Introduction
Depending on the ULB/State requirement to streamline the trade ontology, there can be a third trade entity defined as “Trade Sub Type”.
Trade Sub Type is the (3rd) level classification to the Trade and can be considered as the segmentation, where a trade type is divided into multiple trade subtype(s).
Once the Trade Type(s) are defined, the next task is to define :
“Trade Sub Types”.
Map “Trade Types” & “Sub Types”
Data Table
Sr.No. | *Trade Type Code | *Trade Sub Type Code | *Trade Sub Type Name (English) | Trade Sub Type Name (Local Language) |
|---|---|---|---|---|
1 | TRADE_TYPE_MEDICAL | TRADE_SUBTYPE_CLINIC | Clinic | क्लिनिक |
2 | TRADE_TYPE_HOTEL | TRADE_SUBTYPE_DHABA | Dhaba | ढाबा |
Note: Data given in the above table is a sample data.
Procedure
Sr. No. | Column Name | Data Type | Data Size | Mandatory | Description |
|---|---|---|---|---|---|
1 | Trade Type Code | Text | 64 | Yes | The Code assigned to the Trade Type. Eg: TRADE_TYPE_MEDICAL is assigned to Hospitals |
2 | Trade Sub Type Code | Text | 64 | Yes | The Code assigned to the Trade Sub Type. Eg: TRADE_TYPE_Dhaba is assigned to Hospitals |
3 | Trade Sub Type Name (English) | Text | 256 | Yes | Name of the Trade Sub Type in English. Eg: Clinic |
4 | Trade Sub Type Name (Local Language) | Text | 256 | Yes | Name of the Trade Sub Type in Local Language (as decided). Eg: Dhabais described as “ढाबा” in Hindi. |
How to fill data
Download the data template attached to this page.
Get a good understanding of all the headers in the template sheet, their data type, size, and definitions by referring to the ‘Data Definition’ section of this document.
In case of any doubt, please reach out to the person who has shared this template with you to discuss and clear your doubts.
Identify the “Trade Sub Types” that exists at a ULB/ State level.
Collect the above information and feed it below the “Trade Sub Type Name” column accordingly. The Description of Trade Sub Type Name must be provided as per the language specified in the respective column.
Add the “Trade Sub Type Code” respectively against the identified trade type(s).
Fill in the appropriate Trade Type Code from “Trade Type ” master for the respective trade type accordingly. The predefined format of the Trade Type Code only must be used from Trade Type Master Sheet and not any random code.
The respective mapping between Trade Categories & Trade Types is defined by columns “ Trade Category Code” & “Trade Type Code”.
Checklist
The checklist is a set of activities to be performed one the data is filled into a template to ensure data type, size, and format of data is as per the expectation. These activities have been divided into 2 groups as given below.
Common Checklist
This checklist covers all the activities which are common across the entities.
Sr. No. | Checklist Parameter | Example |
|---|---|---|
1 | Make sure that each and every point in this reference list has been taken care of. |
Entity Specific Checklist
This checklist covers the activities which are specific to the entity.
Sr. No. | Checklist Parameter | Example |
|---|---|---|
1 | The format of the Trade Type Code defined should be text and unique. | TRADE_TYPE_MEDICAL |
2 | The format of the Trade Sub Type Code defined should be text and unique. | TRADE_SUBTYPE_DHABA |
3 | Trade Type Name (In either Languages) should not contain any special characters. | Clinic: [Allowed] #Clinic! : [Not allowed] |
Attachments
Refer to “Trade Sub Type Tab” in the uploaded template. This sheet consists of a blank template for filling in the data.
2. Refer to “Trade Sub Type Tab” in the uploaded template. This sheet consists of sample data for reference.