Questionnaires (Legacy)

The Questionnaire Tables

The Archibus Questionnaires and Archibus Questions tables are used by the Archibus questionnaire system.

Editing the Questionnaire Tables

Several views exist in Archibus Web Central for creating questionnaires specific to certain applications. For example, to define a Project Questionnaire see Capital Projects / Projects / Setup / Define Project Questionnaires .

Archibus Questionnaires Table

Lists all questionnaires in the system.

Field

Purpose

Questionnaire ID

Identifies the Questionnaire record. Provide a descriptive name that uniquely identifies the questionnaire. Also called the Questionnaire Code.

Questionnaire Title

Enter text to more fully describe the questionnaire.

Table /Response Field

Enter the inventory table and the field within this table to hold the questionnaire results. The field holding the questionnaire results must have a String Format of Memo and a Data Type of Varchar. See Creating a Questionnaire Response Field .

Description

Enter a description of the questionnaire.

Archibus Questions Table

Holds a list of questions for each questionnaire.

Field

Purpose

Questionnaire ID

Choose the questionnaire to which this question will be assigned.

Question Name

Enter a value, that when combined with the above Questionnaire ID value, will uniquely identify the record.

Is Active?

Yes/No.  Determines whether or not the question is active and should appear in edit forms. Rather than delete old questions for a questionnaire that is already in use, use this field to set the questions to not active. This ensures that all inventory records that are in process or archived will still process correctly.

Is Required? Yes/No.  Determines whether or not the question is required and should appear in edit forms as a required value.

Sort Order

Controls the order in which the questions appear to users.

Question Text

The question to display.  This text cannot contain special XML characters, such as, <>&’”.

Format Type.

Determines the type of HTML input form control to create for the response to this question.

  • Enumerated presents the Enum List (below) as an enumeration list.
  • Look Up presents a Select Values dialog so that the user can choose values from the table and field specified below in Look-Up Table and Look-Up Field.
  • Free Form presents a blank field so that the user to type in a free-form value.
  • Date presents a standard date form field.

Enum List

If Enumerated is chosen for Format Type, complete this field with an enumeration list of response values. Separate the response values with semi-colons.

Look-Up Table/Look-Up Field

If Look-Up is chosen for the Format Type, choose the table and field whose values to display in the Select Values dialog presented to the user.

Free-Form Width

If Free Form is chosen for Format Type, use this option to set the maximum length of the value that the user can enter in the HTML input form.

Action Type

Specifies the type (from the validating Activity Types table) of Action Item to create if the user responds to the question with the value that is specified for Action Response, below. The system inserts the text from the Instructions field of the Activity Types table into the description of the Action Item record it creates.

Action Response

If the user’s response is equal to the value for this field, then the system creates an Action Item record of the Action Type specified above. For instance, if for an Equipment Move? question, this field has a value of Yes, Action Type above is Move Data, and the user's response is Yes, then the program generates a Move Data Action Item. Questionnaires for more information.