Lookup Type

What is a Lookup?

A Lookup provides a predefined set of values that can be used to ensure consistency and validity in data entry. It is typically used to create a list of choices or options that users can select from, ensuring that the data adheres to a specific set of standards or categories.

Key Characteristics of a Lookup

• System Properties

  • System Properties are the fundamental attributes automatically generated upon an Entity's creation.

  • Example: System Properties of the "Employee" entity include ID, CreatedOn, CreatedBy, ModifiedOn, and ModifiedBy.

• Properties

  • Users can define custom fields to add context or functionality to the lookup.

• Key:

  • A unique identifier for each record in the lookup, such as a code or identifier.

• Sort Order

  • Determines how the data in the lookup is organized and displayed, based on a specified property.

Example: Consider a Department lookup used in an employee management system:

• Properties: Could include fields like "DepartmentCode", “DepartmentName” or "DepartmentHead."

• Key: DepartmentCode (e.g., "HR", "ENG", "FIN")

• Sort Order: Sorted by ascending DepartmentName.