Pre_Mig_Guardian_Details_Bkup (ver12.0.0)
This table holds a static copy of the data from the Guardian table prior to the execution of the Contact Migration. It is for diagnostic purposes only and should not be used for reporting. It will be deleted in a future release.
Note: For internal use only.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
| AccountIdentifier | 12.0.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. |
Bkup_ID | 12.0.0 | Number | Unique identifier assigned by the system. |
| DCID | 12.0.0 | Number(10,0) | DCID for the related Student record. |
| EmailAddress | 12.0.0 | Varchar2(256 | Email address for the Guardian. |
| FirstName | 12.0.0 | Varchar2(50) | First name of the student's Guardian. |
| GuardianID | 12.0.0 | Number(19,0) | Identifier of the Guardian in the Guardian table. |
| GuardianNotificationEmailID | 12.0.0 | Number(19,0) | Identifier of the Guardian's email address from the Guardian's table. |
| GuardianStudentID | 12.0.0 | Number(19,0) | ID for the related Student record. |
| LastName | 12.0.0 | Varchar2(50) | Last name of the student's Guardian. |
| MiddleName | 12.0.0 | Varchar2(30) | Middle name of the student's Guardian. |
| NotificationEmail | 12.0.0 | Varchar2(100) | Password recovery email address for Guardian. |
| PCAS_AccountID | 12.0.0 | Number(19,0) | Guardian's ID in the PCAS_Account table. |
| PCAS_EmailContactID | 12.0.0 | Number(19,0) | Link to PCAS Email for the Guardian |
| WhenCreated | 12.0.0 | Timestamp(6) | The date and time when the record was created. |
| WhenModified | 12.0.0 | Timestamp(6) | The date and time when the record was modified. |
| WhoCreated | 12.0.0 | Varchar2(100) | The name of the person who created the record. |
| WhoModified | 12.0.0 | Varchar2(100) | The name of the person who modified the record. |