{{tag>state_reporting fall_1 CALPADS ongoing_updates}}
======SELA Reconciliation======

===Step 1===
    * Log in to CALPADS
    * Go to **Reports > Extracts**
{{:state_reporting:sela_reconciliation1.png?nolink&500|}}

===Step 2===
From the Extracts page choose ODS Extracts under the Request CALPADS Files.
\\ {{:state_reporting:sela_reconciliation2.png?nolink&500|}}

===Step 3===
From the **Record Type** dropdown choose **Student English Language Acquisition Status ODS Download.**
\\ {{:state_reporting:sela_reconciliation3.png?nolink&500|}}

===Step 4===
Choose **Active Student** or Enter a Date Range and click **Request File.** 
\\ {{:state_reporting:sela_reconciliation4.png?nolink&500|}}

===Step 5===
Click **Return to Request Extract Files**
\\ {{:state_reporting:sela_reconciliation5.png?nolink&500|}}

===Step 6===
From **Retrieve CALPADS Files**, select **ODS Extracts**
\\ {{:state_reporting:sela_reconciliation6.png?nolink&500|}}

===Step 7===
Select the **SELA ODS File** Type from the **Extract Type** drop down. Then click **Apply Filter.**
\\ {{:state_reporting:sela_reconciliation7.png?nolink&500|}}

===Step 8===
Download File
\\ {{:state_reporting:sela_reconciliation8.png?nolink&500|}}

===Step 9===
Log into SchoolPathways, go under **Reports>State/Federal>CALPADS>Ongoing SSID Update**
\\ {{:state_reporting:sela_reconciliation9.png?nolink&500|}}

===Step 10===
On the right side of the page is a link that reads **Click here to load a SELA ODS Extract.** Click on it.
\\ {{:state_reporting:sela_reconciliation10.png?nolink&500|}}

===Step 11===
Choose the SELA ODS extract from your desktop and then **Load File**
\\ {{:state_reporting:sela_reconciliation11.png?nolink&500|}}

**Due to FERPA, THE NEXT FEW SCREEN SHOTS MAY NOT BE AS ACCURATE AS WHAT YOU WILL SEE WHEN THE SELA FILE IS LOADED. STUDENT NAMES HAVE BEEN REMOVED.**

===Step 12===
The system will load a comparison of the records from SP and CALPADS, the status and date will show.
\\ {{:state_reporting:sela_reconciliation12.png?nolink&500|}}

===Other Options===
After loading the file, the user can choose to only display mismatched records, this filter will be on the //upper-left side of the page.// Check the box and click **Update** to ONLY see mismatched records.

\\ {{:state_reporting:sela_reconciliation13.png?nolink&500|}}
\\
Mismatched Records will show in **Red** \\
{{:state_reporting:sela_reconciliation14.png?nolink&500|}}

===Step 13===
On the left-side of the page, check the box next to the students you wish to update.
\\ {{:state_reporting:sela_reconciliation15.png?nolink&200|}}

===Step 14===
Click **Load ELA Data from CALPADS** button at the top of the page.
\\ {{:state_reporting:sela_reconciliation16.png?nolink&200|}}

===Step 15===
Enter **CONFIRM** and hit the **Load ELA Data from CALPADS** button. Please be aware that this will override existing data for the student in the SIS.
\\ {{:state_reporting:sela_reconciliation17.png?nolink&500|}}

===Extra Feature===
The users can see the most recent SELA file load in the system from the **Ongoing Updates** Tab.
\\ {{:state_reporting:sela_reconciliation18.png?nolink&500|}}