BEN_PROG_PARTIC (SQL Table)	Index Back
EE Benefit Programs EE Benefit Programs. Currently no reference to this record.

BEN_PROG_PARTIC

(SQL Table)

EE Benefit Programs

EE Benefit Programs. Currently no reference to this record.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL field used in HD_360_RESPONSE_SYNC message.

3 COBRA_EVENT_ID Number(3,0) SMALLINT NOT NULL Uniquely identifies a COBRA event within an employee's benefits records, and is system-generated.

4 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

5 BENEFIT_PROGRAM Character(3) VARCHAR2(3) NOT NULL Defines a collection of benefit plans and their associated rate and calculation rules.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	field used in HD_360_RESPONSE_SYNC message.
3	COBRA_EVENT_ID	Number(3,0)	SMALLINT NOT NULL	Uniquely identifies a COBRA event within an employee's benefits records, and is system-generated.
4	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
5	BENEFIT_PROGRAM	Character(3)	VARCHAR2(3) NOT NULL	Defines a collection of benefit plans and their associated rate and calculation rules.