S_STU_ADDRESS_C
This is a child table of Students table that stores student's addresses.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| ID | 22.7.1 | Number(10,0) | Primary Key |
STUDENTSDCID | 22.7.1 | Number(10,0) | DCID of the Students table. |
| ADDRESSFORMAT | 22.7.1 | VARCHAR2(50 CHAR) | The format of address |
| ADDRESSTYPE | 22.7.1 | VARCHAR2(50 CHAR) | The type of address |
| CITY | 22.7.1 | VARCHAR2(60 CHAR) | The city part of the address |
| COUNTRY | 22.7.1 | VARCHAR2(60 CHAR) | The country code of the address |
| EFFECTIVEDATE | 22.7.1 | DATE | The date the address is in effect |
| EXPIRYDATE | 22.7.1 | DATE | The date the address expires |
| EXPIRYDATEOVERRIDE | 22.7.1 | DATE | The date the address is no longer in effect. The expiry date is derived taking into account this value. |
| LATITUDE | 22.7.1 | NUMBER(25,10) | The Latitude of the Student Address. Latitude values are expected in decimal format and bounded by +/- 90. |
| LONGITUDE | 22.7.1 | NUMBER(25,10) | The Longitude of the Student Address. Longitude values are expected in decimal format and bounded by +/- 180. |
| POSTALCODE | 22.7.1 | VARCHAR2(15 CHAR) | The postal or zip code of the address |
| STATEPROVINCE | 22.7.1 | VARCHAR2(20 CHAR) | The state or province code of the address |
| STREET | 22.7.1 | VARCHAR2(140 CHAR) | The street part of the address |
| REFID | 22.7.1 | NUMBER(11) | The unique identifier for the phone record |
| ORGCODE | 22.7.1 | NUMBER(11) | The organization code to submit the address request to PASI |
| WhoCreated | 22.7.1 | Varchar2(100) | The name of the person who created the record. Defaults to the user. |
| WhenCreated | 22.7.1 | Timestamp(6) | The date and time the record was created. Defaults to system date. |
| WhoModified | 22.7.1 | 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. |