The following extensions are included in InterchangeEducationOrgCalendar:


CalendarDateExtension

ReportingPeriodExtension


Submissions:

(3) = Summer PEIMS (Submission 3)

(4) = Extended PEIMS (Submission 4) (only for schools offering Additional Days School Year (ADSY) program)

(CF) = TSDS Child Find


* Aeries Table.Fields that have an asterisk must be mapped on Texas State Reporting > Code Translations


CalendarDateExtension

(Submission)Element ID
(Code Table)
Data ElementAeries Table.FieldAeries PageLabel
(3) (4)
(CF)
CalendarDate id

DAY.DT
DAY.T1-T26 (Track)
Calendardate (unlabeled), Track

<CalendarDate id="CLND_SSS_YYYYMMDD_XX">

</CalendarDate>


where:
  • SSS = LOC.SC (zero padded)
  • YYYYMMDD = DAY.DT
  • XX = DAY.T1-T26 (track, zero padded, alpha tracks are converted to numeric (e.g., track A is converted to 01))
(3) (4)
(CF)
E1168

CALENDAR-DATEDAY.DT
DAY.T1-T26 (Track)
CalendarTrack

<CalendarDate id="CLND_SSS_YYYYMMDD_XX">

<Date>YYYY-MM-DD</Date>

</CalendarDate>


where YYYY-MM-DD = DAY.DT
Rule (FATAL):
  • 10200-000D: CALENDAR-DATE must be unique for each CalendarDate.

Special Warnings:

  • 10200-0050: If CALENDAR-DATE is on the Memorial Day holiday (the last Monday in May) and INSTRUCTIONAL-PROGRAM-TYPE is 01, 02, or 14, then SCHOOL-DAY-OPERATIONAL-MINUTES should not be greater than 0.
  • 10200-0051: If CALENDAR-DATE is on the Memorial Day holiday (the last Monday in May) and INSTRUCTIONAL-PROGRAM-TYPE is 03, then SCHOOL-DAY-EVENT-CODE should NOT be 01 (Student Instructional Day).
  • 10200-0052: If CALENDAR-DATE is on the Memorial Day holiday (the last Monday in May) and INSTRUCTIONAL-PROGRAM-TYPE is 04-12 or 15, then SCHOOL-DAY-INSTRUCTIONAL-MINUTES should not be greater than 0.
(3) (4)
(CF)
E1582 (C208)

SCHOOL-DAY-EVENT-CODEDAY.HOCalendarunlabeled

<CalendarDate id="CLND_SSS_YYYYMMDD_XX">

<TX-SchoolDayCode>CC</TX-SchoolDayCode>

</CalendarDate>


where CC = 
  • 01 if DAY.HO = blank (student instructional day)
  • 02 if DAY.HO = Waiver day
  • 03 if DAY.HO = COVID-19 restricted access day - TEA approved
  • 04 if DAY.HO = COVID-19 restricted access day - other than TEA approved
(one for each track, up to 27 tracks)
DAY.WC = code for track 00, and DAY.W1-DAY.W26 correspond to codes for up to 26 tracks.
Rules (FATAL):
  • 10200-0015: If CALENDAR-WAIVER-EVENT-TYPE is 02 (Missed School Waiver Day), then SCHOOL-DAY-EVENT-CODE must be 02 (Waiver Day).
  • 10200-0019: If CALENDAR-WAIVER-EVENT-TYPE is 04 (Low Attendance Waiver Day), then SCHOOL-DAY-EVENT-CODE must be 02 (Waiver Day).
  • 10200-0033: If SCHOOL-DAY-EVENT-CODE is 01 (Student Instructional Day), then CALENDAR-WAIVER-EVENT-TYPE must be blank, 01 (Staff Development Waiver Day), or 99 (Other Waiver Day).
  • 10200-0034: If INSTRUCTIONAL-PROGRAM-TYPE is any value other than 03 or 13, and SCHOOL-DAY-EVENT-CODE is 01 (Student Instructional Day), then SCHOOL-DAY-OPERATIONAL-MINUTES must be greater than 0 or SCHOOL-DAY-INSTRUCTIONAL-MINUTES must be greater than 0.
  • 10200-0035: If SCHOOL-DAY-EVENT-CODE is 02 (Waiver Day), then CALENDAR-WAIVER-EVENT-TYPE must be 01, 02, 04, 05, or 99.
  • 10200-0037: For a particular CAMPUS-ID, there must not be a day on the school calendar with CALENDAR-WAIVER-EVENT-TYPE of 01 (Staff Development Waiver Day) before the first day of the school calendar where SCHOOL-DAY-EVENT-CODE is 01 (Student Instructional Day).
  • 10200-0038: For a particular CAMPUS-ID, there must not be a day on the school calendar with CALENDAR-WAIVER-EVENT-TYPE of 01 (Staff Development Waiver Day) after the last day of the school calendar where SCHOOL-DAY-EVENT-CODE is 01 (Student Instructional Day).
  • (4) 10200-0060: For Submission 4, SCHOOL-DAY-EVENT-CODE must be 01 (Student Instructional Day).

