BNCYCDTL

This table is used by Web Benefit Enrollment Task to display and create the server costs for mid year enrollments into spending account type plans. It contains the detail of each Cycle Plan including date ranges and the number of remaining cycles for that date range. It is used with the header table, BNCYCLE.

REFERENCED BY
BS10.1 BS15.1


UPDATED BY
BS06.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BCC-COMPANY
Element: Company Hr
Numeric 4
Company needs to exist in the PRSYSTEM table.
BS06.1
BCC-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
BCC-EFFECT-DATE
Element: Effect Date
Numeric 8 (yyyymmdd)
Effective Date of Cycle Plan
BS06.1
BCC-CYCLE-FREQ
Element: Cycle Freq
Numeric 1
Same frequencies as employee's pay frequency values. Used to automatically generate 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
BCC-CYCLE-BEGIN-DT
Element: Cycle Begin Dt
Numeric 8 (yyyymmdd)
Contains the cycle period start date.
BS06.1
BCC-CYCLE-END-DATE
Element: Cycle End Date
Numeric 8 (yyyymmdd)
Contains the cycle period end date.
BS06.1
BCC-REMAIN-CYCLES
Element: Remain Cycles
Numeric 2
Determined by Web Enrollment Date (New Election Date on BS01) and the number of remaining Cycle Periods for the enrollment period. Cycle Period Date Ranges are determined by the First Cycle Period End Date and the Cycle Frequency. The BS10 and BS15 programs will display the Remain Cycles value in the new screen fields called Cost Divisor Remaining Cycles and/or Pay Frequency Remaining Cycles. The Web Benefit Enrollment Task performs an AGS call to the BS10 and BS15 programs to access the Remain Cycles value to display and create the correct costs for mid year enrollments into spending account type plans.
BS06.1 BS10.1
BCC-CREATE-DATE
Element: Date Stamp
Numeric 8 (yyyymmdd)
BS06.1
BCC-CREATE-TIME
Element: Time Stamp
Numeric 6 (hhmmss)
BS06.1
BCC-CREATE-USER-ID
Element: User Id
Alpha 10 (Lower Case)
BS06.1
BCC-DATE-STAMP
Element: Date Stamp
Numeric 8 (yyyymmdd)
BS06.1
BCC-TIME-STAMP
Element: Time Stamp
Numeric 6 (hhmmss)
BS06.1
BCC-USER-ID
Element: User Id
Alpha 10 (Lower Case)
BS06.1


BNCYCDTL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BCCSET1 COMPANY
CYCLE-PLAN
EFFECT-DATE
CYCLE-FREQ
CYCLE-END-DATE
BS06.1 BS10.1
BS15.1
BCCSET2 COMPANY
CYCLE-PLAN
EFFECT-DATE
CYCLE-FREQ
CYCLE-END-DATE*
BCCSET3 COMPANY
CYCLE-PLAN
EFFECT-DATE
CYCLE-FREQ
CYCLE-BEGIN-DT*


BNCYCDTL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
BCC-COMPANY->PRS-COMPANY (PRSSET1)
Spaces->PRS-PROCESS-LEVEL
Cycles Plan BNCYCLE Required
BCC-COMPANY->BCY-COMPANY
BCC-CYCLE-PLAN->BCY-CYCLE-PLAN
BCC-EFFECT-DATE->BCY-EFFECT-DATE
BCC-CYCLE-FREQ->BCY-CYCLE-FREQ


File created: Thu Jun 09 02:09:58 2016

Home
Contact Us



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