RS_TASKTYPE_RPT

(SQL View)
Index Back

SELECT TASK_TYPE ,DESCR , FLEXIBILITY , RESV_FLEXIBILITY ,EXTERNAL_CATEGORY , DESCRLONG FROM %Table(RS_TASK_TYPE) WHERE SYSTEM_SOURCE='RS'

  • Related Language Record: RS_TASKTYPE_LVW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TASK_TYPE Character(18) VARCHAR2(18) NOT NULL Task Category
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 FLEXIBILITY Number(4,2) DECIMAL(3,2) NOT NULL Flexibility Factor
    4 RESV_FLEXIBILITY Number(4,2) DECIMAL(3,2) NOT NULL Reserved Status Flexibility
    5 EXTERNAL_CATEGORY Character(40) VARCHAR2(40) NOT NULL External Category
    6 DESCRLONG Long Character CLOB Long Description