TILE_EVENT_IDCO=Contracts
PO=Purchasing
DP=Days Pending
MA=Maximum Amount
NO=None
PO_TILE_EVENTVW(SQL View) |
Index Back |
|---|---|
PO Tile EventsPO Tile Events |
| SELECT DISTINCT TILE_EVENT_ID ,TILE_EVENT_NAME ,SEQ_NUM ,TILE_EVENT_TYPE ,EVENT_THRESH_TYPE FROM PS_PO_TILE_EVENTS WHERE EVENT_THRESH_TYPE IN ('MA','DP') AND TILE_EVENT_ID <> 'CNCTEXP' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TILE_EVENT_ID |
Character(10) | VARCHAR2(10) NOT NULL | Event Short Name |
| 2 | TILE_EVENT_NAME | Character(30) | VARCHAR2(30) NOT NULL | Transaction Name |
| 3 | SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Sequence |
| 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 |