SAD_TAC_SCTY_VW

(SQL View)
 Index Back

Security Prompt for Test ID

Prompt view which enforces operator security by Test ID. It lists the Test IDs that the operator is cleared to see.

SELECT A.TEST_ID ,B.OPRID ,C.DESCR ,B.ACCESS_CD FROM PS_SAD_TEST_SETUP2 A ,PS_SAD_TEST_SCTY B ,PS_SA_TEST_TBL C WHERE C.TEST_ID = A.TEST_ID AND B.ACCESS_CD = 'Y' AND (A.TEST_ID = B.TEST_ID OR B.TEST_ID = 'ALL') AND A.SAD_TEST_ID IN('QTC','VTC','STC','UAC') AND C.EFFDT = ( SELECT MAX(C1.EFFDT) FROM PS_SA_TEST_TBL C1 WHERE C1.TEST_ID = C.TEST_ID AND C1.EFFDT <= %CurrentDateIn) AND C.EFF_STATUS = 'A'

  • Related Language Record: SADTSTSCTYVWLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TEST_ID Character(11) VARCHAR2(11) NOT NULL Test ID

    Prompt Table: SA_TEST_TBL

    2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 ACCESS_CD Character(1) VARCHAR2(1) NOT NULL Access Code
    N=No Access
    Y=Read/Write Access