SSR_ACADLOD_AUS

(SQL Table)
 Index Back

Academic Load Table - AUS

This Table defines the relationship between Academic Load and the Total Units required in a Term within a Level Load Rule and SetID. This is a sibling Table to ACAD_LOAD_TBL This table is specifically used for calculating HECS Load Factor.

  • Parent record: LVL_LD_RULE_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_CS.SETID_CAREER

    Prompt Table: SETID_TBL

    2 LEVEL_LOAD_RULE Character(5) VARCHAR2(5) NOT NULL Academic Level Rule

    Prompt Table: LVL_LD_RULE_TBL

    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 TERM_CATEGORY Character(1) VARCHAR2(1) NOT NULL Term Category
    0=Full Year
    1=1st Semester
    2=2nd Semester
    3=Summer Session AUS
    4=Winter Session AUS
    C=Medical Clinical
    I=Intersession Term
    M=Medical Level 1
    R=Regular Term
    S=Summer Term
    W=Winter Term

    Default Value: R

    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
    6 UNT_TRM_TOTAL Number(9,3) DECIMAL(8,3) NOT NULL Unit Term Total
    7 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
    8 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
    9 ACADEMIC_LOAD_NSLC Character(1) VARCHAR2(1) NOT NULL This field contains the academic load value to report to the NSC.
    F=Full-Time
    H=Half-Time
    L=Less Than Half-Time
    Q=Three Quarter Time
    10 COURSE_LD_PCT Number(6,2) DECIMAL(5,2) NOT NULL Course Load Pct
    11 RES_TERMS_ADJ Number(4,2) DECIMAL(3,2) NOT NULL Resident Terms Adjust Factor
    12 SSR_INCL_LOAD_CALC Character(1) VARCHAR2(1) NOT NULL Include In Annual Load Calc

    Y/N Table Edit

    Default Value: N