HealthVaccineCVXCode (ver22.5.1)
This table contains the selected values from the multi-select drop downs on the Vaccine Management Page.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
CodeSetID | 22.5.1 | Number(19,0) | Foreign key's internal id relating this record to a record in the CodeSet table. Required. Indexed. |
| HealthVaccineCVXCodeID | 22.5.1 | Number(19,0) | Primary key and internal id of the record. Required. |
HealthVaccineID | 22.5.1 | Number(19,0) | Foreign key's internal id relating this record to a record in the HealthVaccine table. Required. Indexed. |
| WhenCreated | 22.5.1 | Timestamp(6) | The date and time the record was last modified. Defaults to system date. |
| WhenModified | 22.5.1 | Timestamp(6) | The date and time the record was created. Defaults to system date. |
| WhoCreated | 22.5.1 | Varchar2(100) | The name of the user who created the record. Defaults to current user. |
| WhoModified | 22.5.1 | Varchar2(100) | The name of the user who last modified the record. Defaults to current user. |