GPES_LBR_TERM(SQL Table) |
Index Back |
|---|---|
Termination DataLabor Agreement Termination Data |
| # | 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_TERM_RSN |
Character(4) | VARCHAR2(4) NOT NULL |
Termination Reason
AF97=Objective innap. after 97 BF97=Objective innap. before 97 CHNG=Changes in Labor conditions COLL=Collective dismissal COMP=Non-fulfillment by employer DIIN=Disciplinary innappropiate DISC=Disciplinary OBIN=Objective Innap. RDL 3/2012 OBJE=Objective TEMP=End of temporary contract VOLU=Voluntary |
| 5 | GPES_INDM_DAYS | Number(3,0) | SMALLINT NOT NULL | Days/Year |
| 6 | GPES_MAX_PRDS | Number(3,0) | SMALLINT NOT NULL | Max. Periods |