Research Analytics Load Process
- Sylvia Pagan
- Tara Connolly
- Chukwuebuka Ezema
Overview
The following guidelines are recommended in uploading data to be used by the Research Analytics dataset.
Location
Teams channel Research Analytics under Analytics – Provide Custom Data GRP
GME Data
There are two parts for loading the GME data. GME is responsible for loading employee information, while Research is responsible for loading the percentage of Resident’s salary.
Loading Employee Information - GME Director
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.
Do not rename files, tabs, or columns. Renaming will cause the data load to produce an error.
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
Loading Control Information - Research
The above channel has a tab named Files with the ResearchControl.xlsx file. To enter new values for GME Percentage Used follow the instructions below.
Open the ResearchControl.xlsx file.
Enter Fiscal Year and GME Percentage Used values on the next empty row.
The file will automatically save the changes.
Do not rename files, tabs, or columns. Renaming will cause the data load to produce an error.
Imputed Rent
To enter new values for Imputed Rent in a Fiscal Year, follow the instructions below.
Open the Imputed Rent.xlsx file.
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.
The file will automatically save the changes.
Do not rename files, tabs, or columns. Renaming will cause the data load to produce an error.
DSO Data
To enter new DSO values for a Fiscal Year, follow the instructions below.
Open the DSOData.xlsx file.
Enter Fiscal Year, DSO Name, FAST Department ID, Federal Expense and Total Expense. Please do not change the name of the columns.
The file will automatically save the changes.