SETIDPrompt Table: SET_LAB_VLD_VW
LABOR_AGREEMENTEFFDTGPES_PYMNT_PDGPES_PIN_ER1_NUMPrompt Table: %GP_EDIT_FLD4
Y/N Table Edit
Prompt Table: %GP_EDIT_FLD5
UPG_LBRXER_GPES(SQL Table) |
Index Back |
|---|---|
Eligible earnings for Xtra PdsEarnings that contributes to extra periods. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SET_LAB_VLD_VW |
| 2 | LABOR_AGREEMENT |
Character(6) | VARCHAR2(6) NOT NULL | Labor Agreement |
| 3 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 4 | GPES_PYMNT_PD |
Number(2,0) | SMALLINT NOT NULL | Extra period payment period |
| 5 | GPES_PIN_ER1_NUM |
Number(8,0) | INTEGER NOT NULL |
Earning Pin Number
Prompt Table: %GP_EDIT_FLD4 |
| 6 | GPES_EARN_TYPE | Character(20) | VARCHAR2(20) NOT NULL |
Earning type: Absorbable complement, transportatio complement or seniority.
Y/N Table Edit |
| 7 | GPES_EARN_FACTOR | Number(6,2) | DECIMAL(5,2) NOT NULL | Extra period earning contribution percentage |
| 8 | GPES_PIN_AC1_NUM | Number(8,0) | INTEGER NOT NULL |
Accumulator Pin Number
Prompt Table: %GP_EDIT_FLD5 |