HCSC_ANN_ACC_VW

(SQL View)
Index Back

SELECT R.ROLEUSER FROM PSROLEUSER R, PS_HCSC_ANN_ROLE I WHERE I.HCSC_ANN_ACCESS = 'Y' AND R.ROLENAME = I.ROLENAME UNION SELECT ROLEUSER FROM PSROLEUSER WHERE NOT EXISTS(SELECT 'X' FROM PS_HCSC_ANN_ROLE)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).