Search…
⌃K

OBPS Data Model Specs

The module is used to apply for Building Plan Approval, Building Plan Occupancy Certificate, DCR Plan Scrutiny and Permits.

OBPS Services Entity Details

bpa-services

land-services

noc-services

Data Constructs

eg_bpa_buildingplan

Description
Attributes
Mapping
Stores primary information like application number, EDCR number, date etc.. for the plot/site building permit and occupancy certificate applications.
Attribute Name
Data Type
Definition
Mandatory (Y/N)
id (PK)
character varying (256)
The system generated unique id(UUID)
Y
applicationno
character varying (64)
Unique identifier to identify an application and shared with applicant
Y
tenantid
character varying (256)
TenantID to identify application submitted for the which city
Y
edcrnumber
character varying (64)
Plan scrutiny number is to identify for which plan permit/occupancy certificate is applied
Y
status
character varying (64)
To know status of the application
Y
landid
character varying (256)
Unique identifier for land details
Y
additionaldetails
jsonb
Json object to capture any extra information which is not accommodated in the model
N
createdby
character varying (64)
username (preferred) or userid of the user that created the object
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
createdtime
bigint
epoch of the time object is created
Y
approvalno
character varying (64)
Unique identifier for the application approved
Y
approvaldate
bigint
epoch of the time object of application approved
Y
applicationdate
bigint
epoch of the time object of application created
Y
businessservice
character varying (64)
name of the business service
Y
accountid
character varying (256)
uuid of the user who created the application
Y
Attribute Name
Mapping Details
id (PK)
BPA.id
applicationno
BPA.applicationno
tenantid
BPA.tenantid
edcrnumber
BPA.edcrnumber
status
BPA.status
landid
BPA.landid
additionaldetails
BPA.additionaldetails
createdby
BPA.createdby
lastmodifiedby
BPA.lastmodifiedby
lastmodifiedtime
BPA.lastmodifiedtime
createdtime
BPA.createdtime
approvalno
BPA.approvalno
approvaldate
BPA.approvaldate
applicationdate
BPA.applicationdate
businessservice
BPA.businessservice
accountid
BPA.accountid

eg_bpa_auditdetails

Description
Attributes
Mapping
Attribute Name
Data Type
Definition
Mandatory (Y/N)
id
character varying (256)
The system generated unique id(UUID)
Y
applicationno
character varying (64)
Unique identifier to identify an application and shared with applicant
Y
tenantid
character varying (256)
TenantID to identify application submitted for the which city
Y
edcrnumber
character varying (64)
Plan scrutiny number is to identify for which plan permit/occupancy certificate is applied
Y
status
character varying (64)
To know status of the application
Y
landid
character varying (256)
Unique identifier for land details
Y
additionaldetails
jsonb
Json object to capture any extra information which is not accommodated in the model
N
createdby
character varying (64)
username (preferred) or userid of the user that created the object
Y
lastmodifiedby
character varying (64)
username (preferred) or userid of the user that last modified the object
Y
createdtime
bigint
epoch of the time object is modified last
lastmodifiedtime
bigint
epoch of the time object is created
Y
approvalno
character varying (64)
Unique identifier for the application approved
Y
approvaldate
bigint
epoch of the time object of application approved
Y
applicationdate
bigint
epoch of the time object of application created
Y
businessservice
character varying (64)
name of the business service
Y
accountid
character varying (256)
uuid of the user who created the application
Y
Attribute Name
Mapping Details
id
BPA.id
applicationno
BPA.applicationno
tenantid
BPA.tenantid
edcrnumber
BPA.edcrnumber
status
BPA.status
landid
BPA.landid
additionaldetails
BPA.additionaldetails
createdby
BPA.createdby
lastmodifiedby
BPA.lastmodifiedby
createdtime
BPA.createdtime
lastmodifiedtime
BPA.lastmodifiedtime
approvalno
BPA.approvalno
approvaldate
BPA.approvaldate
applicationdate
BPA.applicationdate
businessservice
BPA.businessservice
accountid
BPA.accountid

eg_bpa_document

