District Setup

Data Element

Additional Information

[Table]Field Name

Length

Used in these Reports

Course Name

Enter the course name.

[Courses]Course_Name

40

Required Setup

Course Number

Enter the course number.

[Courses]Course_Number

11

Teacher Course Student (TCS)

Alternate Course Number

Enter the alternate course number.

[Courses]Alt_Course_Number

10

Teacher Course Student (TCS)

Department

Note: This field only appears after the course is created.

Click Associate, choose the appropriate department and click Submit,

[Courses]Sched_Department

12

SCED Code Classification System

• Prior to Secondary

• Secondary 

SCED Course Code

Click the SCED Code link to see a list of available SCED codes.

[S_CC_X]SCED_Course_Code

[S_CRS_X]SCED_Course_Code

[S_SEC_X]SCED_Course_Code

5

SCED Course Level

Choose the code that conveys the level of rigor of the course.

Valid values:

• B - Basic or remedial

• X - No specified level of rigor

• H - Honors

• E - Enriched or advanced

• G - General or regular

[S_CC_X]SCED_Course_Level

[S_CRS_X]SCED_Course_Level

[S_SEC_X]SCED_Course_Level

1

Available Carnegie Unit Credit

For secondary courses (SCED Subject Areas 1-22), enter the number of Carnegie credits available for this course.

[S_CC_X]SCED_Carnegie_Credit

[S_CRS_X]SCED_Carnegie_Credit

[S_SEC_X]SCED_Carnegie_Credit

4

SCED Grade Span

For the non-secondary course (SCED Subject Areas 51-73), enter the grade level for which the course is appropriate.

[S_CC_X]SCED_Grade_Span

[S_CRS_X]SCED_Grade_Span

[S_SEC_X]SCED_Grade_Span

4

SCED Sequence of Course

Enter a value to indicate how school systems may “break up” increasingly difficult or more complex information.

[S_CC_X]SCED_Sequence

[S_CRS_X]SCED_Sequence

[S_SEC_X]SCED_Sequence

2

SCED Subject Type

Valid values:

• Alg I

• Alg II

• Adv Math

• Biology

• Calculus

• Computer Science

• Chemistry

• Geometry

• Physics

Note: Required for CRDC

[S_CC_X]SCED_Subject_Type

[S_CRS_X]SCED_Subject_Type

[S_SEC_X]SCED_Subject_Type

30

SCED AP Type

Valid values:

• M -Math

• S - Science

• C - Computer Science

• O - Other

Note: Required for CRDC

[S_CC_X]SCED_AP_Type

[S_CRS_X]SCED_AP_Type

[S_SEC_X]SCED_AP_Type

30

NCES Code Classification System

NCES Course Code

NCES Rigor

NCES Grade Range

NCES Sequence

NCES Completed Course Code

Enter the NCES course code data that applies to this course, if applicable.

NCES Code Classification System values:

• Prior to Secondary

• Secondary 

For NCES Course Code, select a code value for this course. Click the link NCES Codes to view the NCES Codes page. On the NCES Codes page, click the Prior to Secondary or Secondary button to filter the course codes based on the Prior to Secondary or Secondary classification.

NCES Rigor valid values:

• B - Basic/Remedial

• G - General/Regular

• E - Enhanced/Advanced

• H - Honors

• X - No specific rigor (PK-8 only)

Notes: Only for records with no associated course section.

The fields specified at left are concatenated together to form the NCES Completed Course Code.

[S_CT_CRS_X]NCESCourseCode

12

Teacher Course Student (TCS)

School Where Taught

If the course is taught at a different school, enter the SchoolID for where the course is taught.

[S_CT_CRS_X]WhereTaught

9

Exclude from TCS Report

Check to exclude enrollments and grades for this course from the TCS report

[Courses]Exclude_State_Rpt_YN

1

Use Marking Period for TCS

Select Yes if this course uses marking periods for awarding grades and credits instead of a single final grade at the end of the course. This setting can be overridden at the section.

Note: The default for this field is Use School Preference.

[S_CT_CRS_X] UseMarkingPeriodDates

1

Teacher Course Student (TCS)

TCS Alternate Grading Method

Dual Enrollment Code

The code associated with the higher learning dual enrollment program for which the student is earning college credit.

