Student_Term_Snapshot Table

Field Name Source Definition Comment
Acad_Class_Code A Calculation Based on Level, Completed Units, Completed Terms, and Advanced to Candidacy Dates Represents the academic class of the student. Different variables are used to calculate class for the different academic levels. Derived using the SGKCLAS function in Banner.
Acad_Level_Code Sgbstdn_Levl_Code The primary academic level of the student which is used to determine fees  
Acad_Standing_Code Sgbstdn_Astd_Code, Shrttrm_Astd_Code_End_of_Term A code representing the academic standing of the student For snapshots taken prior to the 8/29/2003, the column was populated solely from Sgbstdn_Astd_Code. As of 8/29/2003, the logic is: If Sgbstdn_Astd_Code is null, then Shrttrm_Astd_Code_End_of_Term from max(Shrttrm_Term_Code), else Sgbstdn_Astd_Code
Acad_Term_Code Sgbstdn_Term_Code_Eff The term in which the person is a student  
Activity_Wh_Num Calculated from Sgbstdn_Term_Code_Eff Calculated field related to the Acad_Term_Code  
Ar_Code Sfbetrm_Ar_Ind A code representing the fee status of a student (Y=Yes, C=Confirmed, N=No)  
Campus_Code If Sgbstdn_Camp_Code > "99" then Sgbstdn_Camp_Code else Null A code representing the campus where the student's primary coursework is located  
Citizenship_Status_Code Spbpers_Citz_Code A code indicating the citizenship status of a student  
Dept_Code Sgbstdn_Dept_Code A code representing the department associated with the student's primary major in the Banner student information system  
Dept2_Code Sgbstdn_Dept_Code_1_2 A code representing the department associated with the student's secondary major within the primary course of study in the Banner student information system  
Dept3_Code Sgbstdn_Dept_Code_2 A code representing the department associated with the student's primary major within the secondary course of study in the Banner student information system  
Dept4_Code Sgbstdn_Dept_Code_2_2 A code representing the department associated with the student's secondary major within the secondary course of study in the Banner student information system  
Enrol_Status_Code Sfbetrm_Ests_Code The enrollment status code indicates whether a student is eligible to enroll in courses  
Fee_Rate_Code Sgbstdn_Rate_Code A code representing the fee rate for the student  
Fees_Paid_Date Sfbetrm_Fees_Paid_Date The date on which the student paid his or her fees  
Finaid_Satsfctry_Prog_Code Rorsapr_Sapr_Code A code indicating whether or not the student is making satisfactory progress to continue receiving financial aid (G=Making Satisfac Acad Progress, A=Deny - Ext Terms Exceeded, L=Deny - GPA Acad Yr Deficient, D=Deny - Unit Deficient, P=Appeal Granted (ob), W=Warning status GPA/Units(ob), M=Deny - GPA Cum Deficient, WMIN-D=Warning MinProgress Units, WCUM-M=Warn GPA Cumulative, WAYR-L=Warn GPA Acad Year, A-NL=Deny Ext Term No Letter, D-NL=Deny MinProg No Letter, L-NL=Deny AcadYr GPA No Letter, M-NL=Deny Cum GPA No Letter)  
Full_Part_Time_Code Sgbstdn_Full_Part_Ind A code indicating whether the student is part-time or full-time Because someone has to manually enter this information in Sgbstdn_Full_Part_Ind, it may not be reliable. You may be better off determining full/part-time status from the workload units in Course_Sect_Enrl or the Fee_Rate_Code in this table, depending on your needs. Contact end-user support for more information.
Home_Loc_Code Sgbstdn_Home_Code A code representing the home location of the student. For international students, it represents the home nation. For out-of-state students, it represents the home state. For California students, it represents the home county.  
Leave_Of_Absence_Code Sgbstdn_Leav_Code A code representing the reason for a student's leave of absence.  
Person_Wh_Id Derived from Sgbstdn_Pidm The campus data warehouse's unique person identifier  
Prof_Fee_Code If Sgbstdn_Camp_Code < "99" then Sgbstdn_Camp_Code else Null A code representing professional fees and the years they are in effect  
Record_Update Today() The date that the record was added or last updated in the table  
Record_Valid_Flag Null   Not populated
Residence_Status_Code Sgbstdn_Resd_Code A code representing the residency status of a student  
Snapshot_Code Variable Represents a critical point in time during the enrollment or instructional period of a course  
Source_Record_Update Sgbstdn_Activity_Date The last date that the record was updated in the source system  
Student_Definition_Code Derived from Sfbetrm_Ar_Ind, Sfrstcr_Rsts_Code, and Sgbstdn_Stst_Code Indicates the student's fee and enrollment status 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'
Student_Status_Code Sgbstdn_Stst_Code Represents the status of the student (i.e. active, cancelled, PELP)  
Student_Type_Code Sgbstdn_Styp_Code Indicates the student's type for the term (i.e. new, continuing, re-admit)  
Ucop_Grp_Code Sgbstdn_Capl_Code This field identifies the student groups that are of interest.  
Visa_Type_Code Gorvisa_Vtyp_Code Type of visa held by a non-US citizen. Return Gorvisa_Vtyp_Code with the max(Gorvisa_Start_Date) where Gorvisa_Start_Date<=Today() and Gorvisas_Expire_Date>=Today()

Last Updated on 11/15/04
By Information & Educational Technology