CHART OF LCAP INDICATORS
Dashboard Name
Condition
Additional Information
504 Students
A record in the FOF (504 Plans) table with (Start Date <= current date and (End Date = NULL or End Date >= current date)). After FOF is analyzed the system will check for a PGM.CD = 101, with (Eligibility Start Date <= current date and (Eligibility End Date = Null or Eligibility End Date >= current date)) or (Program Start Date <= current date  and (Program End Date = NULL  or Program End Date >= current date). If all dates are NULL the record is not counted.
Either a FOF record or a PGM Program Code = 101. The current date needs to fall within the start and end date of the record. The FOF records will be analyzed first.
A/G Readiness 12th Graders
STU.GR = 12 and
(STU.CUC = Y or STU.CCS = Y or STU.CCO = Y )
Only includes 12th grade students where UC Course Complete = Y or CSU Course Complete = Y or Course Complete Override  Y
ACT Composite
The Composite score of the most recent ACT test (CTS.SC5)  is evaluated.

CTS.NM = ACT
The level and score ranges are:
Level 1: 1 - 21
Level 2: 22 - 24
Level 3: 25 - 28
Level 4: 29 - 32
Level 5: 33 - 26
The Composite score of the most recent ACT test is evaluated.
Advanced Placement Result
The score of the most recent AP test (CTS.SC1) is evaluated.
STU.GR = 9, 10, 11, or 12
CTS.NM = AP
NR: 1 - 1  (CTS.SC1 = 1) No Recommendation
PQ: 2 - 2  (CTS.SC1 = 2) Possibly Qualified
Q: 3 - 3  (CTS.SC1 = 3) Qualified
WQ: 4 - 4  (CTS.SC1 = 4) Well Qualified
EWQ: 5 - 5  (CTS.SC1 = 5) Extremely Well
                                        Qualified
The score of the most recent AP test is evaluated for students in grades 9 – 12.
All Day Unexcused Absence Count >= 3
Absent Code that are ABS.TY = 3 (unexcused absences) and ABS.SU = 0  (not a suspension) will be used to count the number of unexcused absences the student has in the ATT.AL (All Day) field. Students with 3 or more Unexcused All Day absences are counted
Student counted if they have 3 or more All Day Unexcused absences from the beginning of the year to the current date. The unexcused absences are determined by the Absent Code Table.
AP/IB Participation Rate
The student is counted if he has at least one AP or IB test result.
STU.GR = 9, 10, 11 or 12
One or more AP or IB tests for students in grades 9 – 12.
Attendance % (Chronic (>10%) vs Non Chronic)
If the Calculate Attendance History Through Current Day option is ON in the Attendance History Configuration, then AHS is used:
( Days Enrolled (AHS.EN) - Days Absent (AHS.AB) ) / Days Enrolled (AHS.EN)


If the Calculate Attendance History Through Current Day option is OFF in the Attendance History Configuration, then ATT is used:
(Days Present - 1 ) / Days Enrolled
The number of days enrolled not including today - the number of days absent / the number of days enrolled counting today. Only students enrolled 10 or more days are processed.
CELDT Overall
TST.ID = CELDT
TST.PT = 0

Level 1: 1 - 1  (TST.OT = 1)
Level 2: 2 - 2  (TST.OT = 2)
Level 3: 3 - 3  (TST.OT = 3)
Level 4: 4 - 4  (TST.OT = 4)
Level 5: 5 - 5  (TST.OT = 5)
Count the most recent Performance Level for CELDT Overall Score. The CELDT test needs to be within the current school year. The performance level is stored in the TST.OT field for the CELDT test.
CST (Science)
TST.ID = CST
TST.PT = 3,41,42,43,44,45,46,47,48,49,50,51,52,53,54 or 55
TST.TD from most recent test

Level 1: 1 - 1  (TST.PL = 1)
Level 2: 2 - 2  (TST.PL = 2)
Level 3: 3 - 3  (TST.PL = 3)
Level 4: 4 - 4  (TST.PL = 4)
Level 5: 5 - 5  (TST.PL = 5)
Count the most recent Performance Level for CST Science tests taken
Early Assessment Program
STU.GR = 12
TST.ID = SBAC
TST.PT = 1  for ELA
TST.PT = 2 for Math
TST.GR = 110  (only the 11th grade SBAC results are evaluated)

NRd: 1 - 1  (TST.PL = 1) Not Ready
NYR: 2 - 2  (TST.PL = 2) Not Yet Ready
CRd: 3 - 3  (TST.PL = 3) Conditionally Ready
Rdy: 4 - 4  (TST.PL = 4) Ready
For the 12th grade students, the EAP Readiness status is determined by analyzing their 11th grade SBAC performance levels in ELA and Math.
ELPAC OverallTST.ID = ELPAC
TST.PT = 0

Level 1: 1 - 1  (TST.PL = 1)
Level 2: 2 - 2  (TST.PL = 2)
Level 3: 3 - 3  (TST.PL = 3)
Level 4: 4 - 4  (TST.PL = 4)

Count the most recent Performance Level for ELPAC Overall Score. The ELPAC test needs to be within the current school year. The performance level is stored in the TST.PL field for the ELPAC test.
Foster Students
PGM.CD = 190, with (Eligibility Start Date <= current date and (Eligibility End Date = Null or Eligibility End Date >= current date)) or (Program Start Date <= current date  and (Program End Date = NULL  or Program End Date >= current date)). If all dates are NULL the record is not counted.
Program Code = 190 and the current date needs to fall within the start and end date of the record
Gender
STU.SX = M or B for Male count or STU.SX = F or G for Female count

Grades (HIS)
Departments are determined by COD table. COD.TC = CRS and COD.FC = DC. The highest transcript grade achieved for courses in each department is counted.
Highest Grade for courses in each Department is counted.
Homeless Students
PGM.CD = 191, with (Eligibility Start Date <= current date and (Eligibility End Date = Null or Eligibility End Date >= current date)) or (Program Start Date <= current date  and (Program End Date = NULL  or Program End Date >= current date). If all dates are NULL the record is not counted.
Program Code = 191 and the current date needs to fall within the start and end date of the record
Language Fluency
Uses the CALPADS translations (XRF) to determine the codes being used for EO, EL, IFEP, RFEP

Long Term English Learner (LTEL)
LAC Years in Program (LAC.YP) >=6 and STU.LF is "EL" as determined by CALPADS translations (XRF)
The LAC.YP is recalculated by the system every time Aeries Analytics processes. EL students that have been in the program 6 or more years will be counted as LTELS.
PSAT Participation Rate
The student is counted if he has at least one PSAT test.
One or more
PSAT Performance
The most recent PSAT scores are evaluated
CTS.NM = PSAT
CTS.DT on or after October 2015
English uses CTS.SC5
Math uses CTS.SC6
Total uses CTS.TTL

Level 1: 160 – 379            320 –  759 for Total
Level 2: 380 – 474            760 –  949 for Total
Level 3: 475 – 569            950 – 1139 for Total
Level 4: 570 – 664          1140 – 1329 for Total
Level 5: 665 – 760          1330 – 1520 for Total
Most Recent PSAT scores dated on or after October 2015 are evaluated.
PSAT Performance (Pre-2015)
The most recent PSAT scores are evaluated
CTS.NM = PSAT
CTS.DT before October 2015
Math uses CTS.SC2
Writing uses CTS.SC3
Reading uses CTS.SC4
Total uses CTS.TTL

Level 1: 20 – 39            60 – 199 for Total
Level 2: 40 – 49          120 – 149 for Total
Level 3: 50 – 59          150 – 179 for Total
Level 4: 60 – 69          180 – 209 for Total
Level 5: 70 – 80          210 – 240 for Total
Most Recent PSAT scores dated before October 2015 are evaluated.
Race Ethnicity
HIS: Hispanic - STU.ETH = Y

AMI: American Indian (not Hispanic) - STU.ETH = N, STU.RC1 = 100, STU.RC2 = ""

ASN: Asian (not Hispanic) - STU.ETH = N, STU.RC1 between 200 and 299, STU.RC2 = ""

PAC: Pacific Islander (not Hispanic) - STU.ETH = N, STU.RC1 between 300 and 399, STU.RC2 = ""

FIL: Filipino (not Hispanic) - STU.ETH = N, STU.RC1 = 400, STU.RC2 = ""

BLK: Black (not Hispanic) - STU.ETH = N, STU.RC1 = 600, STU.RC2 = ""

WHT: White (not Hispanic) - STU.ETH = N, STU.RC1 = 700, STU.RC2 = ""

UNK: Unknown (not Hisplanic) – STU.ETH = N, STU.RC1 = 999, STU.RC2 = ""
MLT: Multi-race (not Hispanic) - STU.ETH = N, STU.RC1 <> "", STU.RC2 <> ""
UNK: Unknown – none of the above conditions are met

RFEP
The percentage of RFEP students out of the EL population. The calculation is the # of RFEP students /   ( # of RFEP students + # of EL students ).
Uses the CALPADS translations (XRF) to determine if the STU.LF code is RFEP or EL.
Level 1: RFEP students
Level 3: EL students
Percentage of RFEP students.
SAT I
The most recent SAT I scores are evaluated.  CTS.NM = SAT I
CTS.DT on or after March 2016
English uses CTS.SC5
Math uses CTS.SC6
Total uses CTS.TTL

Level 1: 200 - 479            400 –  959 for Total
Level 2: 480 - 559            960 – 1119 for Total
Level 3: 560 - 639          1120 – 1279 for Total
Level 4: 640 - 719          1280 – 1439 for Total
Level 5: 720 - 800          1440 – 1600 for Total
Most Recent SAT I scores dated on or after March 2016 are evaluated.
SAT I (Pre-Mar-2016)
The most recent SAT I scores are evaluated.  CTS.NM = SAT I
CTS.DT is before March 2016
Verbal uses CTS.SC1
Math uses CTS.SC2
Writing uses CTS.SC3
Reading uses CTS.SC4
Total uses CTS.TTL

Level 1: 200 - 479            600 – 1439 for Total
Level 2: 480 - 559          1140 – 1679 for Total
Level 3: 560 - 639          1680 – 1919 for Total
Level 4: 640 - 719          1920 – 2159 for Total
Level 5: 720 - 800          2160 – 2400 for Total
Most Recent SAT I scores dated before March 2016 are evaluated.
SBAC
TST.ID = SBAC
TST.PT = 1 for ELA
TST.PT = 2 for Math
TST.TD from most recent test

Not Met:    1 - 1  (TST.PL = 1) Standard Not Met
Nearly Met: 2 - 2  (TST.PL = 2) Standard Nearly
                                              Met
Met:           3 - 3  (TST.PL = 3) Standard Met
Exceeded:   4 - 4  (TST.PL = 4) Standard
                                              Exceeded


Most recent Performance Level for SBAC ELA and Math test results
Socio-Economically Disadvantaged Students
STU.PED = Not High School Graduate or
FRE.CD = F or R with (Eligibility Start Date <= current date and (Eligibility End Date = Null or Eligibility End Date >= current date)) or (Program Start Date <= current date  and (Program End Date = NULL  or Program End Date >= current date). If all dates are NULL the record is also counted.
FRE.CD and STU.PED are determined by CALPADS translations (XRF)
Student is counted if he has a NSLP record for the current school year or Parent Ed Level is "Not a High School Graduate"
Special Ed Students
CSE.DI <>  " ", with (Enter Date <= current date and  (Exit Date = Null or Exit Date >= current date)). If the Enter Date is NULL then the record is not counted.
Disability code is not blank and student needs to be a current special ed student.