SCP_EVENTS_LNG

(SQL View)
 Index Back

Event Content View

Event Content View - Related Language

SELECT A.SCP_CONTENT_ID , B.LANGUAGE_CD , B.SCP_SUMMARY , B.SCP_DETAIL FROM PS_SCP_CONTENT_HDR A , PS_SCP_CONTENT_LNG B WHERE A.SCP_CONTENT_TYPE = 'E' AND A.SCP_CONTENT_STATUS = 'P' AND A.SCP_CONTENT_ID = B.SCP_CONTENT_ID

  • Related Language Record for SCP_EVENTS_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCP_CONTENT_ID Character(15) VARCHAR2(15) NOT NULL Content ID
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 SCP_SUMMARY Character(254) VARCHAR2(254) NOT NULL Content Summary
    4 SCP_DETAIL Long Character CLOB Content Detail