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.

Target Column Business Definition Database Data Type Source Name Source Column
ADMINISTRATIVE_GROUP Organization-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

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)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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.3