Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Advancement Composite View Reports

Banner Operational Data Store
Composite View Target: AA_SOLICITOR

Description Source composite view contains details related to any solicitation efforts associated to a gift or pledge.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target
AMOUNT Amount of the gift or pledge. NUMBER

AGRGSOL

AGRPSOL

AGRGSOL_AMT

AGRPSOL_AMT

NO

NO

NO
AMOUNT_PLEDGE_PAID Amount paid toward the pledge. NUMBER

AGRPSOL

AGRPSOL_AMT_PAID

NO

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

AGRGSOL

AGRPSOL

AGRGSOL_CAMPAIGN

AGRPSOL_CAMPAIGN

NO

NO

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

AGRGSOL

AGRPSOL

AGRGSOL_CREDIT_PIDM

AGRPSOL_CREDIT_PIDM

NO

NO

NO
CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

NO

NO
DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)

NA

NA

NO

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

AGRGSOL

AGRPSOL

AGRGSOL_PIDM

AGRPSOL_PIDM

NO

NO

NO
GIFT_NUMBER Number of the gift. VARCHAR2(7)

AGRGSOL

AGRGSOL_GIFT_NO

NO

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'

NO

NO
MIF_DESC Institution description for the record when the optional multi-institution facility feature has been applied. VARCHAR2(30)

NA

NA

NO

NO
MIF_VALUE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(6)

NA

NA

NO

NO
PLEDGE_NUMBER System-assigned pledge number. VARCHAR2(7)

AGRGSOL

AGRPSOL

AGRGSOL_PLEDGE_NO

AGRPSOL_PLEDGE_NO

NO

NO

NO
SOLICITATION_TYPE Pledge solicitation type code. VARCHAR2(15)

AGRGSOL

AGRPSOL

AGRGSOL_SOLC_CODE

AGRPSOL_SOLC_CODE

NO

NO

NO
SOLICITATION_TYPE_DESC Solicitation code description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
SOLICITOR_ORGANIZATION Solicitor organization code. VARCHAR2(5)

AGRGSOL

AGRPSOL

AGRGSOL_SOL_ORG

AGRPSOL_SOL_ORG

NO

NO

NO
SOLICITOR_ORGANIZATION_NAME Solicitor organization name. VARCHAR2(30)

ASBSORG

ASBSORG_NAME

NO

NO
SOLICITOR_UID System generated, unique, internal identification number assigned to the person. NUMBER

AGRGSOL

AGRPSOL

AGRGSOL_SOL_PIDM

AGRPSOL_SOL_PIDM

NO

NO

NO
ZONE_VALUE Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)

NA

NA

NO

NO


Ver: