| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | AI_ID | The record ID. | int | 4 | |||
| AI_PARENT_ID | The ANALYSIS_ITEM_FOLDERS.AIF_ID of the containing folder. If the item is at the top level, the parent ID is 0. Note: In the user interface, there appear to be two roots: public and private. These displayed roots have no representation in the database. The actual roots (parent ID = 0) are all items directly below the displayed public and private roots. | int | 4 | ||||
| AI_NAME | The item name. | varchar | 255 | ||||
| AI_LOGICAL_NAME | A name, unique in the scope of this table, that refers to this record. | varchar | 64 | ||||
| AI_DESCRIPTION | The item description. | varchar | 16 |  | |||
| AI_TYPE | The type of the item. For example, Excel report, standard report, or graph. Do not change this field. | varchar | 60 | ||||
| AI_SUB_TYPE | Do not change this field. Not all sub-types are valid for all types and modules. Examples of sub-types are: AgeGraph | varchar | 60 | ||||
| AI_FILTER_DATA | An XML string that defines the data to be included. | varchar | 16 | | |||
| AI_LAYOUT_DATA | An XML string that defines the presentation of the data. | varchar | 16 | | |||
| AI_IS_PUBLIC | If Y, the item is public. If N, the item is private. | varchar | 1 | | |||
| AI_OWNER | For public items, the user name who created the item. For private items, the user name of the current owner. | varchar | 60 | ||||
| AI_MODULE | The ALM module containing the data. Do not change this field. Examples of modules are: Mercury.TD.Client.Ota.Api.IBaseEntity, OTAClient.Api | varchar | 255 | ||||
| AI_MODIFIED_BY | The user name who last modified the item. | varchar | 60 | | |||
| AI_VER_STAMP | The version of the item. | int | 4 | ||||
| AI_VTS | The server time this version was created. | varchar | 20 | ||||
| AI_USER_01 | User-defined field. | varchar | 40 | | |||
| AI_SEGMENT_ID | The ANALYSIS_SEGMENTS.AS_ID of the segment in which this item is presented in the user interface. | int | 4 | |
| Index | Description | Primary | Unique |
|---|---|---|---|
| ANALYSIS_ITEMS_LWR_UIX | | ||
| ANALYSIS_ITEMS_PK | | | |
| ANALYSIS_ITEMS_UNIQUE_NAME | |