Financial Data Modelling

Document Sample
Financial Data Modelling Powered By Docstoc
					Data Modelling for
Application
Integration
2005 DAMA International Australian Conference
Old Parliament House
Canberra, ACT
19 – 21 October 2005

Presented by David Wiebe
Principal Consultant, Allajaw Associates Pty Ltd
allajaw@bigpond.net.au
Presentation Points

 Understanding the communication
 Interface development methodology
 Leveraging your data models
 Information domains
 Building an XML schema specification
Integration – are you getting the
message?
   Applications need to talk to each other, but are they
    speaking the same language?
       are these ‘Obligation’ details really those ‘Entitlement’ details?
   Is the language used between applications unique to the
    systems involved?
       ‘Client’ information for our systems, ‘Customer’ details when
        dealing with them, and ‘Party’ particulars for that guy…
   Is the conversation consistent or does the structure
    change depending upon subject being discussed?
       a ‘Vendor’ looks like this, and a ‘Supplier’ look like that, and
        when you see a ‘Contact’, it will look like…
Getting Agreement
   Need to have a common understanding of what the
    information means
   Negotiate and agree on the information standards that
    will be adopted
   Helps to use industry standards
   Agreement on the exchange details, not the data storage
    schema
   Don’t start building until you get agreement
What do you need?
   Methodology
   Framework
   Models
   Common Vocabulary
   Data Modellers
   Requirement
Interface Message Data Modelling
Method Overview - Approach
   Using a message development lifecycle (MDLC) adopted
    for application integration message design.
   The MDLC adopts an “information centric’ view that
    requires identification and stabilisation of the information
    models. This stabilisation of the information models
    permits the other aspects of the integration to be
    adequately expressed, such as transformation rules.
   The MDLC described has been derived from industry
    standards for message development. Examples:
       HL7 Message Definition Framework for health section
       eBOM – electronic Business Oriented Methodology
       ISO 15022 Message Development methodology for financial
        sector
Interface Message Data Modelling
Method Overview – Data Models
    Different layers of data models are used to model the data needed
     in application integration.
    Data models are needed to ensure that all application integration
     interactions are built from the same consistent data model.
    Different layers of models shown below.

                                     Contextual Information Model
    Interface Models                                                             Storage Models

         Reference Information Model                         Enterprise Conceptual Data Model
                                                Vocabulary




          Domain Information Model                             Project Conceptual Data Model
                                                 Common




          Message Information Model                                 Logical Data Model

    Physical Hierarchical Information Model                         Physical Data Model
The Models
Contextual Information Model – information domains that identify
   boundaries between core data concepts
Enterprise Conceptual Data Model – business data design that integrates
   all perspectives of an enterprise’s information requirements without
   consideration of technology
Reference Information Model – a coherent, shared information model that
   is the source for data content in all interfaces
Project Conceptual Data Model – business data design aimed at a specific
   business perspective
Domain Information Model – information design for a particular area of
   expertise
Logical Data Model – data design for a particular data storage requirement
Message Information Model – data design for a particular information
   exchange
Physical Data Model – implementation schema for the database
Physical Hierarchical Information Model – implementation schema that
   supports the messages required in a particular information exchange
                                                                             * Zachman
                                                                             Framework
Interface Message Data Modelling
Method Overview – Aims & Steps
    Construct all application integration messages from one common
     model, the ECDM
    Utilise the common vocabulary that supports the ECDM
    Model all message logically, and signoff before constructing physical
     implementation
    Align to industry standards (eg. AS 4950 – Client Name and
     Address, XBRL – Business Reporting Language)

1.   Gather data requirements of existing interfaces
2.   Identify footprint of data on Reference Information Model, or ECDM
3.   Identify Domain Information Model (DIM) for integration
4.   Design messages from MIM based on DIM
5.   Construct XML Schema for messages
6.   Design translation of XML messages to system interfaces
Interface Message Data Modelling
Method – Roles and Responsibilities
   Business / System Analysts
        Gather elements of the interface and possible entities
        Identify data definitions and types aligning with the common vocabulary
        Review proposed message models
        Map elements to message models
   Interface Owner
        Compile interface elements across source and target systems
        Review proposed message models
        Confirm interface message headers
        Review all models
   Enterprise Data Owner
        Identify footprint of elements against enterprise data model, confirming common vocabulary
        Identify the Domain Information Model for release
        Identify candidate models for logical message design
        Create the Message Information Model
   Interface Technical Owner
        Create XML schema for core components
        Create XML schema for messages
Data Modelling Continues
   Data models are for data designs
   Designing structures for exchanging data requires the
    same disciplines as used in designing for data storage
   Data modelling puts rigor into data analysis and
    documentation, bringing with it a higher level of
    confidence of meeting the business expectations
   Data modeller, data analysts and data architects ensure
    the structures created are sound and the integrity is
    maintained
