skip to main content

Central Union High School District

Committed to Excellence
QUICK LINKS & RESOURCES
CALENDAR
CALENDAR
NUTRITION SERVICES
FOOD SERVICES
DIRECTORY
DIRECTORY
FRONTLINE
FRONTLINE
AERIES
AERIES
CALPADS
CALPADS

Feeder Schools Data Request

The current information has the intention of providing as much resources to our feeder schools in order to make it easier to gather the incoming freshmen data we request each year to optimize the enrollment process in our High Schools. We appreciate your responses, time and effort, and we want to assist you as much as possible. 
 
Because not all of us use the same Student Information System (SIS), we understand the process to gather the data is not the same and in some cases it might be more complicated than others, please let me know if I can assist you in any way.
 
Gerardo A Mora
gmora@cuhsd.net
(760) 336-4521
 
Thank you.
The data template include the following tabs:
 
a sample image with some Microsoft Excel tabs showing
 
  • 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

Aeries

If you use Aeries, the following queries should work with no problems.  Queries are provided to be ran in SQL (not in Aeries Query directly) and should be ran by a person who is comfortable doing so.  They require no expertise and are not changing any data in your system.
Aeries SQL Statements (2018)

Aeries SQL Statements (2018)

Demographics

*Might require some adjustments for 2019.
  • 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'

English & CELDT

  • 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'