See the Appendix for valid values.

[S_CT_CRS_X]DualEnrollPrgmCode

Teacher Course Student (TCS)

Title I Services

Multiselect list of Title 1 services

[S_CT_CRS_X]CourseTitle1Service

Legacy → Part B. Credit for Selected Course

Select the category for this course.

[S_CT_CRS_X]Selected_Courses_Credit

N/A

Legacy → Part C. Advanced Placement Course

Choose Yes or No to indicate if this is an advanced placement course.

[S_CT_CRS_X]AdvancedPlacementCourse

N/A

Legacy → Part C. Subject Area

Choose the subject area for this course.

[S_CT_CRS_X]Subject_Area

N/A

Legacy → Part D. College Level Course

Choose the course level for this course If this is a college-level course.

[S_CT_CRS_X]College_Level_Course

N/A

Connecticut State Information

CT Discipline Codes and Subcodes Status

Click to load Codes/Subcodes.

N/A

Organization Code

Enter the Organization code. 

Note: Only numeric values are accepted. 

[Pref]CT_OrganizationCode

7

Connecticut Physical Fitness Assessment Setup

1. Click Connecticut Physical Fitness Assessment Setup link.

2. Complete the process to run the job.

3. Select a student.

4. Navigate to Fitness page.

5. Click Add Score button.

N/A

Civil Rights Data Collection (CRDC)

For instructions on completing the CRDC fields, see CRDC District Setup.

Log Type    

Enter “Discipline”.

[Gen]Cat=logtype

[Gen]Name

Max 20

ED166

Discipline Record Extract

Name of District

The district name.

[Prefs]Name=districtname

[Prefs]Value

40

ED205

District Number

The three-digit code for the reporting school district.

[Prefs]Name=districtnumber

[Prefs]Value

3

PSIS

SASID

ED166

ED205

Teacher Course Student (TCS)

Organization Code

The seven-digit numerical code for the reporting school district

[Prefs]Name=organizationcode

[Prefs]Name=Value

7

CPFA

Civil Rights Data Collection (CRDC)

For instructions on completing the CRDC fields, see CRDC District Setup

School Name

Enter the school name.

[Schools]Name

Max 60

ED205

School Number

Enter the school number.

Note: For CT, it corresponds to “Facility Code 1” and states which other fields are potential sources of the data if a school’s SchoolID is already populated with something that is not the CT Facility Code.

[Schools]School_Number

9

PSIS

SASID

ED166

ED205

Teacher Course Student (TCS)

Exclude From State Reporting?

Select this checkbox to exclude the school from state reporting.

[Schools] State_ExcludeFromReporting

N/A

PSIS

SASID

ED166

Grades

Enter the school grade levels (lowest - highest).

For more information, see the Appendix.

[Schools]Low_Grade

[Schools]High_Grade

2

PSIS

SASID

CRDC Report

Connecticut State Report Information

ED540 Graduating Class Report Setup

Refer to ED540 Setup.

Outplacement school

Choose Yes or No to indicate if the school is an outplacement school

[S_CT_SCH_X]Outplacement_school

1

ED540 - deprecated report

Extended Time Instructional Program

Choose Yes or No to indicate if Title I extended time instructional programs are conducted in your school, including before school, after-school, weekend, and summer programs.

Note: Adult education, preschool programs, or club activities are excluded from this count.

[S_CT_SCH_X] InstructionalProgram

1

ED205 -deprecated report

Family Literacy Program

Choose Yes or No to indicate if Title I family literacy programs are conducted in your school.

[S_CT_SCH_X]FamilyLiteracyProg

1

ED205 -deprecated report

Full-time Equivalent (FTE)

Enter the number of individuals who fit into the designated Title I staffing categories.

Note: This field is included in the calculation to determine the FTE amount a school has for Title 1 programs.

[S_CT_SCH_X]FTEStaff

3

ED205 -deprecated report

PreK Program Status Code

Choose the student’s pre-K program or combination of programs from the pop-up menu.

Note: This field is required for students in grade levels P3 and PK.

[S_CT_SCH_X]PreKProgramStatusCode

2

ED205

Default Length of PreK Program Day in Hours

