Reporting View Target: SOLICITOR_ASSIGNMENT

Go To View:	RETURN TO BANNER ODS META DATA REPORTS LIST
	Advancement Reporting View Reports

Banner Operational Data Store
Reporting View Target: SOLICITOR_ASSIGNMENT_RESULT

Description Contains data about the results of a solicitation contact. Information about results of an assigned contacts to either a campaign, type of solicitation, solicitor organization and or solicitor with the type of contact, results, date of solicitation, gift and pledge number.
Key & Frequency One occurrence per campaign per solicitation_type per solicitor_organization per solicitation_year per solicitor_uid per contact_sequence_number per sequence_number.
Recommended Search Columns CAMPAIGN_TYPE
CAMPAIGN, SOLICITATION_TYPE, SOLICITOR_ORGANIZATION, SOLICITOR_UID, ASSIGNMENT_SEQUENCE_NUMBER, SOLICITATION_YEAR, RESULT_SEQUENCE_NUMBER
SOLICITOR_UID
SOLICITOR_ORGANIZATION
CONTACT
RESULT

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target

ADMINISTRATIVE_GROUP Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)
NA

NA

NO
NO

ASSIGNMENT_RESULT_COMMENT Comments about the constituent contact result. VARCHAR2(2000)
AFRCRES

AFRCRES_COMMENT

NO
NO

ASSIGNMENT_SEQUENCE_NUMBER System-generated one-up number assigned to constituents assigned to a campaign, and or solicitation type, and or solicitor organization, and or solicitor in this record. NUMBER
AFRCRES

AFRCRES_CTYP_SEQ_NO

NO
NO

CAMPAIGN Campaign that the constituent has responded to with a gift or pledge payment. VARCHAR2(63)
AFRCRES

AFRCRES_CAMPAIGN

NO
NO

CAMPAIGN_NAME Campaign name. VARCHAR2(255)
AFBCAMP

AFBCAMP_NAME

NO
NO

CAMPAIGN_TYPE Type of campaign recorded. VARCHAR2(63)
AFBCAMP

AFBCAMP_CMTP_CODE

NO
NO

CAMPAIGN_TYPE_DESC Campaign type description. VARCHAR2(255)
ATVCMTP

ATVCMTP_DESC

NO
NO

CONTACT Type of contact made. VARCHAR2(63)
AFRCRES

AFRCRES_SCNT_CODE

NO
NO

CONTACT_DESC Contact description. VARCHAR2(255)
ATVSCNT

ATVSCNT_DESC

NO
NO

GIFT_NUMBER Number of the gift. VARCHAR2(63)
AFRCRES

AFRCRES_GIFT_NO

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

PLEDGE_NUMBER System assigned number of the pledge. VARCHAR2(63)
AFRCRES

AFRCRES_PLEDGE_NO

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

RESULT Result code used to determine the outcome of the constituent contact. For example, agreed to pledge, couldn't contact, or agreed to give. VARCHAR2(63)
AFRCRES

AFRCRES_SCRS_CODE

NO
NO

RESULT_DESC Result description. VARCHAR2(255)
ATVSCRS

ATVSCRS_DESC

NO
NO

RESULT_SEQUENCE_NUMBER System-generated one-up number assigned to a constituent contact result within a campaign, and or solicitation type, and or solicitor organization, and or solicitor in this record. NUMBER
AFRCRES

AFRCRES_SEQ_NO

NO
NO

SOLICITATION_DATE Date the constituent was contacted for a solicitation. DATE
AFRCRES

AFRCRES_DATE

NO
NO

SOLICITATION_IND Determines if the result ended as a solicitation. VARCHAR2(1)
ATVSCRS

ATVSCRS_SOLICITATION_IND

NO
NO

SOLICITATION_TYPE Solicitation type code. VARCHAR2(63)
AFRCRES

AFRCRES_SOLC_CODE

NO
NO

SOLICITATION_TYPE_DESC Solicitation type description. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

NO
NO

SOLICITATION_YEAR Year in which the solicitation ask amount should be made. VARCHAR2(63)
AFRCRES

AFRCRES_DCYR_CODE

NO
NO

SOLICITATION_YEAR_DESC Year description. VARCHAR2(255)
ATVDCYR

ATVDCYR_DCYR_DESC

NO
NO

SOLICITATION_YEAR_END_DATE Year end date. DATE
ATVDCYR

ATVDCYR_END_DATE

NO
NO

SOLICITATION_YEAR_START_DATE Year start date. DATE
ATVDCYR

ATVDCYR_START_DATE

NO
NO

SOLICITOR_ENTITY_IND Indicates whether this is a person or entity record. VARCHAR2(1)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO
NO

SOLICITOR_FIRST_NAME Solicitor first name. VARCHAR2(63)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO
NO

SOLICITOR_ID Solicitor current identification number. VARCHAR2(63)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO
NO

SOLICITOR_LAST_NAME Solicitor last name. VARCHAR2(63)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO
NO

SOLICITOR_NAME Name of the solicitor person (last name, first name, middle initial) or organization. VARCHAR2(255)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO
NO

SOLICITOR_ORGANIZATION Solicitor organization code. VARCHAR2(63)
AFRCRES

AFRCRES_SOL_ORG

NO
NO

SOLICITOR_ORGANIZATION_NAME Solicitor organization name. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

NO
NO

SOLICITOR_RESULT_ACTIVITY_DATE Date that information for this record in the table was entered or last updated. DATE
AFRCRES

AFRCRES_ACTIVITY_DATE

NO
NO

SOLICITOR_RESULT_USER_ID Unique identification code of the user who entered or last touched the transaction. VARCHAR2(63)
AFRCRES

