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
Note: This is only sample data. Actual tenant records must follow the validation rules described below.
The following table specifies every column in the Tenant Master sheet, including data type, size, mandatory fields, and 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://.
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
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.
Download the Tenant Master Template.
Review all column headers and understand each field as per the Data Definition table.
Ensure all mandatory fields (*) are filled correctly.
Enter data row by row. Complete one full record before starting the next.
Follow the Excel validations applied to each field.
After completing all entries, verify the file using the Checklist.
Submit the validated file for MDMS ingestion.
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.
Last updated
Was this helpful?
Was this helpful?
