schemas-EntryColumn

Metadata describing a configurable entry column (dimension) for the sheet. Columns define what fields are available for entry (project, task, pay type, etc.).

column_idstringrequired

Standard column identifier, also known as the "API name" for the column:

• project - Project column
• code0 through code6 - Code columns (task, pay type, bill type, etc.)
• comment - Primary text comment
• text2, text3 - Additional text fields
• group - Group column - rarely used as an entry column.
• user - User (for crew entry)

Example: project

column_alt_idstring

Alternative/legacy column identifier, also known as the internal "jtgui name" for the column:

• h1 - Project
• dd1 through dd7 - Dropdown codes
• tb1 through tb3 - Text boxes
• grp1 - Group
• u1 - User

Example: h1

namestringrequired

The configurable display name (label) for the column.

Example: Project

tablestring

Database table name for this column type. This table stores the primary selection values for this column.

• projects - Projects
• codes_tasks - Activity codes
• codes_pay_types - Pay type codes
• codes_bill_types - Bill type codes
• Empty string for text columns

Example: projects

defaultstring

Default value ID for this column

Example: p_d_1_1

default_namestring

Display name of the default value

Example: Customer XYZ: Implementation Phase

priorityintegerrequired

Display priority/order (higher = more important/displayed first)

Example: 12

hiddenboolean

Whether this column is hidden from the user

Example: false

is_project_columnboolean

True if this is the project column

Example: true

is_code_columnboolean

True if this is a code/dropdown column (code0 through code6)

Example: false

is_text_columnboolean

True if this is an open text entry column

Example: false

schemas-EntryColumn

{
  "column_id": "project",
  "column_alt_id": "h1",
  "name": "Project",
  "table": "projects",
  "default": "p_d_1_1",
  "default_name": "Customer XYZ: Implementation Phase",
  "priority": 12,
  "hidden": false,
  "is_project_column": true,
  "is_code_column": false,
  "is_text_column": false
}