Condition Anatomy

condition_id

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

Any new conditions added should leave this column blank.

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 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 condition will not be available to assign to any cases.

Valid values are:

• t

  • Condition is enabled

• f

  • Condition is disabled

inheritable

Determines if the 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.

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.

This field is optional

timing_type_name

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

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.

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).