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

SGHE 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 Definition Database Data Type Source Name Source Column
ADMINISTRATIVE_GROUP Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

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

AMRCONT

AMRPEXP_ACTIVITY_DATE

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

AMRPEXP

AMRPEXP_PIDM

EXPENSE_AMOUNT Amount of prospect contact expenditure. NUMBER

AMRPEXP

AMRPEXP_EXPN_AMT

EXPENSE_DESC Expense description. VARCHAR2(255)

GTVEXPN

GTVEXPN_DESC

EXPENSE_TYPE Type of expense. VARCHAR2(63)

AMRPEXP

AMRPEXP_EXPN_CODE

ITEM_REFERENCE_NUMBER Internal generated number for each contact. NUMBER

AMRPEXP

AMRPEXP_GRP_SEQ_NO

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

PERSON_RESPONSIBLE_IDEN Identification code of the person assigned to make the contact. VARCHAR2(63)

AMRPEXP

AMRPEXP_IDEN_CODE

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

GURIDEN

GURIDEN_DESC

PERSON_RESPONSIBLE_UID System generated unique internal identification number assigned to this person. NUMBER

GOBEACC

GOBEACC_PIDM

PRIMARY_STAFF_IDEN Identification code of the staff. VARCHAR2(63)

ARMSTAF

AMRSTAF_IDEN_CODE

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

GURIDEN

GURIDEN_DESC

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

NA

NA



Ver: 8.5