PSPTSEC_ROLES (SQL Table)	Index Back
Security Role Information Roles assigned to a Service Operation

PSPTSEC_ROLES

(SQL Table)

Security Role Information

Roles assigned to a Service Operation

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PTAPP_NAME Character(100) VARCHAR2(100) NOT NULL Application Name

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PTAPP_NAME	Character(100)	VARCHAR2(100) NOT NULL	Application Name
2	ROLENAME	Character(30)	VARCHAR2(30) NOT NULL	The name of a Role in the Role Definition Table (see PSROLEDEFN). Prompt Table: PSROLEDEFN