Undergraduate and Graduate counts are in nested reports (for example, r_ipeds_fall_ef1_undergrad_part_a and r_ipeds_fall_ef1_grad_part_a).

IPEDS Fall Enrollment
	Part A	EF1	r_ipeds_fall_ef1_part_a
		EF2	r_ipeds_fall_ef2_part_a
		EF3-PRIV	r_ipeds_fall_ef3_private_part_a
		EF3-PUB	r_ipeds_fall_ef3_public_part_a
	Part B	EF1	r_ipeds_fall_ef1_part_b
		EF2	r_ipeds_fall_ef2_ef3_part_b
		EF3-PRIV	r_ipeds_fall_ef2_ef3_part_b
		EF3-PUB	r_ipeds_fall_ef2_ef3_part_b
	Part C	EF1	r_ipeds_fall_ef_part_c
		EF2	r_ipeds_fall_ef_part_c
		EF3-PRIV	r_ipeds_fall_ef_part_c
		EF3-PUB	r_ipeds_fall_ef_part_c
	Part D	EF1	r_ipeds_fall_ef1_ef-2_part_d
		EF2	r_ipeds_fall_ef1_ef-2_part_d
		EF3-PRIV	No report
		EF3-PUB	No report
	Part E	EF1	r_ipeds_fall_ef_part_e
		EF2	r_ipeds_fall_ef_part_e
		EF3-PRIV	r_ipeds_fall_ef_part_e
		EF32-PUB	r_ipeds_fall_ef_part_e
	Part F	EF1	r_ipeds_fall_ef_part_f
		EF2	r_ipeds_fall_ef_part_f
		EF3-PRIV	r_ipeds_fall_ef_part_f
		EF3-PUB	r_ipeds_fall_ef_part_f

Part A report displays the total number of Male and Female Undergraduate and Graduate students under the 99.0000 CIP Code. The additional CIP groupings are summary counts NCES wants if you have students with CIPs in those groupings.

i.      To drill down to the counts, click the plus signs.

ii.    To see the ID Number and name of each student that makes up each count, click the plus sign to the left of the "Ethnic/Race" label.

iii.  If you have any "Unknown" labels, these indicate that you are still missing information for one or more students that are flagged for IPEDS in the Institutional Research Student Data Records window.

Part B report displays Fall Enrollment by Age and Gender for both Undergraduate and Graduate Students.

Part C report displays Residence of First-time Undergraduate Students. The second column provides counts of those who graduated from high school or received a GED in the last 12 months.

Part D report displays totals for entering undergraduate students (First Time in Postsecondary or Transfer In). The value reported in Part D is how many of the entering students are non-degree seeking.

Part E report displays the Retention Rate for last year's First-Time, Degree Seeing, Undergraduate students. The report displays the data stored in the IR_IPEDS_SNAPSHOT_EXT table. This data can be maintained in the Create/Work with Snapshots window on the Additional IPEDS Data tab when the focus is on the Snapshot Date.

Part F report displays your Student-to-faculty ratio. J1 does not calculate this data but displays the ratio you stored in the IR_IPEDS_SNAPSHOT_EXT table. This data can be maintained in the Create/Work with Snapshots window on the Additional IPEDS Data tab when the focus is on the Snapshot Date.

 

IPEDS 12-Month Enrollment
	Part A	EF1	r_ipeds_12month_enrollment_part_a	Displays the 12-month Unduplicated Count by Race/Ethnicity and Gender
	Part B	EF1	r_ipeds_12month_enrollment_part_b	Displays the 12-month Instructional Activity of total Credit Hours and total Clock Hours for the undergraduate students reported in Part A and the total Credit Hours for the graduate students reported in Part A

 

The purpose of the Completions component of IPEDS is to collect data on the number of awards conferred by postsecondary institutions during the 12-month time period beginning July 1 of the previous calendar year and ending June 30 of the current calendar year. The reported awards range from sub-baccalaureate certificates to doctor's degrees and must be formal credit awards conferred by the postsecondary institution as the result of completion of an academic or occupational/vocational program of study (the program's instructional activity can be measured in credit hours, contact hours, clock hours, or some other unit of measurement). Data are collected by race/ethnicity and gender for each award level within each program (as defined by 6-digit CIP codes). Data are collected for both first and second major fields of study.

