PLAN – PL Group Detail

System
Benefits (BN)
Prefix
PLN
Primary key
COMPANY, PLAN-TYPE, PLAN-CODE
Fields
91
Updated by
14 programs
Referenced by
248 programs

PLAN is the PL Group Detail table in Lawson Benefits (prefix PLN). It is indexed by COMPANY, PLAN-TYPE, PLAN-CODE (PLNSET1); alternate indexes: PLNSET2, PLNSET3, PLNSET4, PLNSET5, PLNSET6 and PLNSET8. It is related 1:1 to GLMASTER, DEDCODE, PAYCLASS, PRSYSTEM, INSTCTRYCD, CUCODES, DEDFREQTBL, PRPAYCODE and 5 more and 1:M to BENEFIT, BNTAGROUP, BNACCOUNTS, BNCOVDFT, BNCOVERAGE, BNCOVOPT, BNPRMOPT, BNWAIT and 5 more. It is updated by BN00.1, BN04.1, BN100, BN104, BN15.1, BN15.2, BN90.1, LP01.1 and 6 more and referenced by BN02.5, BN03.1, BN06.1, BN101, BN102, BN103, BN105, BN106 and 240 more. The table has 91 fields, 7 indexes and 49 documented relations.

About 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.

Fields (91)

Column = COBOL field name without the PLN- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
PLN-COMPANY PK
COMPANY		Numeric 4Contains the company number.BN100, BN101, BN102, BN103, BN105, BN145, BN15.1, BN232 +29 more
PLN-PLAN-TYPE PK
PLAN_TYPE		Alpha 2Contains 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 +29 more
PLN-PLAN-CODE PK
PLAN_CODE		Alpha 4Contains 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 +29 more
PLN-START-DATE
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
PLAN_OPTION		Numeric 2Contains 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
STOP_DATE		Numeric 8 (yyyymmdd)Contains the last day an employee can be added into the plan.BN15.1
PLN-EMP-COVERED
EMP_COVERED		Alpha 1Indicates whether employee benefits can be added under a plan.
  • Y Yes
  • N No
BN15.1
PLN-GROUP-NAME
GROUP_NAME		Alpha 10Contains 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
RET_COVERED		Alpha 1Indicates 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
RET_GROUP_NAME		Alpha 10Contains 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
POST_CODE_TBL		Alpha 30Contains 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
FLEX_PLAN		Alpha 4Contains 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
DESC		Alpha 30 (Lower Case)Displays the description of the benefit plan.BN15.1
PLN-VEST-DATE
VEST_DATE		Alpha 2Contains 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
VEST_BEF_FLG		Alpha 1If 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
VESTED_AGE		Numeric 2Contains 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
VEST_SCHED		Alpha 2Contains 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
VEST_FROM_DATE		Alpha 2Contains 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
DED_TABLE		Alpha 2If 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
ACT_EMP_FLAG		Alpha 1Specifies 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
CONT_ANN_HRS		Numeric 4This 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
MIN_HOURS		Numeric 4This 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
VEST_HOURS		Signed 7.2This 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
INV_DIST_FLG		Alpha 1This 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
LAST_CMT_SEQ		Numeric 4This is the last sequence number of the comments added for the plan.BN15.1, BN90.1
PLN-PLAN-NAME
PLAN_NAME		Alpha 10If 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
ACR_DIST_CO		Numeric 4Identifies 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
ACR_ACCT_UNT		Alpha 15If 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
ACR_ACCOUNT		Numeric 6Contains 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
ACR_SUB_ACCT		Numeric 4Contains the accrual subaccount for health plans. This field is used only with savings bond plans.BN15.1
PLN-BOND-VALUE
BOND_VALUE		Signed 11.2Contains 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
BOND_COST		Signed 11.2Contains 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
CORE_BEN_FLG		Alpha 1Specifies 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
AR_DIST_CO		Numeric 4Identifies 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
AR_ACCT_UNIT		Alpha 15This 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
AR_ACCOUNT		Numeric 6This 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
AR_SUB_ACCT		Numeric 4See 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
EXP_DIST_CO		Numeric 4Identifies 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
EXP_ACCT_UNT		Alpha 15If 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
EXP_ACCOUNT		Numeric 6See 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
EXP_SUB_ACCT		Numeric 4See 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
GRP_LIFE_FLG		Alpha 1This 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
INCREMENT		Signed 5.2Regulates 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
PAY_EXP_FLAG		Numeric 1Identifies 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
DED_FREQ_FLAG		Numeric 1This 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
FLEX_PAY_CODE		Alpha 4Contains the plan's flex credit pay code.BN15.1
PLN-FLEX-DED-CODE
FLEX_DED_CODE		Alpha 4Contains the plan's flex company deduction.BN15.1
PLN-COBRA-COVERED
COBRA_COVERED		Alpha 1Indicates 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
INS_CARRIER		Alpha 4Contains the insurance carrier assigned to the plan.BN15.1
PLN-CONTRACT-NMBR
CONTRACT_NMBR		Alpha 30Contains the contract the number of the insurance plan.BN15.1
PLN-COMP-CLASS
COMP_CLASS		Alpha 3Contains 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
MAX_COMP_LIMIT		Alpha 1Indicates 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
WAIVE_FLAG		Alpha 1Indicates 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
VEST_CLASS		Alpha 3Contains 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
CHG_ELIG		Alpha 1This field is not used.
  • 0 Changed
  • 1 Not Changed
