RD_USR_TST_VW

(SQL View)
 Index Back

User-level Test view

View of Tests by User ID and access level

SELECT TS.OPRID , T.TEST_ID , TS.ACCESS_CD , T.DESCR FROM PS_SA_TEST_TBL T , PS_SAD_TEST_SCTY TS WHERE (T.TEST_ID = TS.TEST_ID OR TS.TEST_ID = 'ALL') AND NOT EXISTS ( SELECT 1 FROM PS_SAD_TEST_SCTY TS2 WHERE TS.OPRID = TS2.OPRID AND TS.TEST_ID = TS2.TEST_ID AND TS2.ACCESS_CD = 'N') AND %EffdtCheck(SA_TEST_TBL, T, %CurrentDateIn) AND T.EFF_STATUS = 'A'

  • Related Language Record: RD_USR_TST_LVW

    • # 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 TEST_ID Character(11) VARCHAR2(11) NOT NULL Test ID codes.
    3 ACCESS_CD Character(1) VARCHAR2(1) NOT NULL Access Code
    N=No Access
    R=Read Only Access
    Y=Read/Write Access
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description