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

Banner Operational Data Store
Reporting View Target: TRAVEL_AND_EXPENSE_PROFILE

Description Contains current and default information on a travel and expense owner profile. Also provides a total of all expenses paid to date for the profile owner.
Key & Frequency One row per profile owner.
Recommended Search Columns PROFILE_KEY
PERSON_UID
APPROVER_UID

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

NA

NA

NO

NO
APPROVER_ID User-defined or system generated one-up number of the workflow approver. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO

NO
APPROVER_NAME Combination of the workflow approver's last, first, and middle initial into one value. VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO

NO
APPROVER_UID Personal identification number of the workflow approver who approves documents for this expense owner. NUMBER

FTOBPROF

APPROVER_PIDM

NO

NO
DELEGATE_IND Indicates whether this profile is a delegate. VARCHAR2(1)

FUNCTION

CASE WHEN EXISTS FTOBDLGT

NO

NO
DELEGATE_TRAVELER_REVIEW_IND Indicates 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)

FTOBDLGT

BYPASS_TRAVELER_REVIEW_IND

NO

NO
DIRECT_DEPOSIT_IND Determines if the address used indicates direct deposit. (Y)es, use direct deposit, (N)o, create check. VARCHAR2(1)

FUNCTION

GOKODSF.F_DIRECT_DEPOSIT_IND

NO

NO
EMAIL_ADDRESS Email address of the expense owner as contact information for workflow approvals. VARCHAR2(255)

FTOBPROF

DEFAULT_EMAIL_ADDRESS

NO

NO
LIFE_TOTAL_REIMBURSE_PAID Total amount of all reimbursement expense requests that have been (P)aid to this expense owner. NUMBER

FUNCTION

MEKFUNC.F_LIFE_TOTAL_REIMBURSE_PAID

NO

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

NA

NA

NO

NO
MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

NO

NO
PERSON_ENTITY_IND Indicates whether the profile owner is a person or an organization. VARCHAR2(1)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO

NO
PERSON_ID User-defined or system generated one-up number of the person who owns this profile. VARCHAR2(63)

SPRIDEN

SPRIDEN_ID

NO

NO
PERSON_NAME Combination of the person's last, first, and middle initial into one value. VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO

NO
PERSON_UID Personal identification number of the person who owns this profile. NUMBER

FTOBPROF

OWNER_PIDM

NO

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

NA

NA

NO

NO
PROFILE_ACTIVITY_DATE Date information for this record in the table was entered or last updated. DATE

FTOBPROF

ACTIVITY_DATE

NO

NO
PROFILE_DATA_ORIGIN Source system that created or updated the data. VARCHAR2(63)

FTOBPROF

DATA_ORIGIN

NO

NO
PROFILE_KEY Unique internal identification number of the expense profile record. NUMBER

FTOBPROF

ID

NO

NO
PROFILE_USER_ID Unique identification code of the user who entered or last touched the record. VARCHAR2(63)

FTOBPROF

USER_ID

NO

NO
REMIT_ADDRESS_NUMBER Sequence number used to identify different addresses within the same address type for the expense owner. NUMBER

FTOBPROF

DEFAULT_ATYP_SEQ_NUM

NO

NO
REMIT_ADDRESS_TYPE Type of address used as the default for payment to the expense owner. VARCHAR2(63)

FTOBPROF

DEFAULT_ATYP_CODE

NO

NO
WORKFLOW_USER_LOGON Common login identification used to signon into Workflow. This is used to map the profile to a workflow signon in order to pass the document information to workflow for approvals. VARCHAR2(255)

FTOBPROF

WORKFLOW_USER_LOGON

NO

NO


Ver: 9.2