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 |
