Guardian (ver6.2.0)
To store the parent portal guardian account information.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
AccountIdentifier | 6.2.0 | Varchar2(30) | Unique identifier, which identifies a PowerSchool Central Authentication Service (PCAS) account that is associated with a guardian account. Internal number for the associated PCAS_Account.PCAS_accounttoken record. |
| 6.2.0 | Varchar2(256) | No longer used by the application. This field may still be referenced on reports and/or custom pages. | |
FirstName | 12.0.0 | Varchar2(100) | The first name associated to a guardian account. Optional. |
GuardianID | 6.2.0 | Number(19) | Unique identifier for a parent portal guardian account. Indexed. Required. |
| IsPlatformMigrated | 22.10.0 | NUMBER(1,0) | Indicates if record is migrated to Auth0. This is used in Unified User. Non-nullable identifier. 0 - Not Migrated (default value). 1 - Migration pending. 2- Migrated. |
LastName | 12.0.0 | Varchar2(100) | The last name associated to a guardian account. Required. |
MiddleName | 6.2.0 | Varchar2(100) | The middle name associated to a guardian account. |
PSGUID | 7.8.0 | Varchar2(50) | If used, a unique identifier for the row. Currently applicable to multi-tenant, Schoolnet, and Pearson SuccessNet/Pearson SuccessNet Plus. |
| State_GuardianNumber | 7.8.0 | Varchar2(32) | This field is used by State Reporting. It may also be used to integrate with external systems. |
WhenCreated | 6.2.0 | Timestamp(6) | The date and time the record was created. Defaults to system date. |
WhenModified | 6.2.0 | Timestamp(6) | The date and time the record was modified. Defaults to system date. |
WhoCreated | 6.2.0 | Varchar2(305) | The name of the person who created the record. Defaults to user. |
WhoModified | 6.2.0 | Varchar2(305) | The name of person who modified the record. Defaults to user. |