Skip to main content
Skip table of contents


This is a child table of Students table that stores student's addresses.

Column Name


Data Type


ID22.7.1Number(10,0)Primary Key




DCID of the Students table.
ADDRESSFORMAT22.7.1 VARCHAR2(50 CHAR)  The format of address
ADDRESSTYPE22.7.1VARCHAR2(50 CHAR)  The type of address
CITY22.7.1VARCHAR2(60 CHAR)The city part of the address
COUNTRY22.7.1VARCHAR2(60 CHAR)The country code of the address
EFFECTIVEDATE22.7.1DATEThe date the address is in effect
EXPIRYDATE22.7.1DATEThe date the address expires

The date the address is no longer in effect. The expiry date is derived taking into account this value.

LATITUDE22.7.1NUMBER(25,10)  The Latitude of the Student Address. Latitude values are expected in decimal format and bounded by +/- 90.

The Longitude of the Student Address. Longitude values are expected in decimal format and bounded by +/- 180.

POSTALCODE22.7.1VARCHAR2(15 CHAR)  The postal or zip code of the address
STATEPROVINCE22.7.1VARCHAR2(20 CHAR)The state or province code of the address
STREET22.7.1VARCHAR2(140 CHAR) The street part of the address
REFID22.7.1NUMBER(11)   The unique identifier for the phone record
ORGCODE22.7.1NUMBER(11)   The organization code to submit the address request to PASI
WhoCreated22.7.1Varchar2(100)The name of the person who created the record. Defaults to the user.
WhenCreated22.7.1Timestamp(6)The date and time the record was created. Defaults to system date.
WhoModified22.7.1Varchar2(100)The name of the person who modified the record. Defaults to the user.
WhenModified22.7.1Timestamp(6)The date and time the record was modified. Defaults to system date.
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.