Target Column	Business Name	Business Definition	Database Data Type	Business Data Type	Domain Value	Source Name	Source Column	Local Source	Local Target
SOLICITOR_ORGANIZATION	Solicitor Organization	Solicitor organization code.	VARCHAR2(63)			ASBSORG	ASBSORG_SOL_ORG	NO	NO
SOLICITOR_ORGANIZATION_NAME	Solicitor Organization Name	Solicitor organization name.	VARCHAR2(255)			ASBSORG	ASBSORG_NAME	NO	NO
GIFT_SOCIETY_YEAR	Organization Year	Solicitor organization year.	VARCHAR2(63)			ASBSORG	ASBSORG_YEAR	NO	NO
ORGANIZATION_TYPE	Organization Type	Identifies the type of solicitor organization.	VARCHAR2(63)			ASBSORG	ASBSORG_SOTP_TYPE	NO	NO
ORGANIZATION_TYPE_DESC	Organization Type Description	Solicitor organization type description.	VARCHAR2(255)			ATVSOTP	ATVSOTP_DESC	NO	NO
COLLEGE	College	First level of the institution organization structure that owns the student or the academic instruction for a student course.	VARCHAR2(63)			ASBSORG	ASBSORG_COLL_CODE	NO	NO
COLLEGE_DESC	College Description	SolicOrganization college description.	VARCHAR2(255)			FUNCTION	GOKODSF.F_GET_DESC	NO	NO
ORGANIZATION_STATUS	Organization Status	Current organization status.	VARCHAR2(63)			ASBSORG	ASBSORG_SSTA_CODE	NO	NO
ORGANIZATION_STATUS_DESC	Organization Status Description	Organization status description.	VARCHAR2(255)			ATVSSTA	ATVSSTA_DESC	NO	NO
ACTIVE_ORGANIZATION_IND	Active Organization Indicator	Organization status active indicator. Determines if the status is active (Y)es, or inactive (N)o.	VARCHAR2(1)			ATVSSTA	ATVSSTA_ACTIVE_IND	NO	NO
ORG_PARTICIPATION_GOAL	Organization Participation Goal	Solicitor organization's goal for percentage of contacts who are expected to donate.	NUMBER			CALCULATION	NVL=(ASBSORG_PARTICIPATION_GOAL,0)	NO	NO
ORGANIZATION_GOAL	Organization Goal	Amount of the solicitor organization goal.	NUMBER			CALCULATION	NVL(ASBSORG_DOLLAR_GOAL,0)	NO	NO
PCT_PROGRESS_ORGANIZATION_GOAL	Percent Progress Organization Goal	Percentage of the solicitor organization goal that has been reached by the sum of gifts and outstanding pledges.	NUMBER			CALCULATION	(MAKFUNC.F_ORG_TOTAL_GIFTS + MAKFUNC.F_ORG_TOTAL_PLEDGES - MAKFUNC.F_ORG_PLEDGE_PAYMENTS) / ORGANIZATION_GOAL * 100	NO	NO
ORGANIZATION_DONOR_COUNT_GOAL	Organization Donor Count Goal	Solicitor organization's goal for the number of donors for the year.	NUMBER			CALCULATION	NVL(ASBSORG_DONOR_COUNT_GOAL,0)	NO	NO
PCT_PROGRESS_DONOR_COUNT_GOAL	Percent Progress Donor Count Goal	Percentage of the solicitor organization's donor count goal that has been reached by the sum of all donors for gifts and or outstanding pledges.	NUMBER			CALCULATION	MAKFUNC.F_ORG_TOTAL_DONOR_COUNT / ORGANIZATION_DONOR_COUNT_GOAL * 100	NO	NO
ORGANIZATION_TOTAL_PLEDGES	Organization Total Pledges	Total amount of pledges made as a result of this solicitor organization.	NUMBER			FUNCTION	MAKFUNC.F_ORG_TOTAL_PLEDGES	NO	NO
ORGANIZATION_PLEDGE_PAYMENTS	Organization Pledge Payments	Total amount of pledge payments received as a result of this solicitor organization.	NUMBER			FUNCTION	MAKFUNC.F_ORG_PLEDGE_PAYMENTS	NO	NO
ORGANIZATION_PLEDGE_BALANCE	Organization Pledge Balance	Total amount of outstanding pledges made as a result of this solicitor organization.	NUMBER			CALCULATION	MAKFUNC.F_ORG_TOTAL_PLEDGES - MAKFUNC.F_ORG_PLEDGE_PAYMENTS	NO	NO
ORGANIZATION_TOTAL_GIFTS	Organization Total Gifts	Total amount of gifts received as a result of this solicitor organization. This includes pledge payments and outright gifts.	NUMBER			FUNCTION	MAKFUNC.F_ORG_TOTAL_GIFTS	NO	NO
ORGANIZATION_OUTRIGHT_GIFTS	Organization Outright Gifts	Total amount of outright gifts received as a result of this solicitor organization.	NUMBER			FUNCTION	MAKFUNC.F_ORG_OUTRIGHT_GIFTS	NO	NO
ORG_PLEDGE_DONOR_COUNT	Organization Pledge Donor Count	Total number of donors who made one or more pledges as a result of this solicitor organization. This includes original donors and any individuals who received hard credit.	NUMBER			FUNCTION	MAKFUNC.F_ORG_PLEDGE_DONOR_COUNT	NO	NO
ORGANIZATION_PLEDGE_COUNT	Organization Pledge Count	Total number of pledges made as a result of this solicitor organization.	NUMBER			FUNCTION	MAKFUNC.F_ORG_PLEDGE_COUNT	NO	NO
ORGANIZATION_TOTAL_DONOR_COUNT	Organization Total Donor Count	Total number of donors who have made one or more gifts as a result of this solicitor organization. This includes donors who have received hard credit from gifts and includes pledges made with no payment received to date.	NUMBER			FUNCTION	MAKFUNC.F_ORG_TOTAL_DONOR_COUNT	NO	NO
ORG_PLEDGE_DONOR_PAID_COUNT	Organization Pledge Donor Paid Count	Total number of donors who have made payments toward their pledges for this solicitor organization. This could be fully paid or partial paid.	NUMBER			FUNCTION	MAKFUNC.F_ORG_TOTAL_DONOR_COUNT	NO	NO
ORG_PLEDGE_DONOR_NO_PAY_COUNT	Organization Pledge Donor No Pay Count	Total number of donors who have not made any payments toward their pledges to this solicitor organization.	NUMBER			FUNCTION	MAKFUNC.F_ORG_PLEDGE_DONOR_NP_COUNT	NO	NO
ORG_OUTRIGHT_GIFT_DONOR_COUNT	Organization Outright Gift Donor Count	Total number of donors who made one or more outright gifts to this solicitor organization.	NUMBER			FUNCTION	MAKFUNC.F_ORG_OUTRIGHT_DONOR_COUNT	NO	NO
ORGANIZATION_TOTAL_GIFT_COUNT	Organization Total Gift Count	Total number of gifts made to this solicitor organization. This includes both payments and outright gifts.	NUMBER			FUNCTION	MAKFUNC.F_ORG_TOTAL_GIFT_COUNT	NO	NO
ORG_OUTRIGHT_GIFT_COUNT	Organization Outright Gift Count	Total number of outright gifts made to this solicitor organization.	NUMBER			FUNCTION	MAKFUNC.F_ORG_OUTRIGHT_GIFT_COUNT	NO	NO
ALLOW_WEB_UPDATE_IND	Allow Web Update Indicator	Determines if the organization can be updated via the web. (Y)es, the organization can be updated via the web, (N)o, the organization cannot be updated via the web.	VARCHAR2(1)			CALCULATION	ASBSORG_UPD_WEB_IND	NO	NO
CONTACT_ENTITY_UID	Contact Entity UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER			ASBSORG	ASBSORG_CONTACT_PIDM	NO	NO
CONTACT_ID	Contact ID	Current identification number for the contact person or organization.	VARCHAR2(63)			FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
CONTACT_ENTITY_IND	Contact Entity Indicator	Indicates whether the contact entity is a person or an organization.	VARCHAR2(1)			FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
CONTACT_NAME	Contact Name	Name of the person or organization to contact (last name, first name, middle initial).	VARCHAR2(255)			FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
CONTACT_ADDRESS_TYPE	Contact Address Type	Type of address for the contact.	VARCHAR2(63)			ASBSORG	ASBSORG_ATYP_CODE	NO	NO
CONTACT_ADDRESS_TYPE_DESC	Contact Address Type Description	Address type description for the contact.	VARCHAR2(255)			FUNCTION	GOKODSF.F_GET_DESC	NO	NO
CONTACT_STREET_LINE1	Contact Street Line 1	First line of the organization contact's address.	VARCHAR2(255)			SPRADDR	SPRADDR_STREET_LINE1	NO	NO
CONTACT_STREET_LINE2	Contact Street Line 2	Second line of the organization contact's address.	VARCHAR2(255)			SPRADDR	SPRADDR_STREET_LINE2	NO	NO
CONTACT_STREET_LINE3	Contact Street Line 3	Third line of the organization contact's address.	VARCHAR2(255)			SPRADDR	SPRADDR_STREET_LINE3	NO	NO
CONTACT_STREET_LINE4	Contact Street Line 4	Fourth line of the organization contact's address.	VARCHAR2(255)			SPRADDR	SPRADDR_STREET_LINE4	NO	NO
CONTACT_CITY	Contact City	Address, city, town or municipality of the organization contact's address.	VARCHAR2(63)			SPRADDR	SPRADDR_CITY	NO	NO
CONTACT_COUNTY	Contact County	County of the organization contact's address.	VARCHAR2(63)			SPRADDR	SPRADDR_CNTY_CODE	NO	NO
CONTACT_COUNTY_DESC	Contact County Description	County description of the organization contact's address.	VARCHAR2(255)			STVCNTY	STVCNTY_DESC	NO	NO
CONTACT_STATE_PROVINCE	Contact State Province	State or province of the organization contact's address.	VARCHAR2(63)			SPRADDR	SPRADDR_STAT_CODE	NO	NO
CONTACT_STATE_PROVINCE_DESC	Contact State Province Description	State/province description of the organization contact's address.	VARCHAR2(255)			STVSTAT	STVSTAT_DESC	NO	NO
CONTACT_POSTAL_CODE	Contact Postal Code	Address postal code associated with the organization contact's address.	VARCHAR2(63)			SPRADDR	SPRADDR_ZIP	NO	NO
CONTACT_NATION	Contact Nation	Nation/country code of the organization contact's address.	VARCHAR2(63)			SPRADDR	SPRADDR_NATN_CODE	NO	NO
CONTACT_NATION_DESC	Contact Nation Description	Address nation/county description of the organization contact's address.	VARCHAR2(255)			STVNATN	STVNATN_NATION	NO	NO
ORGANIZATION_ACTIVITY_DATE	Organization Activity Date	Date information for this record in the table was entered or last updated.	DATE			ASBSORG	ASBSORG_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