Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ADDRESS_NAME	Name to be used with the preferred address type.	VARCHAR2(120)	APBCONS	APBCONS_ADDR_NAME	NO	NO
BUSINESS	This field specifies the organizations general category of business.	VARCHAR2(30)	NA	NA	NO	NO
COMBINED_MAILING_NAME	Combined mailing name for the constituent.	VARCHAR2(120)	APBCONS	APBCONS_CM_NAME	NO	NO
COMB_MAILING_ADDR_TYPE	Address type to be used for the combined mailing.	VARCHAR2(2)	APBCONS	APBCONS_ATYP_CODE_CM	NO	NO
COMB_MAILING_ADDR_TYPE_DESC	Address type description.	VARCHAR2(30)	STVATYP	STVATYP_DESC	NO	NO
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE	NO	NO
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO
DONOR_IND	Indicates whether the organization constituent or constituent has been a donor.	VARCHAR2(1)	FUNCTION	F_DONOR_IND	NO	NO
ENTITY_IND	This is the indicator that specifies if the consituent is a 'P'erson or 'O'rganization.	VARCHAR2(1)	CONSTANT	'P'	NO	NO
ENTITY_UID	System generated number that is internally generated to uniquely identify the person.	NUMBER	APBCONS	APBCONS_PIDM	NO	NO
FEDERAL_IDENTIFICATION	This field specifies the organizations federal identification number.	VARCHAR2(9)	NA	NA	NO	NO
GRADUATION_NAME	Constituent's name at the time of college graduation.	VARCHAR2(120)	APBCONS	APBCONS_GRAD_NAME	NO	NO
HIGHEST_GIFT_AMOUNT	Highest gift ever received from the constituent.	NUMBER	APBGHIS	APBGHIS_HIGH_GIFT_AMT	NO	NO
HIGHEST_GIFT_DATE	Date of the highest gift ever received from the constituent.	DATE	APBGHIS	APBGHIS_HIGH_GIFT_DATE	NO	NO
HIGHEST_GIFT_FISCAL_YEAR	Fiscal year associated with the highest gift ever received from the constituent.	NUMBER	APBGHIS	APBGHIS_FISC_CODE_HIGH_GIFT	NO	NO
HIGHEST_GIFT_FISCAL_YEAR_DESC	Description of the highest fiscal year.	VARCHAR2(30)	ATVFISC	ATVFISC_DESC	NO	NO
HIGHEST_GIFT_NUMBER	Gift number of the highest gift ever received from the constituent.	VARCHAR2(7)	AGBGIFT	AGBGIFT_GIFT_NO	NO	NO
HOMETOWN	Constituent's hometown.	VARCHAR2(50)	APBCONS	APBCONS_HOME_CITY	NO	NO
HOMETOWN_NATION	Country of the constituent's hometown.	VARCHAR2(5)	APBCONS	APBCONS_NATN_CODE_HOME	NO	NO
HOMETOWN_NATION_DESC	Nation/country description.	VARCHAR2(30)	STVNATN	STVNATN_NATION	NO	NO
HOMETOWN_STATE	State of the constituent's hometown.	VARCHAR2(3)	APBCONS	APBCONS_STAT_CODE_HOME	NO	NO
HOMETOWN_STATE_DESC	State/province name.	VARCHAR2(30)	STVSTAT	STVSTAT_DESC	NO	NO
INCOME_LEVEL	Constituent's income level.	VARCHAR2(2)	APBCONS	APBCONS_INCM_CODE	NO	NO
INCOME_LEVEL_DESC	Income level code description.	VARCHAR2(30)	ATVINCM	ATVINCM_DESC	NO	NO
JOB_CATEGORY	This field specifies the job category associated with the organizational contacts title.	VARCHAR2(3)	NA	NA	NO	NO
JOB_CATEGORY_DESC	This field specifies the description of the job category code.	VARCHAR2(30)	NA	NA	NO	NO
LIFE_GIFT_SOCIETY	Lifetime gift society.	VARCHAR2(4)	FUNCTION	AOKODSF.F_LIFE_GIFT_SOCIETY	NO	NO
LIFE_GIFT_SOCIETY_DESC	Lifetime gift society description.	VARCHAR2(60)	ATVDCNP	ATVDCNP_DESC	NO	NO
LIFE_GIFT_SOCIETY_TYPE	Lifetime gift society type.	VARCHAR2(2)	FUNCTION	AOKODSF.F_LIFE_GIFT_SOCIETY	NO	NO
LIFE_GIFT_SOCIETY_TYPE_DESC	Lifetime gift society type description.	VARCHAR2(30)	ATVDCST	ATVDCST_DESC	NO	NO
LIFE_TOTAL_COMMITMENT	Lifetime total commitments.	NUMBER	FUNCTION	F_LIFE_TOTAL_COMMITMENT	NO	NO
LIFE_TOTAL_GIVING	Lifetime total giving.	NUMBER	FUNCTION	F_LIFE_TOTAL_GIVING	NO	NO
LIFE_TOTAL_PLEDGE_AMT	Lifetime total pledged amount.	NUMBER	FUNCTION	F_LIFE_TOTAL_PLEDGED_AMOUNT	NO	NO
LIFE_TOTAL_PLEDGE_PAY	Lifetime total pledge payments.	NUMBER	FUNCTION	F_LIFE_TOTAL_PLEDGE_PAYMENT	NO	NO
LOST_ALUMNUS_IND	Lost alumnus indicator.	VARCHAR2(1)	FUNCTION	F_LOST_AL_IND	NO	NO
MAIDEN_LAST_NAME	Constituent's maiden name.	VARCHAR2(25)	APBCONS	APBCONS_MAIDEN_LAST_NAME	NO	NO
MATCHING_GIFT_PERCENT	This field specifies the organizations matching gift percentage.	NUMBER	NA	NA	NO	NO
MATCHING_GIFT_UID	Internal Id number for the matching gift company associated with the organization. The id may be the same id or the parent id.	NUMBER	NA	NA	NO	NO
MATCH_MAXIMUM	The maximum matching gift amount allowed.	NUMBER	NA	NA	NO	NO
MATCH_MINIMUM	Minimum amount organization will match.	NUMBER	NA	NA	NO	NO
MAX_MATCH_ORG_EMPL_YEAR	Maximum corporate matching gift payout per employee per year.	NUMBER	NA	NA	NO	NO
MAX_PERSON_MATCH_AMOUNT	Amount an employee can be matched per year.	NUMBER	NA	NA	NO	NO
MAX_YEAR_DONATE_AMOUNT	Amount the organization will donate to an institution per year.	NUMBER	NA	NA	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
MOST_RECENT_GIFT_AMT	Most recent gift amount.	NUMBER	AGBGIFT	AGBGIFT_AMT_TOT	NO	NO
MOST_RECENT_GIFT_DATE	Most recent gift date.	DATE	AGBGIFT	AGBGIFT_GIFT_DATE	NO	NO
MOST_RECENT_GIFT_NUMBER	Most recent gift number.	VARCHAR2(7)	AGBGIFT	AGBGIFT_GIFT_NO	NO	NO
MOST_RECENT_PLEDGE_AMT	Most recent pledge amount.	NUMBER	AGBPLDG	AGBPLDG_AMT_PLEDGED	NO	NO
MOST_RECENT_PLEDGE_DATE	Most recent pledge date.	DATE	AGBPLDG	AGBPLDG_PLEDGE_DATE	NO	NO
MOST_RECENT_PLEDGE_NUMBER	Most recent pledge number.	VARCHAR2(7)	AGBPLDG	AGBPLDG_PLEDGE_NO	NO	NO
MULTIPLE_RATIOS_IND	This field specifies if multiple ratios exist for the id.	VARCHAR2(1)	NA	NA	NO	NO
NICKNAME	Nickname used by the constituent.	VARCHAR2(40)	APBCONS	APBCONS_NICKNAME	NO	NO
OCCUPATIONAL_TITLE	Constituent's occupational title.	VARCHAR2(4)	APBCONS	APBCONS_DOTT_CODE	NO	NO
OCCUPATIONAL_TITLE_DESC	Occupation code description.	VARCHAR2(60)	ATVDOTT	ATVDOTT_DESC	NO	NO
PARENTS_NAME	Name of the constituent's parents.	VARCHAR2(50)	APBCONS	APBCONS_PARENTS_NAME	NO	NO
PREF_ADDRESS_TYPE	This field specifies the address to use for the organizational contact.	VARCHAR2(2)	APBCONS	APBCONS_ATYP_CODE_PREF	NO	NO
PREF_ADDRESS_TYPE_DESC	This field identifies the address type associated with the type code.	VARCHAR2(30)	STVATYP	STVATYP_DESC	NO	NO
PREF_ADDR_TYPE_GEOR	Address type for the address to be used as the preferred geographic region address.	VARCHAR2(2)	APBCONS	APBCONS_ATYP_CODE_GEOR	NO	NO
PREF_ADDR_TYPE_GEOR_DESC	Geographic region for the address description.	VARCHAR2(30)	STVATYP	STVATYP_DESC	NO	NO
PREF_CLASS	Year in which the constituent received the first degree, or the year of expected graduation if the first degree has not been earned.	VARCHAR2(4)	APBCONS	APBCONS_PREF_CLAS	NO	NO
PREF_CLASS_DESC	This field specifies the class (e.g. freshman, sophomore, first year law, etc.) associated with the class code.	VARCHAR2(30)	NA	NA	NO	NO
PREF_COLLEGE	College within the institution with which the constituent prefers to be associated.	VARCHAR2(2)	APBCONS	APBCONS_COLL_CODE_PREF	NO	NO
PREF_COLLEGE_DESC	College, faculty or school name.	VARCHAR2(30)	STVCOLL	STVCOLL_DESC	NO	NO
PREF_FIRST_NAME	Preferred first name of the constituent.	VARCHAR2(60)	APBCONS	APBCONS_PREF_FIRST_NAME	NO	NO
PREF_LAST_NAME	Preferred last name of the constituent.	VARCHAR2(60)	APBCONS	APBCONS_PREF_LAST_NAME	NO	NO
PREF_MIDDLE_INITIAL	Preferred middle initial of the constituent.	VARCHAR2(60)	APBCONS	APBCONS_PREF_MI	NO	NO
PRIMARY_DONOR_CATEGORY	This is the preferred donor code.	VARCHAR2(4)	ATVDONR	ATVDONR_CODE	NO	NO
PRIMARY_DONOR_CATEGORY_DESC	This is the description of preferred donor code.	VARCHAR2(30)	ATVDONR	ATVDONR_DESC	NO	NO
PROSPECT_IND	Indicates whether the person has a prospect record.	VARCHAR2(1)	FUNCTION	F_PROSPECT_IND	NO	NO
SOCIETY_NAME	Gift society name.	VARCHAR2(120)	APBCONS	APBCONS_SOCIETY_NAME	NO	NO
STANDARD_INDUSTRY	This field specifies the organizations standard industry code.	VARCHAR2(4)	NA	NA	NO	NO
STANDARD_INDUSTRY_DESC	This field specifies the description of the SIC.	VARCHAR2(30)	NA	NA	NO	NO
ZONE_VALUE	Institution value of the process-oriented identifier for the record used to determine access authorization to this record.	VARCHAR2(6)	NA	NA	NO	NO

Ver: