|
BNSIMHDR FILE
Benefit Simulation
The Benefit Simulation Header file contains information for simulating
employee benefit deductions and pay. This file stores employee taxable pay,
employee contribution amounts, and company contribution amounts.
BN66.1 (Estimated Pay Calculation) is the primary program that updates this
file.
UPDATED BY
BN00.1 BN65.1 HR11.1 PA115
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BSH-COMPANY Numeric 4 BN65.1
Element: Company Hr The company number represents an
established company and is entered on
all function codes.
BSH-EMPLOYEE Numeric 9 BN65.1
Element: Employee Employee number is assigned to each
person employed by the company. It is
used to correlate all information
related to the employee.
BSH-DATE Numeric 8 (yyyymmdd) BN65.1
Element: Date This field contains the date that the
benefit simulation was created.
BSH-GROSS-PAY Signed 13.2 BN65.1
Element: Gross Pay This field contains the simulation
gross pay.
BSH-COMP-FLX-AMT Signed 11.2 BN65.1
Company Paid Flex This field contains the company flex
Dollar Amt credits amount.
BSH-EMP-FLEX-AMT Signed 11.2 BN65.1
Employee Flex This field contains the employee flex
Dollar Amount credit amount.
BSH-VAC-CREDIT Signed 11.2
Element: Vacation CrediThis field contains the vacation credit
amount.
BSH-COMP-SPENT Signed 11.2 BN65.1
Element: Flex Dollars SThis field contains the amount of
company spent dollars.
BSH-EMP-SPENT Signed 11.2 BN65.1
Employee Pre-tax This field contains the employee flex
Dollars Spent dollars spent.
BSH-ADD-TO-GRS-PCT Signed 5.2 BN65.1
Element: Add To Grs PctContains the percent of unspent flex
dollars that can be added to employee
taxable wages.
BSH-CURRENCY-CODE Alpha 5
Element: Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
BSH-CURR-ND Numeric 1
Account Currency Represents the number of decimals
Code defined for the currency of the object.
BNSIMHDR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BSHSET1 COMPANY BN00.1 BN65.1
EMPLOYEE BN65.2 HR11.1
PA115
BNSIMHDR FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company BNCOMPANY Required
BSH-COMPANY -> BNC-COMPANY
Company Name PRSYSTEM Required
BSH-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Currency CUCODES Required
BSH-CURRENCY-CODE -> CUC-CURRENCY-CODE
Employee EMPLOYEE Required
BSH-COMPANY -> EMP-COMPANY
BSH-EMPLOYEE -> EMP-EMPLOYEE
BNSIMHDR FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Simulation Dtl BNSIMDTL Delete Restricted
BSH-COMPANY -> BSD-COMPANY
BSH-EMPLOYEE -> BSD-EMPLOYEE
BSD-PLAN-TYPE
BSD-PLAN-CODE
|