Enter the default number of hours that pre-k students attend school. Enter a value rounded to the nearest 15-minute (quarter-hour) increment.

[S_CT_SCH_X]PreKHoursPerDay

16

PSIS

Default Length of PreK Program Days per Year

Enter the default number of days that pre-k students attend school per year.

Note: This field is required if students in grade levels P3 and PK attend the school.

[S_CT_SCH_X]PreKDaysPerYear

16

PSIS

Grade Levels using Standards Grading

Click Add, and enter a grade level that utilizes standards-based grading. Repeat for each grade level.

Note: Enter integer values only

[S_CT_SCH_Standard_Grd_Levels_C]Grade_Level

11

Teacher Course Student (TCS)

Use Marking Period for TCS

Select Yes if this school uses marking periods for awarding grades and credits instead of a single final grade at the end of the course. This setting can be overridden at the course or section.

[S_CT_SCH_X] UseMarkingPeriodDates

1

Teacher Course Student (TCS)

(TCS) Alternate Grading Method

Lunch Minutes

Select the number of minutes per day each student is provided for lunch.

[S_CT_SCH_X]LunchMinutes

2

Recess

Select Yes or No to indicate if a recess of at least 20 minutes per day is provided to your students during full school days.

[S_CT_SCH_X]Recess

N/A

Highest Grade

Select the highest grade at which recess is provided.

[S_CT_SCH_X]HighestGrade

N/A

Reporting Store Codes (TCS)

Enter store codes to select the grades extracted for the Teacher Course Student report.

Notes:

• A separate Store Codes(s) needs to be entered for each length of the term a course is taught.

• Multiple store codes can be entered with a comma, such as Q1,Q2,Q3.

• When the End-of-Year Process is run, Reporting Store Codes (TCS) are copied, and new records are automatically generated for the new school year.

[S_CT_ReportingStoreCodes_S]YearId

[S_CT_ReportingStoreCodes_S]StoreCodeList

50

Teacher Course Student (TCS)

Grade Level Outcome Codes (TCS)

Notes: 

• This section should only be set up for schools and grade level using Standards grades. Do not set up Grade Level Outcome or Outcome status for schools or grades that do not use Standards grades. Doing so will cause duplicate entries in TCS submissions via SIF.

• When the End-of-Year Process is run, the Grade Level Outcome setup (TCS Outcome and TCS Outcome Status) is copied, and new records are automatically generated for the new school year.

TCS Outcome

Enter a default outcome for each grade level that uses Standards grades.

[S_CT_GradeLevelOutcome_S]TCSOutcome

10

Teacher Course Student (TCS)

TCS Outcome Status

Select the default outcome status from the dropdown that correlates to the default outcome

[S_CT_GradeLevelOutcome_S]TCSOutcomeStatus

10

Teacher Course Student (TCS)

Civil Rights Data Collection (CRDC)

For instructions on completing the school CRDC fields, see CRDC School Setup.

Ethnicity Decline to Specify

Do not select the checkbox; this option is not allowed for Connecticut state reporting.

[Prefs]FRE_AllowDeclineEthnicity

[Prefs]FRE_DeclineEthnicityText

N/A

Not Allowed in CT State Reporting

Race Decline to Specify

Do not select the checkbox; this option is not allowed for Connecticut state reporting.

[Prefs]FRE_AllowDeclineRace

[Prefs]FRE_DeclineRaceText

N/A

Not Allowed in CT State Reporting

Federal Race Category New/Edit

Code

Enter the federal race category code.

[Gen]Name

[Gen]Cat=federalrace

1

SASID

CRDC

Description

Enter the federal race category description.

[Gen]Value

[Gen]Cat=federalrace

N/A

SASID

CRDC

Sort Order

When you click Submit, the Federal Ethnicity and Race Settings page appear. Enter a sort order for the federal race category.

[Gen]SortOrder

[Gen]Cat=federalrace

N/A

SASID

Code

Enter the ethnicity code.

For code values, see the Appendix.

[Gen]Cat=ethnicity

[Gen]Value

2

Not used in any reports

Description

Enter the ethnicity description.

[Gen]Cat=ethnicity

[Gen]Name

Max 50

Not used in any reports

Name

