Cognos import3 table

From CCMDB Wiki

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

  • unique identifier of the visit, seems to be used as prefix by later fields ending in *Chg

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: