Search…
⌃K

Property Tax Data Model Specs

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.

PT Service Entity Details

Data Constructs

eg_pt_property

Description
Attributes
Mapping
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.
Attribute Name
Data Type
Definition
Mandatory (Y/N)
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
Attribute Name
Mapping Details
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

eg_pt_address

Description
Attributes
Mapping
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.
Attribute Name
Data Type
Definition
Mandatory (Y/N)
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
Attribute Name
Mapping Details
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

eg_pt_institution

Description
Attributes
Mapping
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.
Attribute Name
Data Type
Definition
Mandatory (Y/N)
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
Attribute Name
Mapping Details
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

eg_pt_property_migration

Description
Attributes
Mapping
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.
Attribute Name
Data Type
Definition
Mandatory (Y/N)
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
Attribute Name
Mapping Details
id
Property.id
batch
Property.batch
batchsize
Property.batchsize
createdtime
Property.createdtime
tenantid
Property.tenantid
recordcount
Property.recordcount

eg_pt_property_audit

Description
Attributes
Mapping
This entity captures all audit-related details for the property table.
Attribute Name
Data Type
Definition
Mandatory (Y/N)
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
Attribute Name
Mapping Details
audituuid
Property.audituuid
propertyid
Property.propertyid
property
Property.property
auditcreatedtime
Property.auditcreatedtime

eg_pt_owner

Description
Attributes
Mapping
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.
Attribute Name
Data Type
Definition
Mandatory (Y/N)
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
Attribute Name
Mapping Details
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

eg_pt_asmt_unitusage

Description
Attributes
Mapping
The purpose for which the unit is put to use.
Attribute Name
Data Type
Definition
Mandatory (Y/N)
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
Attribute Name
Mapping Details
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

eg_pt_asmt_document

Description
Attributes
Mapping
Document details relating to the assessment
Attribute Name
Data Type
Definition
Mandatory (Y/N)
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
Attribute Name
Mapping Details
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

eg_pt_document

Description
Attributes
Mapping
Document details related to the property
Attribute Name
Data Type
Definition
Mandatory (Y/N)
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
Attribute Name
Mapping Details
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

eg_pt_unitusage_audit

Description
Attributes
Mapping
Audit for eg_pt_asmt_unit_usage
Attribute Name
Data Type
Definition
Mandatory (Y/N)
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
Attribute Name
Mapping Details
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