Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ADDRESS_RULE	Address Rule	Institution profile defined display rule determines which address displays for this person or entity.	VARCHAR2(30)		MGRSDAX	MGRSDAX_INTERNAL_CODE
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	Organization-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)		FUNCTION	GOKODSF.F_GET_DESC
DELIVERY_POINT	Delivery Point	Delivery point associated with the address for barcode mailings.	NUMBER		SPRADDR	SPRADDR_DELIVERY_POINT
ENTITY_UID	Entity UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER		SPBPERS	SPBPERS_PIDM
ID	ID	Identification number assigned to a person that is used externally for all communication and correspondence with the person.	VARCHAR2(63)		SPRIDEN	SPRIDEN_ID
MAILING_ADDRESS	Mailing Address	Mailing address formatted as a typical North American address.	VARCHAR2(503)		FUNCTION	GOKODSF.F_FORMAT_MAILING_ADDRESS
MAILING_ADDRESS_COUNTY	Mailing Address County	Mailing address formatted as a typical but including county name.	VARCHAR2(503)		FUNCTION	GOKODSF.F_FORMAT_MAILING_ADDRESS
MAILING_NAME_ORGANIZATION	Mailing Name Organization	Name to be used for communication and correspondence with the entity.	VARCHAR2(63)		SPRIDEN	SPRIDEN_LAST_NAME
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
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
POSTAL_CODE	Postal Code	Address postal code.	VARCHAR2(63)		SPRADDR	SPRADDR_ZIP
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.0