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

Banner Operational Data Store
Composite View Target: AA_PROJECT_INTEREST

Description Contains an unlimited number of project or interest areas that a prospect may be interested in supporting.
Key & Frequency One row per entity per project.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target
ACTIVE_PROJECT_IND Project 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

AMRPRIN

AMRPRIN_ACTIVITY_DATE

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

AMRPRIN

AMRPRIN_PIDM

NO

NO
GIVING_VEHICLE Method by which the prospect is expected to donate to the project or interest area. VARCHAR2(2)

AMRPRIN

AMRPRIN_GIVH_CODE

NO

NO
GIVING_VEHICLE_DESC Giving vehicle code description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
LAST_UPDATE_USER_ID Unique identification code of the user who entered or last touched the transaction. VARCHAR2(30)

AMRPRIN

AMRPRIN_USER

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
PROJECT Project or interest area. VARCHAR2(6)

AMRPRIN

AMRPRIN_PROJ_CODE

NO

NO
PROJECT_COMMENT Free-form text about the project. VARCHAR2(2000)

AMRPRIN

AMRPRIN_PROJ_TEXT

NO

NO
PROJECT_DESC Project or interest area description. VARCHAR2(30)

ATVPROJ

ATVPROJ_DESC

NO

NO
PROJECT_END_DATE Date when the project ends for the prospect. DATE

AMRPRIN

AMRPRIN_PROJ_EFF_TO_DATE

NO

NO
PROJECT_START_DATE Date when the project starts for the prospect. DATE

AMRPRIN

AMRPRIN_PROJ_EFF_FROM_DATE

NO

NO
PROJECT_STATUS Current project status for the prospect. VARCHAR2(6)

AMRPRIN

AMRPRIN_PRST_CODE

NO

NO
PROJECT_STATUS_DATE Date the status was created or last updated. DATE

AMRPRIN

AMRPRIN_PRST_DATE

NO

NO
PROJECT_STATUS_DESC Prospect status description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
PROJECT_TARGET_ASK_AMOUNT Target ask amount for the constituent for the project. NUMBER

AMRPRIN

AMRPRIN_TARGET_ASK_AMT

NO

NO
PROJECT_TARGET_ASK_DATE Target ask date for the constituent for the project. DATE

AMRPRIN

AMRPRIN_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: