PIM_CAL_TYPE_VW

(SQL View)
 Index Back

Task Type View.

View to get Active Task Types that are for generic usage. Used by Task Management.

SELECT TASK_TYPE , DESCR FROM PS_RB_TSK_TYPE WHERE ACTIVE_FLG = 'Y' AND APPLICATION_USAGE = 'ALL' AND START_TM_REQ_FLG = 'Y'

  • Related Language Record: RB_TSK_TYP_VW_L

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TASK_TYPE Character(18) VARCHAR2(18) NOT NULL Copied from Resouce Management (8.1). Added new label id for "Task Type"
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description