Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ADDRESS_END_DATE		Calendar date when this address becomes inactive.	DATE		SPRADDR	SPRADDR_TO_DATE
ADDRESS_SEQ_NO		Sequence used to identify different addresses within the same address type.	NUMBER(2)		SPRADDR	SPRADDR_SEQNO
ADDRESS_SOURCE		The source or means by which this address detail was received (notified by addressee, room assignment, etc.)	VARCHAR2(4)		SPRADDR	SPRADDR_ASRC_CODE
ADDRESS_SOURCE_DESC		Description of the address source.	VARCHAR2(30)		STVASRC	STVASRC_DESC
ADDRESS_START_DATE		Calendar date when this address became active.	DATE		SPRADDR	SPRADDR_FROM_DATE
ADDRESS_STATUS_IND		Indicates the address information is active or inactive.	VARCHAR2(1)		SPRADDR	SPRADDR_STATUS_IND
ADDRESS_TAX_ID		The tax identification number for the entity associated with this address.	VARCHAR2(15)		SPRADDR	SPRADDR_GST_TAX_ID
ADDRESS_TYPE		Type of address for this address record. For example, address types of mailing, temporary summer, billing and permanent.	VARCHAR2(2)		SPRADDR	SPRADDR_ATYP_CODE
ADDRESS_TYPE_DESC		Address type description.	VARCHAR2(30)		STVATYP	STVATYP_DESC
CARRIER_ROUTE		Address carrier route.	VARCHAR2(4)		SPRADDR	SPRADDR_CARRIER_ROUTE
CITY	City	Address city, town or municipality.	VARCHAR2(50)		SPRADDR	SPRADDR_CITY
CORRECTION_DIGIT		Correction digit associated with the address for bar code mailing.	NUMBER(1)		SPRADDR	SPRADDR_CORRECTION_DIGIT
COUNTY_CODE		Address county code.	VARCHAR2(5)		SPRADDR	SPRADDR_CNTY_CODE
COUNTY_DESC		County name for the address.	VARCHAR2(30)		STVCNTY	STVCNTY_DESC
CURRENT_DATE		System current date (sysdate) or date the data was extracted.	DATE		NA	SYSDATE
DELIVERY_POINT		Delivery point associated with the address for barcode mailings.	NUMBER(2)		SPRADDR	SPRADDR_DELIVERY_POINT
DOMAIN_VALUE		Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)		NA	NA
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		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(6)		FUNCTION	F_EPSCCODE
ENRL_PLANNING_SERVICE_DESC		Enrollment planning service description.	VARCHAR2(30)		FUNCTION	GOKODSF.F_GET_DESC
ENTITY_UID		System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER(8)		SPRADDR	SPRADDR_PIDM
HOUSE_NUMBER	House Number	House number associated with the persons address.	VARCHAR2(10)		SPRADDR	SPRADDR_HOUSE_NUMBER
IPEDS_CODE		Government determined code for the reporting state/province codes.	VARCHAR2(5)		STVSTAT	STVSTAT_IPEDS_CDE
MAILING_ADDRESS		Complete address concatenated for mailing purposes in a typical North American format.	VARCHAR2(438)		NA	NA
MAILING_ADDRESS_COUNTY		Complete address concatenated for mailing purposes using the county in place of the state/province field.	VARCHAR2(438)		NA	NA
MIF_DESC		Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)		NA	NA
MIF_VALUE		Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)		NA	NA
NATION		Nation/country code associated with the address.	VARCHAR2(5)		SPRADDR	SPRADDR_NATN_CODE
NATION_DESC		Address nation/country description.	VARCHAR2(30)		STVNATN	STVNATN_NATION
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_SCOD_CODE_ISO		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(30)		SPRADDR	SPRADDR_ZIP
PREFERRED_ADDRESS_IND		Indicates whether this active address is the person or entity's preferred address.	VARCHAR2(1)		FUNCTION	GOKODSF.F_PREFERRED_ADDRESS_IND
STATE_PROVINCE		State or province associated with this address.	VARCHAR2(3)		SPRADDR	SPRADDR_STAT_CODE
STATE_PROVINCE_DESC		State/province name.	VARCHAR2(30)		STVSTAT	STVSTAT_DESC
STREET_LINE1	Street Line 1	First line of the address.	VARCHAR2(75)		SPRADDR	SPRADDR_STREET_LINE1
STREET_LINE2	Street Line 2	Second line of the address.	VARCHAR2(75)		SPRADDR	SPRADDR_STREET_LINE2
STREET_LINE3	Street Line 3	Third line of the address.	VARCHAR2(75)		SPRADDR	SPRADDR_STREET_LINE3
STREET_LINE4	Street Line 4	Fourth line of the address.	VARCHAR2(75)		SPRADDR	SPRADDR_STREET_LINE4
ZONE_VALUE		Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)		NA	NA

Ver: