Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

DW Field

Oracle Field/Calc

 DW Field

Description (Sample)

Data Type(field length)

Allows Nulls Checkbox

TERM

Insert excerpt
Common Definitions
Common Definitions
nameTERM
nopaneltrue

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

...