GPBR_TER_ACTRSN (SQL Table)	Index Back
Termination Action/Reason Bra GPBR_TER_ACTRSN Use it to record combinations of action and reason codes with the coorresponding Termination Version and Tremination/Layoff

GPBR_TER_ACTRSN

(SQL Table)

Termination Action/Reason Bra

GPBR_TER_ACTRSN Use it to record combinations of action and reason codes with the coorresponding Termination Version and Tremination/Layoff

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GPBR_TERM_VERSION Character(10) VARCHAR2(10) NOT NULL Termination Version

2 ACTION Character(3) VARCHAR2(3) NOT NULL Action
Prompt Table: GPBR_ACTN_RSN_V

3 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code
Prompt Table: ACTN_REASON_TBL

4 GPBR_TERM_TYPE Character(4) VARCHAR2(4) NOT NULL Termination Reason for Termination Process Brazil
01=Employer Decision Fair Cause
02=Employer Decision Unfair Cause
03=Employee Decision Fair Cause
04=Employee Decision Unfair Cause
05=Transfer Without Onus
06=Transfer With Onus
07=Transfer Reform for Reserves
08=Death
09=Other Cause
10=Contract Termination
11=Retirement by Service Time
12=Retire by Disability, Work Acc
13=Retire by Disability, Sickness
14=Mutual Fault
15=Ret. by ServTime /Contract Ter
16=Retirement by Age
17=Compulsory Retirement
18=Work Regime Change
19=Death by Work Related Accident
20=Death by Professional Sickness
21=Ret. with Continued Employment
22=Indirect Termination
23=Payee's Anticipated Breach
24=Major Causes
25=Employer's Ant Breach - Unfair
26=Employer's Ant Breach - Fair
27=Closing Down of Establishment

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GPBR_TERM_VERSION	Character(10)	VARCHAR2(10) NOT NULL	Termination Version
2	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action Prompt Table: GPBR_ACTN_RSN_V
3	ACTION_REASON	Character(3)	VARCHAR2(3) NOT NULL	Reason Code Prompt Table: ACTN_REASON_TBL
4	GPBR_TERM_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Termination Reason for Termination Process Brazil 01=Employer Decision Fair Cause 02=Employer Decision Unfair Cause 03=Employee Decision Fair Cause 04=Employee Decision Unfair Cause 05=Transfer Without Onus 06=Transfer With Onus 07=Transfer Reform for Reserves 08=Death 09=Other Cause 10=Contract Termination 11=Retirement by Service Time 12=Retire by Disability, Work Acc 13=Retire by Disability, Sickness 14=Mutual Fault 15=Ret. by ServTime /Contract Ter 16=Retirement by Age 17=Compulsory Retirement 18=Work Regime Change 19=Death by Work Related Accident 20=Death by Professional Sickness 21=Ret. with Continued Employment 22=Indirect Termination 23=Payee's Anticipated Breach 24=Major Causes 25=Employer's Ant Breach - Unfair 26=Employer's Ant Breach - Fair 27=Closing Down of Establishment