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

SGHE 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
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(5)

AGRGSOL

AGRPSOL

AGRGSOL_CAMPAIGN

AGRPSOL_CAMPAIGN

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

AGRGSOL

AGRPSOL

AGRGSOL_CREDIT_PIDM

AGRPSOL_CREDIT_PIDM

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

NA

SYSDATE

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

NA

NA

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(7)

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'

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

NA

NA

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

NA

NA

PLEDGE_NUMBER System-assigned pledge number. VARCHAR2(7)

AGRGSOL

AGRPSOL

AGRGSOL_PLEDGE_NO

AGRPSOL_PLEDGE_NO

SOLICITATION_TYPE Pledge solicitation type code. VARCHAR2(15)

AGRGSOL

AGRPSOL

AGRGSOL_SOLC_CODE

AGRPSOL_SOLC_CODE

SOLICITATION_TYPE_DESC Solicitation code description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

SOLICITOR_ORGANIZATION Solicitor organization code. VARCHAR2(5)

AGRGSOL

AGRPSOL

AGRGSOL_SOL_ORG

AGRPSOL_SOL_ORG

SOLICITOR_ORGANIZATION_NAME Solicitor organization name. VARCHAR2(30)

ASBSORG

ASBSORG_NAME

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

AGRGSOL

AGRPSOL

AGRGSOL_SOL_PIDM

AGRPSOL_SOL_PIDM

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

NA

NA



Ver: