SEC_USER_VW2

(SQL View)
 Index Back

SELECT A.OPRID , B.OPRDEFNDESC FROM PS_SEC_USER A , PSOPRDEFN B WHERE A.OPRID = B.OPRID AND A.EFFDT=( SELECT MAX(X.EFFDT) FROM PS_SEC_USER X WHERE %Join(COMMON_KEYS, SEC_USER A, SEC_USER X, EFFDT))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID2 Character(30) VARCHAR2(30) NOT NULL A user's ID
2 OPRDEFNDESC Character(30) VARCHAR2(30) NOT NULL Description field for a user