Special Warnings:

  • 10200-0010: If INSTRUCTIONAL-PROGRAM-TYPE is any value other than 03 or 13, and SCHOOL-DAY-EVENT-CODE is 01 (Student Instructional Day), and CALENDAR-WAIVER-EVENT-TYPE is blank, then SCHOOL-DAY-OPERATIONAL-MINUTES should be 120-480 or SCHOOL-DAY-INSTRUCTIONAL-MINUTES should be greater than 0.
  • 10200-0051: If CALENDAR-DATE is on the Memorial Day holiday (the last Monday in May) and INSTRUCTIONAL-PROGRAM-TYPE is 03, then SCHOOL-DAY-EVENT-CODE should NOT be 01 (Student Instructional Day).
(3) (4)
(CF)
E1570 (C204)

CALENDAR-WAIVER-EVENT-TYPEDAY.WC, DAY.W1 - DAY.W26CalendarWaiver

<CalendarDate id="CLND_SSS_YYYYMMDD_XX">

<TX-CalendarWaiverEventType>TT</TX-CalendarWaiverEventType>

</CalendarDate>


where TT = DAY.WC-DAY.W26 (one for each track, up to 27 tracks)
DAY.WC = code for track 00 (for no-track schools), and DAY.W1-DAY.W26 correspond to codes for up to 26 tracks.
Only included if TX-SchoolDayCode = 02.
Rules (FATAL):
  • 10200-0011: If SCHOOL-DAY-WAIVER-MINUTES is greater than 0, then CALENDAR-WAIVER-EVENT-TYPE must be:
    • 01 (Staff Development Waiver Day), or
    • 02 (Missed School Waiver Day), or
    • 04 (Low Attendance Waiver Day), or
    • 99 (Other Waiver Day)
  • 10200-0012: If SCHOOL-DAY-WAIVER-MINUTES is 0, then CALENDAR-WAIVER-EVENT-TYPE must be blank or 05 (JJAEP School Day Waiver issued by TJJD).
  • 10200-0015: If CALENDAR-WAIVER-EVENT-TYPE is 02 (Missed School Waiver Day), then SCHOOL-DAY-EVENT-CODE must be 02 (Waiver Day).
  • 10200-0019: If CALENDAR-WAIVER-EVENT-TYPE is 04 (Low Attendance Waiver Day), then SCHOOL-DAY-EVENT-CODE must be 02 (Waiver Day).
  • 10200-0029: For a particular CAMPUS-ID, SCHOOL-YEAR, and INSTRUCTIONAL-TRACK-INDICATOR-CODE, the sum of all SCHOOL-DAY-WAIVER-MINUTES where CALENDAR-WAIVER-EVENT-TYPE is "Staff Development Waiver Day" must not be more than 2100 minutes.
  • 10200-0033: If SCHOOL-DAY-EVENT-CODE is 01 (Student Instructional Day), then CALENDAR-WAIVER-EVENT-TYPE must be blank, 01 (Staff Development Waiver Day), or 99 (Other Waiver Day).
  • 10200-0034: If INSTRUCTIONAL-PROGRAM-TYPE is any value other than 03 or 13, and SCHOOL-DAY-EVENT-CODE is 01 (Student Instructional Day), then SCHOOL-DAY-OPERATIONAL-MINUTES must be greater than 0 or SCHOOL-DAY-INSTRUCTIONAL-MINUTES must be greater than 0.
  • 10200-0035: If SCHOOL-DAY-EVENT-CODE is 02 (Waiver Day), then CALENDAR-WAIVER-EVENT-TYPE must be 01, 02, 04, 05, or 99.
  • 10200-0036: If CALENDAR-WAIVER-EVENT-TYPE is 02 or 04 (Missed School Waiver Day or Low Attendance Waiver Day), then SCHOOL-DAY-OPERATIONAL-MINUTES must be 0 or blank/not reported, and SCHOOL-DAY-INSTRUCTIONAL-MINUTES must be 0 or blank/not reported.
  • 10200-0037: For a particular CAMPUS-ID, there must not be a day on the school calendar with CALENDAR-WAIVER-EVENT-TYPE of 01 (Staff Development Waiver Day) before the first day of the school calendar where SCHOOL-DAY-EVENT-CODE is 01 (Student Instructional Day).
  • 10200-0038: For a particular CAMPUS-ID, there must not be a day on the school calendar with CALENDAR-WAIVER-EVENT-TYPE of 01 (Staff Development Waiver Day) after the last day of the school calendar where SCHOOL-DAY-EVENT-CODE is 01 (Student Instructional Day).
  • 10200-0054: If INSTRUCTIONAL-PROGRAM-TYPE is 13, then CALENDAR-WAIVER-EVENT-TYPE must not be 01, 02, 04, or 99.
  • 10200-0055: If CALENDAR-WAIVER-EVENT-TYPE is 05, then CAMPUS-ID must be a JJAEP campus.

Special Warnings:

  • 10200-0016: If CALENDAR-WAIVER-EVENT-TYPE is 02 (Missed School Waiver Day), then SCHOOL-DAY-WAIVER-MINUTES should generally be 1-480.
  • 10200-0020: If CALENDAR-WAIVER-EVENT-TYPE is 04 (Low Attendance Waiver Day), then SCHOOL-DAY-WAIVER-MINUTES should generally be 1-480.
(3) (4)
(CF)
E1571

SCHOOL-DAY-OPERATIONAL-MINUTESDAY.WC, DAY.W1 - DAY.W26Calendarunlabeled
BEL.T1 and BEL.T2CalendarCustomized Day Information - Starting Time, Ending Time (if used)
Bell SchedulerBell Schedule Details - Start Time, End Time
School OptionsDefault Bell Schedule - Start Time, End Time
DAY.BLBlock Schedule Calendar (if used)Date,
Bell Periods
ARP.D1/ARP.D2Attendance Reporting PeriodsStart Date/End Date
Non-flex:
ART.LP/ART.HP, or
Low Period/High Period
Flex:
ART.LT/ART.HT
Low Time/High Time
ATP.TY = ET (ELO Tutorial)
Supp Att ProgramsAtt Type
DAY.R1- DAY.R26CalendarOverride Minutes
<CalendarDate id="CLND_SSS_YYYYMMDD_XX">
<TX-SchoolDayOperationalMinutes>NNN</TX-SchoolDayOperationalMinutes>
</CalendarDate>

where NNN is calculated as follows.
  • DAY.WC, DAY.W1 - DAY.W26 are used to determine whether the date is included in operational minutes.
    • Non-school days are excluded (see legend).
    • Waiver days are included.
    • For the 2020-2021 school year, COVID restricted access dates are included.
    • Dates are checked against Time/Period ranges as defined in ART table.
  • For operational school dates:
    • If an alternate schedule exists for a particular date on the Calendar page or Bell Scheduler, the period start/end times are used to determine minutes for each period.
    • If a particular date does not have an alternate bell schedule, the Default Bell Schedule on the School Options page is used to determine minutes for each period.
    • If a Block Schedule Calendar is used, Bell Periods for a particular Date are used to determine which period's minutes are totaled. If DAY.BL contains a numeric value, the period is included for that date.
    • Any Waiver minutes and ELO Tutorial minutes are included in the total.
  • If Override Minutes are entered on the Calendar page for a particular date, those minutes are extracted, overriding all other calculations for that date. The Override Minutes field is only available at multi-track schools, and only displayed once a track is selected.
Rules (FATAL):
  • 10200-0034: If INSTRUCTIONAL-PROGRAM-TYPE is any value other than 03 or 13, and SCHOOL-DAY-EVENT-CODE is 01 (Student Instructional Day), then SCHOOL-DAY-OPERATIONAL-MINUTES must be greater than 0 or SCHOOL-DAY-INSTRUCTIONAL-MINUTES must be greater than 0.
  • 10200-0036: If CALENDAR-WAIVER-EVENT-TYPE is 02 or 04 (Missed School Waiver Day or Low Attendance Waiver Day), then SCHOOL-DAY-OPERATIONAL-MINUTES must be 0 or blank/not reported, and SCHOOL-DAY-INSTRUCTIONAL-MINUTES must be 0 or blank/not reported.
  • 10200-0039: If INSTRUCTIONAL-PROGRAM-TYPE is 01, 02, or 14, then SCHOOL-DAY-OPERATIONAL-MINUTES must not be blank.
  • 10200-0040: If INSTRUCTIONAL-PROGRAM-TYPE is 03-13 or 15, then SCHOOL-DAY-OPERATIONAL-MINUTES must be blank/not reported.

Special Warnings:

  • 10200-0010: If INSTRUCTIONAL-PROGRAM-TYPE is any value other than 03 or 13, and SCHOOL-DAY-EVENT-CODE is 01 (Student Instructional Day), and CALENDAR-WAIVER-EVENT-TYPE is blank, then SCHOOL-DAY-OPERATIONAL-MINUTES should be 120-480 or SCHOOL-DAY-INSTRUCTIONAL-MINUTES should be greater than 0.
  • 10200-0027: For a particular CAMPUS-ID, SCHOOL-YEAR, and INSTRUCTIONAL-TRACK-INDICATOR-CODE where INSTRUCTIONAL-PROGRAM-TYPE is 01, 02, or 14, the sum of all SCHOOL-DAY-OPERATIONAL-MINUTES and SCHOOL-DAY-WAIVER-MINUTES should be greater than or equal to 75,600.
  • 10200-0050: If CALENDAR-DATE is on the Memorial Day holiday (the last Monday in May) and INSTRUCTIONAL-PROGRAM-TYPE is 01, 02, or 14, then SCHOOL-DAY-OPERATIONAL-MINUTES should not be greater than 0.
(3) (4)
(CF)
E1599

SCHOOL-DAY-INSTRUCTIONAL-MINUTESDAY.WC, DAY.W1 - DAY.W26Calendarunlabeled
BEL.T1 and BEL.T2CalendarCustomized Day Information - Starting Time, Ending Time (if used)
Bell SchedulerBell Schedule Details - Start Time, End Time
School OptionsDefault Bell Schedule - Start Time, End Time
DAY.BLBlock Schedule Calendar (if used)Date,
Bell Periods
ARP.D1/ARP.D2
Attendance Reporting PeriodsStart Date/End Date
Non-flex:
ART.LP/ART.HP, or

Low Period/High Period
Flex:
ART.LT/ART.HT

Low Time/High Time
DAY.R1 - DAY.R26CalendarOverride Minutes
<CalendarDate id="CLND_SSS_YYYYMMDD_XX">
<TX-SchoolDayInstructionalMinutes>NNN</TX-SchoolDayInstructionalMinutes>
 </CalendarDate>

where NNN is calculated as SCHOOL-DAY-OPERATIONAL-MINUTES minus passing periods and lunch periods.
  • Dates are checked against Time/Period ranges as defined in ART table.
  • If Override Minutes are entered on the Calendar page for a particular date, those minutes are extracted, overriding all other calculations for that date. The Override Minutes field is only available at multi-track schools, and only displayed once a track is selected.
Rules (FATAL):
  • 10200-0034: If INSTRUCTIONAL-PROGRAM-TYPE is any value other than 03 or 13, and SCHOOL-DAY-EVENT-CODE is 01 (Student Instructional Day), then SCHOOL-DAY-OPERATIONAL-MINUTES must be greater than 0 or SCHOOL-DAY-INSTRUCTIONAL-MINUTES must be greater than 0.
  • 10200-0036: If CALENDAR-WAIVER-EVENT-TYPE is 02 or 04 (Missed School Waiver Day or Low Attendance Waiver Day), then SCHOOL-DAY-OPERATIONAL-MINUTES must be 0 or blank/not reported, and SCHOOL-DAY-INSTRUCTIONAL-MINUTES must be 0 or blank/not reported.
  • 10200-0041: If INSTRUCTIONAL-PROGRAM-TYPE is 04-12 or 15, then SCHOOL-DAY-INSTRUCTIONAL-MINUTES must not be blank.
  • 10200-0042: If INSTRUCTIONAL-PROGRAM-TYPE is 01-03, 13, or 14, then SCHOOL-DAY-INSTRUCTIONAL-MINUTES must be blank/not reported.

Special Warnings:

  • 10200-0010: If INSTRUCTIONAL-PROGRAM-TYPE is any value other than 03 or 13, and SCHOOL-DAY-EVENT-CODE is 01 (Student Instructional Day), and CALENDAR-WAIVER-EVENT-TYPE is blank, then SCHOOL-DAY-OPERATIONAL-MINUTES should be 120-480 or SCHOOL-DAY-INSTRUCTIONAL-MINUTES should be greater than 0.
  • 10200-0046: For a particular CAMPUS-ID, SCHOOL-YEAR, and INSTRUCTIONAL-TRACK-INDICATOR-CODE where INSTRUCTIONAL-PROGRAM-TYPE is 04 or 15, the sum of all SCHOOL-DAY-INSTRUCTIONAL-MINUTES and SCHOOL-DAY-WAIVER-MINUTES should be greater than or equal to 32,400.
  • 10200-0047: For a particular CAMPUS-ID, SCHOOL-YEAR, and INSTRUCTIONAL-TRACK-INDICATOR-CODE where INSTRUCTIONAL-PROGRAM-TYPE is 05-12, the sum of all SCHOOL-DAY-INSTRUCTIONAL-MINUTES and SCHOOL-DAY-WAIVER-MINUTES should be greater than or equal to 43,200.
  • 10200-0052: If CALENDAR-DATE is on the Memorial Day holiday (the last Monday in May) and INSTRUCTIONAL-PROGRAM-TYPE is 04-12 or 15, then SCHOOL-DAY-INSTRUCTIONAL-MINUTES should not be greater than 0.
(3)
(CF)
E1572

SCHOOL-DAY-WAIVER-MINUTESDAY.WM, DAY.M1 - DAY.M26CalendarMin
<CalendarDate id="CLND_SSS_YYYYMMDD_XX">
<TX-SchoolDayWaiverMinutes>NNN</TX-SchoolDayWaiverMinutes>
</CalendarDate>

where NNN = DAY.WM-M26
(DAY.WM = minutes for track 00 (for no-track schools), and DAY.M1-DAY.M26 correspond to minutes for up to 26 tracks)
Rules (FATAL):
  • 10200-0011: If SCHOOL-DAY-WAIVER-MINUTES is greater than 0, then CALENDAR-WAIVER-EVENT-TYPE must be 01 (Staff Development Waiver Day), 02 (Missed School Waiver Day), 04 (Low Attendance Waiver Day), or 99 (Other Waiver Day).
  • 10200-0012: If SCHOOL-DAY-WAIVER-MINUTES is 0, then CALENDAR-WAIVER-EVENT-TYPE must be blank or 05 (JJAEP School Day Waiver issued by TJJD).
  • 10200-0029: For a particular CAMPUS-ID, SCHOOL-YEAR, and INSTRUCTIONAL-TRACK-INDICATOR-CODE, the sum of all SCHOOL-DAY-WAIVER-MINUTES where CALENDAR-WAIVER-EVENT-TYPE is "Staff Development Waiver Day" must not be more than 2100 minutes.

Special Warnings:

  • 10200-0016: If CALENDAR-WAIVER-EVENT-TYPE is 02 (Missed School Waiver Day), then SCHOOL-DAY-WAIVER-MINUTES should generally be 1-480.
  • 10200-0020: If CALENDAR-WAIVER-EVENT-TYPE is 04 (Low Attendance Waiver Day), then SCHOOL-DAY-WAIVER-MINUTES should generally be 1-480.
  • 10200-0027: For a particular CAMPUS-ID, SCHOOL-YEAR, and INSTRUCTIONAL-TRACK-INDICATOR-CODE where INSTRUCTIONAL-PROGRAM-TYPE is 01, 02, or 14, the sum of all SCHOOL-DAY-OPERATIONAL-MINUTES and SCHOOL-DAY-WAIVER-MINUTES should be greater than or equal to 75,600.
  • 10200-0028: For a particular SCHOOL-YEAR, CAMPUS-ID, and INSTRUCTIONAL-TRACK-INDICATOR-CODE, the sum of all SCHOOL-DAY-WAIVER-MINUTES should not be more than 4200 minutes.
  • 10200-0046: For a particular CAMPUS-ID, SCHOOL-YEAR, and INSTRUCTIONAL-TRACK-INDICATOR-CODE where INSTRUCTIONAL-PROGRAM-TYPE is 04 or 15, the sum of all SCHOOL-DAY-INSTRUCTIONAL-MINUTES and SCHOOL-DAY-WAIVER-MINUTES should be greater than or equal to 32,400.
  • 10200-0047: For a particular CAMPUS-ID, SCHOOL-YEAR, and INSTRUCTIONAL-TRACK-INDICATOR-CODE where INSTRUCTIONAL-PROGRAM-TYPE is 05-12, the sum of all SCHOOL-DAY-INSTRUCTIONAL-MINUTES and SCHOOL-DAY-WAIVER-MINUTES should be greater than or equal to 43,200.


Additional Rules:

  • One CalendarDate extension for each school day of the school year
  • 10200-000E: For a CalendarDate, the following must be provided: CALENDAR-DATE, SCHOOL-DAY-EVENT-CODE, and SCHOOL-DAY-WAIVER-MINUTES.
  • 10200-0045: For a particular CAMPUS-ID, SCHOOL-YEAR, and INSTRUCTIONAL-TRACK-INDICATOR-CODE where INSTRUCTIONAL-PROGRAM-TYPE is 03, the count of distinct calendar days should be at least 180 days.
  • (CF) GR1: The CalendarDateExtension Complex Type is used by the Child Find Collection for students being evaluated for Special Education services.  For all students evaluated, the CalendarDateExtension is used to calculate the following:
    • The number of instructional days needed to complete the student’s evaluation once the LEA receives consent.
    • The number of instructional days left in the school year beginning the first instructional day after parental consent was received.

ReportingPeriodExtension

SubmissionElement ID
(Code Table)
Data ElementAeries Table.FieldAeries PageLabel
(3) (4)
(CF)
E0266

CAMPUS-IDLOC.CC + LOC.DC + LOC.SC School OptionsCounty + District + Campus
<ReportingPeriodExtension>
<TX-SchoolReference>
<EducationalOrgIdentity>
<StateOrganizationId>CCCDDDSSS</StateOrganizationId>
</EducationalOrgIdentity>
</TX-SchoolReference>
</ReportingPeriodExtension>

where:
  • CCC = LOC.CC
  • DDD = LOC.DC
  • SSS = LOC.SC
(3) (4)
(CF)
E1093 (C193)

SCHOOL-YEARCalculated from current database year

<ReportingPeriodExtension>

<TX-SchoolYear>YYYY-YYYY</TX-SchoolYear>

</ReportingPeriodExtension>


where YYYY-YYYY is the beginning and ending years of the current school year
(3) (4)
(CF)
E0934 (C130)

REPORTING-PERIOD-INDICATOR-CODEARP.RPAttendance Reporting PeriodsReporting Period
<ReportingPeriodExtension>
<TX-ReportingPeriod>N</TX-ReportingPeriod>
</ReportingPeriodExtension>

where N = ARP.RP
 Rule (FATAL):
  • (3) 10200-0022 - 10200-0026: For a particular CAMPUS-ID, SCHOOL-YEAR, and INSTRUCTIONAL-TRACK-INDICATOR-CODE, if REPORTING-PERIOD-INDICATOR-CODE is 2, then REPORTING-PERIOD-BEGIN-DATE must be after REPORTING-PERIOD-END-DATE where REPORTING-PERIOD-INDICATOR-CODE is 1 (i.e., the BeginDate for reporting period 2 must be after the EndDate for reporting period 1), and so on.
(3) (4)
(CF)
E1568

REPORTING-PERIOD-BEGIN-DATEARP.D1Attendance Reporting PeriodsStarting Date
<ReportingPeriodExtension>
<BeginDate>YYYY-MM-DD</BeginDate>
</ReportingPeriodExtension>

where YYYY-MM-DD = ARP.D1
Rules (FATAL):
  • 10200-000H: REPORTING-PERIOD-BEGIN-DATE must be a valid date.
  • 10200-0021: REPORTING-PERIOD-END-DATE must be greater than or equal to REPORTING-PERIOD-BEGIN-DATE.
  • (3) 10200-0022 - 10200-0026: For a particular CAMPUS-ID, SCHOOL-YEAR, and INSTRUCTIONAL-TRACK-INDICATOR-CODE, if REPORTING-PERIOD-INDICATOR-CODE is 2, then REPORTING-PERIOD-BEGIN-DATE must be after REPORTING-PERIOD-END-DATE where REPORTING-PERIOD-INDICATOR-CODE is 1 (i.e., the BeginDate for reporting period 2 must be after the EndDate for reporting period 1), and so on.

Special Warning:

  • 10200-0056: REPORTING-PERIOD-END-DATE should be greater than REPORTING-PERIOD-BEGIN-DATE.
(3) (4)
(CF)
E1569

