W3EB_LE_RULES

(SQL Table)

# 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 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

3 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

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

5 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

6 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

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

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

#	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	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
3	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
4	PROOF_REQ_IND	Character(1)	VARCHAR2(1) NOT NULL	Proof Required Y/N Table Edit Default Value: Y
5	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
6	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
7	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.
8	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.