Smart Device Schema

• File Name: smartdevice.parquet
• Type: Full
• Schema Version: 01.00
• Last Updated: 2026-02-25

Description

Contains master data for smart devices (IoT sensors, cameras, and monitoring equipment) including hardware specifications, connectivity information, and installation status.

Fields

📋 Includes Common Fields: Client Information, Location Information, Asset Information

Column Name	Data Type	Description
SmartDeviceId	int	Unique identifier for the smart device
SmartDeviceSerialNumber	varchar	Serial number of the smart device
SmartDeviceType	varchar	Type of smart device
MacAddress	varchar	MAC address
Imei	varchar	International Mobile Equipment Identity
SimNum	varchar	SIM card number
FirmwareVersion	varchar	Firmware version
HardwareVersion	varchar	Hardware version
InventoryLocation	varchar	Inventory location
ShippingDate	datetime	Shipping date
DeliveryDate	datetime	Delivery date
WarrantyEndDate	datetime	Warranty end date
InstallationDate	datetime	Installation date
LastPing	datetime	Last ping timestamp (local time)
LastPingUTC	datetime	Last ping timestamp (UTC)
ModifiedOn	datetime	Record modification timestamp
LatestRssi	int	Latest signal strength (RSSI)
LatestHealthEventTime	datetime	Latest health event timestamp
ImageEventBatteryValue	int	Battery value at image event
InstallAssetBatteryValue	int	Battery value at asset installation
LatestLatitude	decimal(18,2)	Latest latitude coordinate
LatestLongitude	decimal(18,2)	Latest longitude coordinate
PurityDateTime	datetime	Latest image purity date/time
LatestImageStatus	varchar	Status of latest image
ClientName	varchar	Name of the client
ClientCode	varchar	Code of the client
LocationId	int	Location identifier
Name	varchar	Location name
Code	varchar	Location code
ExternalLocationCode	varchar	External system location code
Street	varchar	Street address
Street2	varchar	Street address line 2
Street3	varchar	Street address line 3
City	varchar	City name
PostalCode	varchar	Postal/ZIP code
StateId	int	State/province identifier
State	varchar	State/province name
CountryId	int	Country identifier
Country	varchar	Country name
DisplayName	varchar	Time zone display name
MarketId	int	Market identifier
MarketName	varchar	Market name
LocationTypeId	int	Location type identifier
Channel	varchar	Channel/location type name
ClassificationId	int	Location classification identifier
Classification	varchar	Location classification name
DistributorId	int	Distributor identifier
DistributorName	varchar	Distributor name
AssetId	int	Asset identifier
SerialNumber	varchar	Asset serial number
ExternalAssetCode	varchar	External system asset code
AssetTypeId	int	Asset type identifier
AssetType	varchar	Asset type name
ModifiedByUsername	varchar	Username of last modifier