Benefit Plan

The Benefit Plan file contains information about benefit plans such as coverage and contribution types, deductions, vesting and compensation parameters, and account numbers used for COBRA participants and retirees.

REFERENCED BY

BN141	BN17.1	BN17.2	BN17.3	BN18.1	BN18.2
BN18.3	BN18.4	BN18.5	BN18.6	BN18.7	BN180
BN231	BN232	BN233	BN238	BN240	BN242
BN247	BN248	BN258	BN259	BN310	BN321
BN36.1	BN430	BN47.1	BN48.2	BN50.1	BN51.1
BN51.2	BN53.1	BN532	BN547	BN55.1	BN55.2
BN555	BN556	BN56.1	BN57.1	BN59.1	BN60.1
BN60.2	BN61.1	BN77.1	BN80.1	BN81.2	BS10.1
BS12.1	BS31.1	BS531	ZB01.1	ZS531	HR13.1
HR13.2	HR13.3	HR13.4	HR170	HR513	HR70.1
LP34.1	PA218	MR551	PR129	PR240	PR241
PR242	PR27.1	PR27.2	PR297	PR299	PR797
ZP550	ZP551	ZP555	ZP562	BN02.5	BN03.1
BN06.1	BN13.1	BN16.1	BN16.2	BN16.3	BN16.4
BN181	BN19.1	BN19.2	BN19.3	BN19.4	BN20.1
BN206	BN216	BN220	BN252	BS03.1	BS03.2
BS03.3	BS04.1	BS30.1	HPLN.1	LP01.1	LP02.1
LP15.1	PRBN.1	BN52.1	BN11.1

UPDATED BY

