BNCOMPANY – Benefit Company Parameters

System
Benefits (BN)
Prefix
BNC
Primary key
COMPANY
Fields
43
Updated by
11 programs
Referenced by
152 programs

BNCOMPANY is the Benefit Company Parameters table in Lawson Benefits (prefix BNC). It is indexed by COMPANY (BNCSET1). It is related 1:1 to GLMASTER, LETTERCODE and PRSYSTEM and 1:M to BENEFIT, BNACCOUNTS, BNCOVDFT, CONTRDETL, BNCOVERAGE, DEDFREQTBL, BNCOMMENTS, FLEXPLAN and 14 more. It is updated by BN00.1, BN00.2, BN00.3, BN00.4, BN100, BN180, BN181, BN70.1 and 3 more and referenced by BN02.1, BN02.2, BN02.3, BN02.4, BN02.5, BN03.1, BN04.1, BN05.1 and 144 more. The table has 43 fields, 1 index and 26 documented relations.

About BNCOMPANY

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

Fields (43)

Column = COBOL field name without the BNC- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#BNC-COMPANY PK
COMPANY		Numeric 4Contains the company number. The number correlates all information about the company.BN00.1, BN00.2, BN00.3, BN00.4
#BNC-CSH-DIST-CO
CSH_DIST_CO		Numeric 4Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.BN00.1
#BNC-CSH-ACCT-UNT
CSH_ACCT_UNT		Alpha 15Contains the accounting unit for posting payments from COBRA participants and retirees.BN00.1
#BNC-CSH-ACCOUNT
CSH_ACCOUNT		Numeric 6Contains the account for posting payments from COBRA participants and retirees.BN00.1
#BNC-CSH-SUB-ACCT
CSH_SUB_ACCT		Numeric 4Contains the subaccount for posting payments from COBRA participants and retirees.BN00.1
#BNC-INS-COV-LIM
INS_COV_LIM		Signed 11.2Contains the maximum amount of life insurance coverage for which the cost is non-taxable.BN00.4
#BNC-RET-DUE-DAYS
RET_DUE_DAYS		Numeric 3Contains the number of days from an invoice date that retiree premiums are due. The system calculates due dates for invoices using this field.BN00.1
#BNC-PCT-COV-COMP
PCT_COV_COMP		Signed 5.3This field is not used.—
#BNC-EXC-DIST-CO
EXC_DIST_CO		Numeric 4Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.BN00.2
#BNC-EXC-ACCT-UNT
EXC_ACCT_UNT		Alpha 15Contains the accounting unit for posting the excess premium charged to COBRA participants.BN00.2
#BNC-EXC-ACCOUNT
EXC_ACCOUNT		Numeric 6Contains the account for posting the excess premiums charged to COBRA participants.BN00.2
#BNC-EXC-SUB-ACCT
EXC_SUB_ACCT		Numeric 4Contains the subaccount for posting excess premiums charged to COBRA participants.BN00.2
#BNC-NOT-EVENT
NOT_EVENT		Numeric 3Contains the number of days that an employee or qualified beneficiary has to notify the employer of a qualifying event.BN00.2
#BNC-NOT-RIGHTS
NOT_RIGHTS		Numeric 3Contains the number of days after a qualifying event that the company has to notify employees and qualified beneficiaries of their right to extend coverage.BN00.2
#BNC-NOT-ELECT
NOT_ELECT		Numeric 3Contains the number of days that employees and qualified beneficiaries have to notify the company of their election of coverage.BN00.2
#BNC-CBR-DUE-DAYS
CBR_DUE_DAYS		Numeric 3Contains the number of days from an invoice's due date that COBRA participants and retirees must pay their premium.BN00.2
#BNC-CBR-PREM-PCT
CBR_PREM_PCT		Signed 7.3Contains the percent that the company charges the participant to maintain the COBRA account.BN00.2
#BNC-CBR-IN-GRACE
CBR_IN_GRACE		Numeric 3Contains the number of days from the due date of the first invoice that COBRA participants and retirees must pay their first premium.BN00.2
#BNC-CBR-RE-GRACE
CBR_RE_GRACE		Numeric 3Contains the number of days used as a grace period from the due date of the invoice for retirees.BN00.1
#BNC-CBR-DLQ-LTR
CBR_DLQ_LTR		Alpha 2Contains the code of the standard letter sent to participants or retirees who have delinquent payments.BN00.2
#BNC-CBR-MAX-MNTH
CBR_MAX_MNTH		Numeric 2Contains the maximum number of months coverage extends for multiple occurrences.BN00.3
#BNC-COST-PER-CVG
COST_PER_CVG		Signed 9.2Contains the increment of coverage on which premiums are based. This increment is used in the calculation of excess life insurance.BN00.4
#BNC-GRP-LIFE-AGE
GRP_LIFE_AGE		Numeric 2 Occurs 14 Times ×14Contains 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.BN00.4
#BNC-GRP-LIFE-CST
GRP_LIFE_CST		Signed 7.3 Occurs 14 Times ×14Contains the cost per dollar of life insurance coverage in excess of the limit.BN00.4
#BNC-AUTO-PART
AUTO_PART		Alpha 1Indicates whether the system should automatically number each COBRA participant.
  • N No
  • Y Yes
