- Created by Lise Venning, last modified by Miguel Gonzalez on Aug 07, 2019
You are viewing an old version of this page. View the current version.
Compare with Current View Page History
« Previous Version 149 Next »
This page is Work In Progress
Travel Tables
Editing now...
Temp Column Verify lang. | Table name | Table type | Table description | Columns / Fields |
Chartfield College-Global Department | This table contains college and global department information, including code, abbreviation, name, and ID. | College Code | ||
Data Refresh | This table contains the details regarding the date and time that data was last refreshed from the source system. | Last Refresh Date Last Run Timestamp | ||
Day - ER Created Date | This table contains date and time information captured for the expense when the expense report was initiated. | Calendar Month | ||
GEMS Department Profile View | View | This table contains a list of GEMS departments and associated global departments (links via Global Department ID) | Abbreviated Name - Travel College Code Creation Date Department Code Department Desc Department Name Department Profile ID Begin Date Global Department ID Short Name Type Indicator | |
MDM Current Employee View | View | This table contains MDM data for employees. | Department ID | |
Person - Last Action Person | This table stores the name and ID of the person who last took action on the travel request. | Last Action Person First Name Last Action Person Last Name Last Action Person MDM ID Last Action Person Middle Name Last Action Person Name | ||
Person - Last Send Back | This table stores the name and ID of the person who last sent back the travel request to obtain more information. | Last Send Back Person First Name | ||
Person - Traveler Name | This table contains the details of the traveler, including department, employee ID, and name. | Traveler Department Traveler Department ID Traveler First Name Traveler GEMS Employee ID Traveler Middle Name Traveler Last Name Traveler MDM ID Traveler Middle Name Traveler Name | ||
Day - Travel Begin Date | This table stores date information regarding the beginning date of the person's travel. | Begin Day Calendar Month Calendar Quarter Calendar Year Day of Week Days in Calendar Year Fiscal Month Fiscal Quarter Fiscal Year FYYY Quarter KEY Day Leap Year Monday Thru Friday Flag Month - YYYYMM Month Abbreviation Month Name Saturday Date Of Week Sunday Date Of Week Week Label Sunday Saturday Week of Cal Year Week of Month Week Sunday to Saturday Since FY00 | ||
Day - Travel End Date | This table stores date information regarding the end date of the person's travel. | Bucket Range Calendar Month Calendar Quarter Calendar Year Day of Week Days After Travel Days in Calendar Year Fiscal Month Fiscal Quarter Fiscal Year FYYY Quarter KEY Day Leap Year Monday thru Friday Flag Month Abbreviation Month Name Month YYYYMM Saturday Of Week Sunday Of Week Todays date Travel End Day Week Label Sunday to Saturday Week Of Calendar Year Week Of Month Week Sunday to Saturday Since FY00 | ||
Travel Request Details | This table contains details on the travel request and is updated as action is taken on the request and the expense. | Archivum Number Details ID ER Description ER SB Action Description ER SB Action Type ER SB Note ER Type Expense Report ID KEY Travel Details Last Action Description Last Action Note Last Action Type TAR Number TER Number TR Description TR PTA Preventative Action TR PTA Reason TR SB Action Description TR SB Action Type TR SB Note Travel Title Type | ||
Travel Request Expenses | This table contains the code and description of the travel expense. | Code Description ID Location Category | ||
Travel Request Line Item Details | This table holds information on a specific travel request, include department, expense ID, payment type, and account code. | Chartfield KEY Department Profile Chartfield KEY Global Department Chartfield KEY USF Department Initiative Code KEY Travel Expense ID KEY Travel Location ID KEY USF Fund ID KEY USF Project ID KEY USF Project Profile OU USF Account Code Percentage Travel Request Amount Travel Request ID USF Account Code | ||
Travel Request Location | This table contains details on the travel location, such as city, state, and country. | City City State Country Code Country Country Code Group ID KEY Travel Location State | ||
Travel Request Status | This table contains the current status of the travel request. | ID Status | ||
Travel Request Summary | This table contains the details of the travel request, include travel dates, purpose, request submitter, traveler employee ID, and travel location. It is updated as the request is processed to include status of the request, last action, and send back details (if any). | Bucket Range Days After Travel Days Before Travel Days Between Days in Last Status ER Exists Flag KEY Last Action Day KEY Person Record KEY TR Begin Day KEY TR Create Day KEY TR End Day KEY TR Last Modification Day KEY Travel Details KEY Travel Doc Status KEY Travel Location KEY Travel Purpose Key Person Record Last Send Back by MDM ID Send Back Datetime Send Back Flag Send Back KEY Day Submitter Name TAR Number TR Created by MDM ID TR Total Amount TR Updated by MDM ID TR_TOTAL_AMOUNT_ZERO Travel Request ID Traveler Appt Global Department KEY Traveler Employee Record Traveler GEMS Employee ID Traveler GEMS KEY Department Profile | ||
Traveler College-Global Department | This table contains the college and department information for the traveler. | College Code Abbreviation | ||
USF FAST Department | This table stores the FAST code and name. | FAST Department Code FAST Department Name | ||
USF Fund Codes | This table provides information on fund codes. | Fund Code Fund Description Fund Group Type | ||
USF Products | Contains list of FAST product codes and description | KEY USF Product USF Product USF Product Description | ||
USF Projects | Contains list of FAST projects and associated details such as start and end dates, associated employees, total amounts, award status, and purpose. | Adjusted Award Amount Adjustment Amount Amount Total Award Status Award Type Awards Date Contract Begin Date Contract Business Unit Contract Description Contract Employee ID Contract Employee Name Contract End Date Contract Number Contract Title Contract Type Cust ID Department ID GM Begin Date GM CFDA Num GM End Date GM Source Income GR Source Funding Initial Award Amount KEY USF Project Primary Sponsor ID Project Begin Date Project CFDA Project End Date Project ID Project PI Employee ID Project PI MDM ID Project PI Name Proposal ID Purpose Ref Award Number Ref Awd Num2 Sponsor Award ID Sponsor Name USF Business Unit USF Operating Unit Version ID |
- No labels