PLAN

PL Group Detail

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
BN02.5 BN03.1 BN06.1 BN101 BN102 BN103
BN105 BN106 BN13.1 BN140 BN141 BN145
BN150 BN16.1 BN16.2 BN16.3 BN16.4 BN17.1
BN17.2 BN17.3 BN18.1 BN18.2 BN18.3 BN18.4
BN18.5 BN18.6 BN18.7 BN180 BN181 BN19.1
BN19.2 BN19.3 BN19.4 BN20.1 BN206 BN215
BN216 BN220 BN230 BN231 BN232 BN233
BN236 BN237 BN238 BN240 BN242 BN245
BN246 BN247 BN248 BN252 BN258 BN259
BN260 BN305 BN31.1 BN31.2 BN31.4 BN31.5
BN310 BN32.1 BN32.2 BN32.3 BN320 BN321
BN325 BN330 BN331 BN335 BN340 BN345
BN350 BN36.1 BN430 BN45.1 BN47.1 BN48.2
BN50.1 BN51.1 BN51.2 BN53.1 BN531 BN532
BN547 BN55.1 BN55.2 BN555 BN556 BN56.1
BN57.1 BN59.1 BN60.1 BN60.2 BN61.1 BN65.1
BN65.2 BN66.1 BN71.1 BN72.1 BN77.1 BN80.1
BN81.2 BS03.1 BS03.2 BS03.3 BS03.4 BS04.1
BS10.1 BS12.1 BS13.1 BS14.1 BS15.1 BS30.1
BS31.1 BS32.1 BS531 ZB01.1 ZB10.1 ZB10.2
ZB31.1 ZB31.2 ZB31.4 ZB31.5 ZB32.1 ZB32.2
ZB32.3 ZB599 ZS531 HPLN.1 HR11.1 HR11.2
HR11.4 HR13.1 HR13.2 HR13.3 HR13.4 HR170
HR28.1 HR511 HR513 HR55.1 HR55.2 HR55.3
HR70.1 LT101 LT111 PR521 ZH230 ZH510
EXI2.1 EXI4.1 LP130 LP138 LP15.1 LP34.1
PA02.1 PA100 PA102 PA115 PA13.1 PA13.2
PA218 PA502 PA513 PA52.1 PA52.3 PA52.4
PA52.5 PR110 PR113 PR12.6 PR120 PR128
PR129 PR13.1 PR13.2 PR13.5 PR13.6 PR13.8
PR13.9 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 PR27.1 PR27.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 PR36.4 PR37.1 PR39.1 PR39.2
PR39.5 PR45.1 PR47.1 PR47.2 PR512 PR514
PR529 PR530 PR539 PR560 PR582 PR797
PR80.1 PR80.3 PR80.4 PR82.1 PR89.1 PRAT.1
PRBN.1 UK102 ZP551 ZP555 ZP562 TA147
BN52.1 BN11.1


UPDATED BY
BN00.1 BN04.1 BN104 BN15.1 BN15.2 BN90.1
BN100 LP01.1 LP02.1 PR240 PR241 PR242
PR297 PR299

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 BN260
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN320
BN331 BN340
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS10.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 BN260
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN320
BN331 BN340
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS10.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 BN260
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN320
BN331 BN340
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS10.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
PLN-CREATE-DATE
Element: Date Stamp
Numeric 8 (yyyymmdd)
BN15.1
PLN-CREATE-TIME
Element: Time Stamp
Numeric 6 (hhmmss)
BN15.1
PLN-CREATE-USER-ID
Element: User Id
Alpha 10 (Lower Case)
BN15.1
PLN-DATE-STAMP
Element: Date Stamp
Numeric 8 (yyyymmdd)
BN15.1 BN15.2
PLN-TIME-STAMP
Element: Time Stamp
Numeric 6 (hhmmss)
BN15.1 BN15.2
PLN-USER-ID
Element: User Id
Alpha 10 (Lower Case)
BN15.1 BN15.2


