GPES_NRP_ER1_VW

(SQL View)
Index Back

ERE Finalization actions

ERE 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