Oracle Field/Calc
| DW Field | Description (Sample) | Data Type(field length) | Allows Nulls Checkbox |
---|---|---|---|---|
Error rendering macro 'excerpt-include' : No location was provided. | ||||
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 |
TERM fed from STVTERM
General
Content
Integrations
Add Comment