...
Expand | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
“You should answer the gender question based on the gender with which you identify, which may or may not be the sex you were assigned at birth. Gender Identity is a separate, optional question intended to draw out additional layers of student body diversity, including diverse perspectives from applicants who have experienced major life events or transitions related to their gender identity.” In AMCAS, the reference table for this past 2024 season has the following values: Code: SELECT * FROM AmcasDES.amcas.REFERENCE_Gender WHERE APPL_YEAR = 2024 ORDER BY DISPLAY_SEQ The 2024 applicant data also has a "sex" column: Code: SELECT sex,COUNT(*) AS cnt FROM [AmcasDES].[amcas].[AMCAS_Applicant] WHERE app_year = 2024 GROUP BY sex ORDER BY cnt desc I also see 2024 applicant data on gender identity. I'm currently ignoring this data in terms of SIS and Stuart: Code: SELECT gender_identity_code,gender_identity,COUNT(*) AS cnt FROM [AmcasDES].[amcas].[ApplicantPersonalInfo] WHERE app_year=2024 GROUP BY gender_identity_code,gender_identity ORDER BY COUNT(*) desc
For interfacing with SIS, the SQL view uses these values: O, U, M, F, U CASE WHEN vw.GENDER = 'Another Gender' THEN 'O' WHEN vw.GENDER = 'Decline to Answer' THEN 'U' WHEN vw.GENDER = 'Man' THEN 'M' WHEN vw.GENDER = 'Woman' THEN 'F' ELSE 'U' END AS SEX And lastly, Stuart supports these values currently, though Bruce suspects this will change very soon: Code: SELECT DISTINCT sex, gender.Gender FROM student st INNER JOIN register re ON re.StudentKey = st.StudentKey LEFT JOIN gender ON gender.GenderCode = st.Sex WHERE re.RegType = 'DegreeProgram' AND sex IS NOT null
|
Expand | ||
---|---|---|
| ||
Dental is unusual in that there is no automation from the 3 CAS systems (PASS) and the local Qualtrics application; Mario does a data upload to SIS. |
Summary sheet of all incoming admissions data
...