Fire NOC Data Model
The Fire NOC module is used to provide NOC application services for approval from respective departments. NOC registry stores and serves the NOC related information using rest APIs.
NOC Service Entity Details
Data Constructs
eg_fn_buildingdocuments
This table contains the document details submitted by users for the fire NOC application.
| Attribute Name | Data Type | Definition | Mandatory (Y/N) |
|---|---|---|---|
uuid (PK) | varchar | The system generated unique id(UUID) | Y |
tenantid | varchar | Unique identifier for a tenant to which user primarily belongs | Y |
documenttype | varchar | type of document | Y |
filestoreid | varchar | document filestore id | Y |
active | boolean | boolean atribute to mark the details active/inactive | Y |
documentuid | varchar | Document number | |
createdby | varchar | username (preferred) or userid of the user that created the object | Y |
createdtime | int | username (preferred) or userid of the user that last modified the object | Y |
lastmodifiedby | varchar | epoch of the time object is created | Y |
lastmodifiedtime | int | epoch of the time object is modified last | Y |
buildinguuid (FK) | varchar | Unique identifier of the building details | Y |
| Attribute Name | Mapping Details |
|---|---|
uuid (PK) | FireNOCs.*.fireNOCDetails.buildings.*.applicationDocuments.*.id |
tenantid | FireNOCs.*.tenantId |
documenttype | FireNOCs.*.fireNOCDetails.buildings.*.applicationDocuments.*.documentType |
filestoreid | FireNOCs.*.fireNOCDetails.buildings.*.applicationDocuments.*.fileStoreId |
active | FireNOCs.*.fireNOCDetails.buildings.*.applicationDocuments.*.active |
documentuid | FireNOCs.*.fireNOCDetails.buildings.*.applicationDocuments.*.documentUid |
createdby | FireNOCs.*.auditDetails.createdBy |
createdtime | FireNOCs.*.auditDetails.lastModifiedBy |
lastmodifiedby | FireNOCs.*.auditDetails.createdTime |
lastmodifiedtime | FireNOCs.*.auditDetails.lastModifiedTime |
buildinguuid (FK) | FireNOCs.*.fireNOCDetails.buildings.*.id |
eg_fn_institution
This entity captures the institution detail from which the applicant seeks NOC.
| Attribute Name | Data Type | Definition | Mandatory (Y/N) |
|---|---|---|---|
uuid (PK) | varchar | The system generated unique id(UUID) | Y |
tenantid | varchar | Unique identifier for a tenant to which user primarily belongs | N |
firenocdetailsuuid (FK) | varchar | Unique Identifier of the Fire FireNOC Details (UUID) | Y |
name | varchar | name of institute | N |
type | varchar | type of insititute | N |
designation | varchar | designation in institute | N |
createdby | varchar | username (preferred) or userid of the user that created the object | Y |
createdtime | int | username (preferred) or userid of the user that last modified the object | Y |
lastmodifiedby | varchar | epoch of the time object is created | Y |
lastmodifiedtime | int | epoch of the time object is modified last | Y |
active | boolean |
| Attribute Name | Mapping Details |
|---|---|
uuid (PK) | FireNOCs.*.fireNOCDetails.applicantDetails.additionalDetail.id |
tenantid | FireNOCs.*.fireNOCDetails.applicantDetails.additionalDetail.tenantId |
firenocdetailsuuid (FK) | FireNOCs.*.fireNOCDetails.id |
name | FireNOCs.*.fireNOCDetails.applicantDetails.additionalDetail.name |
type | FireNOCs.*.fireNOCDetails.applicantDetails.additionalDetail.type |
designation | FireNOCs.*.fireNOCDetails.applicantDetails.additionalDetail.designation |
createdby | FireNOCs.*.auditDetails.createdBy |
createdtime | FireNOCs.*.auditDetails.lastModifiedBy |
lastmodifiedby | FireNOCs.*.auditDetails.createdTime |
lastmodifiedtime | FireNOCs.*.auditDetails.lastModifiedTime |
active |
eg_fn_owner
This table contains the details of the building owner for which the fire NOC application is submitted.
| Attribute Name | Data Type | Definition | Mandatory (Y/N) |
|---|---|---|---|
uuid (PK) | varchar | The system generated unique id(UUID) | Y |
tenantid | varchar | Unique identifier for a tenant to which user primarily belongs | Y |
firenocdetailsuuid (FK) | varchar | Unique Identifier of the Fire FireNOC Details (UUID) | Y |
isactive | boolean | boolean atribute to mark the details active/inactive | Y |
isprimaryowner | boolean | The owner is primary or not | Y |
ownertype | varchar | Type of owner, based on this option exemptions are applied. This is master data defined in mdms. | Y |
ownershippercentage | varchar | Percentage of ownership of defined property | Y |
relationship | varchar | Relationship of guardian with the owner | Y |
active | boolean | Y | |
institutionid | varchar | Unique Identifier of the institute details | Y |
createdby | varchar | username (preferred) or userid of the user that created the object | Y |
createdtime | int | username (preferred) or userid of the user that last modified the object | Y |
lastmodifiedby | varchar | epoch of the time object is created | Y |
lastmodifiedtime | int | epoch of the time object is modified last | Y |
useruuid | varchar | user uuid | Y |
applicantcategory | varchar | owner category | Y |
| Attribute Name | Mapping Details |
|---|---|
uuid (PK) | FireNOCs.*.fireNOCDetails.applicantDetails.owners.*.ownerUUID |
tenantid | FireNOCs.*.fireNOCDetails.applicantDetails.owners.*.tenantId |
firenocdetailsuuid (FK) | FireNOCs*.fireNOCDetails.id |
isactive | FireNOCs.*.fireNOCDetails.applicantDetails.owners.*.isActive |
isprimaryowner | FireNOCs.*.fireNOCDetails.applicantDetails.owners.*.isPrimaryOwner |
ownertype | FireNOCs*.fireNOCDetails.applicantDetails.ownerShipType |
ownershippercentage | FireNOCs.*.fireNOCDetails.applicantDetails.owners.*.ownerShipPercentage |
relationship | FireNOCs.*.fireNOCDetails.applicantDetails.owners.*.relationship |
active | FireNOCs.*.fireNOCDetails.applicantDetails.owners.*.active |
institutionid | FireNOCs.*.fireNOCDetails.applicantDetails.additionalDetail.id |
createdby | FireNOCs.*.auditDetails.createdBy |
createdtime | FireNOCs.*.auditDetails.lastModifiedBy |
lastmodifiedby | FireNOCs.*.auditDetails.createdTime |
lastmodifiedtime | FireNOCs.*.auditDetails.lastModifiedTime |
useruuid | FireNOCs.*.fireNOCDetails.applicantDetails.owners.*.uuid |
applicantcategory | FireNOCs.*.fireNOCDetails.applicantDetails.owners.*.ownerType |
eg_fn_firenocdetail
This entity captures the fire NOC certificate details issued to the applicant.
| Attribute Name | Data Type | Definition | Mandatory (Y/N) |
|---|---|---|---|
uuid (PK) | varchar | Unique Identifier of the Fire FireNOC Details (UUID) | Y |
firenocuuid (FK) | varchar | Unique Identifier of the Fire FireNOC | Y |
applicationnumber | varchar | Unique Application FireNOC Number of the Fire FireNOC. This is unique in system for a tenant. This is mandatory but always be generated on the final approval. | Y |
firenoctype | varchar | type of fire NOC from mdms | Y |
firestationid | varchar | Fire station id where we are applying fire fireNOC. | Y |
applicationdate | int | date on which applicaiton has been generated for new Fire NOC. | Y |
financialyear | varchar | Fire NOC applicable for financial year. | Y |
issueddate | int | License issued Date of the Fire NOC as epoch. 2. Application approval date. | v |
validfrom | int | Date from when Fire NOC is valid as epoch | Y |
validto | int | Expiry Date of the Fire NOC as epoch | Y |
action | varchar | Workflow action on the application in certain | Y |
channel | varchar | channel name | Y |
noofbuildings | varchar | the attributestore value as string like single or multiple to denotes the number of buiding | Y |
tenantid | varchar | Unique identifier for a tenant to which user primarily belongs | Y |
additionaldetail | jsonb | Json object to capture any extra information which is not accommodated in the model | N |
createdby | varchar | username (preferred) or userid of the user that created the object | Y |
lastmodifiedby | varchar | username (preferred) or userid of the user that last modified the object | Y |
createdtime | int | epoch of the time object is created | Y |
lastmodifiedtime | int | epoch of the time object is modified last | Y |
propertyid | varchar | property id of building | N |
status | varchar | firenoc application status | Y |
| Attribute Name | Mapping Details |
|---|---|
uuid (PK) | FireNOCs.*.fireNOCDetails.id |
firenocuuid (FK) | FireNOCs.*.id |
applicationnumber | FireNOCs.*.fireNOCDetails.applicationNumber |
firenoctype | FireNOCs.*.fireNOCDetails.fireNOCType |
firestationid | FireNOCs.*.fireNOCDetails.firestationId |
applicationdate | FireNOCs.*.fireNOCDetails.applicationDate |
financialyear | FireNOCs.*.fireNOCDetails.financialYear |
issueddate | FireNOCs.*.fireNOCDetails.issuedDate |
validfrom | FireNOCs.*.fireNOCDetails.validFrom |
validto | FireNOCs.*.fireNOCDetails.validTo |
action | FireNOCs.*.fireNOCDetails.action |
channel | FireNOCs.*.fireNOCDetails.channel |
noofbuildings | FireNOCs.*.fireNOCDetails.noOfBuildings |
tenantid | FireNOCs.*.fireNOCDetails.tenantId |
additionaldetail | FireNOCs.*.fireNOCDetails.additionalDetail |
createdby | FireNOCs.*.auditDetails.createdBy |
lastmodifiedby | FireNOCs.*.auditDetails.lastModifiedBy |
createdtime | FireNOCs.*.auditDetails.createdTime |
lastmodifiedtime | FireNOCs.*.auditDetails.lastModifiedTime |
propertyid | FireNOCs.*.fireNOCDetails.propertyDetails.propertyid |
status | FireNOCs.*.fireNOCDetails.status |
eg_fn_firenoc
This entity captures the fire NOC details.
| Attribute Name | Data Type | Definition | Mandatory (Y/N) |
|---|---|---|---|
uuid (PK) | varchar | The system generated unique id(UUID) | Y |
tenantid | varchar | Unique identifier for a tenant to which user primarily belongs | Y |
firenocnumber | varchar | Unique Fire NOC Number of the Fire NOC. This is unique in system for a tenant. This is mandatory but always be generated on the final approval. | Y |
provisionfirenocnumber | varchar | Unique Fire NOC Number of the Provision Fire NOC number that will be used for linking provision fire NOC number with new fire NOC number. This is unique in system for a tenant. This is mandatory but always be generated on the final approval. | N |
oldfirenocnumber | varchar | Unique Old License Number of the Fire NOC. This is unique in system for a tenant. This is mandatory for legacy license(DataEntry). | N |
dateofapplied | varchar | Applied Date of the fire NOC as epoch | Y |
createdby | varchar | username (preferred) or userid of the user that created the object | Y |
lastmodifiedby | varchar | username (preferred) or userid of the user that last modified the object | Y |
createdtime | int | epoch of the time object is created | Y |
lastmodifiedtime | int | epoch of the time object is modified last | Y |
| Attribute Name | Mapping Details |
|---|---|
uuid (PK) | FireNOCs.*.id |
tenantidT | FireNOCs.*.tenantId |
firenocnumber | FireNOCs.*.firenocnumber |
provisionfirenocnumber | FireNOCs.*.provisionfirenocnumber |
oldfirenocnumber | FireNOCs.*.oldfirenocnumber |
dateofapplied | FireNOCs.*.dateofapplied |
createdby | FireNOCs.*.auditDetails.createdBy |
lastmodifiedby | FireNOCs.*.auditDetails.lastModifiedBy |
createdtime | FireNOCs.*.auditDetails.createdTime |
lastmodifiedtime | FireNOCs.*.auditDetails.lastModifiedTime |
eg_fn_address
This entity captures the address details of the Fire NOC applicant.
| Attribute Name | Data Type | Definition | Mandatory (Y/N) |
|---|---|---|---|
uuid (PK) | varchar | The system generated unique id(UUID) | Y |
tenantid | varchar | Unique Identifier of the tenant to which user primarily belongs | Y |
doorno | varchar | House number or door number of the building of user | Y |
latitude | int | The latitude location details of the user address | N |
longitude | int | The longitude location details of the user address | N |
buildingname | varchar | Name of the building | Y |
addressid | varchar | System generated id for the address | Y |
addressnumber | varchar | House, Door, Building number in the address | Y |
type | varchar | address type | Y |
addressline1 | varchar | Apartment, Block, Street of the address | N |
addressline2 | varchar | Locality, Area, Zone, Ward of the address | N |
landmark | varchar | Additional location detail to help find the address of user | N |
street | varchar | Street name | Y |
city | varchar | City of the address. It can be representated by the tenantid | N |
locality | varchar | Locality of bulding | Y |
pincode | varchar | PIN code of the address. Indian pincodes will usually be all numbers. | N |
detail | varchar | more address detail as may be needed | N |
firenocdetailsuuid (FK) | varchar | Unique Identifier of the Fire FireNOC Details (UUID) | Y |
createdby | varchar | username (preferred) or userid of the user that created the object | Y |
lastmodifiedby | varchar | username (preferred) or userid of the user that last modified the object | Y |
createdtime | int | epoch of the time object is created | Y |
lastmodifiedtime | int | epoch of the time object is modified last | Y |
| Attribute Name | Mapping Details |
|---|---|
uuid (PK)T | FireNOCs.*.fireNOCDetails.propertyDetails.address.id |
tenantid | FireNOCs.*.fireNOCDetails.propertyDetails.address.tenantId |
doorno | FireNOCs.*.fireNOCDetails.propertyDetails.address.doorNo |
latitude | FireNOCs.*.fireNOCDetails.propertyDetails.address.latitude |
longitude | FireNOCs.*.fireNOCDetails.propertyDetails.address.longitude |
buildingname | FireNOCs.*.fireNOCDetails.propertyDetails.address.buildingName |
addressid | FireNOCs.*.fireNOCDetails.propertyDetails.address.addressId |
addressnumber | FireNOCs.*.fireNOCDetails.propertyDetails.address.addressNumber |
type | FireNOCs.*.fireNOCDetails.propertyDetails.address.type |
addressline1 | FireNOCs.*.fireNOCDetails.propertyDetails.address.addressline1 |
addressline2 | FireNOCs.*.fireNOCDetails.propertyDetails.address.addressline1 |
landmark | FireNOCs.*.fireNOCDetails.propertyDetails.address.landmark |
street | FireNOCs.*.fireNOCDetails.propertyDetails.address.street |
city | FireNOCs.*.fireNOCDetails.propertyDetails.address.city |
locality | FireNOCs.*.fireNOCDetails.propertyDetails.address.locality.code |
pincode | FireNOCs.*.fireNOCDetails.propertyDetails.address.pincode |
detail | FireNOCs.*.fireNOCDetails.propertyDetails.address.detail |
firenocdetailsuuid (FK) | FireNOCs.*.fireNOCDetails.id |
createdby | FireNOCs.*.auditDetails.createdBy |
lastmodifiedby | FireNOCs.*.auditDetails.lastModifiedBy |
createdtime | FireNOCs.*.auditDetails.createdTime |
lastmodifiedtime | FireNOCs.*.auditDetails.lastModifiedTime |
eg_fn_buidlings
This entity captures the various attribute details of the building for which the NOC is applied.
| Attribute Name | Data Type | Definition | Mandatory (Y/N) |
|---|---|---|---|
uuid (PK) | varchar | The system generated unique id(UUID) | Y |
firenocdetailsuuid (FK) | varchar | Unique Identifier of the Fire FireNOC Details (UUID) | Y |
tenantid | varchar | Unique identifier for a tenant to which user primarily belongs | Y |
name | varchar | name of building | Y |
usagetype | varchar | building usage type | Y |
createdby | varchar | username (preferred) or userid of the user that created the object | Y |
lastmodifiedby | varchar | username (preferred) or userid of the user that last modified the object | Y |
createdtime | int | epoch of the time object is created | Y |
lastmodifiedtime | int | epoch of the time object is modified last | Y |
active | boolean | boolean atribute to mark the details active/inactive |
| Attribute Name | Mapping Details |
|---|---|
uuid (PK) | FireNOCs.*.fireNOCDetails.buildings.*.id |
firenocdetailsuuid (FK) | FireNOCs[*][?({id} in @.fireNOCDetails.buildings[*].id)].fireNOCDetails.id |
tenantid | FireNOCs.*.fireNOCDetails.buildings.*.tenantId |
name | FireNOCs.*.fireNOCDetails.buildings.*.name |
usagetype | FireNOCs.*.fireNOCDetails.buildings.*.usageType |
createdby | FireNOCs[*][?({id} in @.fireNOCDetails.buildings[*].id)].auditDetails.createdBy |
lastmodifiedby | FireNOCs[*][?({id} in @.fireNOCDetails.buildings[*].id)].auditDetails.lastModifiedBy |
createdtime | FireNOCs[*][?({id} in @.fireNOCDetails.buildings[*].id)].auditDetails.createdTime |
lastmodifiedtime | FireNOCs[*][?({id} in @.fireNOCDetails.buildings[*].id)].auditDetails.lastModifiedTime |
active |
Mapping Constructs
Last updated
