SL Cognos2 Service exclusions table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
| (4 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
<onlyinclude>''' | {{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 [ | It is populated via the [["exclude" button]]s in [[Cognos2 Service Starter]] and [[Patient Viewer Tab Cognos ADT2]].</onlyinclude> | ||
== Data Structure == | == Data Structure == | ||
| Line 17: | Line 18: | ||
== Background == | == Background == | ||
This is a replacement for the old | 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]] | |||
Latest revision as of 15:44, 31 May 2023
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" buttons in Cognos2 Service Starter and Patient Viewer Tab Cognos ADT2.
Data Structure
| Field Name | Data Type | Length |
|---|---|---|
| HospitalMRN | String | 255 |
| Service | String | 255 |
| Service_StartDtTm | date | |
| Service_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.