SADTESTSCVW_LNG

(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 C.TEST_ID ,B.OPRID ,C.LANGUAGE_CD ,C.DESCR FROM PS_SAD_TEST_SCTY B ,PS_SA_TEST_LANG C WHERE B.ACCESS_CD = 'Y' AND (C.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_TEST_SC_VW SAD_TEST_SC_VW2
  • # 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