DARTS : Term Count Comparison

# (COUNT)

UM_FULL_PART

The Alias B is UM_STUD_EXTRACT.

CASE
  WHEN B.Acad_Level_Bot = 'GR'  AND  B.Um_Unt_Tak_Prg_Rc >= 6 THEN 'Full-Time'
  WHEN B.Acad_Level_Bot = 'MAS'  AND  B.Um_Unt_Tak_Prg_Rc >= 6 THEN 'Full-Time'
  WHEN B.Acad_Level_Bot = 'PHD' AND B.Um_Unt_Tak_Prg_Rc >= 6 THEN 'Full-Time'
  WHEN B.Um_Unt_Tak_Prg_Rc >= 12 THEN 'Full-Time'
  ELSE 'Part-Time'
END

Case
when A.SEX ='M' then 'Male'
when A.SEX ='F' then 'Female'
else 'Unknown'  
end

UM_RESIDENCY_DESCR

The Alias B is UM_STUD_EXTRACT. (B.Residency is tuition residency from RESIDENCY_OFF table.)

DECODE(B.Residency,
              'IS', 'In-State',
              'OS', 'Out-of-State',
             'CAN', 'Canadian',
           'NEBHE', 'NEBHE',
           'INTNL', 'International',
           'ONLIN', 'Online',
           'MEONL', 'Academic Partnerships'
                    'Out-of-State'  )

UM_IN_OUT

The Alias B is UM_STUD_EXTRACT. (B.Residency is tuition residency from RESIDENCY_OFF table.) The alias QB is RESIDENCY_OFF table. (QB.Residency is residency.)

CASE
WHEN B.RESIDENCY = 'MEONL' AND QB.RESIDENCY = 'IS' THEN 'In-State'
WHEN B.Residency = 'IS' THEN 'In-State'
ELSE 'Out-of-State'
END 

UM_ETHNIC_GRP_DESC