RBW_TMPL_TSK_VW

(SQL View)
 Index Back

Task Group Template Tasks

Holds the Tasks information for a Task Group Template.

SELECT TASK_GRP_TPL_ID , SEQNO , TASK_TYPE , PERSON_ID_OWNER , TASK_PRIORITY , PERSON_ID_ASSIGNEE , PROVIDER_GRP_TSK , NBR_OF_DAYS ,DESCR60 FROM PS_RB_TGRP_TPL_TSK

  • Related Language Record: RB_TGRP_TP_TSKL

    • # 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 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

    4 PERSON_ID_OWNER Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts

    Prompt Table: RB_WORKER_SRCH

    5 TASK_PRIORITY Character(4) VARCHAR2(4) NOT NULL Task Priority indicator for Task. Used in Task Management.

    Default Value: 2

    Prompt Table: RB_TSK_PRTY_TBL

    6 PERSON_ID_ASSIGNEE Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts

    Prompt Table: RB_WORKER_SRCH

    7 PROVIDER_GRP_TSK Character(1) VARCHAR2(1) NOT NULL Indicator that a Provider Group would be assigned to a Task
    N=No
    Y=Yes
    8 NBR_OF_DAYS Number(4,0) SMALLINT NOT NULL Estimated Days
    9 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description