SL Cognos2 Service exclusions table: Difference between revisions

(2 intermediate revisions by the same user not shown)

Line 1:

<onlyinclude>'''~~{{PAGENAME}}~~''' is an administrative-only, temporary table in [[CCMDB_data.mdb]]. It contains services that should be hidden in [[Cognos2]].

{{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]]s in [[Cognos2 Service Starter]] and [[Patient Viewer Tab Cognos ADT2]].</onlyinclude>

Line 18:

== 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 ==

Line 25:

[[Category:Cognos2]]

[[Category:Cognos Report Integrator]]

[[Category:SL tables]]

@@ Line 1: / Line 1: @@
-<onlyinclude>'''{{PAGENAME}}''' is an administrative-only, temporary table in [[CCMDB_data.mdb]]. It contains services that should be hidden in [[Cognos2]].
+{{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]]s in [[Cognos2 Service Starter]] and [[Patient Viewer Tab Cognos ADT2]].</onlyinclude>
@@ Line 18: / Line 18: @@
 == 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 ==
@@ Line 25: / Line 25: @@
 [[Category:Cognos2]]
 [[Category:Cognos Report Integrator]]
+[[Category:SL tables]]