{"id":1145,"date":"2021-09-27T18:10:56","date_gmt":"2021-09-27T22:10:56","guid":{"rendered":"https:\/\/help.studentclearinghouse.org\/pdp\/?post_type=ht_kb&#038;p=1145"},"modified":"2025-06-09T14:53:56","modified_gmt":"2025-06-09T18:53:56","slug":"course-level-analysis-ready-file-data-dictionary","status":"publish","type":"ht_kb","link":"https:\/\/help.studentclearinghouse.org\/pdp\/knowledge-base\/course-level-analysis-ready-file-data-dictionary\/","title":{"rendered":"Course-Level Analysis-Ready File Data Dictionary"},"content":{"rendered":"<dl>\n<dt>First Name<\/dt>\n<dd>Student&#8217;s first name in the submission file.<\/dd>\n<dt>Middle Name<\/dt>\n<dd>Student&#8217;s middle name or first initial of middle name in the submission file.<\/dd>\n<dt>Last Name<\/dt>\n<dd>Student&#8217;s last name in the submission file.<\/dd>\n<dt>SSN<\/dt>\n<dd>Student&#8217;s Social Security number in the submission file.<\/dd>\n<dt>Date of Birth<\/dt>\n<dd>Student&#8217;s date of birth in the submission file in YYYYMMDD format.<\/dd>\n<dt>Student ID<\/dt>\n<dd>Institutionally supplied student ID number in the submission file.<\/dd>\n<dt>Student Age<\/dt>\n<dd>A student\u2019s age is calculated as: Term Start Date of the institution term listed for the designated fall term in the cohort year minus Date of Birth divided 365.25 and rounded to the nearest whole number.<\/p>\n<ul style=\"margin-top: 15px;\">\n<li>20 and younger<\/li>\n<li>&gt;20-24<\/li>\n<li>&gt;24<\/li>\n<\/ul>\n<\/dd>\n<dt>Race<\/dt>\n<dd>Student\u2019s race in the submission file.<\/p>\n<ul style=\"margin-top: 15px;\">\n<li>Nonresident Alien<\/li>\n<li>American Indian or Alaska Native<\/li>\n<li>Asian<\/li>\n<li>Black or African American<\/li>\n<li>Native Hawaiian or Other Pacific Islander<\/li>\n<li>White<\/li>\n<li>Hispanic<\/li>\n<li>Two or more races<\/li>\n<li>Unknown or missing<\/li>\n<\/ul>\n<\/dd>\n<dt>Ethnicity<\/dt>\n<dd>Ethnicity Ethnicity Student\u2019s ethnicity in the submission file.<\/p>\n<ul style=\"margin-top: 15px;\">\n<li>UK = Unknown<\/li>\n<li>H = Hispanic<\/li>\n<li>N = Not Hispanic<\/li>\n<\/ul>\n<\/dd>\n<dt>Gender<\/dt>\n<dd>Student gender reported to the PDP. If gender was not reported to the PDP, it is imported from data reported to the Clearinghouse&#8217;s enrollment reporting service. If gender was not reported to the PDP or enrollment reporting, it is imputed using methods developed by the Research Center. If gender is reported as <i>Unknown<\/i>, not reported to PDP or enrollment reporting, and cannot be imputed, the value will be <i>Unknown<\/i>.<\/p>\n<ul style=\"margin-top: 15px;\">\n<li>M = Male<\/li>\n<li>F = Female<\/li>\n<li>P = Prefer not to specify<\/li>\n<li>X = Nonbinary, intersex, and gender-nonconforming<\/li>\n<li>UK = Unknown<\/li>\n<\/ul>\n<\/dd>\n<dt>Institution ID<\/dt>\n<dd>The institution\u2019s ID (currently only OPEID) 8-digit OPEID<\/dd>\n<dt>Cohort<\/dt>\n<dd>Academic year in which the student first enrolled in at least one course in YYYY-YY format. Must match the Cohort value in the course data file. Must be 2 consecutive years between 2000 and today. Example: 2019-20<\/dd>\n<dt>Cohort Term<\/dt>\n<dd>Term student first enrolled in at least one course.<\/p>\n<ul style=\"margin-top: 15px;\">\n<li>Fall<\/li>\n<li>Winter<\/li>\n<li>Spring<\/li>\n<li>Summer<\/li>\n<\/ul>\n<\/dd>\n<dt>Academic Year<\/dt>\n<dd>Academic year in which the student was enrolled in the course in YYYY\u2013YY format.<\/dd>\n<dt>Academic Term<\/dt>\n<dd>Academic term in which the student was enrolled in the course.<\/p>\n<ul style=\"margin-top: 15px;\">\n<li>Fall<\/li>\n<li>Winter<\/li>\n<li>Spring<\/li>\n<li>Summer<\/li>\n<\/ul>\n<\/dd>\n<dt>Course Prefix<\/dt>\n<dd>Course prefix in the submission file. Course prefix as it appears in your institution\u2019s catalog. For example, ENG 101 Composition I = ENG. Can include: period, hyphen, underscore, ampersand<\/dd>\n<dt>Course Number<\/dt>\n<dd>Course number in the submission file. Course number as it appears in your institution\u2019s catalog. For example, ENG 101 Composition I = 101. Can include: period, hyphen, underscore, ampersand<\/dd>\n<dt>Section ID<\/dt>\n<dd>Section ID in the submission file. Section ID as it appears in your institution\u2019s catalog. If not available, enter Missing. Can include: period, hyphen, underscore, ampersand<\/dd>\n<dt>Course Name<\/dt>\n<dd>Course name in the submission file. Course name as it appears in your institution\u2019s catalog. For example, ENG 101 Composition I = Composition I.<\/dd>\n<dt>Course CIP<\/dt>\n<dd>Appropriate Course CIP Code. See <a href=\"https:\/\/nces.ed.gov\/ipeds\/cipcode\" target=\"_new\" rel=\"noopener\">https:\/\/nces.ed.gov\/ipeds\/cipcode<\/a> for a list of valid codes. Left blank if a code is not available.<\/dd>\n<dt>Course Type<\/dt>\n<dd>Type of course.<\/p>\n<ul style=\"margin-top: 15px;\">\n<li>CU = College\u2010level, undergraduate (credit towards certificate, associate\u2019s, or bachelor&#8217;s degree)<\/li>\n<li>CG = College level, graduate (credit towards graduate degree)<\/li>\n<li>CC = College developmental, remedial or preparatory credit towards credential completion requirements<\/li>\n<li>CD = College developmental, remedial or preparatory credits not applicable towards credential completion requirements<\/li>\n<li>EL = ESL (non\u2010credit adult basic skills courses supported by WIA Title II)<\/li>\n<li>AB = Adult basic education<\/li>\n<li>GE = Adult secondary education\/GED<\/li>\n<li>NC = Non\u2010credit vocational (courses that lead to an occupational certificate, industry certificate, or other type of credential)<\/li>\n<li>O = Other<\/li>\n<\/ul>\n<\/dd>\n<dt>Math or English Gateway<\/dt>\n<dd>Whether the course is considered a Math or English Gateway.<\/p>\n<ul style=\"margin-top: 15px;\">\n<li>M = Math<\/li>\n<li>E = English<\/li>\n<li>N = N\/A<\/li>\n<\/ul>\n<\/dd>\n<dt>Co-requisite Course<\/dt>\n<dd>Whether or not this course was a co-requisite, which enrolls students in developmental (remedial) education and college\u2010level courses in the same subject at the same time.<\/p>\n<ul style=\"margin-top: 15px;\">\n<li>Y = Yes<\/li>\n<li>N = No<\/li>\n<\/ul>\n<\/dd>\n<dt>Course Begin Date<\/dt>\n<dd>Date the student began enrollment in the course (not the registration date) in YYYYMMDD format.<\/dd>\n<dt>Course End Date<\/dt>\n<dd>Date the student ended enrollment in the course in YYYYMMDD format.<\/dd>\n<dt>Grade<\/dt>\n<dd>Grade the student earned for the course in the submission file. Student\u2019s grade for the term on a 4\u2010point scale. If a numeric grade did not apply to the course, one of the following values may appear:<\/p>\n<ul style=\"margin-top: 15px;\">\n<li>P = Pass<\/li>\n<li>F = Fail<\/li>\n<li>I = Incomplete<\/li>\n<li>W = Withdraw<\/li>\n<li>A = Audit<\/li>\n<li>M = Missing<\/li>\n<li>O = Other<\/li>\n<\/ul>\n<\/dd>\n<dt>Number of Credits Attempted<\/dt>\n<dd>Attempted Number of credits the student attempted in the course. Should be a number between 0-20.<\/dd>\n<dt>Number of Credits Earned<\/dt>\n<dd>Number of credits the student earned for the course. Should be a number between 0-20; cannot be greater than number of credits attempted<\/dd>\n<dt>Delivery Method<\/dt>\n<dd>Describes how the course was administered between teacher and student.<\/p>\n<ul style=\"margin-top: 15px;\">\n<li>F = Face-to-face<\/li>\n<li>O = Online<\/li>\n<li>H = Hybrid<\/li>\n<\/ul>\n<p>Left blank if the course was delivered by another method.<\/dd>\n<dt>Core Course<\/dt>\n<dd>Course is part of core competency\/general education courses at the institution.<\/p>\n<ul style=\"margin-top: 15px;\">\n<li>Y = Yes<\/li>\n<li>N = No<\/li>\n<\/ul>\n<p>Left blank if not applicable.<\/dd>\n<dt>Core Course Type<\/dt>\n<dd>Type of core competency. Required if Core Course = Y. Can be up to 20 characters. For example, core course type for \u201cIntroduction to Art 101\u201d is \u201cHumanities.\u201d<\/dd>\n<dt>Core Competency Completed<\/dt>\n<dd>Student completed the core\/general education course.<\/p>\n<ul style=\"margin-top: 15px;\">\n<li>Y = Core requirements evaluated and satisfied<\/li>\n<li>N = Core requirements evaluated but not satisfied<\/li>\n<\/ul>\n<\/dd>\n<dt>Enrollment Record at Other Institution(s)<\/dt>\n<dd>Whether or not the student was enrolled at another institution at the same time as this course or during this academic term (if a course record is not available).<\/p>\n<ul style=\"margin-top: 15px;\">\n<li>Y = Yes<\/li>\n<li>N = No<\/li>\n<\/ul>\n<\/dd>\n<dt>Credential Engine Identifier<\/dt>\n<dd>Course credential registry number or Credential Transparency Identifier (CTID). Serves as the primary unique identifier for all major objects in the Credential Registry and follows a standard format.<\/p>\n<div class=\"info\">\n<p><strong>Note:<\/strong> This field is optional for data submission. If not submitted by the data provider, it will not appear in the analysis-ready file.<\/p>\n<\/div>\n<\/dd>\n<dt>Course Instructor Employment Status<\/dt>\n<dd>Employment status of the course instructor reported when the student was established in the cohort (can be updated by the data submitter).<\/p>\n<ul style=\"margin-top: 15px;\">\n<li>PT = Instructor is employed part time<\/li>\n<li>FT = Instructor is employed full time<\/li>\n<\/ul>\n<div class=\"info\">\n<p><strong>Note:<\/strong> This field is optional for data submission. If not submitted by the data provider, it will not appear in the analysis-ready file.<\/p>\n<\/div>\n<\/dd>\n<dt>Course Instructor Rank<\/dt>\n<dd>Academic rank of the course instructor reported when the student was established in the cohort (can be updated by the data submitter).<\/p>\n<ul style=\"margin-top: 15px;\">\n<li>1 = Instructor<\/li>\n<li>2 = Lecturer<\/li>\n<li>3 = Senior Lecturer<\/li>\n<li>4 = Assistant Professor<\/li>\n<li>5 = Associate Professor<\/li>\n<li>6 = Professor<\/li>\n<li>7 = Other<\/li>\n<\/ul>\n<div class=\"info\">\n<p><strong>Note:<\/strong> This field is optional for data submission. If not submitted by the data provider, it will not appear in the analysis-ready file.<\/p>\n<\/div>\n<\/dd>\n<dt>Enrollment Record at Other Institution(s) OPEID(s)<\/dt>\n<dd>OPEID or OPEIDs where student was enrolled at the same time as this course or during this academic term. If enrolled in multiple other institutions, values will be pipe ( | ) delimited. Field will be blank if no other enrollments.<\/dd>\n<dt>Enrollment Record at Other Institution(s) STATE(s)<\/dt>\n<dd>State or states where student was enrolled at the same time as this course or during this academic term. If enrolled in multiple other institutions, values will be pipe ( | ) delimited in the same order as the OPEID list. Field will be blank if no other enrollments.<\/dd>\n<dt>Enrollment Record at Other Institution(s) CARNEGIE(s)<\/dt>\n<dd>Carnegie classification or classifications where student was enrolled at the same time as this course or during this academic term. If enrolled in multiple other institutions, values will be pipe ( | ) delimited in the same order as the OPEID list. Field will be blank if no other enrollments.<\/dd>\n<dt>Enrollment Record at Other Institution(s) LOCALE(s)<\/dt>\n<dd>Locale or locales where student was enrolled at the same time as this course or during this academic term. If enrolled in multiple other institutions, values will be pipe (|) delimited in the same order as the OPEID list. Field will be blank if no other enrollments.<\/p>\n<div class=\"info\">\n<p><strong>LOCALE Values: <\/strong><em>Urban <\/em>includes <em>City Large, City Midsize,<\/em> and <em>City Small<\/em> from IPEDS. <em>Suburb <\/em>includes <em>Suburb Large, Suburb Midsize, <\/em>and <em>Suburb Small<\/em> from IPEDS. <em>Town\/Rural<\/em> includes <em>Town Fringe, Town Distant, Town Remote, Rural Fringe, Rural Distant, <\/em>and <em>Rural Remote<\/em> from IPEDS.<\/p>\n<\/div>\n<\/dd>\n<dt>Term Program of Study<\/dt>\n<dd>Student\u2019s program of study based on major CIP code reported by the cohort institution for the specific term in which this course was taken.<\/dd>\n<\/dl>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Learn more about the terminology used in the Course-Level Analysis-Ready (AR) File.<\/p>\n","protected":false},"author":6,"menu_order":61,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":"","_links_to":"","_links_to_target":""},"ht-kb-category":[57,78],"ht-kb-tag":[],"class_list":["post-1145","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-about-ar-files-their-elements","ht_kb_category-institutional-researchers"],"_links":{"self":[{"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/ht-kb\/1145","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/comments?post=1145"}],"version-history":[{"count":24,"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/ht-kb\/1145\/revisions"}],"predecessor-version":[{"id":16622,"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/ht-kb\/1145\/revisions\/16622"}],"wp:attachment":[{"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/media?parent=1145"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/ht-kb-category?post=1145"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/ht-kb-tag?post=1145"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}