Description
Attributes
Mapping
Stores BPA application uploaded document details
Attribute Name
Data Type
Definition
Mandatory (Y/N)
id (PK)
character varying (64)
The system generated unique id(UUID)
Y
documenttype
character varying (64)
Name of the document type
Y
filestoreid
character varying (64)
The filestore UUID
Y
documentuid
character varying (64)
Unique identifier of document
N
buildingplanid (FK)
character varying (64)
The ID of building plan
Y
additionaldetails
jsonb
Json object to capture any extra information which is not accommodated in the model
N
createdby
character varying (64)
username (preferred) or userid of the user that created the object
Y
lastmodifiedby
character varying (64)
username (preferred) or userid of the user that last modified the object
Y
createdtime
bigint
epoch of the time object is modified last
Y
lastmodifiedtime
bigint
epoch of the time object is created
Y
Attribute Name
Mapping Details
id (PK)
BPA.documents.*.id
documenttype
BPA.documents.*.documenttype
filestoreid
BPA.documents.*.filestoreid
documentuid
BPA.documents.*.documentuid
buildingplanid (FK)
BPA.documents.*.buildingplanid
additionaldetails
BPA.documents.*.additionaldetails
createdby
BPA.documents.*.createdby
lastmodifiedby
BPA.documents.*.lastmodifiedby
createdtime
BPA.documents.*.createdtime
lastmodifiedtime
BPA.documents.*.lastmodifiedtime

eg_land_landInfo

Description
Attributes
Mapping
Stores land details information.
Attribute Name
Data Type
Definition
Mandatory (Y/N)
id (PK)
character varying(64)
The system generated unique id(UUID)
Y
landUid
character varying(64)
The system generated unique id(UUID)
Y
landUniqueRegNo
character varying(64)
The unique registration number to identify the land record
Y
tenantId
character varying(256)
TenantID to identify application submitted for the which city
Y
status
character varying(64)
Status of application
N
ownershipCategory
character varying(64)
The land ownership category
Y
source
character varying(64)
The source of land record
Y
channel
character varying(64)
From which channel the application is submitted
Y
additionalDetails
jsonb
Json object to capture any extra information which is not accommodated in the model
N
createdby
character varying(64)
username (preferred) or userid of the user that created the object
Y
lastmodifiedby
character varying(64)
username (preferred) or userid of the user that last modified the object
Y
createdtime
bigint
epoch of the time object is modified last
Y
lastmodifiedtime
bigint
epoch of the time object is created
Y
Attribute Name
Mapping Details
id (PK)
landInfo.id
landUid
landInfo.landUid
landUniqueRegNo
landInfo.landUniqueRegNo
tenantId
landInfo.tenantId
status
landInfo.status
ownershipCategory
landInfo.ownershipCategory
source
landInfo.source
channel
landInfo.channel
additionalDetails
landInfo.additionalDetails
createdby
landInfo.createdby
lastmodifiedby
landInfo.lastmodifiedby
createdtime
landInfo.createdtime
lastmodifiedtime
landInfo.lastmodifiedtime

eg_land_address

Description
Attributes
Mapping
It stores land/plot/site address information.
Attribute Name
Data Type
Definition
Mandatory (Y/N)
id (PK)
character varying(64)
The system generated unique id(UUID)
Y
tenantId
character varying(256)
TenantID to identify application submitted for the which city
Y
doorNo
character varying(64)
The door numbers of plot/land
N
plotNo
character varying(64)
The plot number of plot
N
landmark
character varying(64)
The nearest place to identify the plot
N
city
character varying(64)
The city name where the plot is located
Y
district
character varying(64)
The district name where land is located
N
region
character varying(64)
The region name with respective of plot located
N
state
character varying(64)
The state name where land/plot is located
Y
country
character varying(64)
Name of the country where land is located
Y
locality
character varying(64)
The locality name of the plot/land
Y
pincode
character varying(64)
The pincode of land/plot
Y
additionDetails
character varying(64)
Json object to capture any extra information which is not accommodated in the model
N
buildingName
character varying(64)
Name of the building name
N
street
character varying(64)
Street name of the plot where located
N
landInfoId (FK)
character varying(64)
The landinfo id is foreign key reference to the landinfo
Y
createdby
character varying(64)
username (preferred) or userid of the user that created the object
Y
lastmodifiedby
character varying(64)
username (preferred) or userid of the user that last modified the object
Y
createdtime
bigint
epoch of the time object is modified last
Y
lastmodifiedtime
bigint
epoch of the time object is created
Y
Attribute Name
Mapping Details
id (PK)
landInfo.address.id
tenantId
landInfo.address.tenantId
doorNo
landInfo.address.doorNo
plotNo
landInfo.address.plotNo
landmark
landInfo.address.landmark
city
landInfo.address.city
district
landInfo.address.district
region
landInfo.address.region
state
landInfo.address.state
country
landInfo.address.country
locality
landInfo.address.locality
pincode
landInfo.address.pincode
additionDetails
landInfo.address.additionDetails
buildingName
landInfo.address.buildingName
street
landInfo.address.street
landInfoId (FK)
landInfo.address.landInfoId
createdby
landInfo.address.createdby
lastmodifiedby
landInfo.address.lastmodifiedby
createdtime
landInfo.address.createdtime
lastmodifiedtime
landInfo.address.lastmodifiedtime

