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.

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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

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

Relations

One to one (4) — lookups and parents

RelationTableRulesConditionField map
Cash AccountGLMASTERRequiredBNC-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 != SpacesBNC-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 != ZeroesBNC-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 CompanyPRSYSTEMRequiredBNC-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL

One to many (22) — child tables

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

Programs

Updated by (11)

Referenced by (152)