HealthVaccine (ver6.1.0)
Detailed information about a vaccine.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
DisplayOrder | 6.1.0 | Number(10) | Order to display immunizations. |
HealthVaccineID | 6.1.0 | Number(19) | Unique identifier for this table. Required. |
IsMandatory | 6.1.0 | Number(1) | Is True (1) when this vaccine is mandatory. Defaults to 0. |
IsRulesReady | 6.1.0 | Number(1) | Is True (1) when the rules have been defined for this vaccine. Defaults to 0. |
IsUsedByRuleEngine | 6.1.0 | Number(1) | Is True (1) when this vaccine is evaluated by rules engine. Defaults to 0. |
NumberOfDoses | 6.1.0 | Number(10) | The number for doses typical for this vaccine. Required. |
PSGUID | 7.8.0 | Varchar2(50) | If used, a unique identifier for the row. Currently applicable to multi-tenant, Schoolnet, and Pearson SuccessNet/Pearson SuccessNet Plus. |
StateOfRecord | 6.1.0 | Varchar2(30) | The current state of this record. Valid values: Active or Inactive. Required. |
StateReportCode | 6.1.0 | Varchar2(30) | The state report code, used for reporting purposes. |
StateReportName | 6.1.0 | Varchar2(50) | The state report name, used for reporting purposes. |
VaccineCode | 6.1.0 | Varchar2(30) | The vaccine code. Required. |
VaccineDesc | 6.1.0 | Varchar2(512) | The vaccine description. |
VaccineName | 6.1.0 | Varchar2(50) | The vaccine name. Required. |
WhenCreated | 6.1.0 | Timestamp(6) | The date and time the record was created. Defaults to system date. |
WhenModified | 6.1.0 | Timestamp(6) | The date and time the record was modified. Defaults to system date. |
WhoCreated | 6.1.0 | Varchar2(100) | The name of the person who create the record. Defaults to user. |
WhoModified | 6.1.0 | Varchar2(100) | The name of person who modified the record. Defaults to user. |