Table: Device

Database schema and system attributes for Device.

CameraBarcodeConfigurationType

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: int
  • Property Values:
    • MaxLength = 4

CreatedByPersonAliasId

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: int
  • Property Values:
    • MaxLength = 4

CreatedDateTime

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: datetime
  • Property Values:
    • MaxLength = 8

Description

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: nvarchar
  • Property Values:
    • MaxLength = -1

DeviceTypeValueId

  • Required Property: true
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: int
  • Property Values:
    • MaxLength = 4

ForeignGuid

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: uniqueidentifier
  • Property Values:
    • MaxLength = 16

ForeignId

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: int
  • Property Values:
    • MaxLength = 4

ForeignKey

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: nvarchar
  • Property Values:
    • MaxLength = 200

Guid

  • Required Property: true
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: uniqueidentifier
  • Property Values:
    • MaxLength = 16

HasCamera

  • Required Property: true
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: bit
  • Property Values:
    • MaxLength = 1

Id

  • Required Property: true
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: int
  • Property Values:
    • MaxLength = 4

IPAddress

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: nvarchar
  • Property Values:
    • MaxLength = 90

IsActive

  • Required Property: true
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: bit
  • Property Values:
    • MaxLength = 1

KioskType

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: int
  • Property Values:
    • MaxLength = 4

LocationId

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: int
  • Property Values:
    • MaxLength = 4

ModifiedByPersonAliasId

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: int
  • Property Values:
    • MaxLength = 4

ModifiedDateTime

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: datetime
  • Property Values:
    • MaxLength = 8

Name

  • Required Property: true
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: nvarchar
  • Property Values:
    • MaxLength = 100

PrinterDeviceId

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: int
  • Property Values:
    • MaxLength = 4

PrintFrom

  • Required Property: true
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: int
  • Property Values:
    • MaxLength = 4

PrintToOverride

  • Required Property: true
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: int
  • Property Values:
    • MaxLength = 4

ProxyDeviceId

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: int
  • Property Values:
    • MaxLength = 4

core_device_HasCutter

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Boolean
  • Description: Used for indicating whether or not a printer has an attached auto-cutter. Checking this will cause Rock to perform automatic label cutting at the end of the label set (for server side label printing).

core_device_KioskAllowAddingFamilies

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Boolean
  • Description: Used by next-gen check-in to determine if the kiosk allows new families to be added.

core_device_KioskAllowAddingIndividualsToExistingFamilies

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Single-Select
  • Description: Controls who can be added to an existing family during check-in, regardless of the Allow Editing Families setting.
  • Property Values:
    • fieldtype = ddl
    • values = 0^None,1^Adults & Children,2^Adults Only,3^Children Only

core_device_KioskAllowEditingFamilies

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Boolean
  • Description: Used by next-gen check-in to determine if the kiosk allows existing families to be edited.

core_device_PrinterDpi

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Integer
  • Description: Used by the check-in label designer to render the labels at the correct dots per inch (DPI) for the printer.

core_device_RegistrationMode

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Boolean
  • Description: Kiosk serves the role of enrolling new families. This enables Add Family and Edit Family features during the check-in process. Only used by legacy check-in.
  • Property Values:
    • falsetext = No
    • truetext = Yes