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.
UPDATED BY
BN190 | BN281 | BN480 | BN81.1 | BN81.2 | BN82.1 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||
---|---|---|---|---|---|---|
BNP-COMPANY Element: Company Hr | Numeric 4 Contains the company number. The number correlates all information about the company. |
|
||||
BNP-EMPLOYEE Element: Employee | Numeric 9 Contains the employee's number. |
|
||||
BNP-PARTICIPNT Element: Participnt | Numeric 9 Contains COBRA participant numbers. The number correlates all information about the COBRA participant. |
|
||||
BNP-TYPE Element: Type | Alpha 2 Indicates whether the transaction is a payment or a credit memo. CK = Payment CM = Credit Memo |
|
||||
BNP-CHECK-NBR Element: Check Nbr | Numeric 8 Contains the number of the payment. |
|
||||
BNP-PMT-AMT Element: Pmt Amt | Signed 11.2 Contains the payment amount. |
|
||||
BNP-APPLIED-AMT Element: Applied Amt | Signed 15.2 Contains the amount applied to the outstanding balance. |
|
||||
BNP-DATE Element: Date | Numeric 8 (yyyymmdd) Contains the transaction date. |
|
||||
BNP-REFERENCE Element: Reference | Alpha 10 (Lower Case) Contains a user-defined reference or comment. |
|
||||
BNP-DIST-CO Element: Company | Numeric 4 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 Element: Acct Unit | Alpha 15 Contains the accounting unit for the payment. |
|
||||
BNP-ACCOUNT Element: Account | Numeric 6 Contains the account for the payment. |
|
||||
BNP-SUB-ACCT Element: Sub Acct | Numeric 4 Contains the subaccount for the payment. |
|
||||
BNP-OS-INV-NUMBER Element: Os Inv Number | Numeric 3 Contains the invoice number for the over or short amount of the payment. |
|
||||
BNP-OS-PLAN-TYPE Element: Os Plan Type | Alpha 2 Contains the benefit type. HL = Health DN = Dental EL = Employee Life DL = Dependent Life RS = Spending Account |
|
||||
BNP-OS-PLAN-CODE Element: Os Plan Code | Alpha 4 Contains the benefit plan's code. |
|
||||
BNP-OS-START-DATE Element: Os Start Date | Numeric 8 (yyyymmdd) Contains the start date of the benefit plan. |
|
||||
BNP-OS-AMOUNT Element: Os Amount | Signed 7.2 Contains the over or short amount. |
|
||||
BNP-OS-DIST-CO Element: Company | Numeric 4 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 Element: Acct Unit | Alpha 15 Contains the account used for posting the over or short amount. |
|
||||
BNP-OS-ACCOUNT Element: Account | Numeric 6 Contains the account for posting the over or short amount. |
|
||||
BNP-OS-SUB-ACCT Element: Sub Acct | Numeric 4 Contains the subaccount for posting the over or short amount. |
|
||||
BNP-AR-DIST-CO Element: Company | Numeric 4 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 Element: Acct Unit | Alpha 15 Contains the accounting unit for the over short account. |
|
||||
BNP-AR-ACCOUNT Element: Account | Numeric 6 Contains the account for the over short payment. |
|
||||
BNP-AR-SUB-ACCT Element: Sub Acct | Numeric 4 Contains the subaccount for the over short account. |
|
||||
BNP-STATUS Element: Status | Numeric 1 Contains the status of a given transaction. 1 = Posted to G/L 0 = Not Posted to G/L |
|
||||
BNP-CURRENCY-CODE Element: Currency Code | Alpha 5 This field contains the company base currency code established in Company (GL10.1 ). |
|
||||
BNP-CURR-ND Element: Acct Nd | Numeric 1 The number of decimals assigned to a particular account as determined by the account currency. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
BNPSET1 |
COMPANY EMPLOYEE PARTICIPNT TYPE CHECK-NBR |
|
| ||||||||||||||||
BNPSET2 |
COMPANY EMPLOYEE PARTICIPNT TYPE CHECK-NBR |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Ar Account | GLMASTER |
Required
| ||||||||||||||||||||||||||||||
Company | BNCOMPANY |
Required
| ||||||||||||||||||||||||||||||
Company Name | PRSYSTEM |
Required
| ||||||||||||||||||||||||||||||
Currency | CUCODES |
Required
| ||||||||||||||||||||||||||||||
Employee | EMPLOYEE |
Required
| ||||||||||||||||||||||||||||||
Gl Account | GLMASTER |
Required
| ||||||||||||||||||||||||||||||
Os Account | GLMASTER |
Required
| ||||||||||||||||||||||||||||||
Os Invoice | BNINVDETL |
Required
| ||||||||||||||||||||||||||||||
Os Plan | PLAN |
Required
| ||||||||||||||||||||||||||||||
Participant | PARTICIPNT |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Payment Detail | BNPAYDETL |
Delete Restricted
|
All trademarks and registered trademarks are the property of their
respective owners.