BNPRMOPT

Benefit Premium Options

REFERENCED BY
BN100 BN101 BN102 BN103 BN105 BN245
BN31.1 BN31.2 BN32.1 BN32.2 BN32.3 BN531
BN65.1 BN71.1 BN72.1 BN729 BN991 BS13.1
BS14.1 BS15.1 BS32.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 BN02.1
BN02.2 BN02.3 BN02.4 BN02.5 BN215 HR55.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PCV-COMPANY
Element: Company Hr		Numeric 4
Contains the company number.
BN15.1 BN17.1
BN19.1 BN19.2
PCV-PLAN-TYPE
Element: Plan Type		Alpha 2
Contains the plan type that identifies 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
BN15.1 BN17.1
BN19.1 BN19.2
PCV-PLAN-CODE
Element: Plan Code		Alpha 4
Contains the user-defined code that represents a benefit plan.
BN15.1 BN17.1
BN19.1 BN19.2
PCV-GROUP-NAME
Element: Group Name		Alpha 10
Contains the group that uses the contribution record. This field may contain spaces.
BN15.1 BN17.1
BN19.1 BN19.2
PCV-START-DATE
Element: Start Date		Numeric 8 (yyyymmdd)
Contains the start date for contribution.
BN15.1 BN17.1
BN19.1 BN19.2
PCV-COVERAGE-OPT
Element: Coverage Opt		Numeric 2
Contains the coverage option with which the contributions are associated.
BN15.1 BN17.1
BN19.1 BN19.2
PCV-EMP-CONT
Element: Emp Cont		Signed 7.2
If the contribution type is the same as the option amount, this is the employee contribution.
BN15.1 BN17.1
BN19.1 BN19.2
PCV-COMP-CONT
Element: Comp Cont		Signed 11.2
If the contribution type is the same as the option amount, this field contains the company contribution.
BN15.1 BN17.1
BN19.1 BN19.2
PCV-FLEX-CONT
Element: Flex Cont		Signed 7.2
If the contribution type is the same as the option amount, this field contains the flex credit contribution.
BN15.1 BN17.1
BN19.1 BN19.2
PCV-RATE-TABLE
Element: Rate Table		Alpha 4
If the contribution type is the same as the options amount range, this field contains the rate table used for the contribution.
BN15.1 BN17.1
BN19.1 BN19.2
PCV-E-RET-CONT
Element: E Ret Cont		Signed 7.2
This field is not used.
BN15.1 BN17.1
BN19.1 BN19.2
PCV-E-CO-CONT
Element: E Co Cont		Signed 7.2
This field is not used.
BN15.1 BN17.1
BN19.1 BN19.2
PCV-R-RET-CONT
Element: R Ret Cont		Signed 7.2
This field is not used.
BN15.1 BN17.1
BN19.1 BN19.2
PCV-R-CO-CONT
Element: R Co Cont		Signed 7.2
This field is not used.
BN15.1 BN17.1
BN19.1 BN19.2
PCV-COBRA-CONT
Element: Cobra Cont		Signed 7.2
This field is not used.
BN15.1 BN17.1
BN19.1 BN19.2
PCV-EARLY-RET-AGE
Element: Early Ret Age		Numeric 2
This field is not used.
BN15.1 BN17.1
BN19.1 BN19.2
PCV-REG-RET-AGE
Element: Reg Ret Age		Numeric 2
This field is not used.
BN15.1 BN17.1
BN19.1 BN19.2
PCV-TERM-AGE
Element: Term Age		Numeric 2
This field is not used.
BN15.1 BN17.1
BN19.1 BN19.2
PCV-PREMIUM-CHG
Element: Premium Chg		Numeric 1
This field is not used.
0 = Not Updated
1 = Updated
BN15.1 BN17.1
BN19.1 BN19.2
PCV-ACTIVE-FLAG
Element: Active Flag		Alpha 1
Indicates if the option contribution is active or inactive.
A = Active
I = Inactive
BN15.1 BN17.1
BN19.1 BN19.2
PCV-COVER-TYPE
Element: Cover Type		Alpha 1
For each record, indicates if the contribution type is for employees, retirees, COBRA participants.
E = Employee
C = COBRA Participant
R = Retiree
BN15.1 BN17.1
BN19.1 BN19.2


BNPRMOPT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PCVSET1 COMPANY
PLAN-TYPE
PLAN-CODE
COVER-TYPE
START-DATE
GROUP-NAME
COVERAGE-OPT
...
BN02.1 BN02.2
BN02.3 BN02.4
BN02.5 BN100
BN101 BN102
BN103 BN105
BN15.1 BN17.1
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
PLAN-TYPE
PLAN-CODE
COVERAGE-OPT
COVER-TYPE
START-DATE
GROUP-NAME
BN17.1


BNPRMOPT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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
NAME		 RELATED 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

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

Home
Contact Us



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