Skip to main content
Skip table of contents

PersonAddress (ver12.0.0)

is table stores address records for a student and related contacts, such as parents, guardians, etc.

Column Name

Initial Version

Data Type

Description

City

12.0.0

Varchar2(100)

The city element of the address. Optional.

CountryCodeSetID12.0.0Number(16,0)Internal number for the associated CodeSet Country record. Indexed. Required.

GeoCodeLatitude

12.0.0

Number(16,10)

The latitude coordinates for the student's address. Optional.

GeoCodeLongitude12.0.0Number(16,10)The longitude coordinates for the student's address. Optional.
LineTwo12.0.0Varchar2(100)The second line of the address. Indexed with Street and Unit. Optional.

PersonAddressID

12.0.0

Number(16,0)

Unique sequential number generated by the application. Indexed. Required.

PostalCode12.0.0Varchar2(10)The zip code element of the address. Optional.
StatesCodesetID12.0.0Number(16,0)Internal number for the associated CodeSet State record. Indexed. Required.
Street12.0.0Varchar2(100)The street name and number element of the address. Usually line one of the address. Indexed with LineTwo and Unit. Optional.
Unit12.0.0Varchar2(30)The suite or apartment number element of the address. Indexed with Street and LineTwo. Optional.

Verification

24.9.0.0

VARCHAR2(10)

Indicates how the person's address was verified

CountyCodeSetId

24.9.0.0

NUMBER(16)

Internal number for the associated CodeSet County record. Indexed.
IsVerified24.9.0.0

NUMBER(1)

Indicates whether or not the person's address has been verified. Valid values: 1=True, 0=False. Default 1. Optional.

AddressLine3

24.9.0.0Varchar2(100)The third line of the person's address.
AddressLine424.9.0.0Varchar2(100)The fourth line of the person's address.
AddressLine524.9.0.0Varchar2(100)The fifth line of the person's address.
WhenCreated12.0.0Timestamp(6)The date and time the record was created. Defaults to system date. Required.
WhenModified12.0.0

Timestamp(6)

The date and time the record was modified. Defaults to system date. Required.

WhoCreated

12.0.0

Varchar2(100)

The name of the person who created the record. Defaults to user. Required.

WhoModified

12.0.0

Varchar2(100)

The name of person who modified the record. Defaults to user. Required.

JavaScript errors detected

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

If this problem persists, please contact our support.