REPORT_ENTITYPrompt Table: PO_SPEND_EN_SCH
TILE_EVENT_IDDP=Days Pending
MA=Maximum Amount
NO=None
PO_EVT_THRSH_VW(SQL View) |
Index Back |
|---|---|
PO Event Admin Threshold |
| SELECT A.REPORT_ENTITY , A.TILE_EVENT_ID , B.EVENT_THRESH_TYPE , A.L1_THRESH_AMT , L1_THRESH_DAYS FROM PS_PO_EVT_THRESH A , PS_PO_TILE_EVENTS B WHERE A.TILE_EVENT_ID = B.TILE_EVENT_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | REPORT_ENTITY |
Character(5) | VARCHAR2(5) NOT NULL |
Reporting Entity ID
Prompt Table: PO_SPEND_EN_SCH |
| 2 | TILE_EVENT_ID |
Character(10) | VARCHAR2(10) NOT NULL | Event Short Name |
| 3 | EVENT_THRESH_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Threshold Type
DP=Days Pending MA=Maximum Amount NO=None |
| 4 | L1_THRESH_AMT | Number(15,3) | DECIMAL(14,3) NOT NULL | Amount |
| 5 | L1_THRESH_DAYS | Number(10,0) | DECIMAL(10) NOT NULL | Threshold Days |