Overview
The following guidelines are recommended in uploading the GME data.
Location
Teams channel Research Analytics under Analytics – Provide Custom Data GRP
The above channel has a tab named Files with the following files:
GME Data
The above channel has a tab named Files with the GMEData.xlsx file. To upload the latest data to the GMEData.xlsx file, follow instructions below:
Click on Upload
Select File – Ensure the file is named GMEData.xlsx
Choose the File to Upload
Click on Open
You will get the following message
Select Replace Button
Source of Data
IT will be getting the data from the ACGME tab and the Research Year tab. Please do not rename these tabs
IT will be uploading the data from the following columns. Please do not rename these columns:
EMPLID
Last Name
First name
Middle name
Program Start Date
Program End Date
Current Program
Post Graduate Year
Compensation Status
Program ACGME Number
Annual Comp Benefits
Fiscal Year
2. ResearchControl.xlsx
a. To enter new values GME Percentage Used and Rent for a Fiscal Year, following the instructions
below:
i. Open the ResearchControl.xlsx file
ii. Enter Fiscal Year and GME Percentage Used values on the next empty row.
Please do not change the name of the columns
iii. The file will automatically save the changes
3. Imputed Rent.xlsx
a. To enter new values Imputed Rent for a Fiscal Year, following the instructions
below:
i. Open the Imputed Rent.xlsx file.
ii. Enter Fiscal Year, Facility, SqFt, Rent/SqFt and FAST Department ID on the next empty row.
Please do not change the name of the columns
iii. The file will automatically save the changes.
DSOData.xlsx
a. To enter new DSOData values for a Fiscal Year, follow the instructions below:
i. Open the DSOData.xlsx file.
ii. Enter Fiscal Year, DSO Name, FAST Department ID, Federal Expense and Total Expense.
Please do not change the name of the columns
iii. The file will automatically save the changes.
