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
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. |
|
||||||
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. |
|
||||||
BNC-CSH-ACCT-UNT Element: Cash Account Unit | Alpha 15 Contains the accounting unit for posting payments from COBRA participants and retirees. |
|
||||||
BNC-CSH-ACCOUNT Element: Cash Account | Numeric 6 Contains the account for posting payments from COBRA participants and retirees. |
|
||||||
BNC-CSH-SUB-ACCT Element: Cash Sub-Account | Numeric 4 Contains the subaccount for posting payments from COBRA participants and retirees. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
BNC-EXC-ACCT-UNT Excess Premium Account Unit | Alpha 15 Contains the accounting unit for posting the excess premium charged to COBRA participants. |
|
||||||
BNC-EXC-ACCOUNT Excess Premium Account | Numeric 6 Contains the account for posting the excess premiums charged to COBRA participants. |
|
||||||
BNC-EXC-SUB-ACCT Excess Premium Sub-Account | Numeric 4 Contains the subaccount for posting excess premiums charged to COBRA participants. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
BNC-CBR-PREM-PCT COBRA Premium Percent | Signed 7.3 Contains the percent that the company charges the participant to maintain the COBRA account. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
BNC-CBR-MAX-MNTH Multiple Events Maximum | Numeric 2 Contains the maximum number of months coverage extends for multiple occurrences. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
BNC-AUTO-PART Element: Auto Part | Alpha 1 Indicates whether the system should automatically number each COBRA participant. N = No Y = Yes |
|
||||||
BNC-LAST-PART Element: Last Part | Numeric 9 Contains the last COBRA participant number automatically assigned by the system. |
|
||||||
BNC-RET-INV-PER Element: Ret Inv Per | Numeric 4 Contains the month and year (MMYY) of the last invoice sent to retirees. |
|
||||||
BNC-CBR-INV-PER Element: Cbr Inv Per | Numeric 4 Contains the month and year (MMYY) of the last invoice sent to COBRA participants. |
|
||||||
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. |
|
||||||
BNC-DEP-HEALTH Element: Dep Health | Alpha 1 Indicates whether the Benefits system should track dependent coverage in health plans. Y = Yes N = No |
|
||||||
BNC-DEP-DENTAL Element: Dep Dental | Alpha 1 Indicates whether the Benefits system should track dependent coverage in dental plans. Y = Yes N = No |
|
||||||
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 |
|
||||||
BNC-SPONSOR-ID Element: Sponsor Id | Alpha 30 |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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. |
|
||||||
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 |
|
||||||
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. |
|
||||||
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 |
|
||||||
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. |
|
||||||
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 |
|
||||||
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 |
|
||||||
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 |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||
---|---|---|---|---|---|---|---|---|---|
BNCSET1 |
COMPANY |
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Cash Account | GLMASTER |
Required
| ||||||||||||||||||||||||||||||
Delinq Letter | LETTERCODE |
Required
| ||||||||||||||||||||||||||||||
Exc Prem Acct | GLMASTER |
Required
| ||||||||||||||||||||||||||||||
Pr Company | PRSYSTEM |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Benefit | BENEFIT |
Delete Restricted
| |||||||||||||||||||||||||||
Bnaccounts | BNACCOUNTS |
| |||||||||||||||||||||||||||
Bncovdft | BNCOVDFT |
| |||||||||||||||||||||||||||
Contrib Detail | CONTRDETL |
Delete Cascades
| |||||||||||||||||||||||||||
Coverage | BNCOVERAGE |
| |||||||||||||||||||||||||||
Ded Freq Table | DEDFREQTBL |
Delete Restricted
| |||||||||||||||||||||||||||
Flex Comments | BNCOMMENTS |
Delete Restricted
| |||||||||||||||||||||||||||
Flex Plans | FLEXPLAN |
Delete Restricted
| |||||||||||||||||||||||||||
Invest Distrib | BNINVEST |
Delete Restricted
| |||||||||||||||||||||||||||
Letter Text | LETTERTEXT |
Delete Restricted
| |||||||||||||||||||||||||||
Letters | LETTERCODE |
Delete Restricted
| |||||||||||||||||||||||||||
Occur Type | OCCURTYPE |
Delete Restricted
| |||||||||||||||||||||||||||
Participant | PARTICIPNT |
Delete Restricted
| |||||||||||||||||||||||||||
Plan | PLAN |
Delete Restricted
| |||||||||||||||||||||||||||
Premiums | PREMIUM |
Delete Cascades
| |||||||||||||||||||||||||||
Rate Tables | RATETBLHDR |
Delete Cascades
| |||||||||||||||||||||||||||
Rate Tbl Dtl | RATETBLDTL |
| |||||||||||||||||||||||||||
Stock Exer | BNEMPEXER |
| |||||||||||||||||||||||||||
Stock Grant | BNEMPGRNT |
| |||||||||||||||||||||||||||
Stock Opt Pln | BNSTKGNT |
| |||||||||||||||||||||||||||
Vest Sched Dtl | VESTSCHDDT |
Delete Restricted
| |||||||||||||||||||||||||||
Vesting Sched | VESTSCHDHD |
Delete Restricted
|
All trademarks and registered trademarks are the property of their
respective owners.