UsersCoreFields (ver7.7.1)
Schema extension table associated to the Users table. Fields include those that were migrated from PowerSchool custom fields. These fields store general information.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
DOB | 7.9.0 | Varchar2(4000) | Staff date of birth. |
Gender | 7.9.0 | Varchar2(4000) | Staff gender. |
PhotoLastUpdated | 11.0.0 | Varchar2(20) | Date user photo was last updated. String formatted using ISO-8601, "yyyy-mm-ddThh:mm:ssZ". |
| PSCore_Legal_First_Name | 19.4.0 | Varchar2(100) | Staff legal first name. Currently, this field only used by State Reporting. However, it may also be used on any PowerSchool custom page. |
| PSCore_Legal_Gender | 19.4.0 | Varchar2(10) | Staff legal gender. Currently, this field only used by State Reporting. However, it may also be used on any PowerSchool custom page. |
| PSCore_Legal_Last_Name | 19.4.0 | Varchar2(100) | Staff legal last name. Currently, this field only used by State Reporting. However, it may also be used on any PowerSchool custom page. |
| PSCore_Legal_Middle_Name | 19.4.0 | Varchar2(100) | Staff legal middle name. Currently, this field only used by State Reporting. However, it may also be used on any PowerSchool custom page. |
| PSCore_Legal_Suffix | 19.4.0 | Varchar2(10) | Staff legal suffix. Currently, this field only used by State Reporting. However, it may also be used on any PowerSchool custom page. |