RTBL_CAF_TST_VW

(SQL View)
Index Back

SELECT DISTINCT A.OPRID , A.SCE_ID , A.RTBL_SCENARIO FROM PS_RTBL_CAF_ENT_VW A UNION SELECT B.OPRID , C.SCE_ID , C.RTBL_SCENARIO FROM PSROLEUSER_VW B , PS_RTBL_CAF_ENT_VW C WHERE B.ROLENAME = 'RTBL_ADMIN' AND B.OPRID <> C.OPRID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 SCE_ID Character(10) VARCHAR2(10) NOT NULL ID
3 RTBL_SCENARIO Character(18) VARCHAR2(18) NOT NULL Scenario Name