Target Column	Business Definition	Database Data Type	Source Name	Source Column
ADDRESS_TYPE	Type of address for this address record. For example, address types of mailing, temporary summer, billing and permanent.	VARCHAR2(2)	AORCONT	AORCONT_ATYP_CODE
ADDRESS_TYPE_DESC	Address type description.	VARCHAR2(30)	STVATYP	STVATYP_DESC
CARRIER_ROUTE	Address carrier route.	VARCHAR2(4)	AORCONT SPRADDR	AORCONT_CARRIER_ROUTE SPRADDR_CARRIER_ROUNT
CITY	Address city, town or municipality.	VARCHAR2(50)	AORCONT SPRADDR	AORCONT_ADDR_CITY SPRADDR_CITY
CONTACT_FIRST_NAME	Organizational contact's first name.	VARCHAR2(60)	AORCONT SPRIDEN	AORCONT_FIRST_NAME SPRIDEN_FIRST_NAME
CONTACT_LAST_NAME	Organizational contact's last name.	VARCHAR2(60)	AORCONT SPRIDEN	AORCONT_LAST_NAME SPRIDEN_LAST_NAME
CONTACT_MIDDLE_INITIAL	Organizational contact's middle initial.	VARCHAR2(60)	AORCONT SPRIDEN	AORCONT_MI SPRIDEN_MI
CONTACT_NAME_PREFIX	Prefix used before a person's name.	VARCHAR2(20)	AORCONT SPBPERS	AORCONT_NAME_PREFIX SPBPERS_NAME_PREFIX
CONTACT_NAME_SUFFIX	Suffix for the person's name.	VARCHAR2(20)	AORCONT SPBPERS	AORCONT_NAME_SUFFIX SPBPERS_NAME_SUFFIX
CONTACT_TYPE	Type of contact between the institution and the organization.	VARCHAR2(3)	AORCONT	AORCONT_OCON_CODE
CONTACT_TYPE_DESC	Contact type description.	VARCHAR2(30)	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(5)	AORCONT SPRADDR	AORCONT_CNTY_CODE_ADDR 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	AORCONT SPRADDR	AORCONT_DELIVERY_POINT SPRADDR_DELIVERY_POINT
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA
EMAIL_ADDRESS	Preferred email address.	VARCHAR2(128)	AORCONT GOREMAL	AORCONT_EMAIL_ADDRESS GOREMAL_EMAIL_ADDRESS
EMAIL_DESC	Description for the type of email associated with the organization's preferred email.	VARCHAR2(60)	GTVEMAL	GTVEMAL_DESC
EMAIL_TYPE	Type of email address recorded.	VARCHAR2(4)	AORCONT	AORCONT_EMAL_CODE
ENTITY_UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER(8)	AORCONT	AORCONT_PIDM
JOB_CATEGORY	Job category associated with the organizational contact's title.	VARCHAR2(3)	AORCONT	AORCONT_JOBC_CODE
JOB_CATEGORY_DESC	Job category code description.	VARCHAR2(60)	ATVJOBC	ATVJOBC_DESC
JOB_TITLE	Organizational contact's job title.	VARCHAR2(60)	AORCONT	AORCONT_TITLE
MIF_DESC	Institution description for the record 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)	AORCONT SPRADDR	AORCONT_NATN_CODE_ADDR SPRADDR_NATN_CODE
NATION_DESC	Address nation/country description.	VARCHAR2(30)	STVNATN	STVNATN_NATION
PHONE_AREA	Phone area code.	VARCHAR2(6)	AORCONT SPRTELE	AORCONT_PHONE_AREA SPRTELE_PHONE_AREA
PHONE_DESC	Telephone number type description.	VARCHAR2(30)	STVTELE	STVTELE_DESC
PHONE_EXT	Phone extension.	VARCHAR2(10)	AORCONT SPRTELE	AORCONT_PHONE_EXT SPRTELE_PHONE_EXT
PHONE_NUMBER	Phone number.	VARCHAR2(12)	AORCONT SPRTELE	AORCONT_PHONE_NUMBER SPRTELE_PHONE_NUMBER
PHONE_NUMBER_COMBINED	Organizational contact's telephone number.	VARCHAR2(44)	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(4)	AORCONT	AORCONT_TELE_CODE
PHONE_UNLIST_IND	Specifies if the phone number is unlisted.	VARCHAR2(1)	SPRTELE	SPRTELE_UNLIST_IND
POSTAL_CODE	Postal code for the organizational contact's address.	VARCHAR2(30)	AORCONT SPRADDR	AORCONT_ZIPC_CODE_ADDR SPRADDR_ZIP
PRIMARY_CONTACT_IND	Indicates whether this contact is the institution's primary contact.	VARCHAR2(1)	CALCULATION	CASE WHEN AORCONT_PRIMARY_IND
STATE_PROVINCE	State or province associated with this address.	VARCHAR2(3)	AORCONT SPRADDR	AORCONT_STAT_CODE_ADDR SPRADDR_STAT_CODE
STATE_PROVINCE_DESC	State/province description.	VARCHAR2(30)	STVSTAT	STVSTAT_DESC
STREET_LINE1	First line of the address.	VARCHAR2(75)	AORCONT SPRADDR	AORCONT_ADDR_LINE1 SPRADDR_STREET_LINE1
STREET_LINE2	Second line of the address.	VARCHAR2(75)	AORCONT SPRADDR	AORCONT_ADDR_LINE2 SPRADDR_STREET_LINE2
STREET_LINE3	Third line of the address.	VARCHAR2(75)	AORCONT SPRADDR	AORCONT_ADDR_LINE3 SPRADDR_STREET_LINE3
STREET_LINE4	Fourth line of the address.	VARCHAR2(75)	AORCONT SPRADDR	AORCONT_ADDR_LINE4 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: