...
To generate a report on student sociodemographic information, use the following query. This requires data from the apply__application_vw and apply__personal_information_vw tables.
Figure 7: apply_personal_infromationInformation_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 8: apply_personal_sociodemographic_vw View
app_id | source | ccc_id | tstmp_create | field | value |
119389 | bogfw_application | ABS2569 | 28:30.7 | married_or_rdp | y |
119389 | bogfw_application | ABS2569 | 28:30.7 | homeless_youth_school | y |
119389 | bogfw_application | ABS2569 | 28:30.7 | cert_national_guard | y |
119389 | bogfw_application | ABS2569 | 28:30.7 | marital_status | M |
119389 | bogfw_application | ABS2569 | 28:30.7 | homeless_youth_other | y |
119389 | bogfw_application | ABS2569 | 28:30.7 | elig_police_fire | y |
119389 | bogfw_application | ABS2569 | 28:30.7 | parents_deceased | y |
119389 | bogfw_application | ABS2569 | 28:30.7 | reg_dom_partner | y |
119389 | bogfw_application | ABS2569 | 28:30.7 | us_veteran | y |
119389 | bogfw_application | ABS2569 | 28:30.7 | parents_assistance | y |
Figure 8: apply_personal_sociodemographic View
By querying these tables, researchers can access attributes related to a student's sociodemographic status. For example, to determine how many students indicated they were married when completing their application, use the following query.
Figure 910: Marriage Information Query
...
This query returns the following results:
Figure 1011: Query Results
ABU2416 | married_or_rdp | |
ABU6245 | married_or_rdp | n |
ABU6245 | married_or_rdp | n |
ABU6245 | married_or_rdp | n |
ABU6245 | married_or_rdp | n |
ABU6903 | married_or_rdp | n |
ABU6903 | married_or_rdp | n |
ABU3934 | married_or_rdp | n |
ABU3934 | married_or_rdp | n |
...