IND-GEN - Setup Do you have either a) new trainees OR b) updates to provide for trainees from a previous reporting period? | Yes (complete IND-GEN) No (click Save and Validate button to proceed to the next form) |
Figure 1. IND-GEN - Setup
Do you have either a) new trainees OR b) updates to provide for trainees from a previous reporting period?: Warning If you have used the INDGEN form before, this answer is pre-selected ‘Yes’ for you. You do not need to answer this question again. Please move ahead to the INDGEN form by using the form list located on the left side of your screen. Warning If you are unable to enter data into the INDGEN form, edit prior records, or see drop-down menus despite the question above being answered ‘Yes’, you have a browser compatibility problem. Please refer to the Getting Started-Browser Settings page at the beginning of this manual.
Warning Gray fields in prior records cannot be edited.
Warning Prior records cannot be deleted. |
IND-GEN - Excel Upload (optional)Warning Do not modify the format. For example: renaming the columns, deleting columns, or renaming worksheets. Users must download and use the file from EHB. The system will not upload/process a different format.
Warning The ‘Type of Training Program’ (Column 1) and ‘Trainee Unique ID’ are key columns. These columns must be complete for the row to be uploaded and processed into EHB. If one or both of these columns are not complete, then the row of data will not be processed in EHB.
Warning If you edit your INDGEN data in EHB, you must click the “Generate Template with most recent INDGEN data’ button before downloading the template. If you fail to do so, your Excel template will not reflect the changes you made and may cause issues when you upload/process your data. You can generate and download the Excel template to enter the trainee information on the INDGEN form. Use of the Excel template is optional. If you plan to use it, please read the instructions carefully. - You can generate the Excel template by clicking the ‘Generate Template with most recent INDGEN data’ button.
- You can download the Excel template by clicking the ‘Download Template’ button.
- After downloading the file, save the INDGEN template on your local computer. To save in a particular location, click the arrow next to the Save button and select the Save As option.
- Then you can enter the data in the Excel Template file. After completing the file, click the Browse button to locate your completed INDGEN form on the computer. If applicable, add a description in the textbox field. Click the Upload button to attach the completed INDGEN form.
- Click on the ‘Process Data’ button to view the INDGEN data on your screen.
- You can add or modify the data within EHB once it is uploaded. Note that the system will check for errors and prompt you to fix them before you can save and validate the form.
Types of Data Fields: - Data Entry fields – For these fields, users can copy/paste allowable values and/or enter valid data in the cell or in the formula bar (if required) – e.g., Trainee Unique ID.
- Single-Select dropdown fields – For these fields, users can copy/paste allowable values (note they must match the selection option exactly), select an option from the list of pre-set choices in the dropdown box, and/or enter the valid selection in the cell or in the formula bar – e.g., Select Individual’s Training or Awardee Category.
- Multi-Select dropdown fields – For these fields, users can copy/paste allowable values (note they must match the selection options exactly) and/or select one or more options from the list of pre-set choices in the dropdown box – e.g., Select Individual’s Race. Please do not try to enter data into the cell or the formula bar for this type of field, as it may cause errors.
General Instructions: - Previously reported training programs (i.e., prior records) will be auto-populated and displayed at the top of the page. Gray cells are not editable. If new rows are added in the IND-GEN form, the Record Status, City, and State columns remain non-editable and empty (see below for additional details).
- To enter a new record, users should start on the next blank row, select the ‘Type of Training Program’, and enter the ‘Trainee Unique ID’. While the Record Status will be new, that column is not editable and will remain empty. Once the template is uploaded and processed, the ‘New Record’ status will be displayed in EHB.
- Training programs with at least one active Fellowship Program, Major Participating Site/Rotation Site, or Residency Program will be populated in the ‘Type of Training Program’ dropdown list in the IND-GEN. The list is derived from the Training Program – Setup form.
- The City and State columns are not editable and will remain empty even if the user enters the Zip Code. Once the template is uploaded and processed, as long as a valid Zip Code is provided, the City and State will be populated in EHB.
Copying and Pasting Data: - Users can copy and paste data from another source/file into Data Entry, Single-Select Dropdown, and Multi-Select Dropdown fields.
- The values provided for Single-Select or Multi-Select fields must exactly match the values that exist in the system. This includes having the same spelling, spacing, and punctuation (hyphens, etc.). Capitalization does not matter. Values for Multi-Select fields must be separated by a comma and a space.
Multi-Selecting and Unselecting Pre-Set Options: - For the multi-select fields, users can select one or more pre-set options in the dropdown list. Users will have to select the options one at a time. However, the pre-set options will be concatenated in the field.
- To unselect one or more pre-set options, users can click on the pre-set option(s) a second time. This will remove the option from the field.
Validations: - Validations are embedded within the Excel template.
- Validations will fire:
- When a required field is missing,
- When there is a conditional validation on two or more columns,
- When a pre-set selection option cannot be combined with other pre-set options (specifically for multi-select fields), and
- When the value of the cell is changed (i.e., a different selection value is selected, the data is deleted, or the text field does not match the data type).
- When a validation fires, the user can correct the field or leave it as is. Users can still upload the template into EHB and fix any remaining validation errors in EHB as long as data has been selected/entered in Column 1 and Column 2.
Uploading the Excel File in EHB: - Once you have completed the Excel file:
- Log into HRSA EHB,
- Access the Annual Performance Report,
- Navigate to the INDGEN form,
- Click the "Attach File" button,
- Select the completed INDGEN template,
- Upload your Excel file
- Click the ‘Process Data’ button, and
- Confirm that the data transferred successfully, enter missing fields, and fix validation errors.
Note Once the excel template has been processed in EHBs, the row numbers in EHBs will not match the row numbers in the excel template. |
IND-GEN - Selecting Type of Training Program Figure 2. IND-GEN - Selecting Type of Training Program
Type of Training Program: Select each individual's training program by clicking on the drop-down menu under the column labeled "Type of Training Program" and choosing one of the available options. Note The options available under "Type of Training Program" will prepopulate with information entered and saved in the Training Program Setup Form.
Note This program is no longer able to select "Other" for Type of Training Program. Also, prior records for faculty who had a Type of Training Program of "Other" were deleted. Note This column will prepopulate for prior records with data submitted in the previous reporting period. Prior data cannot be altered or deleted. Example: The School of Medicine saved two (2) entries in the Training Program Setup form to reflect the type of programs supported by the grant. Under "Type of Training Program" the School of Medicine would see the following options: - Residency program | Internal Medicine
- Residency program | Family Medicine
|
IND-GEN - Entering Trainee Unique ID Figure 3. IND-GEN - Entering Trainee Unique ID
Trainee Unique ID: Enter a seven (7) character alphanumeric unique identifier for each individual in the textbox in Column 2 (Block 1).
Warning It is the responsibility of each grantee to generate each unique ID and keep a log of all unique IDs used, as these will be required to provide annual updates and 1-year follow-up data for each individual. Note This Block will prepopulate for prior records with data submitted in previous reporting periods. |
IND-GEN - Entering NPI Number Figure 4. IND-GEN - Entering NPI Number
NPI Number: Enter the 10-digit National Provider Identifier (NPI) number for each individual in the textbox in Column 2a. To apply for an NPI number, go to: https://nppes.cms.hhs.gov. Note NPIs are required as of AY 2022-2023. |
IND-GEN - Selecting Whether T9C Funding was used for Resident or Fellow Figure 5. IND-GEN - Selecting Whether T9C Funding was used for Resident or Fellow
Select Whether T9C Funding Was Used for Resident or Fellow: |
IND-GEN - Selecting Individual's Training or Awardee Category Figure 6. IND-GEN - Selecting Individual's Training or Awardee Category
Select Individual's Training or Awardee Category: Select each individual's training category by clicking on the drop-down menu in Column 3 (Block 2) and choosing one of the following options. Note This column will prepopulate for prior records with data submitted in the previous reporting period. Prior data cannot be altered or deleted. |
IND-GEN - Selecting whether Individual is an IMG Figure 7. IND-GEN - Selecting whether Individual is an IMG
Select Whether Individual is an International Medical Graduate (IMG): Select whether each individuals is an International Medical Graduate (IMG) by clicking on the drop-down menu and choosing one of the following options: |
IND-GEN - Selecting Individual's Enrollment/Employment Status Figure 8. IND-GEN - Selecting Individual's Enrollment/Employment Status
Select Individual's Enrollment / Employment Status: Select each individual’s current enrollment status in the program by clicking on the drop-down menu in Column 4 (Block 3) and choosing one of the following options. - Full-time
- Both Full-time and Part-time
- Part-time
- On leave of absence
|
IND-GEN - Selecting Individuals Sex Figure 9. IND-GEN - Selecting Individuals Sex
Select Individual's Sex: Select the sex that applies to each individual by clicking on the drop-down menu under column 5a and choosing the option that applies: Warning The 'Not Reported' option may not be selected for prior records. Warning'Not Reported' cannot be selected in combination with any other options under column 5a. |
IND-GEN - Entering Year of Birth Figure 10. IND-GEN - Entering Year of Birth
Enter Year of Birth: Enter each individual’s year of birth at the end of the current reporting period in the textbox in Column 6a. - 1933
- 1934
- 1935
- 1936
- 1937
- 1938
- 1939
- 1940
- 1941
- 1942
- 1943
- 1944
- 1945
- 1946
- 1947
- 1948
- 1949
- 1950
- 1951
- 1952
- 1953
- 1954
- 1955
- 1956
- 1957
- 1958
- 1959
- 1960
- 1961
- 1962
- 1963
- 1964
- 1965
- 1966
- 1967
- 1968
- 1969
- 1970
- 1971
- 1972
- 1973
- 1974
- 1975
- 1976
- 1977
- 1978
- 1979
- 1980
- 1981
- 1982
- 1983
- 1984
- 1985
- 1986
- 1987
- 1988
- 1989
- 1990
- 1991
- 1992
- 1993
- 1994
- 1995
- 1996
- 1997
- 1998
- 1999
- 2000
- 2001
- 2002
- 2003
- 2004
- 2005
- 2006
- 2007
- 2008
- 2009
- 2010
- 2011
- 2012
- 2013
- 2014
- 2015
- 2016
- 2017
- Not Reported
|
IND-GEN - Selecting Individual's Ethnicity Figure 11. IND-GEN - Selecting Individual's Ethnicity
Select Individual's Ethnicity: Select each individual’s ethnicity by clicking on the drop-down menu in Column 7 (Block 6) and choosing one of the following options: - Hispanic/Latino
- Non-Hispanic/Non-Latino
- Not Reported
Warning The 'Not Reported' option may not be selected for prior records. Note This column will prepopulate for prior records with data submitted in the previous reporting period. Prior data cannot be altered or deleted. |
IND-GEN - Selecting Individual's Race Figure 12. IND-GEN - Selecting Individual's Race
Select Individual's Race: Select each individual’s race by clicking on the drop-down menu in Column 8 (Block 7) and choosing all that apply from the available options. You may select more than one option for individuals of multiple races. - American Indian or Alaska Native
- Asian
- Black or African-American
- Native Hawaiian or Other Pacific Islander
- White
- Not Reported
Warning You may not select "Not Reported" in combination with any other option. Warning The 'Not Reported' option may not be selected for prior records. Note This column will prepopulate for prior records with data submitted in the previous reporting period. Prior data cannot be altered or deleted. |
IND-GEN - Selecting if Individual is from a Rural Residential Background Figure 13. IND-GEN - Selecting if Individual is from a Rural Residential Background
Select Whether Individual is from a Rural Residential Background: Select whether each individual is from a rural residential background by clicking on the drop-down menu in Column 9 (Block 8) and choosing one of the following options: Warning The 'Not Reported' option may not be selected for prior records. |
|