dbo.SXAAMMSPQuestionnaireHistory 
Default Table Name  SXAAMMSPQuestionnaireHistory 
Definition  Stores the MSP Questionnaire History values 

dbo.SXAAMMSPQuestionnaireHistory Columns 
ColumnName  Domain  Datatype  NULL  Definition 
SiteID    smallint  NO  Identifies the unique distributed database ID where the row was inserted. Distributed databases are no longer supported so this column is deprecated. 
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. 
TouchedWhen    datetime  NO  The date and time that the row was last updated and will be 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. 
CreatedWhen    datetime  NO  The date and time that the row was created and will be based on the Enterprise time zone. 
IsActive    bit  NO  Everything Same as Existing SXAAMMSPQuestionnaire Table 
MSPQuestionnaireID(PK)    bigint  NO  Everything Same as Existing SXAAMMSPQuestionnaire Table 
ClientGUID    HVCIDdt  NO  Everything Same as Existing SXAAMMSPQuestionnaire Table 
VisitGUID    HVCIDdt  NO  Everything Same as Existing SXAAMMSPQuestionnaire Table 
VisitTypeGUID    HVCIDdt  NO  Everything Same as Existing SXAAMMSPQuestionnaire Table 
VisitServiceGUID    HVCIDdt  YES  Everything Same as Existing SXAAMMSPQuestionnaire Table 
IsWorkRelated    tinyint  NO  Indicates if the problem reported is work related 
IsThirdPartyLiable    tinyint  NO  Everything Same as Existing SXAAMMSPQuestionnaire Table 
IllnessInjuryInceptionDtm    datetime  YES  Enterprise TimeZone - Everything Same as Existing SXAAMMSPQuestionnaire Table 
FRPContractGUID    HVCIDdt  YES  Everything Same as Existing SXAAMMSPQuestionnaire Table 
EmployerID    int  YES  Everything Same as Existing SXAAMMSPQuestionnaire Table 
IsReceivingBlackLungBenefits    tinyint  NO  Everything Same as Existing SXAAMMSPQuestionnaire Table 
BlackLungBenefitsInceptionDtm    datetime  YES  Enterprise TimeZone - Everything Same as Existing SXAAMMSPQuestionnaire Table 
IsGovProgramPayer    tinyint  NO  Everything Same as Existing SXAAMMSPQuestionnaire Table 
IsDeptOfVeteranAffairsPayer    tinyint  NO  Everything Same as Existing SXAAMMSPQuestionnaire Table 
MedicareEntitlementType    int  YES  Everything Same as Existing SXAAMMSPQuestionnaire Table 
IsMedicareSecondaryPayer    bit  NO  Everything Same as Existing SXAAMMSPQuestionnaire Table 
IsCurrentlyEmployed    tinyint  NO  Everything Same as Existing SXAAMMSPQuestionnaire Table 
CurrentEmployerID    int  YES  Everything Same as Existing SXAAMMSPQuestionnaire Table 
RetirementDtm    datetime  YES  PHI: Enterprise TimeZone - Everything Same as Existing SXAAMMSPQuestionnaire Table 
IsAlternateCurrentlyEmployed    tinyint  NO  Everything Same as Existing SXAAMMSPQuestionnaire Table 
AlternateCurrentEmployerID    int  YES  Everything Same as Existing SXAAMMSPQuestionnaire Table 
AlternateRetirementDtm    datetime  YES  PHI: Enterprise TimeZone - Everything Same as Existing SXAAMMSPQuestionnaire Table 
IsGHPCoverageAvailable    tinyint  NO  Everything Same as Existing SXAAMMSPQuestionnaire Table 
DoesGHPEmployerEmploy20    tinyint  NO  Everything Same as Existing SXAAMMSPQuestionnaire Table 
DoesGHPEmployerEmploy100    tinyint  NO  Everything Same as Existing SXAAMMSPQuestionnaire Table 
GHPContractGUID    HVCIDdt  YES  Everything Same as Existing SXAAMMSPQuestionnaire Table 
IsKidneyTransplantRecipient    tinyint  NO  Everything Same as Existing SXAAMMSPQuestionnaire Table 
KidneyTransplantDtm    datetime  YES  Enterprise TimeZone - Everything Same as Existing SXAAMMSPQuestionnaire Table 
IsUndergoingDialysis    tinyint  NO  Everything Same as Existing SXAAMMSPQuestionnaire Table 
DialysisInceptionDtm    datetime  YES  Enterprise TimeZone - Everything Same as Existing SXAAMMSPQuestionnaire Table 
SelfDialysisTrainingDtm    datetime  YES  Enterprise TimeZone - Everything Same as Existing SXAAMMSPQuestionnaire Table 
IsWithin30MonthCoordinationPeriod    tinyint  NO  Everything Same as Existing SXAAMMSPQuestionnaire Table 
IsEntitlementComboESRDAndOne    tinyint  NO  Everything Same as Existing SXAAMMSPQuestionnaire Table 
WasInitialEntitlementESRD    tinyint  NO  Everything Same as Existing SXAAMMSPQuestionnaire Table 
DoesMSPProvisionApply    tinyint  NO  Everything Same as Existing SXAAMMSPQuestionnaire Table 
MSrepl_tran_version    uniqueidentifier  YES  Optimistic lock identifier. 
IsWCMSAProgram    tinyint  YES  Everything Same as Existing SXAAMMSPQuestionnaire Table 
COBDtm    datetime  YES  Enterprise TimeZone - Everything Same as Existing SXAAMMSPQuestionnaire Table 
CompletedWhen    datetime  YES  Enterprise TimeZone - Everything Same as Existing SXAAMMSPQuestionnaire Table 
CompletedBy    varchar(50)  YES  PHI: Everything Same as Existing SXAAMMSPQuestionnaire Table 
InfoXML    xml  YES  Stores extended information related to the MSPQuestionaire 
MovedIntoHistoryDtm    datetime  NO  Enterprise TimeZone - Date When the record was Moved into History 
IsSpouseCurrentlyEmployed    tinyint  NO  Stores if the Spouse is Employed 
SpouseCurrentEmployerID    int  YES  Stores Spouse Employer ID 
SpouseRetirementDtm    datetime  YES  Enterprise TimeZone - Stores Spouse Retirement Date 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 
HasPatientDeclinedToAnswer    bit  NO  column will store if Patient Declined To Answer MSP Questionnaire or not 

dbo.SXAAMMSPQuestionnaireHistory Primary and Unique Keys 
Key Name  Key Type  Keys 
SXAAMMSPQuestionnaireHistoryPK  PrimaryKey  MSPQuestionnaireID