Build |
Definition | 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 |
Definition | 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 |
Definition | 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 |
Definition | 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 |
Definition | 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 |
Definition | Optimistic lock identifier using rowversion datatype. |
StatementVisitInfoId |
Definition | Auto generated unique primary key value. |
StatementArtifactID |
Definition | A foreign key to the StatementArtifactID column in the SXARCMStatementArtifact table. |
ClientId |
Definition | Contains the Client Id for which it was created |
visitId |
Definition | Contains the visit Id for which it was created |
VisitStatus |
Definition | Contains the Visit Status for which it was created |
InternalVisitStatus |
Definition | Contains the Internal Visit Status for which it was created |
ChartGUID |
Definition | Contains the ChartGUID |
AdmitDtm |
Definition | PHI: Contains the Admitted date |
DischargeDtm |
Definition | PHI: Contains the Discharged date |
VisitIDCode |
Definition | Contains the VisitIDCode for which it was created |
CareLevelCode |
Definition | Contains the Care Level Code for which it was created |
VisitTypeCareLevelGUID |
Definition | Contains the VisitTypeCareLevelGUID |
ClientDisplayName |
Definition | PHI: Contains the Client Display Name |
ProviderDisplayName |
Definition | Contains the Provider Display Name |
CurrentLocationGUID |
Definition | Contains the Current Location GUID |
DischargeDisposition |
Definition | Contains the Discharge Disposition |
DischargeLocation |
Definition | Contains the Discharge Location |
Note |
Definition | Contains the Visit Note |
DischargeNote |
Definition | PHI: Contains the Discharge Note |
IsCompleteRegistration |
Definition | Contains the Complete Registration status |
IsShortNoticeAdmit |
Definition | Contains the Short Notice Admit status |
IsPendingDischarge |
Definition | Contains the Pending Discharge status |
ReferringFacility |
Definition | Contains the Referring Facility |
CopaymentDue |
Definition | Contains the Co payment Due of visit |
CopaymentDueSource |
Definition | Contains the Copayment Due Source detail |
DeductibleDue |
Definition | Contains the Deductible Due |
DeductibleDueSource |
Definition | Contains the Deductible Due Source detail |
MammographyCertNum |
Definition | Contains the Mammography Certificate Number |
AdmitSource |
Definition | Visit Admit Source like HMO Referral |
AdmitType |
Definition | Visit Admit Type like Emergency |
DischargeInstruction |
Definition | Reason for Discharge |
DischargeCondition |
Definition | Discharge Condition like recover |
SpecialProgramIndicator |
Definition | Special Program Indicator information |
WorkSheetYear |
Definition | A foreign key to the WorkSheetYear column in the SXARCMStatementArtifact table. |
GuarantorID |
Definition | Contains the Guarantor unique ID |
MSReplrowguid |
Definition | Unique GUID used to support merge replication. |
GroupPracticeID |
Definition | A foreign key to the GroupPracticeID column in the SXAAMGroupPractice table. |
VisittypeDesc |
Definition | store visit type description |