SADTSTSCTYVWLNG

(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.LANGUAGE_CD ,C.DESCR FROM PS_SAD_TEST_SETUP2 A ,PS_SAD_TEST_SCTY B ,PS_SA_TEST_LANG 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 C.EFFDT = ( SELECT MAX(C1.EFFDT) FROM PS_SA_TEST_LANG C1 WHERE C1.TEST_ID = C.TEST_ID AND C1.EFFDT <= %CurrentDateIn)

  • Related Language Record for SAD_TAC_SCTY_VW SAD_TST_SCTY_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description