Miscellaneous Collections Data Model
eChallan or the mCollect system enables employees to generate the challans for Adhoc services so that the payment can be recorded into the system along with service-specific details.
mCollect Service Entity Details
Data Constructs
echallan_id
This table store the challan details created by an employee for the ad-hoc services.
id (PK)
varchar
The system generated unique id(UUID)
Y
accountid
varchar
UUID of the user(citizen) requesting the service
Y
tenantid
varchar
Unique identifier for a tenant to which user primarily belongs
Y
challanNo
varchar
Unique ref Number for the Challan created
Y
businessService
varchar
The category for which the Challan is created
Y
referenceid
varchar
Unique identifier of the entity for which the challan is generated
N
applicationStatus
varchar
Challan status - Active, Expired and Cancelled
Y
additionalDetail
jsonb
Json object to capture any extra information which is not accommodated in the model
N
taxperiodFrom
int
Date range used for demand generation for the challan
Y
taxperiodTo
int
Date range used for demand generation for the challan
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
filestoreid
varchar
Filestore id of challan pdf
N
description
varchar
Additional information or description of the challan
N
id (primary key)
$.Challan.id
accountid
$.Challan.citizen.uuid
tenantid
$.Challan.tenantId
challanNo
$.Challan.challanNo
businessService
$.Challan.businessService
referenceid
$.Challan.referenceId
applicationStatus
$.Challan.applicationStatus
additionalDetail
$.Challan.additionalDetail
taxperiodFrom
$.Challan.taxPeriodFrom
taxperiodTo
$.Challan.taxPeriodTo
createdby
$.Challan.auditDetails.createdBy
lastmodifiedby
$.Challan.auditDetails.lastModifiedBy
createdtime
$.Challan.auditDetails.createdTime
lastmodifiedtime
$.Challan.auditDetails.lastModifiedTime
filestoreid
$.Challan.filestoreid
description
$.Challan.description
echallan_address
This table stores the address details of the citizen (applicant) to whom challan is issued.
id (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
N
plotno
varchar
Plot number of the house
N
latitude
FLOAT
The latitude location details of the user address
N
longitude
FLOAT
The longitude location details of the user address
N
buildingName
varchar
Name of the building
N
landmark
varchar
Additional location detail to help find the address of user
N
street
varchar
Street name
N
city
varchar
City of the address. It can be representated by the tenantid
N
district
varchar
The district of the address
N
region
varchar
The region where user resides
N
state
varchar
The State where user resides
N
country
varchar
Country of user
N
locality
varchar
Locality of user
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
echallanid (FK)
varchar
Unique identifier of the challan
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
id (primary key)
$.Challan.address.id
tenantid
$.Challan.address.tenantId
doorno
$.Challan.address.doorNo
plotno
$.Challan.address.plotNo
latitude
$.Challan.address.latitude
longitude
$.Challan.address.longitude
buildingName
$.Challan.address.buildingName
landmark
$.Challan.address.landmark
street
$.Challan.address.street
city
$.Challan.address.city
district
$.Challan.address.district
region
$.Challan.address.region
state
$.Challan.address.state
country
$.Challan.address.country
locality
$.Challan.address.locality.code
pincode
$.Challan.address.pincode
detail
$.Challan.address.detail
echallanid (foreign key)
$.Challan.id
createdby
$.Challan.auditDetails.createdBy
lastmodifiedby
$.Challan.auditDetails.lastModifiedBy
createdtime
$.Challan.auditDetails.createdTime
lastmodifiedtime
$.Challan.auditDetails.lastModifiedTime
Mapping Constructs
All content on this page by eGov Foundation is licensed under a Creative Commons Attribution 4.0 International License.
Last updated
Was this helpful?