ACT_RSN_TBL_NA (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_NA

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

# 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 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

4 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

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

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

7 BN_MJ_WORKFLOW Character(1) VARCHAR2(1) NOT NULL Indicates (Y or N) whether a workflow to the Benefits Administrator should be initiated for a Job action that may have an impact on the determination of an employee's primary job for benefits.
Y/N Table Edit
Default Value: N

8 ROE_REASON Character(1) VARCHAR2(1) NOT NULL Canadian ROE Reason
A=Shortage of Work
B=Strike or Lockout
C=Return to School
D=Illness or Injury
E=Quit
F=Pregnancy/Adoption
G=Retirement Under Age 65
H=Work-Sharing
J=Apprentice Training
K=Other
L=Age 65
M=Dismissed
N=Leave of Absence
P=Parental
Z=Compassionate Care Leave
Default Value: K

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

10 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

#	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	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	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
5	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.
6	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.
7	BN_MJ_WORKFLOW	Character(1)	VARCHAR2(1) NOT NULL	Indicates (Y or N) whether a workflow to the Benefits Administrator should be initiated for a Job action that may have an impact on the determination of an employee's primary job for benefits. Y/N Table Edit Default Value: N
8	ROE_REASON	Character(1)	VARCHAR2(1) NOT NULL	Canadian ROE Reason A=Shortage of Work B=Strike or Lockout C=Return to School D=Illness or Injury E=Quit F=Pregnancy/Adoption G=Retirement Under Age 65 H=Work-Sharing J=Apprentice Training K=Other L=Age 65 M=Dismissed N=Leave of Absence P=Parental Z=Compassionate Care Leave Default Value: K
9	GVT_JOB_BAS_ACTVTY	Character(1)	VARCHAR2(1) NOT NULL	Trigger JOB BAS Activity Y/N Table Edit Default Value: Y
10	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