Skip to main content

Data Ledger

1. Introduction​

Overview​

The Data Ledger feature provides users with a detailed view of data points used in report generation. This feature enables users to view, search, filter, and sort through the data related to various entities across different dimensions.

View Design on Figma

2. Feature Overview​

The Data Ledger feature will display a comprehensive table view of entities with their associated data points. Users can:

  • Select specific dimensions to display for each entity (default: Corporate Structure)
  • View all entities with their corresponding data
  • Filter the list by industry, location, and risk type
  • Search for specific entities by name
  • Sort the data by any column in ascending or descending order

3. User Interface Requirements​

3.1 Layout​

The Data Ledger screen will consist of:

  • A header section containing the title
  • A filter and search section
  • A dimension selector
  • A data table displaying entities and their associated data
  • Pagination controls

3.2 Filter Section​

  • Industry filter (dropdown)
  • Location filter (dropdown)
  • Risk type filter (dropdown)
  • Filters should support multiple selections
  • All filters should have an “All” option
  • Applied filters should be visible with the option to remove them individually

3.3 Search Functionality​

  • A search field allowing users to search by entity name
  • Search should filter results in real-time as the user types
  • Search should work across all pages (if pagination is present)

3.4 Dimension Selector​

  • A select component allowing users to choose which dimensions to display
  • Selected dimensions determine which columns appear in the data table

3.5 Download CSV​

  • A button that allows users to download the data as a CSV file

3.6 Data Table​

  • Columns: Entity Name, Industry, Location, Risk Type, Report Date, and data points from user-selected dimensions (default: Corporate Structure dimensions)
  • Column headers should include sort indicators (arrows indicating sort direction)

3.7 Pagination​

  • Display 20 entities per page by default
  • Include controls to navigate to the previous/next page
  • Display the current page number and total pages

4. Functional Requirements​

4.1 Data Loading​

  • Data should load efficiently, with appropriate loading indicators
  • The initial load should display entities sorted by report date (newest first)

4.2 Filtering​

  • All filters (Industry, Location, Risk Type) should work in combination
  • Applying a filter should immediately update the displayed data

4.3 Searching​

  • Search functionality should search across entity names
  • Search should highlight matching text in the results when possible

4.4 Sorting​

  • Each column should be sortable by clicking on the column header
  • First click sorts ascending, second click sorts descending, third click removes sorting
  • The default sort is by Report Date (newest first)
  • Visual indicators should show which column is being sorted and in which direction
  • Only one column can be sorted at a time

4.5 Dimension Selection​

  • Changing selected dimensions should immediately update the table
  • Selected dimensions should persist if the user navigates away and returns
  • A minimum of one dimension must always be selected

5. User Stories​

  1. As a user, I want to see a list of all entities with their associated data so I can analyze the reports effectively.
  2. As a user, I want to filter entities by industry, location, and risk type so I can focus on specific segments.
  3. As a user, I want to search for a specific entity by name so I can quickly find relevant information.
  4. As a user, I want to sort data by any column in ascending or descending order so I can identify trends and outliers.
  5. As a user, I want to select which dimensions to display so I can customize my view based on my analysis needs.

6. Data Dimensions​

6.1 Corporate Structure & Operational Capability​

  • Active Directors
  • Number of employees

6.2 Financial Health​

  • Turnover
  • Cash and Cash Equivalents
  • Current Liabilities
  • Short Term Debt
  • Current Assets
  • Revenue
  • EBIT
  • Net Income
  • Interest Expense/Finance Cost
  • Long Term Debt
  • Total Assets
  • Current Investments
  • Inventories

6.3 Credit History​

  • CIBIL Hits
  • NCLT Hits
  • NCALT Hits
  • IBBI Hits
  • DRT Hits

6.4 Compliance Rigor​

GST Filings​

  • Ontime %age
  • Delayed %age
  • Default %age

EPFO Filings​

  • Ontime %age
  • Delayed %age
  • Default %age

MCA Filings​

  • Ontime %age
  • Delayed %age
  • Default %age

6.5 Litigation History​

  • Court Cases
  • Tax Litigations

6.6 Defaulter and Blacklist Mentions​

  • SEBI
  • SFIO
  • CCI
  • CBI Notices

6.7 Sanctions & PEP Mentions​

  • International Sanction (Canada Consolidated, Canada OSFI, Europe Consolidated, Switzerland Sanctions, UK Consolidated, UN Consolidated, US Consolidated, Worldbank Debarred)
  • PEP Dilisense

6.8 Promoter & Related Party Quality​

  • All litigations
  • SEBI
  • CBI Notice
  • CCI Record
  • CIBIL
  • International Sanction (Canada Consolidated, Canada OSFI, Europe Consolidated, Switzerland Sanctions, UK Consolidated, UN Consolidated, US Consolidated, Worldbank Debarred)
  • PEP Dilisense

6.9 Market Sentiment​

  • Adverse Media
  • NCDRC