# Query Claim Detail by Status

> Perform Query Claim Detail by Status through ClaimSoft.

Source: [https://genhealth.ai/docs/workflows/integrations/claim-soft/claimsoft_query_claim_detail_by_status](https://genhealth.ai/docs/workflows/integrations/claim-soft/claimsoft_query_claim_detail_by_status)

Integration: [ClaimSoft](https://genhealth.ai/docs/workflows/integrations/claim-soft.md)

- Handler: `claimsoft_query_claim_detail_by_status`

- Connection type: `claimsoft`

## Inputs

- `report` — Report (select, required)
  Required selected identifier or value.
  Options: ByAlert ("ByAlert"), ByPatient ("ByPatient"), BySalesperson ("BySalesperson"), ByHCPCS ("ByHCPCS"), ByPSR ("ByPSR"), ByPractitioner ("ByPractitioner"), ByPrimaryPayer ("ByPrimaryPayer"), BySecondaryPayer ("BySecondaryPayer")
- `selected_ids` — Selected Ids (json)
  Optional JSON value.
- `billing_location_ids` — Billing Location Ids (json)
  Optional JSON value.
- `begin_date` — Begin Date (date, required)
  Required date in YYYY-MM-DD format.
- `end_date` — End Date (date, required)
  Required date in YYYY-MM-DD format.
- `date_basis` — Date Basis (select)
  Optional selected identifier or value.
  Default: `"OrderCreated"`
  Options: OriginalBilled ("OriginalBilled"), SecondaryBilled ("SecondaryBilled"), PrimaryBilled ("PrimaryBilled"), PatientBilled ("PatientBilled"), ServiceDate ("ServiceDate"), ReorderDate ("ReorderDate"), OrderCreated ("OrderCreated"), AuthExpiration ("AuthExpiration")
- `statuses` — Statuses (json)
  Optional JSON value.
  Options: InProcess ("InProcess"), Scheduled ("Scheduled"), Submitted ("Submitted"), Closed ("Closed"), BilledOpen ("BilledOpen"), ReProcess ("ReProcess")
- `detail_level` — Detail Level (select)
  Optional selected identifier or value.
  Default: `"Items"`
  Options: Full claim details ("Items"), Claim summary ("Claims")
- `include_claim_comments` — Include Claim Comments (boolean)
  Optional true-or-false value.
  Default: `true`
- `include_no_payer` — Include No Payer (boolean)
  Optional true-or-false value.
  Default: `false`
- `ignore_location_sorting` — Ignore Location Sorting (boolean)
  Optional true-or-false value.
  Default: `false`
- `timely_filing_min` — Timely Filing Min (text)
  Optional text value.
- `timely_filing_max` — Timely Filing Max (text)
  Optional text value.
- `max_rows` — Max Rows (number)
  Optional numeric value.
  Default: `500`
- `skip_rows` — Skip Rows (number)
  Optional numeric value.
  Default: `0`
- `poll_interval_seconds` — Poll Interval Seconds (number)
  Optional numeric value.
  Default: `15`
- `timeout_seconds` — Timeout Seconds (number)
  Optional numeric value.
  Default: `600`

## Outputs

- `success` — Success
- `report_id` — Report Id
- `report_name` — Report Name
- `total` — Total
- `rows` — Rows
- `order_ids` — Order Ids
- `report_parameters` — Report Parameters
- `report_json` — Report Json
- `truncated` — Truncated
- `report_run_id` — Report Run Id
- `report_status` — Report Status
- `created_date` — Created Date
- `storage_key` — Storage Key
- `filename` — Filename
- `mime_type` — Mime Type
- `size_bytes` — Size Bytes
- `download_url` — Download Url
- `polls` — Polls
- `error` — Error

Output schema completeness: `best_effort_declared`

## Safety

- External effect: `write`
- Confirmation recommended: no
- Retry safe: no
- Dry run supported: no

## Schemas

These schemas are first-pass authoring guidance. Runtime validation remains authoritative.

### Input schema

```json
{
  "type": "object",
  "required": [
    "report",
    "begin_date",
    "end_date"
  ],
  "properties": {
    "report": {
      "enum": [
        "ByAlert",
        "ByPatient",
        "BySalesperson",
        "ByHCPCS",
        "ByPSR",
        "ByPractitioner",
        "ByPrimaryPayer",
        "BySecondaryPayer"
      ],
      "type": "string",
      "description": "Required selected identifier or value.",
      "x-workflow-field-type": "select"
    },
    "end_date": {
      "type": "string",
      "format": "date",
      "description": "Required date in YYYY-MM-DD format.",
      "x-workflow-field-type": "date"
    },
    "max_rows": {
      "type": "number",
      "default": 500,
      "description": "Optional numeric value.",
      "x-workflow-field-type": "number"
    },
    "statuses": {
      "enum": [
        "InProcess",
        "Scheduled",
        "Submitted",
        "Closed",
        "BilledOpen",
        "ReProcess"
      ],
      "description": "Optional JSON value.",
      "x-workflow-field-type": "json"
    },
    "skip_rows": {
      "type": "number",
      "default": 0,
      "description": "Optional numeric value.",
      "x-workflow-field-type": "number"
    },
    "begin_date": {
      "type": "string",
      "format": "date",
      "description": "Required date in YYYY-MM-DD format.",
      "x-workflow-field-type": "date"
    },
    "date_basis": {
      "enum": [
        "OriginalBilled",
        "SecondaryBilled",
        "PrimaryBilled",
        "PatientBilled",
        "ServiceDate",
        "ReorderDate",
        "OrderCreated",
        "AuthExpiration"
      ],
      "type": "string",
      "default": "OrderCreated",
      "description": "Optional selected identifier or value.",
      "x-workflow-field-type": "select"
    },
    "detail_level": {
      "enum": [
        "Items",
        "Claims"
      ],
      "type": "string",
      "default": "Items",
      "description": "Optional selected identifier or value.",
      "x-workflow-field-type": "select"
    },
    "selected_ids": {
      "description": "Optional JSON value.",
      "x-workflow-field-type": "json"
    },
    "timeout_seconds": {
      "type": "number",
      "default": 600,
      "description": "Optional numeric value.",
      "x-workflow-field-type": "number"
    },
    "include_no_payer": {
      "type": "boolean",
      "default": false,
      "description": "Optional true-or-false value.",
      "x-workflow-field-type": "boolean"
    },
    "timely_filing_max": {
      "type": "string",
      "description": "Optional text value.",
      "x-workflow-field-type": "text"
    },
    "timely_filing_min": {
      "type": "string",
      "description": "Optional text value.",
      "x-workflow-field-type": "text"
    },
    "billing_location_ids": {
      "description": "Optional JSON value.",
      "x-workflow-field-type": "json"
    },
    "poll_interval_seconds": {
      "type": "number",
      "default": 15,
      "description": "Optional numeric value.",
      "x-workflow-field-type": "number"
    },
    "include_claim_comments": {
      "type": "boolean",
      "default": true,
      "description": "Optional true-or-false value.",
      "x-workflow-field-type": "boolean"
    },
    "ignore_location_sorting": {
      "type": "boolean",
      "default": false,
      "description": "Optional true-or-false value.",
      "x-workflow-field-type": "boolean"
    }
  },
  "additionalProperties": false
}
```

### Output schema

```json
{
  "type": "object",
  "properties": {
    "rows": {},
    "error": {},
    "polls": {},
    "total": {},
    "success": {},
    "filename": {},
    "mime_type": {},
    "order_ids": {},
    "report_id": {},
    "truncated": {},
    "size_bytes": {},
    "report_json": {},
    "report_name": {},
    "storage_key": {},
    "created_date": {},
    "download_url": {},
    "report_run_id": {},
    "report_status": {},
    "report_parameters": {}
  },
  "additionalProperties": true
}
```