BNPAYDETL FILE
Benefit Payment Detail
The Benefit Payment Detail file contains payment information for COBRA
participants and retirees. Each payment is stored by invoice number and
general ledger posting account. BN81.1 (Cash Entry) is the primary program
that loads this file.
REFERENCED BY
BN190 BN281 BN82.1
UPDATED BY
BN480 BN81.1 BN81.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BPD-COMPANY Numeric 4 BN81.1 BN81.2
Company Contains the company number. The number
correlates all information about the
company.
BPD-EMPLOYEE Numeric 9 BN81.1 BN81.2
Employee Contains the employee's number. The
number correlates all information about
the employee.
BPD-PARTICIPNT Numeric 9 BN81.1 BN81.2
Participant Number Contains COBRA participant numbers. The
number correlates all information about
the COBRA participant.
BPD-TYPE Alpha 2 BN81.1 BN81.2
Type Indicates whether the cash entry is for
a payment or a credit memo.
CK = Payment
CM = Credit Memo
BPD-CHECK-NBR Numeric 8 BN81.1 BN81.2
Payment Number Contains the payment number.
BPD-INV-NUMBER Numeric 3 BN81.1 BN81.2
Invoice Number Contains the invoice number associated
with this payment.
BPD-PLAN-TYPE Alpha 2 BN81.1 BN81.2
Type Contains the benefit plan type used to
identify the kind of plan associated
with this payment.
DL = Dependent Life
DN = Dental
EL = Employee Life
HL = Health
RS = Spending Account
BPD-PLAN-CODE Alpha 4 BN81.1 BN81.2
Plan Contains the plan code.
BPD-START-DATE Numeric 8 (yyyymmdd) BN81.1 BN81.2
Start Date Contains the start date of the benefit
plan.
BPD-AR-DIST-CO Numeric 4 BN81.1 BN81.2
Ar Dist Co
BPD-AR-ACCT-UNIT Alpha 15 BN81.1 BN81.2
Accts Receivable Contains the accounting unit used for
Account Unit posting the payment.
BPD-AR-ACCOUNT Numeric 6 BN81.1 BN81.2
Accounts Receivable Contains the account used for posting
Account the payment.
BPD-AR-SUB-ACCT Numeric 4 BN81.1 BN81.2
Accts Receivable Contains the subaccount used for
Subaccount posting the payment.
BPD-PMT-AMT Signed 11.2 BN81.1 BN81.2
Payment Amount Contains the payment amount received.
BNPAYDETL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BPDSET1 COMPANY BN190 BN281
EMPLOYEE BN480 BN81.1
PARTICIPNT BN81.2 BN82.1
TYPE
CHECK-NBR
INV-NUMBER
PLAN-TYPE
PLAN-CODE
START-DATE
BNPAYDETL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Ar Account GLMASTER Required
When BPD-AR-ACCT-UNIT != Spaces
Or BPD-AR-ACCOUNT != Zeroes
BPD-COMPANY -> GLM-COMPANY
BPD-AR-ACCT-UNIT -> GLM-ACCT-UNIT
BPD-AR-ACCOUNT -> GLM-ACCOUNT
BPD-AR-SUB-ACCT -> GLM-SUB-ACCOUNT
Benefit PARTBEN Required
BPD-COMPANY -> PTB-COMPANY
BPD-PLAN-TYPE -> PTB-PLAN-TYPE
BPD-PARTICIPNT -> PTB-PARTICIPNT
BPD-EMPLOYEE -> PTB-EMPLOYEE
BPD-START-DATE -> PTB-START-DATE
BPD-PLAN-CODE -> PTB-PLAN-CODE
Company BNCOMPANY Required
BPD-COMPANY -> BNC-COMPANY
Company Name PRSYSTEM Required
BPD-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Employee EMPLOYEE Required
When BPD-EMPLOYEE != Zeroes
BPD-COMPANY -> EMP-COMPANY
BPD-EMPLOYEE -> EMP-EMPLOYEE
Invoice Detail BNINVDETL Required
BPD-COMPANY -> BID-COMPANY
BPD-EMPLOYEE -> BID-EMPLOYEE
BPD-PARTICIPNT -> BID-PARTICIPNT
BPD-INV-NUMBER -> BID-INV-NUMBER
BPD-PLAN-TYPE -> BID-PLAN-TYPE
BPD-PLAN-CODE -> BID-PLAN-CODE
BPD-START-DATE -> BID-START-DATE
Participant PARTICIPNT Required
When BPD-PARTICIPNT != Zeroes
BPD-COMPANY -> PAR-COMPANY
BPD-PARTICIPNT -> PAR-PARTICIPNT
Payment BNPAYMENT Required
BPD-COMPANY -> BNP-COMPANY
BPD-PARTICIPNT -> BNP-EMPLOYEE
BPD-EMPLOYEE -> BNP-PARTICIPNT
BPD-TYPE -> BNP-TYPE
BPD-CHECK-NBR -> BNP-CHECK-NBR
Plan PLAN Required
BPD-COMPANY -> PLN-COMPANY
BPD-PLAN-TYPE -> PLN-PLAN-TYPE
BPD-PLAN-CODE -> PLN-PLAN-CODE
|