New Student

Source: Banner

Role: Newstudent

Type: role

Definition: A full time, undergrad, active,  new or provisional student who is a new admit starting in the fall

SQL:

select 'Y'
FROM SGBSTDN a, spriden b
where b.spriden_id = p_id
and b.spriden_change_ind is null
and a.sgbstdn_pidm = b.spriden_pidm
and a.SGBSTDN_TERM_CODE_ADMIT = v_fall_term
AND a.SGBSTDN_LEVL_CODE = 'UG'
AND a.SGBSTDN_STST_CODE = 'AS'
AND a.SGBSTDN_STYP_CODE IN ('N', 'P')
AND a.SGBSTDN_ADMT_CODE = 'N'
AND a.SGBSTDN_FULL_PART_IND = 'F';