SL Cognos2 Unit exclusions table

SL Cognos2 Unit exclusions table is an administrative-only, temporary table in CCMDB_data.mdb. It contains units that should be hidden in Cognos Report Integrator. It is populated via the "exclude" button in [Cognos Report Integrator]] and EPR Reports Integrator.

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.