dbo.SXAAMVisitRegistration 
Default Table Name  SXAAMVisitRegistration 
Definition  stores modifier id from Modifier table, CPT start and CPT End value. 

dbo.SXAAMVisitRegistration 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. 
Active    bit  NO  Denotes whether the row is active or not, 0 means the row has been soft deleted or deactivated. 
ClientVisitGUID(PK)(FK)    HVCIDdt  NO  Primary key 
ModeOfArrivalID    int  YES  Mode of arrival ID from SXAAMModeOfArrival 
AdmitSourceID    int  YES  Admit source ID from SXAAMAdmitSource 
IDSourceID    int  YES  ID source ID from SXAAMIDSource 
GuarantorID(FK)    bigint  YES  A foreign key to the GuarantorID column in the SXAAMGuarantor table. 
AdmitTypeID    int  YES  Admit type ID from SXAAMAdmitType 
DischargeInstructionID    int  YES  Discharge instruction ID from SXAAMDischargeInstruction 
DischargeConditionID    int  YES  Discharge condition ID from SXAAMDischargeCondition 
DischargeProviderGUID    HVCIDdt  YES  Discharge provider GUID from CV3CareProvider 
DischargeUserGUID    HVCIDdt  YES  Discharge user GUID from CV3User 
LastLocationGUID    HVCIDdt  YES  The GUID of the last location of a visit 
LocationStatusID    int  YES  The status of the last location 
Note    varchar(255)  YES  PHI: A free text note field for the visit information 
DischargeNote    varchar(100)  YES  PHI: A free text note field for the visit discharge information 
IsCompleteRegistration    bit  NO  A flag to show that the user needs to complete the registration 
MSrepl_tran_version    uniqueidentifier  YES  Optimistic lock identifier. 
IsShortNoticeAdmit    bit  NO  Denotes whether the Visit is a Short Notice Admit 
IsPendingDischarge    bit  NO  Visit has pending discharge on file in Global Reg or Basic w/Location Management component installed. 
EDLocationGUID    HVCIDdt  YES  This field will hold the value of the ED structure if this is an ED visit and the ED manger is installed. The value is from CV3Location table 
ExpectedLOS    int  NO  Contains an expected length of stay for the visit 
ReferringFacility    varchar(75)  YES  Character description of the facility from which the patient was transferred 
CopaymentDue    decimal(10, 2)  YES  Stores the amount due for the co-payment 
CopaymentDueSource    varchar(30)  YES  Stores the amount of the co-payment due 
DeductibleDue    decimal(10, 2)  YES  Stores the amount of the deductible due 
DeductibleDueSource    varchar(30)  YES  Stores the source of the deductible due amount 
MammographyCertNum    varchar(25)  YES  Mammography Certification Number 
SpecialProgramIndicatorID(FK)    int  YES  A foreign key to the SpecialProgramIndicatorID column in the SXAAMSpecialProgramIndicator table. 
SourceOfDischarge    int  YES  Source of Visit Discharge 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 
IsAutoReregister    bit  NO  To save IsAutoRegister flag mentioned on visit demographic sceen. if NOT NULL the default value will be '0' 
SourceVisitGUID(FK)    HVCIDdt  YES  A foreign key to the ClientVisitGUID column in the SXAAMVisitRegistration table. 
IsRestrictedBilling    bit  NO  PHI: Indicates if the patient is paying for the entire visit out-of-pocket. 
RestrictedBillingComment    varchar(500)  YES  PHI: User comment for making the visit restricted. 
IsConfidentialVisit    bit  NO  PHI: Indicates if this visit has to be confidential under the HIPAA Privacy Rule that protects the privacy of patient data. 
ConfidentialVisitComment    varchar(500)  YES  PHI: User comment for making the visit confidential. 
GroupPracticeID(FK)    int  YES  A foreign key to the GroupPracticeID column in the SXAAMGroupPractice table. 

dbo.SXAAMVisitRegistration Primary and Unique Keys 
Key Name  Key Type  Keys 
SXAAMVisitRegistrationPK  PrimaryKey  ClientVisitGUID