PLAN FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PLNSET1 COMPANY
PLAN-TYPE
PLAN-CODE
...
BN00.1 BN02.5
BN03.1 BN04.1
BN06.1 BN100
BN101 BN102
BN103 BN104
BN105 BN106
BN13.1 BN140
BN141 BN145
BN15.1 BN15.2
BN150 BN16.1
BN16.2 BN16.3
BN16.4 BN17.1
BN17.2 BN17.3
BN18.1 BN18.2
BN18.3 BN18.4
PLNSET2 COMPANY
PLAN-TYPE
START-DATE*
PLAN-CODE
KeyChange
BN52.1 PR297
PR299
PLNSET3 COMPANY
START-DATE*
PLAN-TYPE
PLAN-CODE
KeyChange
BN52.1 PR240
PR241 PR242
PLNSET4 COMPANY
PLAN-TYPE
PLAN-CODE
Subset
WhereDED-FREQ-FLAG =Zeroes
BN104
PLNSET5 POST-CODE-TBL
COMPANY
PLAN-TYPE
PLAN-CODE
KeyChange
BN11.1
PLNSET6 COMPANY
FLEX-PLAN
PLAN-TYPE
PLAN-CODE
KeyChange
BN04.1 BN100
PLNSET8 COMPANY
DED-TABLE
PLAN-TYPE
PLAN-CODE
KeyChange
BN04.1


