GPES_NRP_ER1_AD(SQL Table) |
Index Back |
|---|---|
ERE Finalization actionsERE Finalization actions |
| # | 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 | ERE_U_ACTN_TYP_ESP |
Character(1) | VARCHAR2(1) NOT NULL |
ERE Update action type
D=Daily Hours Reduction P=Permanent S=Suspension W=Work Day Reduction |
| 3 | ERE_TERM_RSN_ESP | Character(4) | VARCHAR2(4) NOT NULL |
Termination Reason
AF97=Objective innap. after 97 BF97=Objective innap. before 97 COLL=Collective dismissal COMP=Non-fulfillment by employer DIIN=Disciplinary innappropiate DISC=Disciplinary OBJE=Objective TEMP=End of temporary contract VOLU=Voluntary |
| 4 | ACTION | Character(3) | VARCHAR2(3) NOT NULL | Action |
| 5 | ACTION_REASON | Character(3) | VARCHAR2(3) NOT NULL | Reason Code |
| 6 | PIN_TAKE_NUM | Number(8,0) | INTEGER NOT NULL | Absence Take |