Category: ISO
-
Object Class Definition Sheet Creation Guide
Views: 13 Object Class Definition Sheet Creation Guide Contents 1. Introduction 2. Understanding UML and Semantic Modeling 2.1. Class in UML 2.2. Property of a Class 2.3. Types of Properties 3. Preparation Tasks 3.1. Resuming Class and Property Names 3.2. Define Data Types for Each Field 3.3. Refine Description 4. Semantic Analysis and Definition of Object Classes in GL Data Model 4.1. Check for Repetitive Field Sets 4.2. Integrating into AWI Semantic model 5. Understanding Multicurrency Monetary Amounts in System Design 5.1. The Basics of Monetary Amounts and Currency Code Class 5.2. Designing a Multicurrency Monetary Amount Class 5.3. UML Representation of Multicurrency Amounts 5.4. Integration with the Currency Code […]
-
Universal Audit Data Converter, UADC
Views: 20 Universal Audit Data Converter (UADC) Table of Contents 1. Overview 2. Developments in Audit Data Standards 2.1. Importance of Audit Data Standardization 2.2. AICPA’s Audit Data Standard 2.3. China’s GB/T 24589 2.4. ISO/TC 295 Audit data services 3. Role of UADC 3.1. Application to ESG Report Auditing 4. Improvements in Auditing with UADC 4.1. Efficiency and Speed 4.2. Consistency and Quality Improvement 4.3. Summary 5. Generic Data Conversion Processing 6. Syntax Binding 6.1. Japanese Core Invoice Gateway 6.2. XBRL Taxonomy 6.3. Adapting to System Changes 7. Semantic Binding 7.1. Its Role 7.2. Flexibility and Adaptability 7.3. Contributing to Efficiency and Speed 7.4. Wickham’s Tidy Data Concept 7.5. xBRL-CSV […]
-
Innovation in Auditing for Complete Accuracy and Integrity of ESG Reporting
Views: 41 Innovation in Auditing for Complete Accuracy and Integrity of ESG Reporting Table of Contents 1. Overview 1.1. Summary 1.2. Introduction 1.3. Why ESG Reporting is Important 1.4. Accuracy in Auditing with XBRL 1.5. Utilizing xBRL-CSV 1.6. Concrete Benefits for Auditors and Auditees 1.7. Conclusion: Absolute Transparency and Accuracy in ESG Reporting 2. ESG Reporting in Japan 2.1. The State of ESG in Japan 3. The Role of the International Sustainability Standards Board (ISSB) 4. Strengthening ESG Reporting 5. Effective Use of XBRL in ESG Reporting and Details 5.1. Beyond Traditional Metrics 5.2. Deep Insights from Raw Data 5.3. Historical Tracking and Contextualization 5.4. Enabling Deeper Evaluations 5.5. Enhancing […]
-
The multiplicity of the attribute in ISO/IEC 19505-1:2012(E) Unified Modeling Language
Views: 6 The multiplicity of the attribute in ISO/IEC 19505-1:2012(E) Unified Modeling Language (OMG UML) [%hardbreaks] Table of Contents 1. Classes Diagram 2. The multiplicity of the attribute (default in UML) 3. The multiplicity of the attribute (Example) Nobuyuki SAMBUICHI ISO/TC295 Audit data services/SG1 Semantic model Convener In the ISO/IEC 19505-1:2012(E) Unified Modeling Language (OMG UML), the cardinality of an object class property is defined as the “multiplicity” of the attribute, allowing for multiple occurrences to be specified. Instead of ISO/IEC 19763 Metamodel framework for interoperability (MFI), we have the option to use the ISO 19505 style text notation for our framework. The notation of MFI (ISO/IEC 19763) is more […]
-
HL7 Graph Walk and Cardinality
Views: 6 HL7 Graph Walk and Cardinality Table of Contents 1. Do we care cardinality then? 2. How cardinality affect graph walk defined in HL7? 3. summarize HL7 graph walk using LIFO queue and cardinality. 4. can you write python program perform graph walk? 5. Can you handle following graph? 6. Python program perform HL7 Graph walk Nobuyuki SAMBUICHI ISO/TC295 Audit data services/SG1 Semantic model Convener 1. Do we care cardinality then? ChatGPT Yes, cardinality is an important aspect when designing and modeling associations between entities in a system. It defines the number of instances or elements that can be associated with each other. Cardinality provides information about the relationship […]
-
ISO 11179:2023 Semantic model definition using ISO/IEC 19505 OMG UML
Views: 8 ISO 11179:2023 Semantic model definition using ISO/IEC 19505 OMG UML Table of Contents 1. Example in ISO/IEC 11179-3 1.1. UML Class Diagram in Figure A.1 1.2. UML Class Diagram in Figure A.7 Nobuyuki SAMBUICHI ISO/TC295 Audit data services/SG1 Semantic model Convener In the 2023 version of ISO/IEC 11179, we can define the UML semantic model and hierarchical logical data model with the ISO/IEC 11179-3 terms without using ISO 15000-5 CCS. The electronic version of ISO/IEC 11179-1:2023 and ISO/IEC 11179-3:2023 can be downloaded from the ISO/IEC Information Technology Task Force (ITTF) web site. 1. Example in ISO/IEC 11179-3 ISO/IEC 11179-3 Annex B.4 shows two different models with different notations […]
-
Study report Part 2 Semantic model definition using ISO/IEC 19505 OMG UML
Views: 11 Study report Part 2 Semantic model definition using ISO/IEC 19505 OMG UML Table of Contents 1. Comments on Part 2 1.1. Draft 4.2.4.2 ACCOUNT SEGMENT 1.2. Attribute not fully listed in Table 3 1.3. The association representation in Table 4 does not follow the UML standard 1.4. Types of association in ISO/IEC 19505 1.5. Multiplicity in ISO/IEC 19505 1.6. Explanation of Multiplicity 2. UML diagram for Account Segment 3. Revised table definition for Account Segment 3.1. Proposed table format change for Part 2 4.1.2 4. ISO 11179:2023 and cardinality of attributes 5. ISO 11179 and cardinality of attributes Nobuyuki SAMBUICHI ISO/TC295 Audit data services/SG1 Semantic model Convener In […]
-
Setting Up Account Segments and Customized Account Segment Tables
Views: 10 Setting Up Account Segments and Customized Account Segment Tables Table of Contents 1. Proposal to Simplify Account Segment and Customized Segment for Ease of Understanding and Efficiency 2. Customized Account Segment and Customized Account Value 2.1. Overview 2.2. Corresponding_File is a predetermined account segment table 2.3. Explaining Corresponding_File as defined in ISO 21378:2019 2.4. Explaining Corresponding_File as a custom table 3. Field Values Used in ISO 21378:2019 Annex B 3.1. General 3.2. The First Set of Records for Account Number 2202 3.3. The Second Set of Records for Account Number 2202 3.4. The third row with Account Number 5502 4. How to setup BAS_Customized_ACC_Segment and BAS_Customized_ACC_Value Nobuyuki SAMBUICHI […]
-
Hierarchical Tidy Data: A Comprehensive Solution for Multi-layer Data Structures
Views: 15 Hierarchical Tidy Data: A Comprehensive Solution for Multi-layer Data Structures Table of Contents 1. Introduction 2. Original Journal Entry 3. Nearly Tidy Data 4. Hierarchical Tidy Data 5. Conclusion 6. Dialogues with ChatGPT Nobuyuki SAMBUICHI ISO/TC295 Audit data services/SG1 Semantic model Convener Following texts are produced by ChatGPT and edited by me. ChatGPT said “As an AI language model, I don’t have feelings or opinions. However, based on our interaction, I hope I’ve been able to provide clear and helpful responses to your questions. We’ve discussed several complex topics, including the principles of tidy data, the challenges of applying these principles to hierarchical data structures, and how hierarchical […]
-
XBRL-GL for Audit Data Collection
Views: 11 XBRL-GL for Audit data collection Table of Contents 1. Mapping between ADC, ADS and XBRL-GL 1.1. Mapping table 1.2. What is the European Triangular currency? 1.3. Bookkeepping in the subsidiary 2. Example instance document 2.1. Sample Journal entries file for XBRL Global Ledger Framework with annotations Version 1.0.91021.1 2.2. Sample Journal entries with timing differences file for XBRL Global Ledger Framework with annotations Version 1.0.91021.1 Nobuyuki SAMBUICHI ISO/TC295 Audit data services/SG1 Semantic model Convener The AICPA (American Institute of Certified Public Accountants) has established a way to connect specific fields in a standard table file with elements in an XML format called XBRL-GL. This is done to facilitate […]
-
Achieving Data Consistency and Clarity in the Table Structure
Views: 10 Achieving Data Consistency and Clarity in the Table Structure Table of Contents 1. Refine Trial Balance Table 2. Missing 4 currency codes 3. How to find out functional currency code? 4. 4 currency codes 5. No.2,3,5 were not improved with your solution Nobuyuki SAMBUICHI ISO/TC295 Audit data services/SG1 Semantic model Convener I recommend the result for 4 currency codes, but it is important in designing a semantic data model to understand what kind of results will be achieved if the model is designed on the premise of normalization. 1. Refine Trial Balance Table User Can you point out the problems with following table definition? PK means the primary […]
-
Shifting Towards Simplicity: Using Single Unique Identifiers in Our Data Model
Views: 9 Shifting Towards Simplicity: Using Single Unique Identifiers in Our Data Model Nobuyuki SAMBUICHI ISO/TC295 Audit data services/SG1 Semantic model Convener In our current table and field definitions, we have several tables that define their primary key as a combination of multiple fields. I recommend that we use a single primary key to define our object classes from our table definition. Primary keys and referenced identifiers (foreign keys) should be defined more simply and clearly in UML associations. User Provide some pros and cons of defining a primary key on multiple fields. Provide the advantage of designing the semantic model of object classes using a single unique identifier (primary […]