RG_T_TPL_TSK_VW

(SQL View)
 Index Back

Task Group Template Tasks

Holds the Tasks information for a Task Group Template.

SELECT A.TASK_GRP_TPL_ID , A.SEQNO , B.APPLICATION_USAGE , B.DESCR , A.TASK_TYPE , C.DESCR , A.TASK_LOCATION , A.NBR_OF_DAYS , A.NBR_OF_HOURS , A.ROW_LASTMANT_DTTM , A.ROW_LASTMANT_OPRID FROM PS_RB_TGRP_TPL_TSK A , PS_RB_TGRP_TPL B , PS_RB_TSK_TYPE C WHERE A.TASK_GRP_TPL_ID = B.TASK_GRP_TPL_ID AND B.APPLICATION_USAGE = 'CHMG' AND A.TASK_TYPE = C.TASK_TYPE

  • Related Language Record: RG_T_TPL_TSK_VL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TASK_GRP_TPL_ID Character(10) VARCHAR2(10) NOT NULL Task Group Template ID primary key
    2 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number
    3 APPLICATION_USAGE Character(4) VARCHAR2(4) NOT NULL Application Usage. Holds the info about the application.
    ALL=All Applications
    CHMG=Change Management
    EVNT=Marketing Events
    FLDS=Field Service
    HIED=Higher Education
    HLPD=HelpDesk
    HRHD=HR Helpdesk
    LEAD=Lead
    OPPY=Opportunity
    PIM=Personal Information Mgmt
    RSP=Strategic Planning
    SALS=Sales
    SUPP=Support
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 TASK_TYPE Character(18) VARCHAR2(18) NOT NULL Copied from Resouce Management (8.1). Added new label id for "Task Type"

    Prompt Table: RB_TSK_TYPE

    6 DESCR_TSK_TYPE Character(30) VARCHAR2(30) NOT NULL Descriotion of Task Type.
    7 TASK_LOCATION Character(30) VARCHAR2(30) NOT NULL Task Location. Used by Task Management.
    8 NBR_OF_DAYS Number(4,0) SMALLINT NOT NULL Estimated Days
    9 NBR_OF_HOURS Number(3,0) SMALLINT NOT NULL Task Duration Hours for Change Management Phase Templates
    10 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    11 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.