Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Travel And Expense Composite View Reports

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 Definition Database Data Type Source Name Source Column
CREATE_ASSIGNMENT_USER_UID Personal identification number of the person who created the delegate assignment. NUMBER(8)

FTORDLAS

USER_PIDM

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

NA

SYSDATE

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

FTORDLAS

ACTIVITY_DATE

DELEGATE_ASSIGN_DATA_ORIGIN Source system that created or updated the data. VARCHAR2(30)

FTORDLAS

DATA_ORIGIN

DELEGATE_ASSIGN_KEY Unique internal identification number of the delegate assignment record. NUMBER(19)

FTORDLAS

ID

DELEGATE_ASSIGN_USER_ID Unique identification code of the user who entered or last touched the record. VARCHAR2(30)

FTORDLAS

USER_ID

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

FTORDLAS

FTOBDLGT_ID

DELEGATE_TRAVELER_REVIEW_IND 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 Personal identification number of the delegate. NUMBER(8)

FTOBDLGT

DELEGATE_PIDM

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

NA

NA

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

NA

NA

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

NA

NA

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

FTOBPROF

OWNER_PIDM

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

FTORDLAS

FTOBPROF_ID

TRAVELER_REVIEW_IND 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 column for future use, not currently populated. VARCHAR2(6)

NA

NA



Ver: