HealthScreenChngDetail (ver6.1.0)
Used to contain details of what vaccine and dose was changed.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
HealthMainStudRecID | 6.1.0 | Number(19) | Internal ID supported by a foreign key to the HealthMainStudRec table. Required. |
HealthOfficVisitID | 6.1.0 | Number(19) | Internal ID supported by a foreign key to the Office Visit screening table. |
HealthScreenChngDetailID | 6.1.0 | Number(19) | Unique identifier for this table. Required. |
HealthStudChngRsnID | 6.1.0 | Number(19) | Internal ID supported by a foreign key to the HealthStudChngRsn table. Required. |
HealthStudHearingID | 6.1.0 | Number(19) | Internal ID supported by a foreign key to the Hearing screening table. |
HealthStudOralID | 6.1.0 | Number(19) | Internal ID supported by a foreign key to the Oral screening table. |
HealthStudScolioID | 6.1.0 | Number(19) | Internal ID supported by a foreign key to the Scolio screening table. |
| HealthStudSystemID | 21.4.4.0 | Number(19) | Internal ID supported by a foreign key to the System screening table. |
HealthStudTBID | 6.1.0 | Number(19) | Internal ID supported by a foreign key to the TB screening table. |
HealthStudVisionID | 6.1.0 | Number(19) | Internal ID supported by a foreign key to the Vision screening table. |
HealthStudVitalSignsID | 6.1.0 | Number(19) | Internal ID supported by a foreign key to the Vital Signs screening table. |
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. |
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. |
HealthStudLeadID | 20.4.0 | Number(19) | Internal ID supported by a foreign key to the Lead screening table. |