|
|
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
Element: Company Hr Contains the company number. The number
correlates all information about the
company.
BPD-EMPLOYEE Numeric 9 BN81.1 BN81.2
Element: Employee Contains the employee's number. The
number correlates all information about
the employee.
BPD-PARTICIPNT Numeric 9 BN81.1 BN81.2
Element: Participnt Contains COBRA participant numbers. The
number correlates all information about
the COBRA participant.
BPD-TYPE Alpha 2 BN81.1 BN81.2
Element: 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
Element: Check Nbr Contains the payment number.
BPD-INV-NUMBER Numeric 3 BN81.1 BN81.2
Element: Inv Number Contains the invoice number associated
with this payment.
BPD-PLAN-TYPE Alpha 2 BN81.1 BN81.2
Element: Plan 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
Element: Plan Code Contains the plan code.
BPD-START-DATE Numeric 8 (yyyymmdd) BN81.1 BN81.2
Element: Start Date Contains the start date of the benefit
plan.
BPD-AR-DIST-CO Numeric 4 BN81.1 BN81.2
Element: Company Identifies the AP company if the
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
BPD-AR-ACCT-UNIT Alpha 15 BN81.1 BN81.2
Element: Acct Unit Contains the accounting unit used for
posting the payment.
BPD-AR-ACCOUNT Numeric 6 BN81.1 BN81.2
Element: Account Contains the account used for posting
the payment.
BPD-AR-SUB-ACCT Numeric 4 BN81.1 BN81.2
Element: Sub Acct Contains the subaccount used for
posting the payment.
BPD-PMT-AMT Signed 11.2 BN81.1 BN81.2
Element: Pmt Amt 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
|
