SL Cognos2 Unit exclusions table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
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]].  
<onlyinclude>'''{{PAGENAME}}''' is an administrative-only, temporary table in [[CCMDB_data.mdb]]. It contains units 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 [[Cognos Service Starter]] and [[Patient Viewer Tab Cognos ADT2]].</onlyinclude>


== Data Structure ==
== Data Structure ==

Revision as of 12:26, 2020 November 5

SL Cognos2 Unit exclusions table is an administrative-only, temporary table in CCMDB_data.mdb. It contains units that should be hidden in Cognos2. It is populated via the "exclude" buttons in Cognos Service Starter and Patient Viewer Tab Cognos ADT2.

Data Structure

Field Name Data Type Length
HospitalMRN String 255
Unit String 255
Unit_StartDtTm date
Unit_EndDtTm date

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.

Related articles

Related articles: