School Setup

Data Element

Additional Information

[Table]FieldName

Length

Used in these Reports

Setting Up Attendance Codes

Attendance Codes

Code

Enter the attendance code abbreviation.

[Attendance_Code]Att_Code

N/A

Required Setup

Description

Enter the attendance code description.

[Attendance_Code]Description

N/A

Required Setup

Presence Status

Select Present or Absent as the presence status.

[Attendance_Code]Presence_Status_CD

N/A

Required Setup

Code Categories

For Colorado State Truancy reporting, Attendance Codes with the Presence Status of Absent must be designated as “Unexcused” to be included in the School Discipline and Attendance – Attendance File as Unexcused

[Code_Entity]Description=Unexcused

N/A

Attendance File – SDA

Attendance Audit

Earns ADA credit

Select whether the attendance code affects attendance calculation.

[Attendance_Code]Calculate_ADA_YN

N/A

Required Setup

Counts toward membership

Select whether the attendance code affects membership calculation.

[Attendance_Code]Calculate_ADM_YN

N/A

Required Setup

Defining Attendance Code Categories

Attendance Code Categories

Note: Attendance code categories are associated with a specific school, but not a specific school year; i.e. they are copied from year to year.

Code

Enter the attendance code category abbreviation.

[Code_Entity]CE_Code

N/A

Required Setup

Name

Enter the name of the attendance code category.

Note:  A Code Category named Unexcused is required.

[Code_Entity]External_Name

N/A

Attendance File – SDA

Attendance Audit

Description

Enter a description for the attendance code category.

[Code_Entity]Description

N/A

Required Setup

Defining Attendance Conversions

Entering Attendance Conversion Name

Attendance Conversions > [New/Edit] > Attendance Conversion

Name

Enter the attendance conversion name.

[Attendance_Conversion]Name

N/A

Required Setup

Entering Period-To-Day Attendance Conversion

Attendance Conversions > [None/Defined] > Period-To-Day Attendance Conversion

Day Attendance Value

Enter the day attendance value for the period-to-day attendance conversion for the FTE.

[Attendance_Conversion_Items]Conversion_Mode_Code = periodday

[Attendance_Conversion_Items]Attendance_Value

N/A

Required Setup

Entering Code-To-Day Attendance Conversion

Attendance Conversions > [None/Defined] > Code-To-Day Attendance Conversion

Code

The code for the code-to-day attendance conversion for the FTE.

[Attendance_Conversion_Items]Conversion_Mode_Code = codeday

[Attendance_Conversion_Items]Input_Value

Note: The value in the Input_Value field is the ID of an attendance code in the [Attendance_Code] table.

N/A

Required Setup

Day Attendance Value

Enter the day attendance value for the code-to-day attendance conversion for the FTE.

[Attendance_Conversion_Items]Conversion_Mode_Code = codeday

[Attendance_Conversion_Items]Attendance_Value

N/A

Required Setup

Defining Attendance Tracking and Notification

Updating Attendance Mode Setup

Attendance Tracking and Notification > Attendance Mode Setup > Edit/New

Attendance Mode Value

Choose the attendance mode used as the default for your school from the pop-up menu:

• (MPTD) Meeting Period to Day

• (MTTD) Meeting Time to Day

• (DCTD) Daily Code to Day

• (DTTD) Daily Time to Day

[Gen]Value=MPTD, MTTD, DCTD, or DTTD

[Gen]Name=UEAT_Mode

[Gen]Cat=Unexcused

N/A

Attendance File – SDA

Attendance Audit

Updating Unexcused Tracking Setup

Attendance Tracking and Notification > Unexcused Tracking Setup > Edit/New

A student is considered truant when s/he achieves the equivalent of one day of unexcused absence. For example, using an eight period schedule, if a student is marked unexcused for eight periods within one month, regardless of whether all of the periods are on the same day, the student is considered to be truant for one day.

Note: The following values should not be changed after initial setup each school year.

Tracking Category

The page displays Unexcused to indicate that the attendance code category selected will be used to track unexcused absences.

N/A

N/A

Attendance File – SDA

Attendance Audit

Attendance Category

Choose the attendance code category dedicated to tracking unexcused absences from the pop-up menu.

Attendance code categories can only be used once, so the pop-up menu displays all attendance code categories set up for your school, except for those already associated with an unexcused reporting category.

[Gen]Value

[Gen]Name=UEAT_Category

[Gen]Cat=Unexcused

N/A

