STDNT_SESSION

(SQL Table)
 Index Back

Student Session Table

This table contains student information by session by term by academic career in Academic programs. To have an entry in this table, the student must have at least one entry in a term within the Academic Program.

  • Parent record: STDNT_CAR_TERM

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PEOPLE_SRCH

    2 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic Career
    BAC=Bachelor (NLD)
    BBL=Vocational Coaching (NLD)
    BOL=Vocational Training (NLD)
    BUSN=Graduate Business
    CNED=Continuing Education
    CRED=Semester Credit
    EDU=Education (NLD)
    EXED=Extended Education
    GRAD=Graduate
    LAW=Law
    MEDS=Medical School
    NONA=Non Award
    PGRD=Postgraduate
    RSCH=Research
    TECH=Technical
    UENG=Undergraduate Engineering
    UGRD=Undergraduate
    VAVO=Advanced General Educ. (NLD)
    VETM=Veterinary Medicine

    Prompt Table: ACAD_CAR_TBL

    3 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    4 STRM Character(4) VARCHAR2(4) NOT NULL Term

    Prompt Table: TERM_VAL_TBL

    5 SESSION_CODE Character(3) VARCHAR2(3) NOT NULL Session
    1=Regular Academic Session
    10W=10 Week
    12W=Twelve Week
    4W1=Four Week - First
    4W2=Four Week - Second
    4W3=Four Week - Third
    4W4=Four Week - Fourth
    6W1=Six Week - First
    6W2=Six Week - Second
    8W1=Eight Week - First
    8W2=Eight Week - Second
    A11=Medical Period 1, 4 Weeks
    A12=Medical Period 1, 8 Weeks
    A13=Medical Pd 1, 12 Weeks
    A21=Medical Period 2, 4 Weeks
    A22=Medical Period 2, 8 Weeks
    A23=Medical Period 2, 12 Week
    FYR=Full Year
    MIN=Mini Session
    OEE=Open Entry/Open Exit
    SM1=Semester 1
    SM2=Semester 2

    Prompt Table: SESSION_TBL_VW

    6 USE_TERM_UNT_LIM Character(1) VARCHAR2(1) NOT NULL Only Use Term Limits

    Y/N Table Edit

    Default Value: N

    7 OVRD_MAX_UNITS Character(1) VARCHAR2(1) NOT NULL Override Maximum Units

    Y/N Table Edit

    Default Value: N

    8 MAX_TOTAL_UNIT Number(6,2) DECIMAL(5,2) NOT NULL Max Total Units
    9 MAX_NOGPA_UNIT Number(6,2) DECIMAL(5,2) NOT NULL Max No GPA Units
    10 MAX_AUDIT_UNIT Number(6,2) DECIMAL(5,2) NOT NULL Max Audit Units
    11 MAX_WAIT_UNIT Number(6,2) DECIMAL(5,2) NOT NULL Max Wait List Units
    12 MAX_CRSE_COUNT Number(3,0) SMALLINT NOT NULL Max Total Courses
    13 FORM_OF_STUDY Character(4) VARCHAR2(4) NOT NULL Form of Study
    ABRD=Study Abroad
    CAND=Advanced to Candidacy
    DTCH=Detached Study
    ENRL=Class Enrollment

    Default Value: STDNT_CAR_TERM.FORM_OF_STUDY

    14 ACADEMIC_LOAD Character(1) VARCHAR2(1) NOT NULL Academic Load
    F=Enrolled Full-Time
    H=Enrolled Half-Time
    L=Less than Half-Time
    N=No Unit Load
    P=Enrolled Part-Time
    T=Three Quarter Time

    Default Value: N

    Prompt Table: %EDITTABLE2

    15 ACAD_LOAD_APPR Character(1) VARCHAR2(1) NOT NULL Approved Academic Load
    B=Vocational Coaching (NLD)
    D=Dual (NLD)
    E=Part-time Vocational Tr (NLD)
    F=Full-Time
    O=Vocational Training (NLD)
    P=Part-Time

    Default Value: STDNT_CAR_TERM.ACAD_LOAD_APPR

    16 FA_LOAD Character(1) VARCHAR2(1) NOT NULL Financial Aid Load
    F=Enrolled Full-Time
    H=Enrolled Half-Time
    L=Less than Half-Time
    N=No Unit Load
    T=Three Quarter Time
    17 WITHDRAW_CODE Character(3) VARCHAR2(3) NOT NULL Withdrawal \ Cancel
    CAN=Cancelled
    NWD=
    WDR=Withdrew

    Default Value: NWD

    18 WITHDRAW_REASON Character(4) VARCHAR2(4) NOT NULL Withdrawal \ Cancel Reason
    MEDI=Medical
    NPAY=Non-Payment of Fees
    RETR=Retroactive
    19 WITHDRAW_DATE Date(10) DATE Withdrawal \ Cancel Date
    20 LAST_DATE_ATTENDED Date(10) DATE Last Date of Attendance
    21 OVRD_BILL_UNITS Character(1) VARCHAR2(1) NOT NULL Override Billing Units

    Y/N Table Edit

    Default Value: N

    22 PROJ_BILL_UNT Number(3,0) SMALLINT NOT NULL Projected Bill Units
    23 UNT_TAKEN_PRGRSS Number(9,3) DECIMAL(8,3) NOT NULL Units Taken for Progress
    24 UNT_TAKEN_FA Number(9,3) DECIMAL(8,3) NOT NULL Fin Aid Progress Units Taken
    25 FULLY_ENRL_DT Date(10) DATE Fully Enrolled Date