Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Introduction

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 Code

*Trade Sub Type Name* (In English)

Trade Sub Type Name* (In Local Language)

Trade Type Code*

1

TRADE_TYPE_MEDICALTRADE_SUBTYPE_CLINIC

Clinic

क्लिनिक2

TRADE_TYPE_HOTELMEDICAL

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 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 Hotels

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: Dhaba is described as “ढाबा” in Hindi.

Steps to create Trade Sub Type master data table

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

  1. Download the data template attached to this page.

  2. Refer to the ‘Data Definition’ section of this document to learn more about the template sheet, data type, size, and definitions.Please reach out to the person who has shared this template with you to discuss and clear your doubts.

  3. 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.

  4. Enter a unique value for Trade Sub Type Code.

  5. Enter the English name for Trade Sub Type Name (English).

  6. 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.

Checklist

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]


Attachments

Configurable Data Template -Trade Sub Type

(Refer to “Trade Sub Type” tab in the attached file).

View file
nameConfiguration Data Template- Trade Master.xlsx

Sample Configurable Data- Trade Sub Type

View file
nameSample Configuration Data Template- Trade Master (Filled).xlsx