Sewerage Service Data Model
The Sewerage module offers various features and functions required to manage the sewerage service connections against a Property in the system.
Sewerage Service Entity Details
eg_sw_connection
This table contains the sewerage connection details
id (PK)
character varying (64)
System generated unique id for the model to identify the record.
Y
tenantid
character varying (250)
Unique identifier for a tenant to which user primarily belongs
Y
property_id
character varying (64)
Unique identifier for a property record
Y
applicationno
character varying (64)
Unique identifier to indentify an application and shared with applicant
N
applicationstatus
character varying (256)
Application status
N
status
character varying (64)
Connection status
Y
connectionno
character varying (256)
Consumer no. alloted to a connection by the system based on the format configuration.
N
oldconnectionno
character varying (64)
Old consumer no.
N
action
character varying (64)
Workflow action
N
roadtype
character varying (32)
Road type, which is cut during providing the connection
N
adhocrebate
numeric (12,2)
Adhoc rebate
N
adhocpenalty
numeric (12,2)
Adhoc penalty
N
adhocpenaltyreason
character varying (1024)
Reason why is the adhoc penalty is levied
N
adhocpenaltycomment
character varying (1024)
Comments on levy the adhoc penalty
N
adhocrebatereason
character varying (1024)
Reason why is the adhoc rebate is pprovided
N
adhocrebatecomment
character varying (1024)
Comments on giving the adhoc rebate
N
createdby
character varying (64)
username (preferred) or userid of the user that created the object
N
createdtime
bigint
epoch of the time object is created
N
lastmodifiedby
character varying (64)
username (preferred) or userid of the user that last modified the object
N
lastmodifiedtime
bigint
epoch of the time object is modified last
N
applicationtype
character varying (64)
Type of application
N
dateeffectivefrom
bigint
Date by when the changed are effective
N
locality
character varying (64)
Locality
N
isoldapplication
boolean
Whether the application is an old application
N
additionaldetails
jsonb
Json object to capture any extra information which is not accommodated in the model
N
id (PK)
tenantid
SewerageConnecion.tenantId
property_id
.SewerageConnecion.propertyId
applicationno
.SewerageConnecion.applicationNo
applicationstatus
.SewerageConnecion.applicationStatus
status
.SewerageConnecion.status
connectionno
.SewerageConnecion.connectionNo
oldconnectionno
.SewerageConnecion.oldConnectionNo
action
.SewerageConnecion.processInstance.action
roadtype
.SewerageConnecion.roadType
adhocrebate
.SewerageConnecion.additionalDetails.adhocRebate
adhocpenalty
SewerageConnecion.additionalDetails.adhocPenalty
adhocpenaltyreason
SewerageConnecion.additionalDetails.adhocPenaltyComment
adhocpenaltycomment
SewerageConnecion.additionalDetails.adhocPenaltyReason
adhocrebatereason
SewerageConnecion.additionalDetails.adhocRebateReason
adhocrebatecomment
SewerageConnecion.additionalDetails.adhocRebateComment
createdby
SewerageConnecion.auditDetails.createdBy
createdtime
SewerageConnecion.auditDetails.createdTime
lastmodifiedby
SewerageConnecion.auditDetails.lastModifiedBy
lastmodifiedtime
SewerageConnecion.auditDetails.lastModifiedTime
applicationtype
SewerageConnecion.applicationType
dateeffectivefrom
SewerageConnecion.dateEffectiveFrom
locality
SewerageConnecion.additionalDetails.locality
isoldapplication
SewerageConnecion.oldApplication
additionaldetails
SewerageConnecion.additionalDetails
eg_sw_applicationdocument
This table contains application document details
id (PK)
character varying (64)
System generated unique id for the entity to identify the record.
Y
tenantid
character varying (64)
Unique identifier for a tenant to which connection belogs
N
documenttype
character varying (64)
Document type which is being attached
N
filestoreid
character varying (64)
Filestore id of document
N
swid (FK)
character varying (64)
sewerage connection id
N
active
character varying (64)
docuemnt status
N
documentuid
character varying (64)
N
createdby
character varying (64)
username (preferred) or userid of the user that created the object
N
createdtime
bigint
epoch of the time object is created
N
lastmodifiedby
character varying (64)
username (preferred) or userid of the user that last modified the object
N
lastmodifiedtime
bigint
epoch of the time object is modified last
N
id (PK)
SewerageConnecion.documents.*.id
tenantid
SewerageConnecion.tenantId
documenttype
SewerageConnecion.documents.*.documentType
filestoreid
SewerageConnecion.documents.*.fileStoreId
swid (FK)
SewerageConnecion.id
active
SewerageConnecion.documents.*.status
documentuid
createdby
SewerageConnecion.documents.*.auditDetails.createdBy
createdtime
SewerageConnecion.documents.*.auditDetails.createdTime
lastmodifiedby
SewerageConnecion.documents.*.auditDetails.lastModifiedBy
lastmodifiedtime
SewerageConnecion.documents.*.auditDetails.lastModifiedTime
eg_sw_connectionholder
This table contains the details of the user who has the sewerage connection in the property.
tenantid
character varying (256)
Unique identifier for a tenant to which connection belogs
N
connectionid (PK) (FK)
character varying (128)
Unique indetifier to identify the connection
Y
status
character varying (128)
status of user
N
userid
character varying (128)
uuid of user
N
isprimaryholder
boolean
boolean field to indicate the whether the user is primary owner or not
N
connectionholdertype
character varying (256)
owner type
N
holdershippercentage
character varying (128)
ownership percentage
N
relationship
character varying (128)
N
createdby
character varying (128)
username (preferred) or userid of the user that created the object
N
createdtime
bigint
epoch of the time object is created
N
lastmodifiedby
character varying (128)
username (preferred) or userid of the user that last modified the object
N
lastmodifiedtime
bigint
epoch of the time object is modified last
N
tenantid
SewerageConnecion.tenantId
connectionid (PK) (FK)
status
SewerageConnecion.connectionHolders.*.status
userid
SewerageConnecion.connectionHolders.*.uuid
isprimaryholder
SewerageConnecion.connectionHolders.*.isPrimaryOwner
connectionholdertype
SewerageConnecion.connectionHolders.*.ownerType
holdershippercentage
SewerageConnecion.connectionHolders.*.ownerShipPercentage
relationship
SewerageConnecion.connectionHolders.*.relationship
createdby
SewerageConnecion.auditDetails.createdBy
createdtime
SewerageConnecion.auditDetails.createdTime
lastmodifiedby
SewerageConnecion.auditDetails.lastModifiedBy
lastmodifiedtime
SewerageConnecion.auditDetails.lastModifiedTime
eg_sw_plumberinfo
This table contains the plumber information.
id (PK)
character varying (256)
System generated unique id for the entity to identify the record.
Y
tenantid
character varying (64)
Unique identifier for a tenant to which connection belogs
N
name
character varying (256)
Name of the plumber
N
licenseno
character varying (256)
Plumber license no.
N
mobilenumber
character varying (256)
Plumber's mobile no.
N
gender
character varying (256)
Gender of plumber
N
fatherorhasbandname
character varying (256)
Father or husband name of the plumber
N
correspondenceaddress
character varying (1024)
Correspondenceaddress of the plumber
N
relationship
character varying (256)
Relationship
N
swid (FK)
character varying (64)
Sewerage connection id
N
createdby
character varying (64)
username (preferred) or userid of the user that created the object
N
createdtime
bigint
epoch of the time object is created
N
lastmodifiedby
character varying (64)
username (preferred) or userid of the user that last modified the object
N
lastmodifiedtime
bigint
epoch of the time object is modified last
N
id (PK)
SewerageConnecion.plumberInfo.*.id
tenantid
SewerageConnecion.tenantId
name
SewerageConnecion.plumberInfo.*.name
licenseno
SewerageConnecion.plumberInfo.*.licenseNo
mobilenumber
SewerageConnecion.plumberInfo.*.mobileNumber
gender
SewerageConnecion.plumberInfo.*.gender
fatherorhasbandname
SewerageConnecion.plumberInfo.*.fatherOrHusbandName
correspondenceaddress
SewerageConnecion.plumberInfo.*.correspondenceAddress
relationship
SewerageConnecion.plumberInfo.*.relationship
swid (FK)
SewerageConnecion.id
createdby
SewerageConnecion.plumberInfo.*.auditDetails.createdBy
createdtime
SewerageConnecion.plumberInfo.*.auditDetails.createdTime
lastmodifiedby
SewerageConnecion.plumberInfo.*.auditDetails.lastModifiedBy
lastmodifiedtime
SewerageConnecion.plumberInfo.*.auditDetails.lastModifiedTime
eg_sw_connection_audit
This table contains the connection audit details.
id (PK)
character varying (64)
System generated unique id for the model to identify the record.
Y
tenantid
character varying (250)
Unique identifier for a tenant to which user primarily belongs
Y
property_id
character varying (64)
Unique identifier for a property record
Y
applicationno
character varying (64)
Unique identifier to indentify an application and shared with applicant
N
applicationstatus
character varying (256)
Application status
N
status
character varying (64)
Connection status
Y
connectionno
character varying (256)
Consumer no. alloted to a connection by the system based on the format configuration.
N
oldconnectionno
character varying (64)
Old consumer no.
N
action
character varying (64)
Workflow action
N
roadtype
character varying (32)
Road type, which is cut during providing the connection
N
adhocrebate
numeric (12,2)
Adhoc rebate
N
adhocpenalty
numeric (12,2)
Adhoc penalty
N
adhocpenaltyreason
character varying (1024)
Reason why is the adhoc penalty is levied
N
adhocpenaltycomment
character varying (1024)
Comments on levy the adhoc penalty
N
adhocrebatereason
character varying (1024)
Reason why is the adhoc rebate is pprovided
N
adhocrebatecomment
character varying (1024)
Comments on giving the adhoc rebate
N
createdby
character varying (64)
username (preferred) or userid of the user that created the object
N
createdtime
bigint
epoch of the time object is created
N
lastmodifiedby
character varying (64)
username (preferred) or userid of the user that last modified the object
N
lastmodifiedtime
bigint
epoch of the time object is modified last
N
applicationtype
character varying (64)
Type of application
N
dateeffectivefrom
bigint
Date by when the changed are effective
N
locality
character varying (64)
Locality
N
isoldapplication
boolean
Whether the application is an old application
N
additionaldetails
jsonb
Json object to capture any extra information which is not accommodated in the model
N
id (PK)
tenantid
SewerageConnecion.tenantId
property_id
.SewerageConnecion.propertyId
applicationno
.SewerageConnecion.applicationNo
applicationstatus
.SewerageConnecion.applicationStatus
status
.SewerageConnecion.status
connectionno
.SewerageConnecion.connectionNo
oldconnectionno
.SewerageConnecion.oldConnectionNo
action
.SewerageConnecion.processInstance.action
roadtype
.SewerageConnecion.roadType
adhocrebate
.SewerageConnecion.additionalDetails.adhocRebate
adhocpenalty
SewerageConnecion.additionalDetails.adhocPenalty
adhocpenaltyreason
SewerageConnecion.additionalDetails.adhocPenaltyComment
adhocpenaltycomment
SewerageConnecion.additionalDetails.adhocPenaltyReason
adhocrebatereason
SewerageConnecion.additionalDetails.adhocRebateReason
adhocrebatecomment
SewerageConnecion.additionalDetails.adhocRebateComment
createdby
SewerageConnecion.auditDetails.createdBy
createdtime
SewerageConnecion.auditDetails.createdTime
lastmodifiedby
SewerageConnecion.auditDetails.lastModifiedBy
lastmodifiedtime
SewerageConnecion.auditDetails.lastModifiedTime
applicationtype
SewerageConnecion.applicationType
dateeffectivefrom
SewerageConnecion.dateEffectiveFrom
locality
SewerageConnecion.additionalDetails.locality
isoldapplication
SewerageConnecion.oldApplication
additionaldetails
SewerageConnecion.additionalDetails
eg_sw_service
This table contains details of the sewerage connection application required for bill calculation.
connection_id (FK)
character varying (64)
System generated unique id for the entity to uniquely identify the record.
Y
connectionexecutiondate
bigint
Connection execution date
N
noofwaterclosets
integer
Number of water closet
N
nooftoilets
integer
Number of toilets
N
connectiontype
character varying (32)
Connection type
N
proposedwaterclosets
integer
Proposed water closet
N
proposedtoilets
integer
proposed toilet
N
appcreatedate
bigint
Application create date
N
detailsprovidedby
character varying (256)
uuid who provided the details
N
estimationfilestoreid
character varying (256)
filestore id of estimation letter
N
santionfilestoreid
character varying (256)
filestore id of saction letter
N
createdby
character varying (64)
username (preferred) or userid of the user that created the object
N
createdtime
bigint
epoch of the time object is created
N
lastmodifiedby
character varying (64)
username (preferred) or userid of the user that last modified the object
N
lastmodifiedtime
bigint
epoch of the time object is modified last
N
estimationletterdate
bigint
epoch time stamp when estimation letter generated
N
connection_id (FK)
SewerageConnecion.id
connectionexecutiondate
SewerageConnecion.connectionExecutionDate
noofwaterclosets
SewerageConnection.noOfWaterClosets
nooftoilets
SewerageConnection.noOfToilets
connectiontype
SewerageConnecion.connectionType
proposedwaterclosets
SewerageConnection.proposedWaterClosets
proposedtoilets
SewerageConnection.proposedToilets
appcreatedate
SewerageConnection.additionalDetails.appCreatedDate
detailsprovidedby
SewerageConnecion.additionalDetails.detailsProvidedBy
estimationfilestoreid
SewerageConnecion.additionalDetails.estimationFileStoreId
santionfilestoreid
SewerageConnecion.additionalDetails.sanctionFileStoreId
createdby
SewerageConnecion.auditDetails.createdBy
createdtime
SewerageConnecion.auditDetails.createdTime
lastmodifiedby
SewerageConnecion.auditDetails.lastModifiedBy
lastmodifiedtime
SewerageConnecion.auditDetails.lastModifiedTime
estimationletterdate
SewerageConnecion.additionalDetails.estimationLetterDate
eg_sw_service_audit
This table contains audit details of the sewerage connection applications required for bill calculation.
connection_id (FK)
character varying (64)
System generated unique id for the entity to uniquely identify the record.
Y
connectionexecutiondate
bigint
Connection execution date
N
noofwaterclosets
integer
Number of water closet
N
nooftoilets
integer
Number of toilets
N
connectiontype
character varying (32)
Connection type
N
proposedwaterclosets
integer
Proposed water closet
N
proposedtoilets
integer
proposed toilet
N
appcreatedate
bigint
Application create date
N
detailsprovidedby
character varying (256)
uuid who provided the details
N
estimationfilestoreid
character varying (256)
filestore id of estimation letter
N
santionfilestoreid
character varying (256)
filestore id of saction letter
N
createdby
character varying (64)
username (preferred) or userid of the user that created the object
N
createdtime
bigint
epoch of the time object is created
N
lastmodifiedby
character varying (64)
username (preferred) or userid of the user that last modified the object
N
lastmodifiedtime
bigint
epoch of the time object is modified last
N
estimationletterdate
bigint
epoch time stamp when estimation letter generated
N
connection_id (FK)
SewerageConnecion.id
connectionexecutiondate
SewerageConnecion.connectionExecutionDate
noofwaterclosets
SewerageConnection.noOfWaterClosets
nooftoilets
SewerageConnection.noOfToilets
connectiontype
SewerageConnecion.connectionType
proposedwaterclosets
SewerageConnection.proposedWaterClosets
proposedtoilets
SewerageConnection.proposedToilets
appcreatedate
SewerageConnection.additionalDetails.appCreatedDate
detailsprovidedby
SewerageConnecion.additionalDetails.detailsProvidedBy
estimationfilestoreid
SewerageConnecion.additionalDetails.estimationFileStoreId
santionfilestoreid
SewerageConnecion.additionalDetails.sanctionFileStoreId
createdby
SewerageConnecion.auditDetails.createdBy
createdtime
SewerageConnecion.auditDetails.createdTime
lastmodifiedby
SewerageConnecion.auditDetails.lastModifiedBy
lastmodifiedtime
SewerageConnecion.auditDetails.lastModifiedTime
estimationletterdate
SewerageConnecion.additionalDetails.estimationLetterDate
eg_sw_roadcuttinginfo
This table contains the road cutting information for sewerage connection.
id (PK)
character varying(64)
System generated unique id for the model to identify the record.
Y
tenantId
character varying(64)
Unique identifier for a tenant to which connection belogs
N
swid (FK)
character varying(64)
sewerage connection uuid
N
active
character varying(64)
boolean flag to mark details active/ inactive
N
roadtype
character varying(32)
Road type
N
roadcuttingarea
FLOAT
Roadcutting area
N
createdby
character varying (64)
username (preferred) or userid of the user that created the object
N
createdtime
bigint
epoch of the time object is created
N
lastmodifiedby
character varying (64)
username (preferred) or userid of the user that last modified the object
N
lastmodifiedtime
bigint
epoch of the time object is modified last
N
id (PK)
SewerageConnecion.roadCuttingInfo.*.id
tenantId
SewerageConnecion.tenantId
swid (FK)
active
SewerageConnecion.roadCuttingInfo.*.status
roadtype
SewerageConnecion.roadCuttingInfo.*.roadType
roadcuttingarea
SewerageConnecion.roadCuttingInfo.*.roadCuttingArea
createdby
SewerageConnecion.roadCuttingInfo.*.auditDetails.createdBy
createdtime
SewerageConnecion.roadCuttingInfo.*.auditDetails.createdTime
lastmodifiedby
SewerageConnecion.roadCuttingInfo.*.auditDetails.lastModifiedBy
lastmodifiedtime
SewerageConnecion.roadCuttingInfo.*.auditDetails.lastModifiedTime
Mapping Constructs
Last updated
