Perkins E-1 Secondary Extract
Introduction
The Perkins E-1 Secondary Extract generates a tab-delimited file of Career Technical Education courses within the district for upload to the Perkins Data System. The extract utilizes the CALPADS CTE data elements to produce the file. This extract can be at the district level or sub-district level.
Selection Criteria
The extract includes records that meet the following criteria:
The student must not be excluded from state reporting.
The section enrollment must be associated with a school that is not excluded from state reporting.
The course must not be excluded from state reporting.
The section must not be excluded from state reporting.
The section enrollment must be associated with both a section and course that are not excluded from state reporting.
The section must be associated with a term within the reporting year.
The course must have a Course Content Code of 154 (Career Technical Education)
The CTE Provider on the Course or Section must not be blank.
To generate the report at the sub-district level, the Sub-district option should be enabled on the server. Make sure that you have added Sub-districts as needed for your reporting needs.
Note: The Perkins E-1 Secondary Extract uses the following matrix provided by CDE to determine which students are concentrators in particular courses. If a student has a CALPADS Student CTE record for a particular pathway and is enrolled in a qualifying course, the student will be counted as a concentrator.
Report Input
This report is run at the District level only.
For help with navigation and running the report, see How to Find and Generate a Report.
Field | Description |
|---|---|
Reporting Year | Select the academic year for which Perkins E-1 should run. The report will use July 1 – June 30 for the date range. |
Report Output
Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.
Report Output Format: The report output format for this report is tab delimited.
Item # | Data Element | Description | [Table]FieldName | Max Length |
|---|---|---|---|---|
1 | Course Code | CBEDS course code for the CTE class. Alt Course Number is used if it is populated, otherwise course number is reported. All courses marked with Course Content Code is (154) Career Technical Education within the school year are reported. Totals are summed across all sections and courses with the same CBEDS code across the district. | [Courses]alt_course_number [Courses]Course_Number [S_CA_CRS_X]ContentCode = 154 | 4 |
2 | Tech Prep |
| [S_CA_CRS_X]CTETechPrep | 1 |
3 | Gender | Aggregations are broken down by student gender. | [Students]Gender [Reenrollments]Gender | 1 |
If CTE Provider = (2) District, the course/section will appear in fields 4 – 123. If the CTE Provider = (1) ROC/P, the course/section will appear in fields 124 – 243. [S_CA_CRS_X]CTEProvider, [S_CA_SEC_X]CTEProvider | ||||
4/124 | Total Participants American Indian or Alaskan Native | A count of non-hispanic students marked with race American Indian or Alaska Native enrolled in the course for at least one day in the reporting period. Count includes Concentrators. | [CC]DateEnrolled [CC]DateLeft [StudentRace]Racecd = 100 (American Indian) and [Students]Fedethnicity is not 1 (Hispanic or Latino) and has no other [StudentRace]Racecd records in the same Federal category | 4 |
5/125 | Total Concentrators American Indian or Alaskan Native | A count of American Indian or Alaskan Native students that have a CALPADS CTE concentrator record for a qualifying pathway and enrolled in the course for at least one day in the reporting period. | [S_CA_STU_StudentCTE_C]PathwayCode [S_CA_STU_StudentCTE_C]AcademicYear | 4 |
6/126 | Concentrators in Capstone Courses American Indian or Alaskan Native | A count of American Indian or Alaskan Native concentrators in courses or sections that indicated as capstone. | [S_CA_CRS_X]CTECapstone [S_CA_SEC_X]CTECapstone | 4 |
7/127 | Concentrators in Capstone course receiving post-secondary credit at the secondary level American Indian or Alaskan Native | Not collected | N/A | 4 |
8/128 | Concentrators in Capstone course completed state or industry-recognized certification or licensure American Indian or Alaskan Native | Not collected | N/A | 4 |
9/129 | Concentrators in Capstone course receiving a “C” or better American Indian or Alaskan Native | A count of American Indian or Alaskan Native concentrators receiving a “C” or better in a stored grade that counts for credit for the course. | [StoredGrades]Course_Number [StoredGrade]Grade starts with A, B, or C [StoredGrades]earnedCrHrs > 0 [StoredGrades]TermID | 4 |
10/130 | Total 12th Grade Concentrators American Indian or Alaskan Native | A count of American Indian or Alaskan Native concentrators in the 12th grade at some point during the reporting period. | [Students]Grade_Level [Reenrollments]Grade_Level | 4 |
11/131 | 12th Grade Concentrators Proficient (3 or 4) in CAASP Eng. Lang Arts American Indian or Alaskan Native | A count of 12th grade American Indian or Alaskan Native concentrators scoring 380 or higher on the CAHSEE Eng. Lang Arts exam. | [Test]Name contains SBAC [TestScore]Name contains ELA-AL [StudentTest]NumScore of 3 or 4 | 4 |
12/132 | 12th Grade Concentrators Proficient in CAASP Math American Indian or Alaskan Native | A count of 12th grade American Indian or Alaskan Native concentrators scoring 380 or higher on the CAHSEE Math exam. | [Test]Name contains SBAC [TestScore]Name contains M-AL [StudentTest]NumScore of 3 or 4 | 4 |
13/133 | 12th Graders receiving a Diploma, GED or equivalent American Indian or Alaskan Native | A count of 12th grade American Indian or Alaskan Native concentrators with one of the following completion codes on an enrollment withing the reporting period:
| [Students]CompletionStatus in ('100','106','108','120','250','320','330') [Reenrollments]CompletionStatus in ('100','106','108','120','250','320','330') | 4 |
14/134 | Total Participants Asian | A count of non-hispanic students marked with one or more Asian races enrolled in the course for at least one day in the reporting period. Count includes Concentrators. | [CC]DateEnrolled [CC]DateLeft [StudentRace]Racecd = 201 (Chinese) or Racecd = 202 (Japanese) or Racecd = 203 (Korean) or Racecd = 204 (Vietnamese) or Racecd = 205 (Asian Indian) or Racecd = 206 (Laotian) or Racecd = 207 (Cambodian) or Racecd = 208 (Hmong) or Racecd = 299 (Other Asian) or Racecd=400 and [Students]Fedethnicity is not 1 (Hispanic or Latino) and has no other [StudentRace]Racecd records in the same Federal category | 4 |
15/135 | Total Concentrators Asian | A count of Asian students that have a CALPADS CTE concentrator record for a qualifying pathway and enrolled in the course for at least one day in the reporting period. | [S_CA_STU_StudentCTE_C]PathwayCode [S_CA_STU_StudentCTE_C]AcademicYear | 4 |
16/136 | Concentrators in Capstone Courses Asian | A count of Asian concentrators in courses or sections that indicated as capstone. | [S_CA_CRS_X]CTECapstone [S_CA_SEC_X]CTECapstone | 4 |
17/137 | Concentrators in Capstone course receiving post-secondary credit at the secondary level Asian | Not collected | N/A | 4 |
18/138 | Concentrators in Capstone course completed state or industry-recognized certification or licensure Asian | Not collected | N/A | 4 |
19/139 | Concentrators in Capstone course receiving a “C” or better Asian | A count of Asian concentrators receiving a “C” or better in a stored grade that counts for credit for the course. | [StoredGrades]Course_Number [StoredGrade]Grade starts with A, B, or C [StoredGrades]earnedCrHrs > 0 [StoredGrades]TermID | 4 |
20/140 | Total 12th Grade Co4ncentrators Asian | A count of Asian concentrators in the 12th grade at some point during the reporting period. | [Students]Grade_Level [Reenrollments]Grade_Level | 4 |
21/141 | 12th Grade Concentrators Profic4ient (3 or 4) in CAASP Eng. Lang Arts Asian | A count of 12th grade Asian concentrators scoring 380 or higher on the CAHSEE Eng. Lang Arts exam. | [Test]Name contains SBAC [TestScore]Name contains ELA-AL [StudentTest]NumScore of 3 or 4 | 4 |
22/142 | 12th Grade Concentrators Proficient in CAASP Math Asian | A count of 12th grade Asian concentrators scoring 380 or higher on the CAHSEE Math exam. | [Test]Name contains SBAC [TestScore]Name contains M-AL [StudentTest]NumScore of 3 or 4 | 4 |
23/143 | 12th Graders receiving a Diploma, GED or equivalent Asian | A count of 12th grade Asian concentrators with one of the following completion codes on an enrollment withing the reporting period:
| [Students]CompletionStatus in ('100','106','108','120','250','320','330') [Reenrollments]CompletionStatus in ('100','106','108','120','250','320','330') | 4 |
24/144 | Total Participants Black or African American | A count of non-hispanic students marked with race Black or African American enrolled in the course for at least one day in the reporting period. Count includes Concentrators. | [CC]DateEnrolled [CC]DateLeft [StudentRace]Racecd = 600 (Black or African American) and [Students]Fedethnicity is not 1 (Hispanic or Latino) and has no other [StudentRace]Racecd records in the same Federal category | 4 |
25/145 | Total Concentrators Black or African American | A count of Black or African American students that have a CALPADS CTE concentrator record for a qualifying pathway and enrolled in the course for at least one day in the reporting period. | [S_CA_STU_StudentCTE_C]PathwayCode [S_CA_STU_StudentCTE_C]AcademicYear | 4 |
26/146 | Concentrators in Capstone Courses Black or African American | A count of Black or African American concentrators in courses or sections that indicated as capstone. | [S_CA_CRS_X]CTECapstone [S_CA_SEC_X]CTECapstone | 4 |
27/147 | Concentrators in Capstone course receiving post-secondary credit at the secondary level Black or African American | Not collected | N/A | 4 |
28/148 | Concentrators in Capstone course completed state or industry-recognized certification or licensure Black or African American | Not collected | N/A | 4 |
29/149 | Concentrators in Capstone course receiving a “C” or better Black or African American | A count of Black or African American concentrators receiving a “C” or better in a stored grade that counts for credit for the course. | [StoredGrades]Course_Number [StoredGrade]Grade starts with A, B, or C [StoredGrades]earnedCrHrs > 0 [StoredGrades]TermID | 4 |
30/150 | Total 12th Grade Concentrators Black or African American | A count of Black or African American concentrators in the 12th grade at some point during the reporting period. | [Students]Grade_Level [Reenrollments]Grade_Level | 4 |
31/151 | 12th Grade Concentrators Proficient (3 or 4) in CAASP Eng. Lang Arts Black or African American | A count of 12th grade Black or African American concentrators scoring 380 or higher on the CAHSEE Eng. Lang Arts exam. | [Test]Name contains SBAC [TestScore]Name contains ELA-AL [StudentTest]NumScore of 3 or 4 | 4 |
32/152 | 12th Grade Concentrators Proficient in CAASP Math Black or African American | A count of 12th grade Asian concentrators scoring 380 or higher on the CAHSEE Math exam. | [Test]Name contains SBAC [TestScore]Name contains M-AL [StudentTest]NumScore of 3 or 4 | 4 |
33/153 | 12th Graders receiving a Diploma, GED or equivalent Black or African American | A count of 12th grade Black or African American concentrators with one of the following completion codes on an enrollment withing the reporting period:
| [Students]CompletionStatus in ('100','106','108','120','250','320','330') [Reenrollments]CompletionStatus in ('100','106','108','120','250','320','330') | 4 |
34/154 | Total Participants Hispanic or Latino | A count of Hispanic or Latino students regardless of race enrolled in the course for at least one day in the reporting period. Count includes Concentrators. | [CC]DateEnrolled [CC]DateLeft [Students]Fedethnicity = 1 (Hispanic or Latino) | 4 |
35/155 | Total Concentrators Hispanic or Latino | A count of Hispanic or Latino students that have a CALPADS CTE concentrator record for a qualifying pathway and enrolled in the course for at least one day in the reporting period. | [S_CA_STU_StudentCTE_C]PathwayCode [S_CA_STU_StudentCTE_C]AcademicYear | 4 |
36/156 | Concentrators in Capstone Courses Hispanic or Latino | A count of Hispanic or Latino concentrators in courses or sections that indicated as capstone. | [S_CA_CRS_X]CTECapstone [S_CA_SEC_X]CTECapstone | 4 |
37/157 | Concentrators in Capstone course receiving post-secondary credit at the secondary level Hispanic or Latino | Not collected | N/A | 4 |
38/158 | Concentrators in Capstone course completed state or industry-recognized certification or licensure Hispanic or Latino | Not collected | N/A | 4 |
39/159 | Concentrators in Capstone course receiving a “C” or better Hispanic or Latino | A count of Hispanic or Latino concentrators receiving a “C” or better in a stored grade that counts for credit for the course. | [StoredGrades]Course_Number [StoredGrade]Grade starts with A, B, or C [StoredGrades]earnedCrHrs > 0 [StoredGrades]TermID | 4 |
40/160 | Total 12th Grade Concentrators Hispanic or Latino | A count of Hispanic or Latino concentrators in the 12th grade at some point during the reporting period. | [Students]Grade_Level [Reenrollments]Grade_Level | 4 |
41/161 | 12th Grade Concentrators Proficient (3 or 4) in CAASP Eng. Lang Arts Hispanic or Latino | A count of 12th grade Hispanic or Latino concentrators scoring 380 or higher on the CAHSEE Eng. Lang Arts exam. | [Test]Name contains SBAC [TestScore]Name contains ELA-AL [StudentTest]NumScore of 3 or 4 | 4 |
42/162 | 12th Grade Concentrators Proficient in CAASP Math Hispanic or Latino | A count of 12th grade Hispanic or Latino concentrators scoring 380 or higher on the CAHSEE Math exam. | [Test]Name contains SBAC [TestScore]Name contains M-AL [StudentTest]NumScore of 3 or 4 | 4 |
43/163 | 12th Graders receiving a Diploma, GED or equivalent Hispanic or Latino | A count of 12th grade Hispanic or Latino concentrators with one of the following completion codes on an enrollment withing the reporting period:
| [Students]CompletionStatus in ('100','106','108','120','250','320','330') [Reenrollments]CompletionStatus in ('100','106','108','120','250','320','330') | 4 |
44/164 | Total Participants Native Hawaiian or Other Pacific Islander | A count of non-hispanic students marked with race Native Hawaiian or one or more other Pacific Islander enrolled in the course for at least one day in the reporting period. Count includes Concentrators. | [CC]DateEnrolled [CC]DateLeft [StudentRace]Racecd = 301 (Hawaiian) or Racecd = 302 (Guamanian) or Racecd = 303 (Samoan) or Racecd = 304 (Tahitian) or Racecd = 399 (Other Pacific Islander) and [Students]Fedethnicity is not 1 (Hispanic or Latino) and has no other [StudentRace]Racecd records in the same Federal category | 4 |
45/165 | Total Concentrators Native Hawaiian or Other Pacific Islander | A count of Native Hawaiiam or other Pacific Islander students that have a CALPADS CTE concentrator record for a qualifying pathway and enrolled in the course for at least one day in the reporting period. | [S_CA_STU_StudentCTE_C]PathwayCode [S_CA_STU_StudentCTE_C]AcademicYear | 4 |
46/166 | Concentrators in Capstone Courses Native Hawaiian or Other Pacific Islander | A count of Native Hawaiian or other Pacific Islander concentrators in courses or sections that indicated as capstone. | [S_CA_CRS_X]CTECapstone [S_CA_SEC_X]CTECapstone | 4 |
47/167 | Concentrators in Capstone course receiving post-secondary credit at the secondary level Native Hawaiian or Other Pacific Islander | Not collected | N/A | 4 |
48/168 | Concentrators in Capstone course completed state or industry-recognized certification or licensure Native Hawaiian or Other Pacific Islander | Not collected | N/A | 4 |
49/169 | Concentrators in Capstone course receiving a “C” or better Native Hawaiian or Other Pacific Islander | A count of Native Hawaiian or other Pacific Islander concentrators receiving a “C” or better in a stored grade that counts for credit for the course. | [StoredGrades]Course_Number [StoredGrade]Grade starts with A, B, or C [StoredGrades]earnedCrHrs > 0 [StoredGrades]TermID | 4 |
50/170 | Total 12th Grade Concentrators Native Hawaiian or Other Pacific Islander | A count of Native Hawaiian or other Pacific Islander concentrators in the 12th grade at some point during the reporting period. | [Students]Grade_Level [Reenrollments]Grade_Level | 4 |
51/171 | 12th Grade Concentrators Proficient (3 or 4) in CAASP Eng. Lang Arts Native Hawaiian or Other Pacific Islander | A count of 12th grade Native Hawaiian or other Pacific Islander concentrators scoring 380 or higher on the CAHSEE Eng. Lang Arts exam. | [Test]Name contains SBAC [TestScore]Name contains M-AL [StudentTest]NumScore of 3 or 4 | 4 |
52/172 | 12th Grade Concentrators Proficient in CAASP Math Native Hawaiian or Other Pacific Islander | A count of 12th grade Native Hawaiian or other Pacific Islander concentrators scoring 380 or higher on the CAHSEE Math exam. | [Test]Name contains CAHSEE [TestScore]Name contains Math [StudentTest]NumScore > 380 | 4 |
53/173 | 12th Graders receiving a Diploma, GED or equivalent Native Hawaiian or Other Pacific Islander | A count of 12th grade Native Hawaiian or other Pacific Islander concentrators with one of the following completion codes on an enrollment withing the reporting period:
| [Students]CompletionStatus in ('100','106','108','120','250','320','330') [Reenrollments]CompletionStatus in ('100','106','108','120','250','320','330') | 4 |
54/174 | Total Participants White | A count of non-hispanic students marked with race White enrolled in the course for at least one day in the reporting period. Count includes Concentrators. | [CC]DateEnrolled [CC]DateLeft [StudentRace]Racecd = 700 (White) and [Students]Fedethnicity is not 1 (Hispanic or Latino) and has no other [StudentRace]Racecd records in the same Federal category | 4 |
55/175 | Total Concentrators White | A count of White students that have a CALPADS CTE concentrator record for a qualifying pathway and enrolled in the course for at least one day in the reporting period. | [S_CA_STU_StudentCTE_C]PathwayCode [S_CA_STU_StudentCTE_C]AcademicYear | 4 |
56/176 | Concentrators in Capstone Courses White | A count of White concentrators in courses or sections that indicated as capstone. | [S_CA_CRS_X]CTECapstone [S_CA_SEC_X]CTECapstone | 4 |
57/177 | Concentrators in Capstone course receiving post-secondary credit at the secondary level White | Not collected | N/A | 4 |
58/178 | Concentrators in Capstone course completed state or industry-recognized certification or licensure White | Not collected | N/A | 4 |
59/179 | Concentrators in Capstone course receiving a “C” or better White | A count of White concentrators receiving a “C” or better in a stored grade that counts for credit for the course. | [StoredGrades]Course_Number [StoredGrade]Grade starts with A, B, or C [StoredGrades]earnedCrHrs > 0 [StoredGrades]TermID | 4 |
60/180 | Total 12th Grade Concentrators White | A count of White concentrators in the 12th grade at some point during the reporting period. | [Students]Grade_Level [Reenrollments]Grade_Level | 4 |
61/181 | 12th Grade Concentrators Proficient (3 or 4) in CAASP Eng. Lang Arts White | A count of 12th grade White concentrators scoring 380 or higher on the CAHSEE Eng. Lang Arts exam. | [Test]Name contains SBAC [TestScore]Name contains ELA-AL [StudentTest]NumScore of 3 or 4 | 4 |
62/182 | 12th Grade Concentrators Proficient in CAASP Math White | A count of 12th grade Native Hawaiian or other Pacific Islander concentrators scoring 380 or higher on the CAHSEE Math exam. | [Test]Name contains SBAC [TestScore]Name contains M-AL [StudentTest]NumScore of 3 or 4 | 4 |
63/183 | 12th Graders receiving a Diploma, GED or equivalent White | A count of 12th grade White concentrators with one of the following completion codes on an enrollment withing the reporting period:
| [Students]CompletionStatus in ('100','106','108','120','250','320','330') [Reenrollments]CompletionStatus in ('100','106','108','120','250','320','330') | 4 |
64/184 | Total Participants Unknown / Other | A count of non-hispanic students marked with one or more race of difference categories or declining to specifiy enrolled in the course for at least one day in the reporting period. Count includes Concentrators. | [CC]DateEnrolled [CC]DateLeft [Students]Fedethnicity is not 1 (Hispanic or Latino) and two or more races are selected in multiple Federal categories: Two or more [StudentRace]Racecd records in different Federal categories (ie Asian, White) or no races selected | 4 |
65/185 | Total Concentrators Unknown / Other | A count of Unknown/Other students that have a CALPADS CTE concentrator record for a qualifying pathway and enrolled in the course for at least one day in the reporting period. | [S_CA_STU_StudentCTE_C]PathwayCode [S_CA_STU_StudentCTE_C]AcademicYear | 4 |
66/186 | Concentrators in Capstone Courses Unknown / Other | A count of Unknown/Other concentrators in courses or sections that indicated as capstone. | [S_CA_CRS_X]CTECapstone [S_CA_SEC_X]CTECapstone | 4 |
67/187 | Concentrators in Capstone course receiving post-secondary credit at the secondary level Unknown / Other | Not collected | N/A | 4 |
68/188 | Concentrators in Capstone course completed state or industry-recognized certification or licensure Unknown / Other | Not collected | N/A | 4 |
69/189 | Concentrators in Capstone course receiving a “C” or better Unknown / Other | A count of Unknown/Other concentrators receiving a “C” or better in a stored grade that counts for credit for the course. | [StoredGrades]Course_Number [StoredGrade]Grade starts with A, B, or C [StoredGrades]earnedCrHrs > 0 [StoredGrades]TermID | 4 |
70/190 | Total 12th Grade Concentrators Unknown / Other | A count of Unknown/Other concentrators in the 12th grade at some point during the reporting period. | [Students]Grade_Level [Reenrollments]Grade_Level | 4 |
71/191 | 12th Grade Concentrators Proficient (3 or 4) in CAASP Eng. Lang Arts Unknown / Other | A count of 12th grade Unknown/Other concentrators scoring 380 or higher on the CAHSEE Eng. Lang Arts exam. | [Test]Name contains SBAC [TestScore]Name contains ELA-AL [StudentTest]NumScore of 3 or 4 | 4 |
72/192 | 12th Grade Concentrators Proficient in CAASP Math Unknown / Other | A count of 12th grade Native Hawaiian or other Pacific Islander concentrators scoring 380 or higher on the CAHSEE Math exam. | [Test]Name contains SBAC [TestScore]Name contains M-AL [StudentTest]NumScore of 3 or 4 | 4 |
73/193 | 12th Graders receiving a Diploma, GED or equivalent Unknown / Other | A count of 12th grade Unknown/Other concentrators with one of the following completion codes on an enrollment withing the reporting period:
| [Students]CompletionStatus in ('100','106','108','120','250','320','330') [Reenrollments]CompletionStatus in ('100','106','108','120','250','320','330') | 4 |
74/194 | Total Participants Economic Disadvantaged | A count of Economic Disadvantaged students enrolled in the course for at least one day in the reporting period. Count includes Concentrators. Students are counted as economically disadvantaged if they have a free or reduced CALPADS lunch record (181 or 182) at any point in the reporting period or if their school of enrollment is marked to count all students as Economically Disadvanated for Perkins. | [S_CA_SCH_X]PerkinsEconDisadvantagedFlag = Y [S_CA_STU_CALPADSPrograms_C]StartDate [S_CA_STU_CALPADSPrograms_C]EndDate [S_CA_STU_CALPADSPrograms_C] ProgramMembershipCode= 181 or 182 | 4 |
75/195 | Total Concentrators Economic Disadvantaged | A count of Economic Disadvantaged students that have a CALPADS CTE concentrator record for a qualifying pathway and enrolled in the course for at least one day in the reporting period. | [S_CA_STU_StudentCTE_C]PathwayCode [S_CA_STU_StudentCTE_C]AcademicYear | 4 |
76/196 | Concentrators in Capstone Courses Economic Disadvantaged | A count of Economically Disadvantaged concentrators in courses or sections that indicated as capstone. | [S_CA_CRS_X]CTECapstone [S_CA_SEC_X]CTECapstone | 4 |
77/197 | Concentrators in Capstone course receiving post-secondary credit at the secondary level Economic Disadvantaged | Not collected | N/A | 4 |
78/198 | Concentrators in Capstone course completed state or industry-recognized certification or licensure Economic Disadvantaged | Not collected | N/A | 4 |
79/199 | Concentrators in Capstone course receiving a “C” or better Economic Disadvantaged | A count of Economic Disadvantaged concentrators receiving a “C” or better in a stored grade that counts for credit for the course. | [StoredGrades]Course_Number [StoredGrade]Grade starts with A, B, or C [StoredGrades]earnedCrHrs > 0 [StoredGrades]TermID | 4 |
80/200 | Total 12th Grade Concentrators Economic Disadvantaged | A count of Economic Disadvantaged concentrators in the 12th grade at some point during the reporting period. | [Students]Grade_Level [Reenrollments]Grade_Level | 4 |
81/201 | 12th Grade Concentrators Proficient (3 or 4) in CAASP Eng. Lang Arts Economic Disadvantaged | A count of 12th grade Economic Disadvantaged concentrators scoring 380 or higher on the CAHSEE Eng. Lang Arts exam. | [Test]Name contains SBAC [TestScore]Name contains ELA-AL [StudentTest]NumScore of 3 or 4 | 4 |
82/202 | 12th Grade Concentrators Proficient in CAASP Math Economic Disadvantaged | A count of 12th grade Economic Disadvantaged concentrators scoring 380 or higher on the CAHSEE Math exam. | [Test]Name contains SBAC [TestScore]Name contains M-AL [StudentTest]NumScore of 3 or 4 | 4 |
83/203 | 12th Graders receiving a Diploma, GED or equivalent Economic Disadvantaged | A count of 12th grade Economic Disadvantaged concentrators with one of the following completion codes on an enrollment withing the reporting period:
| [Students]CompletionStatus in ('100','106','108','120','250','320','330') [Reenrollments]CompletionStatus in ('100','106','108','120','250','320','330') | 4 |
84/204 | Total Participants Individuals w/ Disabilities | A count of Individuals with Disabilities enrolled in the course for at least one day in the reporting period. Count includes Concentrators. Students are counted as individuals with disabilities if they have a CALPADS Special Education program record (144) at any point in the reporting period. | [S_CA_STU_CALPADSPrograms_C]StartDate [S_CA_STU_CALPADSPrograms_C]EndDate [S_CA_STU_CALPADSPrograms_C] ProgramMembershipCode= 144 | 4 |
85/205 | Total Concentrators Individuals w/ Disabilities | A count of Individuals with Disabilities that have a CALPADS CTE concentrator record for a qualifying pathway and enrolled in the course for at least one day in the reporting period. | [S_CA_STU_StudentCTE_C]PathwayCode [S_CA_STU_StudentCTE_C]AcademicYear | 4 |
86/206 | Concentrators in Capstone Courses Individuals w/ Disabilities | A count of Individuals with Disabilities concentrators in courses or sections that indicated as capstone. | [S_CA_CRS_X]CTECapstone [S_CA_SEC_X]CTECapstone | 4 |
87/207 | Concentrators in Capstone course receiving post-secondary credit at the secondary level Individuals w/ Disabilities | Not collected | N/A | 4 |
88/208 | Concentrators in Capstone course completed state or industry-recognized certification or licensure Individuals w/ Disabilities | Not collected | N/A | 4 |
89/209 | Concentrators in Capstone course receiving a “C” or better Individuals w/ Disabilities | A count of Individuals with Disabilities concentrators receiving a “C” or better in a stored grade that counts for credit for the course. | [StoredGrades]Course_Number [StoredGrade]Grade starts with A, B, or C [StoredGrades]earnedCrHrs > 0 [StoredGrades]TermID | 4 |
90/210 | Total 12th Grade Concentrators Individuals w/ Disabilities | A count of Individuals with Disabilities concentrators in the 12th grade at some point during the reporting period. | [Students]Grade_Level [Reenrollments]Grade_Level | 4 |
91/211 | 12th Grade Concentrators Proficient (3 or 4) in CAASP Eng. Lang Arts Individuals w/ Disabilities | A count of 12th grade Individuals with Disabilities concentrators scoring 380 or higher on the CAHSEE Eng. Lang Arts exam. | [Test]Name contains SBAC [TestScore]Name contains ELA-AL [StudentTest]NumScore of 3 or 4 | 4 |
92/212 | 12th Grade Concentrators Proficient in CAASP Math Individuals w/ Disabilities | A count of 12th grade Individuals with Disabilities concentrators scoring 380 or higher on the CAHSEE Math exam. | [Test]Name contains SBAC [TestScore]Name contains M-AL [StudentTest]NumScore of 3 or 4 | 4 |
93/213 | 12th Graders receiving a Diploma, GED or equivalent Individuals w/ Disabilities | A count of 12th grade Individuals with Disabilities concentrators with one of the following completion codes on an enrollment withing the reporting period:
| [Students]CompletionStatus in ('100','106','108','120','250','320','330') [Reenrollments]CompletionStatus in ('100','106','108','120','250','320','330') | 4 |
94/214 | Total Participants Single Parent | A count of Single Parent students enrolled in the course for at least one day in the reporting period. Count includes Concentrators. Students are counted as single parents if they have a CALPADS Pregnant or Parenting program record (162) at any point in the reporting period. | [S_CA_STU_CALPADSPrograms_C]StartDate [S_CA_STU_CALPADSPrograms_C]EndDate [S_CA_STU_CALPADSPrograms_C] ProgramMembershipCode = 162 | 4 |
95/215 | Total Concentrators Single Parent | A count of Single Parent students that have a CALPADS CTE concentrator record for a qualifying pathway and enrolled in the course for at least one day in the reporting period. | [S_CA_STU_StudentCTE_C]PathwayCode [S_CA_STU_StudentCTE_C]AcademicYear | 4 |
96/216 | Concentrators in Capstone Courses Single Parent | A count of Single Parent concentrators in courses or sections that indicated as capstone. | [S_CA_CRS_X]CTECapstone [S_CA_SEC_X]CTECapstone | 4 |
97/217 | Concentrators in Capstone course receiving post-secondary credit at the secondary level Single Parent | Not collected | N/A | 4 |
98/218 | Concentrators in Capstone course completed state or industry-recognized certification or licensure Single Parent | Not collected | N/A | 4 |
99/219 | Concentrators in Capstone course receiving a “C” or better Single Parent | A count of Single Parent concentrators receiving a “C” or better in a stored grade that counts for credit for the course. | [StoredGrades]Course_Number [StoredGrade]Grade starts with A, B, or C [StoredGrades]earnedCrHrs > 0 [StoredGrades]TermID | 4 |
100/220 | Total 12th Grade Concentrators Single Parent | A count of Single parent concentrators in the 12th grade at some point during the reporting period. | [Students]Grade_Level [Reenrollments]Grade_Level | 4 |
101/221 | 12th Grade Concentrators Proficient (3 or 4) in CAASP Eng. Lang Arts Single Parent | A count of 12th grade Single Parent concentrators scoring 380 or higher on the CAHSEE Eng. Lang Arts exam. | [Test]Name contains SBAC [TestScore]Name contains ELA-AL [StudentTest]NumScore of 3 or 4 | 4 |
102/222 | 12th Grade Concentrators Proficient in CAASP Math Single Parent | A count of 12th grade Single Parent concentrators scoring 380 or higher on the CAHSEE Math exam. | [Test]Name contains SBAC [TestScore]Name contains M-AL [StudentTest]NumScore of 3 or 4 | 4 |
103/223 | 12th Graders receiving a Diploma, GED or equivalent Single Parent | A count of 12th grade Single Parent concentrators with one of the following completion codes on an enrollment withing the reporting period:
| [Students]CompletionStatus in ('100','106','108','120','250','320','330') [Reenrollments]CompletionStatus in ('100','106','108','120','250','320','330') | 4 |
104/224 | Total Participants Limited English Proficient | A count of students that have an ELA Status of ‘EL’ and an ELA Status Start Date on or before June 30 of the reporting year or students that have an ELA Status of ‘RFEP’ and an ELA Status Start Date after the last day of the reporting period that are enrolled in the course for at least one day in the reporting period. Count includes Concentrators. | If ([S_CA_STU_ELA_C]ELAStatus = "EL" with [S_CA_STU_ELA_C]ELAStatusStartDate <= June 30 Then Yes Elseif [S_CA_STU_ELA_C]ELAStatus = "RFEP" with [S_CA_STU_ELA_C]ELAStatusStartDate > July 1 Then Yes Else No | 4 |
105/225 | Total Concentrators Limited English Proficient | A count of Limited English Proficient students that have a CALPADS CTE concentrator record for a qualifying pathway and enrolled in the course for at least one day in the reporting period. | [S_CA_STU_StudentCTE_C]PathwayCode [S_CA_STU_StudentCTE_C]AcademicYear | 4 |
106/226 | Concentrators in Capstone Courses Limited English Proficient | A count of Limited English Proficient concentrators in courses or sections that indicated as capstone. | [S_CA_CRS_X]CTECapstone [S_CA_SEC_X]CTECapstone | 4 |
107/227 | Concentrators in Capstone course receiving post-secondary credit at the secondary level Limited English Proficient | Not collected | N/A | 4 |
108/228 | Concentrators in Capstone course completed state or industry-recognized certification or licensure Limited English Proficient | Not collected | N/A | 4 |
109/229 | Concentrators in Capstone course receiving a “C” or better Limited English Proficient | A count of Limited English Proficient concentrators receiving a “C” or better in a stored grade that counts for credit for the course. | [StoredGrades]Course_Number [StoredGrade]Grade starts with A, B, or C [StoredGrades]earnedCrHrs > 0 [StoredGrades]TermID | 4 |
110/230 | Total 12th Grade Concentrators Limited English Proficient | A count of Limited English Proficient concentrators in the 12th grade at some point during the reporting period. | [Students]Grade_Level [Reenrollments]Grade_Level | 4 |
111/231 | 12th Grade Concentrators Proficient (3 or 4) in CAASP Eng. Lang Arts Limited English Proficient | A count of 12th grade Limited English Proficient concentrators scoring 380 or higher on the CAHSEE Eng. Lang Arts exam. | [Test]Name contains SBAC [TestScore]Name contains ELA-AL [StudentTest]NumScore of 3 or 4 | 4 |
112/232 | 12th Grade Concentrators Proficient in CAASP Math Limited English Proficient | A count of 12th grade Limited English Proficient concentrators scoring 380 or higher on the CAHSEE Math exam. | [Test]Name contains SBAC [TestScore]Name contains M-AL [StudentTest]NumScore of 3 or 4 | 4 |
113/233 | 12th Graders receiving a Diploma, GED or equivalent Limited English Proficient | A count of 12th grade Limited English Proficient concentrators with one of the following completion codes on an enrollment withing the reporting period:
| [Students]CompletionStatus in ('100','106','108','120','250','320','330') [Reenrollments]CompletionStatus in ('100','106','108','120','250','320','330') | 4 |
114/234 | Total Participants Migrant | A count of Migrant students enrolled in the course for at least one day in the reporting period. Count includes Concentrators. Students are counted as migrant if they have a CALPADS Migrant program record (135) at any point in the reporting period. | [StudentProgram]CA_prog_mem_Start_Date [StudentProgram]CA_prog_mem_End_Date [StudentProgram]CA_prog_mem_Code = 135 | 4 |
115/235 | Total Concentrators Migrant | A count of Migrant students that have a CALPADS CTE concentrator record for a qualifying pathway and enrolled in the course for at least one day in the reporting period. | [S_CA_STU_StudentCTE_C]PathwayCode [S_CA_STU_StudentCTE_C]AcademicYear | 4 |
116/236 | Concentrators in Capstone Courses Migrant | A count of Migrant concentrators in courses or sections that indicated as capstone. | [S_CA_CRS_X]CTECapstone [S_CA_SEC_X]CTECapstone | 4 |
117/237 | Concentrators in Capstone course receiving post-secondary credit at the secondary level Migrant | Not collected | N/A | 4 |
118/238 | Concentrators in Capstone course completed state or industry-recognized certification or licensure Migrant | Not collected | N/A | 4 |
119/239 | Concentrators in Capstone course receiving a “C” or better Migrant | A count of Migrant concentrators receiving a “C” or better in a stored grade that counts for credit for the course. | [StoredGrades]Course_Number [StoredGrade]Grade starts with A, B, or C [StoredGrades]earnedCrHrs > 0 [StoredGrades]TermID | 4 |
120/240 | Total 12th Grade Concentrators Migrant | A count of Migrant concentrators in the 12th grade at some point during the reporting period. | [Students]Grade_Level [Reenrollments]Grade_Level | 4 |
121/241 | 12th Grade Concentrators Proficient (3 or 4) in CAASP Eng. Lang Arts Migrant | A count of 12th grade Migrant concentrators scoring 380 or higher on the CAHSEE Eng. Lang Arts exam. | [Test]Name contains SBAC [TestScore]Name contains ELA-AL [StudentTest]NumScore of 3 or 4 | 4 |
122/242 | 12th Grade Concentrators Proficient in CAASP Math Migrant | A count of 12th grade Migrant concentrators scoring 380 or higher on the CAHSEE Math exam. | [Test]Name contains SBAC [TestScore]Name contains M-AL [StudentTest]NumScore of 3 or 4 | 4 |
123/243 | 12th Graders receiving a Diploma, GED or equivalent Migrant | A count of 12th grade Migrant concentrators with one of the following completion codes on an enrollment withing the reporting period:
| [Students]CompletionStatus in ('100','106','108','120','250','320','330') [Reenrollments]CompletionStatus in ('100','106','108','120','250','320','330') | 4 |