Reporting View Target: PROSPECT_CONTACT

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 Name Business Definition Database Data Type Domain Value Source Name Source Column

ADMINISTRATIVE_GROUP Administrative Group Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)
NA

NA

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

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

AMRPEXP_PIDM

EXPENSE_AMOUNT Expense Amount Amount of prospect contact expenditure. NUMBER
AMRPEXP

AMRPEXP_EXPN_AMT

EXPENSE_DESC Expense Description Expense description. VARCHAR2(255)
GTVEXPN

GTVEXPN_DESC

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

AMRPEXP_EXPN_CODE

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

AMRPEXP_GRP_SEQ_NO

MULTI_SOURCE Multi Source Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)
NA

NA

MULTI_SOURCE_DESC Multi Source Description Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)
NA

NA

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

AMRPEXP_IDEN_CODE

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

GURIDEN_DESC

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

GOBEACC_PIDM

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

AMRSTAF_IDEN_CODE

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

GURIDEN_DESC

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

NA

Ver: 9.0

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	Source Name	Source Column
ADMINISTRATIVE_GROUP	Administrative Group	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
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
ENTITY_UID	Entity UID	System generated, unique, internal identification number assigned to this person or entity.	NUMBER	AMRPEXP	AMRPEXP_PIDM
EXPENSE_AMOUNT	Expense Amount	Amount of prospect contact expenditure.	NUMBER	AMRPEXP	AMRPEXP_EXPN_AMT
EXPENSE_DESC	Expense Description	Expense description.	VARCHAR2(255)	GTVEXPN	GTVEXPN_DESC
EXPENSE_TYPE	Expense Type	Type of expense.	VARCHAR2(63)	AMRPEXP	AMRPEXP_EXPN_CODE
ITEM_REFERENCE_NUMBER	Item Reference Number	Internal generated number for each contact.	NUMBER	AMRPEXP	AMRPEXP_GRP_SEQ_NO
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
PERSON_RESPONSIBLE_IDEN	Person Responsible ID	Identification code of the person assigned to make the contact.	VARCHAR2(63)	AMRPEXP	AMRPEXP_IDEN_CODE
PERSON_RESPONSIBLE_NAME	Person Responsible Name	Name of the person assigned to make the contact.	VARCHAR2(255)	GURIDEN	GURIDEN_DESC
PERSON_RESPONSIBLE_UID	Person Responsible UID	System generated unique internal identification number assigned to this person.	NUMBER	GOBEACC	GOBEACC_PIDM
PRIMARY_STAFF_IDEN	Primary Staff ID	Identification code of the staff.	VARCHAR2(63)	ARMSTAF	AMRSTAF_IDEN_CODE
PRIMARY_STAFF_IDEN_NAME	Primary Staff ID Name	Name of the person with primary responsibility for this prospect.	VARCHAR2(255)	GURIDEN	GURIDEN_DESC
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA