ODS Column	ODS Business Definition	ODS Calculation Formula	ODS Data Type	Banner Source Name	Banner Source Column	Banner Form Name
ADDRESS_TYPE	Type of address for this address record. For example, address types of mailing, temporary summer, billing and permanent.			AORCONT SPRADDR	AORCONT_ATYP_CODE SPRADDR_ATYP_CODE
ADDRESS_TYPE_DESC	Address type description.			STVATYP	STVATYP_DESC
CARRIER_ROUTE	Address carrier route.			AORCONT	AORCONT_CARRIER_ROUTE
CITY	Address city, town or municipality.			AORCONT	AORCONT_ADDR_CITY
CONTACT_FIRST_NAME	Organizational contact's first name.			AORCONT SPRIDEN	AORCONT_FIRST_NAME SPRIDEN_FIRST_NAME
CONTACT_LAST_NAME	Organizational contact's last name.			AORCONT SPRIDEN	AORCONT_LAST_NAME SPRIDEN_LAST_NAME
CONTACT_MIDDLE_INITIAL	Organizational contact's middle initial.			AOBORGN AORCONT SPRIDEN	AOBORGN_MI_CONTACT AORCONT_MI SPRIDEN_MI
CONTACT_NAME_PREFIX	Prefix used before a person's name.			AORCONT SPBPERS	AORCONT_NAME_PREFIX SPBPERS_NAME_PREFIX
CONTACT_NAME_SUFFIX	Suffix for the person's name.			AORCONT SPBPERS	AORCONT_NAME_SUFFIX SPBPERS_NAME_SUFFIX
CONTACT_TYPE	Type of contact between the institution and the organization.			AORCONT	AORCONT_OCON_CODE
CONTACT_TYPE_DESC	Contact type description.			ATVOCON	ATVOCON_DESC
CONTACT_UID	System generated, unique, internal identification number assigned to this person or organization entity.			AORCONT	AORCONT_CONTACT_PIDM
CORRECTION_DIGIT	Correction digit associated with the address for bar code mailing.			AORCONT SPRADDR	AORCONT_CORRECTION_DIGIT SPRADDR_CORRECTION_DIGIT
COUNTY	County for this address.			AORCONT SPRADDR	AORCONT_CNTY_CODE_ADDR SPRADDR_CNTY_CODE
COUNTY_DESC	County name for the address.			STVCNTY	STVCNTY_DESC
CURRENT_DATE	System current date (sysdate) or date the data was extracted.			NA	SYSDATE
DELIVERY_POINT	Delivery point associated with the address for barcode mailings.			AORCONT SPRADDR	AORCONT_DELIVERY_POINT SPRADDR_DELIVERY_POINT
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.			NA	NA
EMAIL_ADDRESS	Preferred email address.			GOREMAL	GOREMAL_EMAIL_ADDRESS
EMAIL_DESC	Description for the type of email associated with the organization's preferred email.			GTVEMAL	GTVEMAL_DESC
EMAIL_TYPE	Type of email address recorded.			GOREMAL	GOREMAL_EMAL_CODE
ENTITY_UID	System generated, unique, internal identification number assigned to this person or organization entity.			AOBORGN AORCONT	AOBORGN_PIDM AORCONT_PIDM
JOB_CATEGORY	Job category associated with the organizational contact's title.			AOBORGN AORCONT	AOBORGN_JOBC_CODE AORCONT_JOBC_CODE
JOB_CATEGORY_DESC	Job category code description.			ATVJOBC	ATVJOBC_DESC
JOB_TITLE	Organizational contact's job title.			AOBORGN AORCONT	AOBORGN_TITLE_CONTACT AORCONT_TITLE
MIF_DESC	Institution description for the record when the optional multi-institution facility feature has been applied.			NA	NA
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.			NA	NA
NATION	Nation/country code associated with the address.			AORCONT SPRADDR	AORCONT_NATN_CODE_ADDR SPRADDR_NATN_CODE
NATION_DESC	Address nation/country description.			STVNATN	STVNATN_NATION
PHONE_AREA	Phone area code.			AORCONT SPRTELE	AORCONT_PHONE_AREA SPRTELE_PHONE_AREA
PHONE_DESC	Telephone number type description.			STVTELE	STVTELE_DESC
PHONE_EXT	Phone extension.			AORCONT SPRTELE	AORCONT_PHONE_EXT SPRTELE_PHONE_EXT
PHONE_NUMBER	Phone number.			AORCONT SPRTELE	AORCONT_PHONE_NUMBER SPRTELE_PHONE_NUMBER
PHONE_NUMBER_COMBINED	Organizational contact's telephone number.			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.			SPRTELE	SPRTELE_TELE_CODE
PHONE_UNLIST_IND	Specifies if the phone number is unlisted.			SPRTELE	SPRTELE_UNLIST_IND
POSTAL_CODE	Postal code for the organizational contact's address.			AORCONT SPRADDR	AORCONT_ZIPC_CODE_ADDR SPRADDR_ZIP
PRIMARY_CONTACT_IND	Indicates whether this contact is the institution's primary contact.			CONSTANT	SOURCE AOBORGN THEN 'Y', ELSE 'N'
STATE_PROVINCE	State or province associated with this address.			AORCONT SPRADDR	AORCONT_STAT_CODE_ADDR SPRADDR_STAT_CODE
STATE_PROVINCE_DESC	State/province description.			STVSTAT	STVSTAT_DESC
STREET_LINE1	First line of the address.			AORCONT SPRADDR	AORCONT_ADDR_LINE1 SPRADDR_STREET_LINE1
STREET_LINE2	Second line of the address.			AORCONT SPRADDR	AORCONT_ADDR_LINE2 SPRADDR_STREET_LINE2
STREET_LINE3	Third line of the address.			AORCONT SPRADDR	AORCONT_ADDR_LINE3 SPRADDR_STREET_LINE3
STREET_LINE4	Fourth line of the address.			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.			NA	NA

Ver: 8.3