BNCYCDTL – This table is used by Web Benefit Enrollment Task to display and create the server costs for mid year enrollments into…

System
Benefits (BN)
Prefix
BCC
Primary key
COMPANY, CYCLE-PLAN, EFFECT-DATE, CYCLE-FREQ, CYCLE-END-DATE
Fields
13
Updated by
1 program
Referenced by
2 programs

BNCYCDTL is the This table is used by Web Benefit Enrollment Task to display and create the server costs for mid year enrollments into… table in Lawson Benefits (prefix BCC). It is indexed by COMPANY, CYCLE-PLAN, EFFECT-DATE, CYCLE-FREQ, CYCLE-END-DATE (BCCSET1); alternate indexes: BCCSET2 and BCCSET3. It is related 1:1 to PRSYSTEM and BNCYCLE. It is updated by BS06.1 and referenced by BS10.1 and BS15.1. The table has 13 fields, 3 indexes and 2 documented relations.

About 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.

Fields (13)

Column = COBOL field name without the BCC- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
BCC-COMPANY PK
COMPANY		Numeric 4Company needs to exist in the PRSYSTEM table.BS06.1
BCC-CYCLE-PLAN PK
CYCLE_PLAN		Alpha 4Contains 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 PK
EFFECT_DATE		Numeric 8 (yyyymmdd)Effective Date of Cycle PlanBS06.1
BCC-CYCLE-FREQ PK
CYCLE_FREQ		Numeric 1Same 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
CYCLE_BEGIN_DT		Numeric 8 (yyyymmdd)Contains the cycle period start date.BS06.1
BCC-CYCLE-END-DATE PK
CYCLE_END_DATE		Numeric 8 (yyyymmdd)Contains the cycle period end date.BS06.1
BCC-REMAIN-CYCLES
REMAIN_CYCLES		Numeric 2Determined 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
CREATE_DATE		Numeric 8 (yyyymmdd)—BS06.1
BCC-CREATE-TIME
CREATE_TIME		Numeric 6 (hhmmss)—BS06.1
BCC-CREATE-USER-ID
CREATE_USER_ID		Alpha 10 (Lower Case)—BS06.1
BCC-DATE-STAMP
DATE_STAMP		Numeric 8 (yyyymmdd)—BS06.1
BCC-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)—BS06.1
BCC-USER-ID
USER_ID		Alpha 10 (Lower Case)—BS06.1

Indexes (3)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
BCCSET1COMPANY, CYCLE-PLAN, EFFECT-DATE, CYCLE-FREQ, CYCLE-END-DATEPrimaryBS06.1, BS10.1, BS15.1
BCCSET2COMPANY, CYCLE-PLAN, EFFECT-DATE, CYCLE-FREQ, CYCLE-END-DATE*—
BCCSET3COMPANY, CYCLE-PLAN, EFFECT-DATE, CYCLE-FREQ, CYCLE-BEGIN-DT*—

Relations

One to one (2) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequiredBCC-COMPANY → PRS-COMPANY (PRSSET1), Spaces → PRS-PROCESS-LEVEL
Cycles PlanBNCYCLERequiredBCC-COMPANY → BCY-COMPANY, BCC-CYCLE-PLAN → BCY-CYCLE-PLAN, BCC-EFFECT-DATE → BCY-EFFECT-DATE, BCC-CYCLE-FREQ → BCY-CYCLE-FREQ

Programs

Updated by (1)

Referenced by (2)