GPES_NRP_ER1_VW(SQL View) |
Index Back |
---|---|
ERE Finalization actionsERE Finalization actions |
SELECT ERE_U_ACTN_TYP_ESP , ERE_TERM_RSN_ESP , ACTION , ACTION_REASON , PIN_TAKE_NUM + 50000000 FROM PS_ERE_UPD_ACT_ESP |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | 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 Default Value: P |
2 | 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 |
3 | ACTION | Character(3) | VARCHAR2(3) NOT NULL |
Action
Prompt Table: ACTION_TBL |
4 | ACTION_REASON | Character(3) | VARCHAR2(3) NOT NULL |
Reason Code
Prompt Table: ACTN_REASON_TBL |
5 | PIN_TAKE_NUM | Number(8,0) | INTEGER NOT NULL |
Absence Take
Prompt Table: GP_PIN_AT0_VW |