RA_ADV_ACTI_VW

(SQL View)
 Index Back

Offer Search - Not Archived

Advisor Search Record for non archived dialogs within effective dates used by Offer Search

SELECT A.RAD_ADVISOR_ID , A.DESCR , A.DESCR254 , C.START_DT , C.END_DT , C.RAD_STATUS_ID , B.RAD_STATUS_TYP FROM PS_RAD_ADVISOR A , PS_RAD_STATUS B , PS_RAD_ADVISOR_VER C WHERE A.RAD_ADVISOR_ID = C.RAD_ADVISOR_ID AND A.RAD_VERSION_ID = C.RAD_VERSION_ID AND C.RAD_STATUS_ID = B.RAD_STATUS_ID AND A.RAD_ARCHIVED = 'N' AND C.START_DT <= %CurrentDateIn AND C.END_DT >= %CurrentDateIn

  • Related Language Record: RA_ADV_ACT_LVW

    • # 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 RAD_ADVISOR_NAME Character(30) VARCHAR2(30) NOT NULL Advisor Dialog name - obtained from the RAD_ADVISOR header
    3 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    4 START_DT Date(10) DATE Start date field to store start date value.
    5 END_DT Date(10) DATE This field stores the end date values.
    6 RAD_STATUS_ID Character(20) VARCHAR2(20) NOT NULL Advisor Status
    7 RAD_STATUS_TYP Character(1) VARCHAR2(1) NOT NULL Advisor Status type - used to indicate the type for the status
    A=Archived
    D=Deployed
    I=In Progress
    N=New
    O=Past Deployed
    V=Validated