- Departments
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@mycuhsd.org
(760) 336-4521
Thank you.
The data template include the following tabs:
- 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 (2020)
--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'
Aeries SQL Statements (2020)
Demographics
*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'
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.
--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'