ERPFields (ver12.0.0)
This extended schema table stores a reference to an employee ID used to identify a staff member in an external Employee Access Center (EAC). The table is created on PowerSchool startup. The presence of a record in this table indicates the staff member has been linked with the EAC system. If linked, the user interface provides protection for the EAC managed fields, and additionally uses ERP_ID and Users_DCID to SSO from PowerSchool to the EAC. For more information, see eFinancePlus+Initial+Integration and PowerSchool API for eFinance.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
ERP_ID | 12.0.0 | Number(11) | Employee identifier in the ERP system. |
Users_DCID | 12.0.0 | Number(10) | The DCID of the teacher in the associated Users record. Required. |
WhenCreated | 12.0.0 | Timestamp(6) | The date and time the record was created. Defaults to system date. |
WhenModified | 12.0.0 | Timestamp(6) | The date and time the record was modified. Defaults to system date. |
WhoCreated | 12.0.0 | Varchar2(100) | The name of the person who created the record. Defaults to user. |
WhoModified | 12.0.0 | Varchar2(100) | The name of person who modified the record. Defaults to user. |