Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ADDRESS_END_DATE	Calendar date when this address becomes inactive.	DATE	SPRADDR	SPRADDR_TO_DATE	NO	NO
ADDRESS_NUMBER	Sequence used to identify different addresses within the same address type.	NUMBER	SPRADDR	SPRADDR_SEQNO	NO	NO
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	NO	NO
ADDRESS_SOURCE_DESC	Description of the address source.	VARCHAR2(255)	STVASRC	STVASRC_DESC	NO	NO
ADDRESS_START_DATE	Calendar date when this address became active.	DATE	SPRADDR	SPRADDR_FROM_DATE	NO	NO
ADDRESS_STATUS_IND	Indicates the address information is active or inactive.	VARCHAR2(1)	SPRADDR	SPRADDR_STATUS_IND	NO	NO
ADDRESS_TAX_ID	The tax identification number for the entity associated with this address.	VARCHAR2(63)	SPRADDR	SPRADDR_GST_TAX_ID	NO	NO
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	NO	NO
ADDRESS_TYPE_DESC	Address type description.	VARCHAR2(255)	STVATYP	STVATYP_DESC	NO	NO
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
CARRIER_ROUTE	Address carrier route.	VARCHAR2(4)	SPRADDR	SPRADDR_CARRIER_ROUTE	NO	NO
CITY	Address city, town or municipality.	VARCHAR2(63)	SPRADDR	SPRADDR_CITY	NO	NO
CORRECTION_DIGIT	Correction digit associated with the address for bar code mailing.	NUMBER	SPRADDR	SPRADDR_CORRECTION_DIGIT	NO	NO
COUNTY	County for this address.	VARCHAR2(63)	SPRADDR	SPRADDR_CNTY_CODE	NO	NO
COUNTY_DESC	County name for the address.	VARCHAR2(255)	STVCNTY	STVCNTY_DESC	NO	NO
DELIVERY_POINT	Delivery point associated with the address for barcode mailings.	NUMBER	SPRADDR	SPRADDR_DELIVERY_POINT	NO	NO
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	NO	NO
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	NO	NO
ENRL_PLANNING_SERVICE_DESC	Enrollment planning service description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
ENTITY_UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER	SPRADDR SPRIDEN	SPRADDR_PIDM SPRIDEN_PIDM	NO NO	NO
FEDERAL_REPORTING_CODE	Government determined code for the reporting state/province codes.	VARCHAR2(5)	STVSTAT	STVSTAT_IPEDS_CDE	NO	NO
GEOGRAPHIC_REGION_COUNT	Count of geographic regions associated with an address record.	NUMBER	FUNCTION	MGKFUNC.F_COUNT_GEOGRAPHIC_REGIONS	NO	NO
HOUSE_NUMBER	House number associated with the persons address.	VARCHAR2(63)	SPRADDR	SPRADDR_HOUSE_NUMBER	NO	NO
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	NO	NO
MAILING_ADDRESS	Mailing address formatted as a typical North American address.	VARCHAR2(438)	FUNCTION	GOKODSF.F_FORMAT_MAILING_ADDRESS	NO	NO
MAILING_ADDRESS_COUNTY	Mailing address formatted as typically, but including the county name.	VARCHAR2(438)	FUNCTION	GOKODSF.F_FORMAT_MAILING_ADDRESS	NO	NO
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA	NO	NO
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA	NO	NO
NAME	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
NATION	Nation/country code associated with the address.	VARCHAR2(63)	SPRADDR	SPRADDR_NATN_CODE	NO	NO
NATION_DESC	Address nation/country description.	VARCHAR2(255)	STVNATN	STVNATN_NATION	NO	NO
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	NO	NO
NATION_ISO_CODE	Three character International Standards Organization (ISO) Code associated with the nation code.	VARCHAR2(3)	STVNATN	STVNATN_SCOD_CODE_ISO	NO	NO
POSTAL_CODE	Address postal code.	VARCHAR2(63)	SPRADDR	SPRADDR_ZIP	NO	NO
PREFERRED_ADDRESS_IND	Indicates whether this active address is the person or entity's preferred address.	VARCHAR2(1)	FUNCTION	GOKODSF.F_PREFERRED_ADDRESS_IND	NO	NO
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
STATE_PROVINCE	State or province associated with this address.	VARCHAR2(63)	SPRADDR	SPRADDR_STAT_CODE	NO	NO
STATE_PROVINCE_DESC	State/province name.	VARCHAR2(255)	STVSTAT	STVSTAT_DESC	NO	NO
STREET_LINE1	First line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE1	NO	NO
STREET_LINE2	Second line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE2	NO	NO
STREET_LINE3	Third line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE3	NO	NO
STREET_LINE4	Fourth line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE4	NO	NO

Ver: 9.2