EFFDTDefault Value: %date
GPCH_EO_RT_VW(SQL View) |
Index Back |
|---|---|
EO Rates AmountsEO Rates Max and Min amounts |
| SELECT A.EFFDT ,MAX(A.GPCH_EO_ANNUAL_AM) ,MIN(A.GPCH_EO_AVERAGE_AM) ,MIN(A.GPCH_EO_0_AM) FROM PS_GPCH_EO_DATA A GROUP BY A.EFFDT ORDER BY A.EFFDT DESC |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 2 | GPCH_EO_ANNUAL_AM | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Annual Amount |
| 3 | GPCH_EO_AVERAGE_AM | Number(11,2) | DECIMAL(10,2) NOT NULL | Average Earnings |
| 4 | GPCH_EO_0_AM | Number(11,2) | DECIMAL(10,2) NOT NULL | 0 Children |