This chart lists the Item Definitions and associated fields provided with Aeries Analytics.  Districts can use this chart as a guide to customize the Item Definitions to align with established configurations.



Item DefinitionSchool TypeAssociated Fields
Attendance
All Day Truancy

All Schools

  • Type = ATT Threshold
  • Absence Codes to Include = Unexcused Absence Codes
Attendance 
Attendance Notifications

All Schools

  • Type = Field Value
  • Table = STU - Student Data
  • Field = LT - Abs Ltr
Attendance
Attendance Percentage

All Schools

  • Type = Attendance Percentage

Thresholds established to determine Chronic Absenteeism

Attendance
Total Absences

All Schools

  • Type = ATT Threshold
  • Absence Codes to Include = Excused Absence Codes
College and Career Indicator 
Measure A - CTE		High Schools Only

Delete for 
Elementary Districts 
  • Type = CCI
  • Measure = A
College and Career Indicator Measure B - SBACHigh Schools Only

Delete for 
Elementary Districts
  • Type = CCI
  • Measure = B
College and Career Indicator
Measure C - Dual Enrollment		High Schools Only

Delete for 
Elementary Districts
  • Type = CCI
  • Measure = C
College and Career Indicator Measure D - AP/IBHigh Schools Only

Delete for 
Elementary Districts
  • Type = CCI
  • Measure = D
College and Career Indicator
Measure E - A to G		High Schools Only

Delete for 
Elementary Districts
  • Type = CCI
  • Measure = E
College and Career Indicator
Overall		High Schools Only

Delete for 
Elementary Districts
  • Type = CCI
  • Measure = Overall
Discipline
Days of Suspension		All Schools
  • Type = Disposition Days
  • Date Options = Any Time This Year
  • Disposition Codes to Include = All Suspension Disposition Codes
Discipline 
Total Violations		All Schools
  • Type = ADS Violation Count
  • Date Options = Any Time This Year
  • Assertive Discipline Codes to Include = All Suspension Codes
EL 
English Language Status		All Schools
  • Type = Field Value
  • Table = STU - Student Data
  • Field = LF - Language Fluency
EL
Long Term English Learners
All Schools
  • Type = Field Value Ranges
  • Table = LAC - Language Assessment
  • Field = YP - YrsInPgm

Thresholds established to determine Long Term English Learners

GPA 
Current Report Card		High Schools and Middle Schools/
Junior High Schools

N/A for Elementary using Standards Based Report Cards
  • Type = Field Value Ranges
  • Table = STU - Student Data
  • Field = GT - GTGPA

Thresholds established to determine GPAs

Gradebook 
Electives		High Schools and Middle Schools/
Junior High Schools

N/A for Elementary Schools using Standards Based Report Cards

High Schools:

  • Type = Grade
  • Limit By = Subject Area
  • Subject Area = Defined Electives Code 
  • Which Mark in GRD = Most Recent Gradebook

Middle Schools/Junior High Schools:

  • Type = Grade
  • Limit By = Department Code
  • Department Code = Defined Electives Code
  • Which Mark in GRD = Most Recent Gradebooks
Gradebook 
English		High Schools and Middle Schools/
Junior High Schools

N/A for Elementary Schools using Standards Based Report Cards

High Schools:

  • Type = Grade
  • Limit By = Subject Area
  • Subject Area = Defined English Code
  • Which Mark in GRD = Most Recent Gradebook

Middle Schools/Junior High Schools:

  • Type = Grade
  • Limit By = Department Code
  • Department Code = Defined English Code
  • Which Mark in GRD = Most Recent Gradebook
Gradebook
Foreign Language
High Schools and Middle Schools/
Junior High Schools

N/A for Elementary Schools using Standards Based Report Cards

High Schools:

  • Type = Grade
  • Limit By = Subject Area
  • Subject Area =  Defined World Languages Code
  • Which Mark in GRD = Most Recent Gradebook

Middle Schools/Junior High Schools:

  • Type = Grade
  • Limit By = Department Code
  • Department Code = Foreign Language Code
  • Which Mark in GRD = Most Recent Gradebook
Gradebook 
History/Social Science
High Schools and Middle Schools/
Junior High Schools

N/A for Elementary Schools using Standards Based Report Cards

High Schools:

  • Type = Grade
  • Limit By = Subject Area
  • Subject Area = Defined History/Social Science Code
  • Which Mark in GRD = Most Recent Gradebook

Middle Schools/Junior High Schools:

  • Type = Grade
  • Limit By = Department Code
  • Department Code = Defined History/Social Science Code
  • Which Mark in GRD = Most Recent Gradebook
Gradebook 
Math
High Schools and Middle Schools/
Junior High Schools

N/A for Elementary Schools using Standards Based Report Cards

High Schools:

  • Type = Grade
  • Limit By = Subject Area
  • Subject Area = Defined Mathematics Code
  • Which Mark in GRD = Most Recent Gradebook

Middle Schools/Junior High Schools:

  • Type = Grade
  • Limit By = Department Code
  • Department Code = Defined Mathematics Code
  • Which Mark in GRD = Most Recent Gradebook
Gradebook 
Science: Life
High Schools and Middle Schools/
Junior High Schools

N/A for Elementary Schools using Standards Based Report Cards

High Schools:

  • Type = Grade
  • Limit By = Subject Area
  • Subject Area = Defined Science:  Life Code
  • Which Mark in GRD = Most Recent Gradebook

Middle Schools/Junior High Schools:

  • Type = Grade
  • Limit By = Department Code
  • Department Code = Defined Science:  Life Code
  • Which Mark in GRD = Most Recent Gradebook
Gradebook 
Visual and Performing Arts
High Schools and Middle Schools/
Junior High Schools

N/A for Elementary Schools using Standards Based Report Cards

High Schools:

  • Type = Grade
  • Limit By = Subject Area
  • Subject Area = Defined Visual/Performing Arts Code
  • Which Mark in GRD = Most Recent Gradebook

Middle Schools/Junior High Schools:

  • Type = Grade
  • Limit By = Department Code
  • Department Code = Defined Visual/Performing Arts Code
  • Which Mark in GRD = Most Recent Gradebook
Graduation Requirements
Credits in English
High Schools Only

Delete for 
Elementary Districts
  • Type = Graduation Requirements
  • Subject Area = Defined English Code

Graduation Requirements 
Credits in Electives
High Schools Only

Delete for 
Elementary Districts
  • Type = Graduation Requirements
  • Subject Area = Defined Electives Code

Graduation Requirements
Credits in Foreign Language
High Schools Only

Delete for 
Elementary Districts
  • Type = Graduation Requirements
  • Subject Area = Defined World Language Code

Graduation Requirements 
Credits in Life Science
High Schools Only

Delete for 
Elementary Districts
  • Type = Graduation Requirements
  • Subject Area = Defined Science: Life Code

Graduation Requirements
Credits in Mathematics
High Schools Only

Delete for 
Elementary Districts
  • Type = Graduation Requirements
  • Subject Area = Defined Mathematics Code

Graduation Requirements 
Credits in Physical Science
High Schools Only

Delete for 
Elementary Districts
  • Type = Graduation Requirements
  • Subject Area = Defined Science: Physical Code

Graduation Requirements
Credits in Social Science
High Schools Only

Delete for 
Elementary Districts
  • Type = Graduation Requirements
  • Subject Area = Defined History/Social Science Code

Graduation Requirements
Credits in Visual and Performing Arts
High Schools Only

Delete for 
Elementary Districts
  • Type = Graduation Requirements
  • Subject Area = Defined Visual/Performing Arts Code

Graduation Requirements
English
High Schools Only

Delete for 
Elementary Districts
  • Type = Graduation Requirements
  • Subject Area = Defined English Code

Graduation Requirements 
Math
High Schools Only

Delete for 
Elementary Districts
  • Type = Graduation Requirements
  • Subject Area = Defined Mathematics Code

Program 
504
All Schools
  • Type = Program
  • Date Options = Current
  • Program = 101 PGM Code - 504 Accommodation Plan
Program 
AVID
All Schools
  • Type = Program
  • Date Options = Current
  • Program = 160 PGM Code - Educational Options:  Advancement Via Individual Determination (AVID)
Program
Foster Youth
All Schools
  • Type = Program
  • Date Options = Current
  • Program = 190 PGM Code - Foster Program
Program
GATE
All Schools
  • Type = Program
  • Date Options = Current
  • Program = GATE
Program 
Homeless
All Schools
  • Type = Program
  • Date Options = Current
  • Program = 191 PGM Code - Homeless Program
Program 
Socio-Economically Disadvantaged
All Schools
  • Type = Program
  • Date Options = Current
  • Program = Socio-Economically Disadvantaged
