EARNINGS_CLR_VW(SQL View) |
Index Back |
---|---|
Earnings Codes Vw - RP Class RThis is the view used in Retro Pay processing that selects from PS_EARNINGS_TBL all the Earnings Codes that have been set up as 'Used to pay Retro'. |
SELECT ERNCD , EFFDT , DESCR FROM PS_EARNINGS_TBL WHERE EFF_STATUS = 'A' AND USED_TO_PAY_RETRO = 'Y' AND ELIG_FOR_RETROPAY = 'N' |
# | 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 | Effective Date |
3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |