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

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.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target
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
CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

NO

NO
DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)

NA

NA

NO

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

AMRPEXP

AMRPEXP_PIDM

NO

NO
EXPENSE_AMOUNT Amount of prospect contact expenditure. NUMBER

AMRPEXP

AMRPEXP_EXPN_AMT

NO

NO
EXPENSE_DESC Expense description. VARCHAR2(30)

GTVEXPN

GTVEXPN_DESC

NO

NO
EXPENSE_TYPE Type of expense. VARCHAR2(2)

AMRPEXP

AMRPEXP_EXPN_CODE

NO

NO
ITEM_REFERENCE_NUMBER Internal generated number for each contact. NUMBER

AMRPEXP

AMRPEXP_GRP_SEQ_NO

NO

NO
MIF_DESC Institution description for the record when the optional multi-institution facility feature has been applied. VARCHAR2(30)

NA

NA

NO

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

NA

NA

NO

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

AMRPEXP

AMRPEXP_IDEN_CODE

NO

NO
PERSON_RESPONSIBLE_IDEN_NAME Name of the person assigned to make the contact. VARCHAR2(60)

GURIDEN

GURIDEN_DESC

NO

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

GOBEACC

GOBEACC_PIDM

NO

NO
PRIMARY_STAFF_IDEN Identification code of the staff. VARCHAR2(5)

ARMSTAF

AMRSTAF_IDEN_CODE

NO

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

GURIDEN

GURIDEN_DESC

NO

NO
ZONE_VALUE Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)

NA

NA

NO

NO


Ver: