Target Column	Business Definition	Database Data Type	Source Name	Source Column
ADDRESS_COUNT	Count of current active addresses for this person or entity.	NUMBER	FUNCTION	MSKFUNC.F_COUNT_ADDRESSES
ADDRESS_TYPE	Type of address for this address record. For example, address types of mailing, temporary summer, billing and permanent.	VARCHAR2(63)	AORCONT SPRADDR	AORCONT_ATYP_CODE SPRADDR_ATYP_CODE
ADDRESS_TYPE_DESC	Address type description.	VARCHAR2(255)	STVATYP	STVATYP_DESC
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(63)	AORCONT	AORCONT_CARRIER_ROUTE
CITY	Address city, town or municipality.	VARCHAR2(255)	AORCONT	AORCONT_ADDR_CITY
CONTACT_FIRST_NAME	Organizational contact's first name.	VARCHAR2(255)	AORCONT SPRIDEN	AORCONT_FIRST_NAME SPRIDEN_FIRST_NAME
CONTACT_LAST_NAME	Organizational contact's last name.	VARCHAR2(255)	AORCONT SPRIDEN	AORCONT_LAST_NAME SPRIDEN_LAST_NAME
CONTACT_MIDDLE_INITIAL	Organizational contact's middle initial.	VARCHAR2(1)	AOBORGN AORCONT SPRIDEN	AOBORGN_MI_CONTACT AORCONT_MI SPRIDEN_MI
CONTACT_NAME_PREFIX	Prefix used before a person's name.	VARCHAR2(255)	AORCONT SPBPERS	AORCONT_NAME_PREFIX SPBPERS_NAME_PREFIX
CONTACT_NAME_SUFFIX	Suffix for the person's name.	VARCHAR2(255)	AORCONT SPBPERS	AORCONT_NAME_SUFFIX SPBPERS_NAME_SUFFIX
CONTACT_TYPE	Type of contact between the institution and the organization.	VARCHAR2(63)	AORCONT	AORCONT_OCON_CODE
CONTACT_TYPE_DESC	Contact type description.	VARCHAR2(255)	ATVOCON	ATVOCON_DESC
CONTACT_UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER	AORCONT	AORCONT_CONTACT_PIDM
CORRECTION_DIGIT	Correction digit associated with the address for bar code mailing.	NUMBER	AORCONT SPRADDR	AORCONT_CORRECTION_DIGIT SPRADDR_CORRECTION_DIGIT
COUNTY	County for this address.	VARCHAR2(63)	AORCONT SPRADDR	AORCONT_CNTY_CODE_ADDR SPRADDR_CNTY_CODE
COUNTY_DESC	County name for the address.	VARCHAR2(255)	STVCNTY	STVCNTY_DESC
DELIVERY_POINT	Delivery point associated with the address for barcode mailings.	NUMBER	AORCONT SPRADDR	AORCONT_DELIVERY_POINT SPRADDR_DELIVERY_POINT
EMAIL_ADDRESS	Preferred email address.	VARCHAR2(255)	GOREMAL	GOREMAL_EMAIL_ADDRESS
EMAIL_DESC	Organization's preferred email type description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
EMAIL_TYPE	Type of email address recorded.	VARCHAR2(255)	GOREMAL	GOREMAL_EMAL_CODE
ENTITY_UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER	AOBORGN AORCONT	AOBORGN_PIDM AORCONT_PIDM
GEOGRAPHIC_REGION_COUNT	Count of geographic regions associated with an address record.	NUMBER	FUNCTION	MGKFUNC.F_COUNT_GEOGRAPHIC_REGIONS
ID	Person's or organization's current identification number.	VARCHAR2(9)	SPRIDEN	SPRIDEN_ID
JOB_CATEGORY	Job category associated with the organizational contact's title.	VARCHAR2(63)	AOBORGN AORCONT	AOBORGN_JOBC_CODE AORCONT_JOBC_CODE
JOB_CATEGORY_DESC	Job category code description.	VARCHAR2(255)	ATVJOBC	ATVJOBC_DESC
JOB_TITLE	Organizational contact's job title.	VARCHAR2(255)	AOBORGN AORCONT	AOBORGN_TITLE_CONTACT AORCONT_TITLE
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
NAME	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(63)	FUNCTION	F_FORMAT_NAME
NATION	Address nation/country code.	VARCHAR2(63)	AORCONT SPRADDR	AORCONT_NATN_CODE_ADDR SPRADDR_NATN_CODE
NATION_DESC	Address nation/country description.	VARCHAR2(255)	STVNATN	STVNATN_NATION
PHONE_AREA	Phone area code.	VARCHAR2(63)	AORCONT SPRTELE	AORCONT_PHONE_AREA SPRTELE_PHONE_AREA
PHONE_COUNT	Count of phone records.	NUMBER	FUNCTION	MSKFUNC.F_COUNT_TELEPHONES
PHONE_DESC	Telephone number type description.	VARCHAR2(255)	STVTELE	STVTELE_DESC
PHONE_EXT	Phone extension.	VARCHAR2(63)	AORCONT SPRTELE	AORCONT_PHONE_EXT SPRTELE_PHONE_EXT
PHONE_NUMBER	Phone number.	VARCHAR2(63)	AORCONT SPRTELE	AORCONT_PHONE_NUMBER SPRTELE_PHONE_NUMBER
PHONE_NUMBER_COMBINED	Organizational contact's telephone number.	VARCHAR2(63)	CALCULATION CALCULATION	AORCONT_PHONE_AREA||AORCONT_PHONE_NUMBER||AORCONT_PHONE_EXT SPRTELE_INTL_ACCESS||SPRTELE_PHONE_AREA||SPRTELE_PHONE_NUMBER||SPRTELE_PHONE_EXT
PHONE_TYPE	Telephone type code associated with the organization's preferred telephone number.	VARCHAR2(255)	SPRTELE	SPRTELE_TELE_CODE
PHONE_UNLIST_IND	Specifies if the phone number is unlisted.	VARCHAR2(255)	SPRTELE	SPRTELE_UNLIST_IND
POSTAL_CODE	Address postal code.	VARCHAR2(63)	AORCONT SPRADDR	AORCONT_ZIPC_CODE_ADDR SPRADDR_ZIP
PRIMARY_CONTACT_IND	Indicates whether this contact is the institution's primary contact.	VARCHAR2(1)	CONSTANT	SOURCE AOBORGN THEN 'Y', ELSE 'N'
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)	AORCONT SPRADDR	AORCONT_STAT_CODE_ADDR SPRADDR_STAT_CODE
STATE_PROVINCE_DESC	State/province description.	VARCHAR2(255)	STVSTAT	STVSTAT_DESC
STREET_LINE1	First line of the address.	VARCHAR2(255)	AORCONT SPRADDR	AORCONT_ADDR_LINE1 SPRADDR_STREET_LINE1
STREET_LINE2	Second line of the address.	VARCHAR2(255)	AORCONT SPRADDR	AORCONT_ADDR_LINE2 SPRADDR_STREET_LINE2
STREET_LINE3	Third line of the address.	VARCHAR2(255)	AORCONT SPRADDR	AORCONT_ADDR_LINE3 SPRADDR_STREET_LINE3
STREET_LINE4	Fourth line of the address.	VARCHAR2(255)	NA	NA

Ver: 8.1