| d_events table |
|
| id_event |
primary key |
| id_person |
patient id (software id) |
| |
|
| domain |
= 'APPOINTMENT' |
| date_start |
date when appointment was taken |
| date_apt |
date of the appointment |
| date_apt_exe |
date when the visit was done |
| category |
= 'VISIT' |
| event_type |
= 'VISIT' (medical visit)
= 'APP_CHECK' (control visit)
= 'APP_TELEVISIT' (remote consultation)
= 'APP_CPNVISIT' (Pre natal visit)
= 'APP_CPPVISIT (Post Partum visit)
= 'APP_CCRVISIT' (Center for Cancer Research visit)
|
| event_status |
appointment status:
APE-001 = Active
APE-002 = Executed
APE-003 = Missed
APE-004 = End of Assistance |
| ev_vm1 |
note (about the appointment, not about the clinical visit) |
| usr_ins |
user who inserted |
| usr_mod |
user who modified |
| usr_datamod |
modify date |
