W3EB_LE_STATE (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_STATE

(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 ACTIVITYNAME Character(30) VARCHAR2(30) NOT NULL Name of a Business Process Activity (see PSACTIVITYDEFN).

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

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 ACTION_DT_SS Date(10) DATE Termination Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ACTIVITYNAME	Character(30)	VARCHAR2(30) NOT NULL	Name of a Business Process Activity (see PSACTIVITYDEFN).
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
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	ACTION_DT_SS	Date(10)	DATE	Termination Date