GP_PKG_IDSETIDLABOR_AGREEMENTEFFDTA=Active
I=Inactive
GPES_NRP_SE3_AD(SQL Table) |
Index Back |
|---|---|
Labor agreement general dataLabor agreement general data |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GP_PKG_ID |
Character(10) | VARCHAR2(10) NOT NULL | Field used for element packaging |
| 2 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 3 | LABOR_AGREEMENT |
Character(6) | VARCHAR2(6) NOT NULL | Labor Agreement |
| 4 | EFFDT |
Date(10) | DATE | Effective Date |
| 5 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 6 | GPES_SEN_CONSL | Character(1) | VARCHAR2(1) NOT NULL | Seniority consolidation flag |
| 7 | GPES_NEXT_EFFDT | Date(10) | DATE | Effective date value of the next row |
| 8 | GPES_ENT_TYPE_SE1 | Character(3) | VARCHAR2(3) NOT NULL | Seniority duration entry type |
| 9 | GPES_PIN_SE1_NUM | Number(8,0) | INTEGER NOT NULL | Seniority Calculation rule Pin Number |
| 10 | GPES_PIN_SS1_NUM | Number(8,0) | INTEGER NOT NULL | This field houses the Employer SS Accumulator Pin Number. |
| 11 | GPES_PIN_TR1_NUM | Number(8,0) | INTEGER NOT NULL | Pre-advised Daily Salary |
| 12 | GPES_PIN_TR2_NUM | Number(8,0) | INTEGER NOT NULL | Severance Daily Salary |
| 13 | GPES_PIN_TR3_NUM | Number(8,0) | INTEGER NOT NULL | Job Litigation Daily Salary |