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: i.
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
c. IT will be uploading the data from the following columns. Please do not rename these columns: i.
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
...
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.
...