IPEDS Completions
	Part A	r_ipeds_completions_part_a	Displays the counts for all completions.
	Part B	r_ipeds_completions_part_b	Displays Distance Education Status counts for programs by CIP Code and Award Level.
	Part C	r_ipeds_completions_part_c	Displays unduplicated counts by Race/Ethnicity and Gender.
	Part D	r_ipeds_completions_part_d	Displays unduplicated counts by Gender, Race/Ethnicity, and Age for the following award levels: ·       Less than 1-year certificates ·       At least 1 but less than 4-year certificates ·       Associate's Degrees ·       Bachelor's degrees ·       Postbaccalaureate and Post-Master's certificates ·       Master's degrees ·       Doctor's degrees

 

GRS: 4 Year Institution Report

There are 3 sections (1, 2, and 3) in the GRS report for 4-year schools.

SECT. 1 (Section 1)	r_ir_ipeds_g1_1
SECT. 2-1 (Section 2, Page 1)	r_ir_ipeds_g1_2_1
SECT. 2-2 (Section 2, Page 2)	r_ir_ipeds_g1_2_2
SECT. 2-3 (Section 2, Page 3)	r_ir_ipeds_g1_2_3
SECT. 3-1 (Section 2, Page 1)	r_ir_ipeds_g1_3_1
SECT. 3-2 (Section 3, Page 2	r_ir_ipeds_g1_3_2

 

Section 1 displays the Revised Cohort number with sub-cohorts of

§      Those seeking a bachelor's degree

§      Those seeking other than a bachelor's degree

 

Section 2 displays the data for students whose original intent was to seek a Bachelor's degree:

§       Page 1 displays completers of programs < 2 years, 2 < 4 years, and Bachelor's degree.

§       Page 2 displays the students who transferred out or left for reasons counted as exclusions and students still enrolled in programs of 5 years or longer.

§      Page 3 displays the students who transferred out or left for reasons counted as exclusions and students still enrolled in programs of 5 years or longer.

 

Section 3 displays the data for students whose original intent was to seek a degree other than a Bachelor's degree:

§      Page 1 displays completers of programs < 2 years, 2 < 4 years, and Bachelor's degree.

§       Page 2 displays the students who transferred out or left for reasons counted as exclusions and students still enrolled in programs of 5 years or longer.

 

GRS: 4-Year Institution Web Import

Web Import File Query

d_q_ir_ipeds_grs_g1_v

The query selects "record" from ir_ipeds_grs_g1_export_v. The record column is the output of the export view that generated the Key Pair Values that allow the data to be imported on the NCES website. You can view the import specifications at https://surveys.nces.ed.gov/ipeds.

 

GRS: 2-Year Institution Reports

There is 1 section (3) in the GRS report for 2-year schools.

SECT. 3-1 (Section 1, Page 1)	r_ir_ipeds_g2_3_1
SECT. 3-2 (Section 3, Page 2)	r_ir_ipeds_g2_3_2

Section 3 displays the data for students whose original intent was to seek a degree other than a Bachelor's degree:

§       Page 1 displays completers of programs < 2 years and 2 < 4 years.

§       Page 2 displays the students who transferred out or left for reasons counted as exclusions and students who completed in 100% of Normal Time in programs < 2 years and 2 < 4 years and still enrolled in programs of 3 years or longer.

 

GRS: 2-Year Institution Web Import

Web Import File Query

d_q_ir_ipeds_grs_g2_v

The query selects "record" from ir_ipeds_grs_g2_export_v. The record column is the output of the export view that generated the Key Pair Values that allow the data to be imported on the NCES website. You can view the import specifications at https://surveys.nces.ed.gov/ipeds.

 

GRS: Less than 2-Year Institution Reports

There is 1 section (3) in the GRS report for Less than 2-year schools.

SECT. 3 (Section 3)

r_ir_ipeds_g3_3_1

Section 3 displays the data for students whose original intent was to seek a degree other than a Bachelor's degree:

§      Page 1 displays all of the following: Revised Cohort, Total Exclusions, Completers in 100%, Completers in 150%, Total Transfer-out, Non-completers still enrolled, and Completers in Over Normal Time.

 

GRS: Less than 2-Year Institution Web Import

Web Import File Query

d_q_ir_ipeds_grs_g3_v

The query selects "record" from ir_ipeds_grs_g3_export_v. The record column is the output of the export view that generated the Key Pair Values that allow the data to be imported on the NCES website. You can view the import specifications at https://surveys.nces.ed.gov/ipeds.

 

GR200: 4-Year, 2-Year, and Less than 2-Year Institution Reports

The GR200 Report shows the following data for students who have now completed or are exclusions since the cohort was previously reported in the standard GRS report:

Lines 6 and 8 are the values that are included in the Web Import File.

PART A

r_ir_ipeds_gr200_g21

 

GR200: 4-Year Institution Web Import

Web Import File Query

d_q_ir_ipeds_gr200_g21_v

The query selects "record" from ir_ipeds_gr200_g21_export_v. The record column is the output of the export view that generated the Key Pair Values that allow the data to be imported on the NCES website. You can view the import specifications at https://surveys.nces.ed.gov/ipeds.

 

GR200: 2-Year Institution Web Import

Web Import File Query

d_q_ir_ipeds_gr200_g22_v

The query selects "record" from ir_ipeds_gr200_g22_export_v. The record column is the output of the export view that generated the Key Pair Values that allow the data to be imported on the NCES website. You can view the import specifications at https://surveys.nces.ed.gov/ipeds.

 

You can select the J1 <Original> query that selects IR_IPEDS_E12_V. This view creates each of the Key Value Pairs that you need to report for each IPEDS Report. The J1 logic generates the .txt file for import based on the view. This means that you can do the following:

o     Make any changes using the IR_STUDENT_DATA_UDF table

o     Use the stored procedure shell to update the column in the _UDF table

o     Modify the IPEDS reports to include columns on the _UDF table

o     Modify the IR_IPEDS_E12_V% for new Key Value Pairs

o     Modify the Web Import File Query to select the modified view

This button creates the .txt file of Key Value Pairs based on the selected view. A window is displayed and prompts you to enter a path to the file that is being created.

This link is the Internet address of NCES that is stored in the IPEDS Web Link column on the IPEDS Configuration window.

This checkbox is displayed only for EF1, EF2, or EF 3 (Fall Enrollment). This checkbox allows you to appropriately select CIP codes for IPEDS reporting based on NCES regulations for the reporting period. The default is Y, which is set in the Maintain Config Table window. If you select this checkbox, only the CIP Code 99.0000 is included.

This checkbox is displayed only for EF1, EF2, or EF 3 (Fall Enrollment). This checkbox allows you to appropriately generate Part C values in the Web Import text file for IPEDS reporting based on NCES regulations for the reporting period. The default is Y, which is set in the Maintain Config Table window. If you select this checkbox, rows for Part C are included.

The File Location displays the path of the .txt file where the import file is stored. Use the browse button (...)  to locate the report file you want to display in the Report column.

The Open in Notepad button opens the currently selected .txt file in Notepad.

1.    Open the Regulatory Reporting window, and select the appropriate report in the Regulatory Forms drop-down list in the header.

2.    Select the appropriate Part on the Report tab.

3.    View and modify the data, if necessary.

4.    Select the Web Import File tab.

5.    Select and customize the Web Import File Query, if necessary.

6.    Click the Create the Web Import File button.

7.    The Web Import File Path window appears with a default path and file name. You may change the path location of the file if you wish. If you do so, the next time this window opens, it will default to the most recently used path.

8.    Click the IPEDS Web link, which will automatically open your browser and take you to the NCES/IPEDS Web page.

9.    Click on the Web-Based Data Collection System link, and follow the instructions for uploading your file.