EP_ROLE_VW3 (SQL View)	Index Back
ePerformance Roles: View View of active roles based on Current date

EP_ROLE_VW3

(SQL View)

ePerformance Roles: View

View of active roles based on Current date

SELECT EP_ROLE , EP_DESCR ,EP_DESCRLONG FROM PS_EP_ROLE_TBL A WHERE A.EFF_STATUS='A' AND A.EFFDT = ( SELECT MAX(EFFDT) FROM PS_EP_ROLE_TBL B WHERE B.EP_ROLE = A.EP_ROLE AND EFFDT <=%CurrentDateIn)

# 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.

3 EP_DESCRLONG Long Character CLOB Long 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.
3	EP_DESCRLONG	Long Character	CLOB	Long description field used in ePerformance.