Tenant Master

Introduction

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

---

Data Table

S.No.	Tenant Display Name*	Tenant Code*	Tenant Type*	City Name	District Name	Latitude	Longitude	Address	Tenant Website	Logo File Path*
1	City A ULB	PG.CITYA	City	City A	District	32	32.4	City Address	https://unified-uat.digit.org	./dsa.png

Note: This is only sample data. Actual tenant records must follow the validation rules described below.

---

Procedure

Data Definition

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

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

---

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

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

---

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.