Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Travel And Expense Reporting View Reports

Banner Operational Data Store
Reporting View Target: DELEGATE_ASSIGNMENT

Description Contains personnel assigned to the delegate who is responsible for the creation of authorizations and expense reports. The delegate's name and ID and the personnel's name and ID.
Key & Frequency One row per delegate_UID per person_UID.
Recommended Search Columns DELEGATE_UID

Target Column Business Name Business Definition Database Data Type Source Name Source Column
ADMINISTRATIVE_GROUP Administrative Group Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

DELEGATE_ASSIGN_ACTIVITY_DATE Delegate Assignment Activity Date Date information for this record in the table was entered or last updated. DATE

FTORDLAS

ACTIVITY_DATE

DELEGATE_ASSIGN_CREATE_ID Delegate Assignment Create ID User-defined or system generated one-up number of the person who created the delegate assignment VARCHAR2(63)

FUNCTION

SPRIDEN

MGKFUNC.F_GET_PERSON_INFO

SPRIDEN_ID

DELEGATE_ASSIGN_CREATE_NAME Delegate Assignment Create Name Combination of the person's last, first, and middle initial into one value. VARCHAR2(255)

FUNCTION

SPRIDEN

MGKFUNC.F_GET_PERSON_INFO

SPRIDEN_LAST_NAME || SPRIDEN_FIRST_NAME || SPRIDEN_MI

DELEGATE_ASSIGN_CREATE_UID Delegate Assignment Create UID Personal identification number of the person who created the delegate assignment. NUMBER

FTORDLAS

USER_PIDM

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

FTORDLAS

DATA_ORIGIN

DELEGATE_ASSIGN_KEY Delegate Assignment KEY Unique internal identification number of the delegate assignment record. NUMBER

FTORDLAS

ID

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

FTORDLAS

USER_ID

DELEGATE_ID Delegate ID User-defined or system generated one-up number of the delegate. VARCHAR2(63)

FUNCTION

SPRIDEN

MGKFUNC.F_GET_PERSON_INFO

SPRIDEN_ID

DELEGATE_KEY Delegate KEY Unique internal identification number of the delegate record. NUMBER

FTORDLAS

FTOBDLGT_ID

DELEGATE_NAME Delegate Name Combination of the delegate's last, first, and middle initial into one value. VARCHAR2(255)

FUNCTION

SPRIDEN

MGKFUNC.F_GET_PERSON_INFO

SPRIDEN_LAST_NAME || SPRIDEN_FIRST_NAME || SPRIDEN_MI

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). VARCHAR2(1)

FTOBDLGT

BYPASS_TRAVELER_REVIEW_IND

DELEGATE_UID Delegate UID Personal identification number of the delegate. NUMBER

FTOBDLGT

DELEGATE_PIDM

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_ID Person ID User-defined or system generated one-up number of the assigned expense report user. VARCHAR2(63)

FUNCTION

SPRIDEN

MGKFUNC.F_GET_PERSON_INFO

SPRIDEN_ID

PERSON_NAME Person Name Combination of the expense report user's last, first, and middle initial into one value. VARCHAR2(255)

FUNCTION

SPRIDEN

MGKFUNC.F_GET_PERSON_INFO

SPRIDEN_LAST_NAME || SPRIDEN_FIRST_NAME || SPRIDEN_MI

PERSON_UID Person UID Personal identification number of the assigned expense report user. NUMBER

FTRBAUTH

SENT_TO_TRAVELER_BY

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

NA

NA

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

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). VARCHAR2(1)

FTORDLAS

BYPASS_TRAVELER_REVIEW_IND



Ver: 9.2