Attendance File – SDA

Attendance Audit

Status

Select the radio button for Absent to indicate that this unexcused tracking category is used to track absences.

[Gen]Value2=Absent

[Gen]Name=UEAT_Category

[Gen]Cat=Unexcused

N/A

Attendance File – SDA

Attendance Audit

Defining Full-Time Equivalencies (FTE)

Full-Time Equivalencies (FTE)

Name

Enter the FTE name.

[FTE]Name

N/A

Required Setup

Default Attendance Mode

Choose the default attendance mode for the FTE from the pop-up menu.

[FTE]Dflt_Att_Mode_Code

N/A

Required Setup

Default Attendance Conversion

Choose the default attendance conversion for the FTE from the pop-up menu.

[FTE]Dflt_Conversion_Mode_Code

N/A

Required Setup

Defining Attendance Preferences

Attendance Preferences

Attendance Recording Methods

Select the Meeting checkbox to enable meeting attendance.

Select the Daily checkbox to enable daily attendance.

[Prefs]Value

[Prefs]Name=ATT_RecordModeMeeting

[Prefs]Name=ATT_RecordModeDaily

N/A

Required Setup

Count these codes for period conversion

Choose [Absences/Presents] from the count these codes for period conversion pop-up menu.

Note: This option determines whether to count present or absent codes for period-to-day attendance conversions.

[Prefs]Value

[Prefs]Name=ATT_CalcCntPresentsAbsences

N/A

Required Setup

Entering Bell Schedules

Bell Schedules

Name

Enter the bell schedule name.

[Bell_Schedule]Name

N/A

Required Setup

Attendance Conversion Method

Choose the attendance conversion method for the bell schedule from the pop-up menu.

[Bell_Schedule]Attendance_Conversion_ID

N/A

Required Setup

Defining Calendar Setup

Calendar Setup

Date

The date is view-only on this page. The days included in the calendar are determined by the start date and end date of current school year.

[Calendar_Day]Date

1

Required Setup

Day

Choose the appropriate cycle day from the pop-up menu.

[Calendar_Day]Cycle_Day_ID

N/A

Required Setup

Schedule

Choose the appropriate bell schedule from the pop-up menu.

[Calendar_Day]Bell_Schedule_ID

N/A

Required Setup

Tracks

Check the appropriate tracks.

[Calendar_Day]A, B, C, D, E, F

N/A

Required Setup

In Session

Check the checkbox to count the calendar day in attendance calculation.

[Calendar_Day]InSession

1

Attendance File - SDA

Memb Value

Enter the membership value for the calendar day to use when calculating membership.

Note: The value is normally 1 for each day.

[Calendar_Day]MembershipValue

N/A

Required Setup

Type

Choose the appropriate calendar membership type from the pop-up menu.

Choose a type for days when instructional staff is engaged in professional development activities. Calendar Membership Type values are defined at the district level.

[Calendar_Day]Type

N/A

Required Setup

Defining Cycle Days

Cycle Days

Day Letter

The day letter is view-only on this page. To edit the number of days associated to this school year, navigate to School Setup > Years & Terms > Edit School Year.

[Cycle_Day]Letter

N/A

Required Setup

Day Abbreviation

Enter the day abbreviation.

[Cycle_Day]Abbreviation

N/A

Required Setup

Day Name

Enter the day name.

[Cycle_Day]Day_Name

N/A

Required Setup

Defining Periods

Periods

Period Number

The period number is view-only on this page. To edit the number of periods associated to this school year, navigate to School Setup > Years & Terms > Edit School Year.

[Period]Period_Number

N/A

Required Setup

Period Abbreviation

Enter the period abbreviation.

[Period]Abbreviation

N/A

Required Setup

Period Name

Enter the period name.

[Period]Name

N/A

Required Setup

Editing Section

Sections

Sections > [select course] > [select section] > Edit Section

Course Number

Enter the course number for the section.

[Sections]Course_Number

N/A

Student - Advance Course Completion

Statewide Standard Course Codes

TSDL – Enrollment

TSDL - Instructor

Term

Choose the term for the section from the pop-up menu.

[Sections]TermID

N/A

Student - Advance Course Completion

Statewide Standard Course Codes

TSDL – Enrollment

TSDL - Instructor

Schedule

Select the meeting schedule for the section.

[Sections]Expression

[Section_Meeting]SectionID = [Sections]ID

N/A

Required Setup

Teacher – Section Lead

Choose the teacher for the section from the pop-up menu.

