CCMDB Wiki

SL Cognos2 Service exclusions table: Difference between revisions

Created page with "<onlyinclude>'''{{PAGENAME}}''' is an administrative-only, temporary table in CCMDB_data.mdb. It contains units that should be hidden in Cognos Report Integrator. It..."
 
mNo edit summary
 
(5 intermediate revisions by the same user not shown)
Line 1: Line 1:
<onlyinclude>'''{{PAGENAME}}''' is an administrative-only, temporary table in [[CCMDB_data.mdb]]. It contains units that should be hidden in [[Cognos Report Integrator]].  
{{DISPLAYTITLE:sL_Cognos2_Service_exclusions table}}<onlyinclude>'''sL_Cognos2_Service_exclusions table''' is an administrative-only, temporary table in [[CCMDB_data.mdb]]. It contains services that should be hidden in [[Cognos2]].  
It is populated via the [["exclude" button]] in [Cognos Report Integrator]] and [[EPR Reports Integrator]].</onlyinclude>
It is populated via the [["exclude" button]]s in [[Cognos2 Service Starter]] and [[Patient Viewer Tab Cognos ADT2]].</onlyinclude>
 


== Data Structure ==
== Data Structure ==
Line 11: Line 12:
| Service || String|| 255
| Service || String|| 255
|-
|-
| Service_StartDtTm || String|| 255
| Service_StartDtTm || date ||  
|-
|-
| Service_EndDtTm || String|| 255
| Service_EndDtTm || date ||  
|}
|}


== Background ==
== Background ==
This is a replacement for the old [[SL_EPR_Exclusions table]] - using it in [[Cognos Report Integrator]] because what line would be excluded, and whether to base it on unit or service data, was always unclear. Now there are two tables, [[sL_Cognos2_Unit_exclusions table]] and [[sL_Cognos2_Service_exclusions table]], which will store this in a way that can be cleanly associated to one info point.  
This is a replacement for the old ''SL_EPR_Exclusions table'' - using it in [[Cognos Report Integrator]] because what line would be excluded, and whether to base it on unit or service data, was always unclear. Now there are two tables, [[sL_Cognos2_Unit_exclusions table]] and [[sL_Cognos2_Service_exclusions table]], which will store this in a way that can be cleanly associated to one info point.  


== Related articles ==  
== Related articles ==  
Line 24: Line 25:
[[Category:Cognos2]]
[[Category:Cognos2]]
[[Category:Cognos Report Integrator]]
[[Category:Cognos Report Integrator]]
[[Category:SL tables]]
Retrieved from "https://ccmdb.kuality.ca/index.php?title=SL_Cognos2_Service_exclusions_table"