Report
Tables (3)
AccountReceivable
- RecvId — INT — Primary key — NOT NULL
- SessionId — INT — NOT NULL
- ClientId — INT — NOT NULL
- ServiceTypeId — INT — NOT NULL
- CounselorId — INT — NOT NULL
- Price — INT
- RecvDt — DATETIME
- RecvType — INT
- Notes — TEXT
- Closed — BOOL
- Discard — BOOL
- RecvStatus — VARCHAR(255)
Aggregated_Billing (Untitled)
- recv_id — Primary key — NOT NULL
- price
- client_portion
- recv_status
- deductible
- client_paid
- insurance_paid
- first_billed_date
- claim_count
- last_claim_status
- last_follow_up_date
- insurance_company_id
- last_updated_at
- date_of_service
Weekly_Non_Billable_AR_Instance (.)
- id — INT — Primary key — NOT NULL
- RecvId — INT — Foreign key → AccountReceivable.RecvId — NOT NULL
- date — DATETIME
- deductible — BOOL
- client_portion_met — BOOL
- diagnosis — BOOL
- document — BOOL
- progress_notes — BOOL
- center — TINYINT
- price — FLOAT
- insurance_portion — FLOAT
- insurance_company_id — INT
- date_of_service — DATETIME