RETROPAY_PGM_IDEFFDTERNCD_FOR_RETROPAYPrompt Table: EARNINGS_CLE_VW
Prompt Table: EARNINGS_CLR_VW
RETROPAYPGM_DEF(SQL Table) |
Index Back |
|---|---|
Retro Pay Program DefinitionRetro Pay Program Definition |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RETROPAY_PGM_ID |
Character(3) | VARCHAR2(3) NOT NULL | Retro Pay Program ID |
| 2 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 3 | ERNCD_FOR_RETROPAY |
Character(3) | VARCHAR2(3) NOT NULL |
Earnings Type for Retro Pay
Prompt Table: EARNINGS_CLE_VW |
| 4 | RETROPAY_ERNCD | Character(3) | VARCHAR2(3) NOT NULL |
Retro Pay Earnings Type
Prompt Table: EARNINGS_CLR_VW |
| 5 | START_DATE_OVRD | Date(10) | DATE | Start Date Ovrd for Mass Retro |
| 6 | END_DATE_OVRD | Date(10) | DATE | End Date Ovrd for Mass Retro |