SCP_WELCUSR_LNG

(SQL View)
 Index Back

Welcome Users View

Welcome Content Users View - Related Language

SELECT B.OPRID , A.SCP_CONTENT_ID , A.LANGUAGE_CD , A.SCP_SUMMARY , A.SCP_DETAIL , A.SCP_PLAIN_TEXT FROM PS_SCP_WELCOME_LNG A , PS_SCP_CONGRPUS_VW B , PS_SCP_WELCOME_VW C WHERE B.SCP_SECURITY_GROUP = C.SCP_SECURITY_GROUP AND A.SCP_CONTENT_ID = C.SCP_CONTENT_ID

  • Related Language Record for SCP_PUB_WELC_VW SCP_WELC_USR_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 SCP_CONTENT_ID Character(15) VARCHAR2(15) NOT NULL Content ID
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 SCP_SUMMARY Character(254) VARCHAR2(254) NOT NULL Content Summary
    5 SCP_DETAIL Long Character CLOB Content Detail
    6 SCP_PLAIN_TEXT Long Character CLOB Short Description