ODS Column	ODS Business Definition	ODS Calculation Formula	ODS Data Type	Banner Source Name	Banner Source Column	Banner Form Name
ADMINISTRATIVE_GROUP	Organization-oriented identifier used to determine access authorization to this record. Institution defined.			NA	NA
BIRTH_DATE	Person's date of birth.			SPBPERS	SPBPERS_BIRTH_DATE
CARRIER_ROUTE	Address carrier route.			SPRADDR	SPRADDR_CARRIER_ROUTE
CITY	Address, city, town or municipality of the entity.			SPRADDR	SPRADDR_CITY
COMBINED_MAILING_NAME	Combined mailing name for the constituent.			APBCONS	APBCONS_CM_NAME
CONTACT_COUNT	Total number of contacts for this organization.			FUNCTION	MAKFUNC.F_COUNT_ORGN_CONTACT
CORRECTION_DIGIT	Address correction digit.			SPRADDR	SPRADDR_CORRECTION_DIGIT
COUNTY	County for this entity's address.			SPRADDR	SPRADDR_CNTY_CODE
COUNTY_DESC	County address name.			STVCNTY	STVCNTY_DESC
DECEASED_IND	Indicates whether a person is deceased.			SPBPERS	SPBPERS_DEAD_IND
DELIVERY_POINT	Address delivery point.			SPRADDR	SPRADDR_DELIVERY_POINT
ENTITY_IND	Indicates whether the entity is a person or an organization.			CONSTANT CONSTANT	'O' 'P'
ENTITY_UID	System generated unique internal identification number assigned to this person or organization.			SPRIDEN	SPRIDEN_PIDM
FIRST_NAME	First name of the person.			SPRIDEN	SPRIDEN_FIRST_NAME
ID	Person's or Organization's current identification number.			SPRIDEN	SPRIDEN_ID
LAST_NAME	Name of the Organization or last name of the person.			SPRIDEN	SPRIDEN_LAST_NAME
MAILING_NAME	Name used with the preferred address type for the organization or person's last name.			APBCONS SPRIDEN	APBCONS_ADDR_NAME SPRIDEN_LAST_NAME
MIDDLE_NAME	Middle name of the person.			SPRIDEN	SPRIDEN_MI
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.			NA	NA
MULTI_SOURCE_DESC	Institution description for the record when the optional multi-institution facility feature has been applied.			NA	NA
NAME_PREFIX	Prefix used before a person's name.			SPBPERS	SPBPERS_NAME_PREFIX
NAME_SUFFIX	Suffix for the person's name.			SPBPERS	SPBPERS_NAME_SUFFIX
NATION	Nation/country code associated with the entity's address.			SPRADDR	SPRADDR_NATN_CODE
NATION_DESC	Address' nation/country description.			STVNATN	STVNATN_NATION
PHONE_NUMBER_COMBINED	Combined values of the international access, area code, phone number and phone extensions.			CALCULATION	SPRTELE_INTL_ACCESS||SPRTELE_PHONE_AREA||SPRTELE_PHONE_NUMBER||SPRTELE_PHONE_EXT
POSTAL_CODE	Address postal code of the entity.			SPRADDR	SPRADDR_ZIP
PRIMARY_CONTACT_FIRST_NAME	Organizational contact's first name.			AOBORGN	AOBORGN_FIRST_NAME_CONTACT
PRIMARY_CONTACT_JOB_TITLE	Organizational contact's job title.			AOBORGN	AOBORGN_TITLE_CONTACT
PRIMARY_CONTACT_LAST_NAME	Organizational contact's last name.			AOBORGN	AOBORGN_LAST_NAME_CONTACT
PRIMARY_CONTACT_MIDDLE_INITIAL	Organizational contact's middle name.			AOBORGN	AOBORGN_MI_CONTACT
PRIMARY_CONTACT_NAME_PREFIX	Prefix for the person's name.			AOBORGN	AOBORGN_PREFIX_CONTACT
PRIMARY_CONTACT_NAME_SUFFIX	Suffix for the person's name.			AOBORGN	AOBORGN_SUFFIX_CONTACT
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.			NA	NA
STATE_PROVINCE	State or province associated with the entity's address.			SPRADDR	SPRADDR_STAT_CODE
STATE_PROVINCE_DESC	State/province description.			STVSTAT	STVSTAT_DESC
STREET_LINE1	First line of the entity's address.			SPRADDR	SPRADDR_STREET_LINE1
STREET_LINE2	Second line of the entity's address.			SPRADDR	SPRADDR_STREET_LINE2
STREET_LINE3	Third line of the entity's address.			SPRADDR	SPRADDR_STREET_LINE3
STREET_LINE4	Fourth line of the entity's address.			SPRADDR	SPRADDR_STREET_LINE4

Ver: 8.3