Cognos import3 table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) (Created page with "<onlyinclude>'''{{PAGENAME}}''' is an administrative-only, temporary table in CCMDB.mdb. It contains the data provided by the Cognos EPR Report during processing of th...") |
Ttenbergen (talk | contribs) |
||
Line 2: | Line 2: | ||
== Data Structure == | == Data Structure == | ||
=== ClientVisitGUID === | === [[ClientVisitGUID field]]=== | ||
=== Demographics === | === Demographics === |
Latest revision as of 15:36, 2022 August 25
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: |