Hospitalization ID: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
 
(2 intermediate revisions by the same user not shown)
Line 11: Line 11:
}}
}}


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.
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. We probably won't start populating it now since the [[ClientVisitGUID field]] serves this purpose.


=== Using ClientVisitGUID from Cognos ===
{{Todo
[[Cognos]] data includes a field ClientVisitGUID, which is the identifier per hospitalization in EPR. We could use that field to populate this field. One advantage would be that ClientVisitGUID remains the same even when other data is corrected for a John Doe. One disadvantage is that not all our profiles are entered from Cognos, and this field would be blank for those that are not. Colletors can't look the field up in EPR, so it would have to come from Cognos data.
| who = Tina
| todo_added = 2022-08-25
| todo_action = 2022-09-25
| question = _CFE_Data_reconsolidate
* once we have some [[ClientVisitGUID field]] data to test we can delete this field, table and page. }}


== Implementation ==
== Implementation ==
Line 22: Line 26:
* add to sending
* add to sending
* add to CSS
* add to CSS
== Log ==
2021-06-17 - added ClientVisitGUID to [[L_Log table]] in [[CCMDB data.mdb]]


== Related articles ==
== Related articles ==

Latest revision as of 14:42, 2022 August 25

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. We probably won't start populating it now since the ClientVisitGUID field serves this purpose.

_CFE_Data_reconsolidate

  • added: 2022-08-25
  • action: 2022-09-25
  • Cargo


  • Categories

Implementation

to do

  • add to CCMDB_data.accdb
  • add to CFE
  • add to sending
  • add to CSS

Related articles

Related articles: