# Tenant Master

## Overview

The Tenant Master defines the core administrative details of each tenant (ULB/City/State).\
This information is essential for configuring branding, location mapping, and service-level operations on the DIGIT platform.

The Tenant Master sheet also includes Excel-level validations such as dropdowns, text restrictions, coordinate checks, and format validations to ensure data accuracy before uploading to MDMS.

Tenant Template: [Tenant Master](https://docs.google.com/spreadsheets/d/1V9_DkR0WKm7CtZ4Rfcy-3yNtaPj5zL7VKXXvGjXquWs/edit?gid=2052883679#gid=2052883679)

***

## Data Table

<table><thead><tr><th width="76.125">S.No.</th><th>Tenant Display Name*</th><th>Tenant Code*</th><th>Tenant Type*</th><th>City Name</th><th>District Name</th><th>Latitude</th><th>Longitude</th><th>Address</th><th>Tenant Website</th><th>Logo File Path*</th></tr></thead><tbody><tr><td>1</td><td>City A ULB</td><td>PG.CITYA</td><td>City</td><td>City A</td><td>District</td><td>32</td><td>32.4</td><td>City Address</td><td><a href="https://unified-uat.digit.org">https://unified-uat.digit.org</a></td><td>./dsa.png</td></tr></tbody></table>

{% hint style="info" %}
**Note:** This is only sample data. Actual tenant records must follow the validation rules described below.
{% endhint %}

***

## Data Definition

The following table specifies every column in the Tenant Master sheet, including data type, size, mandatory fields, and description.

<table><thead><tr><th width="65.8671875">Sr. No.</th><th width="119.15625">Column Name</th><th width="131.75390625">Data Type</th><th width="97.9921875">Data Size</th><th width="109.71484375">Mandatory?</th><th>Definition / Description</th></tr></thead><tbody><tr><td>1</td><td>Tenant Display Name</td><td>Text</td><td>256</td><td>Yes</td><td>Official display name of the tenant as visible to citizens and administrators.</td></tr><tr><td>2</td><td>Tenant Code</td><td>Alphanumeric</td><td>64</td><td>Yes</td><td>A unique identifier assigned by the ADMIN team. Supports alphanumeric and dot (.).</td></tr><tr><td>3</td><td>Tenant Type</td><td>Text</td><td>64</td><td>Yes</td><td>Category of tenant such as City, State, Municipality. Selected from a predefined dropdown list.</td></tr><tr><td>4</td><td>Logo File Path</td><td>Text</td><td>NA</td><td>Yes</td><td>Relative file path of tenant logo used for branding. Must follow valid path format.</td></tr><tr><td>5</td><td>Latitude</td><td>Numeric (Decimal)</td><td>64</td><td>No</td><td>Geographic latitude of the tenant’s central location. Must be between −90 and +90.</td></tr><tr><td>6</td><td>Longitude</td><td>Numeric (Decimal)</td><td>64</td><td>No</td><td>Geographic longitude of the tenant’s central location. Must be between −180 and +180.</td></tr><tr><td>7</td><td>City Name</td><td>Text</td><td>256</td><td>No</td><td>The recognized city/ULB name. Alphabets and spaces only.</td></tr><tr><td>8</td><td>District Name</td><td>Text</td><td>256</td><td>No</td><td>Name of the district to which the tenant belongs. Accepts alphabets and spaces.</td></tr><tr><td>9</td><td>Address</td><td>Text</td><td>256</td><td>No</td><td>Official address of the tenant office/jurisdiction. Basic format checks applied.</td></tr><tr><td>10</td><td>Tenant Website</td><td>Text (URL)</td><td>256</td><td>No</td><td>Official website of the tenant. Must start with https:// or http://.</td></tr></tbody></table>

***

## Excel Validation Framework

The Tenant Master sheet includes strong validation rules to ensure:

* No malformed data enters the system
* Consistent naming and coding conventions
* Valid geographic data for map services
* High-quality data before MDMS ingestion

#### Types of Validations Applied

<table><thead><tr><th width="267.77734375">Validation Type</th><th>Description</th></tr></thead><tbody><tr><td>Alphabet Restriction</td><td>Ensures clean text-only input for City/District names.</td></tr><tr><td>Structured Code Format</td><td>Allows only alphanumeric + dot (.) for Tenant Code.</td></tr><tr><td>Dropdown-Based Selection</td><td>Restricts Tenant Type to predefined valid categories.</td></tr><tr><td>Geo-Coordinate Validation</td><td>Enforces correct latitude/longitude ranges.</td></tr><tr><td>URL Format Check</td><td>Ensures the website starts with valid protocols.</td></tr><tr><td>File Path Verification</td><td>Confirms valid relative path structure for logo.</td></tr></tbody></table>

***

## Steps to Fill Data

1. Download the Tenant Master Template.
2. Review all column headers and understand each field as per the Data Definition table.
3. Ensure all mandatory fields (\*) are filled correctly.
4. Enter data row by row. Complete one full record before starting the next.
5. Follow the Excel validations applied to each field.
6. After completing all entries, verify the file using the Checklist.
7. Submit the validated file for MDMS ingestion.

***

## Checklist

#### Common Checklist

* Field data type matches expected formats.
* Mandatory fields are not left blank.
* No special characters are used in restricted fields.
* Latitude/Longitude values are valid and numeric.
* URL fields start with https\:// or http\://.
* Logo file paths follow the expected directory structure.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.digit.org/complaints-management/complaints-resolution-v2.10/deploy/configure/master-data/master-data-templates/tenant-master.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.