INSTRUCTOR_TERM

(SQL Table)
 Index Back

Instructor Term Table

Keep track of workload per instructor per term.

  • Parent Record Of INSTR_DTL_LANG INSTR_TERM_DTL

    • # 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 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

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

    Prompt Table: TERM_VAL_TBL

    4 INSTRUCTOR_CLASS Character(6) VARCHAR2(6) NOT NULL Instructor Assignment Class

    Prompt Table: INSTR_CLAS_SRCH

    5 LOAD_CALC_APPLY Character(1) VARCHAR2(1) NOT NULL Calculate Workload

    Y/N Table Edit

    Default Value: Y

    6 WORKLD_LIMIT_APPLY Character(1) VARCHAR2(1) NOT NULL Limit Workload

    Y/N Table Edit

    Default Value: Y

    7 ASSIGNED_FTE_PCT Number(6,2) DECIMAL(5,2) NOT NULL Assigned FTE %

    Default Value: INSTRUCTOR_CLAS.ASSIGNED_FTE_PCT

    8 INSTR_MULTIPLIER Number(3,0) SMALLINT NOT NULL Instructor Multiplier %

    Default Value: INSTRUCTOR_CLAS.INSTR_MULTIPLIER