[Sections]Teacher

N/A

Required Setup

Teacher/Staff - Additional

Choose the teacher for the section from the pop-up menu.

Choose the Role. Roles must be set up at the District Office.

[Sections]Teacher

N/A

TSDL - Instructor

Section Number

Enter the section number or leave blank to be filled automatically.

[Sections]Section_Number

N/A

TSDL – Enrollment

TSDL - Instructor

MSP Project Code

The Project Code must be identifying from one of the codes listed below. This four (4) digit field is REQUIRED and if left blank will result in a message being printed on the error report. Data in this field will override data entered at the Course level.

[S_CO_SEC_X]MSPProjectCode

4

TSDL - Instructor

Exclude from State Reporting

Select the checkbox to exclude this section from being included in any state reports.

[S_CO_SEC_X]State_ExcludeFromReporting

1

All State Reports

Industry Certificate Course

Choose the industry certificate course from the pop-up menu.

Valid values:

• Same as course

• Not an Industry Certificate Course Section (N)

• Industry Certificate Course Section (C)

[S_CO_SEC_X]IndustryCertificate

1

Course Level

Choose the course level from the pop-up menu.

Valid values:

• Same as course

• Not a College level Course Section (N)

• College Level Course Section (C)

[S_CO_SEC_X]CourseLevel

1

Editing Years & Terms

Years & Terms > New

Years & Terms > Edit Terms

Name

Enter the name of the term.

[Terms]Name

N/A

Required Setup

Abbreviation

Enter an abbreviation for the term.

[Terms]Abbreviation

N/A

Required Setup

First Day of Term

Enter the first day of the term.

[Terms]FirstDay

N/A

Required Setup

Last Day of Term

Enter the last day of the term.

[Terms]LastDay

N/A

Required Setup

Store Code for TSDL/Graduation Guidelines Final Grade Reporting

Enter the Store Code that will be used by the TSDL Course Enrollment report and the Graduation Guidelines report to designate a student’s Final Grade for the term.

Note:  You must match the Store Code for TSDL with the Store Code to be used for the Final Grade. Both fields are case-sensitive.

[S_CO_TRM_X]TSDL_StoreCode

2

TSDL – Enrollment

Colorado State Report Information

Checking Store Code Mapping for TSDL/Graduation Guidelines

View Store Code Mapping for TSDL

Note: View only. To update, navigate to Years & Terms

School Year Tabs

Select the school year to view.

Term Name, Abbreviation, First Day, Last Day, Term ID

Data for each term created for the selected (tab) school year

See Years & Terms

Store Code for TSDL Final Grade Reporting

The TSDL Store Code that is designated for that term. To edit the TSDL Store Code, click the existing TSDL Store Code link to be returned to the Edit Term page in Years & Terms.

[S_CO_TRM_X]TSDL_StoreCode

N/A

TSDL – Enrollment

Checking March Report Card Collection Fields

View March Report Card Collection Fields

School Programs

Before and After School Care Programs

Choose Yes or No from the pop-up menu to specify if the school has a Before and After School Care Program.

[S_CO_SCH_X]School_Care_Programs

1

Report Card March

Full-Day Kindergarten Program

Choose Yes or No from the pop-up menu to specify if the school has a Full-Day Kindergarten Program.

[S_CO_SCH_X]Fullday_Kinder_Flag

1

Report Card March

Preschool Program Flag

Choose Yes or No from the pop-up menu to specify if the school has a preschool program.

[S_CO_SCH_X]Preschool_Program

1

Report Card March

Year Round School

Choose Yes or No from the pop-up menu.

[S_CO_SCH_X]Year_Round_School

1

Report Card March

Courses

Civics

Choose Yes or No from the pop-up menu to specify if the school has a Civics Program.

[S_CO_SCH_X]Civics_Flag

1

Report Card March

Comprehensive Health Education

Choose Yes or No from the pop-up menu to specify if the school has a Comprehensive Health Education Program.

[S_CO_SCH_X]Comp_Health_Ed

1

Report Card March

Dance

Choose Yes or No from the pop-up menu to specify if the school has a Dance Program.

[S_CO_SCH_X]Dance_Flag

1

Report Card March

Drama or Theatre

Choose Yes or No from the pop-up menu to specify if the school has a Drama or Theatre Program.

[S_CO_SCH_X]Drama_Theatre_Flag

1

Report Card March

Economics

Choose Yes or No from the pop-up menu to specify if the school has an Economics Program.

