W3EB_LE_RULES

(SQL Table)

Related Language Record: W3EB_LE_RL_LANG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LIFE_EVENT_TYPE Character(3) VARCHAR2(3) NOT NULL Type of Life Event (e.g. Birth, Adoption, Marriage)
A=Adoption
B=Birth
D=Divorce
M=Marriage

2 DESCR20 Character(20) VARCHAR2(20) NOT NULL Description

3 NOTIFY_ADMIN Character(1) VARCHAR2(1) NOT NULL Y/N flag indicating whether the Benefits Administrator should be notified of the event.
Y/N Table Edit
Default Value: Y

4 DAYS_TO_NOTIFY Number(3,0) SMALLINT NOT NULL Used in eBenefits Life Events. The maximum number of days that may elapse between the event date, and the date it is processed.
Default Value: 31

5 PROOF_REQ_IND Character(1) VARCHAR2(1) NOT NULL Proof Required
Y/N Table Edit
Default Value: Y

6 APPR_DOC_FILING Character(1) VARCHAR2(1) NOT NULL Approve Dpcument Filing for the Life Event process
Y/N Table Edit
Default Value: N

7 CREATE_EVENT Character(1) VARCHAR2(1) NOT NULL Used in eBenefits Life Events. User-defined parameter defining whether a Benefits Administration event can be created from the Life Events application.
Y/N Table Edit
Default Value: N

8 BAS_ACTION_SOURCE Character(2) VARCHAR2(2) NOT NULL Source of Action
BP=Benefits Person
EX=Multijob Trigger Explosion
ME=Manual Event
MJ=MultiJob Indicator Change
OE=Open Enrollment
PB=Passive Event Birthdate
PS=Passive Event Service Date
SN=Snapshot
TJ=Job Data Change
TL=Union Change
TP=Address Change

9 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.
Prompt Table: BAS_EVT_CLASS

10 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.
Prompt Table: CBR_EVENT_RULES

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LIFE_EVENT_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Type of Life Event (e.g. Birth, Adoption, Marriage) A=Adoption B=Birth D=Divorce M=Marriage
2	DESCR20	Character(20)	VARCHAR2(20) NOT NULL	Description
3	NOTIFY_ADMIN	Character(1)	VARCHAR2(1) NOT NULL	Y/N flag indicating whether the Benefits Administrator should be notified of the event. Y/N Table Edit Default Value: Y
4	DAYS_TO_NOTIFY	Number(3,0)	SMALLINT NOT NULL	Used in eBenefits Life Events. The maximum number of days that may elapse between the event date, and the date it is processed. Default Value: 31
5	PROOF_REQ_IND	Character(1)	VARCHAR2(1) NOT NULL	Proof Required Y/N Table Edit Default Value: Y
6	APPR_DOC_FILING	Character(1)	VARCHAR2(1) NOT NULL	Approve Dpcument Filing for the Life Event process Y/N Table Edit Default Value: N
7	CREATE_EVENT	Character(1)	VARCHAR2(1) NOT NULL	Used in eBenefits Life Events. User-defined parameter defining whether a Benefits Administration event can be created from the Life Events application. Y/N Table Edit Default Value: N
8	BAS_ACTION_SOURCE	Character(2)	VARCHAR2(2) NOT NULL	Source of Action BP=Benefits Person EX=Multijob Trigger Explosion ME=Manual Event MJ=MultiJob Indicator Change OE=Open Enrollment PB=Passive Event Birthdate PS=Passive Event Service Date SN=Snapshot TJ=Job Data Change TL=Union Change TP=Address Change
9	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. Prompt Table: BAS_EVT_CLASS
10	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. Prompt Table: CBR_EVENT_RULES