{"id":2123,"date":"2024-02-22T17:09:52","date_gmt":"2024-02-22T22:09:52","guid":{"rendered":"https:\/\/help.studentclearinghouse.org\/stcu\/knowledge-base\/control-report-2\/"},"modified":"2026-10-22T01:59:33","modified_gmt":"2026-10-22T01:59:33","slug":"aggregate-report","status":"publish","type":"ht_kb","link":"https:\/\/help.studentclearinghouse.org\/stcu\/knowledge-base\/aggregate-report\/","title":{"rendered":"Aggregate Report"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">The Clearinghouse system generates the aggregate report for DA, PA, and SE queries. It provides the most commonly attended institutions based on the search begin date. The data only contains information on students&#8217; initial enrollment and degree. You can find additional detailed information about each student\u2019s enrollment history in the <a class=\"heroickb_exit_link\" href=\"?hkb-redirect&#038;nonce=aae44fb4ba&#038;check=2s3je&#038;redirect=https%3A%2F%2Fhelp.studentclearinghouse.org%2Fstcu%2Fknowledge-base%2Fdetail-report%2F&#038;otype=unknown&#038;oid=0&#038;source=block-content\">detail report<\/a>. The data is aggregate and includes counts of all matched students that meet the search criteria, even if the student records are blocked.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>DA &amp; SE Queries:<\/strong> The record must have a term end date that is greater than the search date. The system determines initial enrollment by the earliest term begin date and considers the school with the latest enrollment to be the initial school.<\/li>\n\n\n\n<li><strong>PA Queries:<\/strong> The record must have a term end date that is earlier than the search date. The system determines initial enrollment by the earliest term begin date.<\/li>\n\n\n\n<li><strong>CO Queries:<\/strong> The system generates a <a href=\"https:\/\/help.studentclearinghouse.org\/stcu\/knowledge-base\/cohort-report\/\">cohort report<\/a> in place of the aggregate report.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading has-open-sans-font-family\" style=\"font-style:normal;font-weight:500\">Example Aggregate Report<\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"\/stcu\/wp-content\/uploads\/2024\/02\/aggregatereportsample-1.png\" alt=\"Visual sample of a Aggregate Report.\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h2 class=\"wp-block-heading has-open-sans-font-family\" style=\"font-style:normal;font-weight:500\">Aggregate Report Filename Format<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><em>[Sending FTP Account]_[Submission ID]_AGGRPT_[Search Option]_[Date and Time]_[Batch Query File Name].csv<\/em><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Example Filename<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>001234ST_250966_AGGRPT_SE_06302016120000_SPR2005_COHORT2.CSV<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>The Clearinghouse system generates the aggregate report for DA, PA, and SE queries.<\/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-2123","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\/2123","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=2123"}],"version-history":[{"count":5,"href":"https:\/\/help.studentclearinghouse.org\/stcu\/wp-json\/wp\/v2\/ht-kb\/2123\/revisions"}],"predecessor-version":[{"id":3056,"href":"https:\/\/help.studentclearinghouse.org\/stcu\/wp-json\/wp\/v2\/ht-kb\/2123\/revisions\/3056"}],"wp:attachment":[{"href":"https:\/\/help.studentclearinghouse.org\/stcu\/wp-json\/wp\/v2\/media?parent=2123"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/help.studentclearinghouse.org\/stcu\/wp-json\/wp\/v2\/ht-kb-category?post=2123"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/help.studentclearinghouse.org\/stcu\/wp-json\/wp\/v2\/ht-kb-tag?post=2123"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}