The detail report provides all postsecondary term information the Clearinghouse system was able to locate and return on your students within your search variables. Each row contains information on one postsecondary term or degree (if available).
Detail Report Filename Format
[Account_Submission ID]_DETRPT_[Search Option]_[Date and Time]_[Batch Query File Name].csv
Example Filename
001234ST_250966_DETRPT_SE_06302016120000_SPR2005_COHORT2.CSV
Detail Report Details
Student Information
Columns A through H of the detail report contain the information you entered for each student in your batch query file. In the following sample report, Darren A. Young appears twice. This is because Darren has two postsecondary terms within this file’s search range.
Enrollment Information
Columns I through U of the detail report contain student enrollment information as reported by institutions. Columns N and O list the term begin and end dates. Your institution must submit expanded data elements in your enrollment reporting files in order to receive the expanded data in columns Q through U.
Enrollment Status (column P) might not be returned in reports for specific students if their reporting institution does not consider it directory information, which blocks the data element from being released.
This section shows that Darren A. Young attended Raffles Community College (a two-year, public college in California) in the fall 2015 and spring 2016 terms. Both of Darren’s terms were less-than-half time (L), meaning he only took one or two courses at Raffles each reported term.
Degree Information
Columns V through AG of the detail report contain degree information, if available. Your institution must be active with the DegreeVerify service in order for you to receive degree information in your reports. Active Expanded Data Discount schools receive the data in these columns.
While Darren did not receive any degrees within the search range, Frank Hwang received two bachelors of the arts in architecture and in Chinese in the spring 2013 semester.
Fields
Column | Field Name | Max. Length | Format | Description |
A | Your Unique Identifier | 16 | Alphanumeric | Student’s Social Security number as provided in your request file. In order to preserve number formatting, each SSN ends in an underscore (e.g. 123456789_). This field is used only for PA queries. |
B | First Name | 20 | Alphanumeric | Student’s first name as provided in your request file. |
C | Middle Initial | 1 | Alphanumeric | Student’s middle initial as provided in your request file. |
D | Last Name | 20 | Alphanumeric | Student’s last name as provided in your request file. |
E | Name Suffix | 5 | Alphanumeric | Student’s name suffix as provided in your request file (e.g. III, Jr., Sr.). |
F | Requestor Return Field | 50 | Alphanumeric | Data you provided in the Requestor Return field of your request file (e.g. cohort identification, unique student ID, etc.). If you did not provide data, the field is blank. |
G | Record Found | 1 | Y/N |
|
H | Search Date | 8 | Numeric | Search date provided in your request file. |
I | College Code/Branch | 9 | Alphanumeric | OPE/FICE code of the institution the student attended. |
J | College Name | 40 | Alphanumeric | Name of the institution the student attended. |
K | College State | 2 | Alphanumeric | State in which the institution is located. |
L | 2-year/4-year | 1 | Alphanumeric | Type of college that the student attended.
|
M | Public/Private | 7 | Alphanumeric | Indicates whether the institution the student attended is a public or private institution. |
N | Enrollment Begin | 8 | Alphanumeric | Begin date for the student’s period of attendance. |
O | Enrollment End | 8 | Alphanumeric | End date for the student’s period of attendance. |
P | Enrollment Status | 1 | Letter | The last enrollment status reported for the student.
This field is blank if the reporting institution has not defined the student’s enrollment status as directory information. |
Q | Class Level | 1 | Letter | If available, the class level associated with the student as provided by the reporting institution.
|
R | Enrollment Major 1 | 80 | Alphanumeric | If available, the major associated with the student’s enrollment record as provided by the reporting institution. |
S | Enrollment CIP 1 | 6 | Numeric | If available, the NCES CIP code for major 1. |
T | Enrollment Major 2 | 80 | Alphanumeric | If available, the second major associated with the student’s enrollment record as provided by the reporting institution |
U | Enrollment CIP 2 | 6 | Numeric | If available, the NCES CIP code for major 2. |
V | Graduated? | 1 | Y/N | Graduation status information available from the reporting institution.
|
W | Graduation Date | 8 | Alphanumeric | Date of student’s graduation or degree as provided by the reporting institution. |
X | Degree Title | 80 | Alphanumeric | If available, the title of the degree the student received as provided by the reporting institution. |
Y | Degree Major 1 | 80 | Alphanumeric | If available, the major associated with the student’s degree as provided by the reporting institution. |
Z | Degree CIP 1 | 6 | Numeric | If available, the NCES CIP code for major 1. |
AA | Degree Major 2 | 80 | Alphanumeric | If available, the second major associated with the student’s degree as provided by the reporting institution. |
AB | Degree CIP 2 | 6 | Numeric | If available, the NCES CIP code for major 2. |
AC | Degree Major 3 | 80 | Alphanumeric | If available, the third major associated with the student’s degree as provided by the reporting institution. |
AD | Degree CIP 3 | 6 | Numeric | If available, the NCES CIP code for major 3. |
AE | Degree Major 4 | 80 | Alphanumeric | If available, the fourth major associated with the student’s degree as provided by the reporting institution. |
AF | Degree CIP 4 | 6 | Numeric | If available, the NCES CIP code for major 4. |
AG | College Sequence 2 | 2 | Numeric | The sequential order of each institution the student attended.
|