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
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	NVL(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(2)	ASBSORG	ASBSORG_COLL_CODE
COLLEGE_DESC	SolicOrganization college description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC
CONTACT_ADDRESS_TYPE	Type of address for the contact.	VARCHAR2(2)	ASBSORG	ASBSORG_ATYP_CODE
CONTACT_ADDRESS_TYPE_DESC	Address type description for the contact.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC
CONTACT_ENTITY_UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER	ASBSORG	ASBSORG_CONTACT_PIDM
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	NA
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA
GIFT_SOCIETY_YEAR	Solicitor organization year.	VARCHAR2(4)	ASBSORG	ASBSORG_YEAR
GIFT_SOCIETY_YEAR_DESC	Gift society club year description.	VARCHAR2(30)	ATVDCYR	ATVDCYR_DESC
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	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,)
ORGANIZATION_GOAL	Amount of the solicitor organization goal.	NUMBER	CALCULATION	NVL(ASBSORG_DOLLAR_GOAL,)
ORGANIZATION_STATUS	Current organization status.	VARCHAR2(1)	ASBSORG	ASBSORG_SSTA_CODE
ORGANIZATION_STATUS_DESC	Organization status description.	VARCHAR2(30)	ATVSSTA	ATVSSTA_DESC
ORGANIZATION_TYPE	Identifies the type of solicitor organization.	VARCHAR2(2)	ASBSORG	ASBSORG_SOTP_TYPE
ORGANIZATION_TYPE_DESC	Solicitor organization type description.	VARCHAR2(30)	ATVSOTP	ATVSOTP_DESC
ORG_PARTICIPATION_GOAL	Solicitor organization's goal for percentage of contacts who are expected to donate.	NUMBER	CALCULATION	NVL=(ASBSORG_PARTICIPATION_GOAL,0)
SOLICITOR_ORGANIZATION	Solicitor organization code.	VARCHAR2(5)	ASBSORG	ASBSORG_SOL_ORG
SOLICITOR_ORGANIZATION_NAME	Solicitor organization name.	VARCHAR2(60)	ASBSORG	ASBSORG_NAME
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA

Ver: