Skip to main content
Skip table of contents

Staff Schedule File (G)

The following table shows the CEDARS field numbers, field names, the eSchoolPlus Tables and Columns and where the data is coming from in eSchoolPlus for the Staff Schedule File (G) State file.

Field #

Field Name

Required?

eSchoolPlus Table

eSchoolPlus Column

Where to find data in eSchoolPlus

G01

School Year

Yes



From the School Year prompt on page

G02

Serving County District Code

Yes

reg_district

state_code_equiv

Administration > General Setup > District > District (cannot be updated through the software)

G03

Location ID

Yes

schd_ms

building

Scheduling > Courses > Course Sections > Master Schedule: Building

G04

Staff ID

Yes

reg_staff

staff_id

Administration > Registration Setup > Building > Staff: Staff ID field

G05

Course ID

Yes

schd_ms

course

Scheduling > Courses > Course Sections > Master Schedule: Course field

G06

Section ID

Yes

schd_ms

course_section

Scheduling > Courses > Course Sections > Master Schedule: Course Section field

G07

Term

Yes

reg_mp_weeks

state_code_equiv

Administration > Registration Setup > Calendars > Marking Periods: Value in State Code Equivalent column

G08

Instruction Start Date

Yes

Calculated

Calculated

Compare the staff member's Start Date (schd_ms_staff_dates.start_date) with Marking Period dates associated with the course-section (reg_mp_dates.start_date and end_date). Get the earliest valid date where the course meets and the staff member is assigned to the course-section.

In eSchoolPLUS, to determine when the course meets, look at Scheduling > Courses > Course Sections > Master Schedule: Marking Periods. See which Marking Periods are selected.

Then look at the course dates associated with the selected Marking Periods in Administration > Registration Setup > Calendars > Marking Periods: Dates.

For the staff members course dates, refer to Scheduling > Courses > Course Sections > Master Schedule > click either Primary Staff or Secondary Staff link

G09

Instruction End Date

Conditional. This is required if the teacher ceases teaching the course before the Term End Date.

Calculated

Calculated

Compare the staff member's End Date (schd_ms_staff_dates.end_date) with Marking Period dates associated with the course-section (reg_mp_dates.start_date and end_date). Get the latest valid date where the course meets and the staff member is assigned to the course-section.

Instruction End Date is not reported if the teacher has no End Date in Staff Date Tracking.

In eSchoolPLUS, to determine when the course meets, look at Scheduling > Courses > Course Sections > Master Schedule: Marking Periods. See which Marking Periods are selected.

Then look at the course dates associated with the selected Marking Periods in Administration > Registration Setup > Calendars > Marking Periods: Dates.

For the staff members course dates, refer to Scheduling > Courses > Course Sections > Master Schedule > click either Primary Staff or Secondary Staff link

G10

Teacher Indicator

Yes

schd_ms_staff_user

field_value where field_number = '1'

Scheduling > Courses > Course Sections > Master Schedule > click either Primary or Secondary Staff link: Teacher Indicator field

For a primary staff member, default a value of P if the teacher has no Teacher Indicator defined.

G11

Term Start Date

Yes

reg_mp_dates

start_date

Get the Start Date for the course term reported in a particular record.

Administration > Registration Setup > Calendars > Marking Periods > Marking Period Dates panel: Start Date for the reported Term

G12

Term End Date

Yes

reg_mp_dates

end_date

Get the End Date for the course term reported in a particular record.

Administration > Registration Setup > Calendars > Marking Periods > Marking Period Dates panel: End Date for the reported Term.

G10 - Teacher Indicator

Code

Teacher Indicator

P

Primary

A

Alternate

T

Team-Primary
VTeam-Substitute
WTeam-Long Term Substitute
SSubstitute
LLong Term Substitute
JJob Share-Primary
C Job Share-Substitute
DJob Share-Long Term Substitute
ISpecial Education Co-Teaching Model
EELL/ESL Co-Teaching Model
FLAP Co-Teaching Model
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.