Table:
CatElementLU
Generic Lookup Table
| Name | Type | Description | Remarks |
|---|---|---|---|
| AlKey |
varchar(50) |
AcuityLogic record identifier |
Not visible in the U/I. Used only for automated setup. |
| AlPublishedDate |
datetime |
AcuityLogic Publish date for the element |
|
|
Value |
varchar(100) |
A display description for the row element |
|
| Ordinal | Sort order for items when displayed in a pulldown list |
Only relevant for select element types 0 usually means exclude from list. |
|
|
Type |
int |
Element Lookup Type |
Type is a foreign key to the CategoryLU table and designates the type of element represented by the current row. |