RB_SRTY_DF_SRCH (SQL View)	Index Back
Security Role Privileges Security Role Privileges

RB_SRTY_DF_SRCH

(SQL View)

Security Role Privileges

SELECT A.ROLE_TYPE_ID , A.SRTY_PRIV_CD , B.DESCR FROM PS_RB_SRTY_DFLT A , PS_BO_ROLE_TYPE B WHERE A.ROLE_TYPE_ID = B.ROLE_TYPE_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ROLE_TYPE_ID Number(12,0) DECIMAL(12) NOT NULL Role Type ID
Prompt Table: BO_ROLE_TYPE

2 SRTY_PRIV_CD Character(12) VARCHAR2(12) NOT NULL Security privilege code. Used by CRM self-service to define security privileges
Prompt Table: RB_SRTY_PRIV

3 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ROLE_TYPE_ID	Number(12,0)	DECIMAL(12) NOT NULL	Role Type ID Prompt Table: BO_ROLE_TYPE
2	SRTY_PRIV_CD	Character(12)	VARCHAR2(12) NOT NULL	Security privilege code. Used by CRM self-service to define security privileges Prompt Table: RB_SRTY_PRIV
3	ROLENAME	Character(30)	VARCHAR2(30) NOT NULL	The name of a Role in the Role Definition Table (see PSROLEDEFN).