OPRIDTEST_IDLANGUAGE_CDRD_USR_TST_LVW(SQL View) |
Index Back |
|---|---|
RD_USR_TST_VW RLRRelated language view for RD_USR_TST_VW |
| SELECT TS.OPRID , T.TEST_ID , TL.LANGUAGE_CD , T.DESCR FROM PS_SA_TEST_TBL T , PS_SA_TEST_LANG TL , 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.TEST_ID = TL.TEST_ID AND T.EFFDT = TL.EFFDT |
| # | 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |