Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
DIGIT is a specification-driven open-source technology platform that leverages the capabilities of microservice design to promote responsive and agile solutions. This site covers a microscopic view of the standards and specifications that enable the co-creation of secure, agile, interoperable, and manageable solutions as part of the DIGIT platform.
The objective of this site is to provide specifications for DIGIT architecture as well as for the implementation of specific DIGIT products.
The site offers -
A single point of reference for DIGIT implementation and integration specification
Act as a guideline for partners and co-creators on key details to consider
API interaction details
Key benchmarks to follow
The site describes the DIGIT technology specification in the context to -
APIs available from Employee Information System for employee services to -
create statewide standardized database of the employee to streamline processes related to personnel management
increase transparency for higher management for efficient resource planning
integrate with rainmaker modules for security, authentication and workflow handling
establish KPIs for employees and generate reports
A detailed insight into the open standards principles adopted to establish DIGIT platform specifications
Effective co-creation and partnerships in developing digital public goods are based on solid frameworks and principles that define the rules of co-creation. The DIGIT platform is designed using open-source standards that allow other stakeholders in the ecosystem to contribute and build innovative governance solutions.
The published DIGIT specifications and open standards principles help in identifying and explaining the module taxonomies, data modelling approach and API data interactions. This section provides a detailed insight into the DIGIT platform specifications and open standards approach in general.
API Data Interaction Specifications
The past couple of decades has seen an increasing thrust from governments to build digital infrastructures that are scalable and follow open standards. Frameworks, institutional mechanisms, and standards are necessary to bring comprehensiveness to the eGovernance initiatives. It can also help drive efficiencies that enable large-scale transformations. These frameworks and standards are also crucial for bringing us closer to building our technological sovereignty.
There is an established need for standardized knowledge systems that can aid in developing sustainable digital solutions. To build standards that can provide context and boundary to an otherwise fragmented knowledge base of ‘Urban Governance,’ Taxonomies and Ontologies have been identified as essential tools. They are integral to the standards that evolve.
Creating taxonomies is foundational in any knowledge system, and this document attempts to be a repository for standardized nomenclature and classifications in different e-governance application domains. Taxonomies help build robust frameworks and guidelines that support specific operations in context. It aids them in creating workable solutions down the line that can be adopted across different ULB jurisdictions across India.
The taxonomies defined as part of DIGIT specifications establish key principles in the context to various elements linked to the specific module. And, this knowledge is essential to bring in a uniform understanding of the domain and its diverse components.
The taxonomy is developed to meet the practical need to carve out a harmonized view of different elements of the module. It tries to capture the most important entities, their properties, categories, subcategories, parameters, and specifications within this domain as well as other associated areas.
Capturing abstract knowledge across a domain and rendering a uniform perspective of this knowledge is the core challenge in the development of knowledge representation tools like taxonomies and ontologies. Taking this into consideration, a conceptual framework has been followed, which helped in enforcing a systematic approach to building the taxonomies.
This framework follows a bottom-up approach and allows inductive inferencing while developing these knowledge models. The framework has seven broad components, and they are elucidated using an example of building a taxonomy for college education in India.
Domain – A domain outlines the scope of the knowledge area around which the taxonomies and ontologies are to be defined. In our example, the Indian Education System can be marked as the domain.
Sub Domain- A Sub Domain denotes a subset of the knowledge area. It narrows down the scope of the knowledge area and helps in establishing a clear context. A domain may consist of more than one sub-domain, and these sub-domains can be overlapping or mutually exclusive. For instance, the domain of the Indian Education System can consist of several sub-domains like - Higher Education Systems, Primary Education, Elementary Education, Integrated Child Welfare Schemes (Anganwadis), etc. To analyze college education in India narrowing it down to the subdomain of the Higher Education System, will bring more focus.
Entity- Entities in a domain define the nouns in that knowledge area. They are the essential building blocks in any knowledge model. While building taxonomies and ontologies, identification of the key entities and defining them is a critical step. In a college taxonomy, Infrastructure, Learning Aids, Teaching Staff, Non-Teaching Staff, Governing Bodies, Pedagogy, and Academic Subjects are examples of a few entities that surface. Each of these entities does not stand in isolation and is usually supplemented with peripheral associations and terms. This discovery process is iterative and usually spawns a universal terminology for a domain.
Properties - The Entities that are associated with a Domain/Sub Domain are analyzed to identify the properties, processes, services and other aspects related to them. In the example above, if we pick an Entity like Teaching Staff, the associated properties could be Qualifications, Subjects, No of years of experience etc. This exercise helps in bringing clarity about the entities and help in categorizing and identifying parameters and specifications.
Categories- The Entities and their properties will form logical clusters which can be carved into categories and sub-categories. The higher or more generic category subsumes the sub-categories within it leading to hierarchical relations. When organized together as a whole they yield taxonomies. With the example above there could be many categories around each of these entities.
Values- These are the most granular units within a taxonomy. They are usually the assignments in the last sub-category within a branch of a taxonomy. In the current example, consider analyzing the entity - Learning Aids; as we build the taxonomies around it, the possible values that can evolve could be visual aids, recorded audio, textbooks, and so on.
Parameters and Specifications– These do not form part of the taxonomy but carry essential information. This information may be used to execute a process or provide a service. For example, student admissions can have specifications like age, address etc.
To ensure this taxonomy fits the needs of interested stakeholders the following principles have been followed in designing it. The principles are explained in context with the help of inferences from the Property Tax module for illustration.
Usable: Property Tax is predominantly a local tax falling under the jurisdiction of State or ULBs and is governed by State Acts. The local options regarding the tax will be heterogeneous. To fit the multivariate property tax systems in India the taxonomy has been designed to be coarse-grained, light-weight and minimalistic.
Evolvable: The taxonomy is designed to evolve over a period of time thereby adapting to changing needs and emerging technologies. For example, “Collection Channels'' for Property Tax are defined to accommodate any future advancements in the digital payments space.
Modular: The categorizations in the taxonomy are designed modularly, yet they function together as a whole. They are independent and self-contained and may be combined and configured with similar units to achieve a different outcome. These categorizations can be unbundled into multiple simple categorizations. They can be further re-bundled in a modular manner to suit disparate contexts. For example, the Property “Usage” element and its sub-classifications can be easily reapplied in the context of any Building Plan Approval System.
Extendible: The taxonomy is designed to be exhaustive and the elements of Property Tax are positioned in a hierarchy that can accommodate both horizontal and vertical additions. This leaves room for wider adoption and innovation to suit the contexts of any ecosystem. Also as stated earlier in the document the end goal is to build a knowledge practice that supports Open Standards, and taxonomy is an entry point. As it evolves it will be used as a basis to build ontologies around the Property Tax domain.
Open: The taxonomy has been designed to be ‘open’ to allow publishing under the most unrestricted licenses to enable wider ecosystem participation and foster innovations.
The Data Model standards and specifications help in explaining the DIGIT module design specifications that further translate the conceptual rules into recommendations, requirements, and restrictions.
Data models offer a three-dimensional view of what data needs to be collected, how is the database structured, and how the data entities across segments map to one another. The principles and specifications in this section help in defining the key standards applicable across the DIGIT platform to ensure interoperability across the platform and consistency in database design.
Versioning: The design of the data models takes into consideration the fact that these will evolve with time and also allow contributions from multiple stakeholders. The version upgrades will be added to this site for reference guidelines.
The data model design and specifications are based on the guidelines listed below.
Open: In order to maintain technology and vendor neutrality, DIGIT data models -
are published under the Creative Commons Attribution 4.0 International License
does not assume or require the choice of any proprietary technology
is designed and ratified through a multi-stakeholder process
is developed/reviewed/adopted by a group of experts through a consensus-based process
Evolvable: To adapt to changing needs over time, data models -
Are versioned with backward compatibility of at least up to 1 major version.
Is protocol-agnostic to facilitate innovation in protocols and support solution use cases over multiple protocols (e.g. governance application over chat interfaces). In other words, they follow The Rule of Least Power. In order to achieve this, data models carry all the necessary information –
request metadata e.g. authentication token, device information, signatures
response metadata e.g. response signatures, processing status, correlations ids
error data e.g. error codes, messages etc.
in its own structures, rather than depending on protocol-specific fields/headers to carry such information.
Extendable: Given the diversity of India’s urban systems, it is important to ensure that standards do not limit the ability of solution providers to develop solutions that meet local needs. Further to enable innovation, standards should not be restrictive in their specification and application. Thus standards need to be extendable to enable ecosystem actors to innovate and build locally relevant solutions. Therefore, data models -
extend from existing international/national standards like National Municipal Accounting Manual (NMAM) wherever possible
allow adding optional business extension elements
such extension elements are clearly documented in the same manner as base models and APIs and made available on a public repository
Minimalistic: To enable ecosystem actors to easily adopt standards while empowering them to innovate, data models -
contain minimal mandatory fields in data models
require only the most fundamental API operations to enable faster compliance while fulfilling needed functional requirements. The consistent pattern in API operations on various entities makes them simple to adopt.
avoid including attributes/APIs needed for specific solutions that are not yet known to be applicable to wider solutions.
Balance Data Privacy with Data Empowerment: To leverage the power of data while ensuring safe usage, data models -
require minimal personally identifiable information (PII) to be collected mandatorily thereby reducing risk to PII data
provide policy-based access control to enable the creation, modification and sharing of data as needed
include provision for data anonymization and proxy fields for PII and other sensitive data
Provide for non-repudiability: To ensure the right attribution for the data, data models -
declare access mechanisms for APIs
provide digital signatures
provide APIs for accessing data access information
Unbundled: To provide the most fundamental building blocks while ensuring minimalism, extensibility and evolvability, data models -
limit the mandatory information in data models
Given the role and significance of the DIGIT platform in building citizen-centric applications and technology-based solutions for the community, it is crucial to define the data modelling standards. Standardized data aids in interoperability, and improves accuracy while ensuring consistency.
Data Models are broken down into simpler fundamental units (models) as far as possible. For example, a property assessment model is basically a property model and assessment model with the assessment model referring to the property model.
Data models include a Universally Unique Identifier (UUID) field which uniquely identifies the object of the respective entity type within the respective domain. Data models require minimal mandatory fields to enable maximal inclusion. As a thumb rule, wherever unsure whether a field is absolutely required in all scenarios, it should be made optional.
Data models extend/ reuse/ adopt international/ national models wherever available/applicable e.g. Open311 for citizen services like grievances and schema.org for general model definitions.
Data models are extensible i.e. they allow a way to capture extra information that was not initially included during the model design. To achieve this: It may provide a simple map of key-value pairs. Future versions of the data model may choose to create mandatory/optional name attributes in the data models after researching the wider applicability of such fields.
Data models allow for namespacing in field names to indicate the source/reason/category of the extended fields.
APIs to generate three distinct types of bills for MuktaSoft - wage, purchase and supervision. The API specs here enable the calculation of bill amounts. The _estimate API performs the same calculation as _calculate but returns only temporary results. _calculate computes amounts for a bill, stores metadata about the bill and calls the expense service to create a bill.
Organization service and registry. The spec has two components.
The organization services APIs are meant to house business logic such as workflow and/or other validations.
The organization APIs provide access to the pure registry without any of the add-on services. Those who want to use the pure registry can do so without the requirement to use workflow or other services.
Complete taxonomy for Property Tax applications
This section outlines the key entities, properties and major categories associated with the Property Tax governance component. It summarizes their categorizations and sub-categorizations and values. The categorizations primarily establish hierarchical relationships that can be established and as a whole yield taxonomies around Property Tax.
The illustration above offers a consolidated view of the key components and entities defining the Property Tax system.
While building the knowledge models for Property Tax systems, it is imperative to consider entities that are interlinked with Property Tax. Property Tax is a type of Revenue charged against a property. Collections operationalize the Revenue mobilization within a ULB. Hence taxonomy for Property Tax cannot be built in a silo and needs to be accompanied by entities like Property, Revenue and Collections.
Property: It is an immovable real asset with clear ownership, which can be
a) A Land Parcel by itself or
b) A Land Parcel together with built structure or part of it along with its share of the land parcel
A property is transferable by law or deed and can be put to a designated use.
Property ID: An identifier that uniquely represents a specific Property comprehensively
Ownership is an important characteristic of Property and impacts many other processes surrounding Property Tax like exemptions, assessments etc.
Owner: the entity who/ which has the legal title over an item (Such as a property, document etc.) on which entity has the right to enjoy as far as law permits unless prevented by some agreement or covenant (like leases) which restrains the entity's rights. The Owner of a Property can be Individual/s or an organization.
Individual: A person, a group of persons having a legal interest in the property
Organization: An organization, or organization, is an entity – such as a company, an institution, or an association – comprising one or more people and having a particular purpose.
Location: The geographical position where the Item (here Property) is situated on the Earth. This can be expressed as an Address, Digital ID or as Geo-Coordinates. Location can fall under different jurisdictions which are captured in the fields characterizing the location.
Address: The commonly used Postal address with door number, street name, Locality, City, PIN Code, State, Country Combination
Geo-Coordinates: These are the Geographical Coordinates that can be expressed as a Point (Latitude/ Longitude) or a Polygon on a base map of the ULB.
Digital Door Number: Some ULBs have issued Digital Door Numbers to Properties based on some scientific and unique way to identify a property. This is normally restricted to the building and not Each property unless the entire building/ group of buildings is the property.
Property Composition: The Property Composition can be land by itself OR it can be together with the built structures on top of the land. The Built structure can be a building/ group of buildings or part of a building with a share of the underlying land.
The Appropriate combination of the property which can consist of the built structure together with its land/ share of landforms the property composition
Unit: Part of the Property with a unique Combination of traits such as Usage, ownership, Occupancy, structure type etc. is called a Unit. A combination of such units for the Property.
E.g. (1) - If the Property is an Apartment in a Building which is used for Residential purposes, occupied by the owner and one room is sublet to a tenant. The units of the property could be
The Share of Land for the Property (the apartment)
The Room which is rented out
The remaining part of the Apartment which is occupied by the owner
The reason there are 3 units is - the underlying land/share of land always forms one of the units. Units (b) and ( C) are separated because the Occupancy is different and the ULB law might compute taxes based on occupancy type.
E.g (2) - The Property Could be an Independent building wherein the ground floor is used for commercial purposes and the first floor is used as a residence by the owner. The units for the above can be
Underlying Land for the independent building
The Ground floor which is used for commercial purposes (first use)
The First floor which is used for the residential purpose (Second use)
Land: Part of the Earth surface which is not covered by a body of water.
Land Parcel: a plot or tract of land with a clear area and well-defined boundaries.
From a property perspective the underlying land with clear boundaries on which the property is situated.
From a GIS mapping perspective, a land parcel is designated as a single point (as the center) or more accurately in the form of a polygon depending on the purpose.
Share of Land: This is a proportional share of the land area (based on local laws or agreements) when multiple properties are built on the designated land parcel. This is often indicated as a % of the land parcel.
While the exact share of the land area may be quantified, in many instances, the exact boundaries of the share are not demarcated clearly.
Land Use: The activity or purpose for which the land is determined to be employed.
For the purpose of Property Tax, this is a piece of mandatory and important information, when the Land is Vacant but can be optional if there are built structure/s on it
Unit: Part or Portion of the Property (with clear demarcation) for which at least one of the property tax factors (Use, Occupancy, Structure category, Age etc.) is different is called a Unit of the property.
For e.g. in a Single Property - there could be 3 units such that (with Different usage and occupancy)-
The ground floor may be used for commercial purposes & rented out whereas the first floor is used for residential & Tenanted and the second floor is residential and self-occupied. TValue determined (ARV, CV) for each unit together contributes towards the Value for the property on which the Property tax is computed.
If the property is homogeneous (all values are the same, then the property will have only One Unit).
Unit ID:
Building ID: Is the Identified assigned to represent a Specific Independent structure
- this can be a part of a large property OR the can contain several properties within that specific structure.
Age: This is the time period between the Current Date & the date based on a clearly Identified event, based on the local Law / ACT. This date can be the date of completion of construction or the date when the Occupancy certificate was issued for the property.
Age is normally computed for Built structures on the property and not for the Land itself. Age is often used to determine the Depreciation/rebates etc based on the Property tax laws of the ULB
Occupancy: It depicts the current resident/user of the Property or part of it. This is independent of the Owner or the Usage of the property
Structure Category: From a Property Tax viewpoint, the Structure of category is based on the Longevity/permanence of the Property or the relative strength of its built structure
Structure Components: Key Constituents that make up the built structure. From Property Tax assessment perspectives the Wall, Floor, roof are regarded as the key components
Floor: The lower surface of the room/ property on which one may walk is called the floor.
Wall: Vertical surfaces erected to create a space enclosure to provide protection/ privacy or merely to demarcate is called a wall.
Roof: The structure forming the upper covering/ surface for the property/ part of the property
Unit Use: The purpose for which the Unit is put to use
Residential: A structure that is designed for people to live in.
These include a building in which sleeping and living accommodation is provided for normal residential purposes, with cooking facilities and includes one or more family dwellings, apartment houses, flats, and private garages of such buildings (Ministry of Housing & Urban Development, 2016).
Industrial:
Commercial: These includes a building or part thereof used as shops, stores or markets for display and sale of wholesale and or retail goods or merchandise, including office, storage and service facilities incidental thereto and located in the same building. (Ministry of Housing & Urban Development, 2016).
Heritage:
These include any building of one or more premises or any part thereof
and/or structure and/or artefact which requires conservation and/or
preservation for historical and/or architectural and/or artisanry and/or
aesthetic and/or cultural and/or environmental and/or ecological purpose
and includes such portion of land adjoining such building or part thereof as
may be required for fencing or covering or in any manner preserving the
historical and/or architectural and/or aesthetic and/or cultural value of such
building (Ministry of Housing & Urban Development, 2016)
Institutional:
Utilities:
Dimension:
Unit of Measurement:
Value:
Evidence:
Assessment Method: Method by which the state / ULB determine the Property Tax for properties within the ULB.
Property Tax Period:
Financial Year:
Frequency:
Property Zone: This is a combination of factors that contribute to determining the Property Tax based on the chosen Valuation method.
Valuation Rate: The guidance rate issued by the Appropriate authority which the ULB uses to Determine the Value on which the Property Tax Rate is applied. The valuation rate/guidance rate is published by the Govt Authority. (Can be from Non-ULB departments like Registration, PWD etc.)
Zone Combination - Boundary combinations based on which Valuation Rates or Guidance Values are published by Departments such as Municipal, Registration or PWD. It might be typically a combination of Ward/Zone/Locality/ Door number etc. as finalised by the publishing authority.
Land:
Structure Combination: is the combination of Building structure in which the valuation rate is published for the Governing authority. (These rates are usually published by the Registration / Pwd department in most states based on Age, usage etc..) Sometimes they are independent of the Usage/ structure category/components as mentioned in the Property. This is mainly because of potential differences in the definition of these terms as per the publishing authority and the ULB.
Structures:
Property Tax Rate: This is the rate that is applied on the Valuation arrived by the applicable Assessment Method (like ARV, UAM, Capital Value). These rates are typically finalized by the ULB
Arrears: Arrears are the Property Tax liabilities that have accrued because of payment not being received by the due date.
General Tax:
Cess:
Other Taxes:
Other Charges:
Enumeration: These are attempts by the ULB to increase coverage (Adding new properties into their database). These are often specific efforts done periodically or through special intervention like GIS-enabled Property Surveys and these are then assessed to determine property tax.
New Assessment: Property Tax assessment done for the first time for a property in line with ACT and rules for the ULB. These can be initiated by the CItizen or by the ULB
Typical Output: Property Tax ID, Property Tax Demand Notice
Reassessment: Process to determine new tax value for an existing property based on changes to usage, dimensions, occupancy, demolition or merging the property with adjacent property or dividing the property into 2 or more parts etc.
Addition / Alterations: These are changes to Property Sub Units (Additions or Alterations) or the change in its Usage.
These could be initiated by the Property Owner or the ULB authorities.
Typical Output: Reassessment Notice and Revised Demand
Amalgamation: This happens when multiple properties are modified into a single property. With this One Single New Property is created and older properties are deactivated for clear reasons. This process results in an issue of Deactivation notice and issue of New Assessment Notice with appropriate Property Tax demand.
Bifurcation: Properties are split into 2 or more parts for reasons such as inheritance by multiple individuals or Partial sale. This results in the division of the property into 2 or more parts. In such cases, One part of the Bifurcated property retains the Original property ID but the others acquire a newer ID.
Demolition: Dismantling the Structure or part of the structure which change the property tax to be levied on the underlying land and part of the remaining structure OR as a result of this, the Property Tax is only levied on the land (if the entire structure is demolished) A typical output of this is a Demolition Order / Revised demand. This can be initiated by the Owner or the ULB
Mutation: Change in ownership of property. These could be for many reasons such as "sale of property" or because of "inheritance". This could be Initiated by the new owner or as a trigger from the registration department.
Typical Output: A mutation certificate
General Revision: When the ULB initiates a change of the Property Tax assessment based on a Periodic increase in rates (as required by Rules/ Acts).
Typical Output: General Revision Notice
Vacancy Remission: Property Tax discount sought by citizens because the Property has been vacant for a stipulated period. These are typically initiated by the owners.
Typical Output: Vacancy Remission notice and reduced demand for that period
Exemptions: Properties are given exemptions based on the Rules of the State. These could be for religious usage or for properties owned by war widows etc.
Typical Output: Exception Notice
PT Grievances: Complaints from Property Owners regarding Property Tax related issues (excluding disputes on the tax amounts)
a) Did not get a receipt through the Credit card was charged
b) Dues are still showing even though payments are already made
c) Money debited in my account but is not reflecting in the dues statement
PT Dispute Resolution: These are complaints regarding the Tax amount charged, which takes into consideration, appeals, appellate and court cases to get to a resolution.
E.g.
a) Property Usage showing as commercial instead of residential
b) Mistakes in Property Dimensions
c) Court Cases against Property Assessment
Revenue: It is the Income Earned by the Governing Body
The revenue could be earned as Tax, Service charges, fees etc.
Type of Revenue: The governing body can have several sources of revenue as provided in the laws/Acts.
An empowered Local Government like a ULB can create its own revenue sources. In addition, it also receives revenue share from other government bodies as per the prevailing ACTs in the state. For e.g. in many states, the Registration department has to share the revenues from Property Registration in specific proportion if the Property lies within the ULB Jurisdiction.
Permission-Based: Income earned from providing permissions/licenses for specific activities are called permission-based revenues.
E.g. Building Plan Approval, Trade License, Road cutting, Movie Shooting
Tax Based - Income earned by levying tax is called Tax based revenues.
These are enforceable by law.
Eg. Income Tax, GST, Property Tax, Water Tax, Scavenging Tax, Lighting Tax etc.
Service-Based: Income earned by the provision of specific Services are Service based revenues.
For e.g. Electricity Charges, Water Charges, Sewerage Charges, Solid waste pickup etc.
Sale Based: Income earned from Selling certain goods/assets are called Sale based revenues
E.g. Resale of assets, Provision of medicines at discounted prices etc.
Ad Hoc Charges: income that is earned for information provision, fees or fines.
E.g. Fines for Spitting on roads, Fines for Debris creation, Tender Fees
Share from Other Departments:
Account Head: The Chart of accounts relevant to the compliance to local / state and Central finance function
Department Account Head: The appropriate revenue heads to which this revenue should be recognized by the Payee.
For e.g. the Account head relevant to the ULB which are say compliant with the NMAM standards
State / Center Account Head: These are account heads to which the Payee organisation has to report the revenues to the state/ centre.
Payer: is the responsible person/ organisation who has to remit the due amount
Individual:
Refers to the person who has to pay. In the context of property tax, this could be the owner of the property as identified under the Property Tax laws.
Organisation
A formal entity created for a specific purpose can have rights and obligations based on the kind of entity created. The formed entity will have clearly defined owners. This can be a company, trust, institution etc.
Private Organization:
A type of organisation where the owners are individuals or companies as opposed to government
Government Organization:
Organisations that are owned/ run by the Government
Public-Private Organization:
Organisation where the ownership is jointly held by government and private entities
Payee: The governing body which is authorized to collect the revenue as per prevailing Government provision or laws.
Ultimate Payee: The final recipient of the amount to whom it is due irrespective of the actual payee.
This concept might be needed, where the amount collected by the payee is supposed to be earmarked for the ultimate payee.
Amount Due:
The quantum of money that is owed by the payer for the period, or services availed
Collection:
Collection Channel:
Counters:
Portals:
Mobiles:
Market Places:
Door to Door:
Mode of Payment: The Instruments used by the Payer ro remit the amount to the Payee.
Physical mode: Paper based instruments which are approved by the ULB.
These can include Cheques, Demand drafts, Challan etc.
Digital: The electronic Mode of Payment where money is transferred in a digital mode to the payee's account.
These can include Bank Transfers, Credit Card, Wallets, Debit cards etc.
Service Provider: An agency or an Organization which is designated/empowered to collect monies from Payers.
Government Service Provider:
Private Service Provider:
Public- Private Service Provider:
Amount Collected: This is the money to be received by the governing body from its citizens against taxes, permissions and services; also known as demand in case of Property Tax.
Type of Property
Area of Measurement
Representation on Map
Vacant Land
Polygon Area (m2)
Polygon
Built Structure
Builtup Area of Premise (m2)
Polygon, Centroid
Appurtenant Area (m2)
Polygon, Centroid
Height of built structure
Key terms and Definitions
Appurtenant Area: Anything attached to a piece of land or building such that it becomes a part of that property, and is passed on to a new owner when the property is sold. It may be something tangible like a garage, septic system, water tank, or something abstract such as an easement or right of way.
Type
Location Specification
Address
House No, Building Name, Plot/Survey No, Street Name, Locality, Zone/Ward, City/Town, District, Region, State, Country, Pin code
Geo Location
Lat, Long, Polygon
Digital Door Number
Address: The address of the property provides the particulars of the place as per the administrative boundaries or norms defined by the local governing body.
Geo Location: Geolocation is the identification or estimation of the real-world geographic location of the property. This refers to the latitude and longitude coordinates of a particular location where the property is located.
Digital Door Number: Property Numbers are defined using scientific methods and often assigned with QR codes for traceability and usability.
Calculation Methods
Parameters
Capital Value System
The Market Value of the property, Total Carpet Area, Weight for Construction Type, Weight for Age of Property, Weight for User Category, Current Rate of Property Tax
Unit Area Value System
Base Unit Area Value, Covered Space/ Land Area, Location Multiplicative Factor Value, Age Multiplicative Factor Value, Structure Multiplicative Factor Value, Occupancy Multiplicative Factor Value, Rate of Tax
Annual Rent Value System
Monthly Rent Notified by ULB, Plinth Area, Construction Type, Usage Type
Capital Value System: The market value of the property is the basis of estimating the taxes to be paid. This market value is determined by the government and revised annually, based on the ward in which the property is located.
Unit Area Value System: Under this system, the tax is levied on the per-unit price of the carpet area or the built-up area of the property. Municipalities like New Delhi, Bangalore, Kolkata follow this method.
Annual Rent Value: It is the amount of the property which might be let out on a yearly basis. In the case of self-occupied property used for staying by the owner, then the value is zero. In a situation where the owner is neither staying nor letting it out then also, the value is zero. The gross annual rent of the property is fixed by the municipal body which is generally higher than the actual rent received or expected rent. The municipality of Chennai and Hyderabad use this method
Payment gateway is a trusted financial intermediary which facilitates secure digital fund transfer between parties involved and keeps them informed on the status of transactions throughout the lifecycle of transactions.
Level 1
Level 2
Level 3
Property ID
Owner
Individual
Single
Multiple
Public Organization
Central Government
State Government
Local Government
Other Government Organizations
Private Organization
NGO
Private Trust
Other Private Institutions
Private Company
Private Board
Public Private Organization
Location
Geo Coordinates, Address, Digital Door Number
Property Composition
Land
Land Parcel Measurement
Share of Land in Property
Land Use
Unit
Unit ID
Building ID
Age - Date of construction / Date of Occupation
Occupancy - Self Occupied / Rented / Leased / Vacant
Structure Category - Permanent / Semi Permanent / Temporary
Structure Components - Floor / Wall / Roof
Unit Use - Residential / Industrial / Commercial / Heritage / Institutional
Measurements
Level 1
Level 2
Assessment Method
Property Tax Period
Financial Year
Frequency
Property Zone
Valuation Rates
Zone Combinations - Ward, Block, Locality, Door, Road
Structure Combinations - Building Type, Usage
Property Tax Rates
Property Bill Constituents
Current Year
Arrears
Advances
Rebates
Interest
Penalty
Property Tax Components
General Tax
Cess
Other Taxes
Other Charges
Level 1
Level 2
Enumerations
New Assessment
Re-assessment
Additions / Alterations
Amalgamation
Bifurcation
Demolition
Mutation
General Revision
Vacancy Remission
Exemptions
PT Grievances
PT Dispute Resolution
Level 1
Level 2
Type of Revenue
Permission based - Trade license, Building plan approval, Road digging
Service based - Rentals, Water charge, Solid waste disposal
Tax based - Property tax, Water tax, Lighting tax
Sale based - Assets sale, Goods sale
Adhoc - Fines for dustbins, Tender Fees
Share from other Departments - Registration Fees
Account Head
Department Account Head
State Account Head
Payer
Individual
Private Organization
Government Organization
Public Private Organization
Payee
Ultimate Payee
Amount Due
Level 1
Level 2
Collection Channel
Counters - ULB, Revenue Dept, Bank, Registration Office
Portals - State, ULB
Mobile
Market Places - Paytm, Axis
Door to Door
Mode of Payment
Physical
Digital
Service Provider
Private
Government
Public Private
Amount Collected
The origin of a Trade License (TL) links to a mandatory license required to carry out dangerous and offensive trades and also trades that have health implications. Currently from shops to street vendors to restaurants and a lot of other trades must have a TL to carry out their business.
Why is a trade license required? The intent is to ensure trades that meet the prescribed health or safety guidelines. It ensures possible risks are inspected and meet the state’s necessary quality, health and safety standards. And, over time the trade license department has evolved into a new revenue opportunity stream for the ULB and now covers different types of trades.
Who needs a trade license? This varies from one state to another. In Chennai, registered companies do not need a TL. Every state publishes a list of all trades/trade types that need to procure a TL to carry out their business.
Citizen - Citizen is the person who intends to do business and applies for a trade license with the ULB.
Clerk - Clerk is an employee in ULB whose job is to perform first-level scrutiny of any application that is reaching ULB. He/She verifies the application checks for its correctness and has the authority to ask for more information or forward to the next officer in the hierarchy or reject citing the reasons for rejection.
Revenue Inspector - The Revenue Inspector is responsible for inspecting the place where trade is operating, checks for safety, security and sanitation compliance with the applied trade type. This actor has the authority to ask the applicant to make some modifications to comply with the rules or forward to the next officer in the hierarchy or reject citing the reasons for rejection.
Revenue Officer - The Revenue Officer is responsible for all the revenue streams in the ULB and has the authority to decide whether to issue the trade licenses considering the recommendation of the revenue inspector and the clerk. He /She can issue a license or reject the applications citing the reasons for rejection.
This page outlines the key entities and major categories linked to the Public Grievance & Redressal (PGR) system. The categorizations primarily establish hierarchical relationships that can be established and as a whole yield taxonomies around PGR.
Grievance Management
Complainant
Grievance ID
Grievance Nature
Location
Access Channel
Accountable Organization
Accountable Department
Responsible Organization
Status
Prioritization
Grievance Handling Steps
Evidence
Quality
Grievance: A complaint or service request raised by a citizen. Typically, involves concerns raised about the poor quality of service or when the promised services are not delivered as expected. Example: Garbage not collected.
Complainant: An individual, group or organization registering the grievance.
Grievance ID: A unique sequence of characters that identifies the registered grievance and is shared with the complainant. The ID is language independent.
Nature of Grievance: Category or type of grievance that determines if it is an individual grievance or a public grievance.
Access Channel: The different channels available to citizens to formally initiate/raise the grievance/service requests for the ULB to initiate action.
Physical: This channel type offers citizens physical access to ULB authorities or means to raise service requests. These may include local counters [managed by ULB bodies or third parties] or representatives visiting the citizen locations.
Counters: A physical space or window where citizens can transact business such as make a payment or raise service requests. The counters can be run by the department, government or a third party.
Mail: Physical items (such as documents, packages) that are sent/ received through the postal or courier delivery system.
Door to Door: This channel includes local governing body representatives or assigned third party agents who visit individual houses to collect payments, information. documents, etc.
Digital: This refers to the electronic medium (kiosks), that operates on self-help mode, made available to citizens to raise service requests, register grievances, or provide feedback etc.
Portals: Digital access points that enable citizens to avail various public services hosted by government bodies or third parties.
Mobile: This channel type provides citizens or organizations access to public services on their mobile phones.
Social Media: Use of online communication channels including Facebook, Linkedin, Twitter, Instagram etc to share information and develop social or professional contacts.
Others: Access channels that are not purely digital or physical but facilitate citizens to raise service requests or share concerns through assisted means or public means.
Intermediaries: Go between agents or mediators who enable interaction between different parties. In this grievance context, it allows interaction between citizens or organisations and the government.
Print Media: Published media that are circulated among citizens or within communities - like newspapers, magazines, newsletters etc.
Location: A location is the place where something happens or is situated. This can be a geographical specification or the more commonly used postal address.
GeoCoordinates: Representation of the entity or location on the base map to uniquely identify it. For different terms - the requirement of geo specifications can be a mere point, line or a polygon.
Address: Set of location-related details in commonly accepted formats to identify an entity uniquely in a city or village. Conventionally used by postal or courier services to deliver mails or parcels to that location.
Accountable Organisation: The government body responsible for ensuring that the grievance is resolved.
Accountable Department: The department within the accountable organisation that handles grievances of a specific kind.
Grievance Category: The basic level of grouping of grievances handled by the accountable organisation.
Grievance Name: A commonly used name for a specific grievance that allows easy understanding.
Prioritization: The level assigned to grievances to help identify the order of urgency and the attention required. As such, items of high priority will need urgent attention as compared to items of medium or low priority.
Responsible Organisation: The organisation that has the primary ownership to act upon the grievance and is answerable to the accountable organisation.
Status: Refers to the current state of action on the complaint.
Registered: The grievance details are recorded and a unique grievance number is allocated.
Pending Assignment: The state where a responsible resolving employee is not yet identified.
WIP: An assigned complaint that has been taken up for action but yet to be resolved.
Resolved: When the complaint is acted upon and its status informed to stakeholders.
Rejected: Complaint is identified as invalid for any appropriate reason and cannot be worked upon.
Closed: A resolved complaint that may have captured complainant feedback or has met predefined conditions.
Reopened: A previously registered complaint that has not met the satisfaction of the complainant and has been opened again. Only for Resolved or Rejected or Closed complaints can be reopened.
Force Closed: Complaints in this state cannot be reopened.
Grievance Handling Steps: Broad steps or actions required to handle the grievances. Some steps may be optional depending on the context.
Evidence: (from a grievance perspective) Evidence constitutes any document, media or geo-tracking to assist in complaint location, complaint visualisation and complaint resolution process.
Quality: A set of tangible or intangible parameters that determine if a product or service conforms to specified standards or expectations. Quality thresholds change based on customer expectations and improvements sought.
Quality Parameter: The variable that can be measured, monitored and controlled through specific actions or interventions.
Commitment: Refers to the standards or thresholds to which the quality parameters conform to meet expectations. These could be SLAs, defined by the ULB or States.
Actual Value: Relates to the performance achieved on specified quality parameters in context to transactions or delivery of service.
Stakeholders: A defined set of people, individuals, or groups responsible for managing and delivering defined services.
Administrators: Senior officials who review the performance of their teams. For instance, Function Head, City Commissioner, Principal Secretary etc.
Citizens: Person who is a Resident or Visitor to the City
Businesses: Business Operating or wanting to operate in the City
ULB Officials: Employees / Contractors who are responsible for carrying out day to day tasks in the ULB in providing services or administrative work.
Service Providers: Those who actually perform the last mile execution of work under a specific contract or understanding with the ULB.
Evidence: Proof made available to authenticate an assertion or a claim. Depending on the type of claim or assertion - different kinds of evidence is applicable.
Document: Written on printed paper or electronic files that are allowed as evidence by the ULB. Often, the documented evidence mandates a hand signature or digital signature of specific persons in authority to lend authenticity and be admissible as evidence.
Video: An audio-visual media that provides a first-hand report or glimpse into the issue or situation in context.
Audio: Any audio recording that supports the claims or throws light on the situation in context.
Image: A visual depiction of an object through various means such as drawing, painting, photography, mirror reflections, the lens produced, computer-processed representation of objects (using thermal, infrared, ultraviolet, electromagnetic, sound waves) etc.
Electronic Logs: Digitally produced records of events, which are time-stamped. Sources of these logs can be from digital equipment such as telephones, networks, computers, sensors etc. These are normally used to help specific objectives such as gathering information for the diagnosis, evidence of event sequence etc.
Biometric: Personal data obtained from measurements or the use of electronic gadgets to gather physical or physiological data that confirms the identity of living things.
Purpose: The reason for which something is done. In this context - the reason for which the evidence is collected to support the claim or assertion made.
Identity: Condition or characteristics that define the person or the thing.
The objective of the PGR service is to provide the functionality to raise a complaint or grievance by citizens in the system. Citizens can track the status of their complaint or grievance on the application and notifications of any updates is triggered to their registered mobile number whenever there is any change in the status of the complaint.
All content on this page by is licensed under a .
Representation of an address. The postal location details of the area where the complaint needs to be acted upon. Individual APIs may choose to extend from this using all if more details need to be added in their case.
Set of location-related details in commonly accepted formats to identify an entity uniquely in a city or village. Conventionally used by postal or courier services to deliver mails or parcels to that location.
Complaints or service requests raised by a citizen. Typically, involves concerns raised about the poor quality of service or when the promised services are not delivered as expected. This entity holds the complaint or service request details comprising of a unique id, type of complaint and its description.
Refers to the broad steps or actions required to handle the grievances. Some steps may be optional depending on the context. This entity holds the information about the action being taken on the complaint as it goes through the redressal workflow.
All content on this page by is licensed under a .
Solid Waste
List: Broken Bin, Absent Garbage Collector, Overflowing Garbage Bins, Garbage is strewn. Garbage Burning, Smelly Landfills, Fallen Trees, Debris, Hazardous Chemicals, Hazardous Medical Supplies
Water
List: No Water Supply, Pipe Broken, Leakage, Water Contamination, Stagnation, Borewell repair
Street Lighting
List: Not Working, Electric Shock from Street Lights, Streetlight Wires - Cut/ Overhanging
Sewerage
List: Sewerage pipe Leakage, Sewerage Pipe broke, Stagnant water, Open Manholes, Broken Manhole covers
Property Tax
List: Property Calculation, Did not get a receipt, Money Debited but Still showing outstanding, Errors in Demand Notice, Delays in Property Tax services
Public Facilities
List: Play Ground, Marriage Hall, Community Hall, Parks, Playground, Stadiums, Burial Ground
Stray Animals
List: Dog, Menace, Death of Stray Animals, Stray Cattle, Stray Pigs
Unauthorised Deeds
List: Illegal Slaughtering, Unauthorised Shops, Depositing FSM into Waterbody,/ Open groud, Unauthorised Tree cutting, Drinking in the Open, Food adulterations, Road Cutting, Dumping construction Materials on Road. Encroachment of Public Property, Misuse of community Hall, Wrong Parking, Unauthorised Advertisement boards, Violation of Building Byelaws, Unauthorised construction
Noise Pollution
List: Loud Speakers, Open Parties
Sanitation
List: Public Toilets, Community Toilets, School Toilets, Open Defecation, FSM operator, Unhygenice Slaughterhouse
Administrative
List: Election, Voter List, Schools, Employees, eKYC
Infrastructure
List: Roads, Medians, Footpaths, Traffic Island, Poor quality of work
Benefits Administration
List: Benefit Denied, Sum Not received
tenantid (PK)
character varying (256)
Unique identifier for a tenant to which user primarily belongs
Y
uuid (PK)
character varying (256)
system generated id for the address
Y
housenoandstreetname
character varying (512)
house no and street name of complainant
N
mohalla
character varying (256)
locality of the complainant
N
landmark
character varying (1024)
additional location detail to help find the property
N
city
character varying (512)
city of the address..can be representated by the tenantid
N
pincode
character varying (16)
pincode of the address. Indian pincodes constitute numbers only
N
latitude
numeric (9, 6)
the latitude location details of the property
N
longitude
numeric (10, 7)
the longitude location details of the property
N
createdby
character varying (128)
username (preferred) or userid of the user that created the object
Y
createdtime
bigint
epoch of the time object is created
Y
lastmodifiedby
character varying (128)
username (preferred) or userid of the user that last modified the object
N
lastmodifiedtime
bigint
epoch of the time object is modified last
N
additionaldetails
jsonb
Json object to capture any extra information which is not accommodated in the model
N
tenantid
services.*.addressDetail.tenantId
uuid
services.*.addressDetail.uuid
housenoandstreetname
services.*.addressDetail.houseNoAndStreetName
mohalla
services.*.addressDetail.mohalla
landmark
services.*.addressDetail.landmark
city
services.*.addressDetail.city
pincode
latitude
services.*.addressDetail.latitude
longitude
services.*.addressDetail.longitude
createdby
services.*.addressDetail.auditDetails.createdBy
createdtime
services.*.addressDetail.auditDetails.createdTime
lastmodifiedby
services.*.addressDetail.auditDetails.lastModifiedBy
lastmodifiedtime
services.*.addressDetail.auditDetails.lastModifiedTime
additionaldetails
tenantid (PK)
character varying (256)
system generated id for the address
Y
servicecode
character varying (256)
The unique identifier for service
Y
servicerequestid (PK)
character varying (256)
The unique formatted id for service request.
Y
description
character varying (4000)
Additional information or description of the service request - Application to raise grievances and track the progress. - It allows any citizen registered in the system to raise a complaint (based on the service definition provided in the master data) for any ULB belonging to the state.
N
accountid
character varying (256)
userid of the user requesting the srervice - in our case it may be same as phone as we are using mobile number as the userid
N
This is the json object that will carry the actual input (where ever the metadata requries input)
N
applicationstatus
character varying (128)
The current status of the service request.
N
rating
smallint
Evaluation posted by the citizen on complaint resolution.
N
source
character varying (256)
captures the source of the service request(ex:- whatsapp, ivr, Swachhata etc)
N
createdby
character varying (256)
username (preferred) or userid of the user that created the object
Y
createdtime
bigint
epoch of the time object is created
N
lastmodifiedby
character varying (256)
username (preferred) or userid of the user that last modified the object
N
lastmodifiedtime
bigint
epoch of the time object is modified last
N
addressid
character varying (64)
Reference to linked address with the grievance.
N
phone
character varying (64)
Contact number of the individual who lodged the complaint
Y
status
character varying (64)
The current status of the service request
N
feedback
character varying (500)
Information/Comments posted by the citizen on complaint resolution.
N
tenantid
services.*.tenantId
servicecode
services.*.serviceCode
servicerequestid
services.*.serviceRequestId
description
services.*.description
accountid
services.*.accountId
rating
services.*.rating
source
services.*.source
createdby
services.*.auditDetails.createdBy
createdtime
services.*.auditDetails.createdTime
lastmodifiedby
services.*.auditDetails.lastModifiedBy
lastmodifiedtime
services.*.auditDetails.lastModifiedTime
addressid
services.*.addressId
phone
services.*.phone
status
services.*.status
feedback
services.*.feedback
uuid (PK)
character varying (256)
system generated id for the address
Y
tenantid (PK)
character varying (256)
Unique identifier for a tenant to which user primarily belongs
Y
when
bigint
EPOC timestamp on when that particular entity is created in a DB.
N
businesskey
character varying (256)
Connector used to reference a complaint to its action.
Y
status
character varying (64)
The current status of the service request
N
assignee
character varying (256)
The individual responsible for taking next action on a complaint
N
media
jsonb
Supporting evidence by citizen while lodging a complaint
N
comments
character varying (1024)
Additional information with respect to a grievance/ process.
N
action
character varying (64)
Action on the application in certain
N
uuid
actionInfo.*.uuid
tenantid
actionInfo.*.tenantId
when
actionInfo.*.when
businesskey
actionInfo.*.businessKey
status
actionInfo.*.status
assignee
actionInfo.*.assignee
media
actionInfo.*.media
comments
actionInfo.*.comments
action
actionInfo.*.action
Property services create a property, store it in the registry and various municipal activities like assessment, mutation and amalgamation take place. The service registries help track the properties and the taxes paid for them.
It is an immovable real asset with clear ownership, which can be a) a land parcel by itself or b) a land parcel together with a built structure or part of it along with its share of the land parcel.
A property is transferable by law or deed and can be put to a designated use.
This entity is used to create, modify, search or delete property records containing basic information related to land and owner. Can be integrated with other modules like Water and Sewerage or Trade License to act as a base entity against which water connection or trade license can be issued.
id (PK)
character varying (128)
Unique Identifier of the Property for internal reference
Y
propertyid (FK)
character varying (256)
Unique Identifier of the Property
Y
tenantid (FK)
character varying (256)
Unique id for a tenant
Y
surveyid
character varying (256)
survey id of the Property
N
accountid
character varying (128)
UUID of the user to which the property will be associated
Y
oldpropertyid
character varying (128)
Old upic no of the Property. ULBs have the existing property in their system/manual records with their identification number, they want to continue the old reference number in this case the same identification number will be captured here.
N
status (FK - Only active values considered as KEY)
character varying (128)
Status of the property
Y
acknowledgementnumber
character varying (128)
Acknowldgement number given to citizen on submitting the application for creation or modification of the property.
Y
propertytype
character varying (256)
Type of a property like Private, Vacant Land, State Government, Central Government etc.
Y
ownershipcategory
character varying (256)
The type of ownership of the property
Y
usagecategory
character varying (256)
Property owners, these will be citizen users in system
Y
creationreason
character varying (256)
New property comes into system either property is newly constructed or existing property got sub divided. Here the reason for creation will be captured.
Y
nooffloors
bigint
no of floors in the property
Y
landarea
numeric (10,2)
Land area of the property in sq ft
Y
superbuiltuparea
numeric (10,2)
super builtup area of the complete property
Y
linkedproperties
character varying (2048)
Unique Identifier of the Properties from which the current proeprty is derived
N
source
character varying (128)
device type from request is sent - PC,mobile
Y
channel
character varying (128)
channel through which entity is created , like create,migration,update
Y
createdby
character varying (128)
username (preferred) or userid of the user that created the object
Y
createdtime
bigint
epoch of the time object is created
Y
lastmodifiedby
character varying (128)
username (preferred) or userid of the user that last modified the object
Y
lastmodifiedtime
bigint
epoch of the time object is modified last
Y
additionaldetails
jsonb
Json object to capture any extra information which is not accommodated in the model
N
id
Property.id
propertyid
Property.propertyid
tenantid
Property.tenantid
surveyid
Property.surveyid
accountid
Property.accountid
oldpropertyid
Property.oldpropertyid
status
Property.status
acknowledgementnumber
Property.acknowledgementnumber
propertytype
Property.propertytype
ownershipcategory
Property.ownershipcategory
usagecategory
Property.usagecategory
creationreason
Property.creationreason
nooffloors
Property.nooffloors
landarea
Property.landarea
superbuiltuparea
Property.superbuiltuparea
linkedproperties
Property.linkedproperties
source
Property.source
channel
Property.channel
createdby
Property.additionalDetails.createdby
createdtime
Property.additionalDetails.createdtime
lastmodifiedby
Property.additionalDetails.lastmodifiedby
lastmodifiedtime
Property.additionalDetails.lastmodifiedtime
additionaldetails
Property.additionaldetails
The postal location details of the listed property.
The geographical position where the item (in this case property) is situated on the earth.
This can be expressed as an Address, Digital ID or as Geo-coordinates.
Location can be situated under different jurisdictions which are captured in the fields characterising the location.
tenantid (FK)
character varying (256)
Unique identifier for a tenant to which user primarily belongs
Y
id (PK)
character varying (256)
system generated id for the address
Y
propertyid (FK)
character varying (256)
Unique identifier of the property
Y
doorno
character varying (128)
house number or door number
Y
plotno
character varying (256)
plot number of the house
N
buildingname
character varying (1024)
name of the building
N
street
character varying (1024)
street name
N
landmark
character varying (1024)
additional location detail to help find the property
N
city
character varying (512)
city of the address..can be representated by the tenantid
Y
pincode
character varying (16)
pincode of the address. Indian pincodes constitute numbers only
N
locality
character varying (128)
the locality in which the property is located
Y
district
character varying (256)
the district in which property is located
Y
region
character varying (256)
the region in which property is located
Y
state
character varying (256)
the state in which property is located
Y
country
character varying (512)
the country in which property is located
Y
latitude
numeric (9,6)
the latitude location details of the property
N
longitude
numeric (10,7)
the longitude location details of the property
N
createdby
character varying (128)
username (preferred) or userid of the user that created the object
Y
createdtime
bigint
epoch of the time object is created
Y
lastmodifiedby
character varying (128)
username (preferred) or userid of the user that last modified the object
Y
lastmodifiedtime
bigint
epoch of the time object is modified last
Y
additionaldetails
jsonb
Json object to capture any extra information which is not accommodated in the model
N
tenantid
Property.address.tenantid
id
Property.address.id
propertyid
Property.address.propertyid
doorno
Property.address.doorno
plotno
Property.address.plotno
buildingname
Property.address.buildingname
street
Property.address.street
landmark
Property.address.landmark
city
Property.address.city
pincode
Property.address.pincode
locality
Property.address.locality
district
Property.address.district
region
Property.address.region
state
Property.address.state
country
Property.address.country
latitude
Property.address.geoLocation.latitude
longitude
Property.address.geoLocation.longitude
createdby
Property.address.auditDetailscreatedby
createdtime
Property.address.auditDetailscreatedtime
lastmodifiedby
Property.address.auditDetailslastmodifiedby
lastmodifiedtime
Property.address.auditDetailslastmodifiedtime
additionaldetails
Property.address.additionaldetails
An organization, establishment, foundation, society, or the like - devoted to the promotion of a particular cause, value or program, especially characterized as useful for the public, education, research or charity.
id (PK)
character varying (128)
Unique Identifier of the Institution(UUID)
Y
propertyid (FK)
character varying (256)
Unique identifier of a property record
Y
tenantid (FK)
character varying (256)
tenant id of the Property
Y
name
character varying (1024)
Name of the institute
Y
nameofauthorizedperson
character varying (1024)
Name of the person who is taking action on behalf of institution
Y
type
character varying (128)
Institution type
Y
designation
character varying (128)
Designation of the person creating/updatingentity on behalf of the institution
Y
createdby
character varying (128)
username (preferred) or userid of the user that created the object
Y
createdtime
bigint
epoch of the time object is created
Y
lastmodifiedby
character varying (128)
username (preferred) or userid of the user that last modified the object
Y
lastmodifiedtime
bigint
epoch of the time object is modified last
Y
id
Property.institution.id
propertyid
Property.institution.propertyid
tenantid
Property.institution.tenantid
name
Property.institution.name
nameofauthorizedperson
Property.institution.nameofauthorizedperson
type
Property.institution.type
designation
Property.institution.designation
createdby
Property.institution.auditDetails.createdby
createdtime
Property.institution.auditDetails.createdtime
lastmodifiedby
Property.institution.auditDetails.lastmodifiedby
lastmodifiedtime
Property.institution.auditDetails.lastmodifiedtime
Table to capture migration logs in batches to resume in case of failure. The entity stores the migrating legacy property registry details along with demand and collection balances.
id (FK)
character varying (128)
Unique identifier fo the entity
Y
batch
bigint
Order of the batch
Y
batchsize
bigint
Size of the current batch
Y
createdtime
bigint
Createdtime of the entity
Y
tenantid (FK)
character varying (256)
Unique id of the tenant ulb
Y
recordcount
bigint
Total record count till the current entry
Y
id
Property.id
batch
Property.batch
batchsize
Property.batchsize
createdtime
Property.createdtime
tenantid
Property.tenantid
recordcount
Property.recordcount
This entity captures all audit-related details for the property table.
audituuid (FK)
character varying (128)
Unique identifier of the entity record
Y
propertyid
character varying (128)
Unique identifier of the property record
Y
property
jsonb
Complete property object stored as json
Y
auditcreatedtime
bigint
epoch of the time object is created
Y
audituuid
Property.audituuid
propertyid
Property.propertyid
property
Property.property
auditcreatedtime
Property.auditcreatedtime
The owner of a property can be an individual/s or an organisation. The entity captures the property owner details.
Ownership is an important characteristic of the property tax module and impacts many other processes surrounding property tax like exemptions, assessments etc.
ownerinfouuid (PK)
character varying (256)
Unique identifier for the owner entity
Y
tenantid (FK)
character varying (256)
Unique identifier for a tenant to which user primarily belongs
Y
propertyid (FK)
character varying (256)
Unique identifier for a property record
Y
userid (FK)
character varying (128)
Y
status
character varying (128)
status of the assessment determining its validity - active or cancelled
Y
isprimaryowner
boolean
The owner is primary or not
Y
ownertype
character varying (256)
Type of owner, based on this option exemptions are applied. This is master data defined in mdms.
Y
ownershippercentage
character varying (128)
Percentage of ownership of defined property
N
institutionid
character varying (128)
The id of the institution if the owner is the authorized person for one
N
relationship
character varying (128)
Relationship of guardian with the owner
Y
createdby
character varying (128)
username (preferred) or userid of the user that created the object
Y
createdtime
bigint
epoch of the time object is created
Y
lastmodifiedby
character varying (128)
username (preferred) or userid of the user that last modified the object
Y
lastmodifiedtime
bigint
epoch of the time object is modified last
Y
ownerinfouuid
Property.owners.*.ownerinfouuid
tenantid
Property.owners.*.tenantid
propertyid
Property.owners.*.propertyid
userid
Property.owners.*.userid
status
Property.owners.*.status
isprimaryowner
Property.owners.*.isprimaryowner
ownertype
Property.owners.*.ownertype
ownershippercentage
Property.owners.*.ownershippercentage
institutionid
Property.owners.*.institutionid
relationship
Property.owners.*.relationship
createdby
Property.owners.*.auditDetails.createdby
createdtime
Property.owners.*.auditDetails.createdtime
lastmodifiedby
Property.owners.*.auditDetails.lastmodifiedby
lastmodifiedtime
Property.owners.*.auditDetails.lastmodifiedtime
The purpose for which the unit is put to use.
tenantid
character varying (256)
Unique identifier for a tenant to which user primarily belongs
Y
id (PK)
character varying (256)
system generated id for the address
Y
assessmentid
character varying (256)
unique id of the assessment object
Y
unitid
character varying (64)
unique id of the unit
Y
usagecategory
character varying (256)
category of usages allowed for the property defined in the master
Y
occupancytype
character varying (64)
type of occupency - residential or commericial. will be validated with master data
Y
occupancydate
bigint
since when the occupancy of the unit started
Y
active
boolean
Whether the unit record is still active
Y
createdby
character varying (64)
username (preferred) or userid of the user that created the object
Y
createdtime
bigint
epoch of the time object is created
Y
lastmodifiedby
character varying (64)
username (preferred) or userid of the user that last modified the objectusername (preferred) or userid of the user that last modified the object
Y
lastmodifiedtime
bigint
epoch of the time object is modified last
Y
tenantid
Assessment.unitUsageList.*.tenantid
id
Assessment.unitUsageList.*.id
assessmentid
Assessment.unitUsageList.*.assessmentid
unitid
Assessment.unitUsageList.*.unitid
usagecategory
Assessment.unitUsageList.*.usagecategory
occupancytype
Assessment.unitUsageList.*.occupancytype
occupancydate
Assessment.unitUsageList.*.occupancydate
active
Assessment.unitUsageList.*.active
createdby
Assessment.unitUsageList.*.auditDetails.createdby
createdtime
Assessment.unitUsageList.*.auditDetails.createdtime
lastmodifiedby
Assessment.unitUsageList.*.auditDetails.lastmodifiedby
lastmodifiedtime
Assessment.unitUsageList.*.auditDetails.lastmodifiedtime
Document details relating to the assessment
id (PK)
character varying (128)
Unique identifier of the entity record
Y
tenantid (FK)
character varying (128)
Unique identifier for a tenant to which user primarily belongs
Y
entityid (FK)
character varying (128)
Id of the assessment
Y
documenttype
character varying (128)
unique document type code, should be validated with document type master
Y
filestoreid
character varying (128)
File store reference key
Y
documentuid
character varying (128)
The unique id (Pancard Number, Aadhar etc.) of the given document
Y
status
character varying (128)
status of the document , deleted documents will become INACTIVE
Y
createdby
character varying (128)
username (preferred) or userid of the user that created the object
Y
createdtime
bigint
epoch of the time object is created
Y
lastmodifiedby
character varying (128)
username (preferred) or userid of the user that last modified the object
Y
lastmodifiedtime
bigint
epoch of the time object is modified last
Y
id
Assessment.documents.*.id
tenantid
Assessment.documents.*.tenantid
entityid
Assessment.documents.*.entityid
documenttype
Assessment.documents.*.documenttype
filestoreid
Assessment.documents.*.filestoreid
documentuid
Assessment.documents.*.documentuid
status
Assessment.documents.*.status
createdby
Assessment.documents.*.additionalDetails.createdby
createdtime
Assessment.documents.*.additionalDetails.createdtime
lastmodifiedby
Assessment.documents.*.additionalDetails.lastmodifiedby
lastmodifiedtime
Assessment.documents.*.additionalDetails.lastmodifiedtime
Document details related to the property
id (PK)
character varying (128)
system id of the Document
Y
tenantid (FK)
character varying (128)
Unique identifier for a tenant to which user primarily belongs
Y
entityid (FK)
character varying (128)
id of the property
Y
documenttype
character varying (128)
unique document type code, should be validated with document type master
Y
filestoreid
character varying (128)
File store reference key
Y
documentuid
character varying (128)
The unique id(Pancard Number,Adhar etc.) of the given Document
Y
status
character varying (128)
status of the document , deleted documents will become INACTIVE
Y
createdby
character varying (128)
username (preferred) or userid of the user that created the object
Y
createdtime
bigint
epoch of the time object is created
Y
lastmodifiedby
character varying (128)
username (preferred) or userid of the user that last modified the object
Y
lastmodifiedtime
bigint
epoch of the time object is modified last
Y
id
Property.documents.*.id
tenantid
Property.documents.*.tenantid
entityid
Property.documents.*.entityid
documenttype
Property.documents.*.documenttype
filestoreid
Property.documents.*.filestoreid
documentuid
Property.documents.*.documentuid
status
Property.documents.*.status
createdby
Property.documents.*.auditDetails.createdby
createdtime
Property.documents.*.auditDetails.createdtime
lastmodifiedby
Property.documents.*.auditDetails.lastmodifiedby
lastmodifiedtime
Property.documents.*.auditDetails.lastmodifiedtime
Audit for eg_pt_asmt_unit_usage
tenantid
character varying (256)
Unique identifier for a tenant to which user primarily belongs
Y
id (PK)
character varying (256)
Unique identifier of the entity record
Y
assessmentid
character varying (256)
Unique identifier of the assessment identity record
Y
unitid
character varying (64)
unique uuid of the unit for which usage is being stated
Y
usagecategory
character varying (256)
category of usages allowed for the property defined in the master
Y
occupancytype
character varying (64)
type of occupancy - residential or commericial. will be validated with master data
Y
occupancydate
bigint
since when the occupancy of the unit started
Y
active
boolean
Whether the assessment is active or has become history
Y
createdby
character varying (64)
username (preferred) or userid of the user that created the object
Y
createdtime
bigint
epoch of the time object is created
Y
lastmodifiedby
character varying (64)
username (preferred) or userid of the user that last modified the object
Y
lastmodifiedtime
bigint
epoch of the time object is modified last
Y
auditcreatedtime
bigint
createdtime for the audit entry
Y
tenantid
Assessment.unitUsageList.*.tenantid
id
Assessment.unitUsageList.*.id
assessmentid
Assessment.unitUsageList.*.assessmentid
unitid
Assessment.unitUsageList.*.unitid
usagecategory
Assessment.unitUsageList.*.usagecategory
occupancytype
Assessment.unitUsageList.*.occupancytype
occupancydate
Assessment.unitUsageList.*.occupancydate
active
Assessment.unitUsageList.*.active
createdby
Assessment.unitUsageList.*.createdby
createdtime
Assessment.unitUsageList.*.createdtime
lastmodifiedby
Assessment.unitUsageList.*.lastmodifiedby
lastmodifiedtime
Assessment.unitUsageList.*.lastmodifiedtime
auditcreatedtime
Assessment.unitUsageList.*.auditcreatedtime
This table captures and stores the property assessment audit details.
id (PK)
character varying (256)
Unique identifier of the entity record
Y
tenantid
character varying (256)
tenant id of the Property
Y
assessmentnumber
character varying (64)
Assessment number alloted to the assessment record of the property
Y
financialyear
character varying (256)
Financial year for which the assessment generated
Y
propertyid
character varying (256)
unique id of the property which is being assessed
Y
status
character varying (64)
status of the assessment determining its validity - active or cancelled
Y
source
character varying (64)
device type from request is sent - PC, mobile
Y
channel
character varying (256)
channel through which entity is created, migrated, or updated
Y
assessmentdate
bigint
date on which assessment is done
Y
additionaldetails
jsonb
json field to collect undefined new fields
N
createdby
character varying (64)
username (preferred) or userid of the user that created the object
Y
createdtime
bigint
epoch of the time object is created
Y
lastmodifiedby
character varying (64)
username (preferred) or userid of the user that last modified the object
Y
lastmodifiedtime
bigint
epoch of the time object is modified last
Y
auditcreatedtime
bigint
epoch of the time object is created
Y
id
Assessment.id
tenantid
Assessment.tenantid
assessmentnumber
Assessment.assessmentnumber
financialyear
Assessment.financialyear
propertyid
Assessment.propertyid
status
Assessment.status
source
Assessment.source
channel
Assessment.channel
assessmentdate
Assessment.assessmentdate
additionaldetails
Assessment.additionaldetails
createdby
Assessment.auditDetails.createdby
createdtime
Assessment.auditDetails.createdtime
lastmodifiedby
Assessment.auditDetails.lastmodifiedby
lastmodifiedtime
Assessment.auditDetails.lastmodifiedtime
auditcreatedtime
Assessment.auditcreatedtime
The assessment set of services inside the property module is used for assessing the value of a property in a given time frame and collecting taxes for the same. Assessment is a snapshot of Property for a given transaction on that Property.
id (PK)
character varying (256)
Unique identifier of the entity record
Y
tenantid (Unique constraint)
character varying (256)
tenant id of the Property
Y
assessmentnumber (Unique constraint)
character varying (64)
Assessment number alloted to the assessment record of the property
Y
financialyear (can act as unique constraint when enabled by config)
character varying (256)
Financial year for which the assessment generated
Y
propertyid (can act as unique constraint when enabled by config)
character varying (256)
unique id of the property which is being assessed
Y
status
character varying (64)
status of the assessment determining its validity - active or cancelled
Y
source
character varying (64)
device type from request is sent - PC,mobile
Y
channel
character varying (256)
channel through which entity is created , like create,migration,update
Y
assessmentdate
bigint
date on which assessment is done in the applicaton
Y
additionaldetails
jsonb
json fields for undefined additional fields
N
createdby
character varying (64)
username (preferred) or userid of the user that created the object
Y
createdtime
bigint
epoch of the time object is created
Y
lastmodifiedby
character varying (64)
username (preferred) or userid of the user that last modified the object
Y
lastmodifiedtime
bigint
epoch of the time object is modified last
Y
id
Assessment.id
tenantid
Assessment.tenantid
assessmentnumber
Assessment.assessmentnumber
financialyear
Assessment.financialyear
propertyid
Assessment.propertyid
status
Assessment.status
source
Assessment.source
channel
Assessment.channel
assessmentdate
Assessment.assessmentdate
additionaldetails
Assessment.additionaldetails
createdby
Assessment.auditDetails.createdby
createdtime
Assessment.auditDetails.createdtime
lastmodifiedby
Assessment.auditDetails.lastmodifiedby
lastmodifiedtime
Assessment.auditDetails.lastmodifiedtime
The smallest undividable entity within a property - Independent property might have multiple units, apartments can themselves be only one unit at times.
Part or Portion of the Property (with clear demarcation) for which at least one of the property tax factors (Use, Occupancy, Structure category, Age etc) is different is called a unit of the property.
Units contain a unique combination of traits such as usage, ownership, occupancy, structure type etc. A combination of such units constitutes the property.
id (PK)
character varying (128)
Unique identifier of the unit record
Y
tenantid (PK)
character varying (256)
tenant id of the Property
Y
propertyid (FK)
character varying (128)
Unique identifier of the property record
Y
floorno
bigint
floor number of the Unit
Y
unittype
character varying (256)
Unit type is master data. example: Building, Room, Kitchen etc.
Y
usagecategory
character varying (2048)
This is about the usage of the property like Residential, Non-residential, Mixed(Property witch is gettiong used for Residential, Non-residential purpose)
Y
occupancytype
character varying (256)
Type of occupancy of the unit
Y
occupancydate
bigint
Date on which unit is occupied
Y
carpetarea
numeric (10,2)
Total built up area in sq ft(built-up area = carpet area + areas covered by walls)
Y
builtuparea
numeric (10,2)
Total built up area in sq ft(built-up area = carpet area + areas covered by walls)
Y
plintharea
numeric (10,2)
Area of the extension builtup of the Unit, Like balcony, sitouts.
Y
superbuiltuparea
numeric (10,2)
Total built up area in sq ft(built-up area + Common area = Super built-up area)
Y
arv
numeric (10,2)
Annual rental value of the unit
Y
constructiontype
character varying (1024)
Construction type is defined in MDMS ConstructionTypeMaster
N
constructiondate
bigint
The date when the property was constructed
N
dimensions
json
The dimensions of the plot or building or any unit
N
active
boolean
Whether the unit record is still active
Y
createdby
character varying (128)
username (preferred) or userid of the user that created the object
Y
createdtime
bigint
epoch of the time object is created
Y
lastmodifiedby
character varying (128)
username (preferred) or userid of the user that last modified the object
Y
lastmodifiedtime
bigint
epoch of the time object is modified last
Y
id
Property.units.*.id
tenantid
Property.units.*.tenantid
propertyid
Property.units.*.propertyid
floorno
Property.units.*.floorno
unittype
Property.units.*.unittype
usagecategory
Property.units.*.usagecategory
occupancytype
Property.units.*.occupancytype
occupancydate
Property.units.*.occupancydate
carpetarea
Property.units.*.constructionDetail.carpetarea
builtuparea
Property.units.*.constructionDetail.builtuparea
plintharea
Property.units.*.constructionDetail.plintharea
superbuiltuparea
Property.units.*.constructionDetail.superbuiltuparea
arv
Property.units.*.arv
constructiontype
Property.units.*.constructionDetail.constructiontype
constructiondate
Property.units.*.constructionDetail.constructiondate
dimensions
Property.units.*.constructionDetail.dimensions
active
Property.units.*.active
createdby
Property.units.*.additionalDetails.createdby
createdtime
Property.units.*.additionalDetails.createdtime
lastmodifiedby
Property.units.*.additionalDetails.lastmodifiedby
lastmodifiedtime
Property.units.*.additionalDetails.lastmodifiedtime
What is a No Objection Certificate (NoC)? No Objection Certificate, popularly abbreviated as NOC, is a type of legal certificate issued by any agency, organization, institute or, in certain cases, an individual. It does not object to the covenants of the certificate. The certification is a requirement at most government-based departments predominantly from the Indian subcontinent.
In India, there are different NoC documents that are issued by ULB, state or national level departments/organizations. Some of the NoC are listed below:
Why NoC? Value Proposition
Citizens
Save time and effort in visiting ULB to apply
Better interaction with ULB employees
Avoid inconvenience in the current manual process
State
Better citizen experience
Improve EoDB index
ULB Leadership
Transparency - review employee performance
Tighter control on the process
Field Employee
Worklist based prioritization of tasks
Citizens who are constructing a house or need a NOC for cracker trade or need NOC for setting up a shop in ULB grounds during the festive season and for many other reasons will apply for a fire no-objection certificate to the designated department and authorities.
A Clerk is an employee in a department whose job is to first level scrutiny of any application that is reaching ULB. He/She verifies the application checks for correctness and has the authority to ask for more information or forward to the next officer in a hierarchy or reject citing the reasons for rejection.
The Field inspector is responsible for inspecting the site where the construction or business or exhibition is supposed to happen. Validate the application and verify the by-laws. He / She has the authority to ask the applicant to make some modifications to comply with the rules or forward to the next officer in the hierarchy or reject citing the reasons for rejection.
The fire officer is responsible for issuing the NOC considering the recommendation of the Field inspector and the clerk. He/She can issue a NOC or reject the applications citing the reasons for rejection.
All content on this page by eGov Foundation is licensed under a Creative Commons Attribution 4.0 International License.
All content on this page by is licensed under a .
The Fire NOC module is used to provide NOC application services for approval from respective departments. NOC registry stores and serves the NOC related information using rest APIs.
This table contains the document details submitted by users for the fire NOC application.
uuid (PK)
varchar
The system generated unique id(UUID)
Y
tenantid
varchar
Unique identifier for a tenant to which user primarily belongs
Y
documenttype
varchar
type of document
Y
filestoreid
varchar
document filestore id
Y
active
boolean
boolean atribute to mark the details active/inactive
Y
documentuid
varchar
Document number
createdby
varchar
username (preferred) or userid of the user that created the object
Y
createdtime
int
username (preferred) or userid of the user that last modified the object
Y
lastmodifiedby
varchar
epoch of the time object is created
Y
lastmodifiedtime
int
epoch of the time object is modified last
Y
buildinguuid (FK)
varchar
Unique identifier of the building details
Y
uuid (PK)
FireNOCs.*.fireNOCDetails.buildings.*.applicationDocuments.*.id
tenantid
FireNOCs.*.tenantId
documenttype
FireNOCs.*.fireNOCDetails.buildings.*.applicationDocuments.*.documentType
filestoreid
FireNOCs.*.fireNOCDetails.buildings.*.applicationDocuments.*.fileStoreId
active
FireNOCs.*.fireNOCDetails.buildings.*.applicationDocuments.*.active
documentuid
FireNOCs.*.fireNOCDetails.buildings.*.applicationDocuments.*.documentUid
createdby
FireNOCs.*.auditDetails.createdBy
createdtime
FireNOCs.*.auditDetails.lastModifiedBy
lastmodifiedby
FireNOCs.*.auditDetails.createdTime
lastmodifiedtime
FireNOCs.*.auditDetails.lastModifiedTime
buildinguuid (FK)
FireNOCs.*.fireNOCDetails.buildings.*.id
This entity captures the institution detail from which the applicant seeks NOC.
uuid (PK)
varchar
The system generated unique id(UUID)
Y
tenantid
varchar
Unique identifier for a tenant to which user primarily belongs
N
firenocdetailsuuid (FK)
varchar
Unique Identifier of the Fire FireNOC Details (UUID)
Y
name
varchar
name of institute
N
type
varchar
type of insititute
N
designation
varchar
designation in institute
N
createdby
varchar
username (preferred) or userid of the user that created the object
Y
createdtime
int
username (preferred) or userid of the user that last modified the object
Y
lastmodifiedby
varchar
epoch of the time object is created
Y
lastmodifiedtime
int
epoch of the time object is modified last
Y
active
boolean
uuid (PK)
FireNOCs.*.fireNOCDetails.applicantDetails.additionalDetail.id
tenantid
FireNOCs.*.fireNOCDetails.applicantDetails.additionalDetail.tenantId
firenocdetailsuuid (FK)
FireNOCs.*.fireNOCDetails.id
name
FireNOCs.*.fireNOCDetails.applicantDetails.additionalDetail.name
type
FireNOCs.*.fireNOCDetails.applicantDetails.additionalDetail.type
designation
FireNOCs.*.fireNOCDetails.applicantDetails.additionalDetail.designation
createdby
FireNOCs.*.auditDetails.createdBy
createdtime
FireNOCs.*.auditDetails.lastModifiedBy
lastmodifiedby
FireNOCs.*.auditDetails.createdTime
lastmodifiedtime
FireNOCs.*.auditDetails.lastModifiedTime
active
This table contains the details of the building owner for which the fire NOC application is submitted.
uuid (PK)
varchar
The system generated unique id(UUID)
Y
tenantid
varchar
Unique identifier for a tenant to which user primarily belongs
Y
firenocdetailsuuid (FK)
varchar
Unique Identifier of the Fire FireNOC Details (UUID)
Y
isactive
boolean
boolean atribute to mark the details active/inactive
Y
isprimaryowner
boolean
The owner is primary or not
Y
ownertype
varchar
Type of owner, based on this option exemptions are applied. This is master data defined in mdms.
Y
ownershippercentage
varchar
Percentage of ownership of defined property
Y
relationship
varchar
Relationship of guardian with the owner
Y
active
boolean
Y
institutionid
varchar
Unique Identifier of the institute details
Y
createdby
varchar
username (preferred) or userid of the user that created the object
Y
createdtime
int
username (preferred) or userid of the user that last modified the object
Y
lastmodifiedby
varchar
epoch of the time object is created
Y
lastmodifiedtime
int
epoch of the time object is modified last
Y
useruuid
varchar
user uuid
Y
applicantcategory
varchar
owner category
Y
uuid (PK)
FireNOCs.*.fireNOCDetails.applicantDetails.owners.*.ownerUUID
tenantid
FireNOCs.*.fireNOCDetails.applicantDetails.owners.*.tenantId
firenocdetailsuuid (FK)
FireNOCs*.fireNOCDetails.id
isactive
FireNOCs.*.fireNOCDetails.applicantDetails.owners.*.isActive
isprimaryowner
FireNOCs.*.fireNOCDetails.applicantDetails.owners.*.isPrimaryOwner
ownertype
FireNOCs*.fireNOCDetails.applicantDetails.ownerShipType
ownershippercentage
FireNOCs.*.fireNOCDetails.applicantDetails.owners.*.ownerShipPercentage
relationship
FireNOCs.*.fireNOCDetails.applicantDetails.owners.*.relationship
active
FireNOCs.*.fireNOCDetails.applicantDetails.owners.*.active
institutionid
FireNOCs.*.fireNOCDetails.applicantDetails.additionalDetail.id
createdby
FireNOCs.*.auditDetails.createdBy
createdtime
FireNOCs.*.auditDetails.lastModifiedBy
lastmodifiedby
FireNOCs.*.auditDetails.createdTime
lastmodifiedtime
FireNOCs.*.auditDetails.lastModifiedTime
useruuid
FireNOCs.*.fireNOCDetails.applicantDetails.owners.*.uuid
applicantcategory
FireNOCs.*.fireNOCDetails.applicantDetails.owners.*.ownerType
This entity captures the fire NOC certificate details issued to the applicant.
uuid (PK)
varchar
Unique Identifier of the Fire FireNOC Details (UUID)
Y
firenocuuid (FK)
varchar
Unique Identifier of the Fire FireNOC
Y
applicationnumber
varchar
Unique Application FireNOC Number of the Fire FireNOC. This is unique in system for a tenant. This is mandatory but always be generated on the final approval.
Y
firenoctype
varchar
type of fire NOC from mdms
Y
firestationid
varchar
Fire station id where we are applying fire fireNOC.
Y
applicationdate
int
date on which applicaiton has been generated for new Fire NOC.
Y
financialyear
varchar
Fire NOC applicable for financial year.
Y
issueddate
int
License issued Date of the Fire NOC as epoch. 2. Application approval date.
v
validfrom
int
Date from when Fire NOC is valid as epoch
Y
validto
int
Expiry Date of the Fire NOC as epoch
Y
action
varchar
Workflow action on the application in certain
Y
channel
varchar
channel name
Y
noofbuildings
varchar
the attributestore value as string like single or multiple to denotes the number of buiding
Y
tenantid
varchar
Unique identifier for a tenant to which user primarily belongs
Y
additionaldetail
jsonb
Json object to capture any extra information which is not accommodated in the model
N
createdby
varchar
username (preferred) or userid of the user that created the object
Y
lastmodifiedby
varchar
username (preferred) or userid of the user that last modified the object
Y
createdtime
int
epoch of the time object is created
Y
lastmodifiedtime
int
epoch of the time object is modified last
Y
propertyid
varchar
property id of building
N
status
varchar
firenoc application status
Y
uuid (PK)
FireNOCs.*.fireNOCDetails.id
firenocuuid (FK)
FireNOCs.*.id
applicationnumber
FireNOCs.*.fireNOCDetails.applicationNumber
firenoctype
FireNOCs.*.fireNOCDetails.fireNOCType
firestationid
FireNOCs.*.fireNOCDetails.firestationId
applicationdate
FireNOCs.*.fireNOCDetails.applicationDate
financialyear
FireNOCs.*.fireNOCDetails.financialYear
issueddate
FireNOCs.*.fireNOCDetails.issuedDate
validfrom
FireNOCs.*.fireNOCDetails.validFrom
validto
FireNOCs.*.fireNOCDetails.validTo
action
FireNOCs.*.fireNOCDetails.action
channel
FireNOCs.*.fireNOCDetails.channel
noofbuildings
FireNOCs.*.fireNOCDetails.noOfBuildings
tenantid
FireNOCs.*.fireNOCDetails.tenantId
additionaldetail
FireNOCs.*.fireNOCDetails.additionalDetail
createdby
FireNOCs.*.auditDetails.createdBy
lastmodifiedby
FireNOCs.*.auditDetails.lastModifiedBy
createdtime
FireNOCs.*.auditDetails.createdTime
lastmodifiedtime
FireNOCs.*.auditDetails.lastModifiedTime
propertyid
FireNOCs.*.fireNOCDetails.propertyDetails.propertyid
status
FireNOCs.*.fireNOCDetails.status
This entity captures the fire NOC details.
uuid (PK)
varchar
The system generated unique id(UUID)
Y
tenantid
varchar
Unique identifier for a tenant to which user primarily belongs
Y
firenocnumber
varchar
Unique Fire NOC Number of the Fire NOC. This is unique in system for a tenant. This is mandatory but always be generated on the final approval.
Y
provisionfirenocnumber
varchar
Unique Fire NOC Number of the Provision Fire NOC number that will be used for linking provision fire NOC number with new fire NOC number. This is unique in system for a tenant. This is mandatory but always be generated on the final approval.
N
oldfirenocnumber
varchar
Unique Old License Number of the Fire NOC. This is unique in system for a tenant. This is mandatory for legacy license(DataEntry).
N
dateofapplied
varchar
Applied Date of the fire NOC as epoch
Y
createdby
varchar
username (preferred) or userid of the user that created the object
Y
lastmodifiedby
varchar
username (preferred) or userid of the user that last modified the object
Y
createdtime
int
epoch of the time object is created
Y
lastmodifiedtime
int
epoch of the time object is modified last
Y
uuid (PK)
FireNOCs.*.id
tenantidT
FireNOCs.*.tenantId
firenocnumber
FireNOCs.*.firenocnumber
provisionfirenocnumber
FireNOCs.*.provisionfirenocnumber
oldfirenocnumber
FireNOCs.*.oldfirenocnumber
dateofapplied
FireNOCs.*.dateofapplied
createdby
FireNOCs.*.auditDetails.createdBy
lastmodifiedby
FireNOCs.*.auditDetails.lastModifiedBy
createdtime
FireNOCs.*.auditDetails.createdTime
lastmodifiedtime
FireNOCs.*.auditDetails.lastModifiedTime
This entity captures the address details of the Fire NOC applicant.
uuid (PK)
varchar
The system generated unique id(UUID)
Y
tenantid
varchar
Unique Identifier of the tenant to which user primarily belongs
Y
doorno
varchar
House number or door number of the building of user
Y
latitude
int
The latitude location details of the user address
N
longitude
int
The longitude location details of the user address
N
buildingname
varchar
Name of the building
Y
addressid
varchar
System generated id for the address
Y
addressnumber
varchar
House, Door, Building number in the address
Y
type
varchar
address type
Y
addressline1
varchar
Apartment, Block, Street of the address
N
addressline2
varchar
Locality, Area, Zone, Ward of the address
N
landmark
varchar
Additional location detail to help find the address of user
N
street
varchar
Street name
Y
city
varchar
City of the address. It can be representated by the tenantid
N
locality
varchar
Locality of bulding
Y
pincode
varchar
PIN code of the address. Indian pincodes will usually be all numbers.
N
detail
varchar
more address detail as may be needed
N
firenocdetailsuuid (FK)
varchar
Unique Identifier of the Fire FireNOC Details (UUID)
Y
createdby
varchar
username (preferred) or userid of the user that created the object
Y
lastmodifiedby
varchar
username (preferred) or userid of the user that last modified the object
Y
createdtime
int
epoch of the time object is created
Y
lastmodifiedtime
int
epoch of the time object is modified last
Y
uuid (PK)T
FireNOCs.*.fireNOCDetails.propertyDetails.address.id
tenantid
FireNOCs.*.fireNOCDetails.propertyDetails.address.tenantId
doorno
FireNOCs.*.fireNOCDetails.propertyDetails.address.doorNo
latitude
FireNOCs.*.fireNOCDetails.propertyDetails.address.latitude
longitude
FireNOCs.*.fireNOCDetails.propertyDetails.address.longitude
buildingname
FireNOCs.*.fireNOCDetails.propertyDetails.address.buildingName
addressid
FireNOCs.*.fireNOCDetails.propertyDetails.address.addressId
addressnumber
FireNOCs.*.fireNOCDetails.propertyDetails.address.addressNumber
type
FireNOCs.*.fireNOCDetails.propertyDetails.address.type
addressline1
FireNOCs.*.fireNOCDetails.propertyDetails.address.addressline1
addressline2
FireNOCs.*.fireNOCDetails.propertyDetails.address.addressline1
landmark
FireNOCs.*.fireNOCDetails.propertyDetails.address.landmark
street
FireNOCs.*.fireNOCDetails.propertyDetails.address.street
city
FireNOCs.*.fireNOCDetails.propertyDetails.address.city
locality
FireNOCs.*.fireNOCDetails.propertyDetails.address.locality.code
pincode
FireNOCs.*.fireNOCDetails.propertyDetails.address.pincode
detail
FireNOCs.*.fireNOCDetails.propertyDetails.address.detail
firenocdetailsuuid (FK)
FireNOCs.*.fireNOCDetails.id
createdby
FireNOCs.*.auditDetails.createdBy
lastmodifiedby
FireNOCs.*.auditDetails.lastModifiedBy
createdtime
FireNOCs.*.auditDetails.createdTime
lastmodifiedtime
FireNOCs.*.auditDetails.lastModifiedTime
This entity captures the various attribute details of the building for which the NOC is applied.
uuid (PK)
varchar
The system generated unique id(UUID)
Y
firenocdetailsuuid (FK)
varchar
Unique Identifier of the Fire FireNOC Details (UUID)
Y
tenantid
varchar
Unique identifier for a tenant to which user primarily belongs
Y
name
varchar
name of building
Y
usagetype
varchar
building usage type
Y
createdby
varchar
username (preferred) or userid of the user that created the object
Y
lastmodifiedby
varchar
username (preferred) or userid of the user that last modified the object
Y
createdtime
int
epoch of the time object is created
Y
lastmodifiedtime
int
epoch of the time object is modified last
Y
active
boolean
boolean atribute to mark the details active/inactive
uuid (PK)
FireNOCs.*.fireNOCDetails.buildings.*.id
firenocdetailsuuid (FK)
FireNOCs[*][?({id} in @.fireNOCDetails.buildings[*].id)].fireNOCDetails.id
tenantid
FireNOCs.*.fireNOCDetails.buildings.*.tenantId
name
FireNOCs.*.fireNOCDetails.buildings.*.name
usagetype
FireNOCs.*.fireNOCDetails.buildings.*.usageType
createdby
FireNOCs[*][?({id} in @.fireNOCDetails.buildings[*].id)].auditDetails.createdBy
lastmodifiedby
FireNOCs[*][?({id} in @.fireNOCDetails.buildings[*].id)].auditDetails.lastModifiedBy
createdtime
FireNOCs[*][?({id} in @.fireNOCDetails.buildings[*].id)].auditDetails.createdTime
lastmodifiedtime
FireNOCs[*][?({id} in @.fireNOCDetails.buildings[*].id)].auditDetails.lastModifiedTime
active
eChallan or the mCollect system enables employees to generate the challans for Adhoc services so that the payment can be recorded into the system along with service-specific details.
This table store the challan details created by an employee for the ad-hoc services.
id (PK)
varchar
The system generated unique id(UUID)
Y
accountid
varchar
UUID of the user(citizen) requesting the service
Y
tenantid
varchar
Unique identifier for a tenant to which user primarily belongs
Y
challanNo
varchar
Unique ref Number for the Challan created
Y
businessService
varchar
The category for which the Challan is created
Y
referenceid
varchar
Unique identifier of the entity for which the challan is generated
N
applicationStatus
varchar
Challan status - Active, Expired and Cancelled
Y
additionalDetail
jsonb
Json object to capture any extra information which is not accommodated in the model
N
taxperiodFrom
int
Date range used for demand generation for the challan
Y
taxperiodTo
int
Date range used for demand generation for the challan
Y
createdby
varchar
username (preferred) or userid of the user that created the object
Y
lastmodifiedby
varchar
username (preferred) or userid of the user that last modified the object
Y
createdtime
int
epoch of the time object is created
Y
lastmodifiedtime
int
epoch of the time object is modified last
Y
filestoreid
varchar
Filestore id of challan pdf
N
description
varchar
Additional information or description of the challan
N
id (primary key)
$.Challan.id
accountid
$.Challan.citizen.uuid
tenantid
$.Challan.tenantId
challanNo
$.Challan.challanNo
businessService
$.Challan.businessService
referenceid
$.Challan.referenceId
applicationStatus
$.Challan.applicationStatus
additionalDetail
$.Challan.additionalDetail
taxperiodFrom
$.Challan.taxPeriodFrom
taxperiodTo
$.Challan.taxPeriodTo
createdby
$.Challan.auditDetails.createdBy
lastmodifiedby
$.Challan.auditDetails.lastModifiedBy
createdtime
$.Challan.auditDetails.createdTime
lastmodifiedtime
$.Challan.auditDetails.lastModifiedTime
filestoreid
$.Challan.filestoreid
description
$.Challan.description
This table stores the address details of the citizen (applicant) to whom challan is issued.
id (PK)
varchar
The system generated unique id(UUID)
Y
tenantid
varchar
Unique Identifier of the tenant to which user primarily belongs
Y
doorno
varchar
House number or door number of the building of user
N
plotno
varchar
Plot number of the house
N
latitude
FLOAT
The latitude location details of the user address
N
longitude
FLOAT
The longitude location details of the user address
N
buildingName
varchar
Name of the building
N
landmark
varchar
Additional location detail to help find the address of user
N
street
varchar
Street name
N
city
varchar
City of the address. It can be representated by the tenantid
N
district
varchar
The district of the address
N
region
varchar
The region where user resides
N
state
varchar
The State where user resides
N
country
varchar
Country of user
N
locality
varchar
Locality of user
Y
pincode
varchar
PIN code of the address. Indian pincodes will usually be all numbers.
N
detail
varchar
more address detail as may be needed
N
echallanid (FK)
varchar
Unique identifier of the challan
Y
createdby
varchar
username (preferred) or userid of the user that created the object
Y
lastmodifiedby
varchar
username (preferred) or userid of the user that last modified the object
Y
createdtime
int
epoch of the time object is created
Y
lastmodifiedtime
int
epoch of the time object is modified last
Y
id (primary key)
$.Challan.address.id
tenantid
$.Challan.address.tenantId
doorno
$.Challan.address.doorNo
plotno
$.Challan.address.plotNo
latitude
$.Challan.address.latitude
longitude
$.Challan.address.longitude
buildingName
$.Challan.address.buildingName
landmark
$.Challan.address.landmark
street
$.Challan.address.street
city
$.Challan.address.city
district
$.Challan.address.district
region
$.Challan.address.region
state
$.Challan.address.state
country
$.Challan.address.country
locality
$.Challan.address.locality.code
pincode
$.Challan.address.pincode
detail
$.Challan.address.detail
echallanid (foreign key)
$.Challan.id
createdby
$.Challan.auditDetails.createdBy
lastmodifiedby
$.Challan.auditDetails.lastModifiedBy
createdtime
$.Challan.auditDetails.createdTime
lastmodifiedtime
$.Challan.auditDetails.lastModifiedTime
The TL services are used to issue licenses to applicants after verification. The service is designed in such a way that it can be used to serve different types of licenses. Currently used to issue trade licenses, perform stakeholder registration and issue lockdown passes. The service is integrated with configurable workflows that define the steps for approval of the application.
This entity captures the accessory details required for the applied trade.
This entity captures the trade institution details for the applied trade license.
This entity captures the trade license application details.
This entity captures the trade license application audit details.
This entity captures the trade establishment owner details provided in the trade license application.
This entity captures and stores the trade establishment address details furnished in the trade license application.
<!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}-->
This entity captures and stores the supporting documents uploaded by the trade license applicant.
Stores information about the owner of the document used for issuing the trade license.
When the trade license is edited, the old entry is stored in the audit table. Maintains the transaction history.
Stores information about the unit used for accessories in the trade.
Stores the primary information about trade licenses like application number, trade license number, financial year and status.
Stores the document details of the document used for verification.
All content on this page by eGov Foundation is licensed under a Creative Commons Attribution 4.0 International License.
All content on this page by eGov Foundation is licensed under a Creative Commons Attribution 4.0 International License.
All content on this page by is licensed under a .
id (PK)
character varying (64)
unique id of the accessory
Y
tenantid
character varying (64)
tenantid of the trade license
Y
accessorycategory
character varying (64)
a code for the accessory category
Y
uom
character varying (64)
unit of measurement
Y
uomvalue
character varying (64)
value of unit of measurement
Y
tradelicensedetailid (FK)
character varying (64)
unique id of tradelicense details
Y
active
boolean
whether the accessory is active
Y
createdby
character varying (64)
user id of user who created the accessory
N
lastmodifiedby
character varying (64)
user id of user who last modified the accessory
N
createdtime
bigint
epoch for time on which accessory was created
N
lastmodifiedtime
bigint
epoch for time on which accessory was last modified
N
count
integer
how many such accessories are required
Y
id
Licenses.*.tradeLicenseDetail.accessories.*.id
tenantid
Licenses.*.tradeLicenseDetail.accessories.*.tenantId
accessorycategory
Licenses.*.tradeLicenseDetail.accessories.*.accessoryCategory
uom
Licenses.*.tradeLicenseDetail.accessories.*.uom
uomvalue
Licenses.*.tradeLicenseDetail.accessories.*.uomValue
tradelicensedetailid
Licenses[*][?({id} in @.tradeLicenseDetail.accessories[*].id)].tradeLicenseDetail.id
active
Licenses.*.tradeLicenseDetail.accessories.*.active
createdby
Licenses[*][?({id} in @.tradeLicenseDetail.accessories[*].id)].auditDetails.createdBy
lastmodifiedby
Licenses[*][?({id} in @.tradeLicenseDetail.accessories[*].id)].auditDetails.lastModifiedBy
createdtime
Licenses[*][?({id} in @.tradeLicenseDetail.accessories[*].id)].auditDetails.createdTime
lastmodifiedtime
Licenses[*][?({id} in @.tradeLicenseDetail.accessories[*].id)].auditDetails.lastModifiedTime
count
tenantid
character varying (256)
unique id for the tenant in whcih trade is set up
Y
id (PK)
character varying (64)
unique id for the institution
Y
tradelicensedetailid (FK)
character varying (64)
unique id for the tradelicense detail
Y
name
character varying (64)
name of the trade
Y
type
character varying (64)
type of trade
Y
designation
character varying (64)
createdby
character varying (64)
user id of user who created the application
Y
lastmodifiedby
bigint
user id of user who last modified the application
Y
createdtime
character varying (64)
epoch for time on which application was created
Y
lastmodifiedtime
bigint
epoch for time on which application was last modified
Y
active
boolean
whether trade is active
Y
institutionname
character varying (250)
name of institution
Y
contactno
character varying (50)
contact number of the institution
Y
organizationregistrationno
character varying (50)
unique registration number for the institution
Y
address
character varying (512)
address of the institution
Y
tenantid
Licenses.*.tradeLicenseDetail.institution.tenantId
id
Licenses.*.tradeLicenseDetail.institution.id
tradelicensedetailid
Licenses.*.tradeLicenseDetail.id
name
Licenses.*.tradeLicenseDetail.institution.name
type
Licenses.*.tradeLicenseDetail.institution.type
designation
Licenses.*.tradeLicenseDetail.institution.designation
createdby
Licenses.*.auditDetails.createdBy
lastmodifiedby
Licenses.*.auditDetails.lastModifiedBy
createdtime
Licenses.*.auditDetails.createdTime
lastmodifiedtime
Licenses.*.auditDetails.lastModifiedTime
active
Licenses.*.tradeLicenseDetail.institution.active
institutionname
contactno
organizationregistrationno
address
id (PK)
character varying (64)
unique id for the tradelicense details
Y
surveyno
character varying (64)
subownershipcategory
character varying (64)
ownership category
Y
channel
character varying (64)
additionaldetail
jsonb
any additional details
N
tradelicenseid (FK)
character varying (256)
unique id of the tradelicense
Y
createdby
character varying (64)
user id of user who created the application
Y
lastmodifiedby
character varying (64)
user id of user who last modified the application
Y
createdtime
bigint
epoch for time on which application was created
Y
lastmodifiedtime
bigint
epoch for time on which application was last modified
Y
noofemployees
integer
number of employees in the trade
N
structuretype
character varying (64)
type of structure (kutcha, pakka)
Y
adhocexemption
numeric (12, 2)
adhocpenalty
numeric (12, 2)
adhocexemptionreason
character varying (1024)
adhocpenaltyreason
character varying (1024)
id
Licenses.*.tradeLicenseDetail.id
surveyno
Licenses.*.tradeLicenseDetail.surveyNo
subownershipcategory
Licenses.*.tradeLicenseDetail.subOwnerShipCategory
channel
Licenses.*.tradeLicenseDetail.channel
additionaldetail
Licenses.*.tradeLicenseDetail.additionalDetail
tradelicenseid
Licenses.*.id
createdby
Licenses.*.auditDetails.createdBy
lastmodifiedby
Licenses.*.auditDetails.lastModifiedBy
createdtime
Licenses.*.auditDetails.createdTime
lastmodifiedtime
Licenses.*.auditDetails.lastModifiedTime
noofemployees
Licenses.*.tradeLicenseDetail.noOfEmployees
structuretype
Licenses.*.tradeLicenseDetail.structureType
adhocexemption
Licenses.*.tradeLicenseDetail.adhocExemption
adhocpenalty
Licenses.*.tradeLicenseDetail.adhocPenalty
adhocexemptionreason
Licenses.*.tradeLicenseDetail.adhocExemptionReason
adhocpenaltyreason
Licenses.*.tradeLicenseDetail.adhocPenaltyReason
id (PK)
character varying(64)
unique id of the tradelicense audit
Y
surveyno
character varying(64)
subownershipcategory
character varying(64)
owners category
Y
channel
character varying(64)
additionaldetail
jsonb
any additional details
N
tradelicenseid (FK)
character varying(256)
unique id of the tradelicensedetail
Y
createdby
character varying(64)
user id of user who created the application
Y
lastmodifiedby
character varying(64)
user id of user who last modified the application
Y
createdtime
bigint
epoch for time on which application was created
Y
lastmodifiedtime
bigint
epoch for time on which application was last modified
Y
noofemployees
integer
number of employees in the trade
N
structuretype
character varying(64)
type of structure (kutcha, pakka)
Y
adhocexemption
numeric(12, 2)
adhocpenalty
numeric(12, 2)
adhocexemptionreason
character varying(1024)
adhocpenaltyreason
character varying(1024)
id
Licenses.*.tradeLicenseDetail.id
surveyno
Licenses.*.tradeLicenseDetail.surveyNo
subownershipcategory
Licenses.*.tradeLicenseDetail.subOwnerShipCategory
channel
Licenses.*.tradeLicenseDetail.channel
additionaldetail
Licenses.*.tradeLicenseDetail.additionalDetail
tradelicenseid
Licenses.*.id
createdby
Licenses.*.auditDetails.createdBy
lastmodifiedby
Licenses.*.auditDetails.lastModifiedBy
createdtime
Licenses.*.auditDetails.createdTime
lastmodifiedtime
Licenses.*.auditDetails.lastModifiedTime
noofemployees
Licenses.*.tradeLicenseDetail.noOfEmployees
structuretype
Licenses.*.tradeLicenseDetail.structureType
adhocexemption
Licenses.*.tradeLicenseDetail.adhocExemption
adhocpenalty
Licenses.*.tradeLicenseDetail.adhocPenalty
adhocexemptionreason
Licenses.*.tradeLicenseDetail.adhocExemptionReason
adhocpenaltyreason
Licenses.*.tradeLicenseDetail.adhocPenaltyReason
id (PK)
character varying(64)
uuid of the owner
Y
tenantid
character varying(256)
tenant id of the owner
Y
tradelicensedetailid (FK)
character varying(64)
id of the tradelicense details
Y
isactive
boolean
whether owner is active
Y
isprimaryowner
boolean
whether owner is primary
Y
ownertype
character varying(64)
type of owner(single, multiple)
Y
ownershippercentage
character varying(64)
percentage of ownership
N
relationship
character varying(64)
guardian relation
N
active
boolean
whether guardian is active
Y
institutionid
character varying(64)
id of institution, in case of institutional owners
N
createdby
character varying(64)
user id of user who created owner
Y
createdtime
bigint
time when owner was created
Y
lastmodifiedby
character varying(64)
user id of user who last modified owner
Y
lastmodifiedtime
bigint
time when owner was last modified
Y
id
Licenses.*.tradeLicenseDetail.owners.*.uuid
tenantid
Licenses.*.tradeLicenseDetail.owners.*.tenantId
tradelicensedetailid
Licenses[*][?({id} in @.tradeLicenseDetail.owners[*].id)].tradeLicenseDetail.id
isactive
Licenses.*.tradeLicenseDetail.owners.*.userActive
isprimaryowner
Licenses.*.tradeLicenseDetail.owners.*.isPrimaryOwner
ownertype
Licenses.*.tradeLicenseDetail.owners.*.ownerType
ownershippercentage
Licenses.*.tradeLicenseDetail.owners.*.ownerShipPercentage
relationship
Licenses.*.tradeLicenseDetail.owners.*.relationship
active
Licenses.*.tradeLicenseDetail.owners.*.userActive
institutionid
createdby
Licenses[*][?({id} in @.tradeLicenseDetail.owners[*].id)].auditDetails.createdBy
createdtime
Licenses[*][?({id} in @.tradeLicenseDetail.owners[*].id)].auditDetails.createdTime
lastmodifiedby
Licenses[*][?({id} in @.tradeLicenseDetail.owners[*].id)].auditDetails.lastModifiedBy
lastmodifiedtime
Licenses[*][?({id} in @.tradeLicenseDetail.owners[*].id)].auditDetails.lastModifiedTime
id (PK)
character varying(64)
unique id of the address object
Y
tenantid
character varying(64)
tenant id of the location
Y
doorno
character varying(64)
door number
N
buildingname
character varying(64)
building name
N
addressid
character varying(64)
addressnumber
character varying(64)
type
character varying(64)
addressline1
text
full address
N
addressline2
character varying(256)
full address
N
landmark
character varying(64)
any landmark
N
street
character varying(64)
Street name/ number
N
city
character varying(64)
city name
Y
locality
character varying(64)
locality name
Y
pincode
character varying(64)
pincode
N
detail
character varying(64)
other details
N
tradelicensedetailid (FK)
character varying(64)
id of the tradelicense details
Y
createdby
character varying(64)
user who created the address
Y
lastmodifiedby
character varying(64)
user who last modified the address
Y
createdtime
bigint
time when address was created
Y
lastmodifiedtime
bigint
time when address was last modified
Y
id
Licenses.*.tradeLicenseDetail.address.id
tenantid
Licenses.*.tradeLicenseDetail.address.tenantId
doorno
Licenses.*.tradeLicenseDetail.address.doorNo
buildingname
Licenses.*.tradeLicenseDetail.address.buildingName
addressid
Licenses.*.tradeLicenseDetail.address.addressId
addressnumber
Licenses.*.tradeLicenseDetail.address.addressNumber
type
Licenses.*.tradeLicenseDetail.address.type
addressline1
Licenses.*.tradeLicenseDetail.address.addressline1
addressline2
Licenses.*.tradeLicenseDetail.address.addressline2
landmark
Licenses.*.tradeLicenseDetail.address.landmark
street
Licenses.*.tradeLicenseDetail.address.street
city
Licenses.*.tradeLicenseDetail.address.city
locality
Licenses.*.tradeLicenseDetail.address.locality.code
pincode
Licenses.*.tradeLicenseDetail.address.pincode
detail
Licenses.*.tradeLicenseDetail.address.detail
tradelicensedetailid
Licenses.*.tradeLicenseDetail.id
createdby
Licenses.*.auditDetails.createdBy
lastmodifiedby
Licenses.*.auditDetails.lastModifiedBy
createdtime
Licenses.*.auditDetails.createdTime
lastmodifiedtime
Licenses.*.auditDetails.lastModifiedTime
id (PK)
character varying(64)
unique id of the application document
Y
tenantid
character varying(64)
tenant id of the trade license
Y
documenttype
character varying(64)
type of document (id proof, address proof etc)
Y
filestoreid
character varying(64)
id of the document media files
N
tradecategorydetail
character varying(64)
Trade category (good or services)
N
tradelicensedetailid (FK)
character varying(64)
Unique id for the trade license details
N
active
boolean
Whether trade is active or not
N
createdby
character varying(64)
user id of user who created the document
N
lastmodifiedby
character varying(64)
user id of user who last modified the document
N
createdtime
bigint
epoch for time on which document was created
N
lastmodifiedtime
bigint
epoch for time on which document was last modified
N
id
Licenses.*.tradeLicenseDetail.applicationDocuments.*.id
tenantid
Licenses.*.tradeLicenseDetail.applicationDocuments.*.tenantId
documenttype
Licenses.*.tradeLicenseDetail.applicationDocuments.*.documentType
filestoreid
Licenses.*.tradeLicenseDetail.applicationDocuments.*.fileStoreId
tradecategorydetail
Licenses.*.tradeLicenseDetail.applicationDocuments.*.tradecategorydetail
tradelicensedetailid
Licenses[*][?({id} in @.tradeLicenseDetail.applicationDocuments[*].id)].tradeLicenseDetail.id
active
Licenses.*.tradeLicenseDetail.applicationDocuments.*.active
createdby
Licenses[*][?({id} in @.tradeLicenseDetail.applicationDocuments[*].id)].auditDetails.createdBy
lastmodifiedby
Licenses[*][?({id} in @.tradeLicenseDetail.applicationDocuments[*].id)].auditDetails.lastModifiedBy
createdtime
Licenses[*][?({id} in @.tradeLicenseDetail.applicationDocuments[*].id)].auditDetails.createdTime
lastmodifiedtime
Licenses[*][?({id} in @.tradeLicenseDetail.applicationDocuments[*].id)].auditDetails.lastModifiedTime
tenantid
character varying(256)
tenant id of the document owner
Y
id (PK)
character varying(64)
unique id of document owner
Y
tradelicensedetailid (FK)
character varying(64)
unique id of tradelicense detail
Y
userid (FK)
character varying(128)
uuid of the owner
Y
documenttype
character varying(64)
type of document
Y
filestoreid
character varying(64)
id of document media files
N
active
boolean
whether document owner is active
Y
documentuid
character varying(64)
unique uuid for the document
Y
createdby
character varying(64)
user id of user who created owner
Y
createdtime
bigint
time when owner was created
Y
lastmodifiedby
character varying(64)
user id of user who last modified owner
Y
lastmodifiedtime
bigint
time when owner was last modified
Y
tenantid
Licenses[*][?({id} in @.tradeLicenseDetail.owners.*.documents[*].id)].tenantId
id
Licenses.*.tradeLicenseDetail.owners.*.documents.*.id
tradelicensedetailid
Licenses[*][?({id} in @.tradeLicenseDetail.owners.*.documents[*].id)].tradeLicenseDetail.id
userid
Licenses.*.tradeLicenseDetail.owners[*][?({id} in @.documents[*].id)].uuid
documenttype
Licenses.*.tradeLicenseDetail.owners.*.documents.*.documentType
filestoreid
Licenses.*.tradeLicenseDetail.owners.*.documents.*.fileStoreId
active
Licenses.*.tradeLicenseDetail.owners.*.documents.*.active
documentuid
Licenses.*.tradeLicenseDetail.owners.*.documents.*.documentUid
createdby
Licenses[*][?({id} in @.tradeLicenseDetail.owners.*.documents[*].id)].auditDetails.createdBy
createdtime
Licenses[*][?({id} in @.tradeLicenseDetail.owners.*.documents[*].id)].auditDetails.createdTime
lastmodifiedby
Licenses[*][?({id} in @.tradeLicenseDetail.owners.*.documents[*].id)].auditDetails.lastModifiedBy
lastmodifiedtime
Licenses[*][?({id} in @.tradeLicenseDetail.owners.*.documents[*].id)].auditDetails.lastModifiedTime
id
character varying(64)
unique id for trade license audit
Y
accountid
character varying(64)
uuid of the user who created the application
N
tenantid
character varying(64)
tenant id of the trade license
Y
licensetype
character varying(64)
type of trade (permanent, temporary)
Y
licensenumber
character varying(64)
unique number of the license
Y
applicationnumber
character varying(64)
unique number of the application
Y
oldlicensenumber
character varying(64)
old license number, if expired
N
propertyid
character varying(256)
N
oldpropertyid
character varying(64)
N
applicationdate
bigint
date on which application was created
Y
commencementdate
bigint
Date on which trade started
Y
issueddate
bigint
Date on which license issued
Y
financialyear
character varying(64)
Financial year during which applicaation is valid
Y
validfrom
bigint
epoch for time from which application is valid
Y
validto
bigint
epoch for time upto which application is valid
Y
action
character varying(64)
action which was taken on the application
Y
status
character varying(64)
current status of the application
Y
createdby
character varying(64)
user id of user who created the application
Y
lastmodifiedby
character varying(64)
user id of user who last modified the application
Y
createdtime
bigint
epoch for time on which application was created
Y
lastmodifiedtime
bigint
epoch for time on which application was last modified
Y
tradename
character varying(256)
name of the trade
Y
businessservice
character varying(64)
name of the business service (TL)
Y
applicationtype
character varying(64)
type of application (new or renewal)
Y
workflowcode
character varying(64)
new or edit renewal or direct renewal
Y
filestoreid
character varying(256)
id of the validation document media files
N
id
Licenses.*.id
accountid
Licenses.*.accountId
tenantid
Licenses.*.tenantId
licensetype
Licenses.*.licenseType
licensenumber
Licenses.*.licenseNumber
applicationnumber
Licenses.*.applicationNumber
oldlicensenumber
Licenses.*.oldLicenseNumber
propertyid
oldpropertyid
applicationdate
Licenses.*.applicationDate
commencementdate
Licenses.*.commencementDate
issueddate
Licenses.*.issuedDate
financialyear
Licenses.*.financialYear
validfrom
Licenses.*.validFrom
validto
Licenses.*.validTo
action
Licenses.*.action
status
Licenses.*.status
createdby
Licenses.*.auditDetails.createdBy
lastmodifiedby
Licenses.*.auditDetails.lastModifiedBy
createdtime
Licenses.*.auditDetails.createdTime
lastmodifiedtime
Licenses.*.auditDetails.lastModifiedTime
tradename
Licenses.*.tradeName
businessservice
Licenses.*.businessService
applicationtype
Licenses.*.applicationType
workflowcode
Licenses.*.workflowCode
filestoreid
Licenses.*.fileStoreId
id (PK)
character varying(64)
Unique id for the trade unit
Y
tenantid
character varying(64)
Tenant id of the license
Y
tradetype
character varying(64)
Type of trade (goods, services etc)
Y
uom
character varying(64)
Unit of measurement
N
uomvalue
character varying(64)
Value of unit of measurement
N
tradelicensedetailid (FK)
character varying(64)
Unique id for trade license details
Y
active
boolean
Whether the trade unit is active
Y
createdby
character varying(64)
User id of user who created the unit
N
lastmodifiedby
character varying(64)
User id of user who last modified the unit
N
createdtime
bigint
epoch for the time on which unit was created
N
lastmodifiedtime
bigint
epoch for the time on which unit was last modified
N
id
Licenses.*.tradeLicenseDetail.tradeUnits.*.id
tenantid
Licenses.*.tradeLicenseDetail.tradeUnits.*.tenantId
tradetype
Licenses.*.tradeLicenseDetail.tradeUnits.*.tradeType
uom
Licenses.*.tradeLicenseDetail.tradeUnits.*.uom
uomvalue
Licenses.*.tradeLicenseDetail.tradeUnits.*.uomValue
tradelicensedetailid
Licenses[*][?({id} in @.tradeLicenseDetail.tradeUnits[*].id)].tradeLicenseDetail.id
active
Licenses.*.tradeLicenseDetail.tradeUnits.*.active
createdby
Licenses[*][?({id} in @.tradeLicenseDetail.tradeUnits[*].id)].auditDetails.createdBy
lastmodifiedby
Licenses[*][?({id} in @.tradeLicenseDetail.tradeUnits[*].id)].auditDetails.lastModifiedBy
createdtime
Licenses[*][?({id} in @.tradeLicenseDetail.tradeUnits[*].id)].auditDetails.createdTime
lastmodifiedtime
Licenses[*][?({id} in @.tradeLicenseDetail.tradeUnits[*].id)].auditDetails.lastModifiedTime
id
character varying(64)
System generated id for the trade license
Y
accountid
character varying(64)
uuid of the user who created the application
Y
tenantid
character varying(64)
Unique identifier for the city in which trade is set up
Y
licensetype
character varying(64)
Permanent or temporary set up
Y
licensenumber
character varying(64)
Unique license number generated by system
Y
applicationnumber
character varying(64)
Unique application number generated by the syatem
Y
oldlicensenumber
character varying(64)
Old license number, in case of expired licenses
N
propertyid
character varying(256)
N
oldpropertyid
character varying(64)
N
applicationdate
bigint
Date on which application created
Y
commencementdate
bigint
Date on which trade started
Y
issueddate
bigint
Date on which license issued
Y
financialyear
character varying(64)
Financial year during which applicaation is valid
Y
validfrom
bigint
epoch for time from which application is valid
Y
validto
bigint
epoch for time upto which application is valid
Y
action
character varying(64)
action which was taken on the application
Y
status
character varying(64)
current status of the application
Y
createdby
character varying(64)
user id of user who created the application
Y
lastmodifiedby
character varying(64)
user id of user who last modified the application
Y
createdtime
bigint
epoch for time on which application was created
Y
lastmodifiedtime
bigint
epoch for time on which application was last modified
Y
tradename
character varying(256)
name of the trade
Y
businessservice
character varying(64)
name of the business service (TL)
Y
applicationtype
character varying(64)
type of application (new or renewal)