Hospitalization ID

From CCMDB Wiki
Revision as of 10:02, 2021 June 10 by Ttenbergen (talk | contribs) (Created page with "{{Data element |field_name=Person_ID |CCMDB_label=N/A |in_table=L Log table, L Person table |data_type=number |datafield_length=long integer |program_collecting=Med and CC |cr...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
Data Element (edit)
Field Name: Person_ID
CCMDB Label: N/A
CCMDB tab: not stated
Table: L Log table, L Person table
Data type: number
Length: long integer
Program: Med and CC
Created/Raw: Created
Start Date: 1988-07-11
End Date: 2300-01-01
Sort Index: 1

Not currently used

  • SMW

Legacy implementation right in the table

  • Cargo


  • Categories
  • Forms


Field was created at same time as Person_ID, but never populated. It would have been hard to populated when first created and we never got around to it, but with Cognos data, we would be able to put the ClientVisitGUID into this field, which is what designates a hospitalization in EPR. One advantage would be that ClientVisitGUID remains the same even when other data is corrected for a John Doe.


Discussion about adding this field.

  • added: no added date
  • action: no action date
  • Cargo


  • Categories

Related articles

Related articles: