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

Banner Operational Data Store
Composite View Target: AA_PROSPECT_INFO

Description Source composite view contains general information on each prospect person or organization including source, status, target ask amount and ask date and primary staff assignments.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target
ACTIVE_PROSPECT_IND Prospect status active indicator determining if the status is active (Y)es, or inactive (N)o. VARCHAR2(1)

ATVPRST

ATVPRST_ACTIVE_IND

NO

NO
ACTIVITY_DATE Date that information for this record in the table was entered or last updated. DATE

AMRINFO

AMRINFO_ACTIVITY_DATE

NO

NO
ALLOW_WEB_GIFT_IND Determines if gifts from this prospect will be accepted from the Web. (Y)es accepted from the web or (N)ot accepted from the web. VARCHAR2(1)

CALCULATION

NVL(AMRINFO_WEB_GIFT_IND,'N')

NO

NO
ALLOW_WEB_PLEDGE_IND Determines if pledges from this prospect will be accepted from the Web. (Y)es accepted from the web or (N)ot accepted from the web. VARCHAR2(1)

CALCULATION

NVL(AMRINFO_WEB_PLDG_IND,'N')

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

AMRINFO

AMRINFO_PIDM

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
PREF_GEO_REGION_ADDR_TYPE Address type of the address to be used as the preferred geographic region address. VARCHAR2(2)

APBCONS

APBCONS_ATYP_CODE_GEOR

NO

NO
PREF_GEO_REGION_ADDR_TYPE_DESC Preferred geographic region address type. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
PRIMARY_STAFF_ASSIGN_IDEN_CODE Primary staff identification code. VARCHAR2(5)

AMRSTAF

AMRSTAF_IDEN_CODE

NO

NO
PRIMARY_STAFF_ASSIGN_IDEN_DESC Name of the primary staff identification code. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
PRIMARY_STAFF_ASSIGN_TYPE Primary staff type code. VARCHAR2(4)

AMRSTAF

AMRSTAF_STFT_CODE

NO

NO
PRIMARY_STAFF_ASSIGN_TYPE_DESC Primary staff type code description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
PROSPECT_AMOUNT Manually entered or system calculated prospect amount. NUMBER

AMRINFO

AMRINFO_PROSP_RATE

NO

NO
PROSPECT_AMOUNT_ENTRY_DATE Date the rating amount for the prospect was calculated or entered. DATE

AMRINFO

AMRINFO_RATE_ENTRY_DATE

NO

NO
PROSPECT_AMOUNT_METHOD Determines the method for calculating the prospect amount. VARCHAR2(1)

AMRINFO

AMRINFO_SYS_IND

NO

NO
PROSPECT_AMOUNT_METHOD_DESC Prospect amount method description. Explains how the prospect asking amount is calculated. If the value is 'N', the amount is manually entered and cannot be overridden. If the value is 'S', the amount is system calculated either from a primary indicated rate, or weighted-average of rate values. VARCHAR2(30)

FUNCTION

CASE WHEN AMRINFO_SYS_IND

NO

NO
PROSPECT_STATUS Status. VARCHAR2(6)

AMRINFO

AMRINFO_STATUS

NO

NO
PROSPECT_STATUS_DESC Prospect status description. VARCHAR2(30)

ATVPRST

ATVPRST_DESC

NO

NO
REFERENCE Reference code. VARCHAR2(2)

AMRINFO

AMRINFO_REFR_CODE

NO

NO
REFERENCE_COMMENT Prospect reference comment. VARCHAR2(30)

AMRINFO

AMRINFO_REFERENCE

NO

NO
REFERENCE_DESC Reference code description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
SOLICITOR_IND Determines if the staff person is a solicitor (Y)es or not a solicitor (N)o. VARCHAR2(1)

CALCULATION

NVL(AMRSTAF_SOLICIT_IND,'N')

NO

NO
TARGET_ASK_DATE Manually entered target asking date. DATE

AMRINFO

AMRINFO_TARGET_ASK_DATE

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: