Transfer

Source: Banner

Type: package/procedure (szkmbsc.P_Get_Xfers_by_Term(?, ?))

Definition: Provisional or transfer student type, undergrad, active student, admit type transfer, not NACE or NACT, whose admit term matches the provided term code

SQL:

select gzbpius.gzbpius_primary_userid puid
from sgbstdn,gzbpius
where sgbstdn_term_code_eff = i_term
and sgbstdn_styp_code in ('P','T')
and sgbstdn_levl_code = 'UG'
and sgbstdn_stst_code = 'AS'
and sgbstdn_term_code_admit = i_term
and sgbstdn_admt_code = 'T'
and sgbstdn_majr_code_1 not in ('NACE','NACT')
and gzbpius_pidm = sgbstdn_pidm;