Employee Benefit
The Employee Benefit file contains information about the employee's benefits, including employee and company contribution amounts for the benefit.
REFERENCED BY
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
BEN-COMPANY Element: Company Hr | Numeric 4 Contains the company number. |
|||||||||||||||||||||||||||||||
BEN-PLAN-TYPE Element: Plan Type | Alpha 2 Contains 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 |
|||||||||||||||||||||||||||||||
BEN-EMPLOYEE Element: Employee | Numeric 9 Contains the employee number. |
|||||||||||||||||||||||||||||||
BEN-START-DATE Element: Start Date | Numeric 8 (yyyymmdd) Contains the effective date of the benefit. |
|||||||||||||||||||||||||||||||
BEN-PLAN-CODE Element: Plan Code | Alpha 4 Contains the user-defined code representing a specific plan. |
|||||||||||||||||||||||||||||||
BEN-FLEX-PLAN Element: Flex Plan | Alpha 4 Identifies the flex plan associated with this benefit. |
|
||||||||||||||||||||||||||||||
BEN-STOP-DATE Element: Stop Date | Numeric 8 (yyyymmdd) Identifies the ending effective date for the benefit. |
|||||||||||||||||||||||||||||||
BEN-PLAN-OPTION Element: Plan Option | Numeric 2 Contains the plan category. |
|
||||||||||||||||||||||||||||||
BEN-COV-OPTION Element: Cov Option | Numeric 2 Contains the selected coverage option for this benefit. |
|
||||||||||||||||||||||||||||||
BEN-CMP-FLX-CONT Element: Cmp Flx Cont4 | Signed 13.4 Contains the company's annual flex contribution to the benefit. |
|
||||||||||||||||||||||||||||||
BEN-EMP-PRE-CONT Element: Emp Pre Cont4 | Signed 13.4 Contains the employee's annual pre-tax contribution for the benefit. |
|||||||||||||||||||||||||||||||
BEN-EMP-AFT-CONT Element: Emp Aft Cont4 | Signed 13.4 Contains the employee's annual after-tax contribution for the benefit. |
|
||||||||||||||||||||||||||||||
BEN-COMP-CONT Element: Comp Cont4 | Signed 13.4 Contains the company's annual dollar contribution for the benefit. |
|
||||||||||||||||||||||||||||||
BEN-PREM-UPD-DT Element: Prem Upd Dt | Numeric 8 (yyyymmdd) Contains the start date of the contribution record used for this benefit. |
|
||||||||||||||||||||||||||||||
BEN-ELIG-UPD-DT Element: Elig Upd Dt | Numeric 8 (yyyymmdd) Contains the start date of the eligibility record used for this benefit. |
|
||||||||||||||||||||||||||||||
BEN-COV-UPD-DT Element: Cov Upd Dt | Numeric 8 (yyyymmdd) Contains the start date of the coverage record used for this benefit. |
|
||||||||||||||||||||||||||||||
BEN-GL-UPD-DT Element: Gl Upd Dt | Numeric 8 (yyyymmdd) Contains the start date of the general ledger override record used for this benefit. |
|
||||||||||||||||||||||||||||||
BEN-PAY-RATE Element: Pay Rate | Signed 13.4 Contains the employee's salary used to calculate coverage for the benefit. |
|||||||||||||||||||||||||||||||
BEN-COVER-AMT Element: Cover Amt | Signed 11.2 Contains the coverage amount associated with the benefit. |
|
||||||||||||||||||||||||||||||
BEN-DEP-COVER-AMT Element: Dep Cover Amt | Signed 11.2 Contains the dependent's coverage amount associated with the benefit. |
|
||||||||||||||||||||||||||||||
BEN-PCT-AMT-FLAG Element: Pct Amt Flag | Alpha 1 Identifies if the contribution amount is a percent or flat amount. A = Amount P = Percent |
|
||||||||||||||||||||||||||||||
BEN-NBR-HOURS Element: Nbr Hours | Signed 6.3 Contains the number of hours of vacation the employee has purchased or sold under a flex plan for the current year. |
|
||||||||||||||||||||||||||||||
BEN-BOND-DED-AMT Element: Bond Ded Amt | Signed 11.2 Identifies the pay period contribution amount. |
|
||||||||||||||||||||||||||||||
BEN-NBR-PURCH Element: Nbr Purch | Numeric 3 Contains the number of bonds purchased by the employee. |
|
||||||||||||||||||||||||||||||
BEN-YTD-CONT Element: Ytd Cont | Signed 13.2 Contains the year-to-date contribution amount. |
|
||||||||||||||||||||||||||||||
BEN-CMP-SEQ-NBR Element: Cmp Seq Nbr | Numeric 4 Contains the sequence number that allows the tie to the employee deduction master file for the company deduction. |
|||||||||||||||||||||||||||||||
BEN-CMP-AFT-SEQ Element: Cmp Aft Seq | Numeric 4 Contains the sequence number that ties the benefit deduction to the employee deduction master containing the company matched after tax deduction. |
|
||||||||||||||||||||||||||||||
BEN-PRE-SEQ-NBR Element: Pre Seq Nbr | Numeric 4 Contains the sequence number that ties the benefit to the employee deduction master and to the employee pre-tax deduction amount. |
|||||||||||||||||||||||||||||||
BEN-AFT-SEQ-NBR Element: Aft Seq Nbr | Numeric 4 Identifies the after-tax sequence number that ties the benefit to the employee after tax deduction in the employee deduction master. |
|
||||||||||||||||||||||||||||||
BEN-FLEX-DED-SEQ Element: Flex Ded Seq | Numeric 4 Contains the sequence number used to tie the benefit to the employee flex company deduction in the employee deduction master. |
|
||||||||||||||||||||||||||||||
BEN-STM-SEQ-NBR Element: Stm Seq Nbr | Numeric 4 Contains the sequence number that ties the benefit to the employee's standard time record in the employee standard time record file. |
|
||||||||||||||||||||||||||||||
BEN-TA-UPD-FLAG Element: Ta Upd Flag | Alpha 1 Used by BN138 (Vacation Hours Update) to indicate the hours have been updated to the Time Accrual plan. |
|
||||||||||||||||||||||||||||||
BEN-COV-OVER-FLG Element: Cov Over Flg | Alpha 1 Contains 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 |
|
||||||||||||||||||||||||||||||
BEN-TAKEN-FLAG Element: Taken Flag | Alpha 1 Indicates the benefit deduction has been taken at least once This field also does not allow the benefit to be deleted. |
|
||||||||||||||||||||||||||||||
BEN-CYCLES-REMAIN Element: Cycles Remain | Numeric 2 Contains the number of payroll cycles in which the deduction is taken. |
|
||||||||||||||||||||||||||||||
BEN-YTD-FLEX-CONT Element: Ytd Flex Cont | Signed 13.2 Contains an employee's year to date contribution amount. |
|
||||||||||||||||||||||||||||||
BEN-ELIG-GROUP Element: Elig Group | Alpha 10 Contains the employee group name of the eligibility record used for this benefit. |
|
||||||||||||||||||||||||||||||
BEN-COV-GROUP Element: Cov Group | Alpha 10 Contains the coverage group name of the coverage record used for this benefit. |
|
||||||||||||||||||||||||||||||
BEN-PREM-GROUP Element: Prem Group | Alpha 10 Contains the employee group name of the premium record used for this benefit. |
|
||||||||||||||||||||||||||||||
BEN-GL-GROUP Element: Gl Group | Alpha 10 Contains the employee group name of the gl override record used for this benefit. |
|
||||||||||||||||||||||||||||||
BEN-MULTIPLE Element: Multiple | Signed 6.3 Contains the multiple of salary elected by employee. |
|
||||||||||||||||||||||||||||||
BEN-ANNUAL-AMT Element: Annual Amt4 | Signed 11.4 Contains the annual contribution amount. |
|
||||||||||||||||||||||||||||||
BEN-SMOKER Element: Smoker | Alpha 1 Indicates whether rates are used to calculate contributions. Y = Yes N = No |
|
||||||||||||||||||||||||||||||
BEN-CREATION-DATE Element: Creation Date | Numeric 8 (yyyymmdd) Indicates the date the benefit was added to the system. |
|
||||||||||||||||||||||||||||||
BEN-UPD-DATE Element: Upd Date | Numeric 8 (yyyymmdd) Contains the last date the benefit was updated. |
|
||||||||||||||||||||||||||||||
BEN-LAST-SEQ-PURCH Element: Last Seq Purch | Numeric 2 Contains the last bond sequence number used to purchase a savings bond. |
|
||||||||||||||||||||||||||||||
BEN-COV-SAL-DATE Element: Cov Sal Date | Numeric 8 (yyyymmdd) Contains the date used to determine the salary for coverage calculations. |
|
||||||||||||||||||||||||||||||
BEN-COV-AGE-DATE Element: Cov Age Date | Numeric 8 (yyyymmdd) Contains the date used to determine the age for contribution calculations. |
|
||||||||||||||||||||||||||||||
BEN-CNT-SAL-DATE Element: Cnt Sal Date | Numeric 8 (yyyymmdd) Contains the date used to determine salary for contribution calculations. |
|
||||||||||||||||||||||||||||||
BEN-CNT-AGE-DATE Element: Cnt Age Date | Numeric 8 (yyyymmdd) Contains the date used to determine the age for contribution calculations. |
|
||||||||||||||||||||||||||||||
BEN-CNT-SERV-DATE Element: Cnt Serv Date | Numeric 8 (yyyymmdd) Contains the date used to determine the years of service for contribution calculations. |
|
||||||||||||||||||||||||||||||
BEN-EFD-START-DATE Element: Efd Start Date | Numeric 8 (yyyymmdd) Contains the date of employee flex dollars record used to calculate flex contributions. |
|
||||||||||||||||||||||||||||||
BEN-PRE-AFT-FLAG Element: Pre Aft Flag | Alpha 1 Contains the type of employee contribution for the benefit. |
|
||||||||||||||||||||||||||||||
BEN-PEND-EVIDENCE Element: Pend Evidence | Alpha 1 Indicates the status of evidence of insurability. A = Approved P = Pending N = No " " |
|
||||||||||||||||||||||||||||||
BEN-EMP-CONTRIB Element: Emp Contrib | Derived Contains the employee contributions. The calculation is: Emp-Pre-Cont + Emp-Aft-Cont |
|
||||||||||||||||||||||||||||||
BEN-COMP-CONTRIB Element: Comp Contrib | Derived Contains the company contribution. The calculation is: Comp Cont + Cmp Flx Cont |
|
||||||||||||||||||||||||||||||
BEN-TOT-CONTRIB Element: Tot Contrib | Derived Contains the total contribution. The calculation is: ((Comp Cont + Comp Flx Cnt) + Emp Pre Cont) + Emp Aft Cont |
|
||||||||||||||||||||||||||||||
BEN-WK-EMP-CONT Element: Wk Emp Cont | Derived Contains the weekly employee contribution. The calculation is: Emp Contrib / 52.000000 |
|
||||||||||||||||||||||||||||||
BEN-BI-EMP-CONT Element: Bi Emp Cont | Derived Contains the bi-weekly employee contribution. The calculation is: Emp Contrib / 26 |
|
||||||||||||||||||||||||||||||
BEN-SM-EMP-CONT Element: Sm Emp Cont | Derived Contains the semi-monthly employee contribution. The calculation is: Emp Contrib / 24 |
|
||||||||||||||||||||||||||||||
BEN-MO-EMP-CONT Element: Mo Emp Cont | Derived Contains the monthly employee contribution. The calculation is: Emp Contrib / 12 |
|
||||||||||||||||||||||||||||||
BEN-EMP-PER-AMT Element: Emp Per Amt | Derived Contains 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 Element: Mo Comp Cont | Derived Contains the monthly company contribution. The calculation is: Comp Cont / 12 |
|
||||||||||||||||||||||||||||||
BEN-MO-COMP-FLX Element: Mo Comp Flx | Derived Contains the monthly company flex contribution. Comp Flx Cont / 12 |
|
||||||||||||||||||||||||||||||
BEN-MO-EMP-PRE Element: Mo Emp Pre | Derived Contains the monthly employee pretax contribution. The calculation is: Emp Pre Cont / 12 |
|
||||||||||||||||||||||||||||||
BEN-MO-EMP-AFT Element: Mo Emp Aft | Derived Contains the monthly employee after-tax contribution. The calculation is: Empl Aft Cont / 12 |
|
||||||||||||||||||||||||||||||
BEN-MO-DIS-COVER Element: Mo Dis Cover | Derived Contains the The calculation is: Cover Amt / 12 |
|
||||||||||||||||||||||||||||||
BEN-PLAN-TYPE-2 Element: Plan Type 2 | Derived Contains the plan type. |
|
||||||||||||||||||||||||||||||
BEN-SECCLASS Element: Secclass | Derived This field is not used. |
|
||||||||||||||||||||||||||||||
BEN-COMP-MATCH Element: Comp Match | Signed 5.2 Contains the percent of the company match. |
|
||||||||||||||||||||||||||||||
BEN-MTCH-UP-TO Element: Mtch Up To | Signed 5.2 Contains the percent of the employee contribution that the company will match. |
|
||||||||||||||||||||||||||||||
BEN-SOURCE Element: Source | Alpha 1 The 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 Element: Vacation Cost | Derived Contains the vacation cost. The calculation is: ((Comp Flx Cont + Emp Pre Cont) + Empl Aft Cont) / Nbr Hours |
|
||||||||||||||||||||||||||||||
BEN-FLEX-PT Element: Flex Pt | Derived |
|
||||||||||||||||||||||||||||||
BEN-FLEX-PT-AT Element: Flex Pt At | Derived |
|
||||||||||||||||||||||||||||||
BEN-PT-AT Element: Pt At | Derived |
|
||||||||||||||||||||||||||||||
BEN-FLEX-PT-AT-CMP Element: Flex Pt At Cmp | Derived |
|
||||||||||||||||||||||||||||||
BEN-PT-AT-CMP Element: Pt At Cmp | Derived |
|
||||||||||||||||||||||||||||||
BEN-WK-FLEX-PT Element: Wk Flex Pt | Derived |
|
||||||||||||||||||||||||||||||
BEN-BI-FLEX-PT Element: Bi Flex Pt | Derived |
|
||||||||||||||||||||||||||||||
BEN-SM-FLEX-PT Element: Sm Flex Pt | Derived |
|
||||||||||||||||||||||||||||||
BEN-MO-FLEX-PT Element: Mo Flex Pt | Derived |
|
||||||||||||||||||||||||||||||
BEN-WK-FLEX-PT-AT Element: Wk Flex Pt At | Derived |
|
||||||||||||||||||||||||||||||
BEN-BI-FLEX-PT-AT Element: Bi Flex Pt At | Derived |
|
||||||||||||||||||||||||||||||
BEN-SM-FLEX-PT-AT Element: Sm Flex Pt At | Derived |
|
||||||||||||||||||||||||||||||
BEN-MO-FLEX-PT-AT Element: Mo Flex Pt At | Derived |
|
||||||||||||||||||||||||||||||
BEN-PP-FLEX-PT Element: Pp Flex Pt | Derived |
|
||||||||||||||||||||||||||||||
BEN-PP-FLEX-PT-AT Element: Pp Flex Pt At | Derived |
|
||||||||||||||||||||||||||||||
BEN-CURRENCY-CODE Element: Currency Code | Alpha 5 This field contains the company base currency code established in Company (GL10.1 ). |
|
||||||||||||||||||||||||||||||
BEN-CURR-ND Element: Acct Nd | Numeric 1 The number of decimals assigned to a particular account as determined by the account currency. |
|
||||||||||||||||||||||||||||||
BEN-USER-ID Element: User | Alpha 10 (Lower Case) |
|
||||||||||||||||||||||||||||||
BEN-TIME-STAMP Element: Time Stamp | Numeric 6 (hhmmss) Contains the server time (hour, minute, and second) when the record was last changed. |
|
||||||||||||||||||||||||||||||
BEN-TRAN-SEQ-NBR Element: Seq Nbr | Numeric 4 An automatically assigned sequence number. |
|
||||||||||||||||||||||||||||||
BEN-TA-OBJ-ID Element: Obj Id | Numeric 12 This 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. |
|
||||||||||||||||||||||||||||||
BEN-CO-PCT-AMT Element: Pct Amt Flag | Alpha 1 A = Amount P = Percent |
|
||||||||||||||||||||||||||||||
BEN-EMP-YTD-CONT Element: Ytd Cont | Signed 13.2 |
|
||||||||||||||||||||||||||||||
BEN-DED-START-DATE Element: Start Date | Numeric 8 (yyyymmdd) |
|
||||||||||||||||||||||||||||||
BEN-DED-STOP-DATE Element: Stop Date | Numeric 8 (yyyymmdd) |
|
||||||||||||||||||||||||||||||
BEN-CREATE-TIME Element: Time Stamp | Numeric 6 (hhmmss) |
|
||||||||||||||||||||||||||||||
BEN-CREATE-USER-ID Element: User Id | Alpha 10 (Lower Case) |
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Aft Ded Code A | EMDEDMASTR |
Required
| ||||||||||||||||||||||||
Aft Ded Code P | EMDEDMASTR |
Required
| ||||||||||||||||||||||||
Aft Ded Mtch A | EMDEDMASTR |
Required
| ||||||||||||||||||||||||
Aft Ded Mtch P | EMDEDMASTR |
Required
| ||||||||||||||||||||||||
Bncovopt | BNCOVOPT |
Required
| ||||||||||||||||||||||||
Cmp Ded Code A | EMDEDMASTR |
Required
| ||||||||||||||||||||||||
Cmp Ded Code P | EMDEDMASTR |
Required
| ||||||||||||||||||||||||
Company | BNCOMPANY |
Required
| ||||||||||||||||||||||||
Company Name | PRSYSTEM |
Required
| ||||||||||||||||||||||||
Cont Group | PERSGROUP |
Not Required
| ||||||||||||||||||||||||
Contrib 0 | PLAN |
Required
| ||||||||||||||||||||||||
Contrib 1 | PLAN |
Required
| ||||||||||||||||||||||||
Contrib 2 | PLAN |
Required
| ||||||||||||||||||||||||
Contrib 3 | PLAN |
Required
| ||||||||||||||||||||||||
Contrib 4 | PLAN |
Required
| ||||||||||||||||||||||||
Contrib 5 | PLAN |
Required
| ||||||||||||||||||||||||
Contrib 6 | PLAN |
Required
| ||||||||||||||||||||||||
Contrib 7 | PLAN |
Required
| ||||||||||||||||||||||||
Cov Group | PERSGROUP |
Not Required
| ||||||||||||||||||||||||
Coverage 0 | PLAN |
Required
| ||||||||||||||||||||||||
Coverage 1 | PLAN |
Required
| ||||||||||||||||||||||||
Coverage 2 | PLAN |
Required
| ||||||||||||||||||||||||
Currency | CUCODES |
Required
| ||||||||||||||||||||||||
Elig Group | PERSGROUP |
Not Required
| ||||||||||||||||||||||||
Emp Flex Ded | EMDEDMASTR |
Required
| ||||||||||||||||||||||||
Employee | EMPLOYEE |
Required
| ||||||||||||||||||||||||
Flex Plan | FLEXPLAN |
Required
| ||||||||||||||||||||||||
Gl Group | PERSGROUP |
Not Required
| ||||||||||||||||||||||||
Pa Employee | PAEMPLOYEE |
Required
| ||||||||||||||||||||||||
Plan | PLAN |
Required
| ||||||||||||||||||||||||
Pre Ded Code A | EMDEDMASTR |
Required
| ||||||||||||||||||||||||
Pre Ded Code P | EMDEDMASTR |
Required
| ||||||||||||||||||||||||
Pre Ded Mtch A | EMDEDMASTR |
Required
| ||||||||||||||||||||||||
Pre Ded Mtch P | EMDEDMASTR |
Required
| ||||||||||||||||||||||||
Standtime | STANDTIME |
Not Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Beneficiaries | BENEFICRY |
Delete Restricted
| |||||||||||||||||||||||||||
Bn Ta Employee | BNTAEMPBAL |
| |||||||||||||||||||||||||||
Bond Beneficry | BONDBENIF |
Delete Restricted
| |||||||||||||||||||||||||||
Coda Account | CODA |
Delete Restricted
| |||||||||||||||||||||||||||
Comphist | COMPHIST |
Delete Restricted
| |||||||||||||||||||||||||||
Deductions | EMDEDMASTR |
| |||||||||||||||||||||||||||
Dependents | HRDEPBEN |
Delete Restricted
| |||||||||||||||||||||||||||
Emp Comments | BNCOMMENTS |
| |||||||||||||||||||||||||||
Invest Distrib | EMPINVEST |
Delete Cascades
| |||||||||||||||||||||||||||
Res Acct Trans | RESTRANS |
Delete Restricted
| |||||||||||||||||||||||||||
Stock Purchase | SPHIST |
Delete Restricted
| |||||||||||||||||||||||||||
Vesting Hours | VESTHOURS |
Delete Restricted
|
All trademarks and registered trademarks are the property of their
respective owners.