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 Name Business Definition Database Data Type Domain Value Source Name Source Column

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

NA

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

AFRCRES_COMMENT

ASSIGNMENT_SEQUENCE_NUMBER 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 User defined code for a campaign. VARCHAR2(63)
AFRCRES

AFRCRES_CAMPAIGN

CAMPAIGN_NAME Campaign Name Campaign name. VARCHAR2(255)
AFBCAMP

AFBCAMP_NAME

CAMPAIGN_TYPE Campaign Type Type of campaign recorded. VARCHAR2(63)
AFBCAMP

AFBCAMP_CMTP_CODE

CAMPAIGN_TYPE_DESC Campaign Type Description Campaign type description. VARCHAR2(255)
ATVCMTP

ATVCMTP_DESC

CONTACT Contact Type of contact made. VARCHAR2(63)
AFRCRES

AFRCRES_SCNT_CODE

CONTACT_DESC Contact Description Contact description. VARCHAR2(255)
ATVSCNT

ATVSCNT_DESC

GIFT_NUMBER Gift Number Number of the gift. VARCHAR2(63)
AFRCRES

AFRCRES_GIFT_NO

MULTI_SOURCE Multi Source Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)
NA

NA

MULTI_SOURCE_DESC Multi Source Description Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)
NA

NA

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

AFRCRES_PLEDGE_NO

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

NA

RESULT 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 Result description. VARCHAR2(255)
ATVSCRS

ATVSCRS_DESC

RESULT_SEQUENCE_NUMBER 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 Solicitation Date Date the constituent was contacted for a solicitation. DATE
AFRCRES

AFRCRES_DATE

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

ATVSCRS_SOLICITATION_IND

SOLICITATION_TYPE Solicitation Type Solicitation type code. VARCHAR2(63)
AFRCRES

AFRCRES_SOLC_CODE

SOLICITATION_TYPE_DESC Solicitation Type Description Solicitation type description. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

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

AFRCRES_DCYR_CODE

SOLICITATION_YEAR_DESC Solicitation Year Description Year description. VARCHAR2(255)
ATVDCYR

ATVDCYR_DCYR_DESC

SOLICITATION_YEAR_END_DATE Solicitation Year End Date Year end date. DATE
ATVDCYR

ATVDCYR_END_DATE

SOLICITATION_YEAR_START_DATE Solicitation Year Start Date Year start date. DATE
ATVDCYR

ATVDCYR_START_DATE

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

MGKFUNC.F_GET_PERSON_INFO

SOLICITOR_FIRST_NAME Solicitor First Name Solicitor first name. VARCHAR2(63)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

SOLICITOR_ID Solicitor ID Solicitor current identification number. VARCHAR2(63)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

SOLICITOR_LAST_NAME Solicitor Last Name Solicitor last name. VARCHAR2(63)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

SOLICITOR_NAME 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 Solicitor organization code. VARCHAR2(63)
AFRCRES

AFRCRES_SOL_ORG

SOLICITOR_ORGANIZATION_NAME Solicitor Organization Name Solicitor organization name. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

SOLICITOR_RESULT_ACTIVITY_DATE 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 Solicitor Result User ID Unique identification code of the user who entered or last touched the transaction. VARCHAR2(63)
AFRCRES

AFRCRES_USER

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

AFRCRES_PIDM

Ver: 9.0

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 Name	Business Definition	Database Data Type	Source Name	Source Column
ADMINISTRATIVE_GROUP	Administrative Group	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
ASSIGNMENT_RESULT_COMMENT	Assignment Result Comment	Comments about the constituent contact result.	VARCHAR2(2000)	AFRCRES	AFRCRES_COMMENT
ASSIGNMENT_SEQUENCE_NUMBER	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	User defined code for a campaign.	VARCHAR2(63)	AFRCRES	AFRCRES_CAMPAIGN
CAMPAIGN_NAME	Campaign Name	Campaign name.	VARCHAR2(255)	AFBCAMP	AFBCAMP_NAME
CAMPAIGN_TYPE	Campaign Type	Type of campaign recorded.	VARCHAR2(63)	AFBCAMP	AFBCAMP_CMTP_CODE
CAMPAIGN_TYPE_DESC	Campaign Type Description	Campaign type description.	VARCHAR2(255)	ATVCMTP	ATVCMTP_DESC
CONTACT	Contact	Type of contact made.	VARCHAR2(63)	AFRCRES	AFRCRES_SCNT_CODE
CONTACT_DESC	Contact Description	Contact description.	VARCHAR2(255)	ATVSCNT	ATVSCNT_DESC
GIFT_NUMBER	Gift Number	Number of the gift.	VARCHAR2(63)	AFRCRES	AFRCRES_GIFT_NO
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
PLEDGE_NUMBER	Pledge Number	System assigned number of the pledge.	VARCHAR2(63)	AFRCRES	AFRCRES_PLEDGE_NO
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
RESULT	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	Result description.	VARCHAR2(255)	ATVSCRS	ATVSCRS_DESC
RESULT_SEQUENCE_NUMBER	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	Solicitation Date	Date the constituent was contacted for a solicitation.	DATE	AFRCRES	AFRCRES_DATE
SOLICITATION_IND	Solicitation Indicator	Determines if the result ended as a solicitation.	VARCHAR2(1)	ATVSCRS	ATVSCRS_SOLICITATION_IND
SOLICITATION_TYPE	Solicitation Type	Solicitation type code.	VARCHAR2(63)	AFRCRES	AFRCRES_SOLC_CODE
SOLICITATION_TYPE_DESC	Solicitation Type Description	Solicitation type description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
SOLICITATION_YEAR	Solicitation Year	Year in which the solicitation ask amount should be made.	VARCHAR2(63)	AFRCRES	AFRCRES_DCYR_CODE
SOLICITATION_YEAR_DESC	Solicitation Year Description	Year description.	VARCHAR2(255)	ATVDCYR	ATVDCYR_DCYR_DESC
SOLICITATION_YEAR_END_DATE	Solicitation Year End Date	Year end date.	DATE	ATVDCYR	ATVDCYR_END_DATE
SOLICITATION_YEAR_START_DATE	Solicitation Year Start Date	Year start date.	DATE	ATVDCYR	ATVDCYR_START_DATE
SOLICITOR_ENTITY_IND	Solicitor Entity Indicator	Indicates whether this is a person or entity record.	VARCHAR2(1)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
SOLICITOR_FIRST_NAME	Solicitor First Name	Solicitor first name.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
SOLICITOR_ID	Solicitor ID	Solicitor current identification number.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
SOLICITOR_LAST_NAME	Solicitor Last Name	Solicitor last name.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
SOLICITOR_NAME	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	Solicitor organization code.	VARCHAR2(63)	AFRCRES	AFRCRES_SOL_ORG
SOLICITOR_ORGANIZATION_NAME	Solicitor Organization Name	Solicitor organization name.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
SOLICITOR_RESULT_ACTIVITY_DATE	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	Solicitor Result User ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(63)	AFRCRES	AFRCRES_USER
SOLICITOR_UID	Solicitor UID	System generated, unique, internal identification number assigned to this solicitor.	NUMBER	AFRCRES	AFRCRES_PIDM