Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Field

Description

Notes

condition_id

This is a system column and should not be edited or modified.

Any new conditions added should leave this column blank.

Warning

Do not modify this column or add any data to it.

name

This field allows for naming the condition. While this field is optional, it can make identifying the conditions easier when adding to a case or reviewing the conditions on a case.

This field is optional.

long_description

This is main condition text. This field should contain all the information relating to this specific condition.

Variables can be used in the long description to pull in available case data from the case the condition is attached to.

short_description

This field is available for future expansion and is not currently used

This field is optional.

public_description

If Show on Portal is set to yes, this fields content will be displayed on the portal. If this field is blank, then the contents of Long Description will be used

This field is optional.

resolution_action

Internal notes, tasks or details to assist the user to know what steps should be taken when resolving this condition.

This field data is internal only and will never be displayed on the portal or conditions notice.

This field is optional.

condition_group_name

The group this condition belongs to. This is used for filtering and finding conditions when adding them to a case

The condition group must exist in the system prior to import.

severity_name

The severity of the condition

Available options:

  • Required

    • If a condition is set as required, it indicates the flag must be completed in order to satisfy the rules attached to the condition. Such as prevent case issuance, etc. Conditions with this flag must have a rule attached.

  • General

    • A general flag is the default flag level and it denotes a standard condition that has no special attributes

condition_type

The condition type allows further classification of conditions and is used for additional filtering and finding conditions when adding them to a case

The condition type must exist in the system prior to import.

enabled

Determines if the condition is enabled. If not enabled, the flag condition will not be available to assign to any cases.

Info

If the flag condition is already assigned to a case, making it disabled will not remove it from the case

Valid values are:

  • t

    • Condition is enabled

  • f

    • Condition is disabled

inheritable

Determines if the flag condition inherits to other cases when cases are linked to this case

Valid values are:

  • t

    • The condition is inheritable

  • f

    • The condition is not inheritable

show_in_notice

Determines if this condition is shown in the Condition Notice.

Valid values are:

  • t

    • This condition will be displayed in the conditions notice document

  • f

    • This condition will not be shown in the conditions notice document

display_on_portal

Determines if this status is displayed on the Public Portal.

This option is available for future use. Flags do not currently show on the portal, but will be made available in a later portal version.

Valid values are:

  • t

    • This condition will be displayed on the portal

  • f

    • This condition will not be displayed on the portal

additional_info

Allows for the setting of any generic notes or details relating to the condition.

Info

This field data is internal only and will never be displayed on the portal or conditions notice

This field is optional

timing_type_name

Info

Timing type is also commonly referred to as “Rule Type”

Sets the rule type to be enforced when this condition is added to a case

Current Options:

  • case

    • Prevent Case Issuance

      If selected, the case can not be issued until this condition is completed

  • coo

    • Certificate of Occupancy

      If selected, the Certificate of Occupancy document can not be generated until this condition is completed

  • inspection

    • Final Inspection

      Prevents the scheduling of the final inspection(Inspections called "Final"), until this condition is completed

applies_on_add

Determines if the condition timing/restriction is applicable when the condition is originally added to a case

Info

This only applies to conditions that have a severity of required.

When a condition is required either applies_on_add or applies_on_inherit must be “t”

Tip

Both applies_on_add and applies_on_inherit can be set to “t”. This will make the condition apply on both initial add and inherit

Valid values are:

  • t

    • This condition will be enforced on the condition when added

  • f

    • This condition will not be enforced on the condition when initially added

applies_on_inherit

Determines if the condition applies to a case when inherited.

Info

This only applies to conditions that have a severity of required.

When a condition is required either applies_on_add or applies_on_inherit must be “t”

Tip

Both applies_on_add and applies_on_inherit can be set to “t”. This will make the condition apply on both initial add and inherit

Valid values are:

  • t

    • This condition will be enforced when inherited to a case

  • f

    • This condition will not be enforced when inherited to a case

sort

The order in which the condition should show on the case and notice(if set to show).

...