Skip to main content

Central Union High School District

Committed to Excellence

Feeder Schools Data

Incoming Freshmen Data Resources for Feeder Schools

 

The information provided is intended to support our feeder schools in collecting the incoming freshman data required each year to ensure a smooth and efficient high school enrollment process. We sincerely appreciate your time, effort, and collaboration, and remain committed to assisting you throughout this process.

We recognize that not all schools utilize the same Student Information System (SIS), and therefore, data collection procedures may vary in complexity. Should you require any clarification or support, please do not hesitate to contact our office for assistance.

 

Contact Information:

Gerardo A Mora

gmora@mycuhsd.org

(760) 336-4521

STUDENT Data Template

A screenshot of a data table with headers for Data Guide, Demographics, SBAC (CAASPP), ELPAC, Migrant Program Enrollment, and a red row with the text 'D' and 'Blank'.

  • Data Guide: A description of the required fields and some notes
  • Demographics: Our most important data source, general demographic data
  • SBAC (CAASPP): Most current test scores request for CAASPP
  • ELPAC: Same as above, for ELPAC
  • Migrant Program Enrollment: If available, just ID and start and end dates

Aeries

  • If your school utilizes Aeries, the following queries should function without issue. These queries are designed to be executed in SQL (rather than directly within Aeries Query) and should be run by an individual familiar with this process. Please note that the queries do not modify or alter any data within your system and require no advanced technical expertise to perform.

Helpful Aeries SQL Statements

  • *Might require some adjustments for 2020.

    • You can download this file here.

    --Demograhic Data pull - Aeries

    SELECT

    ''                 as '(blank [Checkmarks])',
    STU.LS        as 'School',
    ''                 as '(blank [Student Tag])',
    STU.LN        as 'Last Name',
    STU.FN        as 'First Name',
    STU.MN       as 'Middle Name',
    ''            as '(blank [School Year])',
    STU.GR        as 'Grade',
    STU.SX        as 'Gender',
    STU.CID        as 'State ID',
    STU.BD        as 'Birth Date',
    STU.BCY        as 'Birth City',
    STU.BST        as 'Birth State',
    STU.BCU        as 'Birth Country',
    STU.HL        as 'Home Language',
    STU.ETH        as 'Ethcnicity',
    STU.RC1        as 'Race',
    ''            as '(blank [U13 Tag])',
    STU.RAD        as 'Residence Address',
    STU.RCY        as 'Residence City',
    STU.RST        as 'Residence State',
    STU.RZC        as 'Residence Zip Code',
    STU.AD        as 'Mailing Address',
    STU.CY        as 'Mailing City',
    STU.ST        as 'Mailing State',
    STU.ZC        as 'Mailing Zip Code',
    STU.TL        as 'Home Phone Number',
    STU.FW        as 'Parent Work Phone Number',
    STU.PG        as 'Parent or Guardian Name',
    STU.PED        as 'Parent Education Level',
    STU.LF        as 'Language Fluency'

    FROM STU
    WHERE STU.GR = '8'

    • You can download this file here.

    --CELDT / English Data Pull

    --First, we take the CELDT Data from the TST table, only 8th Grade ***

    CREATE TABLE #CELDT (
    STCID varchar(10),
    STID int,
    TID varchar(8),
    TPT smallint,
    TGR smallint,
    TRS smallint,
    TSS smallint,
    TTD    datetime,
    TOT smallint)

    INSERT INTO #CELDT
    SELECT STU.CID, TST.PID, TST.ID, TST.PT, TST.GR, TST.RS, TST.SS, TST.TD, TST.OT
    FROM STU INNER JOIN TST ON STU.ID = TST.PID
    WHERE TST.ID = 'CELDT' AND STU.GR = '8'

    --Now, we pull the data as required ***

    SELECT

    STU.CID        as 'State Id',
    STU.LN        as 'Last Name',
    STU.FN        as 'First Name',
    STU.MN        as 'Middle Name',
    STU.BD        as 'Birth Date',
    LAC.USS        as 'US School Entry Date',
    LAC.STS        as 'CA School Entry Date',
    LAC.LD        as 'Current Language Designation',
    STU.LF        as 'Language Fluency',
    STU.HL        as 'Home Language',
    LAC.SD        as 'Program Start Date [L]',
    LAC.ED        as 'Program End Date [L]',
    LAC.RD1        as 'ReDes Start Date [R]',
    LAC.LT        as 'Long Term EL',
    LAC.YEL        as 'Years EL',
    #CELDT.TTD            as 'CELDT Test Date',
    #CELDT.TPT            as 'CELDT Test Part',
    #CELDT.TGR            as 'CELDT Grade Test Taken',
    #CELDT.TRS            as 'CELDT Test Raw Score',
    #CELDT.TSS            as 'CELDT Test Scale Score',
    #CELDT.TOT            as 'CELDT Test Proficency Level'

    FROM STU INNER JOIN LAC ON STU.ID = LAC.ID
             LEFT JOIN #CELDT ON STU.ID = #CELDT.STID

    WHERE STU.GR = '8' AND #CELDT.TPT = '0'