UNIT_CONVR_TBL

(SQL Table)
 Index Back

Unit Conversion Table

This Table contains information to convert Units from one Term Type to another Term Type.

  • Parent record: TERM_TYPE_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 TERM_TYPE Character(1) VARCHAR2(1) NOT NULL Term Unit Type
    C=Clock Hours
    E=Continuing Education Units
    Q=Quarter Hours
    S=Semester Hours
    T=Trimester Hours
    U=Units

    Prompt Table: TERM_TYPE_TBL

    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 TERM_TYPE_CONVR_TO Character(1) VARCHAR2(1) NOT NULL Term Type Convert To
    C=Clock Hours
    E=Continuing Education Units
    Q=Quarter Hours
    S=Semester Hours
    T=Trimester Hours
    5 UNIT_MULTIPLIER Number(9,4) DECIMAL(8,4) NOT NULL Unit Multiplier