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 for the chartfield information provided. | 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 Last Action Day Fiscal Month Fiscal Quarter Fiscal Year FYYY-Quarter Month Name |
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 its associated global department (links via Global Department ID).
Info |
---|
This can be used to determine which GEMS departments are grouped under a given Global Department. |
| Abbreviated Name College Code GEMS Department Code GEMS Department Description Global Department Name KEY Global Department Type Indicator |
MDM Current Employee View | View | This table contains appointment data for employees. | Department ID Employee ID Begin Date Key Person Record MDM ID Name Display |
Person - Last Action Person |
| This table stores the name and ID of the person who last took action on the travel expense report.
Info |
---|
MDM ID can be used to determine additional appointment information about the person in MDM Current Employee View. |
| Person MDM ID 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. Info |
---|
MDM ID can be used to determine additional appointment information about the person in MDM Current Employee View. |
| Last Send Back Person MDM ID Last Send Back Person Name |
Person - Traveler Name |
| This table contains the details of the traveler, including department, employee ID, and name. Info |
---|
MDM ID can be used to determine additional appointment information about the person in MDM Current Employee View. |
| Traveler EMPLID Traveler First Name Traveler GEMS ID Traveler Middle Name Traveler Last Name Traveler MDM ID Traveler Middle Name Traveler Name |
Person - Submitter |
| This table contains the details of the submitter, including department, employee ID, and name.
| Submitter EMPLID Submitter GEMS ID Submitter GEMS End Date Submitter GEMS Start Date Submitter Hire Date Submitter Termination Date Submitter MDM ID Submitter 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 Fiscal Month Fiscal Quarter Fiscal Year FYYY Quarter Month Name Calendar Day YYYYMM |
Day - Travel End Date |
| This table stores date information regarding the end date of the person's travel. | Calendar Month Calendar Quarter Calendar Year Day of Week Fiscal Month Fiscal Quarter Fiscal Year FYYY Quarter Month Abbreviation Month Name YYYYMM Travel End Day |
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 PTA Preventative Action TR PTA Reason TR SB Action Description TR SB Action Type TR SB Note Travel Description Travel Title TR Type Travel Expense ID |
Expense Report Travel Expenses |
| This table contains the code and description of the travel expense. | Expense Code Expense Description Expense ID Expense Type |
Expense Report Line Item Details |
| This table holds information on a specific travel expense, include department, expense ID, payment type, and account code. | Chartfield Amount Chartfield Percentage Expense ID Expense Report ID Initiative Code OU Payment Type Percentage Traveler EMPLID Traveler EMPLRCD USF Account Code |
Expense Report Travel Location |
| This table contains details on the travel location, such as city, state, and country. | City City State Country Location Code Country Country Code Location Group Location ID State |
Expense Report Status |
| This table contains the current status of the travel request. | Status ID Status |
Expense Report Summary |
| This table contains the details of the travel expense report, include last status, submission, last action, traveler employee ID, and traveler employee record. | Bucket Range Cash Advance Days Between Modified Days Between Days in Last Status Days in Last Status by ER Days Since Last Action ER Completed Flag ER Created by MDM ID ER Modified by MDM ID ER Total Expenses Expense Report ID Fiscal Review FR Sendback Hold Count Last Action MDM ID Last Send Back by MDM ID On Hold Duration On Hold Flag
|