Cognos2 Services table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) Created page with "{{PAGENAME}} contains the services and their start and end dttm from the Cognos EPR Report. It is populated by Sub CognosImport. == Data Structure == {| class="wikit..." |
Ttenbergen (talk | contribs) |
||
| (3 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
{{PAGENAME}} contains the services and their start and end dttm from the [[Cognos EPR Report]]. It is populated by [[ | {{PAGENAME}} contains the services and their start and end dttm from the [[Cognos EPR Report]]. It is populated by [[Function CognosImport]]. | ||
== Data Structure == | == Data Structure == | ||
{| class="wikitable sortable" | {| class="wikitable sortable" | ||
|- | |- | ||
! field !! type !! description | |||
|- | |- | ||
|| '''HospitalMRN''' || Text || xx | || '''[[ClientVisitGUID field | ClientVisitGUID]]''' || Text(20) || unique visit id | ||
|- | |||
|| '''HospitalMRN''' || Text(20) || xx | |||
|- | |- | ||
|| '''Service''' || Text || xx | || '''Service''' || Text || xx | ||
| Line 14: | Line 16: | ||
|| '''Service_EndDtTm''' || Date/Time || xx | || '''Service_EndDtTm''' || Date/Time || xx | ||
|} | |} | ||
== Related articles == | == Related articles == | ||
Latest revision as of 14:38, 25 August 2022
Cognos2 Services table contains the services and their start and end dttm from the Cognos EPR Report. It is populated by Function CognosImport.
Data Structure
| field | type | description |
|---|---|---|
| ClientVisitGUID | Text(20) | unique visit id |
| HospitalMRN | Text(20) | xx |
| Service | Text | xx |
| Service_StartDtTm | Date/Time | xx |
| Service_EndDtTm | Date/Time | xx |
Related articles
| Related articles: |