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 Name Business Definition Database Data Type Business Data Type Domain Value Source Name Source Column Local Source Local Target
ENTITY_UID Entity UID System generated, unique, internal identification number assigned to this person or organization entity. NUMBER    

AMRPRIN

AMRPRIN_PIDM

NO

NO
PROJECT Project Project or interest area. VARCHAR2(63)    

AMRPRIN

AMRPRIN_PROJ_CODE

NO

NO
PROJECT_DESC Project Description Project or interest area description. VARCHAR2(255)    

ATVPROJ

ATVPROJ_DESC

NO

NO
GIVING_VEHICLE 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 Description Giving vehicle code description. VARCHAR2(255)    

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
PROJECT_TARGET_ASK_AMOUNT 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 Project Target Ask Date Target ask date for the constituent for the project. DATE    

AMRPRIN

AMRPRIN_TARGET_ASK_DATE

NO

NO
ACTIVE_PROJECT_IND Active Project Indicator Project status active indicator determining if the status is active (Y)es, or inactive (N)o. VARCHAR2(1)    

ATVPRST

ATVPRST_ACTIVE_IND

NO

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

AMRPRIN

AMRPRIN_PROJ_EFF_FROM_DATE

NO

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

AMRPRIN

AMRPRIN_PROJ_EFF_TO_DATE

NO

NO
PROJECT_STATUS Project Status Current project status for the prospect. VARCHAR2(63)    

AMRPRIN

AMRPRIN_PRST_CODE

NO

NO
PROJECT_STATUS_DESC Project Status Description Prospect status description. VARCHAR2(255)    

FUNCTION

GOKODSF.F_GET_DESC

NO

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

AMRPRIN

AMRPRIN_PRST_DATE

NO

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

AMRPRIN

AMRPRIN_PROJ_TEXT

NO

NO
LAST_UPDATE_USER_ID Last Update User ID Unique identification code of the user who entered or last touched the transaction. VARCHAR2(63)    

AMRPRIN

AMRPRIN_USER

NO

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

AMRPRIN

AMRPRIN_ACTIVITY_DATE

NO

NO
MULTI_SOURCE 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 Multi Source Description Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)    

NA

NA

NO

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

NA

NA

NO

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

NA

NA

NO

NO


Ver: 9.2