RAD_ADV_STT_VWL

(SQL View)
 Index Back

Status Language View

Link status table with Advisor Type Table

SELECT A.RAD_ADVISOR_TYP_ID , A.RAD_STATUS_ID ,C.LANGUAGE_CD , C.DESCR , A.RAD_SHOW_FLAG FROM PS_RAD_ADV_TYP_STT A , PS_RAD_STATUS B , PS_RAD_STATUS_LNG C WHERE A.RAD_STATUS_ID = B.RAD_STATUS_ID AND B.RAD_STATUS_ID = C.RAD_STATUS_ID

  • Related Language Record for RAD_ADV_STT_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RAD_ADVISOR_TYP_ID Character(20) VARCHAR2(20) NOT NULL Advisor Type Guid - internally represents the Type
    2 RAD_STATUS_ID Character(20) VARCHAR2(20) NOT NULL Advisor Status
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 RAD_SHOW_FLAG Character(1) VARCHAR2(1) NOT NULL show flag