Program 
Special Ed
All Schools
  • Type = Program
  • Date Options = Current
  • Program = Special Ed
Report Card 
English
High Schools and Middle Schools/
Junior High Schools

N/A for Elementary Schools using Standards Based Report Cards
High Schools:
  • Type = Grade
  • Limit By = Subject Area
  • Subject Area = Defined English Code
  • Which Mark in GRD = Most Recent GRD Mark

Middle Schools/Junior High Schools:

  • Type = Grade
  • Limit By = Department Code
  • Department Code = Defined English Code
  • Which Mark in GRD = Most Recent GRD Mark
Report Card 
Math
High Schools and Middle Schools/
Junior High Schools

N/A for Elementary Schools using Standards Based Report Cards
High Schools:
  • Type = Grade
  • Limit By = Subject Area
  • Subject Area = Defined Mathematics Code
  • Which Mark in GRD = Most Recent GRD Mark

Middle Schools/Junior High Schools:

  • Type = Grade
  • Limit By = Department Code
  • Department Code = Defined Mathematics Code
  • Which Mark in GRD = Most Recent GRD Mark
SBAC 
ELA
All Schools
  • Type = TST
  • Test ID = SBAC - Smarter Balanced
  • Test Part = 1 - English Lang Arts/Liter
  • Date Options = Most Recent
  • Score Field = PL - Performance Level
SBAC 
Math
All Schools
  • Type = TST
  • Test ID = SBAC - Smarter Balanced
  • Test Part = 2 - Mathematics
  • Date Options = Most Recent
  • Score Field = PL - Performance Level
SBAC 
Communicate Reasoning
All Schools
  • Type = CST
  • Test ID = SBACMATH/MATHEMATICS
  • Test Part = 3 - Communicating Reasoning
  • Date Options = Most Recent
SBAC 
Concepts Claim
All Schools
  • Type = CST
  • Test ID = SBACMATH/MATHEMATICS
  • Test Part = 1 - Concepts and Procedures
  • Date Options = Most Recent
SBAC 
Listening Claim
All Schools
  • Type = CST
  • Test ID = SBACELA/ENGLISH LANGUAGE ARTS/LITERACY
  • Test Part = 3 - Listening
  • Date Options = Most Recent
SBAC 
Problem Solving
All Schools
  • Type = CST
  • Test ID = SBACMATH/MATHEMATICS
  • Test Part = 2 - Problem Solving and Modeling/Data
  • Date Options = Most Recent
SBAC 
Reading Claim
All Schools
  • Type = CST
  • Test ID = SBACELA/ENGLISH LANGUAGE ARTS/LITERACY
  • Test Part = 1 - Reading
  • Date Options = Most Recent
SBAC 
Research Claim
All Schools
  • Type = CST
  • Test ID = SBACELA/ENGLISH LANGUAGE ARTS/LITERACY
  • Test Part = 4 - Research/Inquiry
  • Date Options = Most Recent
SBAC 
Writing Claim
All Schools
  • Type = CST
  • Test ID = SBACELA/ENGLISH LANGUAGE ARTS/LITERACY
  • Test Part = 2 - Writing
  • Date Options = Most Recent
Transcript 
Electives
High Schools and Middle Schools/
Junior High Schools

N/A for Elementary Schools using Standards Based Report Cards
High Schools:
  • Type = Grade
  • Limit By = Subject Area
  • Subject Area = Defined Electives Code
  • Which Mark in GRD = Most Recent HIS

Middle Schools/Junior High Schools:

  • Type = Grade
  • Limit By = Department Code
  • Department Code = Defined Electives Code
  • Which Mark in GRD = Most Recent HIS
Transcript 
English
High Schools and Middle Schools/
Junior High Schools

N/A for Elementary Schools using Standards Based Report Cards
High Schools:
  • Type = Grade
  • Limit By = Subject Area
  • Subject Area = Defined English Code
  • Which Mark in GRD = Most Recent HIS

Middle Schools/Junior High Schools:

  • Type = Grade
  • Limit By = Department Code
  • Department Code = Defined English Code
  • Which Mark in GRD = Most Recent HIS
Transcript 
Life Science
High Schools and Middle Schools/
Junior High Schools

N/A for Elementary Schools using Standards Based Report Cards
High Schools:
  • Type = Grade
  • Limit By = Subject Area
  • Subject Area = Defined Science:  Life Code
  • Which Mark in GRD = Most Recent HIS

