Versions Compared

Key

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

Introduction

This is a further sub classification of the usage types after minor category. Here the properties can be further classified such as commercial into food joints etc.

Data Table

Below mentioned is the data table from the template used to collect the data:

Sr. No.

Usage Category Sub Minor Code*

UsageCategoryMinorCode

Usage Category Minor Code*

Usage Category Sub Minor

Description

* (In English)

Usage Category

Detail Description

Sub Minor* (In Local Language)

EffectiveFromFY

ExemptionRate

Exemption Rate(In %)

MaxExemptionAmount

Max Exemption Amount

Flat Exemption Amount

Effective From Date

1

RESIDENTIAL

RESIDENTIAL

Residential

निवास

20140015

2

100

/-

200

/

01-04-2020

2

RETAIL

COMMERCIAL

Retail

खुदरा

20140015

3

300

/-

200

/

01-04-2020

3

HOTELS

COMMERCIAL

Hotels

होटल

20140015

5.1

200

/-

300

/

01-04-2020

Note: Data given in the table is a sample data.

Procedure

Data Definition

Sr. No.

Column Name

Data Type

Data Size

Is Mandatory?

Description

1

 Usage

Usage Category Sub Minor Code

Alphanumeric

64

Yes

 This

This is the unique code given to every category

2

 Usage

Usage Category Minor Code

Alphanumeric

64

Yes

 This

This is the relationship between sub minor and minor usage categories.

3

 Usage

Usage Category Sub Minor

Description

(In English) 

Text

256

Yes

 This

This is the description of the sub minor category in English

4

 Usage

Usage Category Sub Minor

Description

(In Local Language)

Text

256

No

Yes

 This

6

 Exemption

This is the description of the sub minor category in Local Language

5

 Effective From FY

Numeric

 

No

 Effectiveness year of the category

Exemption Rate (in % ) 

Numeric

Decimal

 (5,2)

No

 This

This column defines the rate of exemption in tax in % to which the property tax could be exempted.

7

6

 Max

Max Exemption Amount 

Numeric

Decimal

 (5,2)

No

 This

This is the maximum amount which the property can be exempted from

8

7

 Flat

Flat Exemption Amount 

Numeric

Decimal

 (5,2)

No

 This

This is the flat amount by which the property owner can be exempted

8

Effective From Date

Date

NA

Yes

This the date from which the exemption is applicable.

Steps 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 all the sub minor categories used across the state.

  5. After which identify the codes of all the sub minor categories, if not present abbreviate the description.

  6. Get the details(description) of these codes.

  7. Start filling the template with the codes and description in English and one native language would be helpful.

  8. Get the exemption maximum amounts and their respective percentages.

  9. Most importantly do get a mapping of these sub minor codes to their parent which is minor usage type.

  10. Verify the data once again by going through the checklist and making sure that each and every point mentioned in the checklist is covered.

Checklist

The checklist is a set of activities to be performed one on 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.

Every sub minor code should be unique.

-

2.

No parent mapping code(i.e minor) can be given which is not a part of prior data sent for minors, majors etc.

-

Not Applicable

Attachments

1.Configurable Template for Usage Category Sub Minor

View file
nameConfigurable Data Template PT UsageTypeSubMinor.xlsx

2. Configurable Sample Data for Usage Category Sub Minor

View file
nameSample Configurable Sample Data PT UsageType Minor.xlsx