| Code |
| APT-XXX in DREAM5 | D_Events in DREAM 6 | | idApt | id_event | | tab Appuntamenti | domain = APPOINTMENT | | TipoApt | event_type | | APT-001 | VISIT | | APT-002 | APP_DRUGS | | APT-003 | EXAMS | | APT-004 | APP_MEDI | | APT-005 | APP_VERIFY | | APT-006 | APP_FOOD_INT | | APT-007 | APP_COUNSELLING | | APT-008 | APP_CHECK | | APT-009 | APP_TEST_HIV | | APT-010 | APP_DRUGS_TB | | APT-KAP | APP_KAP | | APT-EXBE1 | APP_CACUM | | APT-E01 | APP_PTVSAMPLE | | APT-E02 | APP_CPNVISIT | | APT-E03 | APP_CCRVISIT | | idAnagrafica | id_person | | | category = 'SAMPLE' | | DataApt | date_apt | | DataEseguito | date_apt_exe | | DataIns | date_start | | StatoApt | event_status | | TipoApt | event_type | | NoteApt | ev_vm1 | | DataAptTime ( for APT-007) | ev_vt1 | | idLinkEffettuato (for APT-KAP) | ev_vt1 | | StatoEsame | ev_vt1 | | usr_INS | usr_ins | | usr_MOD | usr_mod | | usr_DATAMOD | usr_datamod |
For drugs appointment : | APT-002 in DREAM5 | D_Events in DREAM 6 | | idApt | id_event | | tab Appuntamenti | domain = APPOINTMENT | | | event_type = APP_DRUGS | | idAnagrafica | id_person | | DataApt | date_apt | | DataConsegna (DataEseguito) | date_apt_exe | | DataIns | date_start | | StatoApt | event_status | | TipoApt | event_type | | Null | ev_vm1 | | usr_INS | usr_ins | | usr_MOD | usr_mod | | usr_DATAMOD | usr_datamod |
event_type : | event_type | domain | category | dream 5 | Description | | VISIT | APPOINTMENT | VISIT | APT-001 | VISIT | | APP_DRUGS | APPOINTMENT | DRUGS | APT-002 | DRUGS | | EXAMS | APPOINTMENT | SAMPLE | APT-003 | SAMPLE | | APP_MEDI | APPOINTMENT | APP | APT-004 | MEDICATION - not used - | | APP_VERIFY | APPOINTMENT | APP | APT-005 | VERIFY | | APP_FOOD_INT | APPOINTMENT | APP | APT-006 | FOOD INTEGRATION | | APP_COUNSELLING | APPOINTMENT | APP | APT-007 | COUNSELING | | APP_CHECK | APPOINTMENT | VISIT | APT-008 | CHECK | | APP_TEST_HIV | APPOINTMENT | SAMPLE | APT-009 | HIV TEST | | APP_DRUGS_TB | APPOINTMENT | DRUGS | APT-010 | TB DRUGS | | APP_KAP | APPOINTMENT | APP | APT-KAP | KAP | | APP_CACUM | APPOINTMENT | APP | APT-EXBE1 | Visit for CACUM prevention | | APP_PTVSAMPLE | APPOINTMENT | SAMPLE | APT-E01 | PTV - SAMPLE | | APP_CPNVISIT | APPOINTMENT | VISIT | APT-E02 | CPN - VISIT | | APP_CCRVISIT | APPOINTMENT | VISIT | APT-E03 | CCR - VISIT |
|
event_status : | Code | Description |
|---|
| APE-001 | Active | | APE-002 | Executed | | APE-003 | Missed | | APE-004 | End of Asistance |
|
