Query Claim Detail by Status
Perform Query Claim Detail by Status through ClaimSoft.
claimsoft_query_claim_detail_by_statusInputs
- Report
reportselectrequiredRequired selected identifier or value.
Options: ByAlert ("ByAlert"), ByPatient ("ByPatient"), BySalesperson ("BySalesperson"), ByHCPCS ("ByHCPCS"), ByPSR ("ByPSR"), ByPractitioner ("ByPractitioner"), ByPrimaryPayer ("ByPrimaryPayer"), BySecondaryPayer ("BySecondaryPayer")
- Selected Ids
selected_idsjsonOptional JSON value.
- Billing Location Ids
billing_location_idsjsonOptional JSON value.
- Begin Date
begin_datedaterequiredRequired date in YYYY-MM-DD format.
- End Date
end_datedaterequiredRequired date in YYYY-MM-DD format.
- Date Basis
date_basisselectOptional selected identifier or value.
Default:
"OrderCreated"Options: OriginalBilled ("OriginalBilled"), SecondaryBilled ("SecondaryBilled"), PrimaryBilled ("PrimaryBilled"), PatientBilled ("PatientBilled"), ServiceDate ("ServiceDate"), ReorderDate ("ReorderDate"), OrderCreated ("OrderCreated"), AuthExpiration ("AuthExpiration")
- Statuses
statusesjsonOptional JSON value.
Options: InProcess ("InProcess"), Scheduled ("Scheduled"), Submitted ("Submitted"), Closed ("Closed"), BilledOpen ("BilledOpen"), ReProcess ("ReProcess")
- Detail Level
detail_levelselectOptional selected identifier or value.
Default:
"Items"Options: Full claim details ("Items"), Claim summary ("Claims")
- Include Claim Comments
include_claim_commentsbooleanOptional true-or-false value.
Default:
true - Include No Payer
include_no_payerbooleanOptional true-or-false value.
Default:
false - Ignore Location Sorting
ignore_location_sortingbooleanOptional true-or-false value.
Default:
false - Timely Filing Min
timely_filing_mintextOptional text value.
- Timely Filing Max
timely_filing_maxtextOptional text value.
- Max Rows
max_rowsnumberOptional numeric value.
Default:
500 - Skip Rows
skip_rowsnumberOptional numeric value.
Default:
0 - Poll Interval Seconds
poll_interval_secondsnumberOptional numeric value.
Default:
15 - Timeout Seconds
timeout_secondsnumberOptional numeric value.
Default:
600
Outputs
successSuccessreport_idReport Idreport_nameReport NametotalTotalrowsRowsorder_idsOrder Idsreport_parametersReport Parametersreport_jsonReport JsontruncatedTruncatedreport_run_idReport Run Idreport_statusReport Statuscreated_dateCreated Datestorage_keyStorage KeyfilenameFilenamemime_typeMime Typesize_bytesSize Bytesdownload_urlDownload UrlpollsPollserrorError
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
{
"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
{
"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
}