ACAD_LOAD2_TBL

(SQL Table)
Index Back

Academic Load for Stats Period

This Table defines the relationship between Academic Load and the Total Units required in an Academic Statistics Period within a Level Load Rule and SetID.

  • 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 ACAD_STATS_PD_RULE Character(1) VARCHAR2(1) NOT NULL Academic Load Rule
    C=Contiguous Terms
    T=Term Load Rule Applies

    Prompt Table: XLAT_STAT_PD_VW

    5 UNT_TRM_TOTAL Number(9,3) DECIMAL(8,3) NOT NULL Unit Term Total
    6 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
    7 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
    8 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