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 CPP 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. CPP_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 ACAD_CAREER_CODE varchar(4)
The academic career leading to an undergraduate (certificate, associate's, bachelor's), graduate (master's, doctorate), or professional (law, medical) degree
DENT [Dental]
GRAD [Graduate]
LAWS [Law]
MEDS [Medical]
NOCR [Non-Credit]
UGRD [Undergraduate]
5 ACAD_PLAN_CODE varchar(10)
Program of study code.

6 ACAD_PLAN_DESCR_PPS varchar(100)
Program of study description

7 ACAD_PLAN_TYPE_CODE varchar(3)
CON [Concentration]
COS [Course of Study]
CRT [Certificate]
LIC [Licensure]
MAJ [Major]
MIN [Minor]
NON [Non Degree Seeking]
OPT [Option]
POS [Program of Study]
PRP [Preparation]
SP [Specialization]
TRK [Track]
8 ACAD_PLAN_CIP varchar(7)
CIP Code Associated with the Academic Plan. Must be a VALID CIP and in this format ##.####

9 ACAD_SUB_PLAN_CODE varchar(10)

10 ACAD_SUB_PLAN_DESCR varchar(30)

11 ACAD_SUB_PLAN_TYPE_CODE varchar(5)

12 ACAD_SUB_PLAN_TYPE_DESCR varchar(30)

13 ACAD_SUB_PLAN_CIP varchar(7)
CIP Code Associated with the Academic Plan. Must be a VALID CIP and in this format ##.####

14 ACAD_LEVEL_CODE varchar(3)
Undergraduate standing defined by Board policy according to the number of credits earned. Graduate standing, professional standing, non-admits, and non-degree seeking students assigned a standing not determined by number of credits earned
10 [Freshman]
20 [Sophomore]
30 [Junior]
40 [Senior]
50 [Ugrd with Bacc]
GR [Graduate]
GS [Graduate Special]
HS [High School]
MAS [Masters]
NDG [Non-degree]
P09 [Professional - Certificate Program]
P1 [Professional Year 1]
P2 [Professional Year 2]
P3 [Professional Year 3]
P4 [Professional Year 4]
PD [Professional Degree]
PHD [Doctoral]
PM [Graduate - Specialist Level (EDS)]
15 ACAD_PROGRAM_CODE varchar(5)

16 ACAD_PROGRAM_DESCR varchar(30)

17 ACAD_PLAN_DESCR varchar(100)
COLUMN REQUIRED - NSHE USE ONLY . Leave Blank (NSHE standardized plan description)

18 DEGREE_TYPE varchar(2)
COMPLETIONS: Type of degree awarded. (Do not use '00')
CPP: Level of award to which the student is admitted. Students admitted to a degree program as a pre-major or undeclared will be coded according to the level of the award sought.
Codes must include leading zero
00 [Non-Degree Seeking]
01 [Certificate of Less Than One Year]
02 [Certificate of at Least One But Less Than Two Years]
03 [Associate's Degree]
04 [Bachelor's Degree]
05 [Master's Degree]
06 [Graduate Certificate]
07 [First Professional Degree]
08 [Professional Certificate]
09 [Undergraduate Certificate]
10 [Post Baccalaureate Certificate]
11 [Post Master's Certificate]
12 [Doctoral Degree (Academic)]