PO_TL_EVT_CO_VW

(SQL View)
 Index Back

PO Tile Events


SELECT SEQ_NUM , TILE_EVENT_ID , TILE_EVENT_NAME , TILE_EVENT_TYPE , EVENT_THRESH_TYPE , 'Y' ,'Y' , 0 , 0 , ' ' , ' ' , 0 , 0 FROM PS_PO_TILE_EVENTS WHERE TILE_EVENT_TYPE = 'CO'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
2 TILE_EVENT_ID Character(10) VARCHAR2(10) NOT NULL Event Short Name
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 SELECT_SLIDER Character(1) VARCHAR2(1) NOT NULL Select
N=No
Y=Yes
7 SELECT_SLIDER2 Character(1) VARCHAR2(1) NOT NULL Select
N=No
Y=Yes
8 EVENT_AMT_ATTRIB Number(15,3) DECIMAL(14,3) NOT NULL Amount
9 EVENT_DAYS_ATTRIB Number(5,0) INTEGER NOT NULL Days
10 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
11 DESCR15 Character(15) VARCHAR2(15) NOT NULL Short Description
12 L1_THRESH_AMT Number(15,3) DECIMAL(14,3) NOT NULL Amount
13 L1_THRESH_DAYS Number(10,0) DECIMAL(10) NOT NULL Threshold Days