Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
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
ADMINISTRATIVE_GROUP	Administrative Group	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)		NA	NA
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
COLLEGE	College	College associated with the solicitor organization.	VARCHAR2(63)		ASBSORG	ASBSORG_COLL_CODE
COLLEGE_DESC	College Description	SolicOrganization college description.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
CONTACT_ADDRESS_TYPE	Contact Address Type	Type of address for the contact.	VARCHAR2(63)		ASBSORG	ASBSORG_ATYP_CODE
CONTACT_ADDRESS_TYPE_DESC	Contact Address Type Description	Address type description for the contact.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
CONTACT_CITY	Contact City	Address, city, town or municipality of the organization contact's address.	VARCHAR2(63)		SPRADDR	SPRADDR_CITY
CONTACT_COUNTY	Contact County	County of the organization contact's address.	VARCHAR2(63)		SPRADDR	SPRADDR_CNTY_CODE
CONTACT_COUNTY_DESC	Contact County Description	County description of the organization contact's address.	VARCHAR2(255)		STVCNTY	STVCNTY_DESC
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
CONTACT_ENTITY_UID	Contact Entity UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER		ASBSORG	ASBSORG_CONTACT_PIDM
CONTACT_ID	Contact ID	Current identification number for the contact person or organization.	VARCHAR2(63)		FUNCTION	MGKFUNC.F_GET_PERSON_INFO
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
CONTACT_NATION	Contact Nation	Nation/country code of the organization contact's address.	VARCHAR2(63)		SPRADDR	SPRADDR_NATN_CODE
CONTACT_NATION_DESC	Contact Nation Description	Address nation/county description of the organization contact's address.	VARCHAR2(255)		STVNATN	STVNATN_NATION
CONTACT_POSTAL_CODE	Contact Postal Code	Address postal code associated with the organization contact's address.	VARCHAR2(63)		SPRADDR	SPRADDR_ZIP
CONTACT_STATE_PROVINCE	Contact State Province	State or province of the organization contact's address.	VARCHAR2(63)		SPRADDR	SPRADDR_STAT_CODE
CONTACT_STATE_PROVINCE_DESC	Contact State Province Description	State/province description of the organization contact's address.	VARCHAR2(255)		STVSTAT	STVSTAT_DESC
CONTACT_STREET_LINE1	Contact Street Line 1	First line of the organization contact's address.	VARCHAR2(255)		SPRADDR	SPRADDR_STREET_LINE1
CONTACT_STREET_LINE2	Contact Street Line 2	Second line of the organization contact's address.	VARCHAR2(255)		SPRADDR	SPRADDR_STREET_LINE2
CONTACT_STREET_LINE3	Contact Street Line 3	Third line of the organization contact's address.	VARCHAR2(255)		SPRADDR	SPRADDR_STREET_LINE3
CONTACT_STREET_LINE4	Contact Street Line 4	Fourth line of the organization contact's address.	VARCHAR2(255)		SPRADDR	SPRADDR_STREET_LINE4
GIFT_SOCIETY_YEAR	Organization Year	Solicitor organization year.	VARCHAR2(63)		ASBSORG	ASBSORG_YEAR
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)		NA	NA
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)		NA	NA
ORGANIZATION_ACTIVITY_DATE	Organization Activity Date	Date information for this record in the table was entered or last updated.	DATE		ASBSORG	ASBSORG_ACTIVITY_DATE
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)
ORGANIZATION_GOAL	Organization Goal	Amount of the solicitor organization goal.	NUMBER		CALCULATION	NVL(ASBSORG_DOLLAR_GOAL,0)
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
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
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
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
ORGANIZATION_STATUS	Organization Status	Current organization status.	VARCHAR2(63)		ASBSORG	ASBSORG_SSTA_CODE
ORGANIZATION_STATUS_DESC	Organization Status Description	Organization status description.	VARCHAR2(255)		ATVSSTA	ATVSSTA_DESC
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
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
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
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
ORGANIZATION_TYPE	Organization Type	Identifies the type of solicitor organization.	VARCHAR2(63)		ASBSORG	ASBSORG_SOTP_TYPE
ORGANIZATION_TYPE_DESC	Organization Type Description	Solicitor organization type description.	VARCHAR2(255)		ATVSOTP	ATVSOTP_DESC
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
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
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)
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
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
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
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
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
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)		NA	NA
SOLICITOR_ORGANIZATION	Solicitor Organization	Solicitor organization code.	VARCHAR2(63)		ASBSORG	ASBSORG_SOL_ORG
SOLICITOR_ORGANIZATION_NAME	Solicitor Organization Name	Solicitor organization name.	VARCHAR2(255)		ASBSORG	ASBSORG_NAME

Ver: 9.0