Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             BNCOMPANY FILE

                       Benefit Company Parameters

The Benefit Company Parameters file contains parameters for the benefits
company. BN00.1 (Benefits Company) is the primary program that updates this
file.

REFERENCED BY

BN02.1    BN02.2    BN02.3    BN02.4    BN02.5    BN03.1
BN04.1    BN05.1    BN06.1    BN08.1    BN101     BN102
BN103     BN104     BN105     BN13.1    BN138     BN140
BN141     BN145     BN15.1    BN150     BN16.1    BN16.2
BN16.3    BN16.4    BN170     BN171     BN175     BN18.1
BN18.2    BN18.3    BN18.4    BN18.5    BN18.6    BN18.7
BN19.1    BN19.2    BN19.3    BN19.4    BN190     BN200
BN202     BN203     BN204     BN206     BN215     BN230
BN231     BN232     BN233     BN236     BN237     BN238
BN240     BN242     BN245     BN246     BN247     BN248
BN252     BN258     BN259     BN270     BN281     BN285
BN30.1    BN300     BN305     BN31.1    BN31.2    BN310
BN32.1    BN32.2    BN32.3    BN320     BN325     BN330
BN331     BN335     BN340     BN345     BN35.1    BN350
BN36.1    BN430     BN45.1    BN46.2    BN47.1    BN48.1
BN48.2    BN480     BN50.1    BN500     BN51.1    BN51.2
BN52.1    BN531     BN532     BN547     BN55.1    BN555
BN56.1    BN57.1    BN59.1    BN60.1    BN61.1    BN65.1
BN66.1    BN71.1    BN72.1    BN77.1    BN80.1    BN81.1
BN81.2    BN82.1    BN85.1    BN90.1    BS01.1    BS02.1
BS03.1    BS03.2    BS03.3    BS09.1    BS10.1    BS11.1
BS12.1    BS13.1    BS14.1    BS15.1    BS32.1    HPLN.1
HR00.1    HR01.1    HR13.2    HR13.3    HR13.4    PBIP.1
PR197

UPDATED BY

BN00.1    BN00.2    BN00.3    BN00.4    BN100     BN180
BN181     BN70.1    PA100     PA52.1    PA52.5

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

BNC-COMPANY          Numeric 4                                   BN00.1  BN00.2
Company              Contains the company number. The number     BN00.3  BN00.4
                     correlates all information about the
                     company.

BNC-CSH-DIST-CO      Numeric 4                                   BN00.1
Csh Dist Co

BNC-CSH-ACCT-UNT     Alpha 15                                    BN00.1
Cash Account Unit    Contains the accounting unit for
                     posting payments from COBRA participants
                     and retirees.

BNC-CSH-ACCOUNT      Numeric 6                                   BN00.1
Cash Account         Contains the account for posting
                     payments from COBRA participants and
                     retirees.

BNC-CSH-SUB-ACCT     Numeric 4                                   BN00.1
Cash Sub-Account     Contains the subaccount for posting
                     payments from COBRA participants and
                     retirees.

BNC-INS-COV-LIM      Signed 11.2                                 BN00.4
Insurance Coverage   Contains the maximum amount of life
Limit                insurance coverage for which the cost is
                     non-taxable.

BNC-RET-DUE-DAYS     Numeric 3                                   BN00.1
Retirees Due Days    Contains the number of days from an
                     invoice date that retiree premiums are
                     due. The system calculates due dates for
                     invoices using this field.

BNC-PCT-COV-COMP     Signed 5.3
Pct Cov Comp         This field is not used.

BNC-EXC-DIST-CO      Numeric 4                                   BN00.2
Exc Dist Co

BNC-EXC-ACCT-UNT     Alpha 15                                    BN00.2
Excess Premium       Contains the accounting unit for
Account Unit         posting the excess premium charged to
                     COBRA participants.

BNC-EXC-ACCOUNT      Numeric 6                                   BN00.2
Excess Premium       Contains the account for posting the
Account              excess premiums charged to COBRA
                     participants.

