{"id":2128,"date":"2024-02-22T17:27:01","date_gmt":"2024-02-22T22:27:01","guid":{"rendered":"https:\/\/help.studentclearinghouse.org\/stcu\/knowledge-base\/aggregate-report-2\/"},"modified":"2026-09-16T15:57:59","modified_gmt":"2026-09-16T15:57:59","slug":"detail-report","status":"publish","type":"ht_kb","link":"https:\/\/help.studentclearinghouse.org\/stcu\/knowledge-base\/detail-report\/","title":{"rendered":"Detail Report"},"content":{"rendered":"\n

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).<\/p>\n\n\n\n

Detail Report Filename Format<\/h2>\n\n\n\n

[Account_Submission ID]_DETRPT_[Search Option]_[Date and Time]_[Batch Query File Name].csv<\/em><\/p>\n\n\n\n

Example Filename<\/strong><\/p>\n\n\n\n

001234ST_250966_DETRPT_SE_06302016120000_SPR2005_COHORT2.CSV<\/em><\/p>\n\n\n\n

Detail Report Details<\/h2>\n\n\n\n

Student Information<\/h3>\n\n\n\n
\"Visual<\/figure>\n\n\n\n

<\/p>\n\n\n\n

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\u2019s search range.<\/p>\n\n\n\n

\"Detail<\/figure>\n\n\n\n

<\/p>\n\n\n\n

Enrollment Information<\/h3>\n\n\n\n
\"Visual<\/figure>\n\n\n\n

<\/p>\n\n\n\n

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.<\/p>\n\n\n\n

Enrollment Status<\/em> (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.<\/p>\n\n\n\n

\"Enrollment<\/figure>\n\n\n\n

<\/p>\n\n\n\n

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\u2019s terms were less-than-half time (L<\/em>), meaning he only took one or two courses at Raffles each reported term.<\/p>\n\n\n\n

\"Enrollment<\/figure>\n\n\n\n

<\/p>\n\n\n\n

Degree Information<\/h3>\n\n\n\n
\"Visual<\/figure>\n\n\n\n

<\/p>\n\n\n\n

Columns V through AG of the detail report contain degree information, if available. Your institution must be active with the DegreeVerify<\/a> service in order for you to receive degree information in your reports. Active Expanded Data Discount schools receive the data in these columns.<\/p>\n\n\n\n

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.<\/p>\n\n\n\n

\"Degree<\/figure>\n\n\n\n

<\/p>\n\n\n\n

Detail Report Fields<\/h3>\n\n\n\n
\n\n\t\n\t\n\t\n\t\n\t\n\t\n <\/colgroup>\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n
Column<\/th>\n Field Name<\/th>\n Max. Length<\/th>\n Format<\/th>\n Description<\/th>\n <\/tr>\n <\/thead>\n
A<\/th>\n Your Unique Identifier<\/td>\n 16<\/td>\n Alphanumeric<\/td>\n 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_<\/em>). This field is used only for PA queries.<\/td>\n <\/tr>\n
B<\/th>\n First Name<\/td>\n 20<\/td>\n Alphanumeric<\/td>\n Student\u2019s first name as provided in your request file.<\/td>\n <\/tr>\n
C<\/th>\n Middle Initial<\/td>\n 1<\/td>\n Alphanumeric<\/td>\n Student\u2019s middle initial as provided in your request file.<\/td>\n <\/tr>\n
D<\/th>\n Last Name<\/td>\n 20<\/td>\n Alphanumeric<\/td>\n Student\u2019s last name as provided in your request file.<\/td>\n <\/tr>\n
E<\/th>\n Name Suffix<\/td>\n 5<\/td>\n Alphanumeric<\/td>\n Student’s name suffix as provided in your request file (e.g. III, Jr., Sr.<\/em>).<\/td>\n <\/tr>\n
F<\/th>\n Requestor Return Field<\/td>\n 50<\/td>\n Alphanumeric<\/td>\n Data you provided in the Requestor Return<\/em> field of your request file (e.g. cohort identification, unique student ID, etc.). If you did not provide data, the field is blank.<\/td>\n <\/tr>\n
G<\/th>\n Record Found<\/td>\n 1<\/td>\n Y\/N<\/td>\n
    \n
  • Y<\/em> = Detail report contains student\u2019s record.<\/li>\n
  • N<\/em> = Detail report does not contain student\u2019s record.<\/li>\n <\/ul><\/td>\n <\/tr>\n
H<\/th>\n Search Date<\/td>\n 8<\/td>\n Numeric<\/td>\n Search date provided in your request file.<\/td>\n <\/tr>\n
I<\/th>\n College Code\/Branch<\/td>\n 9<\/td>\n Alphanumeric<\/td>\n OPE\/FICE code of the institution the student attended.<\/td>\n <\/tr>\n
J<\/th>\n College Name<\/td>\n 40<\/td>\n Alphanumeric<\/td>\n Name of the institution the student attended.<\/td>\n <\/tr>\n
K<\/th>\n College State<\/td>\n 2<\/td>\n Alphanumeric<\/td>\n State in which the institution is located.<\/td>\n <\/tr>\n
L<\/th>\n 2-year\/4-year<\/td>\n 1<\/td>\n Alphanumeric<\/td>\n Type of college that the student attended.\n
    \n
  • 4<\/em> = 4-year or higher institution<\/li>\n
  • 2<\/em> = 2-year institution<\/li>\n
  • L<\/em> = Less than 2-year institution<\/li>\n <\/ul><\/td>\n <\/tr>\n
M<\/th>\n Public\/Private<\/td>\n 7<\/td>\n Alphanumeric<\/td>\n Indicates whether the institution the student attended is a public or private institution.<\/td>\n <\/tr>\n
N<\/th>\n Enrollment Begin<\/td>\n 8<\/td>\n Alphanumeric<\/td>\n Begin date for the student\u2019s period of attendance.<\/td>\n <\/tr>\n
O<\/th>\n Enrollment End<\/td>\n 8<\/td>\n Alphanumeric<\/td>\n End date for the student\u2019s period of attendance.<\/td>\n <\/tr>\n
P<\/th>\n Enrollment Status<\/td>\n 1<\/td>\n Letter<\/td>\n The last enrollment status reported for the student.\n
    \n
  • F<\/em> = Full-time<\/li>\n
  • Q<\/em> = Three-quarter time<\/li>\n
  • H<\/em> = Half-time<\/li>\n
  • L<\/em> = Less than half-time<\/li>\n
  • A<\/em> = Leave of absence<\/li>\n
  • W<\/em> = Withdrawn<\/li>\n
  • D<\/em> = Deceased<\/li>\n <\/ul>\n

    This field is blank if the reporting institution has not defined the student\u2019s enrollment status as directory information.<\/p><\/td>\n <\/tr>\n

Q<\/th>\n Class Level<\/td>\n 1<\/td>\n Letter<\/td>\n If available, the class level associated with the student as provided by the reporting institution.\n
    \n
  • F = Freshman (Undergraduate)<\/li>\n
  • S = Sophomore (Undergraduate)<\/li>\n
  • J = Junior (Undergraduate)<\/li>\n
  • R = Senior (Undergraduate)<\/li>\n
  • C = Certificate (Undergraduate)<\/li>\n
  • N = Unspecified (Undergraduate)<\/li>\n
  • B = Bachelor’s (Undergraduate)<\/li>\n
  • M = Master\u2019s (Graduate)<\/li>\n
  • D = Doctoral (Graduate)<\/li>\n
  • P = Postdoctorate (Graduate)<\/li>\n
  • L = First Professional (Graduate)<\/li>\n
  • G = Unspecified (Graduate\/Professional)<\/li>\n
  • A = Associate’s<\/li>\n
  • T = Post Baccalaureate Certificate<\/li>\n <\/ul><\/td>\n <\/tr>\n
R<\/th>\n Enrollment Major 1<\/td>\n 80<\/td>\n Alphanumeric<\/td>\n If available, the major associated with the student\u2019s enrollment record as provided by the reporting institution.<\/td>\n <\/tr>\n
S<\/th>\n Enrollment CIP 1<\/td>\n 6<\/td>\n Numeric<\/td>\n If available, the NCES CIP code for major 1.<\/td>\n <\/tr>\n
T<\/th>\n Enrollment Major 2<\/td>\n 80<\/td>\n Alphanumeric<\/td>\n If available, the second major associated with the student\u2019s enrollment record as provided by the reporting institution<\/td>\n <\/tr>\n
U<\/th>\n Enrollment CIP 2<\/td>\n 6<\/td>\n Numeric<\/td>\n If available, the NCES CIP code for major 2.<\/td>\n <\/tr>\n
V<\/th>\n Graduated?<\/td>\n 1<\/td>\n Y\/N<\/td>\n Graduation status information available from the reporting institution.\n
    \n
  • Y<\/em> = Institution reported the student as graduated<\/li>\n
  • N<\/em> = Institution did not report the student as graduated<\/li>\n <\/ul><\/td>\n <\/tr>\n
W<\/th>\n Graduation Date<\/td>\n 8<\/td>\n Alphanumeric<\/td>\n Date of student\u2019s graduation or degree as provided by the reporting institution.<\/td>\n <\/tr>\n
X<\/th>\n Degree Title<\/td>\n 80<\/td>\n Alphanumeric<\/td>\n If available, the title of the degree the student received as provided by the reporting institution.<\/td>\n <\/tr>\n
Y<\/th>\n Degree Major 1<\/td>\n 80<\/td>\n Alphanumeric<\/td>\n If available, the major associated with the student\u2019s degree as provided by the reporting institution.<\/td>\n <\/tr>\n
Z<\/th>\n Degree CIP 1<\/td>\n 6<\/td>\n Numeric<\/td>\n If available, the NCES CIP code for major 1.<\/td>\n <\/tr>\n
AA<\/th>\n Degree Major 2<\/td>\n 80<\/td>\n Alphanumeric<\/td>\n If available, the second major associated with the student\u2019s degree as provided by the reporting institution.<\/td>\n <\/tr>\n
AB<\/th>\n Degree CIP 2<\/td>\n 6<\/td>\n Numeric<\/td>\n If available, the NCES CIP code for major 2.<\/td>\n <\/tr>\n
AC<\/th>\n Degree Major 3<\/td>\n 80<\/td>\n Alphanumeric<\/td>\n If available, the third major associated with the student\u2019s degree as provided by the reporting institution.<\/td>\n <\/tr>\n
AD<\/th>\n Degree CIP 3<\/td>\n 6<\/td>\n Numeric<\/td>\n If available, the NCES CIP code for major 3.<\/td>\n <\/tr>\n
AE<\/th>\n Degree Major 4<\/td>\n 80<\/td>\n Alphanumeric<\/td>\n If available, the fourth major associated with the student\u2019s degree as provided by the reporting institution.<\/td>\n <\/tr>\n
AF<\/th>\n Degree CIP 4<\/td>\n 6<\/td>\n Numeric<\/td>\n If available, the NCES CIP code for major 4.<\/td>\n <\/tr>\n
AG<\/th>\n College Sequence 2<\/td>\n 2<\/td>\n Numeric<\/td>\n The sequential order of each institution the student attended.\n
    \n
  • 1<\/em> = The first record from the first institution the student attended<\/li>\n
  • 2<\/em> = The first record from the second institution the student attended<\/li>\n
  • Etc.<\/li>\n <\/ul><\/td>\n <\/tr>\n <\/tbody>\n <\/table>\n<\/figure>\n","protected":false},"excerpt":{"rendered":"

    The detail report provides all postsecondary term information the Clearinghouse system was able to locate and return on your students within your search variables.<\/p>\n","protected":false},"author":3,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"ht-kb-category":[53],"ht-kb-tag":[],"class_list":["post-2128","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-working-with-reports"],"_links":{"self":[{"href":"https:\/\/help.studentclearinghouse.org\/stcu\/wp-json\/wp\/v2\/ht-kb\/2128","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/help.studentclearinghouse.org\/stcu\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/help.studentclearinghouse.org\/stcu\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/help.studentclearinghouse.org\/stcu\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/help.studentclearinghouse.org\/stcu\/wp-json\/wp\/v2\/comments?post=2128"}],"version-history":[{"count":9,"href":"https:\/\/help.studentclearinghouse.org\/stcu\/wp-json\/wp\/v2\/ht-kb\/2128\/revisions"}],"predecessor-version":[{"id":3013,"href":"https:\/\/help.studentclearinghouse.org\/stcu\/wp-json\/wp\/v2\/ht-kb\/2128\/revisions\/3013"}],"wp:attachment":[{"href":"https:\/\/help.studentclearinghouse.org\/stcu\/wp-json\/wp\/v2\/media?parent=2128"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/help.studentclearinghouse.org\/stcu\/wp-json\/wp\/v2\/ht-kb-category?post=2128"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/help.studentclearinghouse.org\/stcu\/wp-json\/wp\/v2\/ht-kb-tag?post=2128"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}