RAD_ADVISOR_VWL

(SQL View)
 Index Back

RAD Search Record Language

Advisor Search Record - Language Record

SELECT A.RAD_ADVISOR_ID , C.LANGUAGE_CD , C.DESCR , E.DESCR , E.RAD_STATUS_SRCH , C.DESCR254 FROM PS_RAD_ADVISOR A , PS_RAD_ADVISOR_VER B , PS_RAD_ADVISOR_LNG C , PS_RAD_ADV_VER_LNG D , PS_RAD_STATUS_LNG E WHERE A.RAD_ADVISOR_ID = C.RAD_ADVISOR_ID AND A.RAD_CUR_WRK_VER = B.RAD_VERSION_ID AND B.RAD_STATUS_ID = E.RAD_STATUS_ID AND A.RAD_CUR_WRK_VER = D.RAD_VERSION_ID AND C.LANGUAGE_CD = D.LANGUAGE_CD AND C.LANGUAGE_CD = E.LANGUAGE_CD

  • Related Language Record for RAD_ADVISOR_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RAD_ADVISOR_ID Character(20) VARCHAR2(20) NOT NULL Advisor Dialog Guid - represents internally the Advisor dialog
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 RAD_STATUS_DESCR Character(30) VARCHAR2(30) NOT NULL Advisor Status Description - description of the status
    5 RAD_STATUS_SRCH Character(4) VARCHAR2(4) NOT NULL Field used for Status during search so that we can fake a dropdown.
    FAKE=Fake Entry
    6 RAD_DESCR254 Character(254) VARCHAR2(254) NOT NULL Advisor Description of Length 254