PCAS_EmailContact (ver7.0.0)
Contains the single reliable email account, which the account holder can be reached.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
EmailAddress | 7.0.0 | Varchar2(256) | An email account for the owner of the login account. Defaults to Invalid Email Address. Required. Indexed. |
ExternalIdent | 7.0.0 | Varchar2(32) | An external Identifier. For PS Parent Portal service this represents the internal number for the associated Guardian record. |
PCAS_AccountID | 7.0.0 | Number(19) | Internal number for the associated Required. Indexed. |
PCAS_EmailContactID | 7.0.0 | Number(19) | Unique identifier for this table. Required. Indexed. |
PCAS_ServiceID | 7.0.0 | Number(19) | Internal number for the associated PCAS_Service record. Required. Indexed. |
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 create the record. Defaults to user. |
WhoModified | 7.0.0 | Varchar2(100) | The name of person who modified the record. Defaults to user. |