This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | Last revision Both sides next revision | ||
documentation:next_cdm:visits_microvisits [2017/06/06 17:05] gowtham_rao |
documentation:next_cdm:visits_microvisits [2017/06/06 18:05] gowtham_rao |
||
---|---|---|---|
Line 31: | Line 31: | ||
| visit_detail_id| Yes| integer| A unique identifier for each Person's visit-detail at a healthcare provider.| | | visit_detail_id| Yes| integer| A unique identifier for each Person's visit-detail at a healthcare provider.| | ||
| person_id | Yes | integer | A foreign key identifier to the Person for whom the visit is recorded. The demographic details of that Person are stored in the PERSON table.| | | person_id | Yes | integer | A foreign key identifier to the Person for whom the visit is recorded. The demographic details of that Person are stored in the PERSON table.| | ||
- | | visit_concept_id| Yes | integer | A foreign key that refers to a visit Concept identifier in the Standardized Vocabularies. | | + | | visit_detail_concept_id| Yes | integer | A foreign key that refers to a visit Concept identifier in the Standardized Vocabularies. | |
| <del>visit_start_date</del>| <del>Yes</del> | <del>date </del> | <del>The start date of the visit.</del>| | | <del>visit_start_date</del>| <del>Yes</del> | <del>date </del> | <del>The start date of the visit.</del>| | ||
| visit_start_datetime | Yes | datetime | The date and time of the visit-detail started.| | | visit_start_datetime | Yes | datetime | The date and time of the visit-detail started.| |