ACTN_REASON_TBL (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.

ACTN_REASON_TBL

(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.

Related Language Record: ACTN_RSN_LANG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ACTION Character(3) VARCHAR2(3) NOT NULL Action

2 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code

3 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
Default Value: A

5 DESCR Character(30) VARCHAR2(30) NOT NULL Description

6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

7 BEN_STATUS Character(4) VARCHAR2(4) NOT NULL Specifies an employee's status relative to benefits, and is used to determine eligibility for benefits. Some examples of benefit status are Active, Suspended, Leave with Benefits, and Terminated.
A=Active
D=Deceased
L=Leave of Absence
P=Leave With Benefits
Q=Retired With Benefits
R=Retired
S=Suspended
T=Terminated
U=Terminated With Benefits
Default Value: A

8 BAS_ACTION Character(3) VARCHAR2(3) NOT NULL Identifies a benefits-related process or event that is associated with a personnel action action reason combination. This provides the link between various personnel changes (both job-related and personal) and benefits eligibility. A BAS (PeopleSoft Benefits Administration System) action may correspond to a BAS Event Class, which defines how a benefits-related event is recognized and handled. Some examples of BAS actions (and event classes) are Hire, Family Status Change, and Open Enrollment.

9 COBRA_ACTION Character(3) VARCHAR2(3) NOT NULL Identifies a COBRA-related process or event that is associated with a personnel action action reason combination. This provides the link between various personnel changes (both job-related and personal) and COBRA benefits eligibility. A COBRA action may correspond to a COBRA event classification, which defines how a qualifying event is recognized and handled. Some examples of COBRA actions (and qualifying events) are Death, Divorce, Medicare, and Military Leave. U.S. only.

10 ROE_REASON Character(1) VARCHAR2(1) NOT NULL Canadian ROE Reason
Default Value: K

11 WRKS_CNCL_APPR_GER Character(1) VARCHAR2(1) NOT NULL Works Council Approval
Y/N Table Edit
Default Value: N

12 SPK_MAN_APPR_GER Character(1) VARCHAR2(1) NOT NULL Spokesmen Committee Approval
Y/N Table Edit
Default Value: N

13 COMP_DR_APPR_GER Character(1) VARCHAR2(1) NOT NULL Company Doctor's Approval
Y/N Table Edit
Default Value: N

14 DECISIONGRP_GER Character(3) VARCHAR2(3) NOT NULL Works Council Decision Group

15 GVT_JOB_BAS_ACTVTY Character(1) VARCHAR2(1) NOT NULL Trigger JOB BAS Activity
Y/N Table Edit
Default Value: Y

16 BN_MJ_WORKFLOW Character(1) VARCHAR2(1) NOT NULL Workflow Enabled for Benefits
Default Value: N

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action
2	ACTION_REASON	Character(3)	VARCHAR2(3) NOT NULL	Reason Code
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
6	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
7	BEN_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Specifies an employee's status relative to benefits, and is used to determine eligibility for benefits. Some examples of benefit status are Active, Suspended, Leave with Benefits, and Terminated. A=Active D=Deceased L=Leave of Absence P=Leave With Benefits Q=Retired With Benefits R=Retired S=Suspended T=Terminated U=Terminated With Benefits Default Value: A
8	BAS_ACTION	Character(3)	VARCHAR2(3) NOT NULL	Identifies a benefits-related process or event that is associated with a personnel action action reason combination. This provides the link between various personnel changes (both job-related and personal) and benefits eligibility. A BAS (PeopleSoft Benefits Administration System) action may correspond to a BAS Event Class, which defines how a benefits-related event is recognized and handled. Some examples of BAS actions (and event classes) are Hire, Family Status Change, and Open Enrollment.
9	COBRA_ACTION	Character(3)	VARCHAR2(3) NOT NULL	Identifies a COBRA-related process or event that is associated with a personnel action action reason combination. This provides the link between various personnel changes (both job-related and personal) and COBRA benefits eligibility. A COBRA action may correspond to a COBRA event classification, which defines how a qualifying event is recognized and handled. Some examples of COBRA actions (and qualifying events) are Death, Divorce, Medicare, and Military Leave. U.S. only.
10	ROE_REASON	Character(1)	VARCHAR2(1) NOT NULL	Canadian ROE Reason Default Value: K
11	WRKS_CNCL_APPR_GER	Character(1)	VARCHAR2(1) NOT NULL	Works Council Approval Y/N Table Edit Default Value: N
12	SPK_MAN_APPR_GER	Character(1)	VARCHAR2(1) NOT NULL	Spokesmen Committee Approval Y/N Table Edit Default Value: N
13	COMP_DR_APPR_GER	Character(1)	VARCHAR2(1) NOT NULL	Company Doctor's Approval Y/N Table Edit Default Value: N
14	DECISIONGRP_GER	Character(3)	VARCHAR2(3) NOT NULL	Works Council Decision Group
15	GVT_JOB_BAS_ACTVTY	Character(1)	VARCHAR2(1) NOT NULL	Trigger JOB BAS Activity Y/N Table Edit Default Value: Y
16	BN_MJ_WORKFLOW	Character(1)	VARCHAR2(1) NOT NULL	Workflow Enabled for Benefits Default Value: N