W3EB_LE_STATE92 (SQL Table)	Index Back
Life Events State Record This record is used to store application state data within eBenefits Life Events. Since the Activity Guide does not allow us to store application data in the Activity State record (PSACTIVITYLOG), we use this record to save application data needed when the user returns to the Life Events application after logging out.

W3EB_LE_STATE92

(SQL Table)

Life Events State Record

This record is used to store application state data within eBenefits Life Events. Since the Activity Guide does not allow us to store application data in the Activity State record (PSACTIVITYLOG), we use this record to save application data needed when the user returns to the Life Events application after logging out.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

3 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

4 LE_EVENTS_CATEGORY Character(4) VARCHAR2(4) NOT NULL Life Events category i.e. Employee, Spouse/Domestic Partner, Child

5 ACTION_DT_SS Date(10) DATE Termination Date

6 DATE_FROM Date(10) DATE Date From

7 DATE_TO Date(10) DATE Previous Period Date To

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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	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
4	LE_EVENTS_CATEGORY	Character(4)	VARCHAR2(4) NOT NULL	Life Events category i.e. Employee, Spouse/Domestic Partner, Child
5	ACTION_DT_SS	Date(10)	DATE	Termination Date
6	DATE_FROM	Date(10)	DATE	Date From
7	DATE_TO	Date(10)	DATE	Previous Period Date To
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.