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
- Data process infographic
- Data Request Flyer
- Student Demographic/Testing/Program Data File Template (.XLSX)
- 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'