CBR_PARTIC_PLAN

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	BENEFIT_RCD_NBR	Number(3,0)	SMALLINT NOT NULL	Specifies a sequence number associated with each of multiple concurrent jobs for a one employee. It is used to determine the applicable benefit program for each job. The first job entered for an employee is automatically assigned a Benefit Record Number of zero (0). This field is linked with EMPL_RCD#, the Employment Record Number.
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	DEPENDENT_BENEF	Character(2)	VARCHAR2(2) NOT NULL	Dependent Benefit 01=default
5	PLAN_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans.
6	BENEFIT_PROGRAM	Character(3)	VARCHAR2(3) NOT NULL	Defines a collection of benefit plans and their associated rate and calculation rules.
7	COBRA_EVENT_DT	Date(10)	DATE	COBRA Event Date
8	COBRA_EVENT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	COBRA Event Type I=Initial COBRA Event N=Not Determined S=Secondary COBRA Event
9	CBR_INIT_EVENT_ID	Number(2,0)	SMALLINT NOT NULL	COBRA Initial Event ID
10	CBR_SCND_EVENT_ID	Number(3,0)	SMALLINT NOT NULL	COBRA Second Event ID
11	INIT_BENEFIT_PGM	Character(3)	VARCHAR2(3) NOT NULL	Initial Benefit Program
12	CBR_PROCESS_STATUS	Character(1)	VARCHAR2(1) NOT NULL	COBRA Process Status C=Closed for Processing O=Open for Processing V=Void
13	CBR_ENROLL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	COBRA Enrollment Status C=Coverage Extended E=Enrolled I=Coverage Inserted N=Not Enrolled
14	CBR_PLN_REPRCS_IND	Character(1)	VARCHAR2(1) NOT NULL	COBRA Plan Reprocess Indicator E=Elect Option N=Normal Processing V=Void Plan
15	COVERAGE_BEGIN_DT	Date(10)	DATE	Coverage Begin Date
16	DISABL_CVG_BEG_DT	Date(10)	DATE	Disabled Coverage Begin Date
17	COVERAGE_END_DT	Date(10)	DATE	Coverage End Date
18	COBRA_ELECT_END_DT	Date(10)	DATE	COBRA Election Period End Date
19	COBRA_ELECT	Character(1)	VARCHAR2(1) NOT NULL	COBRA Election E=Elect W=Waive
20	COBRA_ELECT_DT	Date(10)	DATE	COBRA Election Date
21	COBRA_WAIVE_DT	Date(10)	DATE	COBRA Waive Date
22	COBRA_REVOKE_DT	Date(10)	DATE	COBRA Revoke Date
23	COBRA_TERM_DT	Date(10)	DATE	COBRA Termination Date
24	COBRA_TERM_REASON	Character(1)	VARCHAR2(1) NOT NULL	COBRA Termination Reason L=Lack of Payment N=Not Terminated V=Voluntary Termination
25	OPTION_CD	Character(3)	VARCHAR2(3) NOT NULL	Option Code Prompt Table: CBR_OPTNCD_VW
26	BENEFIT_PLAN	Character(6)	VARCHAR2(6) NOT NULL	Benefit Plan
27	COVRG_CD	Character(2)	VARCHAR2(2) NOT NULL	Coverage Code Prompt Table: COVRG_CD_TBL
28	EMPL_CONTRBUTN_AMT	Number(7,2)	DECIMAL(6,2) NOT NULL	Employee Contribution Amount
29	ANN_EX_CREDIT_FSA	Number(8,2)	DECIMAL(7,2) NOT NULL	Annual Credit Rollover FSA
30	ANNUAL_PLEDGE	Signed Number(10,2)	DECIMAL(8,2) NOT NULL	Annual Pledge
31	FSA_APR_AMT_YTD	Signed Number(10,2)	DECIMAL(8,2) NOT NULL	FSA Approved Amount YTD
32	FSA_PD_AMT_YTD	Signed Number(10,2)	DECIMAL(8,2) NOT NULL	FSA Paid Amount YTD
33	FSA_SUB_AMT_YTD	Signed Number(10,2)	DECIMAL(8,2) NOT NULL	FSA Submitted Amount YTD
34	COBRA_ERROR	Character(1)	VARCHAR2(1) NOT NULL	COBRA Error Y/N Table Edit
35	HLTH_PROVIDER_ID	Character(30)	VARCHAR2(30) NOT NULL	Health Provider ID
36	PREVIOUSLY_SEEN	Character(1)	VARCHAR2(1) NOT NULL	Previously Seen Y/N Table Edit
37	OTH_INSURANCE_IND	Character(1)	VARCHAR2(1) NOT NULL	This is a yes/no flag that will indicate if the employee has an insurance other than the one provided by the employer. Y/N Table Edit Default Value: N
38	OTH_INSURANCE_NAME	Character(30)	VARCHAR2(30) NOT NULL	This edit box is directly related to the OTH_INSUR_IND field. If OTH_INSUR_IND is 'Y' then this will provide a place to put the name of the provider.