dbo.SXARCMStatementGuarantorAddressInfo 
Default Table Name  SXARCMStatementGuarantorAddressInfo 
Definition  Table contains Guaranters information for statement. 

dbo.SXARCMStatementGuarantorAddressInfo Columns 
ColumnName  Domain  Datatype  NULL  Definition 
Build    int  NO  Identifies the build number and patch level of the software that inserted/updated this row. The format is the Build number followed by 3 digits for the patch level which is typically 000. The build number is tied to specific versions of the software, e.g. Sunrise 15.3 is Build 5021, Sunrise 16.3 is Build 5503. 
TouchedBy    varchar(50)  NO  Information about the user that last updated the row. This will typically be the UserID (IDCode from CV3User table) and may be prefixed with an environment identifier followed by an underscore, e.g. b96d2bf5_jongmore. 
TouchedWhenUTC    datetimeoffset(3)  NO  The date and time that the row was last updated including the time zone offset from UTC, for example 2015-01-30 04:55:04.372 -05:00. The date and time is based on the Enterprise Time Zone. 
CreatedBy    varchar(50)  NO  Information about the user that created the row. This will typically be the UserID (IDCode from CV3User table) and may be prefixed with an environment identifier followed by an underscore, e.g. b96d2bf5_jongmore. 
CreatedWhenUTC    datetimeoffset(3)  NO  The date and time that the row was created including the time zone offset from UTC, for example 2015-01-30 04:55:04.372 -05:00. The date and time is based on the Enterprise Time Zone. 
MSRowVersion    timestamp  NO  Optimistic lock identifier using rowversion datatype. 
StatementGuarantorAddressInfoId(PK)    bigint  NO  Auto generated unique primary key value. 
StatementArtifactId(FK)    bigint  NO  A foreign key to the StatementArtifactID column in the SXARCMStatementArtifact table. 
GuarantorId    bigint  NO  GUID of the guarantor 
Line1    varchar(64)  YES  PHI: Address line 1 
Line2    varchar(50)  YES  PHI: Address line 2 
Line3    varchar(50)  YES  PHI: Address line 3 
City    varchar(35)  YES  PHI: City 
CountryCode    varchar(30)  YES  PHI: Country 
PostalCode    varchar(15)  YES  PHI: Postal code 
PhoneNumber    varchar(40)  YES  PHI: Phone Number 
AreaCode    varchar(10)  YES  PHI: Area Code 
TypeCode    varchar(15)  YES  Type of Address 
Status    varchar(10)  YES  Status of the address records 
County    varchar(50)  YES  PHI: County 
WorkSheetYear(PK)(FK)    int  NO  A foreign key to the WorkSheetYear column in the SXARCMStatementArtifact table. 
StateCode    varchar(5)  YES  PHI: Stores State abbreviation 
Email    varchar(64)  YES  PHI: Will store Guarantor's Email Address 
State    varchar(30)  YES  PHI: Will store Guarantor's State Name 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 

dbo.SXARCMStatementGuarantorAddressInfo Primary and Unique Keys 
Key Name  Key Type  Keys 
SXARCMStatementGuarantorAddressInfoPK  PrimaryKey  StatementGuarantorAddressInfoId, WorkSheetYear