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

Banner Operational Data Store
Reporting View Target: PROSPECT_CONTACT_EXPENSE

Description Contains a list of all expenses related to the contact for this prospect for the responsible staff member assigned.
Key & Frequency Multiple rows per entity per contact reference item number, per expense type.
Recommended Search Columns ENTITY_UID, PERSON_RESPONSIBLE_IDEN, EXPENSE_TYPE
EXPENSE_TYPE

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 entity. NUMBER    

AMRPEXP

AMRPEXP_PIDM

NO

NO
PERSON_RESPONSIBLE_IDEN Person Responsible ID Identification code of the person assigned to make the contact. VARCHAR2(63)    

AMRPEXP

AMRPEXP_IDEN_CODE

NO

NO
PERSON_RESPONSIBLE_NAME Person Responsible Name Name of the person assigned to make the contact. VARCHAR2(255)    

GURIDEN

GURIDEN_DESC

NO

NO
PERSON_RESPONSIBLE_UID Person Responsible UID System generated unique internal identification number assigned to this person. NUMBER    

GOBEACC

GOBEACC_PIDM

NO

NO
ITEM_REFERENCE_NUMBER Item Reference Number Internal generated number for each contact. NUMBER    

AMRPEXP

AMRPEXP_GRP_SEQ_NO

NO

NO
EXPENSE_TYPE Expense Type Type of expense. VARCHAR2(63)    

AMRPEXP

AMRPEXP_EXPN_CODE

NO

NO
EXPENSE_DESC Expense Description Expense description. VARCHAR2(255)    

GTVEXPN

GTVEXPN_DESC

NO

NO
EXPENSE_AMOUNT Expense Amount Amount of prospect contact expenditure. NUMBER    

AMRPEXP

AMRPEXP_EXPN_AMT

NO

NO
PRIMARY_STAFF_IDEN Primary Staff ID Identification code of the staff. VARCHAR2(63)    

ARMSTAF

AMRSTAF_IDEN_CODE

NO

NO
PRIMARY_STAFF_IDEN_NAME Primary Staff ID Name Name of the person with primary responsibility for this prospect. VARCHAR2(255)    

GURIDEN

GURIDEN_DESC

NO

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

AMRCONT

AMRPEXP_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