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
Element: Company Hr 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: Applied AmountContains 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: Reference Contains a user-defined reference or
comment.
BNP-DIST-CO Numeric 4 BN81.1
Element: Company
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: Company
BNP-OS-ACCT-UNIT Alpha 15 BN81.2
Element: Accounting UniContains the account used for posting
the over or short amount.
BNP-OS-ACCOUNT Numeric 6 BN81.2
Element: Account Contains the account for posting the
over or short amount.
BNP-OS-SUB-ACCT Numeric 4 BN81.2
Element: Subaccount Contains the subaccount for posting the
over or short amount.
BNP-AR-DIST-CO Numeric 4 BN81.2
Element: Company
BNP-AR-ACCT-UNIT Alpha 15 BN81.2
Element: Accounting UniContains the accounting unit for the
over short account.
BNP-AR-ACCOUNT Numeric 6 BN81.2
Element: Account Contains the account for the over short
payment.
BNP-AR-SUB-ACCT Numeric 4 BN81.2
Element: Subaccount Contains the subaccount for the over
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 BN81.1 BN81.2
Element: Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
BNP-CURR-ND Numeric 1 BN81.1 BN81.2
Account Currency Represents the number of decimals
Code defined for the currency of the object.
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
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
|
