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
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 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 BN260 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 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 BN90.1 BS01.1 BS02.1 BS03.1 BS03.2
BS03.3 BS03.4 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 HPLN.1 HR00.1
HR01.1 HR13.2 HR13.3 HR13.4 LP138 PA50.1
PR129 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
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
BNC-CREATE-DATE
Element: Date Stamp
Numeric 8 (yyyymmdd)
BN00.1 BN00.2
BN00.3 BN00.4
BNC-CREATE-TIME
Element: Time Stamp
Numeric 6 (hhmmss)
BN00.1 BN00.2
BN00.3 BN00.4
BNC-CREATE-USER-ID
Element: User Id
Alpha 10 (Lower Case)
BN00.1 BN00.2
BN00.3 BN00.4
BNC-DATE-STAMP
Element: Date Stamp
Numeric 8 (yyyymmdd)
BN00.1 BN00.2
BN00.3 BN00.4
BNC-TIME-STAMP
Element: Time Stamp
Numeric 6 (hhmmss)
BN00.1 BN00.2
BN00.3 BN00.4
BNC-USER-ID
Element: User Id
Alpha 10 (Lower Case)
BN00.1 BN00.2
BN00.3 BN00.4


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


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 02:09:56 2016

Home
Contact Us



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