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

SGHE 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
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

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

AMRPRIN

AMRPRIN_ACTIVITY_DATE

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

NA

NA

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

AMRPRIN

AMRPRIN_PIDM

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

AMRPRIN

AMRPRIN_GIVH_CODE

GIVING_VEHICLE_DESC Giving vehicle code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

AMRPRIN

AMRPRIN_USER

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

NA

NA

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

NA

NA

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

NA

NA

PROJECT Project or interest area. VARCHAR2(63)

AMRPRIN

AMRPRIN_PROJ_CODE

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

AMRPRIN

AMRPRIN_PROJ_TEXT

PROJECT_DESC Project or interest area description. VARCHAR2(255)

ATVPROJ

ATVPROJ_DESC

PROJECT_END_DATE Date when the project ends for the prospect. DATE

AMRPRIN

AMRPRIN_PROJ_EFF_TO_DATE

PROJECT_START_DATE Date when the project starts for the prospect. DATE

AMRPRIN

AMRPRIN_PROJ_EFF_FROM_DATE

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

AMRPRIN

AMRPRIN_PRST_CODE

PROJECT_STATUS_DATE Date the status was created or last updated. DATE

AMRPRIN

AMRPRIN_PRST_DATE

PROJECT_STATUS_DESC Prospect status description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

AMRPRIN

AMRPRIN_TARGET_ASK_AMT

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

AMRPRIN

AMRPRIN_TARGET_ASK_DATE



Ver: 8.5