BN15.1
PLN-DEFAULT
DEFAULT		Alpha 1Indicates 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
COVERAGE_TYPE		Alpha 2Defines 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
CONTRIB_TYPE		Alpha 2Defines 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
PRE_DED_CODE_A		Alpha 4Contains the pre-tax amount deduction code.BN15.1
PLN-AFT-LMT-DED-A
AFT_LMT_DED_A		Alpha 4Contains the after-limit amount deduction code.BN15.1
PLN-AFT-DED-CODE-A
AFT_DED_CODE_A		Alpha 4Contains the after-tax amount deduction code.BN15.1
PLN-CMP-DED-CODE-A
CMP_DED_CODE_A		Alpha 4Contains the compensation amount deduction code.BN15.1
PLN-PRE-DED-CODE-P
PRE_DED_CODE_P		Alpha 4Contains the pre-tax percent deduction.BN15.1
PLN-AFT-LMT-DED-P
AFT_LMT_DED_P		Alpha 4Contains the after-limit percent deduction code.BN15.1
PLN-AFT-DED-CODE-P
AFT_DED_CODE_P		Alpha 4Contains the after-limit percent deduction code.BN15.1
PLN-CMP-DED-CODE-P
CMP_DED_CODE_P		Alpha 4Contains the company percent deduction code.BN15.1
PLN-PRE-DED-MTCH-A
PRE_DED_MTCH_A		Alpha 4Contains the company match of the pre-tax deduction amount.BN15.1
PLN-AFT-LMT-MTCH-A
AFT_LMT_MTCH_A		Alpha 4Contains the company match of the pre-tax percent deduction.BN15.1
PLN-AFT-DED-MTCH-A
AFT_DED_MTCH_A		Alpha 4Contains the company match of the after-limit percent deduction.BN15.1
PLN-PRE-DED-MTCH-P
PRE_DED_MTCH_P		Alpha 4Contains the company match of the pre-tax percent deduction.BN15.1
PLN-AFT-LMT-MTCH-P
AFT_LMT_MTCH_P		Alpha 4Contains the company match of the after-tax percent deduction.BN15.1
PLN-AFT-DED-MTCH-P
AFT_DED_MTCH_P		Alpha 4Contains the company match of the after-limit percent deduction.BN15.1
PLN-DISPLAY-DESC
DISPLAY_DESC		Alpha 15Contains the short plan description displayed on benefit entry.BN15.1
PLN-PLAN-TYPE-2
PLAN_TYPE_2		Derived——
PLN-CURRENCY-CODE
CURRENCY_CODE		Alpha 5This field contains the company base currency code established in Company (GL10.1 ).BN15.1
PLN-CURR-ND
CURR_ND		Numeric 1The number of decimals assigned to a particular account as determined by the account currency.—
PLN-REGISTR-NBR
REGISTR_NBR		Alpha 7Contains the registration number.BN15.1
PLN-COUNTRY-CODE
COUNTRY_CODE		Alpha 2The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).BN15.1
PLN-SCON-NBR
SCON_NBR		Alpha 9—BN15.1
PLN-CREATE-TRANS
CREATE_TRANS		Alpha 1—
  • Y Yes
  • N No
BN15.2
PLN-SPONSOR-ID
SPONSOR_ID		Alpha 30—BN15.2
PLN-MEMBER-ID
MEMBER_ID		Numeric 1—BN15.2
PLN-HIPAA-INS-CODE
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
BENEFICRY_FLG		Alpha 1—
  • N No
  • Y Yes
—
PLN-CODA-CONTRIB
CODA_CONTRIB		Alpha 1Coda 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
CREATE_DATE		Numeric 8 (yyyymmdd)—BN15.1
PLN-CREATE-TIME
CREATE_TIME		Numeric 6 (hhmmss)—BN15.1
PLN-CREATE-USER-ID
CREATE_USER_ID		Alpha 10 (Lower Case)—BN15.1
PLN-DATE-STAMP
DATE_STAMP		Numeric 8 (yyyymmdd)—BN15.1, BN15.2
PLN-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)—BN15.1, BN15.2
PLN-USER-ID
USER_ID		Alpha 10 (Lower Case)—BN15.1, BN15.2

Indexes (7)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PLNSET1COMPANY, PLAN-TYPE, PLAN-CODEPrimaryBN00.1, BN02.5, BN03.1, BN04.1, BN06.1, BN100, BN101, BN102 +22 more (list truncated in source)
PLNSET2COMPANY, PLAN-TYPE, START-DATE*, PLAN-CODEKeyChangeBN52.1, PR297, PR299
PLNSET3COMPANY, START-DATE*, PLAN-TYPE, PLAN-CODEKeyChangeBN52.1, PR240, PR241, PR242
PLNSET4COMPANY, PLAN-TYPE, PLAN-CODESubsetWhere DED-FREQ-FLAG = ZeroesBN104
PLNSET5POST-CODE-TBL, COMPANY, PLAN-TYPE, PLAN-CODEKeyChangeBN11.1
PLNSET6COMPANY, FLEX-PLAN, PLAN-TYPE, PLAN-CODEKeyChangeBN04.1, BN100
PLNSET8COMPANY, DED-TABLE, PLAN-TYPE, PLAN-CODEKeyChangeBN04.1

Relations

One to one (33) — lookups and parents

