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 BN138 BN140
BN141 BN145 BN149 BN15.1 BN15.2 BN15.3
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 BN19.5 BN190 BN200 BN202 BN203
BN204 BN206 BN215 BN230 BN231 BN232
BN233 BN236 BN237 BN238 BN240 BN242
BN245 BN246 BN247 BN248 BN252 BN255
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 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 BN954
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 XB500 XB510 XB515 XB520 XB706
HPLN.1 HR00.1 HR01.1 HR13.2 HR13.3 HR13.4
LP138 PA50.1 PR129 PR195 PR197 PR582
PR82.1 PR85.1


UPDATED BY
BN00.1 BN00.2 BN00.3 BN00.4 BN00.5 BN100
BN180 BN181 BN70.1 PA100 PA52.1 PA52.5
BN13.1

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
BN00.5
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-ACA-PAY-CLASS
Element: Pay Class
Alpha 3
ACA Pay Class is used during the Payroll Close (PR197) for capturing ACA Hours.
BN00.5
BNC-ACA-WKLY-HOURS
Element: Hours
Signed 7.2
ACA Weekly Hours is used for the ACA average hours calculation which is the basis of determining the ACA Benefit eligibility for the employee.
BN00.5
BNC-ACA-MTH-HOURS
Element: Hours
Signed 7.2
ACA Monthly Hours are used for the ACA average hours calculation which is the basis of determining the Benefit eligibility for the employee.
BN00.5
BNC-ACA-NHMP-DUR
Element: Aca Duration
Numeric 3
ACA New Hire Measurement Period Duration is the period of time chosen by the employer that will be used for determining if new Variable Hour Employees or Seasonal Employees are considered full-time employees.
BN00.5
BNC-ACA-NHMP-FREQ
Element: Aca Frequency
Alpha 1
ACA New Hire Measurement Period Frequency allows user to define number of (W)eeks or (M)onths. This field is used with ACA-NHMP-DUR.
W = Weeks
M = Months
BN00.5
BNC-ACA-NHAP-DUR
Element: Aca Duration
Numeric 3
ACA New Hire Administrative Period Duration is the period between the end of the Initial Measurement Period and the associated Initial Stability Period. The Initial Administrative Period may last up to 90 days and is envisioned to be the time during which employers determine which of its employees have satisified the requisite 30 hours per week average in order to be eligible for coverage.
BN00.5
BNC-ACA-NHAP-FREQ
Element: Aca Frequency
Alpha 1
ACA New Hire Administrative Period Frequency allows user to define number of (W)eeks, (M)onths, or (D)ays. This field is used with ACA-NHAP-DUR.
D = Days
W = Weeks
M = Months
BN00.5
BNC-ACA-NHSP-DUR
Element: Aca Duration
Numeric 3
ACA New Hire Stability Period Duration is the period of time between six and twelve months during which an employee's status as a full-time employee (or not) is fixed based on the results from the average hours worked during the Initial Measurement Period. An Initial Stability Period must be at least as long as the Initial Measuremnt Period but no shorter than six months.
BN00.5
BNC-ACA-NHSP-FREQ
Element: Aca Frequency
Alpha 1
ACA New Hire Stability Period Frequency allows user to define number of (W)eeks, (M)onths, or (D)ays. This field is used with ACA-NHSP-DUR.
D = Days
W = Weeks
M = Months
BN00.5
BNC-ACA-HIRE-DATE
Element: From Date
Alpha 2
Select the hire date that should be used as the starting point for the Initial Measurement Period assessment. Valid values are Hire Date (HI), Adjusted Hire Date (AJ), New Hire Date (NH), Anniversary Date (AN), Seniority Date (SN), Benefit Date 1 (B1), Benefit Date 2 (B2), Benefit Date 3 (B3), Benefit Date 4 (B4), Benefit Date 5 (B5).
HI = Hire Date
AJ = Adjusted Hire Date
NH = New Hire Date
AN = Anniversary Date
SN = Seniority Date
B1 = Benefit Date 1
B2 = Benefit Date 2
B3 = Benefit Date 3
B4 = Benefit Date 4
B5 = Benefit Date 5
BN00.5
BNC-ACA-FIRST-MNTH
Element: Alphadata1
Alpha 1
ACA First of Next Month option allows the Initial Measurement Assessment to start the first day of the following month of hire.
N = No
Y = Yes
BN00.5


BNCOMPANY FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BNCSET1 COMPANY
...
BN00.1 BN00.2
BN00.3 BN00.4
BN00.5 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 BN149
BN15.1 BN15.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: Wed Jun 08 20:48:05 2016

Home
Contact Us



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