|
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 BN106
BN31.1 BN31.2 BN32.1 BN32.2 BN32.3 BN320
BN321 BN53.1 BN531 BN532 BN80.1 BS32.1
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
UPDATED BY
BN105 BN175 BN430 BN71.1 BN72.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PTB-COMPANY Numeric 4 BN105 BN71.1
Element: Company Hr Contains the company number. BN72.1
PTB-PLAN-TYPE Alpha 2 BN105 BN71.1
Element: Plan 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
Element: Plan Code The user-defined code used to represent BN72.1
a specific benefit plan.
PTB-PARTICIPNT Numeric 9 BN105 BN331
Element: Participnt 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
Element: 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
Element: 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
Element: 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
Element: Cov 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
Element: Cover Amt 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
Element: Dep Cover Amt
PTB-COMP-CONT Signed 11.2 BN105 BN71.1
Element: Comp Cont This is the company contribution for BN72.1
retiree premiums.
PTB-EMP-AFT-CONT Signed 11.2 BN105 BN71.1
Element: Emp Aft Cont This is the Retiree or COBRA BN72.1
contribution amount.
PTB-EXC-PREM-AMT Signed 7.2
Element: Exc Prem Amt This is the excess premium amount for
COBRA participants (holds the surcharge
for administrative costs).
PTB-PAY-PER-AMT Signed 7.2 BN105 BN71.1
Element: 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
Element: 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
Element: Smoker Indicates if the participant is a BN72.1
smoker.
PTB-PREM-UPD-DT Numeric 8 (yyyymmdd) BN105 BN71.1
Element: Prem Upd Dt Contains the most recent start date. BN72.1
PTB-PREM-GROUP Alpha 10 BN105 BN71.1
Element: 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
Element: Cov Upd Dt Contains the start date of the coverage BN72.1
record used for this benefit.
PTB-CNT-AGE-DATE Numeric 8 (yyyymmdd)
Element: Cnt Age Date
PTB-COV-GROUP Alpha 10 BN105 BN71.1
Element: 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
Element: 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
Element: Upd Date Contains the date the retiree or COBRA BN72.1
benefits were updated.
PTB-MO-COMP-CONT Derived
Element: Mo Comp Cont
PTB-MO-EMP-AFT Derived
Element: Mo Emp Aft
PTB-MO-EXC-PREM Derived
Element: Mo Exc Prem
PTB-MO-TOT-EMP Derived
Element: Mo Tot Emp
PTB-TOT-EMP-PREM Derived
Element: Tot Emp Prem
PTB-PLAN-TYPE-2 Derived
Element: Plan Type 2
PTB-USER-ID Alpha 10 (Lower Case) BN105 BN71.1
Element: User BN72.1
PTB-TIME-STAMP Numeric 6 (hhmmss) BN105 BN71.1
Element: Time Stamp Contains the server time (hour, minute, BN72.1
and second) when the record was last
changed.
PARTBEN FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PTBSET1 COMPANY BN00.1 BN100
PLAN-TYPE BN101 BN102
PARTICIPNT BN103 BN105
EMPLOYEE BN106 BN175
START-DATE BN31.1 BN31.2
PLAN-CODE BN32.1 BN32.2
BN32.3 BN320
BN321 BN430
BN53.1 BN531
BN532 BN71.1
BN72.1 BN80.1
BS32.1 HR13.1
HR13.2 HR13.3
HR13.4 HR513
PA218
PTBSET2 COMPANY BN02.1 BN02.2
PLAN-TYPE BN02.3 BN02.4
PLAN-CODE BN02.5 BN105
PARTICIPNT BN106 BN15.1
EMPLOYEE BN17.1 BN17.2
START-DATE* 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 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 BN320
START-DATE
PTBSET4 COMPANY KeyChange BN105 BN233
PARTICIPNT BN331 BN71.1
EMPLOYEE BN72.1
PLAN-TYPE
PLAN-CODE
START-DATE*
PTBSET5 COMPANY KeyChange BN100 BN101
EMPLOYEE BN102 BN103
PARTICIPNT BN105 BN180
PLAN-TYPE BN31.1 BN31.2
PLAN-CODE BN32.1 BN32.2
START-DATE 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 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
|