SCP_PUB_ANN_VW

(SQL View)
 Index Back

Announcements Content View

Announcements Content View

SELECT A.SCP_CONTENT_TYPE , A.SCP_CONTENT_ID , A.DISPLAY_ORDER , A.SCP_SECURITY_GROUP , A.SCP_SUMMARY , A.SCP_DETAIL , A.SCP_PLAIN_TEXT , EXTRACT(DAY FROM A.CREATED_DTTM) || ' ' || to_char(TO_DATE(EXTRACT(MONTH FROM A.CREATED_DTTM) ,'MM') ,'Month') || ' ' || EXTRACT(YEAR FROM A.CREATED_DTTM) , A.CREATED_DTTM ,B.OPRID FROM PS_SCP_CONTENT_HDR A ,PS_SCP_ANNO_USR_VW B WHERE SCP_CONTENT_TYPE = 'A' AND SCP_CONTENT_STATUS = 'P' AND A.SCP_CONTENT_ID = B.SCP_CONTENT_ID ORDER BY DISPLAY_ORDER ASC, CREATED_DTTM DESC

  • Related Language Record: SCP_PUB_ANN_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCP_CONTENT_TYPE Character(1) VARCHAR2(1) NOT NULL Content Type
    2 SCP_CONTENT_ID Character(15) VARCHAR2(15) NOT NULL Content ID
    3 DISPLAY_ORDER Number(3,0) SMALLINT NOT NULL Display order for ordering items in a list - web style
    4 SCP_SECURITY_GROUP Character(4) VARCHAR2(4) NOT NULL Content Security Group

    Prompt Table: SCP_CONTSEC_GRP

    5 SCP_SUMMARY Character(254) VARCHAR2(254) NOT NULL Content Summary
    6 SCP_DETAIL Long Character CLOB Content Detail
    7 SCP_PLAIN_TEXT Long Character CLOB Short Description
    8 DESCRLONG Long Character CLOB Long Description
    9 CREATED_DTTM DateTime(26) TIMESTAMP Created Date and time
    10 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).