SOC_MED_TYPE_LV

(SQL View)
 Index Back

Social Media Type RL View


SELECT RL.SOCIAL_MEDIA_ID , RL.LANGUAGE_CD , RL.DESCR FROM PS_SOCIAL_MED_TPLG RL , PS_SOCIAL_MED_TYPE B WHERE B.SOCIAL_MEDIA_ID = RL.SOCIAL_MEDIA_ID AND B.EFF_STATUS='A'

  • Related Language Record for SOC_MED_TYPE_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SOCIAL_MEDIA_ID Character(10) VARCHAR2(10) NOT NULL Social Media ID
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description