AFRCRES_USER

NO
NO

SOLICITOR_UID System generated, unique, internal identification number assigned to this solicitor. NUMBER
AFRCRES

AFRCRES_PIDM

NO
NO

Ver: 9.2

Description	Contains data about the results of a solicitation contact. Information about results of an assigned contacts to either a campaign, type of solicitation, solicitor organization and or solicitor with the type of contact, results, date of solicitation, gift and pledge number.
Key & Frequency	One occurrence per campaign per solicitation_type per solicitor_organization per solicitation_year per solicitor_uid per contact_sequence_number per sequence_number.
Recommended Search Columns	CAMPAIGN_TYPE CAMPAIGN, SOLICITATION_TYPE, SOLICITOR_ORGANIZATION, SOLICITOR_UID, ASSIGNMENT_SEQUENCE_NUMBER, SOLICITATION_YEAR, RESULT_SEQUENCE_NUMBER SOLICITOR_UID SOLICITOR_ORGANIZATION CONTACT RESULT

Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
ASSIGNMENT_RESULT_COMMENT	Comments about the constituent contact result.	VARCHAR2(2000)	AFRCRES	AFRCRES_COMMENT	NO	NO
ASSIGNMENT_SEQUENCE_NUMBER	System-generated one-up number assigned to constituents assigned to a campaign, and or solicitation type, and or solicitor organization, and or solicitor in this record.	NUMBER	AFRCRES	AFRCRES_CTYP_SEQ_NO	NO	NO
CAMPAIGN	Campaign that the constituent has responded to with a gift or pledge payment.	VARCHAR2(63)	AFRCRES	AFRCRES_CAMPAIGN	NO	NO
CAMPAIGN_NAME	Campaign name.	VARCHAR2(255)	AFBCAMP	AFBCAMP_NAME	NO	NO
CAMPAIGN_TYPE	Type of campaign recorded.	VARCHAR2(63)	AFBCAMP	AFBCAMP_CMTP_CODE	NO	NO
CAMPAIGN_TYPE_DESC	Campaign type description.	VARCHAR2(255)	ATVCMTP	ATVCMTP_DESC	NO	NO
CONTACT	Type of contact made.	VARCHAR2(63)	AFRCRES	AFRCRES_SCNT_CODE	NO	NO
CONTACT_DESC	Contact description.	VARCHAR2(255)	ATVSCNT	ATVSCNT_DESC	NO	NO
GIFT_NUMBER	Number of the gift.	VARCHAR2(63)	AFRCRES	AFRCRES_GIFT_NO	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
PLEDGE_NUMBER	System assigned number of the pledge.	VARCHAR2(63)	AFRCRES	AFRCRES_PLEDGE_NO	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
RESULT	Result code used to determine the outcome of the constituent contact. For example, agreed to pledge, couldn't contact, or agreed to give.	VARCHAR2(63)	AFRCRES	AFRCRES_SCRS_CODE	NO	NO
RESULT_DESC	Result description.	VARCHAR2(255)	ATVSCRS	ATVSCRS_DESC	NO	NO
RESULT_SEQUENCE_NUMBER	System-generated one-up number assigned to a constituent contact result within a campaign, and or solicitation type, and or solicitor organization, and or solicitor in this record.	NUMBER	AFRCRES	AFRCRES_SEQ_NO	NO	NO
SOLICITATION_DATE	Date the constituent was contacted for a solicitation.	DATE	AFRCRES	AFRCRES_DATE	NO	NO
SOLICITATION_IND	Determines if the result ended as a solicitation.	VARCHAR2(1)	ATVSCRS	ATVSCRS_SOLICITATION_IND	NO	NO
SOLICITATION_TYPE	Solicitation type code.	VARCHAR2(63)	AFRCRES	AFRCRES_SOLC_CODE	NO	NO
SOLICITATION_TYPE_DESC	Solicitation type description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
SOLICITATION_YEAR	Year in which the solicitation ask amount should be made.	VARCHAR2(63)	AFRCRES	AFRCRES_DCYR_CODE	NO	NO
SOLICITATION_YEAR_DESC	Year description.	VARCHAR2(255)	ATVDCYR	ATVDCYR_DCYR_DESC	NO	NO
SOLICITATION_YEAR_END_DATE	Year end date.	DATE	ATVDCYR	ATVDCYR_END_DATE	NO	NO
SOLICITATION_YEAR_START_DATE	Year start date.	DATE	ATVDCYR	ATVDCYR_START_DATE	NO	NO
SOLICITOR_ENTITY_IND	Indicates whether this is a person or entity record.	VARCHAR2(1)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
SOLICITOR_FIRST_NAME	Solicitor first name.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
SOLICITOR_ID	Solicitor current identification number.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
SOLICITOR_LAST_NAME	Solicitor last name.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
SOLICITOR_NAME	Name of the solicitor person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
SOLICITOR_ORGANIZATION	Solicitor organization code.	VARCHAR2(63)	AFRCRES	AFRCRES_SOL_ORG	NO	NO
SOLICITOR_ORGANIZATION_NAME	Solicitor organization name.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
SOLICITOR_RESULT_ACTIVITY_DATE	Date that information for this record in the table was entered or last updated.	DATE	AFRCRES	AFRCRES_ACTIVITY_DATE	NO	NO
SOLICITOR_RESULT_USER_ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(63)	AFRCRES	AFRCRES_USER	NO	NO
SOLICITOR_UID	System generated, unique, internal identification number assigned to this solicitor.	NUMBER	AFRCRES	AFRCRES_PIDM	NO	NO