S_AL_USR_TeacherCert_C ver 20.10.2.0
This table is a child table extension of the Users table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| USERSDCID | 20.10.2.0 | Number(19,0) | The primary key that relates the extended table back to the Students table. |
| AgencyName | 20.10.2.0 | Varchar2(50) | |
| ALSDE_AppsAccessType | 20.12.1.0 | Varchar2(50) | |
| ALSDE_AppDescription | 20.12.1.0 | Varchar2(50) | |
| ALSDE_AppLevel | 20.12.1.0 | Varchar2(50) | |
| BondedEndDate | 20.12.1.0 | Date | |
| BondedPosition | 20.12.1.0 | Boolean | |
| BondedStartDate | 20.12.1.0 | Date | |
| CertificateLevel | 20.10.2.0 | Varchar2(50) | |
| CertificateType | 20.10.2.0 | Varchar2(50) | |
| CollegesAttended | 20.10.2.0 | Varchar2(100) | |
| College_EndDate | 20.10.2.0 | Date | |
| College_StartDate | 20.10.2.0 | Date | |
| ContractEmployerCity | 20.10.2.0 | Varchar2(50) | |
| ContractEmployerEmpStreet | 20.10.2.0 | Varchar2(50) | |
| ContractEmployerName | 20.10.2.0 | Varchar2(50) | |
| ContractEmployerPhone | 20.10.2.0 | Varchar2(12) | |
| ContractEmployerState | 20.10.2.0 | Varchar2(2) | |
| ContractEmployerZip | 20.10.2.0 | Varchar2(10) | |
| Employer | 20.10.2.0 | Varchar2(150) | The name of the employer. |
| EmpType | 20.10.2.0 | Varchar2(50) | |
| EndDate | 20.10.2.0 | Date | |
| FTE | 20.10.2.0 | Double | |
| GradesTaught | 20.10.2.0 | Varchar2(200) | |
| HireDate | 20.10.2.0 | Date | |
| Position | 20.10.2.0 | Varchar2(50) | |
| SubjectsTaught | 20.10.2.0 | Varchar2(200) | |
| CertificateStatus | 22.2.2.0 | Varchar2(50) | |