REPORTING-PERIOD-END-DATEARP.D2Attendance Reporting PeriodsEnding Date
<ReportingPeriodExtension>
<EndDate>YYYY-MM-DD</EndDate>
</ReportingPeriodExtension>

where YYYY-MM-DD = ARP.D2
Rules (FATAL):
  • 10200-000J: REPORTING-PERIOD-END-DATE must be a valid date.
  • 10200-0021: REPORTING-PERIOD-END-DATE must be greater than or equal to REPORTING-PERIOD-BEGIN-DATE.
  • (3) 10200-0022 - 10200-0026: For a particular CAMPUS-ID, SCHOOL-YEAR, and INSTRUCTIONAL-TRACK-INDICATOR-CODE, if REPORTING-PERIOD-INDICATOR-CODE is 2, then REPORTING-PERIOD-BEGIN-DATE must be after REPORTING-PERIOD-END-DATE where REPORTING-PERIOD-INDICATOR-CODE is 1 (i.e., the BeginDate for reporting period 2 must be after the EndDate for reporting period 1), and so on.

Special Warning:

  • 10200-0056: REPORTING-PERIOD-END-DATE should be greater than REPORTING-PERIOD-BEGIN-DATE.
(3) (4)
(CF)
E0975

INSTRUCTIONAL-TRACK-INDICATOR-CODEARP.TRAttendance Reporting PeriodsTrack

<ReportingPeriodExtension>

<TX-InstructionalTrack>XX</TX-InstructionalTrack>

</ReportingPeriodExtension>


where XX = ARP.TR
Alpha tracks are automatically converted to two-digit numeric codes (i.e., A = 01, B = 02, etc.)
(3) (4)
(CF)
E1600

INSTRUCTIONAL-PROGRAM-TYPEARP.IPAttendance Reporting PeriodsInstructional Program
<ReportingPeriodExtension>
<TX-InstructionalProgramType>XX</TX-InstructionalProgramType>
</ReportingPeriodExtension>

where XX = ARP.IP
Rules (FATAL):
  • (3) 10200-0034: If INSTRUCTIONAL-PROGRAM-TYPE is any value other than 03 or 13, and SCHOOL-DAY-EVENT-CODE is 01 (Student Instructional Day), then SCHOOL-DAY-OPERATIONAL-MINUTES must be greater than 0 or SCHOOL-DAY-INSTRUCTIONAL-MINUTES must be greater than 0.
  • (3) 10200-0039: If INSTRUCTIONAL-PROGRAM-TYPE is 01, 02, or 14, then SCHOOL-DAY-OPERATIONAL-MINUTES must not be blank.
  • (3) 10200-0040: If INSTRUCTIONAL-PROGRAM-TYPE is 03-13 or 15, then SCHOOL-DAY-OPERATIONAL-MINUTES must be blank/not reported.
  • (3) 10200-0041: If INSTRUCTIONAL-PROGRAM-TYPE is 04-12 or 15, then SCHOOL-DAY-INSTRUCTIONAL-MINUTES must not be blank.
  • (3) 10200-0053: If INSTRUCTIONAL-PROGRAM-TYPE is 13, then CAMPUS-ID must be a JJAEP campus.
  • (3) 10200-0054: If INSTRUCTIONAL-PROGRAM-TYPE is 13, then CALENDAR-WAIVER-EVENT-TYPE must not be 01, 02, 04, or 99.
  • (3) 10200-0059: The INSTRUCTIONAL-PROGRAM-TYPE is 15, then for this CAMPUS-ID, the PK-FULL-DAY-WAIVER-INDICATOR-CODE must be 1.
  • (4) 10200-0062: For Submission 4, INSTRUCTIONAL-PROGRAM-TYPE must be 16.
  • (3) 42400-0074: For a particular CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE, and REPORTING-PERIOD-INDICATOR-CODE reported on Attendance data, if any students are reported with GRADE-LEVEL-CODE PK, there must be a ReportingPeriod (Calendar sub-category) with a matching CAMPUS-ID, INSTRUCTIONAL-TRACK-INDICATOR-CODE, and REPORTING-PERIOD-INDICATOR-CODE with INSTRUCTIONAL-PROGRAM-TYPE 03, 04, 14, or 15.