BNC-EXC-SUB-ACCT     Numeric 4                                   BN00.2
Excess Premium       Contains the subaccount for posting
Sub-Account          excess premiums charged to COBRA
                     participants.

BNC-NOT-EVENT        Numeric 3                                   BN00.2
Employee             Contains the number of days that an
Notification Days    employee or qualified beneficiary has to
                     notify the employer of a qualifying
                     event.

BNC-NOT-RIGHTS       Numeric 3                                   BN00.2
Company              Contains the number of days after a
Notification Days    qualifying event that the company has to
                     notify employees and qualified
                     beneficiaries of their right to extend
                     coverage.

BNC-NOT-ELECT        Numeric 3                                   BN00.2
Election             Contains the number of days that
Notification Days    employees and qualified beneficiaries
                     have to notify the company of their
                     election of coverage.

BNC-CBR-DUE-DAYS     Numeric 3                                   BN00.2
COBRA Due Days       Contains the number of days from an
                     invoice's due date that COBRA
                     participants and retirees must pay their
                     premium.

BNC-CBR-PREM-PCT     Signed 7.3                                  BN00.2
COBRA Premium        Contains the percent that the company
Percent              charges the participant to maintain the
                     COBRA account.

BNC-CBR-IN-GRACE     Numeric 3                                   BN00.2
COBRA Initial Grace  Contains the number of days from the
Period               due date of the first invoice that COBRA
                     participants and retirees must pay their
                     first premium.

BNC-CBR-RE-GRACE     Numeric 3                                   BN00.1
Remaining Payment    Contains the number of days used as a
Grace Per            grace period from the due date of the
                     invoice for retirees.

BNC-CBR-DLQ-LTR      Alpha 2                                     BN00.2
Delinquent Letter    Contains the code of the standard
                     letter sent to participants or retirees
                     who have delinquent payments.

BNC-CBR-MAX-MNTH     Numeric 2                                   BN00.3
Multiple Events      Contains the maximum number of months
Maximum              coverage extends for multiple
                     occurrences.

BNC-COST-PER-CVG     Signed 9.2                                  BN00.4
Cost Per Coverage    Contains the increment of coverage on
                     which premiums are based. This increment
                     is used in the calculation of excess
                     life insurance.

BNC-GRP-LIFE-AGE     Numeric 2 Occurs 14 Times                   BN00.4
Group Life Age       Contains the beginning age for the age
                     range used to calculate the cost of
                     excess life insurance coverage. The
                     field occurs 14 times. The system
                     calculates the ending age of the range.

BNC-GRP-LIFE-CST     Signed 7.3 Occurs 14 Times                  BN00.4
Group Life Cost      Contains the cost per dollar of life
                     insurance coverage in excess of the
                     limit.

BNC-AUTO-PART        Alpha 1                                     BN00.2
Auto Participant     Indicates whether the system should
Numbering            automatically number each COBRA
                     participant.
                     N = No
                     Y = Yes

BNC-LAST-PART        Numeric 9                                   BN00.2  BN100
Last Participant     Contains the last COBRA participant         BN70.1  PA100
                     number automatically assigned by the        PA52.1  PA52.5
                     system.

BNC-RET-INV-PER      Numeric 4                                   BN00.1  BN180
Retiree Invoice      Contains the month and year (MMYY) of       BN181
Period               the last invoice sent to retirees.

BNC-CBR-INV-PER      Numeric 4                                   BN00.2  BN180
Cobra/Retiree        Contains the month and year (MMYY) of       BN181
Invoice Period       the last invoice sent to COBRA
                     participants.

BNC-CUR-LIFE-PER     Numeric 4
Current Life         Contains the month and year (MMYY) of
Insurance Period     the last period for which BN150 (Life
                     Insurance Reportable Income) was run.

BNC-CUR-DL-PER       Numeric 4
Cur Dl Per           Contains the month and year (MMYY) of
                     the last period for which BN150 (Life
                     Insurance Reportable Income) was run for
                     dependent life calculations.

BNC-DL-COV-LIM       Signed 11.2                                 BN00.4
Dl Cov Lim           Contains the coverage limit that is
                     non-taxable for dependent life insurance
                     coverage.

BNC-DEP-HEALTH       Alpha 1                                     BN00.1
Health               Indicates whether the Benefits system
                     should track dependent coverage in
                     health plans.
                     Y = Yes
                     N = No

BNC-DEP-DENTAL       Alpha 1                                     BN00.1
Dental               Indicates whether the Benefits system
                     should track dependent coverage in
                     dental plans.
                     Y = Yes
                     N = No

BNC-DEP-EMP-LIFE     Alpha 1
Employee Life        Indicates whether the Benefits system
                     should track dependent coverage in
                     employee life/AD&D plans.
                     Y = Yes
                     N = No

BNC-DEP-DEP-LIFE     Alpha 1                                     BN00.1
Dependent Life       Indicates whether the Benefits system
                     should track dependent coverage in
                     dependent life/AD&D plans.
                     Y = Yes
                     N = No

                         BNCOMPANY FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BNCSET1   COMPANY                                                BN00.1  BN00.2
                                                                 BN00.3  BN00.4
                                                                 BN02.1  BN02.2
                                                                 BN02.3  BN02.4
                                                                 BN02.5  BN03.1
                                                                 BN04.1  BN05.1
                                                                 BN06.1  BN08.1
                                                                 BN100   BN101
                                                                 BN102   BN103
                                                                 BN104   BN105
                                                                 BN13.1  BN138
                                                                 BN140   BN141
                                                                 BN145   BN15.1
                                                                 BN150   BN16.1
                                                                 BN16.2  BN16.3
                                                                 ...

                         BNCOMPANY FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Cash Account   GLMASTER     Required

                            BNC-CSH-DIST-CO     -> GLM-COMPANY
                            BNC-CSH-ACCT-UNT    -> GLM-ACCT-UNIT
                            BNC-CSH-ACCOUNT     -> GLM-ACCOUNT
                            BNC-CSH-SUB-ACCT    -> GLM-SUB-ACCOUNT

Delinq Letter  LETTERCODE   Required
                            When BNC-CBR-DLQ-LTR != Spaces

                            BNC-COMPANY         -> LTC-COMPANY
                            BNC-CBR-DLQ-LTR     -> LTC-LETTER-CODE
                            Zeroes              -> LTC-EMPLOYEE
                            Zeroes              -> LTC-DEPENDENT
                            Zeroes              -> LTC-PARTICIPNT
                            Zeroes              -> LTC-DATE

Exc Prem Acct  GLMASTER     Required
                            When BNC-EXC-ACCT-UNT != Spaces
                            And  BNC-EXC-ACCOUNT  != Zeroes
                            And  BNC-EXC-SUB-ACCT != Zeroes

                            BNC-EXC-DIST-CO     -> GLM-COMPANY
                            BNC-EXC-ACCT-UNT    -> GLM-ACCT-UNIT
                            BNC-EXC-ACCOUNT     -> GLM-ACCOUNT
                            BNC-EXC-SUB-ACCT    -> GLM-SUB-ACCOUNT

Pr Company     PRSYSTEM     Required

                            BNC-COMPANY         -> PRS-COMPANY
                            Spaces              -> PRS-PROCESS-LEVEL

                         BNCOMPANY FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Benefit        BENEFIT      Delete Restricted

                            BNC-COMPANY         -> BEN-COMPANY
                                                   BEN-PLAN-TYPE
                                                   BEN-EMPLOYEE
                                                   BEN-START-DATE
                                                   BEN-PLAN-CODE

Bnaccounts     BNACCOUNTS

                            BNC-COMPANY         -> BNA-COMPANY
                                                   BNA-PLAN-TYPE
                                                   BNA-PLAN-CODE
                                                   BNA-START-DATE
                                                   BNA-GROUP-NAME
                                                   BNA-DED-CODE

Bncovdft       BNCOVDFT

                            BNC-COMPANY         -> BCD-COMPANY
                                                   BCD-PLAN-TYPE
                                                   BCD-PLAN-CODE
                                                   BCD-COVER-TYPE
                                                   BCD-START-DATE
                                                   BCD-GROUP-NAME
                                                   BCD-COVERAGE-OPT

