| Destination Field | Source field | Logic | Comment field |
|---|---|---|---|
| note_id | id postop_clindoc_created_datetime |
Autogenerated running id by ascending order of time and id |
|
| person_id | anon_case_no | Joined with PERSON.PERSON_SOURCE_VALUE for PERSON.PERSON_ID | |
| note_date | postop_clindoc_created_datetime | ||
| note_datetime | postop_clindoc_created_datetime | ||
| note_type_concept_id | 32879 for Registry | ||
| note_class_concept_id | postop_clindoc_item_description | Need mapping table from vocab team | |
| note_title | |||
| note_text | postop_clindoc_value_text | ||
| encoding_concept_id | UTF-8 -> 32678, Other (ASCII) -> 0 | ||
| language_concept_id | 4180186 for English language | ||
| provider_id | |||
| visit_occurrence_id | session_id | ||
| visit_detail_id | |||
| note_source_value | postop_clindoc_item_description | ||
| note_event_id | |||
| note_event_field_concept_id |