Flex Dollars

The Flex Dollars file contains the parameters used to calculate flex dollars for employees. BN08.1 (Flex Dollars) is the primary program that updates this file.

REFERENCED BY

BN02.1	BN02.3	BN02.2	BN02.4	BN02.5	BN06.1
BN104	BN206	BN238	BN246	BN258	BN259
BN325	HR55.1	LP138

UPDATED BY

BN00.1	BN08.1	BN90.1	BN100	BN101	BN102
BN103	BN105	BN145	BN232	BN245	BN260
BN31.1	BN31.2	BN32.1	BN32.2	BN32.3	BN320
BN331	BN340	BN45.1	BN531	BN65.1	BN71.1
BN72.1	BS09.1	BS10.1	BS11.1	BS12.1	BS13.1
BS14.1	BS15.1	BS32.1	ZB01.1	ZB10.1	ZB10.2
ZB31.1	ZB31.2	ZB32.1	ZB32.2	ZB32.3

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
FLD-COMPANY Element: Company Hr	Numeric 4 Contains the company number.	BN08.1
FLD-FLEX-PLAN Element: Flex Plan	Alpha 4 Contains the flex plan name.	BN08.1
FLD-START-DATE Element: Start Date	Numeric 8 (yyyymmdd) Contains the flex dollar start date. The month and date corresponds to the month and date on the flex plan.	BN08.1
FLD-GROUP-NAME Element: Group Name	Alpha 10 Contains the employee group used to define flex dollars.	BN08.1
FLD-STOP-DATE Element: Stop Date	Numeric 8 (yyyymmdd) Contains the flex dollar's stop date. This is calculated as 12 months from the start date.	BN08.1
FLD-CMP-BASE-AMT Element: Cmp Base Amt	Signed 11.2 Contains the base amount of dollars the company gives each employee.	BN08.1
FLD-CMP-BASE-PCT Element: Cmp Base Pct	Signed 5.2 Contains the percent of an employee's salary used to determine how many flex dollars the employee receives.	BN08.1
FLD-ADD-TO-GRS-PCT Element: Add To Grs Pct	Signed 5.2 Contains the percent of unspent flex dollars which employees can add to taxable wages.	BN08.1
FLD-MIN-TOT-CREDTS Element: Min Tot Credts	Signed 11.2 Contains the minimum number of credits an employee receives.	BN08.1
FLD-MAX-TOT-CREDTS Element: Max Tot Credts	Signed 11.2 Contains the maximum number of credits an employee receives.	BN08.1
FLD-EMP-BASE-AMT Element: Emp Base Amt	Signed 11.2 Contains the amount of an employee's salary which can be spent on a pre-tax basis to purchase benefits.	BN08.1
FLD-EMP-BASE-PCT Element: Emp Base Pct	Signed 5.2 Contains the percent of an employee's salary which can be spent on a pre-tax basis to purchase benefits.	BN08.1
FLD-SALARY-TYPE Element: Salary Type	Alpha 2 Defines the salary that is used to calculate the flex dollars. EM = HR11 Salary B1 = Benefit Salary 1 B2 = Benefit Salary 2 B3 = Benefit Salary 3 B4 = Benefit Salary 4 B5 = Benefit Salary 5 E1 = HR11 and Ben Sal 1 E2 = HR11 and Ben Sal 2 E3 = HR11 and Ben Sal 3 E4 = HR11 and Ben Sal 4 E5 = HR11 and Ben Sal 5 ET = Total Emp Salary T1 = Total Emp and Sal 1 T2 = Total Emp and Sal 2 T3 = Total Emp and Sal 3 T4 = Total Emp and Sal 4 T5 = Total Emp and Sal 5 X = Custom Calculation	BN08.1
FLD-SALARY-DATE Element: Salary Date	Numeric 4 (mmdd) If flex dollars are based on the employee's salary, and the salary is determined on a specific month and day, this field contains the date the salary is determined.	BN08.1
FLD-SAL-FIRST-MO Element: Sal First Mo	Alpha 1 If flex dollars are based on salary, this field determines the salary calculation date. C = Current M = First of Month A = As of Date	BN08.1
FLD-SAL-ROUND-METH Element: Sal Round Meth	Alpha 1 If flex dollars are based on salary, this field defines how the salary amount should be rounded. H = High L = Low R = Normal N = No Rounding	BN08.1
FLD-SAL-BEF-AFT Element: Sal Bef Aft	Alpha 1 If flex dollars are based on the salary, this field defines when the salary should be rounded. It does not affect the calculation. B = Before A = After	BN08.1
FLD-SAL-ROUND-TO Element: Sal Round To	Signed 9.4 If the salary amount is rounded, this defines to what place the amount is rounded.	BN08.1
FLD-MIN-SALARY Element: Min Salary	Signed 11.2 Contains the minimum salary for calculating flex dollars. If an employee's salary is less than this amount, the system uses this amount to calculate flex dollars for the employee.	BN08.1
FLD-MAX-SALARY Element: Max Salary	Signed 11.2 Contains the maximum salary that can be used in the flex dollar calculation. If the employee's salary is greater than this amount, the system uses this amount to calculate flex dollars for the employee.	BN08.1
FLD-AGE-DATE Element: Age Date	Numeric 4 (mmdd) If flex dollars are based on a specific age, this field contains the date on which the age is calculated.	BN08.1
FLD-AGE-FIRST-MO Element: Age First Mo	Alpha 1 If the flex dollars are calculated for specific ages, this field determines the age calculation date. C = Current M = First of Month A = As of Date	BN08.1
FLD-AGE-RATE-TBL Element: Age Rate Tbl	Alpha 4 If flex dollars are calculated for specific ages, this is the table used to define flex dollars ages.	BN08.1
FLD-AGE-CREDIT Element: Age Credit	Signed 11.2 Contains the age flex credits.	BN08.1
FLD-AGE-ROUND-METH Element: Age Round Meth	Alpha 1 If flex dollars are based on age, this field defines how the age credits should be rounded. H = High L = Low R = Normal N = No Rounding	BN08.1
FLD-AGE-BEF-AFT Element: Age Bef Aft	Alpha 1 If flex dollars are based on age, this field determines when rounding is performed. It has no affect on calculations. B = Before A = After	BN08.1
FLD-AGE-ROUND-TO Element: Age Round To	Signed 9.4 If flex credits are rounded, this field defines to what place the amount is rounded.	BN08.1
FLD-AGE-MIN-CREDTS Element: Age Min Credts	Signed 11.2 Contains the minimum number of credits for an age.	BN08.1
FLD-AGE-MAX-CREDTS Element: Age Max Credts	Signed 11.2 Contains the maximum number of credits for an age.	BN08.1
FLD-FROM-DATE Element: From Date	Alpha 2 Contains the code that defines the date from which service credits are calculated. HI = Hire Date AJ = Adjusted Hire Date AN = Anniversary Date SN = Seniority Date B1 = Benefit Date 1 B2 = Benefit Date 2 B3 = Benefit Date 3 B4 = Benefit Date 4 B5 = Benefit Date 5 X = Custom Calculation	BN08.1
FLD-SERV-DATE Element: Serv Date	Numeric 4 (mmdd) If flex dollars are based on service, and service is determined on a certain month and day, this field contains the day to be used.	BN08.1
FLD-SERV-FIRST-MO Element: Serv First Mo	Alpha 1 If the flex dollars include service credits, this field contains the service calculation month and days. C = Current M = First of Month A = As of Date	BN08.1
FLD-SERV-RATE-TBL Element: Serv Rate Tbl	Alpha 4 If flex dollars are calculated based on years of service, this is the rate table used to define the service credits.	BN08.1
FLD-SERV-CREDIT Element: Serv Credit	Signed 11.2 Contains the service flex credits.	BN08.1
FLD-SERV-RND-METH Element: Serv Rnd Meth	Alpha 1 If flex dollars are based on service, this field defines how the service credits should be rounded. H = High L = Low R = Normal N = No Rounding	BN08.1
FLD-SERV-BEF-AFT Element: Serv Bef Aft	Alpha 1 If service credits are rounded, this field defines the place to which the amount is rounded. B = Before A = After	BN08.1
FLD-SERV-ROUND-TO Element: Serv Round To	Signed 9.4 If the service credits are rounded, this defines to what place the amount is rounded.	BN08.1
FLD-SERV-MIN-CREDT Element: Serv Min Credt	Signed 11.2 Contains the minimum number of credits for a service.	BN08.1
FLD-SERV-MAX-CREDT Element: Serv Max Credt	Signed 11.2 Contains the maximum number of credits for a service.	BN08.1
FLD-DEP-FIRST-MO Element: Dep First Mo	Alpha 1 If flex dollars include dependent credits, this field contains the date used to determine the number of dependents from the HR History file. A = As of Date C = Current M = First of Month	BN08.1
FLD-DEP-RATE-TBL Element: Dep Rate Tbl	Alpha 4 If flex dollars are based on the number of dependents, this field contains the rate table used to define the number of dependent credits.	BN08.1
FLD-DEP-DATE Element: Dep Date	Numeric 4 (mmdd) If flex dollars are based on the number of dependents, this contains the month and year used to determine the number of dependents from the HR History file.	BN08.1
FLD-LIFE-FIRST-MO Element: Life First Mo	Alpha 1 If flex dollars are based on the number of lifestyle credits, this field contains the date used to define the number of lifestyle credits from the HR History file. A = As of Date C = Current M = First of Month	BN08.1
FLD-LIFE-RATE-TBL Element: Life Rate Tbl	Alpha 4 If flex dollars are based on the number of lifestyle credits, this field contains the rate table used to define the number of lifestyle credits.	BN08.1
FLD-LIFE-DATE Element: Life Date	Numeric 4 (mmdd) If flex dollars are based on the number of lifestyle credits, this field contains the month and year used to determine the number of lifestyle credits from the HR History file.	BN08.1
FLD-LAST-CMT-SEQ Element: Last Cmt Seq	Numeric 4 Contains the sequence number of the last comment.	BN90.1
FLD-SALARY-YEAR Element: Salary Year	Numeric 4 If flex dollars are based on salary year, and an "as of" date is used, this field contains the year.	BN08.1
FLD-AGE-YEAR Element: Age Year	Numeric 4 If flex dollars are based on age and an "as of" date is used, this field contains the year.	BN08.1
FLD-SERV-YEAR Element: Serv Year	Numeric 4 If flex credits are based on a service and an "as of" date is used, this field contains the year.	BN08.1
FLD-DEP-YEAR Element: Dep Year	Numeric 4 If flex dollars are based on dependents and an "as of" date is used, this field contains the year.	BN08.1
FLD-LIFE-YEAR Element: Life Year	Numeric 4 If flex dollars are based on lifestyle credits and an "as of" date is used, this field contains the year.	BN08.1
FLD-CASH-PLAN-FLAG Element: Cash Plan Flag	Alpha 1 " " = Not Applicable 1 = Cash 2 = Plan
FLD-AFTER-TAX-FLAG Element: After Tax Flag	Alpha 1 N = No Y = Yes
FLD-PLAN-TYPE-1 Element: Plan Type	Alpha 2
FLD-PLAN-TYPE-2 Element: Plan Type	Alpha 2
FLD-PLAN-TYPE-3 Element: Plan Type	Alpha 2
FLD-PLAN-TYPE-4 Element: Plan Type	Alpha 2
FLD-PLAN-CODE-1 Element: Plan Code	Alpha 4 Contains the user-defined code that represents a benefit plan.
FLD-PLAN-CODE-2 Element: Plan Code	Alpha 4 Contains the user-defined code that represents a benefit plan.
FLD-PLAN-CODE-3 Element: Plan Code	Alpha 4 Contains the user-defined code that represents a benefit plan.
FLD-PLAN-CODE-4 Element: Plan Code	Alpha 4 Contains the user-defined code that represents a benefit plan.
FLD-CREATE-DATE Element: Date Stamp	Numeric 8 (yyyymmdd)	BN08.1
FLD-CREATE-TIME Element: Time Stamp	Numeric 6 (hhmmss)	BN08.1
FLD-CREATE-USER-ID Element: User Id	Alpha 10 (Lower Case)	BN08.1
FLD-DATE-STAMP Element: Date Stamp	Numeric 8 (yyyymmdd)	BN08.1
FLD-TIME-STAMP Element: Time Stamp	Numeric 6 (hhmmss)	BN08.1
FLD-USER-ID Element: User Id	Alpha 10 (Lower Case)	BN08.1

FLEXDOLLAR FILE INDEX

FLEXDOLLAR FILE RELATIONS

ONE TO ONE RELATIONS

FLEXDOLLAR FILE RELATIONS

ONE TO MANY RELATIONS

All trademarks and registered trademarks are the property of their respective owners.