SCP_EVENT_VW_M

(SQL View)
 Index Back

Event Content View

Event Content View

SELECT H.scp_content_id ,U.OPRID ,start_date , EXTRACT(DAY FROM START_DATE) , A.xlatLONGNAME , EXTRACT(YEAR FROM START_DATE) ,end_date , EXTRACT(DAY FROM end_DATE) , b.xlatLONGNAME , EXTRACT(YEAR FROM end_DATE) ,H.display_order , H.scp_summary ,H.scp_detail , H.scp_plain_text ,H.scp_plain_text FROM PS_SCP_CONTENT_HDR H ,PS_SCP_EVNT_USR_VW U , psxlatitem A , psxlatitem B WHERE H.SCP_CONTENT_TYPE = 'E' AND H.SCP_CONTENT_STATUS = 'P' AND H.SCP_CONTENT_ID = U.SCP_CONTENT_ID AND A.fieldname = 'MONTHCD' AND A.fieldvalue = TO_CHAR(TO_DATE(EXTRACT(MONTH FROM H.START_DATE),'MM'),'MM') AND B.fieldname = 'MONTHCD' AND B.fieldvalue = TO_CHAR(TO_DATE(EXTRACT(MONTH FROM H.END_DATE),'MM'),'MM') AND H.end_date>=%CurrentDateIn

  • Related Language Record: SCP_EVENTS_LNG1

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCP_CONTENT_ID Character(15) VARCHAR2(15) NOT NULL Content ID
    2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    3 START_DATE Date(10) DATE Start Date for Gen Standing PO
    4 DAYS_OF_MONTH_CD Character(2) VARCHAR2(2) NOT NULL Days of Month
    5 MONTHCD_DESC Character(30) VARCHAR2(30) NOT NULL Month Code Desc
    6 YEAR Character(4) VARCHAR2(4) NOT NULL Year
    1=NONE
    7 END_DATE Date(10) DATE End Date
    8 DAYOFTHEWEEK Character(2) VARCHAR2(2) NOT NULL Day of the Week
    1=Sunday
    2=Monday
    3=Tuesday
    4=Wednesday
    5=Thursday
    6=Friday
    7=Saturday
    9 MONTH_DESCR Character(30) VARCHAR2(30) NOT NULL This is the description of the month.
    10 YEAR1 Character(4) VARCHAR2(4) NOT NULL Year 1
    11 DISPLAY_ORDER Number(3,0) SMALLINT NOT NULL Display order for ordering items in a list - web style
    12 SCP_SUMMARY Character(254) VARCHAR2(254) NOT NULL Content Summary
    13 SCP_DETAIL Long Character CLOB Content Detail
    14 SCP_PLAIN_TEXT Long Character CLOB Short Description
    15 DESCRLONG Long Character CLOB Long Description