Versions Compared

Key

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

Introduction

Other than streamlining apply/collection process, the key agenda of Trade License as an application is to re-engineer the discombobulated trade master data (across ULB/ State) into a subtle, simplified, and organized consumable chunk. This re-engineering process is a pivotal necessity for the Trade License application to function efficiently, providing a better data user experience to the multiple involved stakeholders.

...

The Trade Category List can be defined as

...

the primary or the 1st level classification “head” for trade(s) defined at a ULB/State Level.

Data Table

...

Sr.No.

Trade Category Code*

Trade Category Name* (In English)

Trade Category Name* (In Local Language)

1

TC1

Goods

सामग्री

2

TC2

Services

सर्विस

Note: The table above contains sample Trade Category data.

Procedure

Data Definition

...

Sr. No.

Column Name

Data Type

Data Size

Is Mandatory?

Description

1

Trade Category Code

...

Alphameric

 64

Yes

The Code assigned to the Trade Category. Eg: TC1 For Goods, TC2 for Services.

2

Trade Category Name (In English)

Text

256 

Yes

Name of the Trade Category in English. Eg: Goods, Services etc.

3

Trade Category Name (In Local Language)

Text

256 

Yes

Name of the Trade Category in Local Language (as decided). Eg: Service is described as “सर्विस” in Hindi.

Steps to fill data

  1. Identify the “Trade Categories” that exists at a ULB/ State level.

    1. Priorly, there are certain trade categories already defined as the master (Reference of Data Definitions by previous implementations).

    2. Incase any new trade categories are identified, add the same.

  2. Collect the above information and feed it below the “Trade Category Name” column accordingly.

    1. The Description of Trade Category Name must be provided as per the language specified in the respective column.

    2. The Description must be kept short and precise.

  3. Add the “Trade Category Code” respectively against the identified trade categories(s).

    1. The format of the Trade Category will either be predefined or can be a continuous numeric sequence as per the requirement.

Data Template 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 Category Description” must be provided in the required language as mentioned against the respective column. The Description must be kept short and precise.

  • The format of Trade Category must be informed to the individual/team responsible for filling in the master data.

Template Attachments

  • Refer to “Trade Category Tab” in the uploaded template. This consists of sample data for reference.

View file
nameTL_Master_Data (Sample).xlsx

Template Filling Checklist

  • Refer to following checklist specific to “Trade Categories” :

...

Defined Parameter

...

Check Marker

...

Identification of Trade Categories (At State/ULB level).

...

Trade Category Code format is followed

...

Trade Category Description is short and precise.

...

Check for Duplicates in Trade Category Description/Codes

...

All fields starting with * are filled

...

  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. Enter a unique Trade Category Code for each trade head.

  4. Enter the Trade Category Name. Some trade categories are already defined in the master. Add new categories as required.

  5. Enter the Trade Category 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 Category Code defined should be alphanumeric and unique.

TC1 : Goods

TC2: Services

2

Trade Category Name (In either Language) should not contain any special characters.

Goods: [Allowed]

#Goods! : [Not allowed]


Attachments

Configurable Data Template -Trade License Category

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

View file
nameConfiguration Data Template- Trade Master.xlsx

Sample Configurable Data- Trade License Category

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