Water Service Data Model
The Water module offers various features and functions required to manage the Water Service connections against a Property in the system.
Water Service Entity Details
eg_ws_connection
This entity stores the water 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
tenantid
WaterConnection.tenantId
property_id
.WaterConnection.propertyId
applicationno
.WaterConnection.applicationNo
applicationstatus
.WaterConnection.applicationStatus
status
.WaterConnection.status
connectionno
.WaterConnection.connectionNo
oldconnectionno
.WaterConnection.oldConnectionNo
action
.WaterConnection.processInstance.action
roadtype
.WaterConnection.roadType
adhocrebate
.WaterConnection.additionalDetails.adhocRebate
adhocpenalty
WaterConnection.additionalDetails.adhocPenalty
adhocpenaltyreason
WaterConnection.additionalDetails.adhocPenaltyComment
adhocpenaltycomment
WaterConnection.additionalDetails.adhocPenaltyReason
adhocrebatereason
WaterConnection.additionalDetails.adhocRebateReason
adhocrebatecomment
WaterConnection.additionalDetails.adhocRebateComment
createdby
WaterConnection.auditDetails.createdBy
createdtime
WaterConnection.auditDetails.createdTime
lastmodifiedby
WaterConnection.auditDetails.lastModifiedBy
lastmodifiedtime
WaterConnection.auditDetails.lastModifiedTime
applicationtype
WaterConnection.applicationType
dateeffectivefrom
WaterConnection.dateEffectiveFrom
locality
WaterConnection.additionalDetails.locality
isoldapplication
WaterConnection.oldApplication
additionaldetails
WaterConnection.additionalDetails
eg_ws_applicationdocument
This entity stores the details of the documents uploaded by the user while submitting the application.
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
wsid (FK)
character varying (64)
water 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
WaterConnection.documents.*.id
tenantid
WaterConnection.tenantId
documenttype
WaterConnection.documents.*.documentType
filestoreid
WaterConnection.documents.*.fileStoreId
wsid
WaterConnection.id
active
WaterConnection.documents.*.status
documentuid
createdby
WaterConnection.documents.*.auditDetails.createdBy
createdtime
WaterConnection.documents.*.auditDetails.createdTime
lastmodifiedby
WaterConnection.documents.*.auditDetails.lastModifiedBy
lastmodifiedtime
WaterConnection.documents.*.auditDetails.lastModifiedTime
eg_ws_connectionholder
This table contains the details of the user who has the water 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
WaterConnection.tenantId
connectionid (PK) (FK)
status
WaterConnection.connectionHolders.*.status
userid
WaterConnection.connectionHolders.*.uuid
isprimaryholder
WaterConnection.connectionHolders.*.isPrimaryOwner
connectionholdertype
WaterConnection.connectionHolders.*.ownerType
holdershippercentage
WaterConnection.connectionHolders.*.ownerShipPercentage
relationship
WaterConnection.connectionHolders.*.relationship
createdby
WaterConnection.auditDetails.createdBy
createdtime
WaterConnection.auditDetails.createdTime
lastmodifiedby
WaterConnection.auditDetails.lastModifiedBy
lastmodifiedtime
WaterConnection.auditDetails.lastModifiedTime
eg_ws_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
wsid (FK)
character varying (64)
water 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)
WaterConnection.plumberInfo.*.id
tenantid
WaterConnection.tenantId
name
WaterConnection.plumberInfo.*.name
licenseno
WaterConnection.plumberInfo.*.licenseNo
mobilenumber
WaterConnection.plumberInfo.*.mobileNumber
gender
WaterConnection.plumberInfo.*.gender
fatherorhasbandname
WaterConnection.plumberInfo.*.fatherOrHusbandName
correspondenceaddress
WaterConnection.plumberInfo.*.correspondenceAddress
relationship
WaterConnection.plumberInfo.*.relationship
wsid (FK)
WaterConnection.id
createdby
WaterConnection.plumberInfo.*.auditDetails.createdBy
createdtime
WaterConnection.plumberInfo.*.auditDetails.createdTime
lastmodifiedby
WaterConnection.plumberInfo.*.auditDetails.lastModifiedBy
lastmodifiedtime
WaterConnection.plumberInfo.*.auditDetails.lastModifiedTime
eg_ws_connection_audit
This table contains the connection audit table
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
WaterConnection.tenantId
property_id
.WaterConnection.propertyId
applicationno
.WaterConnection.applicationNo
applicationstatus
.WaterConnection.applicationStatus
status
.WaterConnection.status
connectionno
.WaterConnection.connectionNo
oldconnectionno
.WaterConnection.oldConnectionNo
action
.WaterConnection.processInstance.action
roadtype
.WaterConnection.roadType
adhocrebate
.WaterConnection.additionalDetails.adhocRebate
adhocpenalty
WaterConnection.additionalDetails.adhocPenalty
adhocpenaltyreason
WaterConnection.additionalDetails.adhocPenaltyComment
adhocpenaltycomment
WaterConnection.additionalDetails.adhocPenaltyReason
adhocrebatereason
WaterConnection.additionalDetails.adhocRebateReason
adhocrebatecomment
WaterConnection.additionalDetails.adhocRebateComment
createdby
WaterConnection.auditDetails.createdBy
createdtime
WaterConnection.auditDetails.createdTime
lastmodifiedby
WaterConnection.auditDetails.lastModifiedBy
lastmodifiedtime
WaterConnection.auditDetails.lastModifiedTime
applicationtype
WaterConnection.applicationType
dateeffectivefrom
WaterConnection.dateEffectiveFrom
locality
WaterConnection.additionalDetails.locality
isoldapplication
WaterConnection.oldApplication
additionaldetails
WaterConnection.additionalDetails
eg_ws_service
This table contains details of active water connections required for bill calculation.
connection_id (FK)
character varying (64)
System generated unique id for the entity to uniquely identify the record.
Y
connectioncategory
character varying (32)
Unique identifier for a tenant to which user primarily belongs
N
rainwaterharvesting
boolean
Is rainwater harvesting mechanism installed?
N
connectiontype
character varying (32)
Connection type
N
watersource
character varying (64)
Water source
N
meterid
character varying (64)
Meter ID of installed water meter
N
meterinstallationdate
bigint
Water meter installation date
N
pipesize
numeric ()
Pipesize
N
nooftaps
interger
Number of taps
N
connectionexecutiondate
bigint
Connection execution date
N
proposedpipesize
numeric ()
Proposed pipe size
N
proposedtaps
interger
Proposed number of taps
N
initialmeterreading
numeric (12,3)
Initial meter reading
N
appcreatedate
bigint
Application creation date
N
detailsprovidedby
character varying (256)
uuid of user who provided 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)
WaterConnection.id
connectioncategory
WaterConnection.connectionCategory
rainwaterharvesting
connectiontype
WaterConnection.connectionType
watersource
WaterConnection.waterSource
meterid
WaterConnection.meterId
meterinstallationdate
WaterConnection.meterInstallationDate
pipesize
WaterConnection.pipeSize
nooftaps
WaterConnection.noOfTaps
connectionexecutiondate
WaterConnection.connectionExecutionDate
proposedpipesize
WaterConnection.proposedPipeSize
proposedtaps
WaterConnection.proposedTaps
initialmeterreading
WaterConnection.additionalDetails.initialMeterReading
appcreatedate
WaterConnection.additionalDetails.appCreatedDate
detailsprovidedby
WaterConnection.additionalDetails.detailsProvidedBy
estimationfilestoreid
WaterConnection.additionalDetails.estimationFileStoreId
santionfilestoreid
WaterConnection.additionalDetails.sanctionFileStoreId
createdby
WaterConnection.auditDetails.createdBy
createdtime
WaterConnection.auditDetails.createdTime
lastmodifiedby
WaterConnection.auditDetails.lastModifiedBy
lastmodifiedtime
WaterConnection.auditDetails.lastModifiedTime
estimationletterdate
WaterConnection.additionalDetails.estimationLetterDate
eg_ws_service_audit
This table contains the audit details of active water connections.
connection_id (FK)
character varying (64)
System generated unique id for the entity to uniquely identify the record.
Y
connectioncategory
character varying (32)
Unique identifier for a tenant to which user primarily belongs
N
rainwaterharvesting
boolean
Is rainwater harvesting mechanism installed?
N
connectiontype
character varying (32)
Connection type
N
watersource
character varying (64)
Water source
N
meterid
character varying (64)
Meter ID of installed water meter
N
meterinstallationdate
bigint
Water meter installation date
N
pipesize
numeric ()
Pipesize
N
nooftaps
interger
Number of taps
N
connectionexecutiondate
bigint
Connection execution date
N
proposedpipesize
numeric ()
Proposed pipe size
N
proposedtaps
interger
Proposed number of taps
N
initialmeterreading
numeric (12,3)
Initial meter reading
N
appcreatedate
bigint
Application creation date
N
detailsprovidedby
character varying (256)
uuid of user who provided 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)
WaterConnection.id
connectioncategory
WaterConnection.connectionCategory
rainwaterharvesting
connectiontype
WaterConnection.connectionType
watersource
WaterConnection.waterSource
meterid
WaterConnection.meterId
meterinstallationdate
WaterConnection.meterInstallationDate
pipesize
WaterConnection.pipeSize
nooftaps
WaterConnection.noOfTaps
connectionexecutiondate
WaterConnection.connectionExecutionDate
proposedpipesize
WaterConnection.proposedPipeSize
proposedtaps
WaterConnection.proposedTaps
initialmeterreading
WaterConnection.additionalDetails.initialMeterReading
appcreatedate
WaterConnection.additionalDetails.appCreatedDate
detailsprovidedby
WaterConnection.additionalDetails.detailsProvidedBy
estimationfilestoreid
WaterConnection.additionalDetails.estimationFileStoreId
santionfilestoreid
WaterConnection.additionalDetails.sanctionFileStoreId
createdby
WaterConnection.auditDetails.createdBy
createdtime
WaterConnection.auditDetails.createdTime
lastmodifiedby
WaterConnection.auditDetails.lastModifiedBy
lastmodifiedtime
WaterConnection.auditDetails.lastModifiedTime
estimationletterdate
WaterConnection.additionalDetails.estimationLetterDate
eg_ws_roadcuttinginfo
This table contains the road cutting information for water 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
wsid (FK)
character varying(64)
Water 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)
WaterConnection.roadCuttingInfo.*.id
tenantId
WaterConnection.tenantId
wsid (FK)
active
WaterConnection.roadCuttingInfo.*.status
roadtype
WaterConnection.roadCuttingInfo.*.roadType
roadcuttingarea
WaterConnection.roadCuttingInfo.*.roadCuttingArea
createdby
WaterConnection.roadCuttingInfo.*.auditDetails.createdBy
createdtime
WaterConnection.roadCuttingInfo.*.auditDetails.createdTime
lastmodifiedby
WaterConnection.roadCuttingInfo.*.auditDetails.lastModifiedBy
lastmodifiedtime
WaterConnection.roadCuttingInfo.*.auditDetails.lastModifiedTime
Mapping Constructs
Last updated
