Reporting View Target: SOLICITOR_ASSIGNMENT

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

SGHE 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

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

NA

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

AFRCRES_COMMENT

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

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

AFRCRES_CAMPAIGN

CAMPAIGN_NAME Campaign name. VARCHAR2(255)
AFBCAMP

AFBCAMP_NAME

CAMPAIGN_TYPE Type of campaign recorded. VARCHAR2(63)
AFBCAMP

AFBCAMP_CMTP_CODE

CAMPAIGN_TYPE_DESC Campaign type description. VARCHAR2(255)
ATVCMTP

ATVCMTP_DESC

CONTACT Type of contact made. VARCHAR2(63)
AFRCRES

AFRCRES_SCNT_CODE

CONTACT_DESC Contact description. VARCHAR2(255)
ATVSCNT

ATVSCNT_DESC

GIFT_NUMBER Number of the gift. VARCHAR2(63)
AFRCRES

AFRCRES_GIFT_NO

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

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

AFRCRES_PLEDGE_NO

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

NA

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

RESULT_DESC Result description. VARCHAR2(255)
ATVSCRS

ATVSCRS_DESC

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

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

AFRCRES_DATE

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

ATVSCRS_SOLICITATION_IND

SOLICITATION_TYPE Solicitation type code. VARCHAR2(63)
AFRCRES

AFRCRES_SOLC_CODE

SOLICITATION_TYPE_DESC Solicitation type description. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

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

AFRCRES_DCYR_CODE

SOLICITATION_YEAR_DESC Year description. VARCHAR2(255)
ATVDCYR

ATVDCYR_DCYR_DESC

SOLICITATION_YEAR_END_DATE Year end date. DATE
ATVDCYR

ATVDCYR_END_DATE

SOLICITATION_YEAR_START_DATE Year start date. DATE
ATVDCYR

ATVDCYR_START_DATE

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

MGKFUNC.F_GET_PERSON_INFO

SOLICITOR_FIRST_NAME Solicitor first name. VARCHAR2(63)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

SOLICITOR_ID Solicitor current identification number. VARCHAR2(63)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

SOLICITOR_LAST_NAME Solicitor last name. VARCHAR2(63)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

MGKFUNC.F_GET_PERSON_INFO

SOLICITOR_ORGANIZATION Solicitor organization code. VARCHAR2(63)
AFRCRES

AFRCRES_SOL_ORG

SOLICITOR_ORGANIZATION_NAME Solicitor organization name. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

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

AFRCRES_ACTIVITY_DATE

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

AFRCRES_USER

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

AFRCRES_PIDM

Ver: 8.5

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