Leverage your existing models
   Time to reuse your models… again…
   Take stock of what you’ve got
   Both the database and the message are being modelled
    from the same conceptual data model
   Aligning the physical models to a single business model
    will ensure the information that passes through the
    exchange will have a data store to rest in
   Contribute to the enterprise models
  Business Party Type                                             Business Party Role Type                            Contact Subject                          BP Role Contact Event

                         belongs to             groups types through              makes contact concerning is valid for            covers                pertains to

      defines                                                     defines
                                 Valid Business Party Role                             BP Role Type Contact Subject                 BP Role Contact Event Subject


                                        takes on                                        participates as                                                          includes
        Business Party                                         Business Party Role                           BP Role Contact Participant

                               is parent in                                                                                                                   Contact Person Type
                          is child in                                          has                                                defines the association of
                                                                                         Business Party Contact Person

                                  Business Party Structure                                                            is identified as
                                                                                                    BP Role Id                       Canadian Retail Natural Gas
                                                                                                                                     Strategic Information Management
                                 BPId                                                                        External Contact Person Physical Table Design
                                                                                                                                     March 1995

Internal Organisation                                                       Employee                                 Landlord
                                                                                                                                                                   Location Class
              Person                    External Organization                 Company                        Manufacturer
                                                                                                                                 Location Type          groups types through
           accumulates                        accumulates
                                employs                                        Custormer                    Shipper                  belongs to classes through

           Person History                   Ext Org History                          Vendor                Dealer
                                                                                                                                                 Valid Location Type Class
                                                                        works through
           External Organization Employee Work Period                                         External Organization Employee                                                 receives
                                                                                                                                                                defines
                                                      may have           conducts business at
                    has                                                                                   Business Party Location                exists for
 Province                         Country
                                                                            may have                                                                                      Location
             is divided into                   Telephone                                                             may have
                                                                                                                                                                                may be in
                                                                                                                                                  Location Class Id
  has                                               contains                               is valid for
                             Municipality                               Address
                                                                                                               Company Facility                                     Material Location
  Street                                                   Address Id
                                                                                                                    Customer Location                             Storage Location
        is filled with                                                                     Postal Code
                            Civic Address                           Site Address
                                                                                                                       Dealer Location                          Service Truck

                                  Install Address                 Misc Address
                                                                                                                           Other Location             Construction Development Site
Take Stock
   The Physical Data Model – focused on the data
    requirement, making sure it was reliable, usable and the
    database provided optimal performance

   The Logical Data Model – designed and created to get
    an understanding of the nature, expected behaviour and
    the use of the data in relation to the specific application
    being delivered
                                                    Service Item Type Arrangement Type Rule
                                                    Arrangement Type
                                                    Party Role Type                                             Funds Management Conceptual Data Model
                                                    Product Type
                                                    Service Item SubType
                                                    Service Item Type
                                                                                                                                                    Service Item Type
                                                                                               Account Value Rule
                                                                                                                                                     Service Item Type
                                                                                                Value Type
                                                                                                Product Type                                         Description
                                                       Account Type
                                                                                                Party Role Type
                                                        Product Type                            Arrangement Type
                                                        Party Role Type                                                                           SIT Value Type
                                 Arrangement Type                                               Account Type
                                                        Arrangement Type                        Service Item SubType                               Value Type
Party Role Type                  Product Type                                                                                                      Service Item SubType         SIT SubSIT
                                                        Account Type                            Service Item Type
Party Role Type                  Party Role Type                                                                                                   Service Item Type             Service Item SubType
                                 Arrangement Type       Account Type Description                Debit Credit Ind                                                                 Service Item Type
Role Name                                               Geared Nongeared Ind                                                                       SIT Value Type Desc
                                                                                                Navigation Method
Description                                             Auto Setup Ind                                                                             Optional Manditory Ind        Source System
                                                                                                Override SIT Value Type Desc


                                                                                                   Value Type
                  Product Type                                                                      Value Type                                                                Service Item
                  Product Type                                                                                                                                                 Service Item Id
                                                                                                    Value Type Description
                                                                                                                                                                               Service Item SubType
                                                                                                                                        Value
                                                                                                                                                                               Service Item Type
                                                                                                                                         Value Id                              Security Short Name
                                                                                               Currency                                  Value Type                            Effective Date
                                                                                                                                         Service Item SubType                  Entry Date
                                                                                                Currency Code
                                                                                                                                         Service Item Type                     Workflow Status
                                                                                                Currency Description                                                           Trade Settlement Status
                                                                                                                                         Fee Algorithm Type
                Product                                                                                                                                                        Note
                                                                                                                                         Fee Profile Id
                  Product Id                           Account                                                                           Group Type                            Source System Txn Type
                                                        Account Id                                                                       Arrangement Component Id              Source System Txn Id
                  Product Type
                                                                                                                                         Arrangement Component Type            AIO Txn Id
                  Product Name                          Account Association ID                Account Value Entry
                                                                                                                                         Argument Type                         Sync Indicator
                                                        Arrangement Component Id              Account Id                                 Argument Id
                                 Arrangement            Arrangement Component Type            Value Id                                   Service Item Id
                                 Arrangement Id         Account Number                        Value Type                                 Originating Currency Code
                                                        Account Name                          Service Item SubType