Enter the name of the ELL test in this field. You must create one test record for each of the following state-required tests: Listening, Speaking, Reading, Writing, and Comprehension.

[Test]Name

N/A

ELL

Type

Choose State if for ELL tests.

[Test]Test_Type

N/A

ELL

Description

Enter a description of the test. When you click Submit, the Test page reappears, with a link to Edit Scores.

[Test]Description

N/A

ELL

Test > Edit Scores

Define the scale score and raw score for each ELL test required by the state: Listening, Speaking, Reading, Writing, and Comprehension.

Name

Enter the name of the score. For each ELL test, create two records: Scale Score and Raw Score.

[TestScore]Name

N/A

ELL

Sort Order

Enter the order to display this score on the data entry page.

[TestScore]SortOrder

N/A

ELL

Description

Enter a description of this score.

[TestScore]Description

N/A

ELL

Listening Scale Test

Choose the test used to record listening scale scores for students.

[Prefs]Value where [Prefs]Name=ELL_Listen

N/A

ELL

Speaking Scale Test

Choose the test used to record speaking scale scores for students.

[Prefs]Value where [Prefs]Name=ELL_Speak

N/A

ELL

Reading Scale Test

Choose the test used to record reading scale scores for students.

[Prefs]Value where [Prefs]Name=ELL_Reading

N/A

ELL

Writing Scale Test

Choose the test used to record writing scale scores for students.

[Prefs]Value where [Prefs]Name=ELL_Writing

N/A

ELL

Comprehension Scale Test

Choose the test used to record comprehension scale scores for students.

[Prefs]Value where [Prefs]Name=ELL_Comp

N/A

ELL

Initial Incident ID Number

Enter the number used to start the sequence of incident IDs.

Note: You must reset this value to 1 at the beginning of each year to reset the counter before entering any discipline incidents for that year.

You can use the Generate Id button to create a local incident number when creating incidents for a student. This setup ensures that incident IDs are generated in sequential order and are not repeated. Incidents are created for students via Start Page > Student > Log Entries.

[Prefs]Value where [Prefs]Name=CT_Initial_IncidentID

6

ED166

File to Import

Click Browse to select the path and name of the file you want to import. The file must be in comma-delimited format.

Note: These changes are permanent. It is recommended to back up your data prior to importing the state incident number file. Verify the data in the file is valid before importing.

Click Import to begin the import process.

N/A

N/A

N/A

Please select a Graduation Set to Map

Choose a graduation set

[Schools]CT_Grad_Set_Num

N/A

ED504 deprecated report

English

Choose a requirement to map to English.

[Schools]CT_Sub_Eng

N/A

ED504 deprecated report

Mathematics

Choose a requirement to map to Mathematics.

[Schools]CT_Sub_Math

N/A

ED504 deprecated report

Social Studies

Choose a requirement to map to Social Studies.

[Schools]CT_Sub_SS

N/A

ED504 deprecated report

Science

Choose a requirement to map to Science.

[Schools]CT_Sub_Sci

N/A

ED504 deprecated report

World Language

Choose a requirement to map to World Language.

[Schools]CT_Sub_WL

N/A

ED504 deprecated report

The Arts

Choose a requirement to map to The Arts.

[Schools]CT_Sub_Art

N/A

ED504 deprecated report

Vocational ED

Choose a requirement to map to Vocational Ed.

[Schools]CT_Sub_Vocat

N/A

ED504 deprecated report

Arts/Vocational ED

Choose a requirement to map to Arts/Vocational Ed.

[Schools]CT_Sub_AV

N/A

ED504 deprecated report

Physical Ed

Choose a requirement to map to Physical Ed.

[Schools]CT_Sub_Phys

N/A

ED504 deprecated report

Health

Choose a requirement to map to Health.

[Schools]CT_Sub_Heal

N/A

ED504 deprecated report

Community Service

Choose a requirement to map to Community Service.

[Schools]CT_Sub_CS

N/A

ED504 deprecated report

Other

Choose a requirement to map to Other.

[Schools]CT_Sub_Other

N/A

ED504 deprecated report

Electives

Choose a requirement to map to Electives.

[Schools]CT_Sub_Elect

N/A

ED504 deprecated report

Outcome Status

Click the edit (pencil) icon for the grade and in the dialog that appears, select an Outcome Status.