[S_CO_SCH_X]Economics_Flag

1

Report Card March

Geography

Choose Yes or No from the pop-up menu to specify if the school has a Geography Program.

[S_CO_SCH_X]Geography_Flag

1

Report Card March

History

Choose Yes or No from the pop-up menu to specify if the school has a History Program.

[S_CO_SCH_X]History_Flag

1

Report Card March

Music

Choose Yes or No from the pop-up menu to specify if the school has a Music Program.

[S_CO_SCH_X]Music_Flag

1

Report Card March

Physical Education

Choose Yes or No from the pop-up menu to specify if the school has a Physical Education Program.

[S_CO_SCH_X]Phys_Ed_Flag

1

Report Card March

Visual Arts

Choose Yes or No from the pop-up menu to specify if the school has a Visual Arts Program.

[S_CO_SCH_X]Art_Flag

1

Report Card March

World Languages Flag

Choose Yes or No from the pop-up menu to specify if the school has a World Languages Program.

[S_CO_SCH_X]World_Languages_Flag

1

Report Card March

Student Programs

Advanced Placement

Choose Yes or No from the pop-up menu to specify if the school has an Advanced Placement Program.

[S_CO_SCH_X]Advanced_Placement_Flag

1

Report Card March

Assistance of Out-of-School Youth to Re-Enroll

Choose Yes or No from the pop-up menu to specify if the school has an Assistance of Out-of-School Youth to Re-Enroll Program.

[S_CO_SCH_X]Asst_Out_School_Youth

1

Report Card March

Athletics

Choose Yes or No from the pop-up menu to specify if the school has an Athletics Program.

[S_CO_SCH_X]Athletics_Flag

1

Report Card March

Blended Learning

Choose Yes or No from the pop-up menu to specify if the school has a Blended Learning Program.

[S_CO_SCH_X]BlendedLearn

2

Report Card March

Career and Technical Education

Choose Yes or No from the pop-up menu to specify if the school has a Career and Technical Education Program.

[S_CO_SCH_X]Career_Tech_Ed_Flag

1

Report Card March

Concurrent Enrollment Classes on School Property

Choose Yes or No from the pop-up menu to specify if the school has concurrent enrollment classes on school property.

[S_CO_SCH_X]Concur_Enroll_School_Flag

1

Report Card March

Credit Recovery Programs

Choose Yes or No from the pop-up menu to specify if the school has Credit Recovery Programs.

[S_CO_SCH_X]Credit_Recovery_Programs_Flag

1

Report Card March

Extracurricular Activities

Choose Yes or No from the pop-up menu to specify if the school has an Extracurricular Activities Program.

[S_CO_SCH_X]Xtra_Activities_Flag

1

Report Card March

Flexible Schedule Flag

Choose Yes or No from the pop-up menu to specify if the school has a Flexible Schedule Program.

[S_CO_SCH_X]FlexSchedule

2

Report Card March

Honors Courses

Choose Yes or No from the pop-up menu to specify if the school offers Honors Courses.

[S_CO_SCH_X]Honors_Courses_Flag

1

Report Card March

International Baccalaureate

Choose Yes or No from the pop-up menu to specify if the school offers an International Baccalaureate Program.

[S_CO_SCH_X]International_Bac_Flag

1

Report Card March

Internet Safety Programs

Choose Yes or No from the pop-up menu to specify if the school has an Internet Safety Program.

[S_CO_SCH_X]Internet_Safety_Flag

1

Report Card March

Immediate Progress Towards Graduation Flag

Choose Yes or No from the pop-up menu to specify if the school has an Immediate Progress Towards Graduation Program.

[S_CO_SCH_X]ImmediateProgToGrad

2

Report Card March

Library

Choose Yes or No from the pop-up menu to specify if the school has a Library Program

[S_CO_SCH_X]Library_Flag

1

Report Card March

Montessori Curricula

Choose Yes or No from the pop-up menu to specify if the school has Montessori Curricula

[S_CO_SCH_X]Montessori_Curricula_Flag

1

Report Card March

Newcomer Center Flag

Choose Yes or No from the pop-up menu to specify if the school has a Newcomer Center.

[S_CO_SCH_X]NewcomerCenter

2

Report Card March

Opportunities for Civic or Community Engagement

Choose Yes or No from the pop-up menu to specify if the school has Opportunities for Civic or Community Engagement.

[S_CO_SCH_X]Civic_Comm_Engagement

1

Report Card March