Party Role                       PR Reln Type                                                                                            Base Currency Code
                                                        Product Type                          Service Item Type
                                 Party Role Id                                                                                           Processing Status                  Service Item Arrangement
Party Role Id                                           Party Role Type
                                 Party Role Type                                              Debit Credit Ind                           Amount
                                                        Arrangement Type                                                                                                    Service Item Id
Party Role Type                  Arrangement Type                                             Posted Date                                Quantity
                                                        Account Type                                                                                                        Arrangement Id
Party Id                         Product Type                                                 Account Value Entry Desc                   Price
                                                        Currency Code
Structured Name                  Product Id                                                   Posted Funds Clearance Status              Exchange Rate
                                                        As At Date
                                                                                                                                         Note
What else is in Stock
   The Conceptual Data Model – required to single out the
    key business terms regardless of what system they were
    in and establish consistent understanding. Leveraging
    designs for future projects

   The Contextual Information Model – the boundaries are
    drawn around distinct information domains. Each
    business entity exists in only one of these domains
Information Context
                     Tax Office Contextual Data Model
               Environment             Government                                                                                                                                         Legal Product




     Account                 Revenue                                                                     Tax Office                                                                                                                     Revenue Product
                                                                                                                                  Information
                                                                                                                                  Management


                                          IM Strategy, Policy            Data              Common Terms &         Document & Content            Records              Library & Information    Reporting             Intelligence
                                             & Standards              Management              Metadata               Management                Management                  Services           & Analytics


                                                 IM Policies               Contacts                Contacts               Contacts                  Contacts                  Contacts             Contacts              Contacts


                                                   Strategic              Policy &                Policy &                Policy &                  Policy &                  Policy &            Policy &              Policy &
                                                 Frameworks              Procedures              Procedures              Procedures                Procedures                Procedures          Procedures            Procedures

                                                 Information            Forms, Tools &          Forms, Tools &         Forms, Tools &            Forms, Tools &            Forms, Tools &       Forms, Tools &       Forms, Tools &
                                                  Standards                Methods                 Methods                Methods                   Methods                   Methods              Methods              Methods

                                                                         Reference               Reference               Reference                 Reference                 Reference            Reference            Reference
                                                                         Documents               Documents               Documents                 Documents                 Documents            Documents            Documents


                                                                           Projects                Projects                Projects                 Projects                   Projects            Projects              Projects




                                              Content Includes:        Content Includes:      Content Includes:        Content Includes:        Content Includes:        Content Includes:     Content Includes:    Content Includes:
                                            All IM-related Policies      Data Models            Common Bus         Intranet/Internet Content     Recordkeeping            Library Services            EIS                  Alerts
                                                  IM Strategic          Data Stewards            Language                    Email             Classifying Records       Library Catalogue    Reports Catalogue          Reports
                                                   Framework            Data Quality &          Taxonomies          Other Content Systems      Storage & Archiving       Libraries Network    Analytics Catalogue      Intel Model
                                                  Architecture             Integrity           Metadata Rules       Classifying Documents           Disposal             Research Support      Data Warehouse        Intel Templates
                                                   Standards                                                          Document Security                                 Reference Databases




      Risk                    Client                                                       Responsibility                                                                                                                                Admin Product




                  Case                   Channel                                                                                                                                                            Interaction
Information Context           Environment
                                                                                                                                                                                                                                            Government

                                                                                                                                                          influences /
                                                                                                                                                          is influenced by
                                                                                                                                                                                                                                             Parliament
         influences /          Community                                                                                                                                                                                                     Federal
         is influenced by      Reputation                                                                                                                                                                                                    State
                                                                                                                                   Revenue
                               Emerging Trends                                                                                                                                                                                               Local
                                                                Account
         may have /                                                                           is derived from /                     Operating Revenue                                                                 receives /
         relates to                                                                           effects                               Payments                                                                          reported to
                                                                 Debt
                                                                 Posting                                                            Collections                                                                    collects /                          reports to /
                                                                                                                                    Transfers                                                                      is collected by                     guides and funds


                                                                                       Interaction
                                                                                                                                                                 Channel
                      may initiate /                                                                                     occur through /
                      relates to
                                                                                        Contact                          is used for
                                                                                        Registration                                                              Electronic                          determine available /

                                                                                        Activity                                                                  Phone                               is used to interact w ith

                                                                                        Lodgment                                                                  Paper
                                                                     may effect /                                               results from /
                                                                                        Assessment                                                                Face to Face
                                                                     may consider                                               leads to
                                                                                        Payment


                                                                                                                                                      Administration Product                                                Tax Office
Client                                                                                                                                                                                                      maintain /
                                              Risk
                                                                                       may create /
                                                                                                                                                          Form                                              are used by      Tax Office People
                        may be related to /                                            may consider
                                                                                                                                                          Publication                                                        Tax Office Place
 Individual
                        may apply to          Corporate Risk                                                                                              System                                                             Enterprise Strategy & Reporting
 Organisation
                                              Compliance Risk Identification                                                                              Policy
 Intermediary


                                                                                      Case                                                                      may apply to /
                                                                                                                                                                is informed by
              may have /                                                                                             may lead to /
                                                                                                                                                                                         Revenue Product
              may relate to                                                            Compliance                    may be related to
                                                may refer to /
                                                                                       Administrative                                                                                                                             administers /
                                                resolves issues in
                                                                                                                                                                                          Tax                                     is administered by
                                                                                                                                                                                          Excise
                                                                                                                                                                                          Benefit
                                                                                                                                                                                          Super Surcharge
                                                                     Tax Office - Enterprise Contextual Data Model                                                                        Charge
                            Legal Product
                                                                     Level 1.0 - Business Concepts
                                                                     Prepared by Information Management
                            Legislation
                            Notice                                   April 2005
                            Advice                                   Version 1.2                                                           Responsibility
                            Court Ruling
                                                                                                                                                                             defines the terms of /
                                                                                                                                            Obligation
                                                                                                                                                                             is applicable to
         may have /                                                                                                                         Entitlement                                                                      monitors complaince of /
         relates to                                                                                                                         Right                                                                            is managed by
Contextual Modelling
   For application integration, it all starts here
   Contextual Information Modelling – Specifically:
      Information Domains – Fundamental groupings of data
      Other types are:
            Business Components – Provides views across the domains
            Information Flows – Business information being exchanged
   Application integration needs a consistent perspective in order to
    create the expectation of knowing how to deal with the information
    exchange
   Application integration expects standards to be used, like a standard
    for structuring the message payload
   Information Domains provide the perspective that is industry neutral
    but recognises common perspectives of data
   Information Domains, in the context of exchanging data, should be
    easily agreed upon…
Candidate Information Domains

    Location       Party         Interaction




     Event     Responsibility    Instrument




    Incident   Legal Product        Risk



                                    ‘The
    Account       Service
                                Organisation’
Information Domains
   Identify the high level scope applied to the information
    interoperability solution
   A grouping of intrinsically related information entities and
    attributes
   The boundaries are created in order to focus upon the
    content and behaviour of the information within the core
    business concept
   Information domains are not dependent upon a particular
    business perspective, thus being more stable
So how are the Information Domains in the
Contextual Information Model going to help
integrate applications?
    Reference the Enterprise Conceptual Data Model
                                                                                                                                                                                                                                              takes on
                                                                                                                                                                                             Agency Org Unit                                                                              Agency Org Unit Role
                    holds known /                                                          holds
Environment                                 Risk                                                                                        has                                                                                         is arranged into
                    can be seen in
                                                                                                                                                                                                     is made up of /                                            Agency
                                                                                                                                                                     may be responsible for          can be a member of
                                                   can be assigned to
   can be affected by /                                                                                                                                                                                                        employs
   considers                                                             Agency Org Unit Profile                        Agency Org Unit Interaction

                                                                                                                                                                                      may be actioning                                are assigned to /                      identifies
                   is monitored through /                                                                                                         can be                                                       Agency Person
                   assists in measuring                                                                         delivers                                                                                                              may require
                                                                                Channel


               is classified with                                                                                                                                 Interaction                                                                                                    can participate in /
                                            Profile          can be assigned to                    Interaction Profile                   holds
                                                                                                                                                                                                                                                          creates                may require the use of

                                                                                      may result in                                                                                                                       will be met through /
                                                                                                                                                                                                                          can affect
                                                can be assigned to                                                                                                                                                                                            Document
                                                                                                                                                 can create
                                                                                                                   Business Event
Government
                                                                                                                                                                                can be
                       Profile Value                                                                                                                                                                               Payment
                                                                                                                                                             can be
                                                                              holds                              has
                                                          Client Profile                                                             Client Interaction                           Case Interaction                Document Lodgment
   receives /                                                                                                                                                                                                                                                       holds
   is distributed to                                                                                                                                                                                               POWA
                                                                                                                                                  Client Case                                 has
                                                                                                                     may participate in                                may refer to                               Activity

                 is consolidated from           Account             has a single view of               Client                                                                              Case