PLAN FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Acr Account GLMASTER Required
When PLN-ACR-ACCT-UNT !=Spaces
AndPLN-ACR-ACCOUNT !=Zeroes
AndPLN-ACR-SUB-ACCT !=Zeroes
PLN-COMPANY->GLM-COMPANY
PLN-ACR-ACCT-UNT->GLM-ACCT-UNIT
PLN-ACR-ACCOUNT->GLM-ACCOUNT
PLN-ACR-SUB-ACCT->GLM-SUB-ACCOUNT
Aft Ded Code A DEDCODE Required
When PLN-AFT-DED-CODE-A !=Spaces
PLN-COMPANY->DDC-COMPANY
PLN-AFT-DED-CODE-A->DDC-DED-CODE
Aft Ded Code P DEDCODE Required
When PLN-AFT-DED-MTCH-P !=Spaces
PLN-COMPANY->DDC-COMPANY
PLN-AFT-DED-CODE-P->DDC-DED-CODE
Aft Ded Mtch A DEDCODE Required
When PLN-AFT-DED-MTCH-A !=Spaces
PLN-COMPANY->DDC-COMPANY
PLN-AFT-DED-MTCH-A->DDC-DED-CODE
Aft Ded Mtch P DEDCODE Required
When PLN-AFT-DED-MTCH-P !=Spaces
PLN-COMPANY->DDC-COMPANY
PLN-AFT-DED-MTCH-P->DDC-DED-CODE
Aft Lmt Ded A DEDCODE Required
When PLN-AFT-LMT-DED-A !=Spaces
PLN-COMPANY->DDC-COMPANY
PLN-AFT-LMT-DED-A->DDC-DED-CODE
Aft Lmt Ded P DEDCODE Required
When PLN-AFT-LMT-DED-P !=Spaces
PLN-COMPANY->DDC-COMPANY
PLN-AFT-LMT-DED-P->DDC-DED-CODE
Aft Lmt Mtch A DEDCODE Required
When PLN-AFT-LMT-MTCH-A !=Spaces
PLN-COMPANY->DDC-COMPANY
PLN-AFT-LMT-MTCH-A->DDC-DED-CODE
Aft Lmt Mtch P DEDCODE Required
When PLN-AFT-LMT-MTCH-P !=Spaces
PLN-COMPANY->DDC-COMPANY
PLN-AFT-DED-MTCH-P->DDC-DED-CODE
Ar Account GLMASTER Required
When PLN-AR-ACCT-UNIT !=Spaces
AndPLN-AR-ACCOUNT !=Zeroes
AndPLN-AR-SUB-ACCT !=Zeroes
PLN-COMPANY->GLM-COMPANY
PLN-AR-ACCT-UNIT->GLM-ACCT-UNIT
PLN-AR-ACCOUNT->GLM-ACCOUNT
PLN-AR-SUB-ACCT->GLM-SUB-ACCOUNT
Cmp Ded Code A DEDCODE Required
When PLN-CMP-DED-CODE-A !=Spaces
PLN-COMPANY->DDC-COMPANY
PLN-CMP-DED-CODE-A->DDC-DED-CODE
Cmp Ded Code P DEDCODE Required
When PLN-CMP-DED-CODE-P !=Spaces
PLN-COMPANY->DDC-COMPANY
PLN-CMP-DED-CODE-P->DDC-DED-CODE
Comp Class PAYCLASS Required
When PLN-COMP-CLASS !=Spaces
PLN-COMPANY->PCL-COMPANY
PLN-COMP-CLASS->PCL-PAY-CLASS
Company Name PRSYSTEM Required
PLN-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Country INSTCTRYCD Required
PLN-COUNTRY-CODE->INT-COUNTRY-CODE
Currency CUCODES Required
When PLN-CURRENCY-CODE !=Spaces
PLN-CURRENCY-CODE->CUC-CURRENCY-CODE
Ded Freq Table DEDFREQTBL Required
When PLN-DED-TABLE !=Spaces
PLN-COMPANY->DFT-COMPANY
PLN-DED-TABLE->DFT-TABLE-CODE
Exp Account GLMASTER Required
When PLN-EXP-ACCT-UNT !=Spaces
AndPLN-EXP-ACCOUNT !=Zeroes
AndPLN-EXP-SUB-ACCT !=Zeroes
PLN-COMPANY->GLM-COMPANY
PLN-EXP-ACCT-UNT->GLM-ACCT-UNIT
PLN-EXP-ACCOUNT->GLM-ACCOUNT
PLN-EXP-SUB-ACCT->GLM-SUB-ACCOUNT
Flex Ded Code DEDCODE Required
When PLN-FLEX-DED-CODE !=Spaces
PLN-COMPANY->DDC-COMPANY
PLN-FLEX-DED-CODE->DDC-DED-CODE
Flex Pay Code PRPAYCODE Required
When PLN-FLEX-PAY-CODE !=Spaces
PLN-COMPANY->PCD-COMPANY
PLN-FLEX-PAY-CODE->PCD-PAY-CODE
Spaces->PCD-PROCESS-LEVEL
Spaces->PCD-JOB-CODE
Flexible Plan FLEXPLAN Required
When PLN-FLEX-PLAN !=Spaces
PLN-COMPANY->FLP-COMPANY
PLN-FLEX-PLAN->FLP-FLEX-PLAN
Ins Carrier BNCARRIER Required
When PLN-INS-CARRIER !=Spaces
PLN-INS-CARRIER->BCR-INS-CARRIER
Persgroup PERSGROUP Not Required
PLN-COMPANY->PRG-COMPANY
PLN-GROUP-NAME->PRG-GROUP-NAME
Personnel Grp PERSGROUP Required
When PLN-GROUP-NAME !=Spaces
PLN-COMPANY->PRG-COMPANY
PLN-GROUP-NAME->PRG-GROUP-NAME
Plan Name PLANMASTER Required
When PLN-PLAN-NAME !=Spaces
PLN-COMPANY->PLM-COMPANY
PLN-PLAN-NAME->PLM-PLAN-NAME
Pre Ded Code A DEDCODE Required
When PLN-PRE-DED-CODE-A !=Spaces
PLN-COMPANY->DDC-COMPANY
PLN-PRE-DED-CODE-A->DDC-DED-CODE
Pre Ded Code P DEDCODE Required
When PLN-PRE-DED-CODE-P !=Spaces
PLN-COMPANY->DDC-COMPANY
PLN-PRE-DED-CODE-P->DDC-DED-CODE
Pre Ded Mtch A DEDCODE Required
When PLN-PRE-DED-MTCH-A !=Spaces
PLN-COMPANY->DDC-COMPANY
PLN-PRE-DED-MTCH-A->DDC-DED-CODE
Pre Ded Mtch P DEDCODE Required
When PLN-PRE-DED-MTCH-P !=Spaces
PLN-COMPANY->DDC-COMPANY
PLN-PRE-DED-MTCH-P->DDC-DED-CODE
Prsystem PRSYSTEM Required
PLN-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Retiree Group PERSGROUP Not Required
PLN-COMPANY->PRG-COMPANY
PLN-RET-GROUP-NAME->PRG-GROUP-NAME
Vest Class PAYCLASS Required
When PLN-VEST-CLASS !=Spaces
PLN-COMPANY->PCL-COMPANY
PLN-VEST-CLASS->PCL-PAY-CLASS
Vesting Sched VESTSCHDHD Required
PLN-COMPANY->VSH-COMPANY
PLN-VEST-SCHED->VSH-VEST-SCHED


PLAN FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Benefit BENEFIT Delete Restricted
PLN-COMPANY->BEN-COMPANY
PLN-PLAN-TYPE->BEN-PLAN-TYPE
PLN-PLAN-CODE->BEN-PLAN-CODE
  BEN-EMPLOYEE
  BEN-START-DATE
Bn Ta Group BNTAGROUP Delete Cascades
Valid When PLN-PLAN-NAME !=Spaces
PLN-COMPANY->BTG-COMPANY
PLN-PLAN-CODE->BTG-PLAN-CODE
PLN-PLAN-NAME->BTG-TA-PLAN
  BTG-EMPLOYEE-GROUP
