Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
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	NO	NO
ADDRESS_TYPE_DESC	Address type description.	VARCHAR2(30)	STVATYP	STVATYP_DESC	NO	NO
CARRIER_ROUTE	Address carrier route.	VARCHAR2(4)	AORCONT SPRADDR	AORCONT_CARRIER_ROUTE SPRADDR_CARRIER_ROUNT	NO NO	NO
CITY	Address city, town or municipality.	VARCHAR2(50)	AORCONT SPRADDR	AORCONT_ADDR_CITY SPRADDR_CITY	NO NO	NO
CONTACT_ACTIVITY_DATE	Date that information for this record in the table was entered or last updated.	DATE	AORCONT	AORCONT_ACTIVITY_DATE	NO	NO
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(1)	AORCONT	AORCONT_CONT_ORG_IND	NO	NO
CONTACT_ADDRESS_SOURCE_DESC	Contact address source description.	VARCHAR2(12)	CALCULATION	CASE WHEN AORCONT_CONT_ORG_IND	NO	NO
CONTACT_ADDRESS_STATUS_IND	Indicates whether the address information is active or inactive.	VARCHAR2(1)	SPRADDR	SPRADDR_STATUS_IND	NO	NO
CONTACT_COMMENT	Comment related to organization contact.	VARCHAR2(4000)	AORCONT	AORCONT_NOTES	NO	NO
CONTACT_DECEASED_IND	Indicates whether this person is deceased.	VARCHAR2(1)	AORCONT SPBPERS	AORCONT_DECEASED_IND SPBPERS_DEAD_IND	NO NO	NO
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(1)	AORCONT	AORCONT_EMAL_SRC_IND	NO	NO
CONTACT_EMAIL_SOURCE_DESC	Contact email source description.	VARCHAR2(12)	CALCULATION	CASE WHEN AORCONT_EMAL_SRC_IND	NO	NO
CONTACT_END_DATE	Organization contact end date.	DATE	AORCONT	AORCONT_END_DATE	NO	NO
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(1)	AORCONT	AORCONT_FAX_SRC_IND	NO	NO
CONTACT_FAX_SOURCE_DESC	Contact fax source description.	VARCHAR2(12)	CALCULATION	CASE WHEN AORCONT_FAX_SRC_IND	NO	NO
CONTACT_FIRST_NAME	Organizational contact's first name.	VARCHAR2(60)	AORCONT SPRIDEN	AORCONT_FIRST_NAME SPRIDEN_FIRST_NAME	NO NO	NO
CONTACT_LAST_NAME	Organizational contact's last name.	VARCHAR2(60)	AORCONT SPRIDEN	AORCONT_LAST_NAME SPRIDEN_LAST_NAME	NO NO	NO
CONTACT_LAST_NAME_PREFIX	Last name prefix of the person.	VARCHAR2(60)	AORCONT SPRIDEN	AORCONT_SURNAME_PREFIX SPRIDEN_SURNAME_PREFIX	NO NO	NO
CONTACT_MIDDLE_INITIAL	Organizational contact's middle initial.	VARCHAR2(60)	AORCONT SPRIDEN	AORCONT_MI SPRIDEN_MI	NO NO	NO
CONTACT_NAME_PREFIX	Prefix used before a person's name.	VARCHAR2(20)	AORCONT SPBPERS	AORCONT_NAME_PREFIX SPBPERS_NAME_PREFIX	NO NO	NO
CONTACT_NAME_SUFFIX	Suffix for the person's name.	VARCHAR2(20)	AORCONT SPBPERS	AORCONT_NAME_SUFFIX SPBPERS_NAME_SUFFIX	NO NO	NO
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(1)	AORCONT	AORCONT_TELE_SRC_IND	NO	NO
CONTACT_PHONE_SOURCE_DESC	Contact phone source description.	VARCHAR2(12)	CALCULATION	CASE WHEN AORCONT_TELE_SRC_IND	NO	NO
CONTACT_SEQUENCE_NUMBER	Organization contact internal system generated one-up number.	NUMBER(23,20)	AORCONT	AORCONT_SEQ_NO	NO	NO
CONTACT_START_DATE	Organization contact start date.	DATE	AORCONT	AORCONT_DATE	NO	NO
CONTACT_TYPE_DESC	Contact type description.	VARCHAR2(30)	ATVOCON	ATVOCON_DESC	NO	NO
CONTACT_UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER	AORCONT	AORCONT_CONTACT_PIDM	NO	NO
CONTACT_USER_ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(63)	NA	NULL	NO	NO
CORRECTION_DIGIT	Correction digit associated with the address for bar code mailing.	NUMBER	AORCONT SPRADDR	AORCONT_CORRECTION_DIGIT SPRADDR_CORRECTION_DIGIT	NO NO	NO
COUNTY	County for this address.	VARCHAR2(5)	AORCONT SPRADDR	AORCONT_CNTY_CODE_ADDR SPRADDR_CNTY_CODE	NO NO	NO
COUNTY_DESC	County name for the address.	VARCHAR2(30)	STVCNTY	STVCNTY_DESC	NO	NO
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE	NO	NO
DELIVERY_POINT	Delivery point associated with the address for barcode mailings.	NUMBER	AORCONT SPRADDR	AORCONT_DELIVERY_POINT SPRADDR_DELIVERY_POINT	NO NO	NO
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO
EMAIL_ADDRESS	Preferred email address.	VARCHAR2(128)	AORCONT GOREMAL	AORCONT_EMAIL_ADDRESS GOREMAL_EMAIL_ADDRESS	NO NO	NO
EMAIL_DESC	Description for the type of email associated with the organization's preferred email.	VARCHAR2(60)	GTVEMAL	GTVEMAL_DESC	NO	NO
EMAIL_TYPE	Type of email address recorded.	VARCHAR2(4)	AORCONT	AORCONT_EMAL_CODE	NO	NO
ENTITY_UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER	AORCONT	AORCONT_PIDM	NO	NO
FAX_AREA	Fax area code.	VARCHAR2(6)	AORCONT SPRTELE	AORCONT_FAX_AREA SPRTELE_PHONE_AREA	NO NO	NO
FAX_COUNTRY_CODE	Fax country code designation.	VARCHAR2(4)	AORCONT SPRTELE	AORCONT_CTRY_CODE_FAX SPRTELE_CTRY_CODE_PHONE	NO NO	NO
FAX_EXT	Fax extension.	VARCHAR2(10)	AORCONT SPRTELE	AORCONT_FAX_EXT SPRTELE_PHONE_EXT	NO NO	NO
FAX_NUMBER	Fax number.	VARCHAR2(12)	AORCONT SPRTELE	AORCONT_FAX_NUMBER SPRTELE_PHONE_NUMBER	NO NO	NO
FAX_NUMBER_COMBINED	Organizational contact's fax number.	VARCHAR2(44)	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_TYPE	Fax type code associated with the contact preferred fax number.	VARCHAR2(4)	AORCONT	AORCONT_FAX_CODE	NO	NO
FAX_TYPE_DESC	Fax number type description.	VARCHAR2(30)	STVTELE	STVTELE_DESC	NO	NO
FAX_UNLIST_IND	Indicates whether the fax number is unlisted.	VARCHAR2(1)	SPRTELE	SPRTELE_UNLIST_IND	NO	NO
HOUSE_NUMBER	House number associated with the address.	VARCHAR2(10)	AORCONT SPRADDR	AORCONT_HOUSE_NUMBER SPRADDR_HOUSE_NUMBER	NO NO	NO
JOB_CATEGORY	Job category associated with the organizational contact's title.	VARCHAR2(3)	AOBORGN AORCONT	AOBORGN_JOBC_CODE AORCONT_JOBC_CODE	NO NO	NO
JOB_CATEGORY_DESC	Job category code description.	VARCHAR2(60)	ATVJOBC	ATVJOBC_DESC	NO	NO
JOB_TITLE	Organizational contact's job title.	VARCHAR2(60)	AORCONT	AORCONT_TITLE	NO	NO
MIF_DESC	Institution description for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA	NO	NO
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA	NO	NO
NATION	Nation/country code associated with the address.	VARCHAR2(5)	AORCONT SPRADDR	AORCONT_NATN_CODE_ADDR SPRADDR_NATN_CODE	NO NO	NO
NATION_DESC	Address nation/country description.	VARCHAR2(30)	STVNATN	STVNATN_NATION	NO	NO
PHONE_AREA	Phone area code.	VARCHAR2(6)	AORCONT SPRTELE	AORCONT_PHONE_AREA SPRTELE_PHONE_AREA	NO NO	NO
PHONE_COUNTRY_CODE	Telephone country code designation.	VARCHAR2(4)	AORCONT SPRTELE	AORCONT_CTRY_CODE_PHONE SPRTELE_CTRY_CODE_PHONE	NO NO	NO
PHONE_DESC	Telephone number type description.	VARCHAR2(30)	STVTELE	STVTELE_DESC	NO	NO
PHONE_EXT	Phone extension.	VARCHAR2(10)	AORCONT SPRTELE	AORCONT_PHONE_EXT SPRTELE_PHONE_EXT	NO NO	NO
PHONE_NUMBER	Phone number.	VARCHAR2(12)	AORCONT SPRTELE	AORCONT_PHONE_NUMBER SPRTELE_PHONE_NUMBER	NO NO	NO
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	NO NO	NO
PHONE_TYPE	Telephone type code associated with the contact telephone number.	VARCHAR2(4)	AORCONT	AORCONT_TELE_CODE	NO	NO
PHONE_UNLIST_IND	Specifies if the phone number is unlisted.	VARCHAR2(1)	SPRTELE	SPRTELE_UNLIST_IND	NO	NO
POSTAL_CODE	Postal code for the organizational contact's address.	VARCHAR2(30)	AORCONT SPRADDR	AORCONT_ZIPC_CODE_ADDR SPRADDR_ZIP	NO NO	NO
PRIMARY_CONTACT_IND	Indicates whether this contact is the institution's primary contact.	VARCHAR2(1)	CALCULATION	CASE WHEN AORCONT_PRIMARY_IND	NO	NO
STATE_PROVINCE	State or province associated with this address.	VARCHAR2(3)	AORCONT SPRADDR	AORCONT_STAT_CODE_ADDR SPRADDR_STAT_CODE	NO NO	NO
STATE_PROVINCE_DESC	State/province description.	VARCHAR2(30)	STVSTAT	STVSTAT_DESC	NO	NO
STREET_LINE1	First line of the address.	VARCHAR2(75)	AORCONT SPRADDR	AORCONT_ADDR_LINE1 SPRADDR_STREET_LINE1	NO NO	NO
STREET_LINE2	Second line of the address.	VARCHAR2(75)	AORCONT SPRADDR	AORCONT_ADDR_LINE2 SPRADDR_STREET_LINE2	NO NO	NO
STREET_LINE3	Third line of the address.	VARCHAR2(75)	AORCONT SPRADDR	AORCONT_ADDR_LINE3 SPRADDR_STREET_LINE3	NO NO	NO
STREET_LINE4	Fourth line of the address.	VARCHAR2(75)	AORCONT SPRADDR	AORCONT_ADDR_LINE4 SPRADDR_STREET_LINE4	NO NO	NO
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO

Ver: