AccessTeacher (ver7.0.0)
Used to associate a Teacher record to a PCAS_Account record.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
AccessTeacherID | 7.0.0 | Number(19) | Unique identifier for this table. Required. |
AccountIdentifier | 7.0.0 | Varchar2(32) | An identifier for linking to a record in the PCAS_Account table. |
| IsPlatformMigrated | 22.10.0 | NUMBER(1,0) | Indicates if record is migrated to Auth0. This is used in Unified user. Non-nullable identifier. |
TeachersDCID | 7.0.0 | Number(10) | The DCID of the teacher in the associated Users table (Users.DCID). Required. |
WhenCreated | 7.0.0 | Timestamp(6) | The date and time the record was created. Defaults to system date. |
WhenModified | 7.0.0 | Timestamp(6) | The date and time the record was modified. Defaults to system date. |
WhoCreated | 7.0.0 | Varchar2(100) | The name of the person who created the record. Defaults to user. |
WhoModified | 7.0.0 | Varchar2(100) | The name of the person who modified the record. Defaults to user. |