RG_MODL_TSK_VW

(SQL View)
 Index Back

Model Tasks View

View of Model Tasks for Change Management

SELECT A.SETID , A.MODEL_ID , A.SEQ_NBR , A.RG_CHANGE_STATE , B.TASK_GRP_TPL_ID , C.TASK_TYPE , C.PERSON_ID_OWNER , C.TASK_PRIORITY , C.PERSON_ID_ASSIGNEE , C.PROVIDER_GRP_TSK , C.TASK_LOCATION , C.NBR_OF_DAYS , C.NBR_OF_HOURS , C.DESCR60 , C.START_USE_CODE FROM PS_RG_PHS_MODL_DTL A , PS_RG_PHS_MODL_TSK B , PS_RB_TGRP_TPL_TSK C WHERE A.SETID = B.SETID AND A.MODEL_ID = B.MODEL_ID AND A.SEQ_NBR = B.SEQ_NBR AND B.TASK_GRP_TPL_ID = C.TASK_GRP_TPL_ID

  • Related Language Record: RG_MODL_TSK_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
    2 MODEL_ID Character(15) VARCHAR2(15) NOT NULL Model Id used in Change Management Phase Models

    Prompt Table: RG_PHS_MODL_HDR

    3 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
    4 RG_CHANGE_STATE Character(4) VARCHAR2(4) NOT NULL Change request change State / Phase
    CANC=Canceled
    COMP=Complete
    DEV=Development
    HOLD=On Hold
    IMPL=Implementation
    PEND=Change Pending
    POST=Postmortem Review
    PROP=Proposed
    REJ=Rejected
    RETN=Return for More Information
    REVW=Review

    Prompt Table: RG_CHG_STATE_VW

    5 TASK_GRP_TPL_ID Character(10) VARCHAR2(10) NOT NULL Task Group Template ID primary key

    Prompt Table: RB_TGRP_TPL

    6 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

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

    Prompt Table: RB_WORKER_SRCH

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

    Prompt Table: RB_TSK_PRTY_TBL

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

    Prompt Table: RB_WORKER_SRCH

    10 PROVIDER_GRP_TSK Character(1) VARCHAR2(1) NOT NULL Indicator that a Provider Group would be assigned to a Task
    N=No
    Y=Yes
    11 TASK_LOCATION Character(30) VARCHAR2(30) NOT NULL Task Location. Used by Task Management.
    12 NBR_OF_DAYS Number(4,0) SMALLINT NOT NULL Estimated Days
    13 NBR_OF_HOURS Number(3,0) SMALLINT NOT NULL Task Duration Hours for Change Management Phase Templates
    14 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
    15 START_USE_CODE Character(2) VARCHAR2(2) NOT NULL Task Duration Start Use code, used to determine when a Task Template will start.
    CP=Current Phase Start
    N=Next in Sequence
    P=Phase Start
    PP=Prior Phase Start
    PT=Prior Task Start
    T=Task Start