Target Column	Business Definition	Database Data Type	Source Name	Source Column
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
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
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
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
COLLEGE_DESC	SolicOrganization college description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
CONTACT_ADDRESS_TYPE	Type of address for the contact.	VARCHAR2(63)	ASBSORG	ASBSORG_ATYP_CODE
CONTACT_ADDRESS_TYPE_DESC	Address type description for the contact.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
CONTACT_CITY	Address, city, town or municipality of the organization contact's address.	VARCHAR2(63)	SPRADDR	SPRADDR_CITY
CONTACT_COUNTY	County of the organization contact's address.	VARCHAR2(63)	SPRADDR	SPRADDR_CNTY_CODE
CONTACT_COUNTY_DESC	County description of the organization contact's address.	VARCHAR2(255)	STVCNTY	STVCNTY_DESC
CONTACT_ENTITY_IND	Indicates whether the contact entity is a person or an organization.	VARCHAR2(1)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
CONTACT_ENTITY_UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER	ASBSORG	ASBSORG_CONTACT_PIDM
CONTACT_ID	Current identification number for the contact person or organization.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
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	Nation/country code of the organization contact's address.	VARCHAR2(63)	SPRADDR	SPRADDR_NATN_CODE
CONTACT_NATION_DESC	Address nation/county description of the organization contact's address.	VARCHAR2(255)	STVNATN	STVNATN_NATION
CONTACT_POSTAL_CODE	Address postal code associated with the organization contact's address.	VARCHAR2(63)	SPRADDR	SPRADDR_ZIP
CONTACT_STATE_PROVINCE	State or province of the organization contact's address.	VARCHAR2(63)	SPRADDR	SPRADDR_STAT_CODE
CONTACT_STATE_PROVINCE_DESC	State/province description of the organization contact's address.	VARCHAR2(255)	STVSTAT	STVSTAT_DESC
CONTACT_STREET_LINE1	First line of the organization contact's address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE1
CONTACT_STREET_LINE2	Second line of the organization contact's address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE2
CONTACT_STREET_LINE3	Third line of the organization contact's address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE3
CONTACT_STREET_LINE4	Fourth line of the organization contact's address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE4
GIFT_SOCIETY_YEAR	Solicitor organization year.	VARCHAR2(63)	ASBSORG	ASBSORG_YEAR
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
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	Solicitor organization's goal for the number of donors for the year.	NUMBER	CALCULATION	NVL(ASBSORG_DONOR_COUNT_GOAL,0)
ORGANIZATION_GOAL	Amount of the solicitor organization goal.	NUMBER	CALCULATION	NVL(ASBSORG_DOLLAR_GOAL,0)
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	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	Total number of pledges made as a result of this solicitor organization.	NUMBER	FUNCTION	MAKFUNC.F_ORG_PLEDGE_COUNT
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	Current organization status.	VARCHAR2(63)	ASBSORG	ASBSORG_SSTA_CODE
ORGANIZATION_STATUS_DESC	Organization status description.	VARCHAR2(255)	ATVSSTA	ATVSSTA_DESC
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	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	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	Total amount of pledges made as a result of this solicitor organization.	NUMBER	FUNCTION	MAKFUNC.F_ORG_TOTAL_PLEDGES
ORGANIZATION_TYPE	Identifies the type of solicitor organization.	VARCHAR2(63)	ASBSORG	ASBSORG_SOTP_TYPE
ORGANIZATION_TYPE_DESC	Solicitor organization type description.	VARCHAR2(255)	ATVSOTP	ATVSOTP_DESC
ORG_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	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	Solicitor organization's goal for percentage of contacts who are expected to donate.	NUMBER	CALCULATION	NVL=(ASBSORG_PARTICIPATION_GOAL,0)
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
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
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
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
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
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 code.	VARCHAR2(63)	ASBSORG	ASBSORG_SOL_ORG
SOLICITOR_ORGANIZATION_NAME	Solicitor organization name.	VARCHAR2(255)	ASBSORG	ASBSORG_NAME

Ver: 9.1