Cognos2 OneTime table
Jump to navigation
Jump to search
Cognos2 OneTime table contains the parts of the Cognos EPR Report that are only needed once per patient visit. It is populated by Function CognosImport.
Data Structure
field | type | description |
---|---|---|
ClientVisitGUID | Text(20) | unique visit id |
ClientGUID | Text(16) | unique visit id |
HospitalMRN | Text(20) | xx |
hosp | Text | xx |
FirstName | Text | xx |
LastName | Text | xx |
Gender | Text | xx |
Chart | Text | xx |
LastTwo | Text | xx |
PHIN | Text | xx |
DateOfBirth | Date/Time | xx |
Prov | Text | xx |
EmergencyDepartment | Text | xx |
ReferringLocation | Text | xx |
HospEntryDtm | Date/Time | xx |
EDRegistrationDtm | Date/Time | xx |
Visit_Admit_DtTm | Date/Time | xx |
IPAdmitDtm | Date/Time | xx |
EDDischargeDtm | Date/Time | xx |
IPDischargeLocation | Text | xx |
IPDischargeDisposition | Text | xx |
IPDischargeDtm | Date/Time | xx |
HospDischargeDtm | Date/Time | xx |
Related articles
Related articles: |