Service tmp entry: Difference between revisions

JMojica (talk | contribs)
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?
{{Discuss | who = Julie |
*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
* When should the new options be used rather than the other service entries for HSC?
**HSC Critical Care / Adult General
**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 / Amputee
***HSC Critical Care / Adult General
**HSC Critical Care / General
***HSC Critical Care / Amputee
**HSC Critical Care / Intensive Care
***HSC Critical Care / General
**HSC Critical Care / Obstetrics
***HSC Critical Care / Intensive Care
**HSC Critical Care / Oncology
***HSC Critical Care / Obstetrics
 
***HSC Critical Care / Oncology  
- --[[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.
}}


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