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.

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.    

NA

NA

 
APPROVER_ID User-defined or system generated one-up number of the workflow approver.    

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

FTOBPROF

APPROVER_PIDM

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

FUNCTION

GOKODSF.F_DIRECT_DEPOSIT_IND

 
EMAIL_ADDRESS Email address of the expense owner as contact information for workflow approvals.    

FTOBPROF

DEFAULT_EMAIL_ADDRESS

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

FUNCTION

MEKFUNC.F_LIFE_TOTAL_REIMBURSE_PAID

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

NA

NA

 
MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied.    

NA

NA

 
PERSON_ENTITY_IND Indicates whether the profile owner is a person or an organization.    

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

FTOBPROF

OWNER_PIDM

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

NA

NA

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

FTOBPROF

ACTIVITY_DATE

 
PROFILE_DATA_ORIGIN Source system that created or updated the data.    

FTOBPROF

DATA_ORIGIN

 
PROFILE_KEY Unique internal identification number of the expense profile record.    

FTOBPROF

ID

 
PROFILE_USER_ID Unique identification code of the user who entered or last touched the record.    

FTOBPROF

USER_ID

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

FTOBPROF

DEFAULT_ATYP_SEQ_NUM

 
REMIT_ADDRESS_TYPE Type of address used as the default for payment to the expense owner.    

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.    

FTOBPROF

WORKFLOW_USER_LOGON

 


Ver: 8.3