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

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.    

NA

NA

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

AMRCONT

AMRPEXP_ACTIVITY_DATE

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

AMRPEXP

AMRPEXP_PIDM

 
EXPENSE_AMOUNT Amount of prospect contact expenditure.    

AMRPEXP

AMRPEXP_EXPN_AMT

 
EXPENSE_DESC Expense description.    

GTVEXPN

GTVEXPN_DESC

 
EXPENSE_TYPE Type of expense.    

AMRPEXP

AMRPEXP_EXPN_CODE

 
ITEM_REFERENCE_NUMBER Internal generated number for each contact.    

AMRPEXP

AMRPEXP_GRP_SEQ_NO

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

NA

NA

 
MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied.    

NA

NA

 
PERSON_RESPONSIBLE_IDEN Identification code of the person assigned to make the contact.    

AMRPEXP

AMRPEXP_IDEN_CODE

 
PERSON_RESPONSIBLE_NAME Name of the person assigned to make the contact.    

GURIDEN

GURIDEN_DESC

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

GOBEACC

GOBEACC_PIDM

 
PRIMARY_STAFF_IDEN Identification code of the staff.    

ARMSTAF

AMRSTAF_IDEN_CODE

 
PRIMARY_STAFF_IDEN_NAME Name of the person with primary responsibility for this prospect.    

GURIDEN

GURIDEN_DESC

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

NA

NA

 


Ver: 8.3