RAD_QA_SRCH_VW

(SQL View)
 Index Back

Search View QA Rad

Advisor Search View for Questions

SELECT B.RAD_QUESTION_ID , B.RAD_QUESTION_NAME , B.RAD_QUESTION_TEXT , B.RAD_QUESTION_TYP , A.DESCR , B.RAD_LIBRARY_ID FROM PS_RAD_QA_HDR B , PS_RAD_LIBRARY A WHERE B.RAD_LIBRARY_ID = A.RAD_LIBRARY_ID

  • Related Language Record: RAD_QA_SRCH_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RAD_QUESTION_ID Character(20) VARCHAR2(20) NOT NULL Question ID
    2 RAD_QUESTION_NAME Character(50) VARCHAR2(50) NOT NULL Advisor Question Name Field, user visible name of the question
    3 RAD_QUESTION_TEXT Character(245) VARCHAR2(245) NOT NULL Represents the drop-down for questions in Dialog Test.
    4 RAD_QUESTION_TYP Character(1) VARCHAR2(1) NOT NULL Advisor Question Type used to identify the question
    C=Condition
    F=Freeform Text
    M=Multiple Selection
    N=Numeric
    S=Single Selection
    Y=Yes/No
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 RAD_LIBRARY_ID Character(20) VARCHAR2(20) NOT NULL Library for advisor