SETIDPrompt Table: SET_VLD_HR_14
LABOR_AGREEMENTPrompt Table: EMPL_CTG
EFFDTDefault Value: %date
GPES_PYMNT_PDA=Active
I=Inactive
Default Value: 100
005=Payment Period
010=Proration Lump Sum
015=Other Period
Default Value: 005
GPES_XTR_PD_VW(SQL View) |
Index Back |
|---|---|
Labor agreement exra pd. defs.Labor agreement extra period definitions. |
| SELECT A.SETID , A.LABOR_AGREEMENT , A.EFFDT , B.GPES_PYMNT_PD , A.EFF_STATUS , B.GPES_XTRPD_FACTOR , B.GPES_PERIOD_FROM , B.GPES_DURATION , B.GPES_YR_PRORATE , B.GPES_XTR_CALC_OPTN , B.GPES_XTR_ADV_PYMNT FROM PS_GPES_LBR_AGRMNT A , PS_GPES_LBR_XTR_PD B WHERE A.SETID = B.SETID AND A.LABOR_AGREEMENT = B.LABOR_AGREEMENT AND A.EFFDT = B.EFFDT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SET_VLD_HR_14 |
| 2 | LABOR_AGREEMENT |
Character(6) | VARCHAR2(6) NOT NULL |
Labor Agreement
Prompt Table: EMPL_CTG |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | GPES_PYMNT_PD |
Number(2,0) | SMALLINT NOT NULL | Extra period payment period |
| 5 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 6 | GPES_XTRPD_FACTOR | Number(6,2) | DECIMAL(5,2) NOT NULL |
Extra period contribution percentage
Default Value: 100 |
| 7 | GPES_PERIOD_FROM | Number(2,0) | SMALLINT NOT NULL | Extra period beginning period |
| 8 | GPES_DURATION | Number(2,0) | SMALLINT NOT NULL | Extra period timeframe duration in months |
| 9 | GPES_YR_PRORATE | Character(1) | VARCHAR2(1) NOT NULL | Prorated extra period flag |
| 10 | GPES_XTR_CALC_OPTN | Character(3) | VARCHAR2(3) NOT NULL |
Extra period calculation option
005=Payment Period 010=Proration Lump Sum 015=Other Period Default Value: 005 |
| 11 | GPES_XTR_ADV_PYMNT | Character(1) | VARCHAR2(1) NOT NULL | Stats if the extra period payment period is paid before the extra period timeframe end date. |