Contrib Detail CONTRDETL    Delete Cascades

                            BNC-COMPANY         -> CND-COMPANY
                                                   CND-PLAN-TYPE
                                                   CND-PLAN-CODE
                                                   CND-START-DATE
                                                   CND-GROUP-NAME
                                                   CND-BEGIN-YEAR-PCT

Coverage       BNCOVERAGE

                            BNC-COMPANY         -> CVR-COMPANY
                                                   CVR-PLAN-TYPE
                                                   CVR-PLAN-CODE
                                                   CVR-COVER-TYPE
                                                   CVR-START-DATE
                                                   CVR-GROUP-NAME

Ded Freq Table DEDFREQTBL   Delete Restricted

                            BNC-COMPANY         -> DFT-COMPANY
                                                   DFT-TABLE-CODE

Flex Comments  BNCOMMENTS   Delete Restricted

                            BNC-COMPANY         -> BCM-COMPANY
                            "FL"                -> BCM-CMT-TYPE
                                                   BCM-EMPLOYEE
                                                   BCM-PARTICIPNT
                                                   BCM-PLAN-TYPE
                                                   BCM-PLAN-CODE
                                                   BCM-GROUP-NAME
                                                   BCM-START-DATE
                                                   BCM-SEQ-NBR

Flex Plans     FLEXPLAN     Delete Restricted

                            BNC-COMPANY         -> FLP-COMPANY
                                                   FLP-FLEX-PLAN

Invest Distrib BNINVEST     Delete Restricted

                            BNC-COMPANY         -> BIV-COMPANY
                                                   BIV-PLAN-CODE
                                                   BIV-SEQ-NBR

Letter Text    LETTERTEXT   Delete Restricted

                            BNC-COMPANY         -> LTT-COMPANY
                                                   LTT-LETTER-CODE
                                                   LTT-EMPLOYEE
                                                   LTT-DEPENDENT
                                                   LTT-PARTICIPNT
                                                   LTT-DATE
                                                   LTT-SEQ-NBR

Letters        LETTERCODE   Delete Restricted

                            BNC-COMPANY         -> LTC-COMPANY
                                                   LTC-LETTER-CODE
                                                   LTC-EMPLOYEE
                                                   LTC-DEPENDENT
                                                   LTC-PARTICIPNT
                                                   LTC-DATE

Occur Type     OCCURTYPE    Delete Restricted

                            BNC-COMPANY         -> OCC-COMPANY
                                                   OCC-OCCUR-TYPE

Participant    PARTICIPNT   Delete Restricted

                            BNC-COMPANY         -> PAR-COMPANY
                                                   PAR-PARTICIPNT

Plan           PLAN         Delete Restricted

                            BNC-COMPANY         -> PLN-COMPANY
                                                   PLN-PLAN-TYPE
                                                   PLN-PLAN-CODE

Premiums       PREMIUM      Delete Cascades

                            BNC-COMPANY         -> PRE-COMPANY
                                                   PRE-PLAN-TYPE
                                                   PRE-PLAN-CODE
                                                   PRE-COVER-TYPE
                                                   PRE-START-DATE
                                                   PRE-GROUP-NAME

Rate Tables    RATETBLHDR   Delete Cascades

                            BNC-COMPANY         -> RTH-COMPANY
                                                   RTH-TABLE-CODE
                                                   RTH-START-DATE

Rate Tbl Dtl   RATETBLDTL

                            BNC-COMPANY         -> RTD-COMPANY
                                                   RTD-TABLE-CODE
                                                   RTD-START-DATE
                                                   RTD-BEG-AGE-YR-SAL
                                                   RTD-SMOKER

Vest Sched Dtl VESTSCHDDT   Delete Restricted

                            BNC-COMPANY         -> VSD-COMPANY
                                                   VSD-VEST-SCHED
                                                   VSD-SERV-YEARS

Vesting Sched  VESTSCHDHD   Delete Restricted

                            BNC-COMPANY         -> VSH-COMPANY
                                                   VSH-VEST-SCHED