...
To generate a report on student sociodemographic information, use the following query.
Figure 7: Example Query
| Code Block |
|---|
SELECT ccc_id,max(value) as hs_edu_level
FROM apply__application_vw ca
LEFT JOIN apply__education_vw cae
ON (ca.app_id = cae.app_id)
WHERE ca.source = 'stnd_application'
AND cae.field = 'hs_edu_level'
and ca.tstmp_create > '2025-01-01' group by ccc_id; |
This requires data from the apply__application_vw and apply__personal_information_vw tables.
Figure 78: apply_personal_Information_vw view
app_id | source | ccc_id | lastname | firstname | middlename | tstmp_update |
855357 | bogfw_application | ABU2416 | Kimmy | Pamy | 46:12.1 | |
855456 | bogfw_application | ABU3934 | Walsh | Esme | Shanon | 48:24.7 |
855588 | bogfw_application | ABU6936 | sreetest | suvtest | 07:16.8 | |
855555 | bogfw_application | ABU6903 | sreetester | Suvtester | 52:16.4 | |
855489 | bogfw_application | ABU6244 | Sreetester | Suvatester | 01:14.6 | |
855522 | bogfw_application | ABU6245 | sreetest123 | suvtest12 | 17:02.4 | |
855786 | bogfw_application | ABU6244 | Sreetester | Suvatester | 38:28.9 | |
855852 | bogfw_application | ABU6245 | sreetest123 | suvtest12 | 50:40.4 | |
855753 | bogfw_application | ABU6245 | sreetest123 | suvtest12 | 27:13.1 | |
855423 | bogfw_application | ABU3934 | Walsh | Esme | Shanon | 44:48.3 |
Figure 89: apply_personal_sociodemographic_vw View
...