vM_StuAttributes

TERM

STUDENTID

LASTNAME

FIRSTNAME

MIDINIT

STUDENTNAME

SEMESTER

AGE

AGEATTERM

GENDER

PIDM

STATUS

PROGRAM

MAJOR_CODE

MAJOR

GOAL

GOAL_INFORMED_EFF_TERM

GOAL_INFORMED_CODES

CENSUSAGEGROUP

MARITAL_CODE

HIGHSCHOOL

ENG251_ELIG

ENG_TEST_DATE

MATHPLACE

MATH_TEST_DATE

READLEVEL

READ_TEST_DATE

CELSA_ESL

ESL_TEST_DATE

ESL_PLACEMENT

EOPS

DRC

DRC_codes

VATEA

PUENTE

Cohort_codes

REGISTERED_CLASSES

CAMPUSES

ACTIVITY_DATE

CAST_CODE

VISA_TYPE

CALWORKS

VETERAN

REGIS_APPT

ATHLETE

WIA

PELL

DEPENDENT

ED_PLAN_DATE

ED_LEVEL_CODE

ORIENTATION

AP_CALCAB_SCORE

AP_CALCBC_SCORE

AP_STATS_SCORE

AP_LANGCOMP_SCORE

AP_LITCOMP_SCORE

FOSTER_YOUTH

BASIC_SKILLS

EOPS_CARE

HS_STATUS

RACE_ETHN_CDE_DESC as [Race/Ethnicity]

CAREER_ADVACAD

FIN_AID_IND_BY_MJR

CTE_IND_BY_MJR

DEAN_PRES_CODE

DEANS_PRES_DESC

RESD_CODE

RESD_DESC

CAA

TRIO

PARENT_EDLV_1_CODE

PARENT_EDLV_1_DESC

PARENT_EDLV_2_CODE

PARENT_EDLV_2_DESC

PROG_DEPT

PROG_GE_PATTERN

dbo.F_GET_Max_PARENT_ED_LVL(st.PARENT_EDLV_1_CODE, st.PARENT_EDLV_2_CODE) as Highest_Parent_Ed_lvl

dbo.F_Is_FirstGen(dbo.F_GET_Max_PARENT_ED_LVL(st.PARENT_EDLV_1_CODE, st.PARENT_EDLV_2_CODE)) as First_Generation

CASE WHEN sc.Cohort_Code = 'SSP' THEN 'Y' ELSE 'N' END as SSP

CIPC_Code as Major_CIPC_Code

TOP_Code as Major_TOP_Code