eg_land_geolocation

Description
Attributes
Mapping
Stores land geo-location information.
Attribute Name
Data Type
Definition
Mandatory (Y/N)
id (PK)
character varying(64)
The system generated unique id(UUID)
Y
latitude
double precision
The latitude value of the plot/land
Y
longitude
double precision
The longtitude value of the land/plot
Y
addressId (FK)
character varying(64)
The addressid is the foreignkey reference, it contain ID value of the land address
Y
additionalDetails
JSONB
Json object to capture any extra information which is not accommodated in the model
N
createdby
character varying(64)
username (preferred) or userid of the user that created the object
Y
lastmodifiedby
character varying(64)
username (preferred) or userid of the user that last modified the object
Y
createdtime
bigint
epoch of the time object is modified last
Y
lastmodifiedtime
bigint
epoch of the time object is created
Y
Attribute Name
Mapping Details
id (PK)
landInfo.address.geoLocation.id
latitude
landInfo.address.geoLocation.latitude
longitude
landInfo.address.geoLocation.longitude
addressId (FK)
landInfo.address.geoLocation.addressId
additionalDetails
landInfo.address.geoLocation.additionalDetails
createdby
landInfo.address.geoLocation.createdby
lastmodifiedby
landInfo.address.geoLocation.lastmodifiedby
createdtime
landInfo.address.geoLocation.createdtime
lastmodifiedtime
landInfo.address.geoLocation.lastmodifiedtime

eg_land_ownerInfo

Description
Attributes
Mapping
Stores landowner details.
Attribute Name
Data Type
Definition
Mandatory (Y/N)
id
character varying(64)
The system generated unique id(UUID)
Y
uuid
character varying(64)
The UUID is the unique key of user. It contains user UUID to identify which user
Y
isprimaryowner
boolean
Whether the owner is primary owner who own land
Y
ownershippercentage
double precision
If land have multiple owners, then each own how much percentage.
Y
institutionId
character varying(64)
N
additionalDetails
JSONB
Json object to capture any extra information which is not accommodated in the model
N
landInfoId
character varying(64)
The landinfo id is foreign key reference to the landinfo
Y
relationship
character varying(64)
The relationship with primary owner
Y
createdby
character varying(64)
username (preferred) or userid of the user that created the object
Y
lastmodifiedby
character varying(64)
username (preferred) or userid of the user that last modified the object
Y
createdtime
bigint
epoch of the time object is modified last
Y
lastmodifiedtime
bigint
epoch of the time object is created
Y
Attribute Name
Mapping Details
id
landInfo.owners.*.id
uuid
landInfo.owners.*.uuid
isprimaryowner
landInfo.owners.*.isprimaryowner
ownershippercentage
landInfo.owners.*.ownershippercentage
institutionId
landInfo.owners.*.institutionId
additionalDetails
landInfo.owners.*.additionalDetails
landInfoId
landInfo.owners.*.landInfoId
relationship
landInfo.owners.*.relationship
createdby
landInfo.owners.*.createdby
lastmodifiedby
landInfo.owners.*.lastmodifiedby
createdtime
landInfo.owners.*.createdtime
lastmodifiedtime
landInfo.owners.*.lastmodifiedtime