BN00.1	BN04.1	BN100	BN101	BN102	BN103
BN104	BN105	BN106	BN138	BN140	BN145
BN15.1	BN15.2	BN150	BN215	BN230	BN236
BN237	BN245	BN246	BN305	BN31.1	BN31.2
BN32.1	BN32.2	BN32.3	BN320	BN325	BN330
BN331	BN335	BN340	BN345	BN350	BN45.1
BN531	BN65.1	BN66.1	BN71.1	BN72.1	BN90.1
BS13.1	BS14.1	BS15.1	BS32.1	ZB10.1	ZB31.1
ZB31.2	ZB32.1	ZB32.2	ZB32.3	ZB599	HR11.1
HR11.2	HR28.1	HR511	HR55.1	HR55.2	HR55.3
LT101	PR521	ZH230	ZH510	EXI2.1	EXI4.1
LP130	LP138	PA02.1	PA100	PA102	PA115
PA13.1	PA13.2	PA502	PA513	PA52.1	PA52.3
PA52.4	PA52.5	PR110	PR113	PR12.6	PR120
PR128	PR13.1	PR13.2	PR13.5	PR13.6	PR13.8
PR13.9	PR130	PR131	PR132	PR134	PR135
PR136	PR137	PR14.1	PR14.2	PR140	PR15.1
PR15.2	PR189	PR195	PR197	PR20.1	PR20.4
PR205	PR26.1	PR26.2	PR29.1	PR30.2	PR32.1
PR32.2	PR33.1	PR33.2	PR33.3	PR35.1	PR35.2
PR35.3	PR35.4	PR35.5	PR35.6	PR35.8	PR35.9
PR36.1	PR37.1	PR39.1	PR39.2	PR39.5	PR45.1
PR47.1	PR47.2	PR514	PR529	PR530	PR539
PR560	PR582	PR80.1	PR80.3	PR80.4	PR82.1
PR89.1	UK102	UK201	UK47.1	UK47.2	UK50.3
UK560	ZP530	TA147

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
PLN-COMPANY Element: Company Hr	Numeric 4 Contains the company number.	BN100 BN101 BN102 BN103 BN105 BN145 BN15.1 BN232 BN245 BN31.1 BN31.2 BN32.1 BN32.2 BN32.3 BN320 BN331 BN340 BN45.1 BN531 BN65.1 BN71.1 BN72.1 BS12.1 BS13.1 BS14.1 BS15.1 BS32.1 ZB01.1 ZB10.1 ZB10.2 ZB31.1 ZB31.2 ZB32.1 ZB32.2 ZB32.3
PLN-PLAN-TYPE Element: Plan	Alpha 2 Contains the type of benefit plan. 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 FL = Flex	BN100 BN101 BN102 BN103 BN105 BN145 BN15.1 BN232 BN245 BN31.1 BN31.2 BN32.1 BN32.2 BN32.3 BN320 BN331 BN340 BN45.1 BN531 BN65.1 BN71.1 BN72.1 BS12.1 BS13.1 BS14.1 BS15.1 BS32.1 ZB01.1 ZB10.1 ZB10.2 ZB31.1 ZB31.2 ZB32.1 ZB32.2 ZB32.3
PLN-PLAN-CODE Element: Plan	Alpha 4 Contains the user-defined code used to represent a specific benefit plan. The plan code is unique within a plan type.	BN100 BN101 BN102 BN103 BN105 BN145 BN15.1 BN232 BN245 BN31.1 BN31.2 BN32.1 BN32.2 BN32.3 BN320 BN331 BN340 BN45.1 BN531 BN65.1 BN71.1 BN72.1 BS12.1 BS13.1 BS14.1 BS15.1 BS32.1 ZB01.1 ZB10.1 ZB10.2 ZB31.1 ZB31.2 ZB32.1 ZB32.2 ZB32.3
PLN-START-DATE Element: Start Date	Numeric 8 (yyyymmdd) Contains the first date an employee may enroll in a benefit plan. For defined contribution and defined benefit plan types, the month and day define the beginning date for each plan year.	BN15.1
PLN-PLAN-OPTION Element: Type	Numeric 2 Contains the plan category within a plan type. It further defines the type of plan. 01 = Profit Sharing 02 = Money Purchase 03 = ESOP 04 = 401(k) 05 = 403(b) 06 = 457 07 = Thrift or Savings 10 = Medical Reimbursement 11 = Dependent Care 12 = Legal Account 14 = Vacation Buy 15 = Vacation Sell 18 = Life 19 = AD&D 20 = STD 21 = LTD 25 = Medical 26 = Vision 27 = Long Term Care	BN15.1
PLN-STOP-DATE Element: Stop Date	Numeric 8 (yyyymmdd) Contains the last day an employee can be added into the plan.	BN15.1
PLN-EMP-COVERED Element: Emp Covered	Alpha 1 Indicates whether employee benefits can be added under a plan. Y = Yes N = No	BN15.1
PLN-GROUP-NAME Element: Employee Group	Alpha 10 Contains the employee group used to determine which employees are eligible for the plan. The employee must be in this group to be eligible for the plan.	BN15.1
PLN-RET-COVERED Element: Ret Covered	Alpha 1 Indicates whether retiree benefits can be added under a plan. This field is used only for health, dental, life, and disability plans. Y = Yes N = No	BN15.1
PLN-RET-GROUP-NAME Element: Ret Group Name	Alpha 10 Contains the an employee group used to determine which retirees are eligible for the plan. The retiree must be in this group to be eligible.	BN15.1
PLN-POST-CODE-TBL Element: Post Code Tbl	Alpha 30 Contains the table of postal codes used to determine employee eligibility for the plan. The employee must have a benefit postal code which is on this table to be eligible for the plan.	BN15.1
PLN-FLEX-PLAN Element: Flex Plan	Alpha 4 Contains the flexible benefit plan code which is used to determine which flex plan this benefit plan is associated with. If this is not a spending account only plan, the employee must have a flex dollar record to enroll in the benefit plan.	BN15.1
PLN-DESC Element: Description	Alpha 30 (Lower Case) Displays the description of the benefit plan.	BN15.1
PLN-VEST-DATE Element: Vest Date	Alpha 2 Contains the type of year used in determining the vesting computation period. This field is used for defined contribution and defined benefit plans only. CA = Calendar Year EM = Employment Year PL = Plan Year	BN15.1
PLN-VEST-BEF-FLG Element: Vest Bef Flg	Alpha 1 If the employee was hired prior to the plan start date this field is used to specify whether the years prior to the plan start date should be used to calculate the employees vested percent. Yes means the system will include years prior to the plan start date in vesting calculations. No means the system will begin vesting with the plan start date. This field is for defined contribution and defined benefit plans only. Y = Yes N = No	BN15.1
PLN-VESTED-AGE Element: Vested Age	Numeric 2 Contains the age when the employee is 100 percent vested regardless of vesting years of service. This field is for defined contribution and defined benefit plans only.	BN15.1
PLN-VEST-SCHED Element: Vest Sched	Alpha 2 Contains the vesting schedule code for this plan, if applicable. This field is used only for defined contribution and defined benefit plans.	BN15.1
PLN-VEST-FROM-DATE Element: Vest From Date	Alpha 2 Contains the start date for employee vesting calculations. This field is for defined contribution and defined benefit plans only. HI = Hire Date AJ = Adjusted Hire Date SN = Seniority Date AN = Anniversary Date B1 = Benefit Date 1 B2 = Benefit Date 2 B3 = Benefit Date 3 B4 = Benefit Date 4 B5 = Benefit Date 5	BN15.1
PLN-DED-TABLE Element: Frequency Table	Alpha 2 If deductions or pay codes have been set up for this plan, this field is the frequency table used to determine premium divisors (if applicable) and deduction cycles for benefits added under this plan.	BN100 BN102 BN15.1
PLN-ACT-EMP-FLAG Element: Act Emp Flag	Alpha 1 Specifies if an employee must be active on the last day of the plan year to receive the company plan contribution. This field is used for defined contribution and defined benefit plans only. N = No Y = Yes	BN15.1
PLN-CONT-ANN-HRS Element: Cont Ann Hrs	Numeric 4 This field specifies the minimum number of hours that an employee must work in a plan year in order to receive a plan contribution. This field is used with defined benefit and defined contribution plans only.	BN15.1
PLN-MIN-HOURS Element: Min Hours	Numeric 4 This field is the minimum number of hours that an employee must work in a plan year to prevent the year from being considered a break in service. This field is only used with defined contribution and defined benefit plans.	BN15.1
PLN-VEST-HOURS Element: Vest Hours	Signed 7.2 This field is the minimum number of hours an employee must work in a plan year in order to vest for the year. This field is only used with defined contribution and defined benefit plans.	BN15.1
PLN-INV-DIST-FLG Element: Inv Dist Flg	Alpha 1 This field determines if an employee is able to choose the distribution of plan contributions to investment accounts. This field is used only with defined contribution plans. N = No Y = Yes	BN15.1
PLN-LAST-CMT-SEQ Element: Last Cmt Seq	Numeric 4 This is the last sequence number of the comments added for the plan.	BN15.1 BN90.1
PLN-PLAN-NAME Element: Plan	Alpha 10 If using Time Accrual this is the name of the vacation plan to be updated with the number of hours bought or sold through Benefits. This field is only used with vacation plans.	BN15.1
PLN-ACR-DIST-CO Element: Company	Numeric 4 Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.	BN15.1
PLN-ACR-ACCT-UNT Accrual Accounting Unit	Alpha 15 If COBRA participants and retirees are covered under the plan, this field is the accrual accounting unit for the plan. This field is only used with health, dental, life, dependent life, spending account plans.	BN15.1
PLN-ACR-ACCOUNT Element: Accrual Account	Numeric 6 Contains the accrual account for plans. This field is only used with health, dental, life, dependent life, and spending account plans.	BN15.1
PLN-ACR-SUB-ACCT Element: Accrual Subaccount	Numeric 4 Contains the accrual subaccount for health plans. This field is used only with savings bond plans.	BN15.1
PLN-BOND-VALUE Element: Bond Value	Signed 11.2 Contains the face value of the bond that can be purchased under this plan. This field is only used with savings bond plans.	BN15.1
PLN-BOND-COST Element: Bond Cost	Signed 11.2 Contains the cost to the employee for purchasing one bond of this value. This field is used only with savings bond plans.	BN15.1
PLN-CORE-BEN-FLG Element: Core Plan	Alpha 1 Specifies whether the plan is the core benefit under a flex plan. This field is used for health, dental, life, disability, and dependent life plans. If yes is entered this field is used only for health and dental plans. N = No S = Spouse Y = Yes	BN15.1
PLN-AR-DIST-CO Element: Company	Numeric 4 Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.	BN15.1
PLN-AR-ACCT-UNIT Element: A/R Accounting Unit	Alpha 15 This field is the accounts receivable account unit that contains the part of the premium COBRA participants and retirees, for the health plan. This field is used only for health, dental, life, dependent life, and spending account plans.	BN15.1
PLN-AR-ACCOUNT Element: A/R Account	Numeric 6 This field is the accounts receivable account that contains the part of the premium COBRA participants and retirees, for the health plan. This field is used only for health, dental, life, dependent life, and spending account plans.	BN15.1
PLN-AR-SUB-ACCT Element: A/R Subaccount	Numeric 4 See PLN-AR-ACCT-UNIT. This field is used only with health, dental, life, dependent life, and spending account plans.	BN15.1
PLN-EXP-DIST-CO Element: Company	Numeric 4 Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.	BN15.1
PLN-EXP-ACCT-UNT Expense Accounting Unit	Alpha 15 If retirees are covered under the health plan, this is the expense account that contains the expense amount. This field is used only with health, dental, life, dependent life, and spending account plans.	BN15.1
PLN-EXP-ACCOUNT Element: Expense Account	Numeric 6 See PLN-EXP-ACCT-UNT. This field is used only with health, dental, life, dependent life, and spending account plans.	BN15.1
PLN-EXP-SUB-ACCT Element: Expense Subaccount	Numeric 4 See PLN-EXP-ACCT-UNT. This field is used only with health, dental, life, dependent life, and spending account plans.	BN15.1
PLN-GRP-LIFE-FLG Element: Reportable Life	Alpha 1 This field flags a plan as being a group life plan. If the plan if group term life, coverage under the plan will be included in the calculations of excess life insurance cost for employees. This field is used only with life and dependent life plans. N = No Y = Yes	BN15.1
PLN-INCREMENT Element: Increment	Signed 5.2 Regulates the percent increments that the employee can elect for distribution for the defined contribution account funds on the plan.	BN15.1
PLN-PAY-EXP-FLAG Element: Pay Exp Flag	Numeric 1 Identifies whether an employee can be reimbursed for expenses up to the employee's contribution-to-date amount (less withdrawals-to-date) or up to the amount to be contributed for the entire plan year or if system displays a warning only. This field is used with spending account plans only. 1 = Stop at Annual Limit 2 = Stop at Current Limit 3 = Warning over Annual Limit 4 = Warning over Current Limit 5 = None	BN15.1
PLN-DED-FREQ-FLAG Element: Frequency Table	Numeric 1 This field is updated when the deduction frequency table is changed. Run BN104 (Deduction Frequency Update) when the flag is set to one. 0 = Not Updated 1 = Updated	BN04.1 BN104 BN15.1
PLN-FLEX-PAY-CODE Element: Flex Pay Code	Alpha 4 Contains the plan's flex credit pay code.	BN15.1
PLN-FLEX-DED-CODE Element: Flex Ded Code	Alpha 4 Contains the plan's flex company deduction.	BN15.1
PLN-COBRA-COVERED Element: Cobra Covered	Alpha 1 Indicates whether COBRA participants can elect benefits under a plan. This field is only used with health, dental, life, and spending account plans. Y = Yes N = No	BN15.1
PLN-INS-CARRIER Element: Ins Carrier	Alpha 4 Contains the insurance carrier assigned to the plan.	BN15.1
PLN-CONTRACT-NMBR Element: Contract Nmbr	Alpha 30 Contains the contract the number of the insurance plan.	BN15.1
PLN-COMP-CLASS Element: Comp Class	Alpha 3 Contains the pay class used to keep track of an employee's covered compensation. This field is used for defined contribution and defined benefit plans.	BN15.1
PLN-MAX-COMP-LIMIT Element: Max Comp Limit	Alpha 1 Indicates whether the maximum compensation limit for 401k and 403b plans is checked by PR140 (Earning and Deductions Calculations). If yes is entered, deductions stop when the maximum compensation limit is met. The maximum compensation limit is defined in the Benefit Limits file. This field is used only with defined contribution plans. Y = First limit met; comp or addt N = Annual additions limit only B = Do not apply either limit	BN15.1
PLN-WAIVE-FLAG Element: Waive Flag	Alpha 1 Indicates whether the plan is a waive plan. A waive plan tracks employees who do not elect coverage. N = No Y = Yes	BN15.1
PLN-VEST-CLASS Element: Vest Class	Alpha 3 Contains the pay class that keeps track of the number of vesting hours each employee accumulates for a year. This field is used with defined contribution plans only.	BN15.1
PLN-CHG-ELIG Element: Chg Elig	Alpha 1 This field is not used. 0 = Changed 1 = Not Changed	BN15.1
PLN-DEFAULT Element: Default	Alpha 1 Indicates whether benefits should automatically be added to an employee who is eligible for a plan. This field is used by BN100 (Employee Change Benefit Update) and BN101 (Mass Benefit Add). A = Always Default T = Default for Plan Type O = Default for Plan Option N = Do Not Default C = Default for Plan Category	BN15.1
PLN-COVERAGE-TYPE Element: Coverage Type	Alpha 2 Defines the type of coverage for benefits under a plan. If coverage options are used, the user will define coverage options the employee may elect. If coverage amounts are used, the system will calculate a dollar amount of coverage. 0 = No Coverage 1 = Coverage Options 2 = Coverage Amount X = Custom Calculation	BN15.1
PLN-CONTRIB-TYPE Element: Contrib Type	Alpha 2 Defines the contribution type used by the plan. 0 = No Contribution 1 = Options Amount 2 = Options Amount Range 3 = Flat Contributions 4 = Salary or Coverage Rate Table 5 = Contribution Limits 6 = Match Limit Schedule 7 = Match Percent Schedule X = Custom Calculation	BN15.1
PLN-PRE-DED-CODE-A Element: Pre Ded Code A	Alpha 4 Contains the pre-tax amount deduction code.	BN15.1
PLN-AFT-LMT-DED-A Element: Aft Lmt Ded A	Alpha 4 Contains the after-limit amount deduction code.	BN15.1
PLN-AFT-DED-CODE-A Element: Aft Ded Code A	Alpha 4 Contains the after-tax amount deduction code.	BN15.1
PLN-CMP-DED-CODE-A Element: Cmp Ded Code A	Alpha 4 Contains the compensation amount deduction code.	BN15.1
PLN-PRE-DED-CODE-P Element: Pre Ded Code P	Alpha 4 Contains the pre-tax percent deduction.	BN15.1
PLN-AFT-LMT-DED-P Element: Aft Lmt Ded P	Alpha 4 Contains the after-limit percent deduction code.	BN15.1
PLN-AFT-DED-CODE-P Element: Aft Ded Code P	Alpha 4 Contains the after-limit percent deduction code.	BN15.1
PLN-CMP-DED-CODE-P Element: Cmp Ded Code P	Alpha 4 Contains the company percent deduction code.	BN15.1
PLN-PRE-DED-MTCH-A Element: Pre Ded Mtch A	Alpha 4 Contains the company match of the pre-tax deduction amount.	BN15.1
PLN-AFT-LMT-MTCH-A Element: Aft Lmt Mtch A	Alpha 4 Contains the company match of the pre-tax percent deduction.	BN15.1
PLN-AFT-DED-MTCH-A Element: Aft Ded Mtch A	Alpha 4 Contains the company match of the after-limit percent deduction.	BN15.1
PLN-PRE-DED-MTCH-P Element: Pre Ded Mtch P	Alpha 4 Contains the company match of the pre-tax percent deduction.	BN15.1
PLN-AFT-LMT-MTCH-P Element: Aft Lmt Mtch P	Alpha 4 Contains the company match of the after-tax percent deduction.	BN15.1
PLN-AFT-DED-MTCH-P Element: Aft Ded Mtch P	Alpha 4 Contains the company match of the after-limit percent deduction.	BN15.1
PLN-DISPLAY-DESC Element: Display Desc	Alpha 15 Contains the short plan description displayed on benefit entry.	BN15.1
PLN-PLAN-TYPE-2 Element: Plan Type 2	Derived
PLN-CURRENCY-CODE Element: Currency Code	Alpha 5 This field contains the company base currency code established in Company (GL10.1 ).	BN15.1
PLN-CURR-ND Element: Acct Nd	Numeric 1 The number of decimals assigned to a particular account as determined by the account currency.
PLN-REGISTR-NBR Element: Registr Nbr	Alpha 7 Contains the registration number.	BN15.1
PLN-COUNTRY-CODE Element: Country Code	Alpha 2 The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).	BN15.1
PLN-SCON-NBR Element: Scon Nbr	Alpha 9	BN15.1
PLN-CREATE-TRANS Element: Create Trans	Alpha 1 Y = Yes N = No	BN15.2
PLN-SPONSOR-ID Element: Sponsor Id	Alpha 30	BN15.2
PLN-MEMBER-ID Element: Member Id	Numeric 1	BN15.2
PLN-HIPAA-INS-CODE Element: Hipaa Ins Code	Alpha 3 AG = Preventive Care AH = 24 Hour Care AJ = Medicare Risk AK = Mental Health DCP = Dental Capitation (DMO) DEN = Dental EPO = Exclusive Provider Org. FAC = Facility HE = Hearing HLT = Health HMO = Health Maint. Org. LTC = Long Term Care LTD = Long Term Disability MM = Major Medical MOD = Mail Order Drug PDG = Prescription Drug POS = Point of Service PPO = Preferred Provider Org. PRA = Practitioners STD = Short Term Disability UR = Utilization Review VIS = Vision	BN15.2
PLN-BENEFICRY-FLG Element: Beneficry Flg	Alpha 1 N = No Y = Yes
PLN-CODA-CONTRIB Element: Coda Contrib	Alpha 1 Coda Contrib is for the user to indicate the type of distribution that will be used for tracking DC/DB account balances. 1 = Both Contributions 2 = Company Contribution Only 3 = Employee Contribution Only 4 = No Contributions	BN15.1

PLAN FILE INDEX

PLAN FILE RELATIONS

ONE TO ONE RELATIONS

PLAN FILE RELATIONS

ONE TO MANY RELATIONS

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