Greenwood School District 50

SASIxp Help Files

 

Setting Precode Default Values

2004-2005

Revised 9/13/04

 

Precode items that are left blank will generate an error message during the extraction process; thus, setting default values for each school will greatly reduce the problem with blank Precode data.  Prior to schools’ data entry for Precode, queries can be run at each school to set default values for each required Precode item.  With the defaults set, school staff will be required to enter only the exceptions to the defaults.

 

The following steps will generate the default Precode values.  These steps must be completed in each school’s SASIxp database, not in the mirror files on the district server.

 

Updating the Precode Data Items at the School

  1. Be sure that the new Precode template files have been pushed out to each school.
  2. Log into the school’s SASIxp database with administrator or other appropriate rights.
  3. Go to the Enrollment module.
  4. Click the link arrow to EFA/EIA Info.
  5. Click the PreCode Entry tab.
  6. Click EFA/EIA Info on the menu bar at the top of the SASIxp window.
  7. Click Update PreCode Data Items from the drop-down menu.
  8. Click Continue in the warning box.
  9. Note progress on the scale at the bottom left of the SASIxp screen.  This will take several minutes.
  10. Note the number of records that were affected.
  11. Check a few students.  Be sure line 6 has “APM:  Applied Mathematics” (this ensures that you are using the latest template).
  12. Close all open windows on the SASIxp desktop (do not exit SASIxp).
  13. Additional information may be available at <http://www.gwd50.k12.sc.us/SASI-Web/SASI-PrecodeUpdate.htm>.

 

Setting the Default Values for Each Student

  1. Run the following query to set ESL status on Student screen 1:

a.       Do not run this query if you have already entered data for ESL status.

b.       CHANGE ASTU EngProf=”9”

  1. Do NOT set default values for MEALS (Lunch Status).
  2. Do NOT set default values for MIGRANT status.
  3. Prior to running the queries in this section, you must run the Import/Export process defined by SDE to create student records in USCF (http://www.myscschools.com/offices/technology/dts/sasi/Creating_USC-_records.doc).  If you do not run this process, the following queries will generate incomplete results.  Run the following queries to set the defaults for the SC Student Supplemental Data items (in USCF) to sort by the same teacher number you have in the Advisor field on Page 1 in the Student file (ASTU):

a.       CHANGE ASTU USCF ELAS= Advisor

b.       CHANGE ASTU USCF MathS= Advisor

c.       CHANGE ASTU USCF ScienceS=Advisor

d.       CHANGE ASTU USCF SocialS=Advisor

e.       CHANGE USCF AltSchProg=” “

f.         CHANGE USCF Plan504=” “

g.       CHANGE USCF NineGR=” 0”

  1. Run the following queries to set the defaults for each of the required Precode items (in SSCE):

a.       CHANGE SSCE Value=”N” IF PreCode=”APM”

b.       CHANGE SSCE Value=”N” IF PreCode=”APC”

c.       CHANGE SSCE Value=”N” IF PreCode=”APS”

d.       CHANGE SSCE Value=”0” IF PreCode=”AA”

e.       CHANGE SSCE Value=”0” IF PreCode=”PML”

f.         CHANGE SSCE Value=”0” IF PreCode=”CTL”

g.       CHANGE SSCE Value=”0” IF PreCode=”PMM”

h.       CHANGE SSCE Value=”0” IF PreCode=”CTM”

i.         CHANGE SSCE Value=”0” IF PreCode=”PMS”

j.         CHANGE SSCE Value=”0” IF PreCode=”CTS”

k.       CHANGE SSCE Value=”0” IF PreCode=”PMT”

l.         CHANGE SSCE Value=”0” IF PreCode=”CTT”

m.     CHANGE SSCE Value=”0” IF PreCode=”HSP”

n.       CHANGE SSCE Value=”N” IF PreCode=”BXR”

a.       CHANGE SSCE Value=”N” IF PreCode=”BXW”

b.       CHANGE SSCE Value=”N” IF PreCode=”BXM”

c.       CHANGE SSCE Value=”NA” IF PreCode=”KDR”

d.       CHANGE SSCE Value=”N” IF PreCode=”DB”

e.       CHANGE SSCE Value=”N” IF PreCode=”MD”

f.         In items d through m, above, use ZERO – not the letter “O”

  1. The queries listed in #5 above can be consolidated into the following queries; use the following queries instead of those in #5:

a.       CHANGE SSCE Value=”N” IF PreCode=”APM” Or PreCode=”APC” Or PreCode=”APS” Or PreCode=”BXR” Or PreCode=”BXW” Or PreCode=”BXM” Or PreCode=”DB” Or PreCode=”MD”

b.       CHANGE SSCE Value=”0” IF PreCode=”AA” Or PreCode=”PML” Or PreCode=”CTL” Or PreCode=”PMM” Or PreCode=”CTM” Or PreCode=”PMS” Or PreCode=”CTS” Or PreCode=”PMT” Or PreCode=”CTT” Or PreCode=”HSP”

c.       CHANGE SSCE Value=”NA” IF PreCode=”KDR”

 

Entering Precode Values

To complete the Precode data entry process, follow the steps at this link: 

<http://www.gwd50.k12.sc.us/SASI-Web/SASI-PrecodeEnter.htm>.