RG_PHS_MDLH_VW (SQL View)	Index Back
Phase Model Header View of Phase Model Header table

RG_PHS_MDLH_VW

(SQL View)

Phase Model Header

View of Phase Model Header table

SELECT usr.SETID , usr.MODEL_ID , hdr.DESCR FROM PS_RG_PHS_MODL_HDR hdr , PS_RG_PHS_MODL_USE usr WHERE usr.SETID = hdr.SETID AND usr.MODEL_ID = hdr.MODEL_ID

Related Language Record: RG_PHS_MDLH_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

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	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	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description