Bnaccounts BNACCOUNTS
PLN-COMPANY->BNA-COMPANY
PLN-PLAN-TYPE->BNA-PLAN-TYPE
PLN-PLAN-CODE->BNA-PLAN-CODE
  BNA-START-DATE
  BNA-GROUP-NAME
  BNA-DED-CODE
Bncovdft BNCOVDFT Delete Cascades
PLN-COMPANY->BCD-COMPANY
PLN-PLAN-TYPE->BCD-PLAN-TYPE
PLN-PLAN-CODE->BCD-PLAN-CODE
  BCD-COVER-TYPE
  BCD-START-DATE
  BCD-GROUP-NAME
  BCD-COVERAGE-OPT
Bncoverage BNCOVERAGE Delete Cascades
PLN-COMPANY->CVR-COMPANY
PLN-PLAN-TYPE->CVR-PLAN-TYPE
PLN-PLAN-CODE->CVR-PLAN-CODE
  CVR-COVER-TYPE
  CVR-START-DATE
  CVR-GROUP-NAME
Bncovopt BNCOVOPT Delete Cascades
PLN-COMPANY->COP-COMPANY
PLN-PLAN-TYPE->COP-PLAN-TYPE
PLN-PLAN-CODE->COP-PLAN-CODE
  COP-COVERAGE-OPT
Bnprmopt BNPRMOPT Delete Cascades
PLN-COMPANY->PCV-COMPANY
PLN-PLAN-TYPE->PCV-PLAN-TYPE
PLN-PLAN-CODE->PCV-PLAN-CODE
  PCV-COVER-TYPE
  PCV-START-DATE
  PCV-GROUP-NAME
  PCV-COVERAGE-OPT
Bnwait BNWAIT
PLN-COMPANY->BWT-COMPANY
Spaces->BWT-RULE-TYPE
PLN-PLAN-TYPE->BWT-PLAN-TYPE
PLN-PLAN-CODE->BWT-PLAN-CODE
  BWT-START-DATE
  BWT-GROUP-NAME
  BWT-ACTION-CODE
Cobra Benefits PARTBEN
PLN-COMPANY->PTB-COMPANY
PLN-PLAN-TYPE->PTB-PLAN-TYPE
PLN-PLAN-CODE->PTB-PLAN-CODE
  PTB-PARTICIPNT
  PTB-EMPLOYEE
  PTB-START-DATE
Comments BNCOMMENTS Delete Restricted
PLN-COMPANY->BCM-COMPANY
"PL"->BCM-CMT-TYPE
Zeroes->BCM-EMPLOYEE
Zeroes->BCM-PARTICIPNT
PLN-PLAN-TYPE->BCM-PLAN-TYPE
PLN-PLAN-CODE->BCM-PLAN-CODE
Spaces->BCM-GROUP-NAME
Zeroes->BCM-START-DATE
  BCM-SEQ-NBR
Investment BNINVEST Delete Restricted
PLN-COMPANY->BIV-COMPANY
PLN-PLAN-CODE->BIV-PLAN-CODE
  BIV-SEQ-NBR
Partben PARTBEN
PLN-COMPANY->PTB-COMPANY
PLN-PLAN-TYPE->PTB-PLAN-TYPE
PLN-PLAN-CODE->PTB-PLAN-CODE
  PTB-PARTICIPNT
  PTB-EMPLOYEE
  PTB-START-DATE
Postal Code BNPOSTCODE
Valid When PLN-POST-CODE-TBL !=Spaces
PLN-POST-CODE-TBL->BPC-POST-CODE-TBL
  BPC-POSTAL-CODE
Premium PREMIUM Delete Cascades
PLN-COMPANY->PRE-COMPANY
PLN-PLAN-TYPE->PRE-PLAN-TYPE
PLN-PLAN-CODE->PRE-PLAN-CODE
  PRE-COVER-TYPE
  PRE-START-DATE
  PRE-GROUP-NAME
Retiree Ben PARTBEN
PLN-COMPANY->PTB-COMPANY
PLN-PLAN-TYPE->PTB-PLAN-TYPE
PLN-PLAN-CODE->PTB-PLAN-CODE
  PTB-PARTICIPNT
  PTB-EMPLOYEE
  PTB-START-DATE
Wait Rules BNWAIT
PLN-COMPANY->BWT-COMPANY
PLN-PLAN-TYPE->BWT-PLAN-TYPE
PLN-PLAN-CODE->BWT-PLAN-CODE
  BWT-RULE-TYPE
  BWT-START-DATE
  BWT-GROUP-NAME
  BWT-ACTION-CODE


File created: Thu Jun 09 02:10:14 2016

Home
Contact Us



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