eccbb139_Student_Term_Snapshot__Definition
[Field Name] Student_Definition_Code [Source] Derived from Sfbetrm_Ar_Ind, Sfrstcr_Rsts_Code, and Sgbstdn_Stst_Code [Comment] If(Sfbetrm_Ar_Ind='Y' or Sfbetrm_Ar_Ind='C' ) and Sfrstcr_Rsts_Code=('RE' or 'RW') then 'REGISTERED' else if (Sfbetrm_Ar_Ind<>'Y' or Sfbetrm_Ar_Ind<>'C' ) and Sfrstcr_Rsts_Code=('RE' or 'RW') then 'ENROLL ONLY' else if (Sfbetrm_Ar_Ind='Y' or Sfbetrm_Ar_Ind='C' ) and Sfrstcr_Rsts_Code<>('RE' or 'RW') then 'FEE ONLY' else if Sgbstdn_Stst_Code='P%' or Sgbstdn_Stst_Code='%P' or Sgbstdn_Stst_Code='S%' or Sgbstdn_Stst_Code='LV') and Sgbstdn_Stst_Code<>'CP' and Sgbstdn_Stst_Code<>'PW' and Sgbstdn_Stst_Code<>'WP' then 'PELP' else 'OTHER' [Definition] 
Indicates the student's fee and enrollment status
Student_Term_Snapshot
Definition