Cognos2 OneTime table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
 
(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 [[Sub CognosImport]].  
{{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 15: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: