The Questionnaire Tables
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.
|
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. |