The assessment set of services inside the property module is used for assessing the value of a property in a given time frame and collect taxes for the same. Assessment is a snapshot of Property for a given transaction on that Property. These APIs provide functionalities to create/update/search the assessments. An assessment cannot exist without property.
Assessment shares most of the configs with Property as mentioned above, only exclusive properties are mentioned in this section.
Copy serviceMaps:
serviceName: property-services
mappings:
- version: 1.0
description: Persists assessment details to eg_pt_asmt_assessment table
fromTopic: save-pt-assessment
isTransaction: true
queryMaps:
- query: INSERT INTO eg_pt_asmt_assessment(id, tenantid, assessmentnumber, financialyear, propertyid, status, source, channel, assessmentdate, additionaldetails, createdby, createdtime, lastmodifiedby, lastmodifiedtime) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);
basePath: Assessment
jsonMaps:
- jsonPath: $.Assessment.id
- jsonPath: $.Assessment.tenantId
- jsonPath: $.Assessment.assessmentNumber
- jsonPath: $.Assessment.financialYear
- jsonPath: $.Assessment.propertyId
- jsonPath: $.Assessment.status
- jsonPath: $.Assessment.source
- jsonPath: $.Assessment.channel
- jsonPath: $.Assessment.assessmentDate
- jsonPath: $.Assessment.additionalDetails
type: JSON
dbType: JSONB
- jsonPath: $.Assessment.auditDetails.createdBy
- jsonPath: $.Assessment.auditDetails.createdTime
- jsonPath: $.Assessment.auditDetails.lastModifiedBy
- jsonPath: $.Assessment.auditDetails.lastModifiedTime
- query: INSERT INTO eg_pt_asmt_unitusage (tenantid, id, assessmentid, unitid, usagecategory, occupancytype, occupancydate, active, createdby, createdtime, lastmodifiedby, lastmodifiedtime) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);
basePath: Assessment.unitUsageList.*
jsonMaps:
- jsonPath: $.Assessment.unitUsageList.*.tenantId
- jsonPath: $.Assessment.unitUsageList.*.id
- jsonPath: $.Assessment[?({id} in @.unitUsageList[*].id)].id
- jsonPath: $.Assessment.unitUsageList.*.unitId
- jsonPath: $.Assessment.unitUsageList.*.usageCategory
- jsonPath: $.Assessment.unitUsageList.*.occupancyType
- jsonPath: $.Assessment.unitUsageList.*.occupancyDate
- jsonPath: $.Assessment.unitUsageList.*.active
- jsonPath: $.Assessment.unitUsageList.*.auditDetails.createdBy
- jsonPath: $.Assessment.unitUsageList.*.auditDetails.createdTime
- jsonPath: $.Assessment.unitUsageList.*.auditDetails.lastModifiedBy
- jsonPath: $.Assessment.unitUsageList.*.auditDetails.lastModifiedTime
- query: INSERT INTO eg_pt_asmt_document (id, tenantid, entityid, documenttype, filestoreid, documentuid, status, createdby, lastmodifiedby, createdtime, lastmodifiedtime) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);
basePath: $.Assessment.documents.*
jsonMaps:
- jsonPath: $.Assessment.documents.*.id
- jsonPath: $.Assessment.tenantId
- jsonPath: $.Assessment.id
- jsonPath: $.Assessment.documents.*.documentType
- jsonPath: $.Assessment.documents.*.fileStoreId
- jsonPath: $.Assessment.documents.*.documentUid
- jsonPath: $.Assessment.documents.*.status
- jsonPath: $.Assessment.documents.*.auditDetails.createdBy
- jsonPath: $.Assessment.documents.*.auditDetails.lastModifiedBy
- jsonPath: $.Assessment.documents.*.auditDetails.createdTime
- jsonPath: $.Assessment.documents.*.auditDetails.lastModifiedTime
- version: 1.0
description: Updates assessment details to eg_pt_asmt_assessment table
fromTopic: update-pt-assessment
isTransaction: true
queryMaps:
- query: INSERT INTO eg_pt_asmt_assessment_audit SELECT *, (SELECT extract(epoch from now())) FROM eg_pt_asmt_assessment WHERE id = ?;
basePath: Assessment
jsonMaps:
- jsonPath: $.Assessment.id
- query: INSERT INTO eg_pt_asmt_unitusage_audit SELECT *, (SELECT extract(epoch from now())) FROM eg_pt_asmt_unitusage WHERE id = ?;
basePath: Assessment.unitUsageList.*
jsonMaps:
- jsonPath: $.Assessment.unitUsageList.*.id
- query: UPDATE eg_pt_asmt_assessment SET financialyear = ?, status = ?, source = ?, assessmentDate = ?, additionaldetails = ?, lastmodifiedby = ?, lastmodifiedtime = ? WHERE id = ?;
basePath: Assessment
jsonMaps:
- jsonPath: $.Assessment.financialYear
- jsonPath: $.Assessment.status
- jsonPath: $.Assessment.source
- jsonPath: $.Assessment.assessmentDate
- jsonPath: $.Assessment.additionalDetails
type: JSON
dbType: JSONB
- jsonPath: $.Assessment.auditDetails.lastModifiedBy
- jsonPath: $.Assessment.auditDetails.lastModifiedTime
- jsonPath: $.Assessment.id
- query: INSERT INTO eg_pt_asmt_unitusage (tenantid, id, assessmentId, unitid, usageCategory, occupancyType, occupancyDate, active, createdby, createdtime, lastmodifiedby, lastmodifiedtime) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ON CONFLICT (id) DO UPDATE SET usageCategory = ?, occupancyType = ?, occupancyDate = ?, active = ?, lastmodifiedby = ?, lastmodifiedtime = ?;
basePath: Assessment.unitUsageList.*
jsonMaps:
- jsonPath: $.Assessment.unitUsageList.*.tenantId
- jsonPath: $.Assessment.unitUsageList.*.id
- jsonPath: $.Assessment[?({id} in @.unitUsageList[*].id)].id
- jsonPath: $.Assessment.unitUsageList.*.unitId
- jsonPath: $.Assessment.unitUsageList.*.usageCategory
- jsonPath: $.Assessment.unitUsageList.*.occupancyType
- jsonPath: $.Assessment.unitUsageList.*.occupancyDate
- jsonPath: $.Assessment.unitUsageList.*.active
- jsonPath: $.Assessment.unitUsageList.*.auditDetails.createdBy
- jsonPath: $.Assessment.unitUsageList.*.auditDetails.createdTime
- jsonPath: $.Assessment.unitUsageList.*.auditDetails.lastModifiedBy
- jsonPath: $.Assessment.unitUsageList.*.auditDetails.lastModifiedTime
- jsonPath: $.Assessment.unitUsageList.*.usageCategory
- jsonPath: $.Assessment.unitUsageList.*.occupancyType
- jsonPath: $.Assessment.unitUsageList.*.occupancyDate
- jsonPath: $.Assessment.unitUsageList.*.active
- jsonPath: $.Assessment.unitUsageList.*.auditDetails.lastModifiedBy
- jsonPath: $.Assessment.unitUsageList.*.auditDetails.lastModifiedTime
- query: INSERT INTO eg_pt_asmt_document (id, tenantid, entityid, documenttype, filestoreid, documentuid, status, createdby, lastmodifiedby, createdtime, lastmodifiedtime) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ON CONFLICT (id) DO UPDATE documenttype = ?, documentuid = ?, status = ?, lastmodifiedby = ?, lastmodifiedtime = ?;
basePath: $.Assessment.documents.*
jsonMaps:
- jsonPath: $.Assessment.documents.*.id
- jsonPath: $.Assessment.tenantId
- jsonPath: $.Assessment.id
- jsonPath: $.Assessment.documents.*.documentType
- jsonPath: $.Assessment.documents.*.fileStoreId
- jsonPath: $.Assessment.documents.*.documentUid
- jsonPath: $.Assessment.documents.*.status
- jsonPath: $.Assessment.documents.*.auditDetails.createdBy
- jsonPath: $.Assessment.documents.*.auditDetails.lastModifiedBy
- jsonPath: $.Assessment.documents.*.auditDetails.createdTime
- jsonPath: $.Assessment.documents.*.auditDetails.lastModifiedTime
- jsonPath: $.Assessment.documents.*.documentType
- jsonPath: $.Assessment.documents.*.documentUid
- jsonPath: $.Assessment.documents.*.status
- jsonPath: $.Assessment.documents.*.auditDetails.lastModifiedBy
- jsonPath: $.Assessment.documents.*.auditDetails.lastModifiedTime
The first property switches workflow on or off, while the second property provides a way to control which field change can trigger the workflow. A businessService needs to be created using the workflow /egov-workflow-v2/egov-wf/businessservice/_create API.
Copy {
"RequestInfo": {
"apiId": "Rainmaker",
"action": "",
"did": 1,
"key": "",
"msgId": "20170310130900|en_IN",
"requesterId": "",
"ts": 1513579888683,
"ver": ".01",
"authToken": "b39181b1-5c6b-484a-b825-6be2f62012b8"
},
"BusinessServices": [
{
"tenantId": "pb",
"businessService": "ASMT",
"business": "pt-services",
"businessServiceSla": 172800000,
"states": [
{
"sla": null,
"state": null,
"applicationStatus": null,
"docUploadRequired": false,
"isStartState": true,
"isTerminateState": false,
"isStateUpdatable": true,
"actions": [
{
"action": "INITIATE",
"nextState": "INITIATED",
"roles": [
"CITIZEN",
"PT_CEMP"
]
}
]
},
{
"sla": null,
"state": "INITIATED",
"applicationStatus": "INITIATED",
"docUploadRequired": false,
"isStartState": true,
"isTerminateState": false,
"actions": [
{
"action": "APPLY",
"nextState": "APPLIED",
"roles": [
"CITIZEN",
"PT_CEMP"
]
},
{
"action": "INITIATE",
"nextState": "INITIATED",
"roles": [
"CITIZEN",
"PT_CEMP"
]
}
]
},
{
"sla": null,
"state": "APPLIED",
"applicationStatus": "APPLIED",
"docUploadRequired": false,
"isStartState": false,
"isTerminateState": false,
"isStateUpdatable": true,
"actions": [
{
"action": "FORWARD",
"nextState": "FIELDINSPECTION",
"roles": [
"PT_DOC_VERIFIER"
]
},
{
"action": "REJECT",
"nextState": "REJECTED",
"roles": [
"PT_DOC_VERIFIER"
]
},
{
"action" : "SENDBACKTOCITIZEN",
"nextState" : "INITIATED",
"roles":["PT_DOC_VERIFIER"]
}
]
},
{
"sla": null,
"state": "REJECTED",
"applicationStatus": "REJECTED",
"isStateUpdatable": false,
"docUploadRequired": false,
"isStartState": false,
"isTerminateState": true
},
{
"sla": 86400000,
"state": "FIELDINSPECTION",
"applicationStatus": "FIELDINSPECTION",
"docUploadRequired": false,
"isStartState": false,
"isStateUpdatable": true,
"isTerminateState": false,
"actions": [
