AB_STUDENT_ADDRESS
This table stores Student Address List data - includes addresses other than the preferred mailing address.
Column Name | Version | Data Type | Description |
|---|---|---|---|
AB_Student_AddressID | 13.0.0 | NUMBER(19,0) | Primary Key |
| City | 13.0.0 | Varchar2(60) | The city element of the address. |
| Country | 13.0.0 | Varchar2(60) | The county of residence. |
| Effective_Date | 13.0.0 | TIMESTAMP(6) | The date and time the record was effective. Defaults to system date |
| Expiry_Date | 13.0.0 | TIMESTAMP(6) | The date and time the record expired. Defaults to system date |
| Poastal_Code | 13.0.0 | Varchar2(15) | The postal code element of the address |
| RefID | 13.0.0 | NUMBER(10,0) | Unique system identifier. |
| State_Province | 13.0.0 | Varchar2(20) | The province element of the address. |
| Street | 13.0.0 | Varchar2(140) | The street element (number and name). Usually line one of the address. |
| Address_Type | 13.0.0 | Varchar2(15) | Indicates the type of address. |
| Student_InfoID | 13.0.0 | NUMBER(19,0) | The AB_STUDENT_INFOID from the AB_STUDENT_INFO table. |
| WhoCreated | 13.0.0 | Varchar2(100) | The name of the person who created the record. Defaults to user. |
| WhenCreated | 13.0.0 | TIMESTAMP(6) | The date and time the record was created. Defaults to system date. |
| WhoModified | 13.0.0 | Varchar2(100) | The name of person who modified the record. Defaults to user. |
| WhenModified | 13.0.0 | TIMESTAMP(6) | The date and time the record was modified. Defaults to system date |
| List_Position | 13.0.0 | NUMBER(2,0) | Indicates the position this record appears in the address list in ascending order. |