|
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.
REFERENCED BY
BN66.1
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
Element: Comp Flx Amt This field contains the company flex
credits amount.
BSH-EMP-FLEX-AMT Signed 11.2 BN65.1
Element: Emp Flex Amt This field contains the employee flex
credit amount.
BSH-VAC-CREDIT Signed 11.2
Element: Vac Credit This field contains the vacation credit
amount.
BSH-COMP-SPENT Signed 11.2 BN65.1
Element: Comp Spent This field contains the amount of
company spent dollars.
BSH-EMP-SPENT Signed 11.2 BN65.1
Element: Emp Spent This field contains the employee flex
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
Element: Acct Nd The number of decimals assigned to a
particular account as determined by the
account currency.
BNSIMHDR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BSHSET1 COMPANY BN00.1 BN65.1
EMPLOYEE BN65.2 BN66.1
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
|