Versions Compared

Key

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

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

...

*Trade Type Code

Sr. No.

Trade Sub Type Code*

...

Trade Sub Type Name* (In English)

Procedure

Trade Sub Type Name* (In Local Language)

Trade Type Code

...

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.

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.

...

*

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

  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.

  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