Patient Credit: Standard Extract Table
This data table contains information about patient credits pulled from RevFlow.
| Data Element | Type | Description |
| record_id | Integer | Unique ID for the payment adjustment record |
| patient_credit_id | Integer | Internal ID for the patient credit record |
| patient_id | Integer | Revflow patient account number (patient_id) |
| from_ins_code | Integer | Internal ID for the insurance provider |
| payer_name | String | Name of Insurance provider |
| deposit_date | Date | Date of the deposit |
| amount | Float | The amount of the deposit |
| original_amount | Float | The original amount |
| payment_type | String | Type of payment, check, cash, etc |
| created_date | Date | Date of creation of the patient credit record |
| company_id | Integer | Internal Revflow Company ID |
| payment_code_id | Integer | Refercense the payment code (Needs c_payment to make sense not for external use) |
| place_of_service_id | Integer | Internal Revflow Place of Service ID |
| place_of_service_name | String | Name of the Place of Service |
| provider_id | Integer | Internal Revflow ID for the therapist |
| provider_first_name | String | Provider first name |
| provider_last_name | String | Provider last name |
| webpt_therapist_id | Integer | Internal webpt therapist ID |
| charge_id | Integer | Charge Id if applicable |
| time_stamp | DateTime | date the record was written |
| created_by | Integer | Created by identifier |
| patient_credit_type | String | Credit Type |
| money_type | Integer | Money type |
| status | String | status |
| adjustment_code_id | Integer | Adjustment Code |
| from_payer_id | Integer | From Payer Id |
| from_payer_name | String | From Payer Name |
| from_payer_desc | String | From Payer Desc |
| ins_class_desc | String | Insurance class |
| payment_desc | String | payment description |
| payment_code_code | String | payment code |
| export_flag | Integer | Export flag 1 = New, 2 = Modified, 3 = Removed |