Property Tax Data Model
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
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
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
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
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
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
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
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
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
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
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 |
lastmodifiedtime | Assessment.unitUsageList.*.lastmodifiedtime |
auditcreatedtime | Assessment.unitUsageList.*.auditcreatedtime |
eg_pt_asmt_assessment_audit
This table captures and stores the property assessment audit details.
| Attribute Name | Data Type | Definition | Mandatory (Y/N) |
|---|---|---|---|
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 |
| Attribute Name | Mapping Details |
|---|---|
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 |
eg_pt_asmt_assessment
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.
| Attribute Name | Data Type | Definition | Mandatory (Y/N) |
|---|---|---|---|
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 |
| Attribute Name | Mapping Details |
|---|---|
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 |
eg_pt_unit
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.
| Attribute Name | Data Type | Definition | Mandatory (Y/N) |
|---|---|---|---|
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 |
| Attribute Name | Mapping Details |
|---|---|
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 |
Mapping Constructs
Last updated
