Forms and Requests

Here you will find the forms and requests used by the NSHE Institutional Research or other Academics and Student Affairs Office. Select one of the options below to view the up-to-date forms and requests for the indicated department.


Click on the Report/File Name to view the file layout and template download.
Due Date Report / File Name Notes and/or Special Instructions
Jan 18, 2019 APScores Submit file using the NSHE IR File Requests Upload Page
The data for this report will include all data from Fall 2011 to the date when you take your institution’s snapshot for Fall reporting.
Jan 18, 2019 Cohort Submit file using the NSHE IR File Requests Upload Page
Jan 18, 2019 CPP Submit file using the NSHE IR File Requests Upload Page
Jan 18, 2019 Enrollment Submit file using the NSHE IR File Requests Upload Page
Jan 18, 2019 Official Enrollment Report Submit file using the Official Enrollment Report Form
Jan 18, 2019 Student Submit file using the NSHE IR File Requests Upload Page
Jan 18, 2019 Taxonomy Submit file using the NSHE IR File Requests Upload Page
Oct 15, 2019 Completions Submit file using the NSHE IR File Requests Upload Page

NSHE IR Student Data Warehouse STUDENT File

Please review these instructions carefully to identify updates to the templates. It is important that instructions are followed as these files are loaded to a data warehouse and the file structure affects the load. Please pay particular attention to the following:
It is important that only the number of columns listed in the template are included and that your file includes the header row even if the values in the columns are to be left blank. DO NOT add additional columns. If the number of columns in your file does not match the number of columns in the template, the file will be rejected. The column number must match in order to validate the contents of your file.

File naming for validation
File should be submitted in CSV format with the following naming convention:
FileName _ InstitutionCode _ TermCode _ DateDataPulled.csv where the DateDataPulled is in this format MMDDYYYY
(i.e. STUDENT_TMCC1_2188_12102018.csv)

Field Name / Column Heading Make sure your file contains the header row even if the values in the column are to be left blank.
*Acceptable Codes / Values: Institutions may use any codes that they find are appropriate for their own institution but when reporting to NSHE, institutions have to report the data using the codes listed in the acceptable code / values column. These codes are in bold, if applies, use these codes and NOT the code description in the [square brackets]

Column Order Field Name/Column Heading Field Type/Length Field Notes/Description Acceptable Code/Values (in bold)
1 INSTITUTION_CODE varchar(5)
A code used to identify each institution within NSHE

2 EMPL_ID varchar(10)
NSHE-wide common identification number

3 TERM_CODE varchar(4)
PeopleSoft term format

4 MILLENNIUM_ID varchar(20)
ID number assigned by the Treasurer's Office to Millennium Scholars

5 SSN varchar(9)
Social Security Number, no dashes. If SSN is not available leave blank. Do not submit 'XXXXXXXXX' or '999999999' values

6 HIGH_SCHOOL_ID varchar(50)
Identification number issued to the student by Nevada high school attended

7 LAST_NAME varchar(50)
Student's family (last) name

8 MIDDLE_NAME varchar(50)
Student's middle name

9 FIRST_NAME varchar(50)
Student's given (first) name

10 BIRTHDATE date
Student's date of birth. Must be in this format MM/DD/YYYY

11 GENDER varchar(2)
Student's gender

F [Female]
M [Male]
12 HS_LAST_ATTENDED varchar(60)
The name of the Nevada high school from which the student graduated

13 HS_GRAD_DATE date
Must be in this format MM/DD/YYYY

14 HS_GPA number(6,3)
GPA at time of graduation from high school. If no GPA is available, leave blank. Do not submit 'zero' values.

15 HS_COMPLETION_CODE varchar(8)
Type of diploma or other completion indicator.

HSADH [Advanced and Honors Diploma]
HSADJ [Adjusted High School Diploma]
HSADU [Adult High School Diploma]
HSADV [High School Advanced Diploma]
HSCPD [College Preparatory Diploma]
HSCRT [Certificate of Attendance (Did not pass the NV High School Proficiency exam)]
HSGED [High School GED]
HSHON [High School Honors Diploma]
HSIB [High School International Bacc]
HSREG [High School Regents Diploma]
HSSTD [High School Standard Diploma]
16 COUNTY_OF_ORIGIN varchar(15)
NEVADA COUNTIES ONLY - Use the county/state of the last Nevada high school attended. If that doesn't exist, use the Nevada residency county/state at the time of admission. For students whose application data is not available, use current Nevada county of residency. If the county of origin is out-of-state, use the code for Not Nevada - when reporting the codes, make sure the leading zero is included

01 [Carson City]
02 [Churchill]
03 [Clark]
04 [Douglas]
05 [Elko]
06 [Esmeralda]
07 [Eureka]
08 [Humboldt]
09 [Lander]
10 [Lincoln]
11 [Lyon]
12 [Mineral]
13 [Nye]
14 [Pershing]
15 [Storey]
16 [Washoe]
17 [White Pine]
18 [Not Nevada]
19 [Unknown]
17 IPEDS_ETHNICITY varchar(5)
The racial or ethnic background of a person used for IPEDS reporting
2ORMR [Two or more races]
AIAKN [American Indian or Alaska Native]
ASIAN [Asian]
BLACK [Black or African American]
HISPA [Hispanic or Latino]
NONRA [Non-resident Alien]
PACIF [Native Hawaiian or Other Pacific Islander]
UNKNW [Unknown]
WHITE [White]
18 EXCESS_CREDIT_FEE_FLAG varchar(1)
Flag Y if the student was charged the excess credit fee during the term for which this file is being submitted
N [No]
Y [Yes]
19 STUDENT_ID_SIS varchar(10)
COLUMN REQUIRED - NSHE USE ONLY Student ID number used in SIS. Captured for converted records

20 PERSON_KEY varchar(10)
COLUMN REQUIRED - NSHE USE ONLY - Leave Blank

21 STUDENT_KEY varchar(10)
COLUMN REQUIRED - NSHE USE ONLY - Leave Blank