Target Column	Business Definition	Database Data Type	Source Name	Source Column
ADDRESS_RULE	Institution profile defined display rule determines which address displays for this person or entity.	VARCHAR2(30)	MGRSDAX	MGRSDAX_INTERNAL_CODE
ADMINISTRATIVE_GROUP	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
CARRIER_ROUTE	Address carrier route.	VARCHAR2(4)	SPRADDR	SPRADDR_CARRIER_ROUTE
CITY	Address city, town or municipality.	VARCHAR2(63)	SPRADDR	SPRADDR_CITY
CORRECTION_DIGIT	Correction digit associated with the address for bar code mailing.	NUMBER	SPRADDR	SPRADDR_CORRECTION_DIGIT
COUNTY	County for this address.	VARCHAR2(63)	SPRADDR	SPRADDR_CNTY_CODE
COUNTY_DESC	County name for the address.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
DELIVERY_POINT	Delivery point associated with the address for barcode mailings.	NUMBER	SPRADDR	SPRADDR_DELIVERY_POINT
ID	Person's identification number used to access the records associated with the person.	VARCHAR2(63)	SPRIDEN	SPRIDEN_ID
MAILING_FORMAL	Mailing address formatted as a typical North American address with formal name.	VARCHAR2(695)	FUNCTION	F_FORMAT_MAILING_ADDRESS
MAILING_FORMAL_COUNTY	Mailing address formatted as a typical but including county name and formal name.	VARCHAR2(695)	FUNCTION	F_FORMAT_MAILING_ADDRESS
MAILING_INFORMAL	Mailing address formatted as a typical North American address with informal name.	VARCHAR2(695)	FUNCTION	F_FORMAT_MAILING_ADDRESS
MAILING_INFORMAL_COUNTY	Mailing address formatted as a typical but including county name and formal name.	VARCHAR2(695)	FUNCTION	F_FORMAT_MAILING_ADDRESS
MAILING_NAME_FORMAL	Person's formal current full name for a mailing address label.	VARCHAR2(255)	FUNCTION	GOKODSF.F_FORMAT_PREFERRED_NAME
MAILING_NAME_INFORMAL	Person's current informal name for a mailing address label.	VARCHAR2(255)	FUNCTION	GOKODSF.F_FORMAT_PREFERRED_NAME
MAILING_NAME_PREFERRED	Person's preferred name for a mailing address label.	VARCHAR2(255)	FUNCTION	GOKODSF.F_FORMAT_PREFERRED_NAME
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
NATION	Nation/country code associated with the address.	VARCHAR2(63)	SPRADDR	SPRADDR_NATN_CODE
NATION_DESC	Address nation/country description.	VARCHAR2(255)	STVNATN	STVNATN_NATION
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	SPBPERS	SPBPERS_PIDM
POSTAL_CODE	Address postal code.	VARCHAR2(63)	SPRADDR	SPRADDR_ZIP
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 or province associated with this address.	VARCHAR2(63)	SPRADDR	SPRADDR_STAT_CODE
STATE_PROVINCE_DESC	State/province name.	VARCHAR2(255)	STVSTAT	STVSTAT_DESC
STREET_LINE1	First line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE1
STREET_LINE2	Second line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE2
STREET_LINE3	Third line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE3
STREET_LINE4	Fourth line of the address.	VARCHAR2(255)	NA	NA

Ver: 8.1