SETIDLABOR_AGREEMENTEFFDTDefault Value: %Date
GPES_PYMNT_PDGPES_PIN_ER1_NUMPrompt Table: %GP_EDIT_FLD4
Default Value: 100
GPES_NRP_XT1_VW(SQL View) |
Index Back |
|---|---|
Eligible earnings for Xtra PdsEligible earnings for Xtra Pds, for non-rule packager export view |
| SELECT SETID ,LABOR_AGREEMENT ,EFFDT ,GPES_PYMNT_PD ,GPES_PIN_ER1_NUM + 50000000 ,GPES_EARN_TYPE ,GPES_EARN_FACTOR ,GPES_PIN_AC1_NUM + 50000000 FROM PS_GPES_LBR_XTRPER |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | LABOR_AGREEMENT |
Character(6) | VARCHAR2(6) NOT NULL | Labor Agreement |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %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. |
| 7 | GPES_EARN_FACTOR | Number(6,2) | DECIMAL(5,2) NOT NULL |
Extra period earning contribution percentage
Default Value: 100 |
| 8 | GPES_PIN_AC1_NUM | Number(8,0) | INTEGER NOT NULL | Accumulator Pin Number |