BENEFIT – Employee Benefit

System
Benefits (BN)
Prefix
BEN
Primary key
COMPANY, PLAN-TYPE, EMPLOYEE, START-DATE, PLAN-CODE
Fields
100
Updated by
42 programs
Referenced by
122 programs

BENEFIT is the Employee Benefit table in Lawson Benefits (prefix BEN). It is indexed by COMPANY, PLAN-TYPE, EMPLOYEE, START-DATE, PLAN-CODE (BENSET1); alternate indexes: BENSET2, BENSET3, BENSET4, BENSET5, BENSET6, BENSET7 and BENSET8. It is related 1:1 to EMDEDMASTR, BNCOVOPT, BNCOMPANY, PRSYSTEM, PERSGROUP, PLAN, CUCODES, EMPLOYEE and 3 more and 1:M to BENEFICRY, BNTAEMPBAL, BONDBENIF, CODA, COMPHIST, EMDEDMASTR, HRDEPBEN, BNCOMMENTS and 4 more. It is updated by BN100, BN101, BN102, BN103, BN104, BN105, BN140, BN145 and 34 more and referenced by BN00.1, BN02.1, BN02.2, BN02.3, BN02.4, BN02.5, BN04.1, BN106 and 114 more. The table has 100 fields, 8 indexes and 47 documented relations.

About BENEFIT

The Employee Benefit file contains information about the employee's benefits, including employee and company contribution amounts for the benefit.

Fields (100)

Column = COBOL field name without the BEN- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#BEN-COMPANY PK
COMPANY		Numeric 4Contains the company number.BN100, BN101, BN102, BN103, BN105, BN145, BN232, BN245 +29 more
#BEN-PLAN-TYPE PK
PLAN_TYPE		Alpha 2Contains the benefit type.
  • HL Health
  • DN Dental
  • DI Disability
  • EL Employee Life
  • DL Dependent Life
  • DC Defined Contribution
  • DB Defined Benefit
  • VA Vacation
  • RS Spending Account
  • SB Savings Bond
  • SP Stock Purchase
BN100, BN101, BN102, BN103, BN105, BN145, BN232, BN245 +29 more
#BEN-EMPLOYEE PK
EMPLOYEE		Numeric 9Contains the employee number.BN100, BN101, BN102, BN103, BN105, BN145, BN232, BN245 +30 more
#BEN-START-DATE PK
START_DATE		Numeric 8 (yyyymmdd)Contains the effective date of the benefit.BN100, BN101, BN102, BN103, BN105, BN145, BN232, BN245 +30 more
#BEN-PLAN-CODE PK
PLAN_CODE		Alpha 4Contains the user-defined code representing a specific plan.BN100, BN101, BN102, BN103, BN105, BN145, BN232, BN245 +30 more
#BEN-FLEX-PLAN
FLEX_PLAN		Alpha 4Identifies the flex plan associated with this benefit.BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +10 more
#BEN-STOP-DATE
STOP_DATE		Numeric 8 (yyyymmdd)Identifies the ending effective date for the benefit.BN100, BN101, BN102, BN103, BN105, BN145, BN232, BN245 +30 more
#BEN-PLAN-OPTION SET8
PLAN_OPTION		Numeric 2Contains the plan category.BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +10 more
#BEN-COV-OPTION
COV_OPTION		Numeric 2Contains the selected coverage option for this benefit.BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +11 more
#BEN-CMP-FLX-CONT
CMP_FLX_CONT		Signed 13.4Contains the company's annual flex contribution to the benefit.BN100, BN101, BN102, BN103, BN105, BN145, BN31.1, BN31.2 +12 more
#BEN-EMP-PRE-CONT
EMP_PRE_CONT		Signed 13.4Contains the employee's annual pre-tax contribution for the benefit.BN100, BN101, BN102, BN103, BN105, BN145, BN232, BN245 +28 more
#BEN-EMP-AFT-CONT
EMP_AFT_CONT		Signed 13.4Contains the employee's annual after-tax contribution for the benefit.BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +10 more
#BEN-COMP-CONT
COMP_CONT		Signed 13.4Contains the company's annual dollar contribution for the benefit.BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +10 more
#BEN-PREM-UPD-DT SET5
PREM_UPD_DT		Numeric 8 (yyyymmdd)Contains the start date of the contribution record used for this benefit.BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +10 more
#BEN-ELIG-UPD-DT
ELIG_UPD_DT		Numeric 8 (yyyymmdd)Contains the start date of the eligibility record used for this benefit.BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +10 more
#BEN-COV-UPD-DT
COV_UPD_DT		Numeric 8 (yyyymmdd)Contains the start date of the coverage record used for this benefit.BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +10 more
#BEN-GL-UPD-DT
GL_UPD_DT		Numeric 8 (yyyymmdd)Contains the start date of the general ledger override record used for this benefit.BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +10 more
#BEN-PAY-RATE
PAY_RATE		Signed 13.4Contains the employee's salary used to calculate coverage for the benefit.BN100, BN101, BN102, BN103, BN105, BN145, BN232, BN245 +28 more
#BEN-COVER-AMT
COVER_AMT		Signed 11.2Contains the coverage amount associated with the benefit.BN100, BN101, BN102, BN103, BN105, BN145, BN31.1, BN31.2 +12 more
#BEN-DEP-COVER-AMT
DEP_COVER_AMT		Signed 11.2Contains the dependent's coverage amount associated with the benefit.BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +10 more
#BEN-PCT-AMT-FLAG
PCT_AMT_FLAG		Alpha 1Identifies if the contribution amount is a percent or flat amount.
  • A Amount
  • P Percent
BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +11 more
#BEN-NBR-HOURS
NBR_HOURS		Signed 6.3Contains the number of hours of vacation the employee has purchased or sold under a flex plan for the current year.BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +10 more
#BEN-BOND-DED-AMT
BOND_DED_AMT		Signed 11.2Identifies the pay period contribution amount.BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN31.1 +13 more
#BEN-NBR-PURCH
NBR_PURCH		Numeric 3Contains the number of bonds purchased by the employee.—
#BEN-YTD-CONT
YTD_CONT		Signed 13.2Contains the year-to-date contribution amount.BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +11 more
#BEN-CMP-SEQ-NBR
CMP_SEQ_NBR		Numeric 4Contains the sequence number that allows the tie to the employee deduction master file for the company deduction.BN100, BN101, BN102, BN103, BN105, BN145, BN245, BN31.1 +22 more
#BEN-CMP-AFT-SEQ
CMP_AFT_SEQ		Numeric 4Contains the sequence number that ties the benefit deduction to the employee deduction master containing the company matched after tax deduction.BN100, BN101, BN102, BN103, BN105, BN145, BN245, BN31.1 +21 more
#BEN-PRE-SEQ-NBR
PRE_SEQ_NBR		Numeric 4Contains the sequence number that ties the benefit to the employee deduction master and to the employee pre-tax deduction amount.BN100, BN101, BN102, BN103, BN105, BN145, BN245, BN31.1 +22 more
#BEN-AFT-SEQ-NBR
AFT_SEQ_NBR		Numeric 4Identifies the after-tax sequence number that ties the benefit to the employee after tax deduction in the employee deduction master.BN100, BN101, BN102, BN103, BN105, BN145, BN245, BN31.1 +21 more
#BEN-FLEX-DED-SEQ
FLEX_DED_SEQ		Numeric 4Contains the sequence number used to tie the benefit to the employee flex company deduction in the employee deduction master.BN100, BN101, BN102, BN103, BN105, BN145, BN245, BN31.1 +21 more
#BEN-STM-SEQ-NBR
STM_SEQ_NBR		Numeric 4Contains the sequence number that ties the benefit to the employee's standard time record in the employee standard time record file.BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +10 more
#BEN-TA-UPD-FLAG
TA_UPD_FLAG		Alpha 1Used by BN138 (Vacation Hours Update) to indicate the hours have been updated to the Time Accrual plan.LP138
#BEN-COV-OVER-FLG
COV_OVER_FLG		Alpha 1Contains a flag that identifies if the coverage amount has been overridden and should not be recalculated when running BN100 (Employee Change Benefit Update) or BN102 (Plan Employee Update). " " = No
  • Y Yes
BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +10 more
#BEN-TAKEN-FLAG
TAKEN_FLAG		Alpha 1Indicates the benefit deduction has been taken at least once This field also does not allow the benefit to be deleted.—
#BEN-CYCLES-REMAIN
CYCLES_REMAIN		Numeric 2Contains the number of payroll cycles in which the deduction is taken.BN100, BN101, BN102, BN103, BN104, BN105, BN31.1, BN31.2 +11 more
#BEN-YTD-FLEX-CONT
YTD_FLEX_CONT		Signed 13.2Contains an employee's year to date contribution amount.BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +11 more
#BEN-ELIG-GROUP
ELIG_GROUP		Alpha 10Contains the employee group name of the eligibility record used for this benefit.BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +10 more
#BEN-COV-GROUP
COV_GROUP		Alpha 10Contains the coverage group name of the coverage record used for this benefit.BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +10 more
#BEN-PREM-GROUP SET5
PREM_GROUP		Alpha 10Contains the employee group name of the premium record used for this benefit.BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +10 more
#BEN-GL-GROUP
GL_GROUP		Alpha 10Contains the employee group name of the gl override record used for this benefit.BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +10 more
#BEN-MULTIPLE
MULTIPLE		Signed 6.3Contains the multiple of salary elected by employee.BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +10 more
#BEN-ANNUAL-AMT
ANNUAL_AMT		Signed 11.4Contains the annual contribution amount.BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +10 more
#BEN-SMOKER
SMOKER		Alpha 1Indicates whether rates are used to calculate contributions.
  • Y Yes
  • N No
BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +10 more
#BEN-CREATION-DATE
CREATION_DATE		Numeric 8 (yyyymmdd)Indicates the date the benefit was added to the system.BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +10 more
#BEN-UPD-DATE
UPD_DATE		Numeric 8 (yyyymmdd)Contains the last date the benefit was updated.BN100, BN101, BN102, BN103, BN104, BN105, BN31.1, BN31.2 +12 more
#BEN-LAST-SEQ-PURCH
LAST_SEQ_PURCH		Numeric 2Contains the last bond sequence number used to purchase a savings bond.BN140
#BEN-COV-SAL-DATE
COV_SAL_DATE		Numeric 8 (yyyymmdd)Contains the date used to determine the salary for coverage calculations.BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +10 more
#BEN-COV-AGE-DATE
COV_AGE_DATE		Numeric 8 (yyyymmdd)Contains the date used to determine the age for contribution calculations.BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +10 more
#BEN-CNT-SAL-DATE
CNT_SAL_DATE		Numeric 8 (yyyymmdd)Contains the date used to determine salary for contribution calculations.BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +10 more
#BEN-CNT-AGE-DATE
CNT_AGE_DATE		Numeric 8 (yyyymmdd)Contains the date used to determine the age for contribution calculations.BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +10 more
#BEN-CNT-SERV-DATE
CNT_SERV_DATE		Numeric 8 (yyyymmdd)Contains the date used to determine the years of service for contribution calculations.BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +10 more
#BEN-EFD-START-DATE SET7
EFD_START_DATE		Numeric 8 (yyyymmdd)Contains the date of employee flex dollars record used to calculate flex contributions.BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +10 more
#BEN-PRE-AFT-FLAG
PRE_AFT_FLAG		Alpha 1Contains the type of employee contribution for the benefit.BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +10 more
#BEN-PEND-EVIDENCE
PEND_EVIDENCE		Alpha 1Indicates the status of evidence of insurability. " "
  • A Approved
  • P Pending
  • N No
BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +10 more
#BEN-EMP-CONTRIB
EMP_CONTRIB		DerivedContains the employee contributions. The calculation is: Emp-Pre-Cont + Emp-Aft-Cont—
#BEN-COMP-CONTRIB
COMP_CONTRIB		DerivedContains the company contribution. The calculation is: Comp Cont + Cmp Flx Cont—
#BEN-TOT-CONTRIB
TOT_CONTRIB		DerivedContains the total contribution. The calculation is: ((Comp Cont + Comp Flx Cnt) + Emp Pre Cont) + Emp Aft Cont—
#BEN-WK-EMP-CONT
WK_EMP_CONT		DerivedContains the weekly employee contribution. The calculation is: Emp Contrib / 52.000000—
#BEN-BI-EMP-CONT
BI_EMP_CONT		DerivedContains the bi-weekly employee contribution. The calculation is: Emp Contrib / 26—
#BEN-SM-EMP-CONT
SM_EMP_CONT		DerivedContains the semi-monthly employee contribution. The calculation is: Emp Contrib / 24—
#BEN-MO-EMP-CONT
MO_EMP_CONT		DerivedContains the monthly employee contribution. The calculation is: Emp Contrib / 12—
#BEN-EMP-PER-AMT
EMP_PER_AMT		DerivedContains the employee pay period amount. The calculation is: If (weekly) Wk Emp Cont Else If (Bi Weekly) Bi Emp Cont Else If (Semi Monthly) Sm Emp Cont Else Mo Emp Cont—
#BEN-MO-COMP-CONT
MO_COMP_CONT		DerivedContains the monthly company contribution. The calculation is: Comp Cont / 12—
#BEN-MO-COMP-FLX
MO_COMP_FLX		DerivedContains the monthly company flex contribution. Comp Flx Cont / 12—
#BEN-MO-EMP-PRE
MO_EMP_PRE		DerivedContains the monthly employee pretax contribution. The calculation is: Emp Pre Cont / 12—
#BEN-MO-EMP-AFT
MO_EMP_AFT		DerivedContains the monthly employee after-tax contribution. The calculation is: Empl Aft Cont / 12—
#BEN-MO-DIS-COVER
MO_DIS_COVER		DerivedContains the The calculation is: Cover Amt / 12—
#BEN-PLAN-TYPE-2
PLAN_TYPE_2		DerivedContains the plan type.—
#BEN-SECCLASS
SECCLASS		DerivedThis field is not used.—
#BEN-COMP-MATCH
COMP_MATCH		Signed 5.2Contains the percent of the company match.BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +10 more
#BEN-MTCH-UP-TO
MTCH_UP_TO		Signed 5.2Contains the percent of the employee contribution that the company will match.BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +10 more
#BEN-SOURCE
SOURCE		Alpha 1The source of the transaction. Input or output. Input transactions are Accounts Payable. Output transactions are Accounts Receivable.
  • I Interactive Voice Response
  • K KIOSK
  • W Web
—
#BEN-VACATION-COST
VACATION_COST		DerivedContains the vacation cost. The calculation is: ((Comp Flx Cont + Emp Pre Cont) + Empl Aft Cont) / Nbr Hours—
#BEN-FLEX-PT
FLEX_PT		Derived——
#BEN-FLEX-PT-AT
FLEX_PT_AT		Derived——
#BEN-PT-AT
PT_AT		Derived——
#BEN-FLEX-PT-AT-CMP
FLEX_PT_AT_CMP		Derived——
#BEN-PT-AT-CMP
PT_AT_CMP		Derived——
#BEN-WK-FLEX-PT
WK_FLEX_PT		Derived——
#BEN-BI-FLEX-PT
BI_FLEX_PT		Derived——
#BEN-SM-FLEX-PT
SM_FLEX_PT		Derived——
#BEN-MO-FLEX-PT
MO_FLEX_PT		Derived——
#BEN-WK-FLEX-PT-AT
WK_FLEX_PT_AT		Derived——
#BEN-BI-FLEX-PT-AT
BI_FLEX_PT_AT		Derived——
#BEN-SM-FLEX-PT-AT
SM_FLEX_PT_AT		Derived——
#BEN-MO-FLEX-PT-AT
MO_FLEX_PT_AT		Derived——
#BEN-PP-FLEX-PT
PP_FLEX_PT		Derived——
#BEN-PP-FLEX-PT-AT
PP_FLEX_PT_AT		Derived——
#BEN-CURRENCY-CODE
CURRENCY_CODE		Alpha 5This field contains the company base currency code established in Company (GL10.1 ).BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +10 more
#BEN-CURR-ND
CURR_ND		Numeric 1The number of decimals assigned to a particular account as determined by the account currency.BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +10 more
#BEN-USER-ID
USER_ID		Alpha 10 (Lower Case)—BN100, BN101, BN102, BN103, BN104, BN105, BN31.1, BN31.2 +12 more
#BEN-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)Contains the server time (hour, minute, and second) when the record was last changed.BN100, BN101, BN102, BN103, BN104, BN105, BN31.1, BN31.2 +12 more
#BEN-TRAN-SEQ-NBR
TRAN_SEQ_NBR		Numeric 4An automatically assigned sequence number.—
#BEN-TA-OBJ-ID
TA_OBJ_ID		Numeric 12This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +10 more
#BEN-CO-PCT-AMT
CO_PCT_AMT		Alpha 1—
  • A Amount
  • P Percent
