|
|
PARTBEN FILE
COBRA Participant Benefit
The COBRA Participant Benefit file contains benefit records for COBRA
participants and retirees.
REFERENCED BY
BN00.1 BN100 BN101 BN102 BN103 BN230
BN31.1 BN31.2 BN32.1 BN32.2 BN32.3 BN320
BN321 BN531 BN532 BN80.1 BS32.1 HR13.3
HR13.4 HR13.5 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 BN331 BN233
BN180 BN70.1 BN77.1 BN90.1
UPDATED BY
BN105 BN175 BN430 BN71.1 BN72.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PTB-COMPANY Numeric 4 BN105 BN71.1
Company Contains the company number. BN72.1
PTB-PLAN-TYPE Alpha 2 BN105 BN71.1
Type This field contains the code that BN72.1
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
PTB-PLAN-CODE Alpha 4 BN105 BN71.1
Plan The user-defined code used to represent BN72.1
a specific benefit plan.
PTB-PARTICIPNT Numeric 9 BN105 BN331
Participant Number This is the COBRA participant's number. BN71.1 BN72.1
This is not the same as the employee
number. If this record is for a
retiree, this field is blank.
PTB-EMPLOYEE Numeric 9 BN105 BN71.1
Employee Contains the employee number. BN72.1
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.
PTB-START-DATE Numeric 8 (yyyymmdd) BN105 BN71.1
Start Date This is the benefit start date. BN72.1
It determines when premium/invoicing
begins for the participant/employee.
PTB-STOP-DATE Numeric 8 (yyyymmdd) BN105 BN175
Stop Date This field indicates when the BN71.1 BN72.1
participant/retiree terminates or
switches coverage. This field also is
used to terminate premium invoicing.
PTB-COV-OPTION Numeric 2 BN105 BN71.1
Coverage Option This field selects the plan and BN72.1
coverage type desired by the
participant/retiree.
PTB-COVER-AMT Signed 11.2 BN105 BN71.1
Flat Amount This field specifies the coverage BN72.1
amount. The system uses this field to
calculate the premium for the desired
coverage amount. The user enters the
coverage amount.
PTB-DEP-COVER-AMT Signed 11.2
Dep Cover Amt
PTB-COMP-CONT Signed 7.2 BN105 BN71.1
Company Contribution This is the company contribution for BN72.1
retiree premiums.
PTB-EMP-AFT-CONT Signed 7.2 BN105 BN71.1
Employee After Tax This is the Retiree or COBRA BN72.1
Contrib contribution amount.
PTB-EXC-PREM-AMT Signed 7.2
Excess Premium This is the excess premium amount for
Amount COBRA participants (holds the surcharge
for administrative costs).
PTB-PAY-PER-AMT Signed 7.2 BN105 BN71.1
Pay Per Amt Contains the monthly contribution BN72.1
amount for spending accounts. This field
is used only for COBRA participants.
PTB-ANNUAL-AMT Signed 9.2 BN105 BN71.1
Annual Amt Contains the annual contribution for BN72.1
spending accounts. This field is used
only for COBRA participants.
PTB-SMOKER Alpha 1 BN105 BN71.1
Smoker Indicates if the participant is a BN72.1
smoker.
PTB-PREM-UPD-DT Numeric 8 (yyyymmdd) BN105 BN71.1
Premium Update Date Contains the most recent start date. BN72.1
PTB-PREM-GROUP Alpha 10 BN105 BN71.1
Prem Group Contains the employee group name of the BN72.1
contribution record for retiree or COBRA
benefits.
PTB-COV-UPD-DT Numeric 8 (yyyymmdd) BN105 BN71.1
Cov Upd Dt Contains the start date of the coverage BN72.1
record used for this benefit.
PTB-CNT-AGE-DATE Numeric 8 (yyyymmdd)
Cnt Age Date
PTB-COV-GROUP Alpha 10 BN105 BN71.1
Cov Group Contains the employee group name of the BN72.1
coverage record for retiree and COBRA
benefits.
PTB-CREATION-DATE Numeric 8 (yyyymmdd) BN105 BN71.1
Creation Date This is the date that this line was BN72.1
added to the requisition.
PTB-UPD-DATE Numeric 8 (yyyymmdd) BN105 BN71.1
Upd Date Contains the date the retiree or COBRA BN72.1
benefits were updated.
PTB-MO-COMP-CONT Derived
Mo Comp Cont
PTB-MO-EMP-AFT Derived
Mo Emp Aft
PTB-MO-EXC-PREM Derived
Mo Exc Prem
PTB-MO-TOT-EMP Derived
Mo Tot Emp
PTB-TOT-EMP-PREM Derived
Tot Emp Prem
PTB-PLAN-TYPE-2 Derived
Plan Type 2
PARTBEN FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PTBSET1 COMPANY BN00.1 BN100
PLAN-TYPE BN101 BN102
PARTICIPNT BN103 BN105
EMPLOYEE BN175 BN230
START-DATE BN31.1 BN31.2
PLAN-CODE BN32.1 BN32.2
BN32.3 BN320
BN321 BN430
BN531 BN532
BN71.1 BN72.1
BN80.1 BS32.1
HR13.3 HR13.4
HR13.5
PTBSET2 COMPANY BN02.1 BN02.2
PLAN-TYPE BN02.3 BN02.4
PLAN-CODE BN02.5 BN105
PARTICIPNT BN15.1 BN17.1
EMPLOYEE BN17.2 BN17.3
START-DATE* BN18.1 BN18.2
BN18.3 BN18.4
BN18.5 BN18.6
BN18.7 BN19.1
BN19.2 BN19.3
BN19.4 BN331
PTBSET3 COMPANY KeyChange BN15.1 BN18.1
PLAN-TYPE BN18.2 BN18.3
PLAN-CODE BN18.4 BN18.5
PREM-UPD-DT BN18.6 BN18.7
PREM-GROUP BN19.1 BN19.2
EMPLOYEE BN19.3 BN19.4
PARTICIPNT
START-DATE
PTBSET4 COMPANY KeyChange BN105 BN233
PARTICIPNT BN331 BN71.1
EMPLOYEE BN72.1
PLAN-TYPE
PLAN-CODE
START-DATE*
PTBSET5 COMPANY KeyChange BN105 BN180
EMPLOYEE BN70.1 BN71.1
PARTICIPNT BN72.1 BN77.1
PLAN-TYPE BN90.1 HR13.5
PLAN-CODE
START-DATE
PARTBEN FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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
And PTB-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 RELATED
NAME 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
|