HealthStudGradeLevel (ver6.1.0)
Used to contain details of who certified a student at a grade level.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
CertificationComment | 6.1.0 | Varchar2(512) | Comment regarding the certification made by the person performing the certification. |
CertificationDate | 6.1.0 | Date | The date the certification for this student in a grade level. |
CertificationFirstName | 6.1.0 | Varchar2(30) | First name of the person making the certification. Required. |
CertificationLastName | 6.1.0 | Varchar2(30) | Last name of the person making the certification. Required. |
CertificationMiddleName | 6.1.0 | Varchar2(30) | Middle name of the person making the certification. |
CertificationStatusLuID | 6.1.0 | Number(19) | Internal ID supported by a foreign key to the Lookup table referencing a CodeType of CertificationStatusCode. |
HealthGradeLevelID | 6.1.0 | Number(19) | Unique identifier for the grade level referenced. Required. |
HealthStudGradeLevelID | 6.1.0 | Number(19) | Unique identifier for this table. 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. |
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. |