GPES_STA_TERM(SQL Table) |
Index Back |
|---|---|
Statutory Termination DataStatutory data for terminations |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  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 |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | GPES_INDM_DAYS | Number(3,0) | SMALLINT NOT NULL | Days/Year |
| 4 | GPES_MAX_PRDS | Number(3,0) | SMALLINT NOT NULL | Max. Periods |