PARTBEN

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

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PTBSET1 COMPANY
PLAN-TYPE
PARTICIPNT
EMPLOYEE
START-DATE
PLAN-CODE
...
BN00.1 BN100
BN101 BN102
BN103 BN105
BN106 BN175
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN320
BN321 BN430
BN53.1 BN531
BN532 BN71.1
BN72.1 BN80.1
BN991 BS32.1
XB500 XB510
XB520 HR13.1
HR13.2 HR13.3
PTBSET2 COMPANY
PLAN-TYPE
PLAN-CODE
PARTICIPNT
EMPLOYEE
START-DATE*
BN02.1 BN02.2
BN02.3 BN02.4
BN02.5 BN105
BN106 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
HR13.1 HR513
PA218
PTBSET3 COMPANY
PLAN-TYPE
PLAN-CODE
PREM-UPD-DT
PREM-GROUP
EMPLOYEE
PARTICIPNT
START-DATE
KeyChange
BN15.1 BN18.1
BN18.2 BN18.3
BN18.4 BN18.5
BN18.6 BN18.7
BN19.1 BN19.2
BN19.3 BN19.4
BN320
PTBSET4 COMPANY
PARTICIPNT
EMPLOYEE
PLAN-TYPE
PLAN-CODE
START-DATE*
KeyChange
BN105 BN233
BN331 BN71.1
BN72.1
PTBSET5 COMPANY
EMPLOYEE
PARTICIPNT
PLAN-TYPE
PLAN-CODE
START-DATE
KeyChange
BN100 BN101
BN102 BN103
BN105 BN180
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN531
BN532 BN70.1
BN71.1 BN72.1
BN77.1 BN90.1
BS32.1 HR13.1
HR13.2 HR13.3
HR13.4 HR513
PA218


PARTBEN FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Bncovopt BNCOVOPT Not Required
PTB-COMPANY->COP-COMPANY
PTB-PLAN-TYPE->COP-PLAN-TYPE
PTB-PLAN-CODE->COP-PLAN-CODE
PTB-COV-OPTION->COP-COVERAGE-OPT
Company BNCOMPANY Required
PTB-COMPANY->BNC-COMPANY
Company Name PRSYSTEM Required
PTB-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Contrib Group PERSGROUP Not Required
PTB-COMPANY->PRG-COMPANY
PTB-PREM-GROUP->PRG-GROUP-NAME
Coverage Group PERSGROUP Not Required
PTB-COMPANY->PRG-COMPANY
PTB-COV-GROUP->PRG-GROUP-NAME
Employee EMPLOYEE Required
When PTB-EMPLOYEE !=Zeroes
AndPTB-PARTICIPNT =Zeroes
PTB-COMPANY->EMP-COMPANY
PTB-EMPLOYEE->EMP-EMPLOYEE
Participant PARTICIPNT Required
When PTB-PARTICIPNT !=Zeroes
PTB-COMPANY->PAR-COMPANY
PTB-PARTICIPNT->PAR-PARTICIPNT
Plan PLAN Required
PTB-COMPANY->PLN-COMPANY
PTB-PLAN-TYPE->PLN-PLAN-TYPE
PTB-PLAN-CODE->PLN-PLAN-CODE
Ret Cont Group PREMIUM Not Required
PTB-COMPANY->PRE-COMPANY
PTB-PLAN-TYPE->PRE-PLAN-TYPE
PTB-PLAN-CODE->PRE-PLAN-CODE
"R"->PRE-COVER-TYPE
PTB-START-DATE->PRE-START-DATE
PTB-PREM-GROUP->PRE-GROUP-NAME
Ret Cov Group BNCOVERAGE Not Required
PTB-COMPANY->CVR-COMPANY
PTB-PLAN-TYPE->CVR-PLAN-TYPE
PTB-PLAN-CODE->CVR-PLAN-CODE
"R"->CVR-COVER-TYPE
PTB-START-DATE->CVR-START-DATE
PTB-COV-GROUP->CVR-GROUP-NAME


PARTBEN FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Hrdepben HRDEPBEN
PTB-COMPANY->HDB-COMPANY
PTB-EMPLOYEE->HDB-EMPLOYEE
PTB-PLAN-TYPE->HDB-PLAN-TYPE
PTB-PLAN-CODE->HDB-PLAN-CODE
PTB-START-DATE->HDB-EMP-START
  HDB-DEPENDENT
  HDB-START-DATE


File created: Wed Jun 08 20:48:08 2016

Home
Contact Us



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