Platform Tools

Latest Version

Used Version

Description

License Type

​

​Metabase​

v0.40.4

v0.40.2

Metabase is an open-source business intelligence tool. It lets you ask questions about your data, and displays answers in formats that make sense, whether that's a bar graph or a detailed table.

​

​

​Druid

0.21.1

0.21.1

Apache Druid is a real-time analytics database designed for fast slice-and-dice analytics ("OLAP" queries) on large data sets. Druid is most often used as a database for powering use cases where real-time ingest, fast query performance, and high uptime is important. As such, Druid is commonly used for powering GUIs of analytical applications, or as a backend for highly concurrent APIs that need fast aggregations. Druid works best with event-oriented data.

​​Apache License 2.0

​

Confluent Kafka​

6.2.0

5.4.1

Apache Kafka is an open-sourced and community distributed event streaming platform capable of handling trillions of events a day.

​Community License

​

Postgresql​

13.4

9.6 and 10.6

PostgreSQL is a powerful, open-source object-relational database system with over 30 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance

​PostGres License​

​

Attribute

Description

version

string example: 1.0.0

Version of the Data Model Definition

id

string example: 51c9c03c-1607-4dd5-9e0e-93bbf860f6f7

System generated UUID of Line Item

eventId

string example: fecbbf1d-d6e3-4f24-9935-02c33b9248e0

Fiscal Event Reference Id

tenantId

string nullable: false example: pb

Tenant Id

government.id

string example: pb

government.name

string example: Punjab

department.id

string example: 5d664a9f-9367-458a-aa5f-07fb18b90adc

Unique system generated UUID

department.code

string example: DWSS

Unique department code

department.name

string example: Department of Water Supply & Sanitation

Name of the department

expenditure.id

string example: d334d99a-b5c1-426c-942b-f11b5b5454fe

Unique system generated UUID

expenditure.code

string example: JJM

Unique Expenditure code

expenditure.name

string example: Jal Jeevan Mission

Name of the Expenditure

expenditure.type

string

Type of the Expenditure Enum: Array [ 2 ]

project.id

string example: 6ab1b1d2-e224-46fa-b53b-ac83b3c7ce95

Unique system generated UUID

project.code

string example: PWT

Unique Project code

project.name

string example: Peepli Water Tank

Name of the Project

eventType

string nullable: false example: Appropriation

Captures the event type e.g Demand, Receipt, Bill, Payment

eventTime

integer($int64) example: 1628177497000

when the event occurred at source system level

referenceId

string example: 013e9c56-8207-4dac-9f4d-f1e20bd824e7

reference unique id(transaction id) of the caller system

parentEventId

string nullable: true example: 7d476bb0-bc9f-48e2-8ad4-5a4a36220779

If this is a follow up event then it will refer to the parent event using this reference id.

parentReferenceId

string nullable: true example: 77f23efe-879d-407b-8f23-7b8dd5b2ecb1

If this is a follow up event then it will refer to the parent event in source system using this reference id.

amount

number example: 10234.5

Transaction Amount

coa.id

string example: e9f940d4-69aa-4bbb-aa82-111b8948a6b6

Unique system generated UUID

coa.coaCode

string example: 1234-123-123-12-12-12

Chart of account concatenated string

coa.majorHead

string example: 1234

Major head code

coa.majorHeadName

string

Major head name

coa.majorHeadType

string example: Revenue

Major head code type

coa.subMajorHead

string example: 123

Sub-Major head code

coa.subMajorHeadName

string

Sub-Major head name

coa.minorHead

string example: 123

Minor head code

coa.minorHeadName

string

Minor head name

coa.subHead

string example: 12

Sub-Head code

coa.subHeadName

string

Sub-Head name

coa.groupHead

string example: 12

Group head code

coa.groupHeadName

string

Group head name

coa.objectHead

string example: 12

Object head code

coa.objectHeadName

string

Object head name

fromBillingPeriod

integer($int64) example: 1622907239000

Start date of the billing period for which transaction is applicable

toBillingPeriod

integer($int64) example: 1628177643000

Start date of the billing period for which transaction is applicable