—
#BEN-EMP-YTD-CONT
EMP_YTD_CONT		Signed 13.2—BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +13 more
#BEN-DED-START-DATE
DED_START_DATE		Numeric 8 (yyyymmdd)—BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +10 more
#BEN-DED-STOP-DATE
DED_STOP_DATE		Numeric 8 (yyyymmdd)—BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +10 more
#BEN-CREATE-TIME
CREATE_TIME		Numeric 6 (hhmmss)—BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +10 more
#BEN-CREATE-USER-ID
CREATE_USER_ID		Alpha 10 (Lower Case)—BN100, BN101, BN102, BN103, BN105, BN31.1, BN31.2, BN32.1 +10 more

Indexes (8)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
BENSET1
  1. COMPANY
  2. PLAN-TYPE
  3. EMPLOYEE
  4. START-DATE
  5. PLAN-CODE
PrimaryBN00.1, BN100, BN101, BN102, BN103, BN104, BN105, BN106 +22 more (list truncated in source)
BENSET2
  1. COMPANY
  2. PLAN-TYPE
  3. PLAN-CODE
  4. EMPLOYEE
  5. START-DATE ↓
BN02.1, BN02.2, BN02.3, BN02.4, BN02.5, BN04.1, BN102, BN103 +22 more (list truncated in source)
BENSET3
  1. COMPANY
  2. EMPLOYEE
  3. PLAN-TYPE
  4. PLAN-CODE
  5. START-DATE ↓
BN100, BN101, BN102, BN103, BN105, BN145, BN231, BN232 +22 more (list truncated in source)
BENSET4
  1. COMPANY
  2. EMPLOYEE
  3. PLAN-TYPE
  4. PLAN-CODE
  5. START-DATE
BN100, BN101, BN102, BN103, BN105, BN106, BN145, BN245 +22 more (list truncated in source)
BENSET5
  1. COMPANY
  2. PLAN-TYPE
  3. PLAN-CODE
  4. PREM-UPD-DT
  5. PREM-GROUP
  6. EMPLOYEE
  7. START-DATE
KeyChangeBN15.1, BN18.1, BN18.2, BN18.3, BN18.4, BN18.5, BN18.6, BN18.7 +4 more
BENSET6
  1. COMPANY
  2. PLAN-TYPE
  3. PLAN-CODE
  4. START-DATE
  5. EMPLOYEE
BN02.5, BN15.1, BN16.1, BN16.2, BN16.3, BN16.4, BN17.1
BENSET7
  1. COMPANY
  2. EMPLOYEE
  3. EFD-START-DATE
  4. PLAN-TYPE
  5. PLAN-CODE
  6. START-DATE
BN100, BN102, BN103
BENSET8
  1. COMPANY
  2. EMPLOYEE
  3. PLAN-OPTION
  4. PLAN-TYPE
  5. PLAN-CODE
  6. START-DATE
BN100, BN101

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
EMDEDMASTRBNCOVOPTBNCOMPANYPRSYSTEMPERSGROUPPLANCUCODESEMPLOYEEFLEXPLANPAEMPLOYEESTANDTIMEBENEFICRYBNTAEMPBALBONDBENIFCODACOMPHISTEMDEDMASTRHRDEPBENBNCOMMENTSEMPINVESTRESTRANSSPHISTVESTHOURSBENEFIT

One to one (35) — lookups and parents

