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