RelationTableRulesConditionField map
Acr AccountGLMASTERRequiredWhen PLN-ACR-ACCT-UNT != Spaces And PLN-ACR-ACCOUNT != Zeroes And PLN-ACR-SUB-ACCT != ZeroesPLN-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 ADEDCODERequiredWhen PLN-AFT-DED-CODE-A != SpacesPLN-COMPANY → DDC-COMPANY, PLN-AFT-DED-CODE-A → DDC-DED-CODE
Aft Ded Code PDEDCODERequiredWhen PLN-AFT-DED-MTCH-P != SpacesPLN-COMPANY → DDC-COMPANY, PLN-AFT-DED-CODE-P → DDC-DED-CODE
Aft Ded Mtch ADEDCODERequiredWhen PLN-AFT-DED-MTCH-A != SpacesPLN-COMPANY → DDC-COMPANY, PLN-AFT-DED-MTCH-A → DDC-DED-CODE
Aft Ded Mtch PDEDCODERequiredWhen PLN-AFT-DED-MTCH-P != SpacesPLN-COMPANY → DDC-COMPANY, PLN-AFT-DED-MTCH-P → DDC-DED-CODE
Aft Lmt Ded ADEDCODERequiredWhen PLN-AFT-LMT-DED-A != SpacesPLN-COMPANY → DDC-COMPANY, PLN-AFT-LMT-DED-A → DDC-DED-CODE
Aft Lmt Ded PDEDCODERequiredWhen PLN-AFT-LMT-DED-P != SpacesPLN-COMPANY → DDC-COMPANY, PLN-AFT-LMT-DED-P → DDC-DED-CODE
Aft Lmt Mtch ADEDCODERequiredWhen PLN-AFT-LMT-MTCH-A != SpacesPLN-COMPANY → DDC-COMPANY, PLN-AFT-LMT-MTCH-A → DDC-DED-CODE
Aft Lmt Mtch PDEDCODERequiredWhen PLN-AFT-LMT-MTCH-P != SpacesPLN-COMPANY → DDC-COMPANY, PLN-AFT-DED-MTCH-P → DDC-DED-CODE
Ar AccountGLMASTERRequiredWhen PLN-AR-ACCT-UNIT != Spaces And PLN-AR-ACCOUNT != Zeroes And PLN-AR-SUB-ACCT != ZeroesPLN-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 ADEDCODERequiredWhen PLN-CMP-DED-CODE-A != SpacesPLN-COMPANY → DDC-COMPANY, PLN-CMP-DED-CODE-A → DDC-DED-CODE
Cmp Ded Code PDEDCODERequiredWhen PLN-CMP-DED-CODE-P != SpacesPLN-COMPANY → DDC-COMPANY, PLN-CMP-DED-CODE-P → DDC-DED-CODE
Comp ClassPAYCLASSRequiredWhen PLN-COMP-CLASS != SpacesPLN-COMPANY → PCL-COMPANY, PLN-COMP-CLASS → PCL-PAY-CLASS
Company NamePRSYSTEMRequiredPLN-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL
CountryINSTCTRYCDRequiredPLN-COUNTRY-CODE → INT-COUNTRY-CODE
CurrencyCUCODESRequiredWhen PLN-CURRENCY-CODE != SpacesPLN-CURRENCY-CODE → CUC-CURRENCY-CODE
Ded Freq TableDEDFREQTBLRequiredWhen PLN-DED-TABLE != SpacesPLN-COMPANY → DFT-COMPANY, PLN-DED-TABLE → DFT-TABLE-CODE
Exp AccountGLMASTERRequiredWhen PLN-EXP-ACCT-UNT != Spaces And PLN-EXP-ACCOUNT != Zeroes And PLN-EXP-SUB-ACCT != ZeroesPLN-COMPANY → GLM-COMPANY, PLN-EXP-ACCT-UNT → GLM-ACCT-UNIT, PLN-EXP-ACCOUNT → GLM-ACCOUNT, PLN-EXP-SUB-ACCT → GLM-SUB-ACCOUNT
Flex Ded CodeDEDCODERequiredWhen PLN-FLEX-DED-CODE != SpacesPLN-COMPANY → DDC-COMPANY, PLN-FLEX-DED-CODE → DDC-DED-CODE
Flex Pay CodePRPAYCODERequiredWhen PLN-FLEX-PAY-CODE != SpacesPLN-COMPANY → PCD-COMPANY, PLN-FLEX-PAY-CODE → PCD-PAY-CODE, Spaces → PCD-PROCESS-LEVEL, Spaces → PCD-JOB-CODE
Flexible PlanFLEXPLANRequiredWhen PLN-FLEX-PLAN != SpacesPLN-COMPANY → FLP-COMPANY, PLN-FLEX-PLAN → FLP-FLEX-PLAN
Ins CarrierBNCARRIERRequiredWhen PLN-INS-CARRIER != SpacesPLN-INS-CARRIER → BCR-INS-CARRIER
PersgroupPERSGROUPNot RequiredPLN-COMPANY → PRG-COMPANY, PLN-GROUP-NAME → PRG-GROUP-NAME
Personnel GrpPERSGROUPRequiredWhen PLN-GROUP-NAME != SpacesPLN-COMPANY → PRG-COMPANY, PLN-GROUP-NAME → PRG-GROUP-NAME
Plan NamePLANMASTERRequiredWhen PLN-PLAN-NAME != SpacesPLN-COMPANY → PLM-COMPANY, PLN-PLAN-NAME → PLM-PLAN-NAME
Pre Ded Code ADEDCODERequiredWhen PLN-PRE-DED-CODE-A != SpacesPLN-COMPANY → DDC-COMPANY, PLN-PRE-DED-CODE-A → DDC-DED-CODE
Pre Ded Code PDEDCODERequiredWhen PLN-PRE-DED-CODE-P != SpacesPLN-COMPANY → DDC-COMPANY, PLN-PRE-DED-CODE-P → DDC-DED-CODE
Pre Ded Mtch ADEDCODERequiredWhen PLN-PRE-DED-MTCH-A != SpacesPLN-COMPANY → DDC-COMPANY, PLN-PRE-DED-MTCH-A → DDC-DED-CODE
Pre Ded Mtch PDEDCODERequiredWhen PLN-PRE-DED-MTCH-P != SpacesPLN-COMPANY → DDC-COMPANY, PLN-PRE-DED-MTCH-P → DDC-DED-CODE
PrsystemPRSYSTEMRequiredPLN-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL
Retiree GroupPERSGROUPNot RequiredPLN-COMPANY → PRG-COMPANY, PLN-RET-GROUP-NAME → PRG-GROUP-NAME
Vest ClassPAYCLASSRequiredWhen PLN-VEST-CLASS != SpacesPLN-COMPANY → PCL-COMPANY, PLN-VEST-CLASS → PCL-PAY-CLASS
Vesting SchedVESTSCHDHDRequiredPLN-COMPANY → VSH-COMPANY, PLN-VEST-SCHED → VSH-VEST-SCHED