Middle Schools/Junior High Schools:

  • Title = Consider Science
  • Type = Grade
  • Limit By = Department Code
  • Department Code = Defined Science Code
  • Which Mark in GRD = Most Recent HIS
Transcript 
Math
High Schools and Middle Schools/
Junior High Schools

N/A for Elementary Schools using Standards Based Report Cards
High Schools:
  • Type = Grade
  • Limit By = Subject Area
  • Subject Area = Defined Mathematics Code
  • Which Mark in GRD = Most Recent HIS

Middle Schools/Junior High Schools:

  • Type = Grade
  • Limit By = Department Code
  • Department Code = Defined Mathematics Code
  • Which Mark in GRD = Most Recent HIS

Transcript 
PE
High Schools and Middle Schools/
Junior High Schools

N/A for Elementary Schools using Standards Based Report Cards
High Schools:
  • Type = Grade
  • Limit By = Subject Area
  • Subject Area = Defined Physical Education Code
  • Which Mark in GRD = Most Recent HIS

Middle Schools/Junior High Schools:

  • Type = Grade
  • Limit By = Department Code
  • Department Code = Defined Physical Education Code
  • Which Mark in GRD = Most Recent HIS
Transcript 
Physical Science
High Schools and Middle Schools/
Junior High Schools

N/A for Elementary Schools using Standards Based Report Cards
High Schools:
  • Type = Grade
  • Limit By = Subject Area
  • Subject Area = Defined Science:  Physical Code
  • Which Mark in GRD = Most Recent HIS

Middle Schools/Junior High Schools:

  • Title = Consider Science
  • Type = Grade
  • Limit By = Department Code
  • Department Code = Defined English Code
  • Which Mark in GRD = Most Recent HIS
May need to delete if Transcript - Science already exists
Transcript 
Social Science
High Schools and Middle Schools/
Junior High Schools

N/A for Elementary Schools using Standards Based Report Cards
High Schools:
  • Type = Grade
  • Limit By = Subject Area
  • Subject Area = Defined History/Social Science Code
  • Which Mark in GRD = Most Recent HIS

Middle Schools/Junior High Schools:

  • Title = Consider Science
  • Type = Grade
  • Limit By = Department Code
  • Department Code = Defined History/Social Science Code
  • Which Mark in GRD = Most Recent HIS
Transcript 
World Languages
High Schools and Middle Schools/
Junior High Schools

N/A for Elementary Schools using Standards Based Report Cards
High Schools:
  • Type = Grade
  • Limit By = Subject Area
  • Subject Area = Defined World Languages Code
  • Which Mark in GRD = Most Recent HIS

Middle Schools/Junior High Schools:

  • Title = Consider Science
  • Type = Grade
  • Limit By = Department Code
  • Department Code = Defined Foreign Languages Code
  • Which Mark in GRD = Most Recent HIS
UC A-G
A - History/Social Science
High Schools Only

Delete for 
Elementary Districts
  • Type = College Entrance Requirements
  • UC/CSU = UC
  • California Specific Fields Tab, Subject Area = A
UC A-G
B - English
High Schools Only

Delete for 
Elementary Districts
  • Type = College Entrance Requirements
  • UC/CSU = UC
  • California Specific Fields Tab, Subject Area = B
UC A-G
C - Mathematic
High Schools Only

Delete for 
Elementary Districts
  • Type = College Entrance Requirements
  • UC/CSU = UC
  • California Specific Fields Tab, Subject Area = C
UC A-G
D - AP/IB
High Schools Only

Delete for 
Elementary Districts
  • Type = College Entrance Requirements
  • UC/CSU = UC
  • California Specific Fields Tab, Subject Area = D
UC A-G
D - AP/IB
High Schools Only

Delete for 
Elementary Districts
  • Type = College Entrance Requirements
  • UC/CSU = UC
  • California Specific Fields Tab, Subject Area = D
UC A-G
F - VAPA
High Schools Only

Delete for 
Elementary Districts
  • Type = College Entrance Requirements
  • UC/CSU = UC
  • California Specific Fields Tab, Subject Area = F

UC A-G
G - College Prep Elective
High Schools Only

Delete for 
Elementary Districts
  • Type = College Entrance Requirements
  • UC/CSU = UC
  • California Specific Fields Tab, Subject Area = G