Cognos2 OneTime table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
| (3 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
{{PAGENAME}} contains the parts of the [[Cognos EPR Report]] that are only needed once per patient visit. It is populated by [[ | {{PAGENAME}} contains the parts of the [[Cognos EPR Report]] that are only needed once per patient visit. It is populated by [[Function CognosImport]]. | ||
== Data Structure == | == Data Structure == | ||
| Line 6: | Line 6: | ||
! field !! type !! description | ! field !! type !! description | ||
|- | |- | ||
|| '''HospitalMRN''' || Text || xx | || '''[[ClientVisitGUID field|ClientVisitGUID]] ''' || Text(20) || unique visit id | ||
|- | |||
|| '''[[ClientGUID field|ClientGUID ]] ''' || Text(16) || unique visit id | |||
|- | |||
|| '''HospitalMRN''' || Text(20) || xx | |||
|- | |- | ||
|| '''hosp''' || Text || xx | || '''hosp''' || Text || xx | ||
Latest revision as of 14:38, 2022 August 25
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: |