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 College Code Abbreviation College Name Department Name HSC Directory Global Department Abbreviated Name Global Department ID Global Department Name Global Department Type Indicator |
| 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 - Last Action Date |
| This table contains date and time information captured for the expense when the expense report was initiated. | Calendar Month Calendar Quarter Calendar Year Day of the Week Last Action Day Fiscal Month Fiscal Quarter Fiscal Year FYYY-Quarter Month Abbreviation Month Name YYYYMM |
| Day - ER Created Date |
| This table contains date and time information captured for the expense when the expense report was initiated. | Calendar Month Calendar Quarter Calendar Year Day of the Week ER Created Day Fiscal Month Fiscal Quarter Fiscal Year FYYY-Quarter Month Abbreviation Month Name YYYYMM |
| 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 Employee ID Begin Date Key Person Record MDM ID Name Display Begin Date |
| Person - Last Action Person |
| This table stores the name and ID of the person who last took action on the travel expense report. | 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 expense report to obtain more information. | Last Send Back Person First Name Last Send Back Person Last Name Last Send Back Person MDM ID Last Send Back Person Middle Name Last Send Back Person 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 Days After Travel 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 |
| Expense Report Details |
| This table contains details on the expense report details and is updated as action is taken on the request and the expense. | ER Description ER SB Action Description ER SB Action Type ER SB Note ER Type Expense Report ID 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 Description Travel Title Type |
| Expense Report Travel |
Request Expenses |
| This table contains the code and description of the travel expense. | Code Description ID Location Category |
|
Travel Request Expense Report 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 |
| Expense Report 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 Expense Report Status |
| This table contains the current status of the travel request. | ID Status |
|
Travel Request Expense Report 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 College Name Global Department ID Traveler College Code Traveler Department Name HSC Directory Traveler Global Department Abbreviated Name - Travel Traveler Global Department Name Traveler Global Department Type Indicator |
| 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 Source Income 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 |