SCCPS_CNTTLS_VW (SQL View)	Index Back
Security Override for Tools Security override for tools that are allowed for a given context.

SCCPS_CNTTLS_VW

(SQL View)

Security Override for Tools

Security override for tools that are allowed for a given context.

SELECT A.SCCPS_CNTXT_HDR_ID , A.SCCPS_TOOL_ID , B.OPRID FROM PS_SCCPS_CNTXT_TLS A , PSROLEUSER_VW B WHERE A.ROLENAME = B.ROLENAME

Parent record: SCCPS_CNTXT_DFN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SCCPS_CNTXT_HDR_ID Number(15,0) DECIMAL(15) NOT NULL Population Selection Context Bind ID

2 SCCPS_TOOL_ID Number(15,0) DECIMAL(15) NOT NULL Tool ID - the unique key for a pop select tool
Prompt Table: SCCPS_TOOL_DFN

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SCCPS_CNTXT_HDR_ID	Number(15,0)	DECIMAL(15) NOT NULL	Population Selection Context Bind ID
2	SCCPS_TOOL_ID	Number(15,0)	DECIMAL(15) NOT NULL	Tool ID - the unique key for a pop select tool Prompt Table: SCCPS_TOOL_DFN
3	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).