Architecture

Fiscal Event services flatten each fiscal event line item and post them into Druid via the Kafka Druid connector. The raw events are stored in the fiscal events dataset in Druid. Metabase is used for visualisations.

The flattened fiscal event consists of the following attributes

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