Search…
⌃K

Water Data Model Specs

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

Description
Attributes
Mapping
This entity stores the water connection details.
Attribute Name
Data Type
Definition
Mandatory (Y/N)
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
Attribute Name
Mapping Details
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

Description
Attributes
Mapping
This entity stores the details of the documents uploaded by the user while submitting the application.
Attribute Name
Data Type
Definition
Mandatory (Y/N)
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
Attribute Name
Mapping Details
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

Description
Attributes
Mapping
This table contains the details of the user who has the water connection in the property.
Attribute Name
Data Type
Definition
Mandatory (Y/N)
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
Attribute Name
Mapping Details
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

Description
Attributes
Mapping
This table contains the plumber information.
Attribute Name
Data Type
Definition
Mandatory (Y/N)
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
Attribute Name
Mapping Details
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

Description
Attributes
Mapping
This table contains the connection audit table
Attribute Name
Data Type
Definition
Mandatory (Y/N)
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
Attribute Name
Mapping Details
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

Description
Attributes
Mapping
This table contains details of active water connections required for bill calculation.
Attribute Name
Data Type
Definition
Mandatory (Y/N)
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
Attribute Name
Mapping Details
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

Description
Attributes
Mapping
This table contains the audit details of active water connections.
Attribute Name
Data Type
Definition
Mandatory (Y/N)
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
Attribute Name
Mapping Details
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

Description
Attributes
Mapping
This table contains the road cutting information for water connection.
Attribute Name
Data Type
Definition
Mandatory (Y/N)
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