Cognos2 OneTime table

Cognos2 OneTime table contains the parts of the Cognos EPR Report that are only needed once per patient visit. It is populated by Sub CognosImport.

Data Structure

! field	type	description
HospitalMRN	Text	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