Table properties

The description of the table. The table description displays in wizards and other dialogs to help users understand what type of data the table holds.

The name of the table. This name is used in Axiom queries and Axiom functions to query data, so it should be descriptive and short. The table name must be unique.

NOTE: The table name can only be changed by using Save Type 4. If you change the table name of an existing table, keep in mind that this name change is not applied throughout the system—any references to the old table name will now be invalid. Generally speaking, this should only be done to a new table that has not yet been referenced throughout the system. For more information, see Managing tables using Save Type 4.

This setting only applies to systems with installed product packages, and is only present if Is Variable Table is set to True. It defines an alternate display name for the table. This setting is intended to be configured during system implementation as needed. You should not change this setting afterward without consulting Axiom Support.

The table type assigned to the table, for security filter purposes. This can be a defined table type or None.

You can change the table type from None to a specific table type, and vice versa. However, if you want to change from one table type to another table type, the following restrictions apply:

• If the new table type has a different table classification, the table must be eligible to be converted to that classification.
• Any required columns for the new table type must be added to the table (if not already present).

The virtual folder location where the table resides in the Table Library.

The class of table, either Data or Reference. This property is displayed on both the General tab and the Table Properties tab, but it can only be edited on the General tab.

NOTE: Picklist tables and KPI tables are reference tables; they are not separate classifications.

The table classification can only be changed if:

• The table is not assigned to a table type. If the table is assigned to a table type, then it must match the classification of the table type.

• The structure of the table is compatible with the new classification. For example, a data table cannot be changed to a reference table if it has more than one key column.

It is not possible to change an existing table to a picklist table or a KPI table. If you have an existing reference table that you want to convert to a picklist table or a KPI table, it is recommended to create a new table and then copy the relevant data.

This table property refers to a deprecated feature. Enabling the setting has no impact in the system.

Specifies whether the table data is read-only. All tables default to False.

If this is set to True, then the data in the table cannot be changed by Axiom Software processes such as save-to-database or Open Table in Spreadsheet.

You can still edit table properties, change the table current period, and edit table aliases, sequences, hierarchies, and calculated fields.

NOTE: If the table uses the Large Table index scheme, transform statements in imports are not blocked from modifying the data in the table.

Specifies whether the table is a picklist table. This is set when the picklist table is created and cannot be changed.

NOTE: It is possible to convert a picklist table to a regular reference table by using the General tab of the Edit Table dialog to change the classification to Reference Table. This will convert IsPicklist to False. If the picklist table belongs to a picklist table type, you must remove it from the table type first.

Specifies the index scheme used by the table. This should be left at Default unless you are advised to use a different scheme by your implementation consultant or by Axiom Support. For more information, see About table index schemes.

Once the index scheme is set for a table, it can only be changed as follows:

• Default can be changed to Hybrid, and vice versa. In this case, the new indexes will not be created until the next time the System Index Maintenance job is run by Scheduler. By default, the job runs nightly.

• Large Table can only be set when the table is first created. Afterward, it is not possible to change Default or Hybrid to Large Table, or vice versa. If necessary, you can clone the table and change the index scheme as part of the clone.

Specifies whether changes to the table data are tracked in the audit database. By default, this is set to True, which means data changes are tracked. Change this to False if you do not need to be able to audit the granular data changes to the table.

For more information on table auditing, see Auditing changes to table data.

NOTE: Auditing cannot be enabled for tables using the Large Table index scheme.