W3EB_SVEMP_SRCH (SQL View)	Index Back
Ben PlanType Enrollmnt Control BENEFITS_PARTIC is a record that contains information on employee enrollments in a benefit plan type. The record is used by the Benefit Enrollment panels. They are either entered online by the Base Benefits system, or by the batch processes BASOELOD and BASEMLOD during Benefits Administration processing. The records can be rebuilt using the PARTIC sql script.

W3EB_SVEMP_SRCH

(SQL View)

Ben PlanType Enrollmnt Control

BENEFITS_PARTIC is a record that contains information on employee enrollments in a benefit plan type. The record is used by the Benefit Enrollment panels. They are either entered online by the Base Benefits system, or by the batch processes BASOELOD and BASEMLOD during Benefits Administration processing. The records can be rebuilt using the PARTIC sql script.

SELECT DISTINCT (P.EMPLID) , O.OPRID FROM PS_BENEFIT_PARTIC P , PSOPRDEFN O WHERE P.EMPLID = O.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERSON

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).