eg_land_institution

Description
Attributes
Mapping
Attribute Name
Data Type
Definition
Mandatory (Y/N)
id (PK)
character varying(64)
The system generated unique id(UUID)
Y
tenantId
character varying(256)
TenantID to identify application submitted for the which city
Y
type
character varying(64)
type
N
designation
character varying(256)
Designation name
N
nameOfAuthorizedPerson
character varying(256)
Name of the authorized person from institute
N
additionalDetails
JSONB
Json object to capture any extra information which is not accommodated in the model
N
landInfoId (FK)
character varying(64)
The landinfo id is foreign key reference to the landinfo
Y
createdby
character varying(64)
username (preferred) or userid of the user that created the object
Y
lastmodifiedby
character varying(64)
username (preferred) or userid of the user that last modified the object
Y
createdtime
bigint
epoch of the time object is modified last
Y
lastmodifiedtime
bigint
epoch of the time object is created
Y
Attribute Name
Mapping Details
id (PK)
landInfo.institution.id
tenantId
landInfo.institution.tenantId
type
landInfo.institution.type
designation
landInfo.institution.designation
nameOfAuthorizedPerson
landInfo.institution.nameOfAuthorizedPerson
additionalDetails
landInfo.institution.additionalDetails
landInfoId (FK)
landInfo.institution.landInfoId
createdby
landInfo.institution.createdby
lastmodifiedby
landInfo.institution.lastmodifiedby
createdtime
landInfo.institution.createdtime
lastmodifiedtime
landInfo.institution.lastmodifiedtime

eg_land_document

Description
Attributes
Mapping
Stores land-related attached documents.
Attribute Name
Data Type
Definition
Mandatory (Y/N)
id (PK)
character varying(64)
The system generated unique id(UUID)
Y
documentType
character varying(256)
Name of the document type
Y
fileStoreId
character varying(256)
The filestoreId of document
Y
documentUid
character varying(256)
The system generated unique id(UUID)
Y
additionalDetails
JSONB
Json object to capture any extra information which is not accommodated in the model
N
landInfoId (FK)
character varying(64)
REFERENCES eg_land_landInfo (id)
Y
createdby
character varying(64)
username (preferred) or userid of the user that created the object
Y
lastmodifiedby
character varying(64)
username (preferred) or userid of the user that last modified the object
Y
createdtime
bigint
epoch of the time object is modified last
Y
lastmodifiedtime
bigint
epoch of the time object is created
Y
Attribute Name
Mapping Details
id (PK)
landInfo.documents.*.id
documentType
landInfo.documents.*.documentType
fileStoreId
landInfo.documents.*.fileStoreId
documentUid
landInfo.documents.*.documentUid
additionalDetails
landInfo.documents.*.additionalDetails
landInfoId (FK)
landInfo.documents.*.landInfoId
createdby
landInfo.documents.*.createdby
lastmodifiedby
landInfo.documents.*.lastmodifiedby
createdtime
landInfo.documents.*.createdtime
lastmodifiedtime
landInfo.documents.*.lastmodifiedtime

eg_land_unit

Description
Attributes
Mapping
Stores building information in the land/plot.
Attribute Name
Data Type
Definition
Mandatory (Y/N)
id (PK)
character varying(64)
The system generated unique id(UUID)
Y
tenantId
character varying(256)
TenantID to identify application submitted for the which city
Y
floorNo
character varying(64)
The floor no value
Y
unitType
character varying(256)
The unit type
Y
usageCategory
character varying(64)
Name of the usage
N
occupancyType
character varying(64)
Name of the occupancy building occupied
Y
occupancyDate
bigint
As on date which occupancy, the building having
N
additionalDetails
JSONB
Json object to capture any extra information which is not accommodated in the model
N
landInfoId (FK)
character varying(64)
REFERENCES eg_land_landInfo (id)
Y
createdby
character varying(64)
username (preferred) or userid of the user that created the object
Y
lastmodifiedby
character varying(64)
username (preferred) or userid of the user that last modified the object
Y
createdtime
bigint
epoch of the time object is modified last
Y
lastmodifiedtime
bigint
epoch of the time object is created
Y
Attribute Name