RelationTableRulesConditionField map
Aft Ded Code AEMDEDMASTRRequiredWhen BEN-AFT-SEQ-NBR != Zeroes And BEN-PCT-AMT-FLAG = "A"
BEN-COMPANY→EDM-COMPANY
BEN-EMPLOYEE→EDM-EMPLOYEE
PLN-AFT-DED-CODE-A→EDM-DED-CODE
BEN-AFT-SEQ-NBR→EDM-SEQ-NBR
Aft Ded Code PEMDEDMASTRRequiredWhen BEN-AFT-SEQ-NBR != Zeroes And BEN-PCT-AMT-FLAG != "A"
BEN-COMPANY→EDM-COMPANY
BEN-EMPLOYEE→EDM-EMPLOYEE
PLN-AFT-DED-CODE-P→EDM-DED-CODE
BEN-AFT-SEQ-NBR→EDM-SEQ-NBR
Aft Ded Mtch AEMDEDMASTRRequiredWhen BEN-CMP-AFT-SEQ != Zeroes And BEN-PCT-AMT-FLAG = "A"
BEN-COMPANY→EDM-COMPANY
BEN-EMPLOYEE→EDM-EMPLOYEE
PLN-AFT-DED-MTCH-A→EDM-DED-CODE
BEN-CMP-AFT-SEQ→EDM-SEQ-NBR
Aft Ded Mtch PEMDEDMASTRRequiredWhen BEN-CMP-AFT-SEQ != Zeroes And BEN-PCT-AMT-FLAG = "P"
BEN-COMPANY→EDM-COMPANY
BEN-EMPLOYEE→EDM-EMPLOYEE
PLN-AFT-DED-MTCH-P→EDM-DED-CODE
BEN-CMP-AFT-SEQ→EDM-SEQ-NBR
BncovoptBNCOVOPTRequiredWhen PLN-COVERAGE-TYPE = "1"
BEN-COMPANY→COP-COMPANY
BEN-PLAN-TYPE→COP-PLAN-TYPE
BEN-PLAN-CODE→COP-PLAN-CODE
BEN-COV-OPTION→COP-COVERAGE-OPT
Cmp Ded Code AEMDEDMASTRRequiredWhen BEN-CMP-SEQ-NBR != Zeroes And BEN-PCT-AMT-FLAG = "A"
BEN-COMPANY→EDM-COMPANY
BEN-EMPLOYEE→EDM-EMPLOYEE
PLN-CMP-DED-CODE-A→EDM-DED-CODE
BEN-CMP-SEQ-NBR→EDM-SEQ-NBR
Cmp Ded Code PEMDEDMASTRRequiredWhen BEN-CMP-SEQ-NBR != Zeroes And BEN-PCT-AMT-FLAG != "A"
BEN-COMPANY→EDM-COMPANY
BEN-EMPLOYEE→EDM-EMPLOYEE
PLN-CMP-DED-CODE-P→EDM-DED-CODE
BEN-CMP-SEQ-NBR→EDM-SEQ-NBR
CompanyBNCOMPANYRequired
BEN-COMPANY→BNC-COMPANY
Company NamePRSYSTEMRequired
BEN-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
Cont GroupPERSGROUPNot Required
BEN-COMPANY→PRG-COMPANY
BEN-PREM-GROUP→PRG-GROUP-NAME
Contrib 0PLANRequiredWhen PLN-CONTRIB-TYPE = "0"
BEN-COMPANY→PLN-COMPANY
BEN-PLAN-TYPE→PLN-PLAN-TYPE
BEN-PLAN-CODE→PLN-PLAN-CODE
Contrib 1PLANRequiredWhen PLN-CONTRIB-TYPE = "1"
BEN-COMPANY→PLN-COMPANY
BEN-PLAN-TYPE→PLN-PLAN-TYPE
BEN-PLAN-CODE→PLN-PLAN-CODE
Contrib 2PLANRequiredWhen PLN-CONTRIB-TYPE = "2"
BEN-COMPANY→PLN-COMPANY
BEN-PLAN-TYPE→PLN-PLAN-TYPE
BEN-PLAN-CODE→PLN-PLAN-CODE
Contrib 3PLANRequiredWhen PLN-CONTRIB-TYPE = "3"
BEN-COMPANY→PLN-COMPANY
BEN-PLAN-TYPE→PLN-PLAN-TYPE
BEN-PLAN-CODE→PLN-PLAN-CODE
Contrib 4PLANRequiredWhen PLN-CONTRIB-TYPE = "4"
BEN-COMPANY→PLN-COMPANY
BEN-PLAN-TYPE→PLN-PLAN-TYPE
BEN-PLAN-CODE→PLN-PLAN-CODE
Contrib 5PLANRequiredWhen PLN-CONTRIB-TYPE = "5"
BEN-COMPANY→PLN-COMPANY
BEN-PLAN-TYPE→PLN-PLAN-TYPE
BEN-PLAN-CODE→PLN-PLAN-CODE
Contrib 6PLANRequiredWhen PLN-CONTRIB-TYPE = "6"
BEN-COMPANY→PLN-COMPANY
BEN-PLAN-TYPE→PLN-PLAN-TYPE
BEN-PLAN-CODE→PLN-PLAN-CODE
Contrib 7PLANRequiredWhen PLN-CONTRIB-TYPE = "7"
BEN-COMPANY→PLN-COMPANY
BEN-PLAN-TYPE→PLN-PLAN-TYPE
BEN-PLAN-CODE→PLN-PLAN-CODE
Cov GroupPERSGROUPNot Required
BEN-COMPANY→PRG-COMPANY
BEN-COV-GROUP→PRG-GROUP-NAME
Coverage 0PLANRequiredWhen PLN-COVERAGE-TYPE = "0"
BEN-COMPANY→PLN-COMPANY
BEN-PLAN-TYPE→PLN-PLAN-TYPE
BEN-PLAN-CODE→PLN-PLAN-CODE
Coverage 1PLANRequiredWhen PLN-COVERAGE-TYPE = "1"
BEN-COMPANY→PLN-COMPANY
BEN-PLAN-TYPE→PLN-PLAN-TYPE
BEN-PLAN-CODE→PLN-PLAN-CODE
Coverage 2PLANRequiredWhen PLN-COVERAGE-TYPE = "2"
BEN-COMPANY→PLN-COMPANY
BEN-PLAN-TYPE→PLN-PLAN-TYPE
BEN-PLAN-CODE→PLN-PLAN-CODE
CurrencyCUCODESRequired
BEN-CURRENCY-CODE→CUC-CURRENCY-CODE
Elig GroupPERSGROUPNot Required
BEN-COMPANY→PRG-COMPANY
BEN-ELIG-GROUP→PRG-GROUP-NAME
Emp Flex DedEMDEDMASTRRequiredWhen BEN-FLEX-DED-SEQ != Zeroes
BEN-COMPANY→EDM-COMPANY
BEN-EMPLOYEE→EDM-EMPLOYEE
PLN-FLEX-DED-CODE→EDM-DED-CODE
BEN-FLEX-DED-SEQ→EDM-SEQ-NBR
EmployeeEMPLOYEERequired
BEN-COMPANY→EMP-COMPANY
BEN-EMPLOYEE→EMP-EMPLOYEE
Flex PlanFLEXPLANRequiredWhen BEN-FLEX-PLAN != Spaces
BEN-COMPANY→FLP-COMPANY
BEN-FLEX-PLAN→FLP-FLEX-PLAN
Gl GroupPERSGROUPNot Required
BEN-COMPANY→PRG-COMPANY
BEN-GL-GROUP→PRG-GROUP-NAME
Pa EmployeePAEMPLOYEERequired
BEN-COMPANY→PEM-COMPANY
BEN-EMPLOYEE→PEM-EMPLOYEE
PlanPLANRequired
BEN-COMPANY→PLN-COMPANY
BEN-PLAN-TYPE→PLN-PLAN-TYPE
BEN-PLAN-CODE→PLN-PLAN-CODE
Pre Ded Code AEMDEDMASTRRequiredWhen BEN-PRE-SEQ-NBR != Zeroes And BEN-PCT-AMT-FLAG = "A"
BEN-COMPANY→EDM-COMPANY
BEN-EMPLOYEE→EDM-EMPLOYEE
PLN-PRE-DED-CODE-A→EDM-DED-CODE
BEN-PRE-SEQ-NBR→EDM-SEQ-NBR
Pre Ded Code PEMDEDMASTRRequiredWhen BEN-PRE-SEQ-NBR != Zeroes And BEN-PCT-AMT-FLAG != "A"
BEN-COMPANY→EDM-COMPANY
BEN-EMPLOYEE→EDM-EMPLOYEE
PLN-PRE-DED-CODE-P→EDM-DED-CODE
BEN-PRE-SEQ-NBR→EDM-SEQ-NBR
Pre Ded Mtch AEMDEDMASTRRequiredWhen BEN-CMP-SEQ-NBR != Zeroes And BEN-PCT-AMT-FLAG = "A"
BEN-COMPANY→EDM-COMPANY
BEN-EMPLOYEE→EDM-EMPLOYEE
PLN-PRE-DED-MTCH-A→EDM-DED-CODE
BEN-CMP-SEQ-NBR→EDM-SEQ-NBR
Pre Ded Mtch PEMDEDMASTRRequiredWhen BEN-CMP-SEQ-NBR != Zeroes And BEN-PCT-AMT-FLAG = "P"
BEN-COMPANY→EDM-COMPANY
BEN-EMPLOYEE→EDM-EMPLOYEE
PLN-PRE-DED-MTCH-P→EDM-DED-CODE
BEN-CMP-SEQ-NBR→EDM-SEQ-NBR
StandtimeSTANDTIMENot Required
BEN-COMPANY→STM-COMPANY
BEN-EMPLOYEE→STM-EMPLOYEE
Spaces→STM-TIME-GROUP
PLN-FLEX-PAY-CODE→STM-PAY-CODE
BEN-STM-SEQ-NBR→STM-SEQ-NBR

One to many (12) — child tables

RelationTableRulesConditionField map
BeneficiariesBENEFICRYDelete Restricted
BEN-COMPANY→BNF-COMPANY
BEN-EMPLOYEE→BNF-EMPLOYEE
BEN-PLAN-TYPE→BNF-PLAN-TYPE
BEN-PLAN-CODE→BNF-PLAN-CODE
—→BNF-SEQ-NBR
Bn Ta EmployeeBNTAEMPBAL
BEN-COMPANY→BTE-COMPANY
BEN-PLAN-CODE→BTE-PLAN-CODE
BEN-EMPLOYEE→BTE-EMPLOYEE
BEN-START-DATE→BTE-START-DATE
—→BTE-EMPLOYEE-GROUP
—→BTE-POSITION
Bond BeneficryBONDBENIFDelete Restricted
BEN-COMPANY→BON-COMPANY
BEN-EMPLOYEE→BON-EMPLOYEE
BEN-PLAN-CODE→BON-PLAN-CODE
BEN-START-DATE→BON-START-DATE
—→BON-BOND-NBR
Coda AccountCODADelete Restricted
BEN-COMPANY→COD-COMPANY
BEN-EMPLOYEE→COD-EMPLOYEE
BEN-PLAN-TYPE→COD-PLAN-TYPE
BEN-PLAN-CODE→COD-PLAN-CODE
—→COD-PLAN-YEAR
—→COD-PROCESS-LEVEL
—→COD-BUS-NBR-GRP
—→COD-QC-ENT-NBR-GRP
ComphistCOMPHISTDelete Restricted
BEN-COMPANY→CPH-COMPANY
BEN-EMPLOYEE→CPH-EMPLOYEE
BEN-PLAN-TYPE→CPH-PLAN-TYPE
BEN-PLAN-CODE→CPH-PLAN-CODE
—→CPH-PLAN-YEAR
DeductionsEMDEDMASTR
BEN-COMPANY→EDM-COMPANY
BEN-EMPLOYEE→EDM-EMPLOYEE
—→EDM-DED-CODE
—→EDM-SEQ-NBR
DependentsHRDEPBENDelete Restricted
BEN-COMPANY→HDB-COMPANY
BEN-EMPLOYEE→HDB-EMPLOYEE
BEN-PLAN-TYPE→HDB-PLAN-TYPE
BEN-PLAN-CODE→HDB-PLAN-CODE
BEN-START-DATE→HDB-EMP-START
—→HDB-DEPENDENT
—→HDB-START-DATE
Emp CommentsBNCOMMENTS
BEN-COMPANY→BCM-COMPANY
"EM"→BCM-CMT-TYPE
BEN-EMPLOYEE→BCM-EMPLOYEE
Zeroes→BCM-PARTICIPNT
BEN-PLAN-TYPE→BCM-PLAN-TYPE
BEN-PLAN-CODE→BCM-PLAN-CODE
Spaces→BCM-GROUP-NAME
BEN-START-DATE→BCM-START-DATE
—→BCM-SEQ-NBR
Invest DistribEMPINVESTDelete Cascades
BEN-COMPANY→EMI-COMPANY
BEN-EMPLOYEE→EMI-EMPLOYEE
BEN-PLAN-CODE→EMI-PLAN-CODE
BEN-START-DATE→EMI-START-DATE
—→EMI-SEQ-NBR
—→EMI-DIST-ST-DATE
Res Acct TransRESTRANSDelete Restricted
BEN-COMPANY→RTR-COMPANY
BEN-EMPLOYEE→RTR-EMPLOYEE
BEN-PLAN-CODE→RTR-PLAN-CODE
BEN-START-DATE→RTR-START-DATE
—→RTR-DATE
—→RTR-CHECK-NBR
Stock PurchaseSPHISTDelete Restricted
BEN-COMPANY→SPH-COMPANY
BEN-EMPLOYEE→SPH-EMPLOYEE
BEN-PLAN-CODE→SPH-PLAN-CODE
BEN-START-DATE→SPH-START-DATE
—→SPH-DATE-PURCH
Vesting HoursVESTHOURSDelete Restricted
BEN-COMPANY→VES-COMPANY
BEN-EMPLOYEE→VES-EMPLOYEE
BEN-PLAN-TYPE→VES-PLAN-TYPE
BEN-PLAN-CODE→VES-PLAN-CODE
—→VES-PLAN-YEAR

Programs

Updated by (42)

Referenced by (122)