Versions Compared

Key

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

...

Dependent on the Trade Classification Level (Types/ Subtypes), the fee allocated might be same across the Sate or could vary from ULB to ULB. There could be a distinct fee(s) for two different types of applications (new and renewal).

...

(Note: The Rows in the above table consists of Sample Data)

Procedure

Data Definition(s)

Sr. No

...

Trade Subtype Code: Unique Identifier for Trade Sub Type which is used as a reference for child configuration mapping.

...

Trade Subtype Name (Eng): Nomenclature of “Trade Sub Type ” in English.

...

.

Column Name

Data Type

Data Size

Mandatory

Description

1

Trade Sub Type Code

Text

64

Yes

The Code assigned to the Trade Sub Type. Eg: TRADE_TYPE_Dhaba is assigned to Hospitals

2

Trade Sub Type Name (English)

Text

256 

Yes

Name of the Trade Sub Type in English. Eg: Small Bakery

3

New License Fee

Number

64

Yes

The fee charged as when the license applied for the respective trade for the first time.

4

Renewal License Fee

...

Number

64

Yes

The fee charged as

...

when the license applied for the respective trade for the renewal.

5

UOM Unit

...

Text

64

No

The Units of Measurement” associated with the Trade. Eg : Workers is the UOM associated with the trade “Bakery”

6

UOM From

...

Number

64

No

Initial Range from which the “Units of Measurement” is applicable for a Trade

...

7

UOM To

...

Number

64

No

Final Range to which the “Units of Measurement” is applicable to a Trade

...

...

How to fill data

  1. Download the data template attached to this page.

  2. Get a good understanding of all the headers in the template sheet, their data type, size, and definitions by referring to the ‘Data Definition’ section of this document.

  3. In case of any doubt, please reach out to the person who has shared this template with you to discuss and clear your doubts.

  4. Identify the “Trade Sub Types” that exists at a ULB/ State level.

  5. Collect the above information and feed it below the “Trade Sub Type Name” column accordingly.

...

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

  2. Add the “Trade Sub Type Code” respectively against the identified trade type(s)

...

  1. .

  2. Fill in the New License Fee & New Renewal Fee accordingly.

...

  1. The New License Fee & Renewal Fee can be the same as well as distinct, depending on the by-laws/ mandate followed by the State/ULB.

  2. Fill in the fields related to Units of Measurement (UOM Unit, From/To) for the available trades only.

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 Trade Rates must be defined as a “Whole Number” and must not be :

    • In Range.

    • In Fractions/ Decimals.

Attachments

...

Checklist

The checklist is a set of activities to be performed one the data is filled into a template to ensure data type, size, and format of data is as per the expectation. 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_SMALL_BAKERY

2

Trade Type Name (In either Languages) should not contain any special characters.

Small Bakery: [Allowed]

#Small_Bakery! : [Not allowed]

3

The New/ Renew License Fee should be a whole number only.

1500: [Allowed]

1500-2000 :[Not allowed]

4

The UOM Unit must only be in text and unique.

Workers : [Allowed]

3 Workers : [Not Allowed]

5

The UOM From must be a whole number only.

1 : [Allowed]

1-3 : [Not allowed]

6

The UOM To must be a whole number only.

3 : [Allowed]

1-3 : [Not allowed]

Attachments

  1. Refer to “Trade License Fee Tab” in the uploaded template. This sheet consists of a blank template for filling in the data.

View file
nameTemplate_Trade_Masters Data.xlsx

2. Refer to “Trade License Fee Tab” in the uploaded template. This sheet consists of sample data for reference.

View file
nameTL_Master_Data (Sample).xlsx

...