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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
int |
YES |
A foreign key to the GroupPracticeID column in the SXAAMGroupPractice table. |