SADTESTSCVW_LNG(SQL View) |
Index Back |
---|---|
Security Prompt for Test IDPrompt 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) |
# | 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 |