Composite View Target: AE_DELEGATE

Go To View:	RETURN TO BANNER COMP META DATA REPORTS LIST
	Neu Schedule Data Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AE_DELEGATE_ASSIGNMENT

Description Contains personnel assigned to the delegate who is responsible for the creation of authorizations and expense reports.
Key & Frequency One row per delegate UID per person UID.

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column

CREATE_ASSIGNMENT_USER_UID Create Assignment User UID Personal identification number of the person who created the delegate assignment. NUMBER(8)
FTORDLAS

USER_PIDM

CURRENT_DATE Current Date This is a the system current date (sysdate). DATE
NA

SYSDATE

DELEGATE_ASSIGN_ACTIVITY_DATE Delegate Assignment Activity Date Date information for this record in the table was entered or last updated. TIMESTAMP(6)
FTORDLAS

ACTIVITY_DATE

DELEGATE_ASSIGN_DATA_ORIGIN Delegate Assignment Data Origin Source system that created or updated the data. VARCHAR2(30)
FTORDLAS

DATA_ORIGIN

DELEGATE_ASSIGN_KEY Delegate Assignment KEY Unique internal identification number of the delegate assignment record. NUMBER(19)
FTORDLAS

ID

DELEGATE_ASSIGN_USER_ID Delegate Assignment User ID Unique identification code of the user who entered or last touched the record. VARCHAR2(30)
FTORDLAS

USER_ID

DELEGATE_KEY Delegate KEY Unique internal identification number of the delegate record. NUMBER(19)
FTORDLAS

FTOBDLGT_ID

DELEGATE_TRAVELER_REVIEW_IND Delegate Traveler Review Indicator Indicates delegate profile setup requires traveler to review the report prepared by the delegate (Y), or if the traveler does need to review the report by the delegate (N). CHAR(1)
FTOBDLGT

BYPASS_TRAVELER_REVIEW_IND

DELEGATE_UID Delegate UID Personal identification number of the delegate. NUMBER(8)
FTOBDLGT

DELEGATE_PIDM

DOMAIN_VALUE Domain Value Domain column for future use, not currently populated. VARCHAR2(6)
NA

NA

MIF_DESC MIF Description Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(30)
NA

NA

MIF_VALUE MIF Value Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(6)
NA

NA

PERSON_UID Person UID Personal identification number of the assigned expense report user. NUMBER(8)
FTOBPROF

OWNER_PIDM

PROFILE_KEY Profile KEY Unique internal identification number of the expense profile record for the assigned traveler. NUMBER(19)
FTORDLAS

FTOBPROF_ID

TRAVELER_REVIEW_IND Traveler Review Indicator Inidcates whether traveler does not need to review the report prepared by the delegate (Y), or if the traveler does need to review the report by the delegate (N). This might be the same as the delegate_traveler_review_ind or it may be an override. CHAR(1)
FTORDLAS

BYPASS_TRAVELER_REVIEW_IND

ZONE_VALUE Zone Value Zone column for future use, not currently populated. VARCHAR2(6)
NA

NA

Ver:

Description	Contains personnel assigned to the delegate who is responsible for the creation of authorizations and expense reports.
Key & Frequency	One row per delegate UID per person UID.

Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
CREATE_ASSIGNMENT_USER_UID	Create Assignment User UID	Personal identification number of the person who created the delegate assignment.	NUMBER(8)	FTORDLAS	USER_PIDM
CURRENT_DATE	Current Date	This is a the system current date (sysdate).	DATE	NA	SYSDATE
DELEGATE_ASSIGN_ACTIVITY_DATE	Delegate Assignment Activity Date	Date information for this record in the table was entered or last updated.	TIMESTAMP(6)	FTORDLAS	ACTIVITY_DATE
DELEGATE_ASSIGN_DATA_ORIGIN	Delegate Assignment Data Origin	Source system that created or updated the data.	VARCHAR2(30)	FTORDLAS	DATA_ORIGIN
DELEGATE_ASSIGN_KEY	Delegate Assignment KEY	Unique internal identification number of the delegate assignment record.	NUMBER(19)	FTORDLAS	ID
DELEGATE_ASSIGN_USER_ID	Delegate Assignment User ID	Unique identification code of the user who entered or last touched the record.	VARCHAR2(30)	FTORDLAS	USER_ID
DELEGATE_KEY	Delegate KEY	Unique internal identification number of the delegate record.	NUMBER(19)	FTORDLAS	FTOBDLGT_ID
DELEGATE_TRAVELER_REVIEW_IND	Delegate Traveler Review Indicator	Indicates delegate profile setup requires traveler to review the report prepared by the delegate (Y), or if the traveler does need to review the report by the delegate (N).	CHAR(1)	FTOBDLGT	BYPASS_TRAVELER_REVIEW_IND
DELEGATE_UID	Delegate UID	Personal identification number of the delegate.	NUMBER(8)	FTOBDLGT	DELEGATE_PIDM
DOMAIN_VALUE	Domain Value	Domain column for future use, not currently populated.	VARCHAR2(6)	NA	NA
MIF_DESC	MIF Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA
MIF_VALUE	MIF Value	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA
PERSON_UID	Person UID	Personal identification number of the assigned expense report user.	NUMBER(8)	FTOBPROF	OWNER_PIDM
PROFILE_KEY	Profile KEY	Unique internal identification number of the expense profile record for the assigned traveler.	NUMBER(19)	FTORDLAS	FTOBPROF_ID
TRAVELER_REVIEW_IND	Traveler Review Indicator	Inidcates whether traveler does not need to review the report prepared by the delegate (Y), or if the traveler does need to review the report by the delegate (N). This might be the same as the delegate_traveler_review_ind or it may be an override.	CHAR(1)	FTORDLAS	BYPASS_TRAVELER_REVIEW_IND
ZONE_VALUE	Zone Value	Zone column for future use, not currently populated.	VARCHAR2(6)	NA	NA