This database table is used for the Web Benefit Enrollment processing. It contains the header information of a Cycle Plan and is used with the BNCYCDTL table that contains the Remaining Cycles for specific Begin and End Dates.

REFERENCED BY

BS10.1

BS15.1

UPDATED BY

BS06.1

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
BCY-COMPANY Element: Hr Company	Numeric 4 Company needs to exist in the PRSYSTEM table.	BS06.1
BCY-CYCLE-PLAN Element: Cycle Plan	Alpha 4 Contains the user-defined code that represents a Cycle Plan. A Cycle Plan determines the remaining cycle values for the web benefit enrollment task to use to display and create the correct costs for mid year enrollments into spending account type plans.	BS06.1
BCY-EFFECT-DATE Element: Effect Date	Numeric 8 (yyyymmdd) Effective Date of Cycle Plan	BS06.1
BCY-DESCRIPTION Element: Description	Alpha 30 (Lower Case) This field displays the cycle plan description.	BS06.1
BCY-PER-END-DATE Element: Per End Date	Numeric 8 (yyyymmdd) First Cycle Period End Date used to automatically generate Begin and End Date Ranges and Remaining Cycle values.	BS06.1
BCY-CYCLE-FREQ Element: Cycle Freq	Numeric 1 Same frequencies as employee's pay frequency values. Used to automatically generate Cycle Begin and End Date Ranges and Remaining Cycle values. 1 = Weekly 2 = Bi-weekly 3 = Semi-monthly 4 = Monthly 6 = Nonstandard Semi-monthly	BS06.1
BCY-CREATE-DATE Element: Date Stamp	Numeric 8 (yyyymmdd)	BS06.1
BCY-CREATE-TIME Element: Time Stamp	Numeric 6 (hhmmss)	BS06.1
BCY-CREATE-USER-ID Element: User Id	Alpha 10 (Lower Case)	BS06.1
BCY-DATE-STAMP Element: Date Stamp	Numeric 8 (yyyymmdd)	BS06.1
BCY-TIME-STAMP Element: Time Stamp	Numeric 6 (hhmmss)	BS06.1
BCY-USER-ID Element: User Id	Alpha 10 (Lower Case)	BS06.1

BNCYCLE FILE INDEX

BNCYCLE FILE RELATIONS

ONE TO ONE RELATIONS

BNCYCLE FILE RELATIONS

ONE TO MANY RELATIONS

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