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)Trade Type can be further sub-classified into Trade Sub Type depending on the trade ontology existing in the ULBs or States. Hence, Hotels can be further classified into Dhabas in North India or Udupis in South India.
Once the Trade Type(s) are defined, the next task is to define :-
“Trade Define Trade Sub Types”.Types
Map “Trade Types” & “Sub Types”Trade Types to corresponding Trade Sub Types
Data Table
Sr. No. | *Trade Sub Type Code*Trade Sub Type Code | *Trade Sub Type Name* (In English) | Trade Sub Type Name* (In Local Language) | Trade Type Code* | |
---|---|---|---|---|---|
1TRADE_TYPE_MEDICAL | TRADE_SUBTYPE_CLINIC | Clinic | क्लिनिक | 2 | TRADE_TYPE_HOTELMEDICAL |
2 | TRADE_SUBTYPE_DHABA | Dhaba | ढाबा | TRADE_TYPE_HOTEL |
Note: Data given in the The above table is a contains sample Trade Sub Type data.
Procedure
Data Definition
Sr. No. | Column Name | Data Type | Data Size | Is Mandatory? | Description | ||||||
---|---|---|---|---|---|---|---|---|---|---|---|
1 | Trade Type Code | Reference | 64 | Yes | The Code assigned to the Trade Type. Eg: TRADE_TYPE_MEDICAL is assigned to Hospitals | 2 | Trade Sub Type Code | Alphanumeric | 64 | Yes | The Code assigned to the Trade Sub Type. Eg: TRADE_TYPE_Dhaba is assigned to HospitalsHotels |
32 | Trade Sub Type Name (In English) | Text | 256 | Yes | Name of the Trade Sub Type in English. Eg: Clinic | ||||||
43 | Trade Sub Type Name (In Local Language) | Text | 256 | Yes | Name of the Trade Sub Type in Local Language (as decided). Eg: Dhabais Dhaba is described as “ढाबा” in Hindi. |
4 | Trade Type Code | Reference | 64 | Yes | The Code assigned to the Trade Type. Eg: TRADE_TYPE_MEDICAL is assigned to Hospitals |
Steps to fill data
Download the data template attached to this page.
Get a good understanding of all the headers in Refer to the ‘Data Definition’ section of this document to learn more about 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”.
Select the relevant Trade Type Code from the Trade Type master data. This will map the listed Trade Sub Type to the selected Trade Type.
Enter a unique value for Trade Sub Type Code.
Enter the English name for Trade Sub Type Name (English).
Enter the local name for the Trade Sub Type Name (Local Language).
Checklist
The checklist is contains a set of activities to be performed one once the data is filled into a template to ensure data type, size, and format of data is as per the expectationentry requirements are met. 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 Sub Type Code defined should be text and unique. | TRADE_TYPESUBTYPE_MEDICALCLINIC |
2 | Trade Type Name (In in either Languageslanguage) should not contain any special characters. | Clinic: [Allowed] #Clinic! : [Not allowed] |