RAD_QUESTION_IDLANGUAGE_CDRAD_QA_SRCH_LVW(SQL View) |
Index Back |
|---|---|
RAD Question Search LanguageAdvisor Search View for Questions, Language View |
| SELECT B.RAD_QUESTION_ID , C.LANGUAGE_CD , C.RAD_QUESTION_NAME , C.RAD_QUESTION_TEXT , D.DESCR , B.RAD_LIBRARY_ID FROM PS_RAD_QA_HDR B , PS_RAD_LIBRARY A , PS_RAD_QA_HDR_LNG C , PS_RAD_LIB_LNG D WHERE B.RAD_LIBRARY_ID = A.RAD_LIBRARY_ID AND B.RAD_QUESTION_ID = C.RAD_QUESTION_ID AND A.RAD_LIBRARY_ID = D.RAD_LIBRARY_ID AND D.LANGUAGE_CD = C.LANGUAGE_CD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RAD_QUESTION_ID |
Character(20) | VARCHAR2(20) NOT NULL | Question ID |
| 2 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | RAD_QUESTION_NAME | Character(50) | VARCHAR2(50) NOT NULL | Advisor Question Name Field, user visible name of the question |
| 4 | RAD_QUESTION_TEXT | Character(245) | VARCHAR2(245) NOT NULL | Represents the drop-down for questions in Dialog Test. |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | RAD_LIBRARY_ID | Character(20) | VARCHAR2(20) NOT NULL | Library for advisor |