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

Banner Operational Data Store
Reporting View Target: SOLICITATION

Description Contains detail information for each solicitation associated with a donor pledge or gift on a per campaign basis. Includes gift pledge indicator, gift number, pledge number, campaign, solicitation type, solicitor organization, solicitor details, solicitation amount, actual amount, and credit recipient UID as applicable.
Key & Frequency One row per entity per gift number per pledge number per solicitation type per campaign.
Recommended Search Columns ENTITY_UID
ENTITY_UID, GIFT_NUMBER, PLEDGE_NUMBER, GIFT_PLEDGE_IND
ENTITY_UID, PLEDGE_NUMBER, GIFT_PLEDGE_IND
SOLICITOR_UID

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

AMOUNT Amount of the gift or pledge. NUMBER

AGRGSOL

AGRPSOL

AGRGSOL_AMT

AGRPSOL_AMT

AMOUNT_PLEDGE_PAID Amount paid toward the pledge. NUMBER

AGRPSOL

AGRPSOL_AMT_PAID

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

AGRGSOL

AGRPSOL

AGRGSOL_CAMPAIGN

AGRPSOL_CAMPAIGN

CAMPAIGN_NAME Campaign name. VARCHAR2(255)

AFBCAMP

AFBCAMP_NAME

CREDIT_UID System generated, unique, internal identification number assigned to this person or organization entity. NUMBER

AGRGSOL

AGRPSOL

AGRGSOL_CREDIT_PIDM

AGRPSOL_CREDIT_PIDM

ENTITY_UID System generated, unique, internal identification number assigned to this person or organization entity. NUMBER

AGRGSOL

AGRPSOL

AGRGSOL_PIDM

AGRPSOL_PIDM

GIFT_NUMBER Number of the gift. VARCHAR2(63)

AGRGSOL

AGRGSOL_GIFT_NO

GIFT_PLEDGE_IND Indicates whether the solicitation was for a gift or pledge. VARCHAR2(1)

CONSTANT

SOURCE AGRGSOL THEN 'G'; SOURCE AGRPSOL THEN 'P'

ID Identification number assigned to a person that is used externally for all communication and correspondence with the person. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied for this table/column. VARCHAR2(63)

NA

NA

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

NA

NA

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

PLEDGE_NUMBER System-assigned pledge number. VARCHAR2(63)

AGRGSOL

AGRPSOL

AGRGSOL_PLEDGE_NO

AGRPSOL_PLEDGE_NO

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

NA

NA

SOLICITATION_TYPE Pledge solicitation type code. VARCHAR2(63)

AGRGSOL

AGRPSOL

AGRGSOL_SOLC_CODE

AGRPSOL_SOLC_CODE

SOLICITATION_TYPE_DESC Solicitation code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

SOLICITOR_FIRST_NAME Solicitor's first name. VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

SOLICITOR_ID Solicitor's current identification number. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

SOLICITOR_LAST_NAME Solicitor's last name. VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

SOLICITOR_ORGANIZATION Solicitor organization code. VARCHAR2(63)

AGRGSOL

AGRPSOL

AGRGSOL_SOL_ORG

AGRPSOL_SOL_ORG

SOLICITOR_ORGANIZATION_NAME Solicitor organization name. VARCHAR2(255)

ASBSORG

ASBSORG_NAME

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

AGRGSOL

AGRPSOL

AGRGSOL_SOL_PIDM

AGRPSOL_SOL_PIDM



Ver: 9.1