EP_NO_ROLES_VW (SQL View)	Index Back
ePerformance Roles: View View that selects no roles. To be used as a prompt on the Establish Criteria Role Rules grid to show no Roles in the drop down list.

EP_NO_ROLES_VW

(SQL View)

ePerformance Roles: View

View that selects no roles. To be used as a prompt on the Establish Criteria Role Rules grid to show no Roles in the drop down list.

SELECT EP_ROLE , EP_DESCR FROM PS_EP_ROLE_TBL WHERE 1 = 2

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EP_ROLE Character(8) VARCHAR2(8) NOT NULL Role unique identifier

2 EP_DESCR Character(30) VARCHAR2(30) NOT NULL Description field used in ePerformance.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EP_ROLE	Character(8)	VARCHAR2(8) NOT NULL	Role unique identifier
2	EP_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description field used in ePerformance.