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.
| Due Date | Report / File Name | Notes and/or Special Instructions |
|---|---|---|
| Oct 15, 2019 | Completions | Submit file using the NSHE IR File Requests Upload Page |
| Oct 18, 2019 | Official Enrollment Report | Submit file using the NSHE IR File Requests Upload Page |
| Jan 20, 2020 | APScores | Submit file using the NSHE IR File Requests Upload Page
The data for this report will include all data from Fall 2011 (term begins date) to the DATE when you take your institution's snapshot for the semester you are reporting. |
| Jan 20, 2020 | Cohort | Submit file using the NSHE IR File Requests Upload Page |
| Jan 20, 2020 | CPP | Submit file using the NSHE IR File Requests Upload Page |
| Jan 20, 2020 | Enrollment | Submit file using the NSHE IR File Requests Upload Page |
| Jan 20, 2020 | Student | Submit file using the NSHE IR File Requests Upload Page |
| Jan 20, 2020 | Taxonomy | Submit file using the NSHE IR File Requests Upload Page |
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. TAXONOMY_TMCC1_2198_12062019.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 | DOCTORAL_FLAG | varchar(1) | Y = Student in a doctoral program. N=Student not in a doctoral program. | N [No] Y [Yes] |
| 5 | COURSE_LEVEL | varchar(2) | Lower Division, Upper Division, Master, Doctoral | DC [Doctoral] LD [Lower Division] MA [Masters] UD [Upper Division] |
| 6 | CLASS_NUMBER | varchar(5) | Unique identifier for a section of the class in a given term. | |
| 7 | SUBJECT_CODE | varchar(8) | Code that identifies the subject area of a course (i.e. MATH, ENGL) | |
| 8 | CATALOG_NUMBER | varchar(10) | The official number or other identifier that serves to uniquely identify a course within the offering academic unit. Board policy also uses the course number to identify the level of the course (Remedial/developmental courses 001-099, Lower-division 100-299, Upper-division 300-499, State College Graduate Courses 500-699, University Graduate Courses 500-799) "101" in Psychology 101. | |
| 9 | COURSE_SUFFIX | varchar(1) | COLUMN REQUIRED - Leave Blank | |
| 10 | CLASS_SECTION | varchar(4) | The section number of a course | |
| 11 | COURSE_TITLE | varchar(30) | The name of the course as it appears in the catalog | |
| 12 | COURSE_UNITS | number(5,2) | Indicates the number of student credit hours for the enrollment | |
| 13 | OFFICIAL_RESIDENCY_CODE_TAXONOMY | varchar(2) | Residency Determination for tuition purposes: In-state or out-of-state.
i.e. Teaching and Research Assistants who receive waivers of out-of-state tuition should be coded as IS for the term in which they receive the waiver. | IS [In State] OS [Out of State] |
| 14 | COURSE_OFFICIAL_GRADE | varchar(3) | The student's final grade in the course - if a grade used at your institution is not found in the acceptable list and you think it should be in the list, please contact the IR office. | A A- AD AU B B+ B- C C+ C- D D+ D- F I IP NR P R S U W X |
| 15 | DATE_LAST_ATTENDANCE | date | Last day of attendance for all F grades. Must be in this format MM/DD/YYYY | |
| 16 | COURSE_START_DATE | date | The Course Start Date - Must be in this format MM/DD/YYYY | |
| 17 | COURSE_END_DATE | date | The Course End Date - Must be in this format MM/DD/YYYY | |
| 18 | LATE_END_DATE_FLAG | varchar(1) | Y = Course end date occurs after the term end date defined in Board procedure (Dec. 31 for fall, June 10 for spring, and Aug. 20 for Summer) | N [No] Y [Yes] |
| 19 | UGRD_DEGREE_SEEKING_FLAG | varchar(1) | UGRD students only: Y or N | N [No] Y [Yes] |