Work-based Educational Experience Flag

Choose Yes or No from the pop-up menu to specify if the school has a Work-based Educational Experience Program.

[S_CO_SCH_X]WorkEdExperiences

2

Report Card March

Health and Wellness

School-Based Health Center

Choose Yes or No from the pop-up menu to specify if the school has a School-Based Health Center

[S_CO_SCH_X]School_Linked_Health_Center

1

Report Card March

Comprehensive Health Education Required

Choose Yes or No from the pop-up menu to specify if the school requires Comprehensive Health Education.

[S_CO_SCH_X]Health_Ed_Required

1

Report Card March

Physical Activity

Choose Yes or No from the pop-up menu to specify if the school requires Physical Activity

[S_CO_SCH_X]K6_Recess_Flag

1

Report Card March

Physical Education Is Required (All Students)

Choose Yes or No from the pop-up menu to specify if the school requires Physical Education for all students.

[S_CO_SCH_X]Phys_Ed_Required

1

Report Card March

Uses Federal School Breakfast Program in Classroom

Choose Yes or No from the pop-up menu to specify if the school uses the Federal School Breakfast Programs in the classroom.

[S_CO_SCH_X]Participates_Fed_Sch_Breakfast

1

Report Card March

CDE Licensed School Nurse is Available During School Hours

Choose Yes or No from the pop-up menu to specify if the school has a CDE Licensed School Nurse Available during school hours.

[S_CO_SCH_X]Rn_On_Premises_Flag

1

Report Card March

School Health Team or School Wellness Committee

Choose Yes or No from the pop-up menu to specify if the school has a School Health Team or School Wellness Committee

[S_CO_SCH_X]Health_Wellness_Flag

1

Report Card March

Number of Days

Professional Development Days

Enter the number of whole and partial days scheduled in which all instructional staff members are engaged together in professional development activities for the current school year.

[S_CO_SCH_X]Professional_Dev_Days

3

Report Card March

Bullying Policies and Programs

Bully Policy Flag

Choose Yes or No to indicate whether the school meets all components of the bullying policy. For further information, refer to the latest CDE Report Card March File Layout and Definitions document: http://www.cde.state.co.us/datapipeline/per_report-march.

[S_CO_SCH_X]Bully_Policy

1

Report Card March

Bully Prevention in Positive Behavioral Interventions

and Supports (BP - PBIS) Flag

Choose Yes or No to indicate whether the school uses Bully Prevention in Positive Behavioral Interventions and Supports (BP-PBIS) as an evidence based bullying program.

[S_CO_SCH_X]Bully_Prevention_BPPBIS

1

Report Card March

Bully Proofing Your School (BPYS) Flag

Choose Yes or No to indicate whether the school uses Bully Proofing Your School (BPYS) as evidence based bullying program.

[S_CO_SCH_X]Bully_Proofing_PBYS

1

Report Card March

Olweus Bully Prevention Program (BPP) Flag

Choose Yes or No to indicate whether the Olweus Bully Prevention Program (BPP) as an evidence based bullying program.

[S_CO_SCH_X]Olweus_BPP

1

Report Card March

Promoting Alternative Thinking Strategies (PATHS) Flag

Choose Yes or No to indicate whether the school uses Promoting Alternative Thinking Strategies (PATHS) as an evidence based bullying program.

[S_CO_SCH_X]Promote_Alternative_PATHS

1

Report Card March

Second Step Flag

Choose Yes or No to indicate whether the school uses Second Step as an evidence based bullying program.

[S_CO_SCH_X]Second_Step

1

Report Card March

Steps to Respect Flag

Choose Yes or No to indicate whether the school uses Steps to Respect as an evidence based bullying program.

[S_CO_SCH_X]Steps_To_Respect

1

Report Card March

Home Grown

Choose Yes or No to indicate whether the school

uses a Home Grown bullying program as an evidence based bullying program.

[S_CO_SCH_X]Home_Grown_Program

1

Report Card March

If Home Grown, specify

If Yes is chosen for Home Grown, enter the name the program is patterned after.

[S_CO_SCH_X]Home_Grown_Specify

50

Report Card March

Other Flag

Choose Yes or No to indicate whether the school uses a program not listed above as an evidence based bullying program

[S_CO_SCH_X]Other_Bully_Program

1

Report Card March

If Other, specify

If Yes is chosen for Other, enter the name of the program.

[S_CO_SCH_X]Other_Bully_Program_Specify

50

Report Card March