SETIDLABOR_AGREEMENTPrompt Table: EMPL_CTG
EFFDTDefault Value: %date
A=Active
I=Inactive
Default Value: A
Y/N Table Edit
Default Value: N
GPES_NRP_SE3_VW(SQL View) |
Index Back |
|---|---|
Labor agreement general dataLabor agreement general data, for non-rule packager export view |
| SELECT SETID ,LABOR_AGREEMENT ,EFFDT ,EFF_STATUS ,GPES_SEN_CONSL ,GPES_NEXT_EFFDT ,GPES_ENT_TYPE_SE1 ,GPES_PIN_SE1_NUM + 50000000 ,GPES_PIN_SS1_NUM + 50000000 ,GPES_PIN_TR1_NUM + 50000000 ,GPES_PIN_TR2_NUM + 50000000 ,GPES_PIN_TR3_NUM + 50000000 FROM PS_GPES_LBR_AGRMNT |
| # | 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
Prompt Table: EMPL_CTG |
| 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 Default Value: A |
| 5 | GPES_SEN_CONSL | Character(1) | VARCHAR2(1) NOT NULL |
Seniority consolidation flag
Y/N Table Edit Default Value: N |
| 6 | GPES_NEXT_EFFDT | Date(10) | DATE | Effective date value of the next row |
| 7 | GPES_ENT_TYPE_SE1 | Character(3) | VARCHAR2(3) NOT NULL | Seniority duration entry type |
| 8 | GPES_PIN_SE1_NUM | Number(8,0) | INTEGER NOT NULL | Seniority Calculation rule Pin Number |
| 9 | GPES_PIN_SS1_NUM | Number(8,0) | INTEGER NOT NULL | This field houses the Employer SS Accumulator Pin Number. |
| 10 | GPES_PIN_TR1_NUM | Number(8,0) | INTEGER NOT NULL | Pre-advised Daily Salary |
| 11 | GPES_PIN_TR2_NUM | Number(8,0) | INTEGER NOT NULL | Severance Daily Salary |
| 12 | GPES_PIN_TR3_NUM | Number(8,0) | INTEGER NOT NULL | Job Litigation Daily Salary |