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

SGHE 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
ADMINISTRATIVE_GROUP Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

FTOBPROF

APPROVER_PIDM

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

FUNCTION

CASE WHEN EXISTS FTOBDLGT

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

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

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

FTOBPROF

DEFAULT_EMAIL_ADDRESS

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

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

NA

NA

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

NA

NA

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

SPRIDEN

SPRIDEN_ID

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

FTOBPROF

OWNER_PIDM

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

NA

NA

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

FTOBPROF

ACTIVITY_DATE

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

FTOBPROF

DATA_ORIGIN

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

FTOBPROF

ID

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

FTOBPROF

USER_ID

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

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

FTOBPROF

DEFAULT_ATYP_CODE

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



Ver: 8.5