Service tmp entry: Difference between revisions
Line 34: | Line 34: | ||
{{Discuss | who = JALT | question = | {{Discuss | who = JALT | question = | ||
* If first service Start Dttm is before the Cognos [[Visit Admit DtTm]], should the first Service Start Dttm be made the same as the Cognos [[Visit Admit DtTm]] or keep the former DtTm? - --[[User:JMojica|JMojica]] 15:29, 2023 October 10 (CDT) | * If first service Start Dttm is before the Cognos [[Visit Admit DtTm]], should the first Service Start Dttm be made the same as the Cognos [[Visit Admit DtTm]] or keep the former DtTm? - --[[User:JMojica|JMojica]] 15:29, 2023 October 10 (CDT) | ||
* I would suggest that it should be the same as the COGNOS Visit admit dttm [[User:Lkaita|Lisa Kaita]] 14:57, 2023 October 11 (CDT) }} | * I would suggest that it should be the same as the COGNOS Visit admit dttm [[User:Lkaita|Lisa Kaita]] 14:57, 2023 October 11 (CDT) | ||
** I agree. --[[User:JMojica|JMojica]] 15:40, 2023 October 11 (CDT) | |||
}} | |||
==== Code Blue ==== | ==== Code Blue ==== |
Revision as of 15:40, 2023 October 11
Projects | |
Active?: | active |
Program: | CC and Med |
Requestor: | internal |
Collection start: | 2020-10-15 |
Collection end: |
This data encodes which service is taking care of a patient. See Definition of a Critical Care Laptop Admission / Definition of a Medicine Laptop Admission for info on when a new profile should be started.
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 an additional entry for service only if the service changes during their stay.
Example: |
|
- Use tmp fields:
- project: Service
- item: no service entered is added by default to each new profile entered
- change this to the applicable service; this will be the service as listed in the Cognos Report Integrator tools (see s_Cognos_Services table for a list of applicable services).
- select the appropriate service from the dropdown list
DtTm to use
- Edit the Service Start DtTm in the Patient Viewer Tab Cognos ADT2
- value is initially entered in CSS as per Using Cognos2 to keep track of patients
- once patient is discharged, set as per Definition of a Critical Care Laptop Admission or Definition of a Medicine Laptop Admission; except if within 30 min of time in Cognos, use Cognos time
- at this point also update the first Boarding Loc DtTm as per DtTm for First Boarding Loc and First Service
|
Code Blue
See Definition_of_a_Critical_Care_Laptop_Admission#From_Code_Blue for when a profile should start in case of a code blue.
Specifically for STB Critical Care
Special rules apply to STB CICU Admissions start at Arrive DtTm
- at StB, the Service tmp date and time for ICU patients coming from ER is taken from the orders. If the time is written after the patient has already arrived to the ICU, the Service tmp date and time is the same time as the Boarding Loc time
- if the patient is coming from the Cath Lab, or the OR, the time is obtained from the ICU flowsheet
Direct Admissions/Transfers
For patients who have been accepted from another hospital but have a wait time in ER (who used to be called Direct Admissions/Parked in ER), use the Visit Admit DtTm shown in Patient Viewer Tab Cognos ADT2. You can use the "VA" button to fill it in.
Which service to use when several are listed for the same timeframe
Use what you know to be correct from chart and your knowledge of your hospital.
Data Integrity Checks (automatic list)
App | Status | |
---|---|---|
Query check minimal data set incomplete | CCMDB.accdb | implemented |
Query check tmp service or location duplicate | CCMDB.accdb | implemented |
Query check tmp service and program consistency | CCMDB.accdb | implemented |
Query check tmp Service and Boarding Loc during admission timeframe | CCMDB.accdb | implemented |
Query check CCI TISS NrDays GT LOS | CCMDB.accdb | implemented |
Query check CCI TISS NrDays LT LOS | CCMDB.accdb | implemented |
Query check tmp Boarding Loc Service first same | CCMDB.accdb | implemented |
Query check CCI vs LOS count days component | CCMDB.accdb | implemented |
Query check CCI vs LOS count days picklist | CCMDB.accdb | implemented |
Query check no consecutive same BL or Service | CCMDB.accdb | implemented |
Query check ICD10 date | CCMDB.accdb | implemented |
Query check CCI Date | CCMDB.accdb | implemented |
Query s tmp Boarding Loc date item | CCMDB.accdb | implemented |
Check duplicate patient | CCMDB.accdb | implemented |
Query check CCI TISS Pharm Vasoactive | CCMDB.accdb | implemented |
Query check tmp 2 BL TR S same tm | CCMDB.accdb | implemented |
Data Use
This data is used to facilitate Using Cognos2 to keep track of patients.
Legacy / Background
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. We initially planned to change to a single profile per program collection mode, but then gradually reverted to a single profile per service for all critical care profiles.