Properties
| Name | Type | Description |
|---|---|---|
| month_end_data_loaded | stringnull | Month end of data being loaded |
| status | object | |
| preload_started | stringnull | When pre-load started |
| load_started | stringnull | When load started |
| first_account | stringnull | Starting trust account number |
| last_account | stringnull | Ending trust account number |
| number_of_accounts | integernull | Number of accounts |
| load_id | string | Unique ID assigned when Load file was received for processing |
| short_month | object | |
| main_pan | stringnull | Main PAN number |
| vendor_id | stringnull | Vendor ID |
| sequence | integer | Sequence |
| oid_only | object | |
| processing_step | integer | Current processing step (internal) |
| completion_status | object | |
| volser | stringnull | VolSer of tape being loaded |
| received_file_name | stringnull | Name of Load File As Received from Vendor |
| number_of_accounts_closed | integernull | Number of accounts closed |
| number_of_sales | integernull | Number of sales |
| number_of_ctf_transactions | integernull | Number of CTF transactions |
| number_of_records_on_custom_file | integernull | Total Number Records on Custom File |
| number_of_5227_balance_sheet_record_8 | integernull | Number of 5227 Balance Sheet Record 8 |
| number_of_5227_asset_detail_record_82 | integernull | Number of 5227 Asset Detail Record 82 |
| number_of_5227_balance_sheet_record_81 | integernull | Number of 5227 Balance Sheet Record 81 |
| number_of_990_balance_sheet_record_89 | integernull | Number of 990 Balance Sheet Record 89 |
| number_of_accounts_loaded_5498_fmv | integernull | Number of Accounts Loaded 5498 FMV |
| number_of_ctf_factor_records_with_state | integernull | Number of CTF Factor Records with State |
| number_of_accounts_added | integernull | Number of accounts added |
| number_of_beneficiaries_loaded | integernull | Number of beneficiaries loaded |
| number_of_beneficiaries_added | integernull | Number of beneficiaries added |
| number_of_beneficiaries_deleted | integernull | Number of beneficiaries deleted |
| number_of_beneficiaries_changed | integernull | Number of changed beneficiaries |
| number_of_transactions | integernull | Number of transactions |
| total_number_of_records | integernull | Total number of records |
| number_of_k1_records | integernull | Number of K1 Records |
| number_of_copy_to_records | integernull | Number of Copy To Records |
| number_of_ctf_factor_records | integernull | Number of CTF Factor Records |
| number_of_mutual_fund_transaction_records | integernull | Number of Mutual Fund Transaction Records |
| number_of_portfolio_open_lot_position_3q | integernull | Number of Portfolio Open Lot Position (3Q) |
| number_of_portfolio_position_3p | integernull | Number of Portfolio Position (3P) |
| number_of_sales_stop_4s | integernull | Number of Sales Stop (4S) |
| number_of_sales_updated_4u | integernull | Number of Sales Updated (4U) |
| number_of_transactions_stop_3s | integernull | Number of Transactions Stop(3S) |
| number_of_transactions_updated_3u | integernull | Number of Transactions Updated (3U) |
| number_of_mineral_records | integernull | Number of Mineral Records |
| number_of_mutual_fund_factor_records | integernull | Number of Mutual Fund Factor Records |
JSON Schema
{
"$schema": "https://json-schema.org/draft/2020-12/schema",
"$id": "https://raw.githubusercontent.com/api-evangelist/thomson-reuters/main/json-schema/thomson-reuters-load-status-schema.json",
"title": "LoadStatus",
"x-generated": "2026-10-20",
"x-method": "derived",
"x-generator": "derive-json-schema.py",
"x-source": "openapi/thomson-reuters-onesource-trust-tax-administration-openapi.yml#/components/schemas/LoadStatus",
"type": "object",
"properties": {
"month_end_data_loaded": {
"type": [
"string",
"null"
],
"description": "Month end of data being loaded",
"format": "date-time"
},
"status": {
"$ref": "#/$defs/ClientStatus"
},
"preload_started": {
"type": [
"string",
"null"
],
"description": "When pre-load started",
"format": "date-time"
},
"load_started": {
"type": [
"string",
"null"
],
"description": "When load started",
"format": "date-time"
},
"first_account": {
"type": [
"string",
"null"
],
"description": "Starting trust account number"
},
"last_account": {
"type": [
"string",
"null"
],
"description": "Ending trust account number"
},
"number_of_accounts": {
"type": [
"integer",
"null"
],
"description": "Number of accounts",
"format": "int32"
},
"load_id": {
"type": "string",
"description": "Unique ID assigned when Load file was received for processing",
"format": "date-time"
},
"short_month": {
"$ref": "#/$defs/YesNo"
},
"main_pan": {
"type": [
"string",
"null"
],
"description": "Main PAN number"
},
"vendor_id": {
"type": [
"string",
"null"
],
"description": "Vendor ID"
},
"sequence": {
"type": "integer",
"description": "Sequence",
"format": "int32"
},
"oid_only": {
"$ref": "#/$defs/YesNo"
},
"processing_step": {
"type": "integer",
"description": "Current processing step (internal)",
"format": "int32"
},
"completion_status": {
"$ref": "#/$defs/CompletionCode"
},
"volser": {
"type": [
"string",
"null"
],
"description": "VolSer of tape being loaded"
},
"received_file_name": {
"type": [
"string",
"null"
],
"description": "Name of Load File As Received from Vendor"
},
"number_of_accounts_closed": {
"type": [
"integer",
"null"
],
"description": "Number of accounts closed",
"format": "int32"
},
"number_of_sales": {
"type": [
"integer",
"null"
],
"description": "Number of sales",
"format": "int32"
},
"number_of_ctf_transactions": {
"type": [
"integer",
"null"
],
"description": "Number of CTF transactions",
"format": "int32"
},
"number_of_records_on_custom_file": {
"type": [
"integer",
"null"
],
"description": "Total Number Records on Custom File",
"format": "int32"
},
"number_of_5227_balance_sheet_record_8": {
"type": [
"integer",
"null"
],
"description": "Number of 5227 Balance Sheet Record 8",
"format": "int32"
},
"number_of_5227_asset_detail_record_82": {
"type": [
"integer",
"null"
],
"description": "Number of 5227 Asset Detail Record 82",
"format": "int32"
},
"number_of_5227_balance_sheet_record_81": {
"type": [
"integer",
"null"
],
"description": "Number of 5227 Balance Sheet Record 81",
"format": "int32"
},
"number_of_990_balance_sheet_record_89": {
"type": [
"integer",
"null"
],
"description": "Number of 990 Balance Sheet Record 89",
"format": "int32"
},
"number_of_accounts_loaded_5498_fmv": {
"type": [
"integer",
"null"
],
"description": "Number of Accounts Loaded 5498 FMV",
"format": "int32"
},
"number_of_ctf_factor_records_with_state": {
"type": [
"integer",
"null"
],
"description": "Number of CTF Factor Records with State",
"format": "int32"
},
"number_of_accounts_added": {
"type": [
"integer",
"null"
],
"description": "Number of accounts added",
"format": "int32"
},
"number_of_beneficiaries_loaded": {
"type": [
"integer",
"null"
],
"description": "Number of beneficiaries loaded",
"format": "int32"
},
"number_of_beneficiaries_added": {
"type": [
"integer",
"null"
],
"description": "Number of beneficiaries added",
"format": "int32"
},
"number_of_beneficiaries_deleted": {
"type": [
"integer",
"null"
],
"description": "Number of beneficiaries deleted",
"format": "int32"
},
"number_of_beneficiaries_changed": {
"type": [
"integer",
"null"
],
"description": "Number of changed beneficiaries",
"format": "int32"
},
"number_of_transactions": {
"type": [
"integer",
"null"
],
"description": "Number of transactions",
"format": "int32"
},
"total_number_of_records": {
"type": [
"integer",
"null"
],
"description": "Total number of records",
"format": "int32"
},
"number_of_k1_records": {
"type": [
"integer",
"null"
],
"description": "Number of K1 Records",
"format": "int32"
},
"number_of_copy_to_records": {
"type": [
"integer",
"null"
],
"description": "Number of Copy To Records",
"format": "int32"
},
"number_of_ctf_factor_records": {
"type": [
"integer",
"null"
],
"description": "Number of CTF Factor Records",
"format": "int32"
},
"number_of_mutual_fund_transaction_records": {
"type": [
"integer",
"null"
],
"description": "Number of Mutual Fund Transaction Records",
"format": "int32"
},
"number_of_portfolio_open_lot_position_3q": {
"type": [
"integer",
"null"
],
"description": "Number of Portfolio Open Lot Position (3Q)",
"format": "int32"
},
"number_of_portfolio_position_3p": {
"type": [
"integer",
"null"
],
"description": "Number of Portfolio Position (3P)",
"format": "int32"
},
"number_of_sales_stop_4s": {
"type": [
"integer",
"null"
],
"description": "Number of Sales Stop (4S)",
"format": "int32"
},
"number_of_sales_updated_4u": {
"type": [
"integer",
"null"
],
"description": "Number of Sales Updated (4U)",
"format": "int32"
},
"number_of_transactions_stop_3s": {
"type": [
"integer",
"null"
],
"description": "Number of Transactions Stop(3S)",
"format": "int32"
},
"number_of_transactions_updated_3u": {
"type": [
"integer",
"null"
],
"description": "Number of Transactions Updated (3U)",
"format": "int32"
},
"number_of_mineral_records": {
"type": [
"integer",
"null"
],
"description": "Number of Mineral Records",
"format": "int32"
},
"number_of_mutual_fund_factor_records": {
"type": [
"integer",
"null"
],
"description": "Number of Mutual Fund Factor Records",
"format": "int32"
}
},
"additionalProperties": false,
"$defs": {
"ClientStatus": {
"enum": [
"Pending",
"Processing",
"Completed",
"Received",
"Received_Needs_Attention",
"Received_Stop_Service",
"Received_Load_on_Hold",
"PreLoad_Queued",
"Preload_Processing",
"Preload_Complete",
"Preload_Needs_Attention",
"Preload_Split",
"Return_Marked_As_Completed",
"Load_Queued",
"Load_Processing",
"Load_Complete",
"Load_Needs_Attention",
"Loaded_with_Errors",
"Load_Failed_See_Report",
"Loaded_with_Failures",
"Stop_Load_Requested",
"Stop_Completed",
"Delete_Load_Queued",
"Delete_Load_Processing",
"Delete_Load_Complete",
"Delete_Load_Needs_Attention",
"SB_Hits_Queued",
"SB_Hits_Processing",
"SB_Hits_Needs_Attention"
],
"type": "integer",
"description": "Client Status",
"format": "int32"
},
"CompletionCode": {
"enum": [
"Processing",
"Completed",
"Needs_Attention"
],
"type": "integer",
"description": "Completion Code",
"format": "int32"
},
"YesNo": {
"enum": [
"No",
"Yes"
],
"type": "integer",
"format": "int32"
}
}
}Work with this as data
Every JSON Schema here is available over the APIs.io API and to AI agents over MCP.
MCP server
One button, every client — Claude, Cursor, VS Code and the rest.
https://apis.io/mcp
Tools for schemas
4 MCP tools reach this
find_json_schemasBrowse and filter every JSON Schema in the catalog.apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.resolveTurn a domain, URL or GitHub org into the provider it belongs to.find_cohortsEvery scored population of providers in the catalog.
Call it yourself
curl for this page
This JSON Schema
curl "https://apis.io/api/v1/json-schemas/thomson-reuters-load-status"
All schemas
curl "https://apis.io/api/v1/json-schemas?limit=25"Discovery needs no key. Ratings and market analysis are Pro.
Get an API key
Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.
A second provider on the same verified email joins the account you already have.