Revenue                                                                                                                               may be primary entity in /                                                                                                    Reported Value
                                                                                                                                      is related to                                                      categorises
                                                                                                                                                                                                                            Case Classification
                                                                                                    takes on                                                                                                                                                                      makes reference to /
   is structured using /                               is structured through                                                                                                                           can refer to /
                                                                                                                                                                            records                                                                                               can appear in
   has specific perspective on                                                                                                                            Decision                                     may be referenced in
                                                                                                                                     holds
                                                                                                    Client Role
                                        Running Balance Account
                                                                                                                                                 Responsibility
                                                                                                                                                                                                                                                                                                       holds
                                                                                                                 may lead to                                                                         may be based upon /
                                                       consists of
                                                                                                                                                                                                     apply to


General Ledger                                                                                                                                                                                                            Legal Product                                                   Admin Product
                                         Revenue Product Account                                                                                                         dictates the terms and conditions of                                     makes reference to /
                                                                                                                                                                                                                                                  can appear on
                                                                                                                       Obligation
                                                         receives                                                                                           dictates the terms and conditions of
                                                                                                                       Entitlement                                                                         may create /
                                                                                                                                                                                                           refers to
                                                                                                                        Right                                                                                                                     Court Ruling                                       Form
          is applied to /
          is recorded against                Account Posting                                                           Arrangement                         is made up of                                                                          Legislation                                    Business System

                                                                                                                                                                                         Revenue Product
                                                                                                                                                                                                                                                   identifies required /
                                                                                                                                       Responsibility Component                                                                                    may be applicable to
                                                                                              identifies the type of /
              IM Whole of Government Agency                                                   collects postings applicable to
                                                                                                                                                                                                                                                                            is supported through /
              Enterprise Conceptual Data Model
                                                                                                                                                                                                                                                                            relate to

                                                                                                                                                    Revenue Collection Product                             Revenue Payment Product
Populate the Project Conceptual Data Model
Only Include Attributes for Integration and call it the RIM
1st Wave – Selected Subtype Resolution
Creation of the Domain Information Model
2nd Wave – Classification Removal
DIM Relevant Attribute Concentration
3rd Wave – Transform DIM into MIM
                               IncidentNote
                                                              Incident
                                                               IncidentId
                                NoteId
                                                                  ClientId (FK)
                               IncidentId (FK)                    AgencyOrgUnitID (FK)
                               NoteTitle                          IncidentTypeCode                                                                                                Agency Org Unit Interaction
                               NoteText                           IncidentProductCode                                                                                              AgencyOrgUnitID (FK)
                                                                  IncidentTypeSubCode                                                                                              InteractionId (FK)
                                                                                                 Interaction Relationship                                                          InteractionType (FK)
                                                                                                  InteractionRelationshipTypeCode                                                  AssignedAgencyOrgUnitId (FK)
          Message Model Creation                                                                  PrimaryInteractionId (FK)
          Third Drill Down - Transformation                                                       PrimaryInteractionType (FK)
                                                                                                  RelatedInteractionId (FK)                                Interaction
          Message Information Model / Logical Data Model                                          RelatedInteractionType (FK)
                                                                                                                                                            InteractionId
                                                                                                                                                            InteractionType
                          Client Identifier                                                                                                                 InteractionDate
                           ClientId (FK)                                                                                                                    ContactSubType
                           IdentifierType                                                                                                                   IVROption
                           IdentifierStatus                                               Channel                                                           ContactName
                           IdentifierStatusDate                                            ChannelTypeCode                                                  ReceiptId
                                                                                           ChannelCode                                                      ReceiptIssueDate
                            IdentifierValue
                                                                                           ChannelName                                                      ContactType
                                                                                                                                                            IncidentId (FK)
                                                                                                                                                            ChannelTypeCode (FK)
                                                      Client                                                                                                ChannelCode (FK)
                                                       ClientId                                                                                             TaxOfficePersonId
                                                                                                                                                            CorrespondenceWorkingStatus
                                                      ClientTypeCode
                                                      ClientSubTypeCode
                                                      NonResidentIndicator
                                                                                             InteractionNote                                                                                        Agency Org Unit
   NonIndividual
                                                                                              NoteId                                                                                                 AgencyOrgUnitID
    ClientId (FK)
                                                                                              InteractionId (FK)                                                                                     AgencyOrgUnitTypeCode
                                                                                              InteractionType (FK)                                                                                   AgencyOrgUnitCode
                                                                                              NoteTitle                                                                                              AgencyOrgUnitName
    Individual                                                                                NoteText
     ClientId (FK)
     BirthDate                                                                                                         Client Interaction                 Interaction Document
     CurrentJobTitle                                                                                                    ClientId (FK)                      InteractionId (FK)
                                                                                                                                                           InteractionType (FK)
                                                                                                                       InteractionId (FK)                  DocumentID (FK)                           Agency Org Unit Location
                                                                                                                       InteractionType (FK)
                                 Client Name                                                                                                               PrimaryDocumentIndicator                   AgencyOrgUnitID (FK)
                                                                                                                       AssignedATOOrgUnitId (FK)
                                                                                                                                                                                                      LocationName
                                  ClientId (FK)                                   Client Address
                                  ClientRoleId (FK)                                ClientId (FK)
                                  NameId (FK)                                      AddressId (FK)
                                                                                   AddressUsageTypeCode
                                                                                   AddressTypeCode (FK)
                                                                                   ClientRoleId (FK)

                                                                                                                                                                                  Document
                                                                                                           SemiStructuredAddress                                                   DocumentID
              IndividualName
               NameId                                                                                       AddressId                       Form                                  DocumentType
                                                                                                            AddressTypeCode                  FormId                               DocumentCategoryType
               NameType                           Client Role                                                                                                                     DocumentIdentiferNumber
               NameValue                                                                                       AddressLine1                 AgencyFormId
                                                   ClientRoleId                                                AddressLine2                                                       ContentManagerEntryDatetime
               ClientTypeCode                                                                                                               AgencyFormDocumentId                  FileName
               Title                              ClientId (FK)                                                LocalityName                 FormTypeCode
                                                                                                               StateCode                                                          MimeType
               GivenName                          ClientRoleTypeCode                                                                        ApplicationFormType                   DocumentPageCount
               FamilyName                                                                                      CountryName
                                                                                                               Postcode                                                           EndorserNumber
               Initial                                                                                                                                                            MailReceiptDate
                                                                                                                                                                                  FileAttachment
                                                                                                                                            BusinessSystem                        FileAttachmentId
                                                                                                                                                                                  ApplicationCode (FK)
