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

Banner Operational Data Store
Reporting View Target: 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.
Recommended Search Columns ENTITY_UID
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
ADMINISTRATIVE_GROUP Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

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

AMRPRIN

AMRPRIN_GIVH_CODE

NO

NO
GIVING_VEHICLE_DESC Giving vehicle code description. VARCHAR2(255)

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

AMRPRIN

AMRPRIN_USER

NO

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

NA

NA

NO

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

NA

NA

NO

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

NA

NA

NO

NO
PROJECT Project or interest area. VARCHAR2(63)

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

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

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

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


Ver: 9.2