Versions Compared

Key

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

Introduction

The Usage category could be more detailed out on classifying them further and detailing more specifically on what kind of usage it is such as hotel, shops, community center etc.

Data Table

Below mentioned is the definition of the template which is used in data gathering;:

Sr. No.

Usage Category Detail Code*

UsageCategorySub MinorCode*

UsagecategoryMinorCode*

UsageCategoryMajorUsage Category Sub Minor Code*

Usage Category Detail Desctipion* (In English)*

Usage Category Detail Desctipion * (In Local Language)

ARVM Factor*

EffectiveFromFY*

ExemptionRateExemption (In %)*

MaxExemptionAmount*

FlatExemptionAmount

Exemption Flat Amount

Exemption Max Amount

Effective FY*

1.

1

R1

 RESRED

RESIDENTIALRESIDENTIAL

Residential

आवासीय

3

 2019

 2

200/- 

 100/-2019-20

2.2

NONRED

A

TAP

Commercial

NONRESIDENTIALHOTELS

Hotel/ Paying Guest House up to 10 rooms (without air-conditioned)

होटल पेईग गेस्ट हाउस 10 कमरों तक (बेगैर वातानुकूलित)

1

2018 

1.2 

300/- 

100/- 2018-19

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 Detail Code

Alphanumeric

64

Yes

 This This column ideally contains the code for which the Usage Category Detail is being categorized

2

 Usage Usage Category Sub Minor Code 

Alphanumeric

64

Yes

 This This is the mapping between detail and Sub Minor Code

3

 Usage Category Minor Code 

Alphanumeric

64

Yes

 This is the mapping between Sub Minor and Minor Code

4

 Usage Category Major Code 

Alphanumeric

64

Yes

 This is the mapping between Minor and Major Code

5

 Usage Category Detail Description (. Refer Sub Minor entity for more detail.

3

Usage Category Detail (In English) 

Text

256

Yes

 DescriptionDescription/ Detail of the detail code in which the category is being classified in English Language6

4

 Usage Usage Category Detail Description (In Local Language) 

Text

256

NoYes

 DescriptionDescription/ Detail of the detail code in which the category is being classified in English Language

7

 ARV M Factor

Numeric

 (12,2)

No

 Its an Annual value multiplication factor through which the final value of property tax is multiplied based upon the type of usage category detail type

8

 Effective From FY

Numeric

 (12,2)

No

 This is the year from which the category has come into effect for property tax

9

 Exemption Rate(in % ) 

Numeric

 (12Local Language. e.g. Hindi, Telugu etc.

5

Exemption (In % ) 

Decimal

(5,2)

No

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

6

 Max Exemption Amount Flat Amount

NumericDecimal

 (125,2)

No

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

7

 Flat Exemption Max Amount 

NumericDecimal

 (125,2)

No

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

8

Effective FY

Text

 64

Yes

This is the year from which the category detail has come into effect for property tax

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. Gather all the details for this last classification of Usage Category Detail.

  5. Figure out the codes, if not present abbreviate the description so that it creates a relevancy between code and description.

  6. Get the relations to the sub minor, minor and major.

  7. Start filling the template with the codes and description of the usage Category detail and then followed by relative codes of sub minor, minor and at last major.Now start getting the exemption rates as well as % percentage with their effective dates which could be the beginning of financial yearsub minor codes.

  8. In the active column fill up weather the category is still active or not.

  9. Also get the ARV M factor for every detail 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

2.

There should be a mapping between usage category detail, https://digit-discuss.atlassian.net/browse/IP-914 , Usage Category Minor and https://digit-discuss.atlassian

.

net/browse/IP-912 .

-

3.

No other codes for sub minor, minor, major should be used which are not a part of prior data sent for these categories.

-

Attachments

1.Configurable Template Usage Type Detail

View file
nameConfigurable Template PT UsageTypeDetailData Template - Usage Category Detail_V1.xlsx

2. Configurable Sample Data Usage Type Detail

View file
nameConfigurable Sample Data PT UsageTypeDetail V1.xlsx