Property Tax Data Model
Last updated
Was this helpful?
Last updated
Was this helpful?
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
All content on this page by is licensed under a .
