TR_HV_PAY_C_VW(SQL View) |
Index Back |
|---|---|
Top Payment Count over ThreshoThis Record is used to calculate the Total Count Over Threshold to be displayed on the Top Payments Tile |
| SELECT TH.OPRID , COUNT(*) FROM PS_TR_HV_DTL_AL_VW DTL , PS_TR_HV_CUR_THOLD TH WHERE DTL.CURRENCY_CD = TH.CURRENCY_CD AND DTL.AMOUNT > TH.AMOUNT GROUP BY TH.OPRID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | COUNT1 | Number(10,0) | DECIMAL(10) NOT NULL | Counter |