BNPAYMENT FILE
Benefit Payment
The Benefit Payment file contains payment information for COBRA participant
and retiree premiums. Each record is for one COBRA participant or retiree
transaction.
BN81.1 (Cash Entry) is the primary program that updates this file.
REFERENCED BY
BN82.1 BN281
UPDATED BY
BN190 BN480 BN81.1 BN81.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BNP-COMPANY Numeric 4 BN81.1
Company Contains the company number. The number
correlates all information about the
company.
BNP-EMPLOYEE Numeric 9 BN81.1
Employee Contains the employee's number.
BNP-PARTICIPNT Numeric 9 BN81.1
Participant Number Contains COBRA participant numbers. The
number correlates all information about
the COBRA participant.
BNP-TYPE Alpha 2 BN81.1
Type Indicates whether the transaction is a
payment or a credit memo.
CK = Payment
CM = Credit Memo
BNP-CHECK-NBR Numeric 8 BN81.1
Payment Number Contains the number of the payment.
BNP-PMT-AMT Signed 11.2 BN81.1
Payment Amount Contains the payment amount.
BNP-APPLIED-AMT Signed 15.2 BN81.1 BN81.2
Applied Amount Contains the amount applied to the
outstanding balance.
BNP-DATE Numeric 8 (yyyymmdd) BN81.1
Date Contains the transaction date.
BNP-REFERENCE Alpha 10 (Lower Case) BN81.1
Reference Contains a user-defined reference or
comment.
BNP-DIST-CO Numeric 4 BN81.1
Dist Co
BNP-ACCT-UNIT Alpha 15 BN81.1
Accounting Unit Contains the accounting unit for the
payment.
BNP-ACCOUNT Numeric 6 BN81.1
Account Contains the account for the payment.
BNP-SUB-ACCT Numeric 4 BN81.1
Subaccount Contains the subaccount for the payment.
BNP-OS-INV-NUMBER Numeric 3 BN81.2
Over/Short Invoice Contains the invoice number for the
Number over or short amount of the payment.
BNP-OS-PLAN-TYPE Alpha 2 BN81.2
Over/Short Plan Type Contains the benefit type.
HL = Health
DN = Dental
EL = Employee Life
DL = Dependent Life
BNP-OS-PLAN-CODE Alpha 4 BN81.2
Over/Short Plan Code Contains the benefit plan's code.
BNP-OS-START-DATE Numeric 8 (yyyymmdd) BN81.2
Over/Short Start Contains the start date of the benefit
Date plan.
BNP-OS-AMOUNT Signed 7.2 BN81.2
Over/Short Contains the over or short amount.
Transaction Amount
BNP-OS-DIST-CO Numeric 4 BN81.2
Os Dist Co
BNP-OS-ACCT-UNIT Alpha 15 BN81.2
Offsetting Contains the account used for posting
Accounting Unit the over or short amount.
BNP-OS-ACCOUNT Numeric 6 BN81.2
Offsetting Account Contains the account for posting the
over or short amount.
BNP-OS-SUB-ACCT Numeric 4 BN81.2
Offsetting Contains the subaccount for posting the
Subaccount over or short amount.
BNP-AR-DIST-CO Numeric 4 BN81.2
Ar Dist Co
BNP-AR-ACCT-UNIT Alpha 15 BN81.2
Accts Receivable Contains the accounting unit for the
Account Unit over short account.
BNP-AR-ACCOUNT Numeric 6 BN81.2
Accounts Receivable Contains the account for the over short
Account payment.
BNP-AR-SUB-ACCT Numeric 4 BN81.2
Accts Receivable Contains the subaccount for the over
Subaccount short account.
BNP-STATUS Numeric 1 BN190 BN81.1
Status Contains the status of a given BN81.2
transaction.
1 = Posted to G/L
0 = Not Posted to G/L
BNPAYMENT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BNPSET1 COMPANY BN480 BN82.1
EMPLOYEE
PARTICIPNT
TYPE
CHECK-NBR
BNPSET2 COMPANY Subset BN190 BN281
EMPLOYEE Where STATUS != 9 BN81.1 BN81.2
PARTICIPNT
TYPE
CHECK-NBR
BNPAYMENT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Ar Account GLMASTER Required
When BNP-AR-ACCT-UNIT != Spaces
Or BNP-AR-ACCOUNT != Zeroes
BNP-COMPANY -> GLM-COMPANY
BNP-AR-ACCT-UNIT -> GLM-ACCT-UNIT
BNP-AR-ACCOUNT -> GLM-ACCOUNT
BNP-AR-SUB-ACCT -> GLM-SUB-ACCOUNT
Company BNCOMPANY Required
BNP-COMPANY -> BNC-COMPANY
Company Name PRSYSTEM Required
BNP-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Employee EMPLOYEE Required
When BNP-EMPLOYEE != Zeroes
BNP-COMPANY -> EMP-COMPANY
BNP-EMPLOYEE -> EMP-EMPLOYEE
Gl Account GLMASTER Required
When BNP-ACCT-UNIT != Spaces
And BNP-ACCOUNT != Zeroes
And BNP-SUB-ACCT != Zeroes
BNP-COMPANY -> GLM-COMPANY
BNP-ACCT-UNIT -> GLM-ACCT-UNIT
BNP-ACCOUNT -> GLM-ACCOUNT
BNP-SUB-ACCT -> GLM-SUB-ACCOUNT
Os Account GLMASTER Required
When BNP-OS-ACCT-UNIT != Spaces
Or BNP-OS-ACCOUNT != Zeroes
BNP-COMPANY -> GLM-COMPANY
BNP-OS-ACCT-UNIT -> GLM-ACCT-UNIT
BNP-OS-ACCOUNT -> GLM-ACCOUNT
BNP-OS-SUB-ACCT -> GLM-SUB-ACCOUNT
Os Invoice BNINVDETL Required
When BNP-OS-INV-NUMBER != Zeroes
BNP-COMPANY -> BID-COMPANY
BNP-OS-PLAN-TYPE -> BID-PLAN-TYPE
BNP-OS-PLAN-CODE -> BID-PLAN-CODE
BNP-OS-START-DATE -> BID-START-DATE
BNP-EMPLOYEE -> BID-EMPLOYEE
BNP-PARTICIPNT -> BID-PARTICIPNT
BNP-OS-INV-NUMBER -> BID-INV-NUMBER
Os Plan PLAN Required
When BNP-OS-PLAN-CODE != Spaces
BNP-COMPANY -> PLN-COMPANY
BNP-OS-PLAN-TYPE -> PLN-PLAN-TYPE
BNP-OS-PLAN-CODE -> PLN-PLAN-CODE
Participant PARTICIPNT Required
When BNP-PARTICIPNT != Zeroes
BNP-COMPANY -> PAR-COMPANY
BNP-PARTICIPNT -> PAR-PARTICIPNT
BNPAYMENT FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Payment Detail BNPAYDETL Delete Restricted
BNP-COMPANY -> BPD-COMPANY
BNP-EMPLOYEE -> BPD-EMPLOYEE
BNP-PARTICIPNT -> BPD-PARTICIPNT
BNP-TYPE -> BPD-TYPE
BNP-CHECK-NBR -> BPD-CHECK-NBR
BPD-INV-NUMBER
BPD-PLAN-TYPE
BPD-PLAN-CODE
BPD-START-DATE
|