|
|
BNPRMOPT FILE
Benefit Premium Options
REFERENCED BY
BN02.1 BN02.2 BN02.3 BN02.4 BN02.5 BN100
BN101 BN102 BN103 BN105 BN215 BN245
BN31.1 BN31.2 BN32.1 BN32.2 BN32.3 BN531
BN65.1 BN71.1 BN72.1 BS13.1 BS14.1 BS15.1
BS32.1 HR55.1
UPDATED BY
BN15.1 BN17.1 BN18.1 BN18.2 BN18.3 BN18.4
BN18.5 BN18.6 BN18.7 BN19.1 BN19.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PCV-COMPANY Numeric 4 BN15.1 BN17.1
Company Contains the company number. BN19.1 BN19.2
PCV-PLAN-TYPE Alpha 2 BN15.1 BN17.1
Type Contains the plan type that identifies BN19.1 BN19.2
the type of benefit.
HL = Health
DN = Dental
DI = Disability
EL = Life
DL = Dependent Life
DC = Defined Contribution
DB = Defined Benefit
VA = Vacation
RS = Spending Account
SB = Savings Bond
SP = Stock Purchase
PCV-PLAN-CODE Alpha 4 BN15.1 BN17.1
Plan Contains the user-defined code that BN19.1 BN19.2
represents a benefit plan.
PCV-GROUP-NAME Alpha 10 BN15.1 BN17.1
Group Name Contains the group that uses the BN19.1 BN19.2
contribution record. This field may
contain spaces.
PCV-START-DATE Numeric 8 (yyyymmdd) BN15.1 BN17.1
Start Date Contains the start date for BN19.1 BN19.2
contribution.
PCV-COVERAGE-OPT Numeric 2 BN15.1 BN17.1
Coverage Opt Contains the coverage option with which BN19.1 BN19.2
the contributions are associated.
PCV-EMP-CONT Signed 7.2 BN15.1 BN17.1
Emp Cont If the contribution type is the same as BN19.1 BN19.2
the option amount, this is the employee
contribution.
PCV-COMP-CONT Signed 7.2 BN15.1 BN17.1
Company Contribution If the contribution type is the same as BN19.1 BN19.2
the option amount, this field contains
the company contribution.
PCV-FLEX-CONT Signed 7.2 BN15.1 BN17.1
Flex Cont If the contribution type is the same as BN19.1 BN19.2
the option amount, this field contains
the flex credit contribution.
PCV-RATE-TABLE Alpha 4 BN15.1 BN17.1
Rate Table If the contribution type is the same as BN19.1 BN19.2
the options amount range, this field
contains the rate table used for the
contribution.
PCV-E-RET-CONT Signed 7.2 BN15.1 BN17.1
E Ret Cont This field is not used. BN19.1 BN19.2
PCV-E-CO-CONT Signed 7.2 BN15.1 BN17.1
E Co Cont This field is not used. BN19.1 BN19.2
PCV-R-RET-CONT Signed 7.2 BN15.1 BN17.1
R Ret Cont This field is not used. BN19.1 BN19.2
PCV-R-CO-CONT Signed 7.2 BN15.1 BN17.1
R Co Cont This field is not used. BN19.1 BN19.2
PCV-COBRA-CONT Signed 7.2 BN15.1 BN17.1
Cobra Cont This field is not used. BN19.1 BN19.2
PCV-EARLY-RET-AGE Numeric 2 BN15.1 BN17.1
Early Ret Age This field is not used. BN19.1 BN19.2
PCV-REG-RET-AGE Numeric 2 BN15.1 BN17.1
Reg Ret Age This field is not used. BN19.1 BN19.2
PCV-TERM-AGE Numeric 2 BN15.1 BN17.1
Termination Age This field is not used. BN19.1 BN19.2
PCV-PREMIUM-CHG Numeric 1 BN15.1 BN17.1
Premium Chg This field is not used. BN19.1 BN19.2
0 = Not Updated
1 = Updated
PCV-ACTIVE-FLAG Alpha 1 BN15.1 BN17.1
Status Indicates if the option contribution is BN19.1 BN19.2
active or inactive.
A = Active
I = Inactive
PCV-COVER-TYPE Alpha 1 BN15.1 BN17.1
Cover Type For each record, indicates if the BN19.1 BN19.2
contribution type is for employees,
retirees, COBRA participants.
E = Employee
C = COBRA Participant
R = Retiree
BNPRMOPT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PCVSET1 COMPANY BN02.1 BN02.2
PLAN-TYPE BN02.3 BN02.4
PLAN-CODE BN02.5 BN100
COVER-TYPE BN101 BN102
START-DATE BN103 BN105
GROUP-NAME BN15.1 BN17.1
COVERAGE-OPT BN18.1 BN18.2
BN18.3 BN18.4
BN18.5 BN18.6
BN18.7 BN19.1
BN19.2 BN215
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN531 BN65.1
...
PCVSET2 COMPANY BN17.1 BN17.2
PLAN-TYPE
PLAN-CODE
COVERAGE-OPT
COVER-TYPE
START-DATE
GROUP-NAME
BNPRMOPT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Bncovopt BNCOVOPT Required
PCV-COMPANY -> COP-COMPANY
PCV-PLAN-TYPE -> COP-PLAN-TYPE
PCV-PLAN-CODE -> COP-PLAN-CODE
PCV-COVERAGE-OPT -> COP-COVERAGE-OPT
Company Name PRSYSTEM Required
PCV-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Persgroup PERSGROUP Not Required
PCV-COMPANY -> PRG-COMPANY
PCV-GROUP-NAME -> PRG-GROUP-NAME
Plan PLAN Required
PCV-COMPANY -> PLN-COMPANY
PCV-PLAN-TYPE -> PLN-PLAN-TYPE
PCV-PLAN-CODE -> PLN-PLAN-CODE
Prsystem PRSYSTEM Required
PCV-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Ratetblhdr RATETBLHDR Not Required
PCV-COMPANY -> RTH-COMPANY
PCV-RATE-TABLE -> RTH-TABLE-CODE
PCV-START-DATE -> RTH-START-DATE
BNPRMOPT FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Premium PREMIUM Required
PCV-COMPANY -> PRE-COMPANY
PCV-PLAN-TYPE -> PRE-PLAN-TYPE
PCV-PLAN-CODE -> PRE-PLAN-CODE
PRE-COVER-TYPE
PRE-START-DATE
PRE-GROUP-NAME
Ratetbldtl RATETBLDTL
PCV-COMPANY -> RTD-COMPANY
PCV-RATE-TABLE -> RTD-TABLE-CODE
PCV-START-DATE -> RTD-START-DATE
RTD-BEG-AGE-YR-SAL
RTD-SMOKER
|