Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Advancement Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AA_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.

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
CONTACT_EXPENSE_ACTIVITY_DATE Date that information for this record in the table was entered or last updated.    

AMRCONT

AMRPEXP_ACTIVITY_DATE

 
CURRENT_DATE System current date (sysdate) or date the data was extracted.    

NA

SYSDATE

 
DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined.    

NA

NA

 
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

 
MIF_DESC Institution description for the record when the optional multi-institution facility feature has been applied.    

NA

NA

 
MIF_VALUE Institution value for the record when the optional multi-institution facility feature has been applied for this table/column.    

NA

NA

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

AMRPEXP

AMRPEXP_IDEN_CODE

 
PERSON_RESPONSIBLE_IDEN_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

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

NA

NA

 


Ver: 8.3