Cognos2 Services table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m (→Data Structure) |
Ttenbergen (talk | contribs) m (→Data Structure) |
||
Line 6: | Line 6: | ||
! field !! type !! description | ! field !! type !! description | ||
|- | |- | ||
|| '''HospitalMRN''' || Text || xx | || '''ClientVisitGUID''' || Text(20) || unique visit id | ||
|- | |||
|| '''HospitalMRN''' || Text(20) || xx | |||
|- | |- | ||
|| '''Service''' || Text || xx | || '''Service''' || Text || xx |
Revision as of 15:59, 2020 December 31
Cognos2 Services table contains the services and their start and end dttm from the Cognos EPR Report. It is populated by Sub 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: |