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 BN700 BN81.1 BN81.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BNP-COMPANY Numeric 4 BN81.1
Element: Company Contains the company number. The number
correlates all information about the
company.
BNP-EMPLOYEE Numeric 9 BN81.1
Element: Employee Contains the employee's number.
BNP-PARTICIPNT Numeric 9 BN81.1
Element: Participant NuContains COBRA participant numbers. The
number correlates all information about
the COBRA participant.
BNP-TYPE Alpha 2 BN81.1
Element: Type Indicates whether the transaction is a
payment or a credit memo.
CK = Payment
CM = Credit Memo
BNP-CHECK-NBR Numeric 8 BN81.1
Element: Payment NumberContains the number of the payment.
BNP-PMT-AMT Signed 11.2 BN81.1
Element: Payment AmountContains the payment amount.
BNP-APPLIED-AMT Signed 15.2 BN81.1 BN81.2
Element: Adj Amt Contains the amount applied to the
outstanding balance.
BNP-DATE Numeric 8 (yyyymmdd) BN81.1
Element: Date Contains the transaction date.
BNP-REFERENCE Alpha 10 (Lower Case) BN81.1
Element: Requester Contains a user-defined reference or
comment.
BNP-DIST-CO Numeric 4 BN81.1
Element: Dist Co
BNP-ACCT-UNIT Alpha 15 BN81.1
Element: Accounting UniContains the accounting unit for the
payment.
BNP-ACCOUNT Numeric 6 BN81.1
Element: Account Contains the account for the payment.
BNP-SUB-ACCT Numeric 4 BN81.1
Element: 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
Element: Over/Short PlaContains the benefit type.
HL = Health
DN = Dental
EL = Employee Life
DL = Dependent Life
RS = Spending Account
BNP-OS-PLAN-CODE Alpha 4 BN81.2
Element: Over/Short PlaContains 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
Element: 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
Element: Offsetting AccContains 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
Element: 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
Element: Status Contains the status of a given BN81.2
transaction.
1 = Posted to G/L
0 = Not Posted to G/L
BNP-CURRENCY-CODE Alpha 5 BN700 BN81.1
Element: Currency Code This field contains the company base BN81.2
currency code established in Company
(GL10.1 ).
BNP-CURR-ND Numeric 1 BN700 BN81.1
Account Currency BN81.2
Code
BNPAYMENT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BNPSET1 COMPANY BN480 BN700
EMPLOYEE BN82.1
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
Currency CUCODES Required
BNP-CURRENCY-CODE -> CUC-CURRENCY-CODE
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
|
