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:
GMEData.xlsx
a. To upload the latest data to the GMEData.xlsx file, follow instructions below:
i. Click on Upload
ii. Select File – Ensure the file is named GMEData.xlsx
iii. Choose the File to Upload
iv. Click on Open
v. You will get the following message
vi. Select Replace Button
b. 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
ii. Last Name
iii. First name
iv. Middle name
v. Program Start Date
vi. Program End Date
vii. Current Program
viii. Post Graduate Year
ix. Compensation Status
x. Program ACGME Number
xi. Annual Comp Benefits
xii. 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