S_TN_SSF_X (ver 17.6.0)
This table is an extension of the SchoolStaff Table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| SchoolStaffDCID | 17.6.0 | Number(10,0) | Primary key. |
| EndorsementType | 17.6.0 | Varchar2(2) | Waiver Course Endorsement Type. |
| GrandfatherCourse | 17.6.0 | Varchar2(2) | Grandfather Course Name. |
| GrandfatherStatus | 17.6.0 | Varchar2(1) | Grandfather Course Status. |
| GrandfatherYear | 17.6.0 | Number(10,0) | Grandfather Course Year. |
| PrevFirstName | 17.6.0 | Varchar2(25) | Staff Member's Previous First Name. |
| PrevLastName | 17.6.0 | Varchar2(35) | Staff Member's Previous Last Name. |
| PrevMiddleName | 17.6.0 | Varchar2(25) | Staff Member's Previous Middle Name. |
| PrevLicenseNumber | 17.6.0 | Varchar2(9) | Staff Member's Previous License Number. |
| PrevSSN | 17.6.0 | Varchar2(11) | Staff Member's Previous SSN Number. |
| WaiverCourse | 17.6.0 | Varchar2(10) | Waiver Course Name. |
| WaiverStatus | 17.6.0 | Varchar2(1) | Waiver Course Status. |
| WaiverYear | 17.6.0 | Number(10,0) | Waiver Course Year. |