Service tmp entry: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
Line 33: Line 33:
==== Special instruction for HSC Critical Care ====
==== Special instruction for HSC Critical Care ====
There are two extra options "HSC Critical Care - MICU" and "HSC Critical Care - SICU" that should be used...  
There are two extra options "HSC Critical Care - MICU" and "HSC Critical Care - SICU" that should be used...  
{{DiscussTask | When should the new options be used rather than the other service entries for HSC? }}
{{DiscussTask | When should the new options be used rather than the other service entries for HSC?
*if I understand it correctly, when the list of these services appear in Cognos, since they do not map well to MICU or SICU, the DC must specified which service is appropriate : MICU or SICU.  In reporting, I need to separate the data belonging to MICU and SICU service.  If you would like to add "HSC Critical Care - MICU" and "HSC Critical Care - SICU", we need to add them to s_Cognos_Services.xlsx
**HSC Critical Care / Adult General
**HSC Critical Care / Amputee
**HSC Critical Care / General
**HSC Critical Care / Intensive Care
**HSC Critical Care / Obstetrics
**HSC Critical Care / Oncology
 
- --[[User:JMojica|JMojica]] 14:18, 2021 April 6 (CDT)}}


=== Which service to use when several are listed for the same timeframe ===
=== Which service to use when several are listed for the same timeframe ===

Revision as of 14:18, 2021 April 6

Projects
Active?: active
Program: CC and Med
Requestor: internal
Collection start: 2020-10-15
Collection end:

This isn't so much a project as a change to Service/Location collection to allow us to collect more than one Service/Location per patient-program-stay. See Change from Service Location to Service, Boarding Loc and Transfer Ready DtTm tmp entry for why we needed to change to this.

Data Collection Instructions

You can use the "Make Service" button in Patient Viewer Tab Cognos ADT2 to generate and populate these entries.

How to enter this

Add a new entry for service only if the service changes during their stay.

Example:   
  • E.G. patient X is in the ER and is accepted by HSC A medicine on Oct 15,2020@0900, On Oct 17,2020 @1500 HSC H medicine takes over his care
  • in the TMP select Project Service, Item choose HSC A medicine, column E enter Oct 15,2020, Column M enter 0900
  • second entry in TMP would be project Service, Item choose HSC H medicine, Column E enter Oct 17,2020, Column M enter 1500

Special instruction for HSC Critical Care

There are two extra options "HSC Critical Care - MICU" and "HSC Critical Care - SICU" that should be used...

When should the new options be used rather than the other service entries for HSC?

  • if I understand it correctly, when the list of these services appear in Cognos, since they do not map well to MICU or SICU, the DC must specified which service is appropriate : MICU or SICU. In reporting, I need to separate the data belonging to MICU and SICU service. If you would like to add "HSC Critical Care - MICU" and "HSC Critical Care - SICU", we need to add them to s_Cognos_Services.xlsx
    • HSC Critical Care / Adult General
    • HSC Critical Care / Amputee
    • HSC Critical Care / General
    • HSC Critical Care / Intensive Care
    • HSC Critical Care / Obstetrics
    • HSC Critical Care / Oncology
- --JMojica 14:18, 2021 April 6 (CDT)
  • SMW


  • Cargo


  • Categories

Which service to use when several are listed for the same timeframe

Occasionally Cognos may list several services with the same dttm. See Process for bad data in Cognos.

Data Integrity Checks (automatic list)

 AppStatus
Query check CCI vs LOS count days picklistCCMDB.accdbimplemented
Query check tmp 2 BL TR S same tmCCMDB.accdbimplemented
Query check CCI TISS Pharm VasoactiveCCMDB.accdbimplemented
Check duplicate patientCCMDB.accdbimplemented
Query s tmp Boarding Loc date itemCCMDB.accdbimplemented
Query check CCI DateCCMDB.accdbimplemented
Query check ICD10 dateCCMDB.accdbimplemented
Query check no consecutive same BL or ServiceCCMDB.accdbimplemented
Query check minimal data set incompleteCCMDB.accdbimplemented
Query check CCI vs LOS count days componentCCMDB.accdbimplemented
Query check tmp Boarding Loc Service first sameCCMDB.accdbimplemented
Query check CCI TISS NrDays LT LOSCCMDB.accdbimplemented
Query check CCI TISS NrDays GT LOSCCMDB.accdbimplemented
Query check tmp Service and Boarding Loc during admission timeframeCCMDB.accdbimplemented
Query check tmp service and program consistencyCCMDB.accdbimplemented
Query check tmp service or location duplicateCCMDB.accdbimplemented
Query check CCI CXR vs LOSCCMDB.accdbneeds review

Data Use

Critical care and Medicine programs want to know this to better understand patient flow and bed utilization.

SAS Program

Background

Related articles

Related articles: