RG_MODL_TGRP_VW

(SQL View)
 Index Back

Task Groups In Phase

View Task Groups within a Phase of a Model

SELECT DISTINCT B.SETID , B.TASK_GRP_TPL_ID , A.MODEL_ID , A.SEQ_NBR , A.RG_CHANGE_STATE FROM PS_RG_PHS_MODL_DTL A , PS_RG_PHS_MODL_TSK B WHERE A.SETID = B.SETID AND A.MODEL_ID = B.MODEL_ID AND A.SEQ_NBR = B.SEQ_NBR

# 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 TASK_GRP_TPL_ID Character(10) VARCHAR2(10) NOT NULL Task Group Template ID primary key

Prompt Table: RB_TGRP_TPL

3 MODEL_ID Character(15) VARCHAR2(15) NOT NULL Model Id used in Change Management Phase Models

Prompt Table: RG_PHS_MODL_HDR

4 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
5 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