GDP_TMPL_SM_VW (SQL View)	Index Back
GDP Template Priv. Sum View Guided Process Template Privilege Summary View - Used to control the Guided Processes the operater can select on the Select Guided Process Summary pagelet.

GDP_TMPL_SM_VW

(SQL View)

GDP Template Priv. Sum View

Guided Process Template Privilege Summary View - Used to control the Guided Processes the operater can select on the Select Guided Process Summary pagelet.

SELECT OPR.OPRID , GPT.GDP_TEMPLATE_ID , GPT.GDP_LABEL FROM PS_GDP_TMPL_TBL GPT , PSOPRDEFN OPR WHERE GPT.GDP_ACTIVE_FLG = 'Y' AND EXISTS ( SELECT 'X' FROM PS_GDP_TMPL_PRIV PRL , PSROLEUSER ROL WHERE PRL.GDP_TEMPLATE_ID = GPT.GDP_TEMPLATE_ID AND PRL.GDP_MBR_TYPE = 'ROLE' AND PRL.GDP_MBR_NAME = ROL.ROLENAME AND ROL.ROLEUSER = OPR.OPRID AND PRL.GDP_PRIVSET_ID IN ('PTAI_CONTRIBUTOR', 'PTAI_ADMINISTRATOR'))

Related Language Record: GDP_TMPL_SM_LVW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 GDP_TEMPLATE_ID Character(10) VARCHAR2(10) NOT NULL Guided Process Template ID

3 GDP_LABEL Character(100) VARCHAR2(100) NOT NULL Guided Process Title

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	GDP_TEMPLATE_ID	Character(10)	VARCHAR2(10) NOT NULL	Guided Process Template ID
3	GDP_LABEL	Character(100)	VARCHAR2(100) NOT NULL	Guided Process Title