HealthStudDoseRec (ver6.1.0)
Table to contain the dose records for each student.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
CompliancyStatus | 6.1.0 | Number(1) | Refers to whether the dose was administered correctly. Valid values: 0=Compliant, 1=Non Compliant. Required. |
DateAdministered | 6.1.0 | Date | The date this dose was administered. |
Dose | 6.1.0 | Number(10) | The dose number for this record. Required. |
DoseCompliancyStatement | 6.1.0 | Varchar2(100) | A statement regarding the compliancy of a dose populated by the rules engine. |
| ExcludeComplianceCalc | 21.4.0 | Number(1) | Indicates whether to exclude the dose from Compliance calculation. Valid values: 0=Include in calculation, 1=Exclude from calculation. Required. Default 0. |
HealthImmSourceID | 6.1.0 | Number(19) | Internal ID for the immunization source record to which this record is related. |
HealthStudDoseRecID | 6.1.0 | Number(19) | Unique identifier for this table. Required. |
HealthStudImmRecID | 6.1.0 | Number(19) | Internal ID for the student immunization record to which this record is related. Required. |
| HealthVaccineCVXID | 22.5.1 | Number(16,0) | Internal ID for the HealthVaccineCVX record to which this record is related. |
HealthVaccineID | 6.1.0 | Number(19) | Internal ID for the vaccine record to which this record is related. 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. |
StudentID | 6.1.0 | Number(10) | The internal number for the student with which this health record is associated. 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. |