School Setup

Data Element

Additional Information

[Table]Field Name

Length

Used in these Reports

Defining Attendance Codes and Code Categories

Attendance Code

Attendance Code

Define attendance codes and their attributes. There are no state-mandated attendance codes for Indiana; however, you must identify attendance codes as either excused or unexcused.

For more information, see PowerSchool Help.

[Attendance_Code]

N/A

N/A

Attendance Code Categories

Attendance Code Categories

Define attendance code categories such as tardy, excluded.

The Unexcused attendance category must be named "Unexcused". This value is used in the DOE_AT report and must be named exactly "Unexcused" without the quotation marks.

The code of the category must be set to the name of the category, such as "Unexcused".

For more information, see PowerSchool Help.

[Code_Entity]

N/A

DOE_AT

Defining Attendance Conversions

Attendance Conversions > [New/Edit] > Attendance Conversion

Attendance Conversion

Define attendance calculation conversion settings used when calculating ADA.

Note: Because attendance is reported in 0.5 increments on the DOE_AT report that is submitted to the state, you must set up the school attendance conversion parameters to generate attendance in 0.5 increments.

For more information, see PowerSchool Help.

[Attendance_Conversion]

N/A

N/A

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

N/A

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

N/A

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

N/A

Attendance Conversions > [None/Defined] > Time

Minutes Present

Enter the minutes present for the time-to-day attendance conversion for the FTE.

[Attendance_Conversion_Items]Conversion_Mode_Code=timeday

[Attendance_Conversion_Items]Input_Value

N/A

N/A

Day Attendance Value

Enter the day attendance value for the time attendance conversion for the FTE.

[Attendance_Conversion_Items]Conversion_Mode_Code=timeday

[Attendance_Conversion_Items]Attendance_Value

N/A

N/A

Defining Full-Time Equivalencies

Full-Time Equivalencies (FTE)

Full-Time Equivalencies

Define student full-time equivalencies used when calculating ADA.

For more information, see PowerSchool Help.

[FTE]

N/A

N/A

Setting Attendance Preferences

Attendance Preferences

Attendance Preferences

Specify general attendance preferences.

For more information, see PowerSchool Help.

[Prefs]

N/A

N/A

Defining Bell Schedules and School Calendars

Bell Schedules

Bell Schedules

Define bell schedules for the current school.

For more information, see PowerSchool Help.

[Bell_Schedule]

N/A

N/A

Calendar Setup - Name of School Year

Calendar Setup

Assign days to membership types and schedules.

For more information, see PowerSchool Help.

[Calendar_Day]

N/A

N/A

Defining Course Section

Sections

Medium of Instruction

Select the applicable medium of instruction:

• Face-to-face instruction (default)

• Technology-based instruction in classroom

• Virtual/On-line Distance learning
  
  

If descriptors are not downloaded the default value, Face-to-face instruction is published.

[S_SEC_X]mediumOfInstruction

50

Section ID

The section ID is automatically assigned when a new section is created.

[Sections]ID

N/A

DOE_CP

DOE-CC

Course Number

Enter the course number for the section.

[Sections]Course_Number

Max 11

DOE_CP

Term

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

[Sections]TermID

N/A

DOE_CP

Schedule

Select the meeting schedule for the section.

[Sections]Expression

[Section_Meeting]SectionID = [Sections]ID

N/A

DOE_CP

Teacher - Section Lead

Choose the Lead Teacher for the section from the pop-up menu.

[SectionTeacher]TeacherID

N/A

DOE_CP

Start Date

The first date the teacher taught in this role.

[SectionTeacher]Start_Date

N/A

DOE_CP

End Date

The last date the teacher taught in this role.

[SectionTeacher]End_Date

N/A

DOE_CP

Section Number

Enter the section number.

[Sections]Section_Number

Max 10

DOE_CP

Grade Level

Enter the grade level for this course.

[Sections]Grade_Level

N/A

DOE_CP

Special Education Area

Enter the area of specialization if this is a special education class.

[S_IN_SEC_X]SpecialEd_Area

N/A

DOE_CP

Special Education Classroom Settings (for primary teacher)

If the primary teacher assigned to this section is a special education teacher, select the setting of the special education classroom.

[S_IN_SEC_X]SpecialEd_Setting

N/A

DOE_CP

Class Instruction

Choose the class instruction code to indicate how the class is instructed.

You must set this value to 1 if the Special Education Classroom Setting (for primary teacher) is:

• Team Teaching

• Co-Teacher

• Consultant Teacher

If this field value is set to 1, you can select up to three additional teachers and/or staff members in the First Secondary Teacher, Second Secondary Teacher and Third Secondary Teacher fields.

[S_IN_USR_X]Multiple_Teachers

1

DOE-CP

First Secondary Teacher

Select the name of the first co-teacher if the Class Taught by Two or More Teachers is set to 1.

[S_IN_SEC_X]Multi_Teacher_1

N/A

DOE_CP

Special Education Classroom Settings (First Secondary Teacher)

If the first secondary teacher assigned to this section is a special education teacher, select the setting of the special education classroom.

[S_IN_SEC_X]SpecialEd_Setting_1

N/A

DOE_CP

Second Secondary Teacher

Select the name of the second co-teacher if the Class Taught by Two or More Teachers is set to 1.

[S_IN_SEC_X]Multi_Teacher_2

N/A

DOE_CP

Special Education Classroom Settings (Second First Secondary Teacher)

If the second secondary teacher assigned to this section is a special education teacher, select the setting of the special education classroom.

[S_IN_SEC_X]SpecialEd_Setting_2

N/A

DOE_CP

Third Secondary Teacher

Select the name of the third co-teacher if the Class Taught by Two or More Teachers is set to 1.

[S_IN_SEC_X]Multi_Teacher_3

N/A

DOE_CP

Special Education Classroom Settings (Third Secondary Teacher)

If the third secondary teacher assigned to this section is a special education teacher, select the setting of the special education classroom.

[S_IN_SEC_X]SpecialEd_Setting_3

N/A

DOE_CP

Alt Course Number

The alternate course number displays from the Edit Course Information page. You cannot change this field value.

[Courses]alt_course_number

N/A

DOE_CP

Class/Period Number

Enter the unique identifier for this class/period.

[S_IN_SEC_X]Class_Period_Number

3

DOE_TL

Dual Credit

Enter a Y value (Yes) if the student received both high school credit and post-secondary institution credit as a result of taking this course.

Enter an N value (No) if the student did not receive or attempt to receive dual credit for this course.

Enter an A value (Not Applicable) if this course is an elementary or middle school course.

[S_IN_SEC_X]Dual_Credit

1

DOE-CC

External Education Organization

Search or choose the external organization from which the student receives dual credit.

[S_IN_CRS_X]External_EduOrg_ID

20

Course Transcipt

Applied Units

An Applied Unit is a section of an applied course that is tied to the IDOE course via alternate achievement standards or content connections and completed with the approved course description.

Valid Values:

• A - Not Applicable. Select if this is an elementary or middle school course or your district is opting out of reporting for the 2018-19 school year. Note: Data will be required for 2019-2020 school year reporting

• Y - Yes

• N - No

• Blank

[S_IN_SEC_X]Applied_Units

1

Post Secondary Institution

If the Dual Credit field equals Y, enter the state-assigned number of the post secondary institution from which the student received dual credit.

Refer to the IDOE Web site for a list of valid post-secondary institution codes.

[S_IN_SEC_X]Post_Secondary_Institution

20

DOE-CC

Method Credit Earned

Choose the method the credit is earned:

• Credit recovery

• Summer school credit

• Summer school IOA

• Transfer credit

• Transfer credit Homeschool

• Transfer credit Out of State

• Virtual/Online credit

If this field is blank then the Classroom credit field is published.

[courses.s_in_crs_x]methodcreditearned

100

Indiana State Obsolete Fields

Periods per Week

Enter the number of combined period per week for this subject and level.

[S_IN_SEC_X]Periods_Per_Week

2

N/A

Highly Qualified Subject

Select the core academic subject that this teacher is highly qualified to teach. Select at least one core academic subject to identify this teacher as highly qualified.

Select the highly qualified subject only if the Alt Course Number value falls within the 0400 - 0499 range and the Highly Qualified Subject is not Elementary Curriculum. In each case, the course could apply to multiple highly qualified areas; therefore, you must identify the highly qualified area that relates to this section. Select one highly qualified area from the list provided to override the default value of Elementary Curriculum as determined in the Highly Qualified Subject Area table.

[S_IN_USR_X]Highly_Qualified_Subject

[S_IN_USR_X]Eng_Qual

[S_IN_USR_X]Rla_Qual

[S_IN_USR_X]Math_Qual

[S_IN_USR_X]Sci_Qual

[S_IN_USR_X]Flang_Qual

[S_IN_USR_X]Gov_Qual

[S_IN_USR_X]Econ_Qual

[S_IN_USR_X]Hist_Qual

[S_IN_USR_X]Geog_Qual

[S_IN_USR_X]Art_Qual

[S_IN_USR_X]Elm_Qual

N/A

DOE_CP

Defining Years & Terms

Years & Terms > New

Years & Terms > Edit Terms

Years & Terms

Define term names and abbreviations with term beginning and ending dates.

Year Long Terms must be set up in the Graduated Students school. The Year Long Term populates the list of terms on the DOE-GR report interface page.

For more information, see PowerSchool SIS > Help > System.

[Terms]

N/A

DOE-GR

Name

Enter the name of the term.

[Terms]Name

N/A

Abbreviation

Enter an abbreviation for the term.

[Terms]Abbreviation

N/A

First Day of Term

Enter the first day of the term.

[Terms]FirstDay

N/A

Last Day of Term

Enter the last day of the term.

[Terms]LastDay

N/A

What portion of the school year does this term represent?

Select the fraction or item that represents the portion of the school year during which the term takes place.

[Terms]Portion

N/A

Import File Term

Enter the Import File Term ID

[Terms]ImportMap

N/A

Exclude Attendance from Transcript

Select to exclude the term's attendance from the IN e-Transcript.

[S_IN_TRM_X]Exclude_Att_From_Transcript

N/A

Course Length

Select the length of the course.

Note: If this field is left blank, the Course Length is extracted based on the value in the field "What portion of the school year does this term represent?", using the following term portion conversion:

[S_IN_TRM_X]Course_Length

N/A