Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
PUT pt-national-dashboard/_mapping/nss
{
  "properties": {
    "ulb": {
      "type": "text",
      "fields": {
        "keyword": {
          "type": "keyword",
          "ignore_above": 256
        }
      }
    },
    "state": {
      "type": "text",
      "fields": {
        "keyword": {
          "type": "keyword",
          "ignore_above": 256
        }
      }
    },
    "ward": {
      "type": "text",
      "fields": {
        "keyword": {
          "type": "keyword",
          "ignore_above": 256
        }
      }
    },
    "region": {
      "type": "text",
      "fields": {
        "keyword": {
          "type": "keyword",
          "ignore_above": 256
        }
      }
    },
    "transactionsForUsageCategory": {
      "type": "long"
    },
    "todaysTotalApplications": {
      "type": "long"
    },
    "todaysClosedApplications": {
      "type": "long"
    },
    "assessedPropertiesForUsageCategory": {
      "type": "long"
    },
    "date": {
      "type": "date",
      "format": "dd-MM-yyyy HH:mm:ss||dd-MM-yyyy||epoch_millis||dd-MM-yyyy'T'HH:mm:ss.SSSZ"
    },
    "propertiesRegisteredForFinancialYear": {
      "type": "long"
    },
    "financialYear": {
      "type": "text",
      "fields": {
        "keyword": {
          "type": "keyword",
          "ignore_above": 256
        }
      }
    },
    "usageCategory": {
      "type": "text",
      "fields": {
        "keyword": {
          "type": "keyword",
          "ignore_above": 256
        }
      }
    },
    "todaysCollectionForUsageCategory": {
      "type": "long"
    },
    "propertyTaxForUsageCategory": {
      "type": "long"
    },
    "cessForUsageCategory": {
      "type": "long"
    },
    "rebateForUsageCategory": {
      "type": "long"
    },
    "penaltyForUsageCategory": {
      "type": "long"
    },
    "interestForUsageCategory": {
      "type": "long"
    },
	 "assessments": {
      "type": "long"
    }
  }
}

The following table that describes the properties mentioned above:

Attributes

Definition

Breakup

state

It represents the state name.

for ex. Punjab

Nil

ulb

It represents the ulb name of state .

for ex. for state Punjab, ulb can be "pb.amritsar", "pb.longowal" etc.

Nil

ward

It represents the ward name of particular ulb of particular state.

for ex. for ulb "pb.amritsar", ward name can we “Ram Nagar”, “Ajith Nagar” etc.

Nil

usageCategory

It represents the category like “RESIDENCIAL”, INDUSTRIAL”, “COMMERCIAL” etc.

Nil

transactionsForUsageCategory

It represents total transactions based on the usageCategory on given date.

Breakup by usageCategory(RESIDENCIAL, INDUSTRIAL,COMMERCIAL etc. )

assessedPropertiesForUsageCategory

It represents total properties assessed based on the usageCategory on given date.

Breakup by usageCategory(RESIDENCIAL, INDUSTRIAL,COMMERCIAL etc. )

todaysCollectionForUsageCategory

It represents the aggregation of fields property tax, cess, penalty, interest, rebate(should be nagative number) for the given date based on the usageCategory.

Breakup by usageCategory(RESIDENCIAL, INDUSTRIAL,COMMERCIAL etc. )

propertyTaxForUsageCategory

It represents the collection done as part of property tax for given date based on the usageCategory.

Breakup by usageCategory(RESIDENCIAL, INDUSTRIAL,COMMERCIAL etc. )

cessForUsageCategory

It represents the collection done as part of cess for given date based on the usageCategory.

Breakup by usageCategory(RESIDENCIAL, INDUSTRIAL,COMMERCIAL etc. )

rebateForUsageCategory

It represents the rebate given based on the usageCategory.

Breakup by usageCategory(RESIDENCIAL, INDUSTRIAL,COMMERCIAL etc. )

penaltyForUsageCategory

It represents the collection done as part of panalty for given date based on the usageCategory.

Breakup by usageCategory(RESIDENCIAL, INDUSTRIAL,COMMERCIAL etc. )

interestForUsageCategory

It represents the collection done as part of interest for given date based on the usageCategory.

Breakup by usageCategory(RESIDENCIAL, INDUSTRIAL,COMMERCIAL etc. )

assessments

It represents number of assessments done.

Nil

todaysTotalApplications

It represents number of applications created as part of property tax on given date

Nil

todaysClosedApplications

It represents number of closed applications as part of property tax on given date.

Nil

date

It represents date for which data is ingesting

Nil

financialYear

it represents financial year which which data is inserting.

Nil

propertiesRegisteredForFinancialYear

It represents number of properties registered in the system for the given financial year.

Breakup by financialYear(“2021-22”, “2022-23” etc.)