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 | 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. |
|
||||||
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-CREATE-DATE Element: Date Stamp | Numeric 8 (yyyymmdd) |
|
||||||
BNC-CREATE-TIME Element: Time Stamp | Numeric 6 (hhmmss) |
|
||||||
BNC-CREATE-USER-ID Element: User Id | Alpha 10 (Lower Case) |
|
||||||
BNC-DATE-STAMP Element: Date Stamp | Numeric 8 (yyyymmdd) |
|
||||||
BNC-TIME-STAMP Element: Time Stamp | Numeric 6 (hhmmss) |
|
||||||
BNC-USER-ID Element: User Id | Alpha 10 (Lower Case) |
|
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.