S_STU_EMAILADDRESS_C
This is a child table of Students table that stores student's email addresses.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| ID | 22.10.3 | Number(19,0) | Primary Key |
STUDENTSDCID | 22.10.3 | Number(19,0) | DCID of the Students table. |
| EMAILADDRESS | 22.10.3 | VARCHAR2(255) | Email address of the student |
| TYPE | 22.10.3 | VARCHAR2(20) | Type of the email address |
| REFID | 22.10.3 | NUMBER(11,0) | RefId |
| ISACTIVE | 22.10.3 | NUMBER(1,0) | True if the email address is set active in PASI |
| ORGCODE | 22.10.3 | NUMBER(11,0) | schoolcode |
| WhoCreated | 22.10.3 | Varchar2(100) | The name of the person who created the record. Defaults to the user. |
| WhenCreated | 22.10.3 | Timestamp(6) | The date and time the record was created. Defaults to system date. |
| WhoModified | 22.10.3 | Varchar2(100) | The name of the person who modified the record. Defaults to the user. |
| WhenModified | 22.7.1 | Timestamp(6) | The date and time the record was modified. Defaults to system date. |