Special Warnings:

  • (3) 10200-0010: If INSTRUCTIONAL-PROGRAM-TYPE is any value other than 03 or 13, and SCHOOL-DAY-EVENT-CODE is 01 (Student Instructional Day), and CALENDAR-WAIVER-EVENT-TYPE is blank, then SCHOOL-DAY-OPERATIONAL-MINUTES should be 120-480 or SCHOOL-DAY-INSTRUCTIONAL-MINUTES should be greater than 0.
  • (3) 10200-0045: For a particular CAMPUS-ID, SCHOOL-YEAR, and INSTRUCTIONAL-TRACK-INDICATOR-CODE where INSTRUCTIONAL-PROGRAM-TYPE is 03, the count of distinct calendar days should be at least 180 days.
  • (3) 10200-0050: If CALENDAR-DATE is on the Memorial Day holiday (the last Monday in May) and INSTRUCTIONAL-PROGRAM-TYPE is 01, 02, or 14, then SCHOOL-DAY-OPERATIONAL-MINUTES should not be greater than 0.
(3) (4)
(CF)
E0935

NUMBER-DAYS-TAUGHTARP.TDAttendance Reporting PeriodsTotal Days
<ReportingPeriodExtension>
<TX-NumberDaysTaught>NN</TX-NumberDaysTaught>
</ReportingPeriodExtension>

where NN = ARP.TD
(3) (4)
(CF)
CalendarDateReference ref

DAY.DT,
DAY.T1-T26
Calendardate (unlabled), Track
ARP.D1-ARP.D2Attendance Reporting PeriodsStarting/Ending Dates
 <ReportingPeriodExtension>
<CalendarDateReference ref="CLND_SSS_YYYYMMDD_XX" />
 </ReportingPeriodExtension>

where:
  • SSS = LOC.SC (zero padded)
  • YYYYMMDD = DAY.DT
    The DAY.DT dates are checked against ARP.D1 and ARP.D2. All operational school dates within that range are extracted, one reference per date.
  • XX = DAY.T1-T26 (zero padded)


Additional Rules:

  • (4) The Reporting Periods for the Additional Days School Year Program are reported in the PEIMS Extended Year Submission.
  • (3) (4) 10200-000F: The combination of the following fields must be unique for each ReportingPeriod: CAMPUS-ID, SCHOOL-YEAR, REPORTING-PERIOD-INDICATOR-CODE and INSTRUCTIONAL-TRACK-INDICATOR-CODE.
  • (3) (4) 10200-000G: For a ReportingPeriod, the following must be provided: CAMPUS-ID, SCHOOL-YEAR, REPORTING-PERIOD-INDICATOR-CODE, REPORTING-PERIOD-BEGIN-DATE, REPORTING-PERIOD-END-DATE, INSTRUCTIONAL-TRACK-INDICATOR-CODE, INSTRUCTIONAL-PROGRAM-TYPE, NUMBER-DAYS-TAUGHT, and CalendarDateReference.
  • (3) (4) 42400-0067: For a particular CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE, and REPORTING-PERIOD-INDICATOR-CODE reported on Attendance data, there must be a ReportingPeriod (Calendar sub-category) with a matching CAMPUS-ID, INSTRUCTIONAL-TRACK-INDICATOR-CODE, REPORTING-PERIOD-INDICATOR-CODE, and NUMBER-DAYS-TAUGHT.
  • (3) 42500-0045: For a particular CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE, and REPORTING-PERIOD-INDICATOR-CODE reported on Flexible Attendance data, there must be a ReportingPeriod (Calendar sub-category) with a matching CAMPUS-ID, INSTRUCTIONAL-TRACK-INDICATOR-CODE, REPORTING-PERIOD-INDICATOR-CODE, and NUMBER-DAYS-TAUGHT.
  • (CF) 41163-0082: For a particular CAMPUS-ID-OF-EVALUATION and INSTRUCTIONAL-TRACK-INDICATOR-CODE on Student Child Find Association data, there should be a Reporting Period (Calendar sub-category) with a matching CAMPUS-ID and INSTRUCTIONAL-TRACK-INDICATOR-CODE.
  • (4) 42401-0017: For a particular CAMPUS-ID-OF-ENROLLMENT, INSTRUCTIONAL-TRACK-INDICATOR-CODE, and REPORTING-PERIOD-INDICATOR-CODE reported on SpecialProgramsReportingPeriodAttendanceExtension, if REPORTING-PERIOD-INDICATOR-CODE is 9, there must be a Calendar ReportingPeriodExtension with a matching CAMPUS-ID, INSTRUCTIONAL-TRACK-INDICATOR-CODE, REPORTING-PERIOD-INDICATOR-CODE, and NUMBER-DAYS-TAUGHT.