GPES_EST_XTR_VW(SQL View) |
Index Back |
---|---|
Extra per for Earn&Ded assignmExtra periods for a earning that is entered through Earnings&Deductions assignment. |
SELECT X.SETID , X.LABOR_AGREEMENT , X.EFFDT , X.EFF_STATUS , P.GPES_PYMNT_PD , P.GPES_PIN_ER1_NUM , P.GPES_EARN_FACTOR , P.GPES_PIN_AC1_NUM , L.GPES_YR_PRORATE , L.GPES_PERIOD_FROM , L.GPES_DURATION , L.GPES_XTR_ADV_PYMNT FROM PS_GPES_LBR_AGRMNT X , PS_GPES_LBR_XTRPER P , PS_GPES_LBR_XTR_PD L WHERE X.SETID = P.SETID AND X.LABOR_AGREEMENT = P.LABOR_AGREEMENT AND X.EFFDT = P.EFFDT AND L.SETID = P.SETID AND L.LABOR_AGREEMENT = P.LABOR_AGREEMENT AND L.EFFDT = P.EFFDT AND L.GPES_PYMNT_PD = P. GPES_PYMNT_PD |
# | 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 |
Effective Date
Default Value: %date |
4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
5 | GPES_PYMNT_PD | Number(2,0) | SMALLINT NOT NULL | Extra period payment period |
6 | GPES_PIN_ER1_NUM | Number(8,0) | INTEGER NOT NULL | Earning Pin Number |
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 |
9 | GPES_YR_PRORATE | Character(1) | VARCHAR2(1) NOT NULL | Prorated extra period flag |
10 | GPES_PERIOD_FROM | Number(2,0) | SMALLINT NOT NULL | Extra period beginning period |
11 | GPES_DURATION | Number(2,0) | SMALLINT NOT NULL | Extra period timeframe duration in months |
12 | 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. |