The TST part names for the SBAC and CELDT tests are in the CTL table. This query can be used to list the CAASPP ELA and Math test results with their part names (sorted by student name, test taken date, part):
LIST STU IDN TST CTL STU.ID STU.LN STU.FN STU.GR TST.ID TST.PT CTL.NM TST.SS TST.PL TST.TD TST.TA BY STU.LN STU.FN TST.TD TST.PT IF TST.ID = "SBAC" AND ( TST.PT = 1 OR TST.PT = 2 )This query can be used to list the CELDT test results with their part names (sorted by student name, test taken date, part):
LIST STU IDN TST CTL STU.ID STU.LN STU.FN STU.GR TST.ID TST.PT CTL.NM TST.SS TST.OT TST.TD TST.TA BY STU.LN STU.FN TST.TD TST.PT IF TST.ID = "CELDT"
Both queries may require more limitations in the condition portion of the query depending on what you are trying to report.
To get a list of the CAASPP ELA and Math Claims from the CST table along with their part names you can use this query (sorted by student name, test taken date, and part):
LIST STU IDN CST CSN STU.ID STU.LN STU.FN STU.GR CST.ID CST.PT CSN.NM CST.RS CST.TD CST.TA BY STU.LN STU.FN CST.TD CST.PT IF CST.ID : "SBAC"