Target Column	Business Name	Business Definition	Database Data Type	Business Data Type	Domain Value	Source Name	Source Column	Local Source	Local Target
ENTITY_UID	Entity UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER			AORCONT	AORCONT_PIDM	NO	NO
ID	ID	Identification number assigned to a person that is used externally for all communication and correspondence with the person.	VARCHAR2(63)			SPRIDEN	SPRIDEN_ID	NO	NO
NAME	Name	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(63)			SPRIDEN	SPRIDEN_LAST_NAME	NO	NO
PRIMARY_CONTACT_IND	Primary Contact Indicator	Indicates whether this contact is the institution's primary contact.	VARCHAR2(1)			CALCULATION	CASE WHEN AORCONT_PRIMARY_IND	NO	NO
CONTACT_SEQUENCE_NUMBER	Contact Sequence Number	Organization contact internal system generated one-up number.	NUMBER			AORCONT	AORCONT_SEQ_NO	NO	NO
CONTACT_START_DATE	Contact Start Date	Organization contact start date.	DATE			AORCONT	AORCONT_DATE	NO	NO
CONTACT_END_DATE	Contact End Date	Organization contact end date.	DATE			AORCONT	AORCONT_END_DATE	NO	NO
CONTACT_UID	Contact UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER			AORCONT	AORCONT_CONTACT_PIDM	NO	NO
CONTACT_LAST_NAME	Contact Last Name	Organizational contact's last name.	VARCHAR2(255)			AORCONT SPRIDEN	AORCONT_LAST_NAME SPRIDEN_LAST_NAME	NO NO	NO
CONTACT_FIRST_NAME	Contact First Name	Organizational contact's first name.	VARCHAR2(255)			AORCONT SPRIDEN	AORCONT_FIRST_NAME SPRIDEN_FIRST_NAME	NO NO	NO
CONTACT_MIDDLE_INITIAL	Contact Middle Initial	Organizational contact's middle initial.	VARCHAR2(255)			AORCONT SPRIDEN	AORCONT_MI SPRIDEN_MI	NO NO	NO
CONTACT_NAME_PREFIX	Contact Name Prefix	Prefix used before a person's name.	VARCHAR2(255)			AORCONT SPBPERS	AORCONT_NAME_PREFIX SPBPERS_NAME_PREFIX	NO NO	NO
CONTACT_NAME_SUFFIX	Contact Name Suffix	Suffix for the person's name.	VARCHAR2(255)			AORCONT SPBPERS	AORCONT_NAME_SUFFIX SPBPERS_NAME_SUFFIX	NO NO	NO
CONTACT_LAST_NAME_PREFIX	Contact Last Name Prefix	Last name prefix of the person.	VARCHAR2(255)			AORCONT SPRIDEN	AORCONT_SURNAME_PREFIX SPRIDEN_SURNAME_PREFIX	NO NO	NO
CONTACT_DECEASED_IND	Contact Deceased Indicator	Indicates whether this person is deceased.	VARCHAR2(1)			AORCONT SPBPERS	AORCONT_DECEASED_IND SPBPERS_DEAD_IND	NO NO	NO
CONTACT_DECEASED_IND_DESC	Contact Deceased Indicator Description	Contact deceased indicator description.	VARCHAR2(255)			CALCULATION	CASE WHEN CONTACT_DECEASED_IND	NO	NO
CONTACT_TYPE	Contact Type	Type of contact between the institution and the organization.	VARCHAR2(63)			AORCONT	AORCONT_OCON_CODE	NO	NO
CONTACT_TYPE_DESC	Contact Type Description	Contact type description.	VARCHAR2(255)			ATVOCON	ATVOCON_DESC	NO	NO
JOB_CATEGORY	Job Category	Job category associated with the organizational contact's title.	VARCHAR2(63)			AORCONT	AORCONT_JOBC_CODE	NO	NO
JOB_CATEGORY_DESC	Job Category Description	Job category code description.	VARCHAR2(255)			ATVJOBC	ATVJOBC_DESC	NO	NO
JOB_TITLE	Job Title	Organizational contact's job title.	VARCHAR2(255)			AORCONT	AORCONT_TITLE	NO	NO
ADDRESS_TYPE	Address Type	Type of address for this address record. For example, address types of mailing, temporary summer, billing and permanent.	VARCHAR2(63)			AORCONT	AORCONT_ATYP_CODE	NO	NO
ADDRESS_TYPE_DESC	Address Type Description	Address type description.	VARCHAR2(255)			STVATYP	STVATYP_DESC	NO	NO
STREET_LINE1	Street Line 1	First line of the address.	VARCHAR2(255)			AORCONT SPRADDR	AORCONT_ADDR_LINE1 SPRADDR_STREET_LINE1	NO NO	NO
STREET_LINE2	Street Line 2	Second line of the address.	VARCHAR2(255)			AORCONT SPRADDR	AORCONT_ADDR_LINE2 SPRADDR_STREET_LINE2	NO NO	NO
STREET_LINE3	Street Line 3	Third line of the address.	VARCHAR2(255)			AORCONT SPRADDR	AORCONT_ADDR_LINE3 SPRADDR_STREET_LINE3	NO NO	NO
STREET_LINE4	Street Line 4	Fourth line of the address.	VARCHAR2(255)			AORCONT SPRADDR	AORCONT_ADDR_LINE4 SPRADDR_STREET_LINE4	NO NO	NO
HOUSE_NUMBER	House Number	House number associated with the address.	VARCHAR2(63)			AORCONT SPRADDR	AORCONT_HOUSE_NUMBER SPRADDR_HOUSE_NUMBER	NO NO	NO
CITY	City	Address city, town or municipality.	VARCHAR2(255)			AORCONT SPRADDR	AORCONT_ADDR_CITY SPRADDR_CITY	NO NO	NO
COUNTY	County	County for this address.	VARCHAR2(63)			AORCONT SPRADDR	AORCONT_CNTY_CODE_ADDR SPRADDR_CNTY_CODE	NO NO	NO
COUNTY_DESC	County Description	County name for the address.	VARCHAR2(255)			STVCNTY	STVCNTY_DESC	NO	NO
STATE_PROVINCE	State Province	State or province associated with this address.	VARCHAR2(63)			AORCONT SPRADDR	AORCONT_STAT_CODE_ADDR SPRADDR_STAT_CODE	NO NO	NO
STATE_PROVINCE_DESC	State Province Description	State/province description.	VARCHAR2(255)			STVSTAT	STVSTAT_DESC	NO	NO
POSTAL_CODE	Postal Code	Address postal code.	VARCHAR2(63)			AORCONT SPRADDR	AORCONT_ZIPC_CODE_ADDR SPRADDR_ZIP	NO NO	NO
NATION	Nation	Address nation/country code.	VARCHAR2(63)			AORCONT SPRADDR	AORCONT_NATN_CODE_ADDR SPRADDR_NATN_CODE	NO NO	NO
NATION_DESC	Nation Description	Address nation/country description.	VARCHAR2(255)			STVNATN	STVNATN_NATION	NO	NO
DELIVERY_POINT	Delivery Point	Delivery point associated with the address for barcode mailings.	NUMBER			AORCONT SPRADDR	AORCONT_DELIVERY_POINT SPRADDR_DELIVERY_POINT	NO NO	NO
CORRECTION_DIGIT	Correction Digit	Correction digit associated with the address for bar code mailing.	NUMBER			AORCONT SPRADDR	AORCONT_CORRECTION_DIGIT SPRADDR_CORRECTION_DIGIT	NO NO	NO
CARRIER_ROUTE	Carrier Route	Address carrier route.	VARCHAR2(63)			AORCONT SPRADDR	AORCONT_CARRIER_ROUTE SPRADDR_CARRIER_ROUNT	NO NO	NO
GEOGRAPHIC_REGION_COUNT	Geographic Region Count	Count of geographic regions associated with an address record.	NUMBER			FUNCTION	MGKFUNC.F_COUNT_GEOGRAPHIC_REGIONS	NO	NO
CONTACT_ADDRESS_STATUS_IND	Contact Address Status Indicator	Indicates whether the address information is active or inactive.	VARCHAR2(1)			SPRADDR	SPRADDR_STATUS_IND	NO	NO
CONTACT_ADDRESS_SOURCE	Contact Address Source	Indicates whether this contact address information is sourced from the (O)rganization address type, (C)onstituent address type, or manually entered as No Source.	VARCHAR2(63)			AORCONT	AORCONT_CONT_ORG_IND	NO	NO
CONTACT_ADDRESS_SOURCE_DESC	Contact Address Source Description	Contact address source description.	VARCHAR2(255)			CALCULATION	CASE WHEN AORCONT_CONT_ORG_IND	NO	NO
ADDRESS_COUNT	Address Count	Count of current active addresses for this person or entity.	NUMBER			FUNCTION	MSKFUNC.F_COUNT_ADDRESSES	NO	NO
PHONE_NUMBER_COMBINED	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	NO NO	NO
PHONE_AREA	Phone Area	Phone area code.	VARCHAR2(63)			AORCONT SPRTELE	AORCONT_PHONE_AREA SPRTELE_PHONE_AREA	NO NO	NO
PHONE_NUMBER	Phone Number	Phone number.	VARCHAR2(63)			AORCONT SPRTELE	AORCONT_PHONE_NUMBER SPRTELE_PHONE_NUMBER	NO NO	NO
PHONE_EXT	Phone Extension	Phone extension.	VARCHAR2(63)			AORCONT SPRTELE	AORCONT_PHONE_EXT SPRTELE_PHONE_EXT	NO NO	NO
PHONE_COUNTRY_CODE	Phone Country Code	Telephone country code designation.	VARCHAR2(63)			AORCONT SPRTELE	AORCONT_CTRY_CODE_PHONE SPRTELE_CTRY_CODE_PHONE	NO NO	NO
PHONE_UNLIST_IND	Phone Unlisted Indicator	Specifies if the phone number is unlisted.	VARCHAR2(255)			SPRTELE	SPRTELE_UNLIST_IND	NO	NO
PHONE_TYPE	Phone Type	Telephone type code associated with the contact telephone number.	VARCHAR2(63)			AORCONT	AORCONT_TELE_CODE	NO	NO
PHONE_DESC	Phone Description	Telephone number type description.	VARCHAR2(255)			STVTELE	STVTELE_DESC	NO	NO
CONTACT_PHONE_SOURCE	Contact Phone Source	Indicates whether this contact phone information is sourced from the (O)rganization phone type, (C)onstituent phone type, or manually entered as No Source.	VARCHAR2(63)			AORCONT	AORCONT_TELE_SRC_IND	NO	NO
CONTACT_PHONE_SOURCE_DESC	Contact Phone Source Description	Contact phone source description.	VARCHAR2(255)			CALCULATION	CASE WHEN AORCONT_TELE_SRC_IND	NO	NO
PHONE_COUNT	Phone Count	Count of phone records.	NUMBER			FUNCTION	MSKFUNC.F_COUNT_TELEPHONES	NO	NO
FAX_NUMBER_COMBINED	Fax Number Combined	Organizational contact's fax number.	VARCHAR2(63)			CALCULATION CALCULATION	AORCONT_FAX_AREA||AORCONT_FAX_NUMBER||AORCONT_FAX_EXT SPRTELE_INTL_ACCESS||SPRTELE_PHONE_AREA||SPRTELE_PHONE_NUMBER||SPRTELE_PHONE_EXT	NO NO	NO
FAX_AREA	Fax Area	Fax area code.	VARCHAR2(63)			AORCONT SPRTELE	AORCONT_FAX_AREA SPRTELE_PHONE_AREA	NO NO	NO
FAX_NUMBER	Fax Number	Fax number.	VARCHAR2(63)			AORCONT SPRTELE	AORCONT_FAX_NUMBER SPRTELE_PHONE_NUMBER	NO NO	NO
FAX_EXT	Fax Extension	Fax extension.	VARCHAR2(63)			AORCONT SPRTELE	AORCONT_FAX_EXT SPRTELE_PHONE_EXT	NO NO	NO
FAX_COUNTRY_CODE	Fax Country Code	Fax country code designation.	VARCHAR2(63)			AORCONT SPRTELE	AORCONT_CTRY_CODE_FAX SPRTELE_CTRY_CODE_PHONE	NO NO	NO
FAX_UNLIST_IND	Fax Unlisted Indicator	Indicates whether the fax number is unlisted.	VARCHAR2(1)			SPRTELE	SPRTELE_UNLIST_IND	NO	NO
FAX_TYPE	Fax Type	Fax type code associated with the contact preferred fax number.	VARCHAR2(63)			AORCONT	AORCONT_FAX_CODE	NO	NO
FAX_TYPE_DESC	Fax Type Description	Fax number type description.	VARCHAR2(255)			STVTELE	STVTELE_DESC	NO	NO
CONTACT_FAX_SOURCE	Contact Fax Source	Indicates whether this contact fax information is sourced from the (O)rganization fax type, (C)onstituent fax type, or manually entered as No Source.	VARCHAR2(63)			AORCONT	AORCONT_FAX_SRC_IND	NO	NO
CONTACT_FAX_SOURCE_DESC	Contact Fax Source Description	Contact fax source description.	VARCHAR2(255)			CALCULATION	CASE WHEN AORCONT_FAX_SRC_IND	NO	NO
EMAIL_ADDRESS	Email Address	Preferred email address.	VARCHAR2(255)			AORCONT GOREMAL	AORCONT_EMAIL_ADDRESS GOREMAL_EMAIL_ADDRESS	NO NO	NO
EMAIL_TYPE	Email Type	Type of email address recorded.	VARCHAR2(63)			AORCONT	AORCONT_EMAL_CODE	NO	NO
EMAIL_DESC	Email Description	Organization's or Individual email type description.	VARCHAR2(255)			GTVEMAL	GTVEMAL_DESC	NO	NO
CONTACT_EMAIL_SOURCE	Contact Email Source	Indicates whether this contact email information is sourced from the (O)rganization email type, (C)onstituent email type, or manually entered as No Source.	VARCHAR2(63)			AORCONT	AORCONT_EMAL_SRC_IND	NO	NO
CONTACT_EMAIL_SOURCE_DESC	Contact Email Source Description	Contact email source description.	VARCHAR2(255)			CALCULATION	CASE WHEN AORCONT_EMAL_SRC_IND	NO	NO
CONTACT_COMMENT	Contact Comment	Comment related to organization contact.	VARCHAR2(4000)			AORCONT	AORCONT_NOTES	NO	NO
CONTACT_USER_ID	Contact User ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(63)			NA	NULL	NO	NO
CONTACT_ACTIVITY_DATE	Contact Activity Date	Date that information for this record in the table was entered or last updated.	DATE			AORCONT	AORCONT_ACTIVITY_DATE	NO	NO
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)			NA	NA	NO	NO
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)			NA	NA	NO	NO
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)			NA	NA	NO	NO
ADMINISTRATIVE_GROUP	Administrative Group	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)			NA	NA	NO	NO

Ver: 9.2