ACT_RSN_TBL_MEX (SQL Table)	Index Back
Action/Reason Combinations ACTN_REASON_TBL is an edit table. Use it to record combinations of action codes and the reason codes that are valid for an action. For example, two valid reasons for a termination action might be attendance and misconduct.

ACT_RSN_TBL_MEX

(SQL Table)

Action/Reason Combinations

ACTN_REASON_TBL is an edit table. Use it to record combinations of action codes and the reason codes that are valid for an action. For example, two valid reasons for a termination action might be attendance and misconduct.

Parent record: ACTN_REASON_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ACTION Character(3) VARCHAR2(3) NOT NULL Action
Prompt Table: ACTION_TBL

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

3 IMS_TER_REASON_MEX Character(4) VARCHAR2(4) NOT NULL Termination Reason Mexico
0010=N/A
0020=Agreement
0030=Lay-Off
0040=Retirement
0050=Employer Transfer
0060=Pension-Off
0070=Voluntary Resignation
0080=Leave
0090=Employee Death
0100=Mental or Physical Disability
0110=Inability
0120=Work Risk Disability
0130=Collective Termination
0140=Contract Termination
0150=Employee's Resignation
0160=Closing
0170=Anticipated End of Contract
0180=Leave of Absence

4 INF_REASON_MEX Character(4) VARCHAR2(4) NOT NULL INFONAVIT Reason Mexico
0010=Retirement
0020=Death
0030=Never Worked in the Company
0040=Other (Specify)
0050=Permanent/Partial Disability
0060=Disengage
0070=Transfer

5 SUA_REASON_MEX Character(4) VARCHAR2(4) NOT NULL SUA Reason Mexico
0010=Employee Register
0020=Employee Termination
0030=Salary Change
0040=Re-enter
0050=N/A
Default Value: 0050

6 IMS_PRN_FORM_MEX Character(4) VARCHAR2(4) NOT NULL IMSS Print Form Mexico
0010=Employee Register
0020=Employee Termination
0030=Salary Change
0040=N/A
Default Value: 0040

7 MAINT_VAR_SDI_MEX Character(1) VARCHAR2(1) NOT NULL Keep Variable SDI Mexico
Y/N Table Edit

8 SYSTEM_DATA_FLG Character(1) VARCHAR2(1) NOT NULL This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA.
Y/N Table Edit
Default Value: N

9 INTERCOMP_FLG_MEX Character(1) VARCHAR2(1) NOT NULL Intercompany Transfer Flag for Mexico
Y/N Table Edit
Default Value: N

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action Prompt Table: ACTION_TBL
2	ACTION_REASON	Character(3)	VARCHAR2(3) NOT NULL	Reason Code Prompt Table: ACTN_REASON_TBL
3	IMS_TER_REASON_MEX	Character(4)	VARCHAR2(4) NOT NULL	Termination Reason Mexico 0010=N/A 0020=Agreement 0030=Lay-Off 0040=Retirement 0050=Employer Transfer 0060=Pension-Off 0070=Voluntary Resignation 0080=Leave 0090=Employee Death 0100=Mental or Physical Disability 0110=Inability 0120=Work Risk Disability 0130=Collective Termination 0140=Contract Termination 0150=Employee's Resignation 0160=Closing 0170=Anticipated End of Contract 0180=Leave of Absence
4	INF_REASON_MEX	Character(4)	VARCHAR2(4) NOT NULL	INFONAVIT Reason Mexico 0010=Retirement 0020=Death 0030=Never Worked in the Company 0040=Other (Specify) 0050=Permanent/Partial Disability 0060=Disengage 0070=Transfer
5	SUA_REASON_MEX	Character(4)	VARCHAR2(4) NOT NULL	SUA Reason Mexico 0010=Employee Register 0020=Employee Termination 0030=Salary Change 0040=Re-enter 0050=N/A Default Value: 0050
6	IMS_PRN_FORM_MEX	Character(4)	VARCHAR2(4) NOT NULL	IMSS Print Form Mexico 0010=Employee Register 0020=Employee Termination 0030=Salary Change 0040=N/A Default Value: 0040
7	MAINT_VAR_SDI_MEX	Character(1)	VARCHAR2(1) NOT NULL	Keep Variable SDI Mexico Y/N Table Edit
8	SYSTEM_DATA_FLG	Character(1)	VARCHAR2(1) NOT NULL	This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA. Y/N Table Edit Default Value: N
9	INTERCOMP_FLG_MEX	Character(1)	VARCHAR2(1) NOT NULL	Intercompany Transfer Flag for Mexico Y/N Table Edit Default Value: N