RAD_ADVISOR_VW

(SQL View)
 Index Back

RAD Search Record

View Record used for Advisor Search

SELECT A.RAD_ADVISOR_ID , A.DESCR , C.DESCR , C.RAD_STATUS_SRCH , A.DESCR254 , B.START_DT , B.END_DT FROM PS_RAD_ADVISOR A , PS_RAD_ADVISOR_VER B , PS_RAD_STATUS C WHERE A.RAD_CUR_WRK_VER = B.RAD_VERSION_ID AND A.RAD_ADVISOR_ID = B.RAD_ADVISOR_ID AND B.RAD_STATUS_ID = C.RAD_STATUS_ID

  • Related Language Record: RAD_ADVISOR_VWL

    • # 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 RAD_STATUS_DESCR Character(30) VARCHAR2(30) NOT NULL Advisor Status Description - description of the status
    4 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
    5 RAD_DESCR254 Character(254) VARCHAR2(254) NOT NULL Advisor Description of Length 254
    6 START_DT Date(10) DATE Start date field to store start date value.
    7 END_DT Date(10) DATE This field stores the end date values.