Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ACTIVE_ORGANIZATION_IND	Organization status active indicator. Determines if the status is active (Y)es, or inactive (N)o.	VARCHAR2(1)	ATVSSTA	ATVSSTA_ACTIVE_IND	NO	NO
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
ALLOW_WEB_UPDATE_IND	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
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	SolicOrganization college description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
CONTACT_ADDRESS_TYPE	Type of address for the contact.	VARCHAR2(63)	ASBSORG	ASBSORG_ATYP_CODE	NO	NO
CONTACT_ADDRESS_TYPE_DESC	Address type description for the contact.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
CONTACT_CITY	Address, city, town or municipality of the organization contact's address.	VARCHAR2(63)	SPRADDR	SPRADDR_CITY	NO	NO
CONTACT_COUNTY	County of the organization contact's address.	VARCHAR2(63)	SPRADDR	SPRADDR_CNTY_CODE	NO	NO
CONTACT_COUNTY_DESC	County description of the organization contact's address.	VARCHAR2(255)	STVCNTY	STVCNTY_DESC	NO	NO
CONTACT_ENTITY_IND	Indicates whether the contact entity is a person or an organization.	VARCHAR2(1)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
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	Current identification number for the contact person or organization.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
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_NATION	Nation/country code of the organization contact's address.	VARCHAR2(63)	SPRADDR	SPRADDR_NATN_CODE	NO	NO
CONTACT_NATION_DESC	Address nation/county description of the organization contact's address.	VARCHAR2(255)	STVNATN	STVNATN_NATION	NO	NO
CONTACT_POSTAL_CODE	Address postal code associated with the organization contact's address.	VARCHAR2(63)	SPRADDR	SPRADDR_ZIP	NO	NO
CONTACT_STATE_PROVINCE	State or province of the organization contact's address.	VARCHAR2(63)	SPRADDR	SPRADDR_STAT_CODE	NO	NO
CONTACT_STATE_PROVINCE_DESC	State/province description of the organization contact's address.	VARCHAR2(255)	STVSTAT	STVSTAT_DESC	NO	NO
CONTACT_STREET_LINE1	First line of the organization contact's address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE1	NO	NO
CONTACT_STREET_LINE2	Second line of the organization contact's address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE2	NO	NO
CONTACT_STREET_LINE3	Third line of the organization contact's address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE3	NO	NO
CONTACT_STREET_LINE4	Fourth line of the organization contact's address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE4	NO	NO
GIFT_SOCIETY_YEAR	Solicitor organization year.	VARCHAR2(63)	ASBSORG	ASBSORG_YEAR	NO	NO
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	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA	NO	NO
ORGANIZATION_ACTIVITY_DATE	Date information for this record in the table was entered or last updated.	DATE	ASBSORG	ASBSORG_ACTIVITY_DATE	NO	NO
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
ORGANIZATION_GOAL	Amount of the solicitor organization goal.	NUMBER	CALCULATION	NVL(ASBSORG_DOLLAR_GOAL,0)	NO	NO
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
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_PLEDGE_COUNT	Total number of pledges made as a result of this solicitor organization.	NUMBER	FUNCTION	MAKFUNC.F_ORG_PLEDGE_COUNT	NO	NO
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_STATUS	Current organization status.	VARCHAR2(63)	ASBSORG	ASBSORG_SSTA_CODE	NO	NO
ORGANIZATION_STATUS_DESC	Organization status description.	VARCHAR2(255)	ATVSSTA	ATVSSTA_DESC	NO	NO
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
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_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
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_TYPE	Identifies the type of solicitor organization.	VARCHAR2(63)	ASBSORG	ASBSORG_SOTP_TYPE	NO	NO
ORGANIZATION_TYPE_DESC	Solicitor organization type description.	VARCHAR2(255)	ATVSOTP	ATVSOTP_DESC	NO	NO
ORG_OUTRIGHT_GIFT_COUNT	Total number of outright gifts made to this solicitor organization.	NUMBER	FUNCTION	MAKFUNC.F_ORG_OUTRIGHT_GIFT_COUNT	NO	NO
ORG_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
ORG_PARTICIPATION_GOAL	Solicitor organization's goal for percentage of contacts who are expected to donate.	NUMBER	CALCULATION	NVL=(ASBSORG_PARTICIPATION_GOAL,0)	NO	NO
ORG_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
ORG_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_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
PCT_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
PCT_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
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
SOLICITOR_ORGANIZATION	Solicitor organization code.	VARCHAR2(63)	ASBSORG	ASBSORG_SOL_ORG	NO	NO
SOLICITOR_ORGANIZATION_NAME	Solicitor organization name.	VARCHAR2(255)	ASBSORG	ASBSORG_NAME	NO	NO

Ver: 9.2