BNCOMPANY

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
BN101 BN102 BN103 BN104 BN105 BN106
BN138 BN140 BN141 BN145 BN15.1 BN15.2
BN150 BN170 BN171 BN175 BN18.1 BN18.2
BN18.3 BN18.4 BN18.5 BN18.6 BN18.7 BN202
BN215 BN230 BN231 BN232 BN233 BN236
BN237 BN238 BN240 BN242 BN245 BN246
BN247 BN248 BN258 BN259 BN270 BN281
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 BN53.1
BN531 BN532 BN547 BN55.1 BN55.2 BN555
BN556 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 BS01.1 BS09.1
BS10.1 BS11.1 BS12.1 BS13.1 BS14.1 BS15.1
BS32.1 ZB10.1 ZB31.1 ZB31.2 ZB32.1 ZB32.2
ZB32.3 HR00.1 HR01.1 HR13.2 HR13.3 HR13.4
LP138 PR129 PR197 WAOP.1 BN02.1 BN02.2
BN02.3 BN02.4 BN02.5 BN03.1 BN04.1 BN05.1
BN06.1 BN08.1 BN13.1 BN16.1 BN16.2 BN16.3
BN16.4 BN19.1 BN19.2 BN19.3 BN19.4 BN190
BN200 BN203 BN204 BN206 BN252 BN285
BN52.1 BN90.1 BS02.1 BS03.1 BS03.2 BS03.3
HPLN.1 PA50.1


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
Element: Company Hr		Numeric 4
Contains the company number. The number correlates all information about the company.
BN00.1 BN00.2
BN00.3 BN00.4
BNC-CSH-DIST-CO
Element: Company		Numeric 4
Identifies 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
Element: Cash Account Unit		Alpha 15
Contains the accounting unit for posting payments from COBRA participants and retirees.
BN00.1
BNC-CSH-ACCOUNT
Element: Cash Account		Numeric 6
Contains the account for posting payments from COBRA participants and retirees.
BN00.1
BNC-CSH-SUB-ACCT
Element: Cash Sub-Account		Numeric 4
Contains the subaccount for posting payments from COBRA participants and retirees.
BN00.1
BNC-INS-COV-LIM
Insurance Coverage
Limit		Signed 11.2
Contains the maximum amount of life insurance coverage for which the cost is non-taxable.
BN00.4
BNC-RET-DUE-DAYS
Element: Retirees Due Days		Numeric 3
Contains 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
Element: Pct Cov Comp		Signed 5.3
This field is not used.
BNC-EXC-DIST-CO
Element: Company		Numeric 4
Identifies 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
Excess Premium
Account Unit		Alpha 15
Contains the accounting unit for posting the excess premium charged to COBRA participants.
BN00.2
BNC-EXC-ACCOUNT
Excess Premium
Account		Numeric 6
Contains the account for posting the excess premiums charged to COBRA participants.
BN00.2
BNC-EXC-SUB-ACCT
Excess Premium
Sub-Account		Numeric 4
Contains the subaccount for posting excess premiums charged to COBRA participants.
BN00.2
BNC-NOT-EVENT
Employee
Notification Days		Numeric 3
Contains the number of days that an employee or qualified beneficiary has to notify the employer of a qualifying event.
BN00.2
BNC-NOT-RIGHTS
Company
Notification Days		Numeric 3
Contains 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
Election
Notification Days		Numeric 3
Contains 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
Element: COBRA Due Days		Numeric 3
Contains 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
COBRA Premium
Percent		Signed 7.3
Contains the percent that the company charges the participant to maintain the COBRA account.
BN00.2
BNC-CBR-IN-GRACE
COBRA Initial Grace
Period		Numeric 3
Contains 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
Element: Cbr Re Grace		Numeric 3
Contains the number of days used as a grace period from the due date of the invoice for retirees.
BN00.1
BNC-CBR-DLQ-LTR
Element: Delinquent Letter		Alpha 2
Contains the code of the standard letter sent to participants or retirees who have delinquent payments.
BN00.2
BNC-CBR-MAX-MNTH
Multiple Events
Maximum		Numeric 2
Contains the maximum number of months coverage extends for multiple occurrences.
BN00.3
BNC-COST-PER-CVG
Element: Cost Per Coverage		Signed 9.2
Contains 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
Element: Grp Life Age		Numeric 2 Occurs 14 Times
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.
BN00.4
BNC-GRP-LIFE-CST
Element: Grp Life Cst		Signed 7.3 Occurs 14 Times
Contains the cost per dollar of life insurance coverage in excess of the limit.
BN00.4
BNC-AUTO-PART
Element: Auto Part		Alpha 1
Indicates whether the system should automatically number each COBRA participant.
N = No
Y = Yes
BN00.2
BNC-LAST-PART
Element: Last Part		Numeric 9
Contains the last COBRA participant number automatically assigned by the system.
BN00.2 BN100
BN70.1 PA100
PA52.1 PA52.5
BNC-RET-INV-PER
Element: Ret Inv Per		Numeric 4
Contains the month and year (MMYY) of the last invoice sent to retirees.
BN00.1 BN180
BN181
BNC-CBR-INV-PER
Element: Cbr Inv Per		Numeric 4
Contains the month and year (MMYY) of the last invoice sent to COBRA participants.
BN00.2 BN180
BN181
BNC-CUR-LIFE-PER
Element: Cur Life Per		Numeric 4
Contains the month and year (MMYY) of the last period for which BN150 (Life Insurance Reportable Income) was run.
BNC-CUR-DL-PER
Element: Cur Dl Per		Numeric 4
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
Element: Dl Cov Lim		Signed 11.2
Contains the coverage limit that is non-taxable for dependent life insurance coverage.
BN00.4
BNC-DEP-HEALTH
Element: Dep Health		Alpha 1
Indicates whether the Benefits system should track dependent coverage in health plans.
Y = Yes
N = No
BN00.1
BNC-DEP-DENTAL
Element: Dep Dental		Alpha 1
Indicates whether the Benefits system should track dependent coverage in dental plans.
Y = Yes
N = No
BN00.1
BNC-DEP-EMP-LIFE
Element: Dep Emp Life		Alpha 1
Indicates whether the Benefits system should track dependent coverage in employee life/AD&D plans.
Y = Yes
N = No
BNC-DEP-DEP-LIFE
Element: Dep Dep Life		Alpha 1
Indicates whether the Benefits system should track dependent coverage in dependent life/AD&D plans.
Y = Yes
N = No
BN00.1
BNC-SPONSOR-ID
Element: Sponsor Id		Alpha 30
BN00.1
BNC-DEP-VISION
Element: Dep Vision		Alpha 1

N = No
Y = Yes


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
NAME		 RELATED 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
AndBNC-EXC-ACCOUNT !=Zeroes
AndBNC-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
NAME		 RELATED 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

File created: Thu Jun 09 11:09:55 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.