|
|
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: Participnt Contains 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: Check Nbr Contains the number of the payment.
BNP-PMT-AMT Signed 11.2 BN81.1
Element: Pmt Amt Contains the payment amount.
BNP-APPLIED-AMT Signed 15.2 BN81.1 BN81.2
Element: Applied 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: Reference Contains a user-defined reference or
comment.
BNP-DIST-CO Numeric 4 BN81.1
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.
BNP-ACCT-UNIT Alpha 15 BN81.1
Element: Acct Unit Contains 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: Sub Acct Contains the subaccount for the payment.
BNP-OS-INV-NUMBER Numeric 3 BN81.2
Element: Os Inv Number Contains the invoice number for the
over or short amount of the payment.
BNP-OS-PLAN-TYPE Alpha 2 BN81.2
Element: Os Plan Type Contains 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: Os Plan Code Contains the benefit plan's code.
BNP-OS-START-DATE Numeric 8 (yyyymmdd) BN81.2
Element: Os Start Date Contains the start date of the benefit
plan.
BNP-OS-AMOUNT Signed 7.2 BN81.2
Element: Os Amount Contains the over or short amount.
BNP-OS-DIST-CO Numeric 4 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.
BNP-OS-ACCT-UNIT Alpha 15 BN81.2
Element: Acct Unit Contains 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: Sub Acct Contains the subaccount for posting the
over or short amount.
BNP-AR-DIST-CO Numeric 4 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.
BNP-AR-ACCT-UNIT Alpha 15 BN81.2
Element: Acct Unit Contains 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: Sub Acct 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
Element: Acct Nd The number of decimals assigned to a
particular account as determined by the
account currency.
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
|
