RG_PHS_MODL_D_V (SQL View)	Index Back
Phase Model Detail View View Phases only on the table for change requests

RG_PHS_MODL_D_V

(SQL View)

Phase Model Detail View

View Phases only on the table for change requests

SELECT A.SETID , A.MODEL_ID , A.SEQ_NBR , A.RG_CHANGE_STATE FROM PS_RG_PHS_MODL_DTL A

# 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

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_UD_STATE_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
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_UD_STATE_VW