edops

Absent

=case([Present] = "False", 1, 0)

ISA_YTD

=case([Datesequence] = 0, [Ytdisa], 0)

LastWkAttendance

=case([Datesequence] = 0, [Attendancelast7days], 0)

YTDUnexcused

=case([Datesequence] = 0, [Unexcusedabsences], 0)

CurrentChronic

=case([Datesequence] = 0 AND [Chronicallyabsent] = "True", 1, 0)

CurrentTruant

=case([Datesequence] = 0 AND [Truant] = "True", 1, 0)

Before adding the next two, you must add CurrentCornic to Summary section. See “Note” above

CurrentChronicBool

=case([Sum of CurrentChronic] = 1, "True", "False")

CurrentTruantBool

=case([Sum of CurrentTruant] = 1, "True", "False")

Columns

• CurrentlyEnrolled

  • Rename to Active

• StudentID

  • Rename to SIS ID

  • Separator style: 100000.00

• StudentName

  • Rename to Student Name

• GradeLevelStr

  • Rename to Grade Level

• Gender

• Homeroom

• SpecialEducation

  • Rename to SPED (or equivalent)

• LimitedEnglishProficiency

  • Rename to LEP (or equivalent)

• Sum of ISA_YTD

  • Rename to ISA (YTD)

• Sum of Absent

  • Rename to YTDAbsences

• Sum of LastWeekAttendance

  • Rename to ISA (LastWk)

• CurrentChronicBool

  • Rename to Chronic

• Sum of YTDUnexcused

  • Rename to Unexcused

• CurrentTruantBool

  • Rename to Truant