sasixp:cte_queries
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | |||
|
sasixp:cte_queries [2016/05/16 10:36] jlester removed |
— (current) | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ==== Queries to Check CTE Accuracy ==== | ||
| - | |||
| - | These queries ALL assume that all the CTE courses are accurately marked with career families in the course atom. | ||
| - | |||
| - | === Blank CTE Family Queries === | ||
| - | |||
| - | For these two queries, check both the "show inactive records" | ||
| - | |||
| - | |||
| - | DISPLAY ASTU ACLS AMST ACRS AVOC Status Permnum LN FN Course Title IF | ||
| - | StateCrs2 <> " " AND CipNo = " " AND Status <> " | ||
| - | |||
| - | |||
| - | DISPLAY ASTU ACLH ACRS AVOC Status Permnum LN FN Course Title IF | ||
| - | StateCrs2 <> " " AND CipNo = " " AND Status <> " | ||
| - | |||
| - | |||
| - | === CTE Fam List Queries === | ||
| - | |||
| - | These two list the CTE Fam that is currently marked in the vocational atom. It also shows the " | ||
| - | |||
| - | |||
| - | DISPLAY ASTU ACLS AMST ACRS AVOC Status PermNum LN FN Grade Gender Course Title | ||
| - | StateCrs2 CarTech Technical CipNo NonTrad SnglParent IF STatus <> " | ||
| - | " AND StateCrs2 <> " " | ||
| - | |||
| - | DISPLAY ASTU ACLH ACRS AVOC Status PermNum LN FN Grade Gender Course Title | ||
| - | StateCrs2 CarTech Technical CipNo NonTrad SnglParent IF Status <> " | ||
| - | " AND StateCrs2 <> " " | ||
| - | |||
| - | === Tips: === | ||
| - | - It is helpful to run both queries in each group and extract these to the same Excel spreadsheet. Sometimes someone may be currently taking a class, but also had taken a different class previously this year. | ||
| - | |||
| - | - Anything that is listed in a student' | ||
sasixp/cte_queries.1463409406.txt.gz · Last modified: 2016/05/16 10:36 by jlester
Page Tools
