Service tmp entry: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
Line 58: | Line 58: | ||
==== Item - Special instruction for HSC Critical Care ==== | ==== Item - 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... | ||
{{Discuss | {{Discuss | | ||
* When should the new options be used rather than the other service entries for HSC? | * 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 | **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 | ||
Line 69: | Line 69: | ||
**::: - --[[User:JMojica|JMojica]] 14:18, 2021 April 6 (CDT) | **::: - --[[User:JMojica|JMojica]] 14:18, 2021 April 6 (CDT) | ||
* if you mean [[S Cognos Services table]] then I am not sure we really need to add them there... that is the list of services that come in from Cognos, and these don't come in from Cognos. Actually, what we would need to do is make sure we remove the ambiguous items that came via Cognos into the s_tmp table that we don't want people to use any longer, so that people are forced to instead use our made up ...SICU and ...MICU ones. Julie and Tina might need to discuss this in our questions meeting on Thursday. | * if you mean [[S Cognos Services table]] then I am not sure we really need to add them there... that is the list of services that come in from Cognos, and these don't come in from Cognos. Actually, what we would need to do is make sure we remove the ambiguous items that came via Cognos into the s_tmp table that we don't want people to use any longer, so that people are forced to instead use our made up ...SICU and ...MICU ones. Julie and Tina might need to discuss this in our questions meeting on Thursday. | ||
***** Are we using the new options for all HSC CC now, or are we still entering some Services as per Cognos? [[User:Ttenbergen|Ttenbergen]] 15:27, 2021 April 15 (CDT) | |||
}} | }} | ||
Revision as of 15:27, 2021 April 15
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 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 patient 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
- date: Service Start DtTm date as per collector best estimate
- time: Service Start DtTm time as per collector best estimate
- the first Service Start DtTm must be the same as Accept DtTm, if that field is required to be filled for this profile
- the Service may start after the first Boarding Loc, since a patient may well already be in a location when a service takes over
- Enter the Service Start DtTm in the Patient Viewer Tab Cognos ADT2; you can click on this DtTm to automatically populate it into the Accept_DtTm field
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 ID date and time for the Service tmp entry as it is clearly marked in the EPR.
|
When does collection start?
see
Item - Special instruction for HSC Critical Care
There are two extra options "HSC Critical Care - MICU" and "HSC Critical Care - SICU" that should be used...
|
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)
Data Use
Critical care and Medicine programs want to know this to better understand patient flow and bed utilization.