The School of Choice system requires the following actions to be completed before implementation:
- Update COD Table – many codes need to be defined
- School of Choice Options - page needs to be configured
- School of Choice Notification Emails - need to be configured for each scenario (Approved, Denied, etc.)
- Security Permissions - Permissions for Parents and Users need to be granted – including Field Level Security
School of Choice uses the following tables:
- SCR – School of Choice Requests
- SCD – School of Choice Decisions
- SCN – School of Choice Notes
Define Code Sets
Many codes need to be defined in the COD Table before the system can be implemented. Examples are provided below, but districts can choose to customize their own codes.
SCR Table - School of Choice Requests
SCR.RTW – School of Choice Window. One or multiple date range windows can be made available to parents. Only 1 window date range can be open at a time. There can be no overlapping dates on windows. Some examples of types of windows are Magnet Schools, Inter-District Transfers, Intra-District Transfers, or Children of District Employees.
SCR.SC1 – School of Choice 1st Choice. All schools that parents can request for the 1st choice need to be entered. The same school codes used in the LOC table must be used.
SCR.SC2 – School of Choice 2nd Choice. All schools that parents can request for the 2nd choice need to be entered. The same school codes used in the LOC table should be used. The 2nd choice schools can be different or the same as the 1st choice schools, but must still match LOC School codes.
*A SQL query can be used to copy the codes from SC1 to SC2 to eliminate the need to enter codes more than once.
SCR.ITS – Inter/Intra Code. Enter codes for Inter-District and Intra-District. The Amount (COD.N1) fields must be entered to define Inter-District and Intra-District codes. The Amount codes control options available to parents.
Note: If allowing Intra and Inter District Transfers: the Amount field in the COD table (COD.N1) fields must be entered as follows:
1.00 = Intra-District – Transfers within the same district
2.00 = Inter-District – Transfers from other school districts outside of the home district
SCR.ITN – New/Renewal Code. Enter a 1-character code value for New and Renewal codes for both Inter and Intra transfers. The Amount field (COD.N1) also needs to be entered to correspond with the Inter/Intra codes above. Multiple codes can be entered for Inter or Intra transfers.
SCR.ITD – Inter-District From. Enter the outside Districts that can be selected by the parents. All the neighboring districts should be entered. This field is for information only.
SCR.SIB – Sibling Status Code. Enter the sibling status. Examples below.
SCD Table – School of Choice Decisions
SCD.ITP – Inter-District Transfer Permit Status. Informational only, examples below:
SCD.SR – School Recommendations. Customizable to District Needs.
SCD.ST1 – Approval Status School 1
SCD.ST2 – Approval Status School 2
Note: Enter the values for the School 1 Approval Status and School 2 Approval Status. The Amount field in the COD table (COD.N1) field of 1 = Approved. The Code Sort Order fields can also be used to control the code sort order in the drop-down.
SCD.DNQ1 – DNQ – Did Not Qualify Reason School 1
SCD.DNQ2 – DNQ – Did Not Qualify Reason School 2
Enter the values for the DNQ Reason for School 1 and School 2. Examples are below.
SCD.LI – Lottery ID Informational field for now. Can be used to import random Lottery ID#s into this field.
*A SQL query can be used to copy the codes from ST1 to ST2 and DNQ1 to DNQ2 to eliminate the need to enter codes more than once.