S_NC_TEACHER_LICENSE_AREA (ver 13.6.0)
This table is an extension of the Users table and stores teacher license information.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| HQ_LAST_MODIFIED | 13.6.0 | DATE | |
| ID | 13.6.0 | NUMBER(10,0) | Primary key. |
| LAST_MODIFIED | 13.6.0 | DATE | |
| LICENSE_AREA_CODE | 13.6.0 | VARCHAR2(5) | |
| LICENSE_AREA_EFFECTIVE_DATE | 13.6.0 | DATE | |
| LICENSE_AREA_EXPERIENCE_NUMBER | 13.6.0 | NUMBER(11,0) | |
| LICENSE_AREA_HQ_CODE | 13.6.0 | VARCHAR2(2) | |
| LICENSE_AREA_NEW_EXP_NUMBER | 13.6.0 | NUMBER(11,0) | |
| LICENSE_CLASS_LEVEL_CODE | 13.6.0 | VARCHAR2(3) | |
| LICENSE_PROGRAM_BASIS_CODE | 13.6.0 | VARCHAR2(1) | |
| LICENSE_PROGRAM_STATUS_CODE | 13.6.0 | VARCHAR2(1) | |
| TEACHER_SSN | 13.6.0 | NUMBER(11,0) | The teacher's social security number. |
| USERSDCID | 13.6.0 | NUMBER(10,0) | Foreign key to link to the users table. |