|
|
BNINVDETL FILE
Benefit Invoice Detail
The Benefit Invoice Detail file contains the invoice detail for retiree and
participant billing. Each record contains one invoice for a retiree or COBRA
participant. If the invoice is for a retiree, the retiree number displays in
the BID-EMPLOYEE field. If the invoice is for a COBRA participant, the
participant number displays.
REFERENCED BY
BN105 BN71.1 BN72.1 BN430 BN171 BN175
BN82.1
UPDATED BY
BN180 BN181 BN190 BN480 BN80.1 BN81.1
BN81.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BID-COMPANY Numeric 4 BN180 BN80.1
Company Contains the company number.
BID-PLAN-TYPE Alpha 2 BN180 BN80.1
Type Contains the plan type of the invoice.
DL = Dependent Life
DN = Dental
EL = Employee Life
HL = Health
RS = Spending Account
BID-PLAN-CODE Alpha 4 BN180 BN80.1
Plan Contains the plan code.
BID-START-DATE Numeric 8 (yyyymmdd) BN180 BN80.1
Start Date Contains the start date of the benefit.
BID-EMPLOYEE Numeric 9 BN180 BN80.1
Employee Contains the retiree's number.
BID-PARTICIPNT Numeric 9 BN180 BN80.1
Participant Number Contains COBRA participant numbers.
BID-INV-NUMBER Numeric 3 BN180 BN80.1
Invoice Number Contains the invoice number.
BID-INV-TYPE Alpha 1 BN180 BN80.1
Invoice Type Contains the invoice as a manual
invoice or a system created invoice.
BID-INV-DATE Numeric 8 (yyyymmdd) BN180 BN80.1
Invoice Date Contains the invoice date.
BID-DUE-DATE Numeric 8 (yyyymmdd) BN180 BN80.1
Due Date Contains the invoice due date.
BID-INV-AMOUNT Signed 11.2 BN180 BN80.1
Invoice Amount Contains the amount of the invoice.
For retiree invoices, the invoice
amount is less than or equal to the
premium amount. The difference is the
company expense.
For COBRA invoices, the invoice amount
is greater than or equal to the premium
amount. The difference is the excess
premium amount.
BID-PREMIUM-AMT Signed 7.2 BN180 BN80.1
Premium Amount Contains the premium amount.
BID-DESC Alpha 30 (Lower Case) BN80.1
Description Contains a description of the invoice.
BID-GL-AMOUNT Signed 7.2 Occurs 3 Times BN180 BN80.1
General Ledger Contains the amount to be posted to the
Amount general ledger.
BID-GL-ACCT-UNIT Alpha 15 Occurs 3 Times BN180 BN80.1
General Ledger Contains the accounting unit for
Accounting Unit posting invoice amounts.
BID-GL-ACCOUNT Numeric 6 Occurs 3 Times BN180 BN80.1
General Ledger Contains the account for posting
Account invoice amounts.
BID-GL-SUB-ACCT Numeric 4 Occurs 3 Times BN180 BN80.1
General Ledger Contains the subaccount for posting
Subaccount invoice amounts.
BID-UNPAID-AMT Signed 7.2 BN180 BN80.1
Invoice Unpaid Contains any unpaid invoice amounts. BN81.1 BN81.2
Amount
BID-GL-DIST-CO Numeric 4 Occurs 3 Times BN180 BN80.1
Gl Dist Co
BID-STATUS Numeric 1 BN180 BN181
Status This field contains the status of the BN190
transaction.
BNINVDETL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BIDSET1 COMPANY BN105 BN190
PLAN-TYPE BN480 BN71.1
PLAN-CODE BN72.1 BN81.1
START-DATE BN81.2
EMPLOYEE
PARTICIPNT
INV-NUMBER
BIDSET2 COMPANY Subset BN180 BN430
INV-TYPE Where STATUS = Zeroes BN80.1
EMPLOYEE
PARTICIPNT
INV-NUMBER
PLAN-TYPE
PLAN-CODE
START-DATE
BIDSET3 COMPANY KeyChange BN171 BN175
EMPLOYEE BN81.1 BN81.2
PARTICIPNT BN82.1
INV-DATE
INV-NUMBER
PLAN-TYPE
PLAN-CODE
START-DATE
BIDSET4 COMPANY BN181
EMPLOYEE
PARTICIPNT
INV-NUMBER
PLAN-TYPE
PLAN-CODE
START-DATE
BNINVDETL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Account GLMASTER Required
When BID-GL-ACCOUNT != Zeroes
Or BID-GL-ACCT-UNIT != Spaces
BID-COMPANY -> GLM-COMPANY
BID-GL-ACCT-UNIT -> GLM-ACCT-UNIT
BID-GL-ACCOUNT -> GLM-ACCOUNT
BID-GL-SUB-ACCT -> GLM-SUB-ACCOUNT
Company BNCOMPANY Required
BID-COMPANY -> BNC-COMPANY
Company Name PRSYSTEM Required
BID-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Employee EMPLOYEE Required
When BID-EMPLOYEE != Zeroes
BID-COMPANY -> EMP-COMPANY
BID-EMPLOYEE -> EMP-EMPLOYEE
Participant PARTICIPNT Required
When BID-PARTICIPNT != Zeroes
BID-COMPANY -> PAR-COMPANY
BID-PARTICIPNT -> PAR-PARTICIPNT
Plan PLAN Required
When BID-PLAN-CODE != Spaces
BID-COMPANY -> PLN-COMPANY
BID-PLAN-TYPE -> PLN-PLAN-TYPE
BID-PLAN-CODE -> PLN-PLAN-CODE
BNINVDETL FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Payment Detail BNPAYDETL Delete Restricted
BID-COMPANY -> BPD-COMPANY
BID-EMPLOYEE -> BPD-EMPLOYEE
BID-PARTICIPNT -> BPD-PARTICIPNT
BPD-TYPE
BPD-CHECK-NBR
BPD-INV-NUMBER
BPD-PLAN-TYPE
BPD-PLAN-CODE
BPD-START-DATE
Payments BNPAYMENT Delete Restricted
BID-COMPANY -> BNP-COMPANY
BID-EMPLOYEE -> BNP-EMPLOYEE
BID-PARTICIPNT -> BNP-PARTICIPNT
BNP-TYPE
BNP-CHECK-NBR
|