NonIndividualName                                                                                      TelecommunicationAddress              ApplicationCode                      FormId (FK)
 NameId                                                                                                 AddressId                            ApplicationName                      InteractionType (FK)
                                          Responsibility                                                                                                                          InteractionId (FK)
 ExternalOrganisationName                                                                               AddressTypeCode                      ApplicationDescription
                                           ResponsibilityId                                                                                  ImageSourceName
 OrganisationalUnitName                    ClientRoleId (FK)                                            TelephonePrefix
 NameType                                  RevenueProductCode (FK)                                      TelephoneNumber
 NameValue
 ClientTypeCode                           ResponsibilityTypeCode
                                          ResponsibilityStatusTypeCode                                                                                 Document Revenue Product                                            Document Reported Value
                                                                                               Revenue Product                                          DocumentID (FK)                                                     DocumentID (FK)
                                                                                                                                                        RevenueProductCode (FK)                                             ReportedValueType
                                                                                                RevenueProductCode                                      DocumentRevenueProductUsageType
                                                                                                                                                                                                                            ReportedValue
                                                                                                RevenueProductName                                                                                                          SectionName
                                                                                                RevenueProductTypeCode
Almost there…
   How long did that really take…
   Message Information Model is still in a network form
   Style for representing repeating groups will be influenced
    by the modelling tool
   Next step is to create the Physical Hierarchical
    Information Model – the schema for the XML structure,
    the XSD
Integration Message Structure
   Create a standard for the order of the content within the
    information domain to appear in the message structure
   The exchange of information is an action – a request, or
    an expectation for information to be supplied
   Contextually, it is an Interaction, the Information
    Domain… my logical choice for the top of the message
    structure

   Lets focus on finishing the example…
