Versions Compared

Key

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

...

Code Block
PUT mcollect-national-dashboard/_mapping/nss
{
  "properties": {
    "todaysCollectionForCategory": {
      "type": "long"
    },
    "todaysCollectionForPaymentMode": {
      "type": "long"
    },
    "todaysCollectionForStatus": {
      "type": "long"
    },
    "paymentMode": {
      "type": "text",
      "fields": {
        "keyword": {
          "type": "keyword",
          "ignore_above": 256
        }
      }
    },
    "status": {
      "type": "text",
      "fields": {
        "keyword": {
          "type": "keyword",
          "ignore_above": 256
        }
      }
    },
    "category": {
      "type": "text",
      "fields": {
        "keyword": {
          "type": "keyword",
          "ignore_above": 256
        }
      }
    },
    "challanStatus": {
      "type": "text",
      "fields": {
        "keyword": {
          "type": "keyword",
          "ignore_above": 256
        }
      }
    },
    "numberOfReceiptsForStatus": {
      "type": "long"
    },
    "numberOfReceiptsForPaymentMode": {
      "type": "long"
    },
    "numberOfReceiptsForCategory": {
      "type": "long"
    },
    "numberOfChallansForChallanStatus": {
      "type": "long"
    },
    "numberOfChallansForCategory": {
      "type": "long"
    },
    "ward": {
      "type": "text",
      "fields": {
        "keyword": {
          "type": "keyword",
          "ignore_above": 256
        }
      }
    },
    "ulb": {
      "type": "text",
      "fields": {
        "keyword": {
          "type": "keyword",
          "ignore_above": 256
        }
      }
    },
    "region": {
      "type": "text",
      "fields": {
        "keyword": {
          "type": "keyword",
          "ignore_above": 256
        }
      }
    },
    "state": {
      "type": "text",
      "fields": {
        "keyword": {
          "type": "keyword",
          "ignore_above": 256
        }
      }
    },
    "date": {
      "type": "date",
      "format": "dd-MM-yyyy HH:mm:ss||dd-MM-yyyy||epoch_millis||dd-MM-yyyy'T'HH:mm:ss.SSSZ"
    }
  }
}

The following is the table that describes the properties mentioned above:

Attributes

Defintion

Breakup

ulb

The district or region for which the data is ingested.

Nil

state

The ULB name for which the data is ingested.

Nil

ward

The ward for which the data is ingested.

Nil

transactions

Number of transactions related to WS/SW module on a given date

Nil

connectionsCreated

Number of connections related to WS/SW module on a given date.

Breakup by channel type(Counter, ONLINE, CSC, SYSTEM) and connection type(WATER.METERED, WATER.NONMETERED, SEWERAGE) has to be provided

todaysCollection

Total collection related to WS/SW module on a given date

Breakup by usage type(Domestic, Commercial, Institutional, Domestic SLC, Domestic Exempted,Commercial Motor,etc), payment channel type(System, Paytm, Field, RazorPay, PayU, BBPS, POS, Sewakendra, Freecharge) and tax head(INTEREST,LATE.CHARGES, ADVANCE, CURRENT.CHARGES, ARREAR.CHARGES) has to be provided

waterConnections

new connections created on the given date

Breakup by meter type(METERED, NON.METERED), usage(Domestic, Commercial, Residential, Institutional, Domestic Exempted) and channel(Counter, ONLINE, CSC, SYSTEM)

sewerageConnections

new sewreage connections created on the given date

Breakup by usage(Domestic, Commercial, Residential, Institutional, Domestic Exempted) and channel(ONLINE, CSC, SYSTEM)

pendingConnections

pending connections on the given date

Breakup by duration(0to3Days, 3to7Days, 7to15Days, MoreThan15Days)

slaCompliance

Percentage of complaints that are resolved within SLA till the given date.

Nil

todaysTotalApplications

# of Applications created on the given date

Nil

todaysClosedApplications

# of Applications closed on the given date

Nil

todaysCompletedApplicationsWithinSLA

# of Applications closed on the given date within SLA

Nil

 

Attributes

Definition

Breakup

ulb

The district or region for which the data is ingested.

Nil

state

The ULB name for which the data is ingested.

Nil

ward

The ward for which the data is ingested.

Nil

transactions

Number of transactions related to WS/SW module on a given date

Nil

connectionsCreated

Number of connections related to WS/SW module on a given date.

Breakup by channel type(Counter, ONLINE, CSC, SYSTEM) and connection type(WATER.METERED, WATER.NONMETERED, SEWERAGE) has to be provided

todaysCollection

Total collection related to WS/SW module on a given date

Breakup by usage type(Domestic, Commercial, Institutional, Domestic SLC, Domestic Exempted,Commercial Motor,etc), payment channel type(System, Paytm, Field, RazorPay, PayU, BBPS, POS, Sewakendra, Freecharge) and tax head(INTEREST,LATE.CHARGES, ADVANCE, CURRENT.CHARGES, ARREAR.CHARGES) has to be provided

waterConnections

new connections created on the given date

Breakup by meter type(METERED, NON.METERED), usage(Domestic, Commercial, Residential, Institutional, Domestic Exempted) and channel(Counter, ONLINE, CSC, SYSTEM)

sewerageConnections

new sewreage connections created on the given date

Breakup by usage(Domestic, Commercial, Residential, Institutional, Domestic Exempted) and channel(ONLINE, CSC, SYSTEM)

pendingConnections

pending connections on the given date

Breakup by duration(0to3Days, 3to7Days, 7to15Days, MoreThan15Days)

slaCompliance

Percentage of complaints that are resolved within SLA till the given date.

Nil

todaysTotalApplications

# of Applications created on the given date

Nil

todaysClosedApplications

# of Applications closed on the given date

Nil

todaysCompletedApplicationsWithinSLA

# of Applications closed on the given date within SLA

Nil