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
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	NVL(ASBSORG_UPD_WEB_IND)
COLLEGE	College	College associated with the solicitor organization.	VARCHAR2(2)		ASBSORG	ASBSORG_COLL_CODE
COLLEGE_DESC	College Description	SolicOrganization college description.	VARCHAR2(30)		FUNCTION	GOKODSF.F_GET_DESC
CONTACT_ADDRESS_TYPE	Contact Address Type	Type of address for the contact.	VARCHAR2(2)		ASBSORG	ASBSORG_ATYP_CODE
CONTACT_ADDRESS_TYPE_DESC	Contact Address Type Description	Address type description for the contact.	VARCHAR2(30)		FUNCTION	GOKODSF.F_GET_DESC
CONTACT_ENTITY_UID	Contact Entity UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER(8)		ASBSORG	ASBSORG_CONTACT_PIDM
CURRENT_DATE	Current Date	System current date (sysdate) or date the data was extracted.	DATE		NA	NA
DOMAIN_VALUE	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	Gift Society Year	Solicitor organization year.	VARCHAR2(4)		ASBSORG	ASBSORG_YEAR
GIFT_SOCIETY_YEAR_DESC	Gift Society Year Description	Gift society club year description.	VARCHAR2(30)		ATVDCYR	ATVDCYR_DESC
MIF_DESC	MIF Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)		NA	NA
MIF_VALUE	MIF Value	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)		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,)
ORGANIZATION_GOAL	Organization Goal	Amount of the solicitor organization goal.	NUMBER		CALCULATION	NVL(ASBSORG_DOLLAR_GOAL,)
ORGANIZATION_STATUS	Organization Status	Current organization status.	VARCHAR2(1)		ASBSORG	ASBSORG_SSTA_CODE
ORGANIZATION_STATUS_DESC	Organization Status Description	Organization status description.	VARCHAR2(30)		ATVSSTA	ATVSSTA_DESC
ORGANIZATION_TYPE	Organization Type	Identifies the type of solicitor organization.	VARCHAR2(2)		ASBSORG	ASBSORG_SOTP_TYPE
ORGANIZATION_TYPE_DESC	Organization Type Description	Solicitor organization type description.	VARCHAR2(30)		ATVSOTP	ATVSOTP_DESC
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)
SOLICITOR_ORGANIZATION	Solicitor Organization	Solicitor organization code.	VARCHAR2(5)		ASBSORG	ASBSORG_SOL_ORG
SOLICITOR_ORGANIZATION_NAME	Solicitor Organization Name	Solicitor organization name.	VARCHAR2(60)		ASBSORG	ASBSORG_NAME
ZONE_VALUE	Zone Value	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)		NA	NA

Ver: