Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

BNCOMPANY


                             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     BN106     BN13.1    BN138
BN140     BN141     BN145     BN15.1    BN15.2    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    BN51.1
BN51.2    BN52.1    BN53.1    BN531     BN532     BN547
BN55.1    BN555     BN56.1    BN57.1    BN59.1    BN60.1
BN61.1    BN65.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
Element: Company Hr    Contains the company number. The number   BN00.3  BN00.4
                       correlates all information about the
                       company.

BNC-CSH-DIST-CO        Numeric 4                                 BN00.1
Element: Company

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

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

BNC-CSH-SUB-ACCT       Numeric 4                                 BN00.1
Element: Cash Sub-AccouContains 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
Element: Retirees Due DContains 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
Element: Pct Cov Comp  This field is not used.

BNC-EXC-DIST-CO        Numeric 4                                 BN00.2
Element: Company

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
Element: COBRA Due DaysContains 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
Element: Delinquent LetContains 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
Element: Cost Per CoverContains 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
Element: Group Life AgeContains 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
Element: Group Life CosContains 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
Element: Last ParticipaContains 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
Element: 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
Element: Dl Cov Lim    Contains the coverage limit that is
                       non-taxable for dependent life insurance
                       coverage.

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

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

BNC-DEP-EMP-LIFE       Alpha 1
Element: 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
Element: Dependent LifeIndicates whether the Benefits system
                       should track dependent coverage in
                       dependent life/AD&D plans.
                       Y = Yes
                       N = No

BNC-SPONSOR-ID         Alpha 30                                  BN00.1
Element: Sponsor Id

                         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
                                                                 BN106   BN13.1
                                                                 BN138   BN140
                                                                 BN141   BN145
                                                                 BN15.1  BN15.2
                                                                 BN150   BN16.1
                                                                 ...

                         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

Stock Exer     BNEMPEXER

                            BNC-COMPANY         -> BXR-COMPANY
                                                   BXR-EMPLOYEE
                                                   BXR-OPT-GRANT-NBR
                                                   BXR-STOCK-CTF
                                                   BXR-EXERCISE-DATE
                                                   BXR-SEQ-NBR

Stock Grant    BNEMPGRNT

                            BNC-COMPANY         -> BEG-COMPANY
                                                   BEG-EMPLOYEE
                                                   BEG-OPT-GRANT-NBR
                                                   BEG-STOCK-CTF

Stock Opt Pln  BNSTKGNT

                            BNC-COMPANY         -> BSG-COMPANY
                                                   BSG-OPT-GRANT-NBR

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