S_NC_TEACHER_LICENSE (ver 13.6.0)
This table is an extension of the Users table and stores teacher license information.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| ID | 13.6.0 | NUMBER(10,0) | Primary key. |
| LAST_MODIFIED | 13.6.0 | DATE | The date the record was last modified. |
| LICENSE_BEGIN_RENEW_DATE | 13.6.0 | DATE | |
| LICENSE_EFFECTIVE_DATE | 13.6.0 | DATE | |
| LICENSE_END_RENEW_DATE | 13.6.0 | DATE | |
| LICENSE_EXPIRE_DATE | 13.6.0 | DATE | |
| LICENSE_INITIAL_DATE | 13.6.0 | DATE | |
| LICENSE_LAST_ISSUE_DATE | 13.6.0 | DATE | |
| LICENSE_RESCIND_DATE | 13.6.0 | DATE | |
| LICENSE_REVOKE_DATE | 13.6.0 | DATE | |
| 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. |