SCP_EVNTUSR_LNG

(SQL View)
 Index Back

Event Content User View

Event Content User View - Related Language

SELECT B.OPRID , A.SCP_CONTENT_ID , A.LANGUAGE_CD , A.SCP_SUMMARY , A.SCP_DETAIL FROM PS_SCP_EVENTS_LNG A , PS_SCP_CONGRPUS_VW B , PS_SCP_EVENTS_VW C WHERE B.SCP_SECURITY_GROUP = C.SCP_SECURITY_GROUP AND C.SCP_CONTENT_ID = A.SCP_CONTENT_ID

  • Related Language Record for SCP_EVNT_USR_VW SCP_PUB_EVNT_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