This is a collection of queries related to Imports and Exports that have been obtained from various sources. These queries are being provided here for the convenience of our customers. The results of each query should be verified for accuracy and carefully considered before using.


List Queries

CTL:  List of Tests

Provides a list of tests including:  Test ID, Test Part, Test Title, Test Abbreviation, Test Grade


LIST CTL ID PT NM A1 GR BY ID PT

ELPAC:  List of Students, Language Fluency and Intifial Fluency

Lists all students with a Language Fluency of TBD and an Initial Fluency other than blank.


LIST STU LAC STU.TG STU.ID STU.LN STU.FN STU.GR STU.LF LAC.SD LAC.IFD LAC.ITF LAC.ITD IF STU.LF = "T" AND LAC.ITF # " "

('T' is the Language Fluency code for TBD - modify the query to use the Language Fluency codes.)

Change Queries

ELPAC:  Updating TBD to IFEP in Language Assessment (LAC)

After the list of TBD students is reviewed, update the IFEP Start Date (LAC.IFD) for the students that have been designated as IFEP


CHANGE STU LAC LAC.IFD TO LAC.ITD IF STU.LF = "T" AND LAC.ITF = "IFEP" AND LAC.ITD # NULL AND LAC.IFD = NULL

ELPAC:  Updating TBD to EL in Language Assesment (LAC)

After the list of TBD students is reviewed, update the Program Start Date (LAC.SD) for the students that have been designated EL in the Initial Fluency (LAC.ITF)


CHANGE STU LAC LAC.SD TO LAC.ITD IF STU.LF = "T" AND LAC.ITF = "EL" AND LAC.ITD # NULL AND LAC.SD = NULL

ELPAC:  List of Student Language Fluency, Grade and Language Assessment Data from ELPAC

Provides a list of the results in STU and LAC so that the data entry can be reviewed for accuracy


LIST STU LAC STU.TG STU.ID STU.NM STU.GR STU.LF LAC.SD LAC.IFD LAC.ITF LAC.ITD IF LAC.ITF # " "

ELPAC:  Updating TBD to EL in Language Fluency (STU)

After the Program Start Date (LAC.SD) for the students that have been designated EL in the Initial Fluency (LAC.ITF) has been updated, update the language fluency codes (STU.LF) based on the Initial Fluency (LAC.ITF) value. 


CHANGE STU LAC STU.LF TO "L" IF STU.LF = "T" AND LAC.ITF =  "EL" AND LAC.ITD # NULL

('L' is the district's language fluency code for EL - modify the queries to use the Language Fluency codes)

ELPAC:  Updating TBD to IFEP in Language Fluency (STU)

After the Program Start Date (LAC.SD) for the students that have been designated IFEP in the Initial Fluency (LAC.ITF) has been updated, update the language fluency codes (STU.LF) based on the Initial Fluency (LAC.ITF) value. 


CHANGE STU LAC STU.LF TO "I" IF STU.LF = "T" AND LAC.ITF =  "IFEP" AND LAC.ITD # NULL

('I' is the district's language fluency code for EL - modify the queries to use the Language Fluency codes)