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