ASSIGN_TYPE_VW

(SQL View)
 Index Back

Assignment Type View

This view checks for "display on schedule of classes" field.

SELECT A.INSTITUTION ,A.ASSIGN_TYPE ,A.EFFDT ,A.EFF_STATUS ,A.DESCR ,A.DESCRSHORT ,A.LOAD_CALC_APPLY ,A.ASSIGN_FULLTIM_HRS ,A.ASSIGN_FT_OEE_HRS ,A.DSP_ON_SCHED_CLASS FROM PS_ASSIGNMENT_TYPE A WHERE A.DSP_ON_SCHED_CLASS = 'Y'

  • Related Language Record: ASSIGN_VW_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    2 ASSIGN_TYPE Character(3) VARCHAR2(3) NOT NULL Assignment Type
    NON=Not Included in Workload
    3 EFFDT Date(10) DATE Effective Date
    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    7 LOAD_CALC_APPLY Character(1) VARCHAR2(1) NOT NULL Calculate Workload

    Y/N Table Edit

    Default Value: Y

    8 ASSIGN_FULLTIM_HRS Number(6,2) DECIMAL(5,2) NOT NULL 100% Weekly Workload Hours
    9 ASSIGN_FT_OEE_HRS Number(6,2) DECIMAL(5,2) NOT NULL Similar to ASSIGN_FULLTIME_HRS but holds the value for the OEE counterpart.
    10 DSP_ON_SCHED_CLASS Character(1) VARCHAR2(1) NOT NULL View on Schedule of Classes

    Y/N Table Edit

    Default Value: Y