Closer look at the Message Information Model                  Incident
                               IncidentNote                    IncidentId
                                NoteId
                                                                  ClientId (FK)
                               IncidentId (FK)                    AgencyOrgUnitID (FK)
                               NoteTitle                          IncidentTypeCode                                                                                                Agency Org Unit Interaction
                               NoteText                           IncidentProductCode                                                                                              AgencyOrgUnitID (FK)
                                                                  IncidentTypeSubCode                                                                                              InteractionId (FK)
                                                                                                 Interaction Relationship                                                          InteractionType (FK)
                                                                                                  InteractionRelationshipTypeCode                                                  AssignedAgencyOrgUnitId (FK)
          Message Model Creation                                                                  PrimaryInteractionId (FK)
          Third Drill Down - Transformation                                                       PrimaryInteractionType (FK)
                                                                                                  RelatedInteractionId (FK)                                Interaction
          Message Information Model / Logical Data Model                                          RelatedInteractionType (FK)
                                                                                                                                                            InteractionId
                                                                                                                                                            InteractionType
                          Client Identifier                                                                                                                 InteractionDate
                           ClientId (FK)                                                                                                                    ContactSubType
                           IdentifierType                                                                                                                   IVROption
                           IdentifierStatus                                               Channel                                                           ContactName
                           IdentifierStatusDate                                            ChannelTypeCode                                                  ReceiptId
                                                                                           ChannelCode                                                      ReceiptIssueDate
                            IdentifierValue
                                                                                           ChannelName                                                      ContactType
                                                                                                                                                            IncidentId (FK)
                                                                                                                                                            ChannelTypeCode (FK)
                                                      Client                                                                                                ChannelCode (FK)
                                                       ClientId                                                                                             TaxOfficePersonId
                                                                                                                                                            CorrespondenceWorkingStatus
                                                      ClientTypeCode
                                                      ClientSubTypeCode
                                                      NonResidentIndicator
                                                                                             InteractionNote                                                                                        Agency Org Unit
   NonIndividual
                                                                                              NoteId                                                                                                 AgencyOrgUnitID
    ClientId (FK)
                                                                                              InteractionId (FK)                                                                                     AgencyOrgUnitTypeCode
                                                                                              InteractionType (FK)                                                                                   AgencyOrgUnitCode
                                                                                              NoteTitle                                                                                              AgencyOrgUnitName
    Individual                                                                                NoteText
     ClientId (FK)
     BirthDate                                                                                                         Client Interaction                 Interaction Document
     CurrentJobTitle                                                                                                    ClientId (FK)                      InteractionId (FK)
                                                                                                                                                           InteractionType (FK)
                                                                                                                       InteractionId (FK)                  DocumentID (FK)                           Agency Org Unit Location
                                                                                                                       InteractionType (FK)
                                 Client Name                                                                                                               PrimaryDocumentIndicator                   AgencyOrgUnitID (FK)
                                                                                                                       AssignedATOOrgUnitId (FK)
                                                                                                                                                                                                      LocationName
                                  ClientId (FK)                                   Client Address
                                  ClientRoleId (FK)                                ClientId (FK)
                                  NameId (FK)                                      AddressId (FK)
                                                                                   AddressUsageTypeCode
                                                                                   AddressTypeCode (FK)
                                                                                   ClientRoleId (FK)

                                                                                                                                                                                  Document
                                                                                                           SemiStructuredAddress                                                   DocumentID
              IndividualName
               NameId                                                                                       AddressId                       Form                                  DocumentType
                                                                                                            AddressTypeCode                  FormId                               DocumentCategoryType
               NameType                           Client Role                                                                                                                     DocumentIdentiferNumber
               NameValue                                                                                       AddressLine1                 AgencyFormId
                                                   ClientRoleId                                                AddressLine2                                                       ContentManagerEntryDatetime
               ClientTypeCode                                                                                                               AgencyFormDocumentId                  FileName
               Title                              ClientId (FK)                                                LocalityName                 FormTypeCode
                                                                                                               StateCode                                                          MimeType
               GivenName                          ClientRoleTypeCode                                                                        ApplicationFormType                   DocumentPageCount
               FamilyName                                                                                      CountryName
                                                                                                               Postcode                                                           EndorserNumber
               Initial                                                                                                                                                            MailReceiptDate
                                                                                                                                                                                  FileAttachment
                                                                                                                                            BusinessSystem                        FileAttachmentId
                                                                                                                                                                                  ApplicationCode (FK)
NonIndividualName                                                                                      TelecommunicationAddress              ApplicationCode                      FormId (FK)
 NameId                                                                                                 AddressId                            ApplicationName                      InteractionType (FK)
                                          Responsibility                                                                                                                          InteractionId (FK)
 ExternalOrganisationName                                                                               AddressTypeCode                      ApplicationDescription
                                           ResponsibilityId                                                                                  ImageSourceName
 OrganisationalUnitName                    ClientRoleId (FK)                                            TelephonePrefix
 NameType                                  RevenueProductCode (FK)                                      TelephoneNumber
 NameValue
 ClientTypeCode                           ResponsibilityTypeCode
                                          ResponsibilityStatusTypeCode                                                                                 Document Revenue Product                                            Document Reported Value
                                                                                               Revenue Product                                          DocumentID (FK)                                                     DocumentID (FK)
                                                                                                                                                        RevenueProductCode (FK)                                             ReportedValueType
                                                                                                RevenueProductCode                                      DocumentRevenueProductUsageType
                                                                                                                                                                                                                            ReportedValue
                                                                                                RevenueProductName                                                                                                          SectionName
                                                                                                RevenueProductTypeCode
      Every Interaction comes over a Channel
                               InteractionRelationship
                                InteractionRelationshipTypeCode
                                RelatedReceiptId

Interaction                      InteractionNote

 InteractionId                    NoteTitle
 InteractionType                  NoteText
 InteractionDate
 ReceiptId
 ReceiptIssueDate              Document
 CorrespondenceWorkingStatus                                      DocumentRevenueProduct
 ContactSubType                 DocumentID
 IVROption                      DocumentType                      DocumentRevenueProductUsageType
 ContactName                    DocumentCategoryType              RevenueProductCode
 ContactType                    DocumentIdentifierNumber
                                ContentManagerEntryDatetime
                                FileName
                                MimeType
                                DocumentPageCount
                                ImageSourceName
                                EndorserNumber
                                MailReceiptDate                    DocumentReportedValue
                                AgencyFormId
                                AgencyFormDocumentId                ReportedValueType
 Channel                        ApplicationFormType                 ReportedValue
                                FileAttachment                      SectionName
  ChannelTypeCode               FileAttachmentId
  ChannelCode                   PrimaryDocumentIndicator
  ChannelName
     Client and its Location
                        ClientType              Individual

                         ClientTypeCode          BirthDate
                         ClientSubTypeCode       CurrentJobTitle

                        ClientIdentifier
                                                IndividualName
                         IdentifierType
                         IdentifierValue         Title
                                                 GivenName
                        ClientName               FamilyName
                                                 Initial
                         NameType
