Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ADDRESS_END_DATE	Address End Date	Calendar date when this address becomes inactive.	DATE	SPRADDR	SPRADDR_TO_DATE
ADDRESS_NUMBER	Address Number	Sequence used to identify different addresses within the same address type.	NUMBER	SPRADDR	SPRADDR_SEQNO
ADDRESS_SOURCE	Address Source	The source or means by which this address detail was received (notified by addressee, room assignment, etc.).	VARCHAR2(63)	SPRADDR	SPRADDR_ASRC_CODE
ADDRESS_SOURCE_DESC	Address Source Description	Description of the address source.	VARCHAR2(255)	STVASRC	STVASRC_DESC
ADDRESS_START_DATE	Address Start Date	Calendar date when this address became active.	DATE	SPRADDR	SPRADDR_FROM_DATE
ADDRESS_STATUS_IND	Address Status Indicator	Indicates the address information is active or inactive.	VARCHAR2(1)	SPRADDR	SPRADDR_STATUS_IND
ADDRESS_TAX_ID	Address Tax ID	The tax identification number for the entity associated with this address.	VARCHAR2(63)	SPRADDR	SPRADDR_GST_TAX_ID
ADDRESS_TYPE	Address Type	Type of address for this address record. For example, address types of mailing, temporary summer, billing and permanent.	VARCHAR2(63)	SPRADDR	SPRADDR_ATYP_CODE
ADDRESS_TYPE_DESC	Address Type Description	Address type description.	VARCHAR2(255)	STVATYP	STVATYP_DESC
ADMINISTRATIVE_GROUP	Administrative Group	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
CARRIER_ROUTE	Carrier Route	Address carrier route.	VARCHAR2(4)	SPRADDR	SPRADDR_CARRIER_ROUTE
CITY	City	Address city, town or municipality.	VARCHAR2(63)	SPRADDR	SPRADDR_CITY
CORRECTION_DIGIT	Correction Digit	Correction digit associated with the address for bar code mailing.	NUMBER	SPRADDR	SPRADDR_CORRECTION_DIGIT
COUNTY	County	County for this address.	VARCHAR2(63)	SPRADDR	SPRADDR_CNTY_CODE
COUNTY_DESC	County Description	County name for the address.	VARCHAR2(255)	STVCNTY	STVCNTY_DESC
DELIVERY_POINT	Delivery Point	Delivery point associated with the address for barcode mailings.	NUMBER	SPRADDR	SPRADDR_DELIVERY_POINT
EDI_EQUIVALENT	Edi Equivalent	EDI equivalent code used for electronic transfer of state or province or nation information. This might be used on transcripts for the person, vendor invoice, etc.	VARCHAR2(2)	STVSTAT	STVSTAT_EDI_EQUIV
ENRL_PLANNING_SERVICE	Enrl Planning Service	Enrollment planning service code based on the student's postal code. Used to provide a standard geographic region code for use in planning and research.	VARCHAR2(63)	FUNCTION	F_EPSCCODE
ENRL_PLANNING_SERVICE_DESC	Enrl Planning Service Description	Enrollment planning service description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
ENTITY_UID	Entity UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER	SPRADDR SPRIDEN	SPRADDR_PIDM SPRIDEN_PIDM
FEDERAL_REPORTING_CODE	Federal Reporting Code	Government determined code for the reporting state/province codes.	VARCHAR2(5)	STVSTAT	STVSTAT_IPEDS_CDE
GEOGRAPHIC_REGION_COUNT	Geographic Region Count	Count of geographic regions associated with an address record.	NUMBER	FUNCTION	MGKFUNC.F_COUNT_GEOGRAPHIC_REGIONS
HOUSE_NUMBER	House Number	House number associated with the persons address.	VARCHAR2(63)	SPRADDR	SPRADDR_HOUSE_NUMBER
ID	ID	Identification number assigned to a person that is used externally for all communication and correspondence with the person.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
MAILING_ADDRESS	Mailing Address	Mailing address formatted as a typical North American address.	VARCHAR2(438)	FUNCTION	GOKODSF.F_FORMAT_MAILING_ADDRESS
MAILING_ADDRESS_COUNTY	Mailing Address County	Mailing address formatted as typically, but including the county name.	VARCHAR2(438)	FUNCTION	GOKODSF.F_FORMAT_MAILING_ADDRESS
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
NAME	Name	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
NATION	Nation	Nation/country code associated with the address.	VARCHAR2(63)	SPRADDR	SPRADDR_NATN_CODE
NATION_DESC	Nation Description	Address nation/country description.	VARCHAR2(255)	STVNATN	STVNATN_NATION
NATION_EDI_EQUIVALENT	Nation Edi Equivalent	EDI equivalent code used for electronic transfer of country information. This might be used on transcripts for the person, vendor invoice, etc.	VARCHAR2(2)	STVNATN	STVNATN_EDI_EQUIV
NATION_ISO_CODE	Nation ISO Code	Three character International Standards Organization (ISO) Code associated with the nation code.	VARCHAR2(3)	STVNATN	STVNATN_SCOD_CODE_ISO
POSTAL_CODE	Postal Code	Address postal code.	VARCHAR2(63)	SPRADDR	SPRADDR_ZIP
PREFERRED_ADDRESS_IND	Preferred Address Indicator	Indicates whether this active address is the person or entity's preferred address.	VARCHAR2(1)	FUNCTION	GOKODSF.F_PREFERRED_ADDRESS_IND
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
STATE_PROVINCE	State Province	State or province associated with this address.	VARCHAR2(63)	SPRADDR	SPRADDR_STAT_CODE
STATE_PROVINCE_DESC	State Province Description	State/province name.	VARCHAR2(255)	STVSTAT	STVSTAT_DESC
STREET_LINE1	Street Line 1	First line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE1
STREET_LINE2	Street Line 2	Second line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE2
STREET_LINE3	Street Line 3	Third line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE3
STREET_LINE4	Street Line 4	Fourth line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE4

Ver: 9.2