Cognos import3 table
Cognos import3 table is an administrative-only, temporary table in CCMDB.mdb. It contains the data provided by the Cognos EPR Report during processing of that report. See also Cognos_import3 table.
Data Structure
ClientVisitGUID field
Demographics
- HospitalMRN
- FirstName
- LastName
- Gender
FacilityCode
EmergencyDepartment
PHIN
DateOfBirth
HospEntryDtm
EDRegistrationDtm
EDDischargeDtm
EDDischargeDisposition
ReferringLocation
IPAdmitDtm
IPDischargeDtm
HospDischargeDtm
IPDischargeDisposition
IPDischargeLocation
ServiceCluster
ServiceGroup
ServiceDesc
SubserviceDesc_Current
ADT_ServiceDesc
ADT_SubserviceDesc
Bed_ServiceCluster
Bed_ServiceGroup
Bed_ServiceDesc
ServiceClusterStatusChg
ServiceClusterStartDtm
ServiceClusterEndDtm
ServiceGroupStatusChg
ServiceGroupStartDtm
ServiceGroupEndDtm
ServiceDescStatusChg
ServiceDescStartDtm
ServiceDescEndDtm
SubserviceDescStatusChg
SubserviceDescStartDtm
SubserviceDescEndDtm
AttendingProviderName
AttendingProviderStatusChg
AttendingProviderStartDtm
AttendingProviderEndDtm
AsgnUnit_Current
AsgnBed
ADT_AsgnUnit
- same as #AsgnUnit_Current most of the time, except for some units at STB which use variations of the same name
ADT_AsgnBed
- was always identical to #AsgnBed in the test data
AsgnUnitStatusChg
AsgnUnitStartDtm
AsgnUnitEndDtm
AsgnBedStatusChg
AsgnBedStartDtm
AsgnBedEndDtm
DateValue
DateValue_FromDtm
DateValue_ToDtm
FromDtm
ToDtm
Related articles
Related articles: |