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