Client
                                                NonIndividualName
 ClientId
 NonResidentIndicator                            ExternalOrganisationName
                                                 OrganisationalUnitName


                                                SemiStructuredAddress

                                                 AddressLine1
                        ClientRole               AddressLine2
                                                 LocalityName
                         ClientRoleTypeCode      StateCode
Location                                         CountryName
                                                 Postcode
                        LocationAddress
  LocationId
                         AddressUsageTypeCode   TelecommunicationAddress
                         AddressTypeCode
                                                TelephonePrefix
                                                TelephoneNumber
Couple of others

        Incident

         IncidentId              IndicidentNote
         IncidentTypeSubCode
         IncidentTypeCode         NoteTitle
         IncidentProductCode      NoteText



        AgencyOrgUnit
                                 AgencyOrgUnitLocation
         AgencyOrgUnitTypeCode
         AgencyOrgUnitCode        LocationName



        AdminProduct             System

        AdminProductTypeCode     ScanBatchId
        AdminProductName         DocumentLocationNumber
                                                            InteractionRelationship

                                                            InteractionRelationshipTypeCode
                                                            RelatedReceiptId

                              Interaction                   InteractionNote


The Physical Hierarchical     InteractionId
                              InteractionType
                              InteractionDate
                                                            NoteTitle
                                                            NoteText

                              ReceiptId
Information Model             ReceiptIssueDate
                              CorrespondenceWorkingStatus
                                                            Document

                                                            DocumentID                        DocumentRevenueProduct
                              ContactSubType                DocumentType
                              IVROption                                                       DocumentRevenueProductUsageType
                                                            DocumentCategoryType
                              ContactName                                                     RevenueProductCode
                                                            DocumentIdentifierNumber
                              ContactType                   ContentManagerEntryDatetime
                                                            FileName
                                                            MimeType
                                                            DocumentPageCount
                                                            ImageSourceName
                                                            EndorserNumber
                                                            MailReceiptDate                   DocumentReportedValue
                                                            AgencyFormId                      ReportedValueType
                              Channel                       AgencyFormDocumentId              ReportedValue
                                                            ApplicationFormType               SectionName
                              ChannelTypeCode               FileAttachment
                              ChannelCode                   FileAttachmentId
                              ChannelName                   PrimaryDocumentIndicator


                                                            ClientType                        Individual

                                                            ClientTypeCode                    BirthDate
                                                            ClientSubTypeCode                 CurrentJobTitle

                                                            ClientIdentifier
                                                                                              IndividualName
                                                            IdentifierType
                                                            IdentifierValue                   Title
                                                                                              GivenName
                                                            ClientName                        FamilyName
                                                                                              Initial
                                                            NameType
                              Client
                                                                                              NonIndividualName
                              ClientId
        InformationExchange   NonResidentIndicator                                            ExternalOrganisationName
                                                                                              OrganisationalUnitName


                                                                                              SemiStructuredAddress

                                                                                              AddressLine1
                                                            ClientRole                        AddressLine2
                                                                                              LocalityName
                                                            ClientRoleTypeCode                StateCode
                                                                                              CountryName
                              Location
                                                                                              Postcode
                                                            LocationAddress
                               LocationId
                                                             AddressUsageTypeCode             TelecommunicationAddress
                                                             AddressTypeCode
                                                                                              TelephonePrefix
                              Incident                                                        TelephoneNumber

                              IncidentId                    IndicidentNote
                              IncidentTypeSubCode
                              IncidentTypeCode              NoteTitle
                              IncidentProductCode           NoteText



                              AgencyOrgUnit
                                                            AgencyOrgUnitLocation
                              AgencyOrgUnitTypeCode
                              AgencyOrgUnitCode             LocationName



                              AdminProduct                  System
                              AdminProductTypeCode          ScanBatchId
                              AdminProductName              DocumentLocationNumber
Goals to Achieve
   Reuse patterns for assembling information to exchange
   Communicate with exchange partners with a common
    format and vocabulary
   Leverage the current understanding of the enterprise
    information
   Educate developers and business analysts in the
    information exchange standards
Thank you for your time
   Questions

   Comments


David Wiebe
allajaw@bigpond.net.au
0439 023 570

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:46
posted:2/4/2011
language:English
pages:36
Description: Financial Data Modelling document sample