BN00.2
#BNC-LAST-PART
LAST_PART		Numeric 9Contains the last COBRA participant number automatically assigned by the system.BN00.2, BN100, BN70.1, PA100, PA52.1, PA52.5
#BNC-RET-INV-PER
RET_INV_PER		Numeric 4Contains the month and year (MMYY) of the last invoice sent to retirees.BN00.1, BN180, BN181
#BNC-CBR-INV-PER
CBR_INV_PER		Numeric 4Contains the month and year (MMYY) of the last invoice sent to COBRA participants.BN00.2, BN180, BN181
#BNC-CUR-LIFE-PER
CUR_LIFE_PER		Numeric 4Contains the month and year (MMYY) of the last period for which BN150 (Life Insurance Reportable Income) was run.—
#BNC-CUR-DL-PER
CUR_DL_PER		Numeric 4Contains 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
DL_COV_LIM		Signed 11.2Contains the coverage limit that is non-taxable for dependent life insurance coverage.BN00.4
#BNC-DEP-HEALTH
DEP_HEALTH		Alpha 1Indicates whether the Benefits system should track dependent coverage in health plans.
  • Y Yes
  • N No
BN00.1
#BNC-DEP-DENTAL
DEP_DENTAL		Alpha 1Indicates whether the Benefits system should track dependent coverage in dental plans.
  • Y Yes
  • N No
BN00.1
#BNC-DEP-EMP-LIFE
DEP_EMP_LIFE		Alpha 1Indicates whether the Benefits system should track dependent coverage in employee life/AD&D plans.
  • Y Yes
  • N No
—
#BNC-DEP-DEP-LIFE
DEP_DEP_LIFE		Alpha 1Indicates whether the Benefits system should track dependent coverage in dependent life/AD&D plans.
  • Y Yes
  • N No
BN00.1
#BNC-SPONSOR-ID
SPONSOR_ID		Alpha 30—BN00.1
#BNC-DEP-VISION
DEP_VISION		Alpha 1—
  • N No
  • Y Yes
—
#BNC-CREATE-DATE
CREATE_DATE		Numeric 8 (yyyymmdd)—BN00.1, BN00.2, BN00.3, BN00.4
#BNC-CREATE-TIME
CREATE_TIME		Numeric 6 (hhmmss)—BN00.1, BN00.2, BN00.3, BN00.4
#BNC-CREATE-USER-ID
CREATE_USER_ID		Alpha 10 (Lower Case)—BN00.1, BN00.2, BN00.3, BN00.4
#BNC-DATE-STAMP
DATE_STAMP		Numeric 8 (yyyymmdd)—BN00.1, BN00.2, BN00.3, BN00.4
#BNC-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)—BN00.1, BN00.2, BN00.3, BN00.4
#BNC-USER-ID
USER_ID		Alpha 10 (Lower Case)—BN00.1, BN00.2, BN00.3, BN00.4

Indexes (1)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
BNCSET1
  1. COMPANY
PrimaryBN00.1, BN00.2, BN00.3, BN00.4, BN02.1, BN02.2, BN02.3, BN02.4 +22 more (list truncated in source)

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
GLMASTERLETTERCODEPRSYSTEMBENEFITBNACCOUNTSBNCOVDFTCONTRDETLBNCOVERAGEDEDFREQTBLBNCOMMENTSFLEXPLANBNINVESTLETTERTEXTLETTERCODEOCCURTYPEPARTICIPNTPLAN+8 more belowBNCOMPANY

One to one (4) — lookups and parents

RelationTableRulesConditionField map
Cash AccountGLMASTERRequired
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 LetterLETTERCODERequiredWhen 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 AcctGLMASTERRequiredWhen 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 CompanyPRSYSTEMRequired
BNC-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL

One to many (22) — child tables

