TERM_PGM_IDEFFDTERNCDPrompt Table: EARNINGS_TBL
E=Pay Earnings Amount
G=Pay Goal Difference
TERM_PGM_DEFERN(SQL Table) |
Index Back |
|---|---|
Final Check Earnings Defn TblThis table stores all of the valid earnings codes and payout rules associated with a Final Check program. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TERM_PGM_ID |
Character(3) | VARCHAR2(3) NOT NULL | Final Check Program ID |
| 2 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 3 | ERNCD |
Character(3) | VARCHAR2(3) NOT NULL |
Earnings Code
Prompt Table: EARNINGS_TBL |
| 4 | AMT_OVRD_LIMIT | Number(11,2) | DECIMAL(10,2) NOT NULL | Amount Override Limit |
| 5 | PAYOUT_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Payout Option
E=Pay Earnings Amount G=Pay Goal Difference |