[S_CT_GSI_X]TCSGradeStatus

10

Teacher Course Student (TCS)

Data Element

Additional Information

[Table]FieldName

Length

Used in these Reports

In-Person

Radio button

[S_InstructionModeByGrades_S] InstructionMode

3

Learning Model and Enrollment Data Collection (weekly)

Hybrid

Radio button

[S_InstructionModeByGrades_S] InstructionMode

3

Learning Model and Enrollment Data Collection (weekly)

Remote

Radio button

[S_InstructionModeByGrades_S] InstructionMode

3

Learning Model and Enrollment Data Collection (weekly)

Data Element

Description

[Table]FieldName

Length

Code set

Select the Code set type.

[CODESET]CODETYPE=EntryCode

Code

Enter the entry code.

[CODESET]Code

2

Display Value

Enter the code display value.

[CODESET]DisplayValue

Description

Enter the entry code description.

[CODESET]Description

N/A

Sort Order

Enter a sort order to determine where the code displays on the page.

[CODESET] UIDisplayOrder

N/A

Start Date

Enter a start date to activate this code.

[CODESET]EffectiveStartDate

8

End Date

Enter an end date to inactivate this code.

[CODESET]EffectiveEndDate

8

Data Element

Description

[Table]FieldName

Length

Code set

Select the Code set type.

[CODESET]CODETYPE=ExitCode

Code

Enter the exit code.

[CODESET]Code

2

Display Value

Enter the code display value.

[CODESET]DisplayValue

Description

Enter the exit code meaning.

[CODESET]Description

N/A

Sort Order

Enter a sort order to determine where the code displays on the page.

[CODESET] UIDisplayOrder

N/A

Start Date

Enter a start date to activate this code.

[CODESET]EffectiveStartDate

8

End Date

Enter an end date to inactivate this code.

[CODESET]EffectiveEndDate8

8

Relationship

Click the edit (pencil) icon for the relationship code and in the dialog that appears, enter a reported value.

Note: Valid Parent Type codes

[CodeSet]ReportedValue

Record Type

Record type can be one of the following:

Mother, Father, Guardian

[s_ct_guardianmapping_s]RecordType

Parent Name

[Table]FieldName from which this field is to be extracted in the student Contact report

[s_ct_guardianmapping_s]ParentName

Parent Type

Parent type can be one of the following:

M, F, LG

[s_ct_guardianmapping_s]ParentType

Student Code

The state student number.[Table]FieldName from which this field is to be extracted in the student Contact report

[s_ct_guardianmapping_s]StudentCode

Email

Student's email address.[Table]FieldName from which this field is to be extracted in the student Contact report

[s_ct_guardianmapping_s]Email

Address

Student's mailing address.[Table]FieldName from which this field is to be extracted in the student Contact report

[s_ct_guardianmapping_s]Address

City

Student's city.[Table]FieldName from which this field is to be extracted in the student Contact report

[s_ct_guardianmapping_s]City

State

Student's state.[Table]FieldName from which this field is to be extracted in the student Contact report

[s_ct_guardianmapping_s]State

ZipCode

Student's zipcode.[Table]FieldName from which this field is to be extracted in the student Contact report

[s_ct_guardianmapping_s]Zipcode

Home Phone

Student's home phone number.[Table]FieldName from which this field is to be extracted in the student Contact report

[s_ct_guardianmapping_s]HomePhone

Work Phone

Student's mother's work phone.[Table]FieldName from which this field is to be extracted in the student Contact report

[s_ct_guardianmapping_s]WorkPhone

Cell Phone

Student's mobile phone number. [Table]FieldName from which this field is to be extracted in the student Contact report

[s_ct_guardianmapping_s]CellPhone

Language

Native language.[Table]FieldName from which this field is to be extracted in the student Contact report

[s_ct_guardianmapping_s]GuardianLanguage

Student Lives Here

This flag indicates that the student lives here. [Table]FieldName from which this field is to be extracted in the student Contact report

[s_ct_guardianmapping_s]StudentLivesHere

Can receive parent portal notifications

The guardian can receive parent portal notifications. [Table]FieldName from which this field is to be extracted in the student Contact report

[s_ct_guardianmapping_s]ParentNotifications