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. |
AbstractVisitDetailID |
Definition | Auto generated unique primary key value. |
ClientVisitGUID |
Definition | Visit ID from AM |
InsZipCode |
Definition | PHI: Zip code of insurance company |
AdmitTypeID |
Definition | Admit type from AM |
IsAdmitThroughER |
Definition | Is visit admit through ER |
AdmitSourceId |
Definition | Admit source From AM |
IsReAdmitWithin30Days |
Definition | This indicates whether the patient was readmitted within 30 days. |
ReAdmissionCount |
Definition | Number of Readmission count |
DischargeLocationGUID |
Definition | Foreign key to CV3DischargeLocation |
DischargeDispositionGUID |
Definition | Foreign key to CV3DischargeDisposition |
DischargeConditionID |
Definition | Foreign key to SXAAMDischargeCondition |
IsAutopsy |
Definition | Is Autopsy done or not |
IsMedicalExaminerAssigned |
Definition | Medical Examiner assigned or not |
PostOPOR |
Definition | Post OP/ OR |
IsUnder48Hrs |
Definition | This indicates whether the visit is within 48 hrs. of previous visit. |
PrimaryORPhysicianID |
Definition | FK to cv3careprovider |
AdmittingDiagnosisCode |
Definition | Admitting diagnosis Code |
NewBornbabyWeight |
Definition | Stores New born baby weight |
MothersMRN |
Definition | PHI: MRN of mother |
AGAR1Min |
Definition | This is a numeric field which is filled in case of new born baby. |
AGAR5MIN |
Definition | This is a numeric field which is filled in case of new born baby. |
AbstractStatusID |
Definition | A foreign key to the AbstractStatusID column in the SXARCMAbstractStatus table. |
AbstractCompletedBY |
Definition | User who has completed the abstract. |
AbstractStateCodeID |
Definition | A foreign key to the AbstractStateCodeID column in the SXARCMAbstractStateCode table. |
AbstractCompletedUTC |
Definition | Abstract Completed Date |
CauseOfDeath |
Definition | PHI: Free text describing cause of death |
ReleaseForBillingUTC |
Definition | Billing Release Date |
AdmitWeight |
Definition | Stores Admit weight |
DischargeWeight |
Definition | Stores Discharge weight |
BirthFacility |
Definition | Foreign key to cv3location for facility |
GestationalWeek |
Definition | Number of Gestational Weeks |
GestationalDay |
Definition | Number of Gestational days |
DayOnVentilator |
Definition | Number of days on ventilator |
DayOnHyperalimentation |
Definition | Number of days in hyperpigmentation |
DayOnECMO |
Definition | Days on ECMO |
AGAR10MIN |
Definition | This is a numeric field which is filled in case of new born baby |
AbstractReleaseBy |
Definition | User who has Released abstract for billing |
AttendPhysicianID |
Definition | Attending Physician |
AdmitPhysicianID |
Definition | Admitting Physician |
ReferringPhysicianID |
Definition | Referring Physician |
ReferringAgencyID |
Definition | Referring Agency |
SurgeonPhysicianID |
Definition | Surgeon Physician |
MappedAdmittingDiagnosisCode |
Definition | Admitting diagnosis Code |
IsCodedICD10 |
Definition | Flag to identify that Diagnosis code is for ICD10 or not |
IsOrphanDiagnosisICD10Code |
Definition | Flag indicated that ICD10 code is orphan and we do not have any ICD9 Mapping for it |
CustomTileData |
Definition | PHI: XMl which will contain data mapped with UDDI fields |
AdmittingDiagnosisCode10 |
Definition | Store Admitting diagnosis code for ICD10 |
MSReplrowguid |
Definition | Unique GUID used to support merge replication. |
IsBulkCoded |
Definition | Is Bulk Coded |