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.
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
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.
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
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.
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
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.
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
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.
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
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.
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
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.
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
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
