Please enable JavaScript.

Coggle requires JavaScript to display documents.

Hookit Data Integrity (Long-Term Solutions (Wishlist (Brian Duarte - To be…

- - - - Triggers on Tables
      - Logging
      - IDENTIFY SOURCES OF RECORD
      - Additional Columns (CreatedDate,LastModifiedDate,LastModifiedBy)
      - Documentation of SportsRadar
      - Documentation of KPMG Football Benchmark
      - Notifications/Alerts
- - - - TEAMS - InfluenceNetwork.dbo.SportOrganizations
      - OTHER
        
        InfluenceNetwork.dbo.SportRadarFiles
        
        InfluenceNetwork.dbo.SportRadarMissingEntities
        
        HookitIndex.dbo.SocialPosts
        
        HookitIndex.dbo.SocialPostContent
        
        InfluenceNetwork.dbo.SportOrganizationTypes
      - LEAGUES - InfluenceNetwork.dbo.SportOrganizationsHierarchy
      - PLAYERS/ATHLETES - Core.dbo.Members WHERE (CAREERLEVEL >= 3 (PROS!) AND TYPE = 1) (ATHLETE) OR TYPE > 1
      - SOCIAL MEDIA HANDLES - Core.dbo.ConnectedNetworks
      - TEAM ROSTERS - InfluenceNetwork.dbo.mapMembers2SportOrganizations
    - - InfluenceNetwork.dbo.PopulateHandleVerification.proc.sql
- - - - How do we maintain social media handles? (dbo.ConnectedNetworks)
      - How do we know when a Social Media Handle is changed (accidentally or not)?
      - How do we import/ingest social media handles we don't have (without adding duplicates)?
      - How do we import social media handles (via Automation) without adding duplicates?
      - How are Social Media Handles VERIFIED that they are correct?
    - - What are all the leagues in the system?
      - How is league information currently entered into the system?
      - How is league information modified in the system?
      - How are league hierarchies entered into the system?
      - How are league hierarchies maintained in the system, specifically when there is a change?
    - - How are rosters in the system setup (created/inserted) into the system?
      - How are rosters in the system updated? Deleted?
      - How are rosters in the system "VERIFIED" that they are correct?