BNCOMPANY FILE
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 BN138
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 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 BN500
BN51.1 BN51.2 BN52.1 BN53.1 BN531 BN532
BN547 BN55.1 BN555 BN56.1 BN57.1 BN59.1
BN60.1 BN61.1 BN65.1 BN66.1 BN702 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 BS09.1 BS10.1 BS11.1 BS12.1 BS13.1
BS14.1 BS15.1 BS32.1 HPLN.1 HR00.1 HR01.1
HR13.2 HR13.3 HR13.4 PBIP.1 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 Numeric 4 BN00.1 BN00.2
Element: Company Contains the company number. The number BN00.3 BN00.4
correlates all information about the
company.
BNC-CSH-DIST-CO Numeric 4 BN00.1
Element: Csh Dist Co
BNC-CSH-ACCT-UNT Alpha 15 BN00.1
Element: Cash Account UContains the accounting unit for
posting payments from COBRA participants
and retirees.
BNC-CSH-ACCOUNT Numeric 6 BN00.1
Element: Cash Account Contains the account for posting
payments from COBRA participants and
retirees.
BNC-CSH-SUB-ACCT Numeric 4 BN00.1
Element: Cash Sub-AccouContains the subaccount for posting
payments from COBRA participants and
retirees.
BNC-INS-COV-LIM Signed 11.2 BN00.4
Insurance Coverage Contains the maximum amount of life
Limit insurance coverage for which the cost is
non-taxable.
BNC-RET-DUE-DAYS Numeric 3 BN00.1
Element: Retirees Due DContains 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 Signed 5.3
Element: Pct Cov Comp This field is not used.
BNC-EXC-DIST-CO Numeric 4 BN00.2
Element: Exc Dist Co
BNC-EXC-ACCT-UNT Alpha 15 BN00.2
Excess Premium Contains the accounting unit for
Account Unit posting the excess premium charged to
COBRA participants.
BNC-EXC-ACCOUNT Numeric 6 BN00.2
Excess Premium Contains the account for posting the
Account excess premiums charged to COBRA
participants.
BNC-EXC-SUB-ACCT Numeric 4 BN00.2
Excess Premium Contains the subaccount for posting
Sub-Account excess premiums charged to COBRA
participants.
BNC-NOT-EVENT Numeric 3 BN00.2
Employee Contains the number of days that an
Notification Days employee or qualified beneficiary has to
notify the employer of a qualifying
event.
BNC-NOT-RIGHTS Numeric 3 BN00.2
Company Contains the number of days after a
Notification Days qualifying event that the company has to
notify employees and qualified
beneficiaries of their right to extend
coverage.
BNC-NOT-ELECT Numeric 3 BN00.2
Election Contains the number of days that
Notification Days employees and qualified beneficiaries
have to notify the company of their
election of coverage.
BNC-CBR-DUE-DAYS Numeric 3 BN00.2
Element: COBRA Due DaysContains the number of days from an
invoice's due date that COBRA
participants and retirees must pay their
premium.
BNC-CBR-PREM-PCT Signed 7.3 BN00.2
COBRA Premium Contains the percent that the company
Percent charges the participant to maintain the
COBRA account.
BNC-CBR-IN-GRACE Numeric 3 BN00.2
COBRA Initial Grace Contains the number of days from the
Period due date of the first invoice that COBRA
participants and retirees must pay their
first premium.
BNC-CBR-RE-GRACE Numeric 3 BN00.1
Remaining Payment Contains the number of days used as a
Grace Per grace period from the due date of the
invoice for retirees.
BNC-CBR-DLQ-LTR Alpha 2 BN00.2
Element: Delinquent LetContains the code of the standard
letter sent to participants or retirees
who have delinquent payments.
BNC-CBR-MAX-MNTH Numeric 2 BN00.3
Multiple Events Contains the maximum number of months
Maximum coverage extends for multiple
occurrences.
BNC-COST-PER-CVG Signed 9.2 BN00.4
Element: Cost Per CoverContains the increment of coverage on
which premiums are based. This increment
is used in the calculation of excess
life insurance.
BNC-GRP-LIFE-AGE Numeric 2 Occurs 14 Times BN00.4
Element: Group Life AgeContains 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 Signed 7.3 Occurs 14 Times BN00.4
Element: Group Life CosContains the cost per dollar of life
insurance coverage in excess of the
limit.
BNC-AUTO-PART Alpha 1 BN00.2
Auto Participant Indicates whether the system should
Numbering automatically number each COBRA
participant.
N = No
Y = Yes
BNC-LAST-PART Numeric 9 BN00.2 BN100
Element: Last ParticipaContains the last COBRA participant BN70.1 PA100
number automatically assigned by the PA52.1 PA52.5
system.
BNC-RET-INV-PER Numeric 4 BN00.1 BN180
Retiree Invoice Contains the month and year (MMYY) of BN181
Period the last invoice sent to retirees.
BNC-CBR-INV-PER Numeric 4 BN00.2 BN180
Cobra/Retiree Contains the month and year (MMYY) of BN181
Invoice Period the last invoice sent to COBRA
participants.
BNC-CUR-LIFE-PER Numeric 4
Current Life Contains the month and year (MMYY) of
Insurance Period the last period for which BN150 (Life
Insurance Reportable Income) was run.
BNC-CUR-DL-PER Numeric 4
Element: Cur Dl Per 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 Signed 11.2 BN00.4
Element: Dl Cov Lim Contains the coverage limit that is
non-taxable for dependent life insurance
coverage.
BNC-DEP-HEALTH Alpha 1 BN00.1
Element: Health Indicates whether the Benefits system
should track dependent coverage in
health plans.
Y = Yes
N = No
BNC-DEP-DENTAL Alpha 1 BN00.1
Element: Dental Indicates whether the Benefits system
should track dependent coverage in
dental plans.
Y = Yes
N = No
BNC-DEP-EMP-LIFE Alpha 1
Element: Employee Life Indicates whether the Benefits system
should track dependent coverage in
employee life/AD&D plans.
Y = Yes
N = No
BNC-DEP-DEP-LIFE Alpha 1 BN00.1
Element: Dependent LifeIndicates whether the Benefits system
should track dependent coverage in
dependent life/AD&D plans.
Y = Yes
N = No
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 RELATED
NAME 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
And BNC-EXC-ACCOUNT != Zeroes
And BNC-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 RELATED
NAME 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
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
|
