COBRA Participant Benefit

The COBRA Participant Benefit file contains benefit records for COBRA participants and retirees.

REFERENCED BY

BN53.1

BN80.1

BN991

UPDATED BY

BN105	BN175	BN430	BN71.1	BN72.1	BN00.1
BN100	BN101	BN102	BN103	BN106	BN31.1
BN31.2	BN32.1	BN32.2	BN32.3	BN320	BN321
BN531	BN532	BS32.1	XB500	XB510	XB520
HR13.1	HR13.2	HR13.3	HR13.4	HR513	PA218
BN02.1	BN02.2	BN02.3	BN02.4	BN02.5	BN15.1
BN17.1	BN17.2	BN17.3	BN18.1	BN18.2	BN18.3
BN18.4	BN18.5	BN18.6	BN18.7	BN19.1	BN19.2
BN19.3	BN19.4	BN230	BN331	BN233	BN180
BN70.1	BN77.1	BN90.1

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
PTB-COMPANY Element: Company Hr	Numeric 4 Contains the company number.	BN105 BN71.1 BN72.1
PTB-PLAN-TYPE Element: Plan Type	Alpha 2 This field contains the code that identifies the type of benefit plan. DB = Defined Benefit DC = Defined Contribution DI = Disability DL = Dependent Life DN = Dental EL = Employee Life HL = Health RS = Reserve Account SB = Savings Bond SP = Stock Purchase VA = Vacation	BN105 BN71.1 BN72.1
PTB-PLAN-CODE Element: Plan Code	Alpha 4 The user-defined code used to represent a specific benefit plan.	BN105 BN71.1 BN72.1
PTB-PARTICIPNT Element: Participnt	Numeric 9 This is the COBRA participant's number. This is not the same as the employee number. If this record is for a retiree, this field is blank.	BN105 BN331 BN71.1 BN72.1
PTB-EMPLOYEE Element: Employee	Numeric 9 Contains the employee number. This field only has a value in it if this record is for a retiree. If the record is for a COBRA participant, this field is blank.	BN105 BN71.1 BN72.1
PTB-START-DATE Element: Start Date	Numeric 8 (yyyymmdd) This is the benefit start date. It determines when premium/invoicing begins for the participant/employee.	BN105 BN71.1 BN72.1
PTB-STOP-DATE Element: Stop Date	Numeric 8 (yyyymmdd) This field indicates when the participant/retiree terminates or switches coverage. This field also is used to terminate premium invoicing.	BN105 BN175 BN71.1 BN72.1
PTB-COV-OPTION Element: Cov Option	Numeric 2 This field selects the plan and coverage type desired by the participant/retiree.	BN105 BN71.1 BN72.1
PTB-COVER-AMT Element: Cover Amt	Signed 11.2 This field specifies the coverage amount. The system uses this field to calculate the premium for the desired coverage amount. The user enters the coverage amount.	BN105 BN71.1 BN72.1
PTB-DEP-COVER-AMT Element: Dep Cover Amt	Signed 11.2
PTB-COMP-CONT Element: Comp Cont	Signed 11.2 This is the company contribution for retiree premiums.	BN105 BN71.1 BN72.1
PTB-EMP-AFT-CONT Element: Emp Aft Cont	Signed 11.2 This is the Retiree or COBRA contribution amount.	BN105 BN71.1 BN72.1
PTB-EXC-PREM-AMT Element: Exc Prem Amt	Signed 7.2 This is the excess premium amount for COBRA participants (holds the surcharge for administrative costs).
PTB-PAY-PER-AMT Element: Pay Per Amt	Signed 7.2 Contains the monthly contribution amount for spending accounts. This field is used only for COBRA participants.	BN105 BN71.1 BN72.1
PTB-ANNUAL-AMT Element: Annual Amt	Signed 9.2 Contains the annual contribution for spending accounts. This field is used only for COBRA participants.	BN105 BN71.1 BN72.1
PTB-SMOKER Element: Smoker	Alpha 1 Indicates if the participant is a smoker.	BN105 BN71.1 BN72.1
PTB-PREM-UPD-DT Element: Prem Upd Dt	Numeric 8 (yyyymmdd) Contains the most recent start date.	BN105 BN71.1 BN72.1
PTB-PREM-GROUP Element: Prem Group	Alpha 10 Contains the employee group name of the contribution record for retiree or COBRA benefits.	BN105 BN71.1 BN72.1
PTB-COV-UPD-DT Element: Cov Upd Dt	Numeric 8 (yyyymmdd) Contains the start date of the coverage record used for this benefit.	BN105 BN71.1 BN72.1
PTB-CNT-AGE-DATE Element: Cnt Age Date	Numeric 8 (yyyymmdd)
PTB-COV-GROUP Element: Cov Group	Alpha 10 Contains the employee group name of the coverage record for retiree and COBRA benefits.	BN105 BN71.1 BN72.1
PTB-CREATION-DATE Element: Creation Date	Numeric 8 (yyyymmdd) This is the date that this line was added to the requisition.	BN105 BN71.1 BN72.1
PTB-UPD-DATE Element: Upd Date	Numeric 8 (yyyymmdd) Contains the date the retiree or COBRA benefits were updated.	BN105 BN71.1 BN72.1
PTB-MO-COMP-CONT Element: Mo Comp Cont	Derived
PTB-MO-EMP-AFT Element: Mo Emp Aft	Derived
PTB-MO-EXC-PREM Element: Mo Exc Prem	Derived
PTB-MO-TOT-EMP Element: Mo Tot Emp	Derived
PTB-TOT-EMP-PREM Element: Tot Emp Prem	Derived
PTB-PLAN-TYPE-2 Element: Plan Type 2	Derived
PTB-USER-ID Element: User	Alpha 10 (Lower Case)	BN105 BN71.1 BN72.1
PTB-TIME-STAMP Element: Time Stamp	Numeric 6 (hhmmss) Contains the server time (hour, minute, and second) when the record was last changed.	BN105 BN71.1 BN72.1
PTB-PROCESS-LEVEL Element: Process Level	Alpha 5	BN105 BN71.1 BN72.1

PARTBEN FILE INDEX

PARTBEN FILE RELATIONS

ONE TO ONE RELATIONS

PARTBEN FILE RELATIONS

ONE TO MANY RELATIONS

All trademarks and registered trademarks are the property of their respective owners.