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_KioskSkipScreenBehavior

• Required Property: false
• Lava Supported Property: true
• Database Property: false
• Data Type: Single-Select
• Description: Determines when the 'skip' screen is shown when an attendee has no valid check-in option. 'Never Show' quietly skips the attendee (labels for other family members may print before you realize this person had no option). 'Show When Needed' skips only when the attendee could never check in, but shows the screen when a room exists yet is unavailable (e.g. full). 'Always Show' always displays the screen so the operator can confirm the skip.
• Property Values:
  • fieldtype = ddl
  • values = 1^Never Show,0^Show When Needed,2^Always Show

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