XBRL Evaluation Program Normalizes Financial Data Strings
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
The processing load for evaluating records in input-completed sheets is increased when the character strings in financial statements submitted in XBRL format are changed, leading to inconsistencies and errors during conversion to XBRL instances.
Innovation Solution
An evaluation program that normalizes and compares character strings in input-completed sheets with those defined in the mapping definition, determining whether item values satisfy conditions to evaluate records efficiently, thereby reducing processing time and load.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If character strings in financial statements are changed, then adaptability to different descriptions is improved, but processing load increases and errors occur
Solution Approach 1:
The patent applies preliminary action by pre-defining mapping definitions that associate XBRL items with multiple possible character string variations. Before actual conversion occurs, the system prepares a mapping framework that anticipates different description forms, allowing it to handle character string changes without increasing processing load during conversion. The mapping definition is created in advance to include various acceptable descriptions for each XBRL item.
Solution Approach 2:
The patent applies parameter changes by transforming character strings into a normalized form through the mapping definition. Instead of processing raw character strings directly, the system converts them into standardized XBRL item references, changing the parameter from variable text descriptions to fixed structured data. This parameter transformation reduces processing complexity while maintaining adaptability to different original descriptions.
2Loss of time
If character strings are normalized and compared, then processing time is reduced, but measurement precision of original descriptions may be lost
Solution Approach 1:
The patent applies copying by creating a mapping definition that preserves the relationship between original character strings and XBRL items. Instead of losing original description information, the system creates a reference copy that maps various character string forms to their corresponding XBRL items. This copying mechanism allows fast processing through normalization while retaining the ability to trace back to original descriptions if needed.
Solution Approach 2:
The patent applies intermediary by introducing the mapping definition as a mediating layer between original character strings and XBRL items. The mapping definition serves as an intermediary structure that enables efficient comparison and processing through normalization, while simultaneously preserving the connection to original descriptions. This intermediary layer resolves the conflict between processing speed and information retention.
3Reliability
If evaluation is performed on all records, then reliability of conversion is improved, but productivity decreases
Solution Approach 1:
The patent applies segmentation by dividing the evaluation process into two distinct phases: a comprehensive evaluation phase during mapping definition creation, and a streamlined evaluation phase during actual conversion. The mapping definition is created with complete evaluation rules in advance, then reused during conversion without repeating full evaluation. This segmentation allows thorough reliability checking when creating the mapping while maintaining high productivity during subsequent conversions.
Solution Approach 2:
The patent applies preliminary action by performing complete evaluation and creating the mapping definition before actual conversion operations. All complex evaluation logic is executed in advance when building the mapping definition, so that subsequent conversions can rely on the pre-established mapping without repeating intensive evaluation. This preliminary action ensures conversion reliability while enabling fast processing during actual use.
Data Source
AI summary
A non-transitory computer-readable recording medium records an evaluation program for causing a computer to execute processing including: acquiring a record group that includes a plurality of ordered records and includes a plurality of item values in which each record is associated with each of a plurality of items; specifying a first record and a second record associated with order having a predetermined relationship with order associated with the first record from among records included in the acquired record group; determining whether or not an item value associated with a second item included in the first record satisfies a condition in a case where an item value associated with the first item among item values included in the first record is different from an item value associated with the first item among item values included in the second record; and evaluating the first record on the basis of the determination result.


