For other system and custom lists and folder trees, see the LISTS table.
Folder structures are recreated with a self-join of ALL_LISTS parent and ALL_LISTS child where child.AL_FATHER_ID = parent.AL_ITEM_ID. For top level nodes, AL_FATHER_ID = 0.
In addition, each child node inherits the AL_ABSOLUTE_PATH of its parent node and appends three more characters. For example, the children of the node with path AAA have paths AAAAAA, AAAAAB, AAAAAC, and so on.
The characters V and W are not used.
|The record ID.
|The ID of the parent folder, list, or list item. Tree and list roots have AL_FATHER_ID = 0.
|The item description.
|The permissions for the item:
R - read-only but can add sub-folders.
S - system field (ALM does not permit changes to this field).
A - all actions are available.
C - can change but not delete.
|An alphabetic code showing the tree structure. The characters V and W are not used.
|For internal use.
|A descriptive comment.
|A Value of Y indicates that the item has at least one attachment.
|For backward compatibility. Field may be removed in future version.
|The revision number of this item. Increments each time the record is updated.
|The version time stamp. Indicates the database-server time the record was last changed.