Central Union High School District - Feeder Schools Data Request

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.

STUDENT Data Template

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

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)

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'

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'