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 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 Sub
...
Types
Map
...
Trade Types to corresponding Trade Sub Types
Data Table
Sr. No. |
|---|
...
Trade Sub Type Code |
|---|
...
* |
|---|
...
...
Trade Sub Type Name* (In English) | Trade Sub Type Name* (In Local Language) |
|---|
...
Procedure
Field(s) Description
...
Sr.No: Defines the serial no of the line item.
...
Trade Type Code: Unique Identifier for Trade Type as defined in the Trade Type master.
...
Trade Sub Type Code: Unique Identifier for Trade Sub Type which is used as a reference for child configuration mapping.
...
Trade Sub Type Name: Nomenclature of “Trade Sub Type ” in English.
...
Trade Type Code* | ||||
|---|---|---|---|---|
1 | TRADE_SUBTYPE_CLINIC | Clinic | क्लिनिक | TRADE_TYPE_MEDICAL |
2 | TRADE_SUBTYPE_DHABA | Dhaba | ढाबा | TRADE_TYPE_HOTEL |
Note: The above table contains sample Trade Sub Type data.
Procedure
Data Definition
Sr. No. | Column Name | Data Type | Data Size | Is Mandatory? | Description |
|---|---|---|---|---|---|
1 | Trade Sub Type Code | Alphanumeric | 64 | Yes | The Code assigned to the Trade Sub Type. Eg: TRADE_TYPE_Dhaba is assigned to Hotels |
2 | Trade Sub Type Name (In English) | Text | 256 | Yes | Name of the Trade Sub Type in English. Eg: Clinic |
3 | Trade Sub Type Name (In Local Language) | Text | 256 | Yes | Name of the Trade Sub Type in Local Language (as decided). Eg: 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
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).
The format of the Trade Sub Type Code will either be predefined or can be a continuous numeric/ alphanumeric sequence as per the requirement.
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”.
Validations
All the fields with * sign are mandatory to be filled in. Without this information, the system configurations cannot be executed.
A “single entry” should be made against the respective column. Incase of multiple entries, continuation must be followed.
The “Trade Sub Type Name” must be provided in the required language as mentioned against the respective column.
The format of Trade Sub Type Code must be informed to the individual/team responsible for filling in the master data.
The Code filled in for “Trade Type” column must be referred from Trade Type Master sheet only. Else, the mapping between Trade Type & Trade Sub Type won't be attainable.
Attachments
Refer to “Trade Sub Type Tab” in the uploaded template. This consists of sample data for reference.
Download the data template attached to this page.
Refer to the ‘Data Definition’ section of this document to learn more about the template sheet, data type, size, and definitions.
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 contains a set of activities to be performed once the data is filled into a template to ensure data entry 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_SUBTYPE_CLINIC |
2 | Trade Type Name (in either language) should not contain any special characters. | Clinic: [Allowed] #Clinic! : [Not allowed] |