MEMBER_PAYMENTS
Description:
This table contains information about payments by the member

Primary Key
Column Name Ordinal Position
BENEFIT_USAGE_ID 1
CONTACT_DATE_REAL 2
LINE 3

Column Information
Name Type Discontinued?
1 BENEFIT_USAGE_ID VARCHAR No
The unique ID of the benefit usage record.
2 CONTACT_DATE_REAL FLOAT No
The date when a benefit usage was recorded.
3 LINE INTEGER No
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
4 PAYMENT_C VARCHAR No
The payment type.
May contain organization-specific values: Yes
Category Entries:
Check
Credit Card
Cash
No Payment Due
Other
Unpaid
5 RECEIPT_NUM VARCHAR No
The receipt number for the payment.
6 AMOUNT_PAID NUMERIC No
The amount paid in the transaction.
7 PAYMENT_NAME VARCHAR No
The name appearing on check/credit card.
8 CHECK_NUMBER VARCHAR No
The check number.
9 CHECK_DATE DATETIME No
The check date.
10 CC_NUMBER INTEGER No
The credit card number.
11 CC_EXPIRE VARCHAR No
The expiration date for credit card.
12 CC_TYPE_C VARCHAR No
The credit card type.
May contain organization-specific values: Yes
Category Entries:
Visa
Discover
American Express
Master Card
13 OTHER_PAYMENT_C VARCHAR No
The other mode of payment.
May contain organization-specific values: Yes