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 |
BN480 | BN81.1 | BN81.2 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||
---|---|---|---|---|
BPD-COMPANY Element: Company Hr | Numeric 4 Contains the company number. The number correlates all information about the company. |
|
||
BPD-EMPLOYEE Element: Employee | Numeric 9 Contains the employee's number. The number correlates all information about the employee. |
|
||
BPD-PARTICIPNT Element: Participnt | Numeric 9 Contains COBRA participant numbers. The number correlates all information about the COBRA participant. |
|
||
BPD-TYPE Element: Type | Alpha 2 Indicates whether the cash entry is for a payment or a credit memo. CK = Payment CM = Credit Memo |
|
||
BPD-CHECK-NBR Element: Check Nbr | Numeric 8 Contains the payment number. |
|
||
BPD-INV-NUMBER Element: Inv Number | Numeric 3 Contains the invoice number associated with this payment. |
|
||
BPD-PLAN-TYPE Element: Plan Type | Alpha 2 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 Element: Plan Code | Alpha 4 Contains the plan code. |
|
||
BPD-START-DATE Element: Start Date | Numeric 8 (yyyymmdd) Contains the start date of the benefit plan. |
|
||
BPD-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. |
|
||
BPD-AR-ACCT-UNIT Element: Acct Unit | Alpha 15 Contains the accounting unit used for posting the payment. |
|
||
BPD-AR-ACCOUNT Element: Account | Numeric 6 Contains the account used for posting the payment. |
|
||
BPD-AR-SUB-ACCT Element: Sub Acct | Numeric 4 Contains the subaccount used for posting the payment. |
|
||
BPD-PMT-AMT Element: Pmt Amt | Signed 11.2 Contains the payment amount received. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
BPDSET1 |
COMPANY EMPLOYEE PARTICIPNT TYPE CHECK-NBR INV-NUMBER PLAN-TYPE PLAN-CODE START-DATE |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Ar Account | GLMASTER |
Required
| ||||||||||||||||||||||||
Benefit | PARTBEN |
Required
| ||||||||||||||||||||||||
Company | BNCOMPANY |
Required
| ||||||||||||||||||||||||
Company Name | PRSYSTEM |
Required
| ||||||||||||||||||||||||
Employee | EMPLOYEE |
Required
| ||||||||||||||||||||||||
Invoice Detail | BNINVDETL |
Required
| ||||||||||||||||||||||||
Participant | PARTICIPNT |
Required
| ||||||||||||||||||||||||
Payment | BNPAYMENT |
Required
| ||||||||||||||||||||||||
Plan | PLAN |
Required
|
All trademarks and registered trademarks are the property of their
respective owners.