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

• echallan_id

• echallan_address

Data Constructs

echallan_id

Description

This table store the challan details created by an employee for the ad-hoc services.

Attributes

Attribute Name	Data Type	Definition	Mandatory (Y/N)
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

Mapping

Attribute Name	Mapping Details
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

Description

This table stores the address details of the citizen (applicant) to whom challan is issued.

Attributes

Attribute Name	Data Type	Definition	Mandatory (Y/N)
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

Mapping

Attribute Name	Mapping Details
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.