RelationTableRulesConditionField map
BenefitBENEFITDelete Restricted
BNC-COMPANY→BEN-COMPANY
—→BEN-PLAN-TYPE
—→BEN-EMPLOYEE
—→BEN-START-DATE
—→BEN-PLAN-CODE
BnaccountsBNACCOUNTS
BNC-COMPANY→BNA-COMPANY
—→BNA-PLAN-TYPE
—→BNA-PLAN-CODE
—→BNA-START-DATE
—→BNA-GROUP-NAME
—→BNA-DED-CODE
BncovdftBNCOVDFT
BNC-COMPANY→BCD-COMPANY
—→BCD-PLAN-TYPE
—→BCD-PLAN-CODE
—→BCD-COVER-TYPE
—→BCD-START-DATE
—→BCD-GROUP-NAME
—→BCD-COVERAGE-OPT
Contrib DetailCONTRDETLDelete Cascades
BNC-COMPANY→CND-COMPANY
—→CND-PLAN-TYPE
—→CND-PLAN-CODE
—→CND-START-DATE
—→CND-GROUP-NAME
—→CND-BEGIN-YEAR-PCT
CoverageBNCOVERAGE
BNC-COMPANY→CVR-COMPANY
—→CVR-PLAN-TYPE
—→CVR-PLAN-CODE
—→CVR-COVER-TYPE
—→CVR-START-DATE
—→CVR-GROUP-NAME
Ded Freq TableDEDFREQTBLDelete Restricted
BNC-COMPANY→DFT-COMPANY
—→DFT-TABLE-CODE
Flex CommentsBNCOMMENTSDelete 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 PlansFLEXPLANDelete Restricted
BNC-COMPANY→FLP-COMPANY
—→FLP-FLEX-PLAN
Invest DistribBNINVESTDelete Restricted
BNC-COMPANY→BIV-COMPANY
—→BIV-PLAN-CODE
—→BIV-SEQ-NBR
Letter TextLETTERTEXTDelete Restricted
BNC-COMPANY→LTT-COMPANY
—→LTT-LETTER-CODE
—→LTT-EMPLOYEE
—→LTT-DEPENDENT
—→LTT-PARTICIPNT
—→LTT-DATE
—→LTT-SEQ-NBR
LettersLETTERCODEDelete Restricted
BNC-COMPANY→LTC-COMPANY
—→LTC-LETTER-CODE
—→LTC-EMPLOYEE
—→LTC-DEPENDENT
—→LTC-PARTICIPNT
—→LTC-DATE
Occur TypeOCCURTYPEDelete Restricted
BNC-COMPANY→OCC-COMPANY
—→OCC-OCCUR-TYPE
ParticipantPARTICIPNTDelete Restricted
BNC-COMPANY→PAR-COMPANY
—→PAR-PARTICIPNT
PlanPLANDelete Restricted
BNC-COMPANY→PLN-COMPANY
—→PLN-PLAN-TYPE
—→PLN-PLAN-CODE
PremiumsPREMIUMDelete Cascades
BNC-COMPANY→PRE-COMPANY
—→PRE-PLAN-TYPE
—→PRE-PLAN-CODE
—→PRE-COVER-TYPE
—→PRE-START-DATE
—→PRE-GROUP-NAME
Rate TablesRATETBLHDRDelete Cascades
BNC-COMPANY→RTH-COMPANY
—→RTH-TABLE-CODE
—→RTH-START-DATE
Rate Tbl DtlRATETBLDTL
BNC-COMPANY→RTD-COMPANY
—→RTD-TABLE-CODE
—→RTD-START-DATE
—→RTD-BEG-AGE-YR-SAL
—→RTD-SMOKER
Stock ExerBNEMPEXER
BNC-COMPANY→BXR-COMPANY
—→BXR-EMPLOYEE
—→BXR-OPT-GRANT-NBR
—→BXR-STOCK-CTF
—→BXR-EXERCISE-DATE
—→BXR-SEQ-NBR
Stock GrantBNEMPGRNT
BNC-COMPANY→BEG-COMPANY
—→BEG-EMPLOYEE
—→BEG-OPT-GRANT-NBR
—→BEG-STOCK-CTF
Stock Opt PlnBNSTKGNT
BNC-COMPANY→BSG-COMPANY
—→BSG-OPT-GRANT-NBR
Vest Sched DtlVESTSCHDDTDelete Restricted
BNC-COMPANY→VSD-COMPANY
—→VSD-VEST-SCHED
—→VSD-SERV-YEARS
Vesting SchedVESTSCHDHDDelete Restricted
BNC-COMPANY→VSH-COMPANY
—→VSH-VEST-SCHED

Programs

Updated by (11)

Referenced by (152)