One to many (16) — child tables

RelationTableRulesConditionField map
BenefitBENEFITDelete RestrictedPLN-COMPANY → BEN-COMPANY, PLN-PLAN-TYPE → BEN-PLAN-TYPE, PLN-PLAN-CODE → BEN-PLAN-CODE, → BEN-EMPLOYEE, → BEN-START-DATE
Bn Ta GroupBNTAGROUPDelete CascadesValid When PLN-PLAN-NAME != SpacesPLN-COMPANY → BTG-COMPANY, PLN-PLAN-CODE → BTG-PLAN-CODE, PLN-PLAN-NAME → BTG-TA-PLAN, → BTG-EMPLOYEE-GROUP
BnaccountsBNACCOUNTSPLN-COMPANY → BNA-COMPANY, PLN-PLAN-TYPE → BNA-PLAN-TYPE, PLN-PLAN-CODE → BNA-PLAN-CODE, → BNA-START-DATE, → BNA-GROUP-NAME, → BNA-DED-CODE
BncovdftBNCOVDFTDelete CascadesPLN-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
BncoverageBNCOVERAGEDelete CascadesPLN-COMPANY → CVR-COMPANY, PLN-PLAN-TYPE → CVR-PLAN-TYPE, PLN-PLAN-CODE → CVR-PLAN-CODE, → CVR-COVER-TYPE, → CVR-START-DATE, → CVR-GROUP-NAME
BncovoptBNCOVOPTDelete CascadesPLN-COMPANY → COP-COMPANY, PLN-PLAN-TYPE → COP-PLAN-TYPE, PLN-PLAN-CODE → COP-PLAN-CODE, → COP-COVERAGE-OPT
BnprmoptBNPRMOPTDelete CascadesPLN-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
BnwaitBNWAITPLN-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 BenefitsPARTBENPLN-COMPANY → PTB-COMPANY, PLN-PLAN-TYPE → PTB-PLAN-TYPE, PLN-PLAN-CODE → PTB-PLAN-CODE, → PTB-PARTICIPNT, → PTB-EMPLOYEE, → PTB-START-DATE
CommentsBNCOMMENTSDelete RestrictedPLN-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
InvestmentBNINVESTDelete RestrictedPLN-COMPANY → BIV-COMPANY, PLN-PLAN-CODE → BIV-PLAN-CODE, → BIV-SEQ-NBR
PartbenPARTBENPLN-COMPANY → PTB-COMPANY, PLN-PLAN-TYPE → PTB-PLAN-TYPE, PLN-PLAN-CODE → PTB-PLAN-CODE, → PTB-PARTICIPNT, → PTB-EMPLOYEE, → PTB-START-DATE
Postal CodeBNPOSTCODEValid When PLN-POST-CODE-TBL != SpacesPLN-POST-CODE-TBL → BPC-POST-CODE-TBL, → BPC-POSTAL-CODE
PremiumPREMIUMDelete CascadesPLN-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 BenPARTBENPLN-COMPANY → PTB-COMPANY, PLN-PLAN-TYPE → PTB-PLAN-TYPE, PLN-PLAN-CODE → PTB-PLAN-CODE, → PTB-PARTICIPNT, → PTB-EMPLOYEE, → PTB-START-DATE
Wait RulesBNWAITPLN-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

Programs

Updated by (14)

Referenced by (248)