ERNCDEFFDTEARNINGS_CLE_VW(SQL View) |
Index Back |
|---|---|
Earnings Codes Vw - RP Class EThis is the view used in Retro Pay processing that selects from PS_EARNINGS_TBL all the Earnings Codes that have been set up as 'Eligible for Retro Pay'. |
| SELECT ERNCD , EFFDT , DESCR FROM PS_EARNINGS_TBL WHERE EFF_STATUS = 'A' AND ELIG_FOR_RETROPAY = 'Y' AND USED_TO_PAY_RETRO = 'N' AND ERNCD NOT IN ('$NA','$AC') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ERNCD |
Character(3) | VARCHAR2(3) NOT NULL | Earnings Code |
| 2 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |