RG_MODL_TSK_LVW

(SQL View)
 Index Back

Model Tasks View

Related langauge View of Model Tasks for Change Management

SELECT A.SETID , A.MODEL_ID , A.SEQ_NBR , D.LANGUAGE_CD , C.TASK_LOCATION , D.DESCR60 FROM PS_RG_PHS_MODL_DTL A , PS_RG_PHS_MODL_TSK B , PS_RB_TGRP_TPL_TSK C , PS_RB_TGRP_TP_TSKL D 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 AND C.TASK_GRP_TPL_ID = D.TASK_GRP_TPL_ID AND C.SEQNO = D.SEQNO

  • Related Language Record for RG_MODL_TSK_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 TASK_LOCATION Character(30) VARCHAR2(30) NOT NULL Task Location. Used by Task Management.
    6 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description