PO_VET_PO_VW

(SQL View)
 Index Back

View Event Threshold PO Events


SELECT A.TILE_EVENT_ID , A.SEQ_NUM , A.TILE_EVENT_NAME , A.TILE_EVENT_TYPE , A.EVENT_THRESH_TYPE , B.REPORT_ENTITY , B.L1_THRESH_AMT , B.L1_THRESH_DAYS , 0 , ' ' FROM PS_PO_TILE_EVENTS A LEFT OUTER JOIN PS_PO_EVT_THRESH B ON A.TILE_EVENT_ID=B.TILE_EVENT_ID WHERE A.TILE_EVENT_TYPE='PO'

  • Related Language Record: PO_VET_PO_LG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TILE_EVENT_ID Character(10) VARCHAR2(10) NOT NULL Event Short Name
    2 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
    3 TILE_EVENT_NAME Character(30) VARCHAR2(30) NOT NULL Transaction Name
    4 TILE_EVENT_TYPE Character(2) VARCHAR2(2) NOT NULL Tile Event Type
    CO=Contracts
    PO=Purchasing
    5 EVENT_THRESH_TYPE Character(2) VARCHAR2(2) NOT NULL Threshold Type
    DP=Days Pending
    MA=Maximum Amount
    NO=None
    6 REPORT_ENTITY Character(5) VARCHAR2(5) NOT NULL Reporting Entity ID
    7 L1_THRESH_AMT Number(15,3) DECIMAL(14,3) NOT NULL Amount
    8 L1_THRESH_DAYS Number(10,0) DECIMAL(10) NOT NULL Threshold Days
    9 EVENT_AMT_ATTRIB1 Number(15,3) DECIMAL(14,3) NOT NULL Threshold
    10 DESCR15 Character(15) VARCHAR2(15) NOT NULL Short Description