Connecticut



SIF Crosswalk from PowerSchool to TCS

Record Layout

The following is a list of all the fields and guidance for completing each student record.

Requirements:

Mandatory - If this field is not complete, an error is generated.

Optional - Districts have the option to report this field or leave it blank.

Recommended - We recommend that this field be reported, but your district has the option to or leave it blank.

Conditional - This field may be required depending upon the response to a related field.

Disallowed - Districts may not report this field for this submission. This field is for display purposes only.

| |Field Name |Req'd. |Screen Name |Field Name |

|1 |SASID |M |Student > State/Province – CT |State Assigned Student ID |

|2 |Reporting District |M |District Office > District > District Info|District Number |

|3 |District Student ID |R |Student > Demographics |Student Number |

|4 |Date of Birth |M |Student > Demographics |DOB |

|5 |EIN |C |Staff > Information |StatePrId |

|6 |Teacher Type |M |Staff > Information |Teacher Type |

|7 |District Teacher ID |R |Staff > Information |ID |

|8 |Course Facility Code |M |District Office > District > Schools / |StatePrId of the school that the course if|

| | | |SchoolInfo > Edit a School |taught at. |

|9 |NCES Course Code |M |District Office > District > Courses > |NCES Completed Course Code of Alternate |

| | | |Edit a Course |Course Number if NCES is not filled in. |

|10 |District Course Code |R |District Office > District > Courses > |Course Number |

| | | |Edit a Course | |

|11 |Section Code |M |Choose a School > School Setup > Sections|Section Number – Course Number |

| | | |> Edit a section | |

|12 |Outcome/Grade |M |Standard Grades |Standard Grades |

| | | |Student > Historical Grades > Choose the |The value of Grade and Percent will be |

| | | |grade under the Store Code that will be |published. The state will use Grade if it|

| | | |published |has a value and Percent if no Grade is |

| | | | |published. |

| | | | | |

| | | |Grade Level Outcome Grades |Grade Level Outcome Grades |

| | | |District Office > District > Schools / |TCS Outcome |

| | | |SchoolInfo > Edit a School > Grade Level | |

| | | |outcome Codes (TCS) | |

|13 |Facility Code 1 |M |2 Sources |The Facility Code 1 on the student’s |

| | | |Student > Transfer Info > Enrollment |enrollment record is an override and will |

| | | |District Office > District > Schools / |be used if present. Otherwise, the |

| | | |SchoolInfo > Edit a School |StatePrId field on the school record will |

| | | | |be used. |

|14 |Session Start Date |M |Choose a School > School Setup > Years & |The First Day of Term is used for the term|

| | | |Terms > Select Edit Terms for the year |that the section is being taught in. |

|15 |Session End Date |M |Choose a School > School Setup > Years & |The Last Day of Term is used for the term |

| | | |Terms > Select Edit Terms for the year |that the section is being taught in. |

|16 |Outcome/Grade Status |M |Standard Grades |Standard Grades |

| | | |District Office > District > TCS Grade |The value of Outcome Status will be used. |

| | | |Scale Status Mapper > Edit a Grade Scale |This is found by comparing the Grade Name |

| | | | |in the grade scale, to the value of the |

| | | | |Grade on the students Historical Grades |

| | | | |record. The Historical Grade store code |

| | | | |that is published is compared to what is |

| | | | |entered in District Office > District > |

| | | | |Schools / SchoolInfo > Edit a school > |

| | | | |Reporting Store Codes (TCS). The store |

| | | | |codes that are aligned with the correct |

| | | | |term for the course / section will be |

| | | | |published. Also, the grade scale listed |

| | | | |on the Historical Grades record is used to|

| | | | |obtain the correct match. |

| | | | | |

| | | | |Grade Level Outcome Grades |

| | | |Grade Level Outcome Grades |TCS Outcome Status |

| | | |District Office > District > Schools / | |

| | | |SchoolInfo > Edit a School > Grade Level | |

| | | |outcome Codes (TCS) | |

|17 |Course Credits Earned |C |Student > Historical Grades > Choose the |Earned credit hours will be published if |

| | | |grade under the Store Code that will be |Potential credit hours is greater than 0. |

| | | |published |Otherwise, nothing will be published. |

| | | | |This will always be null for grade level |

| | | | |outcomes. |

|18 |Number of Membership Sessions |R |Not currently supported. | |

|19 |Number of Membership Sessions Attended |R |Not currently supported. | |

|20 |Dual Enrollment Code |C |Choose a School > School Setup > Sections|Dual Enrollment Program Code |

| | | |> Edit a section | |

|21 |CSDE Use |D | | |

|22 |End Of Record Marker |M | | |

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download