Attribute

Database column name

Field in UI

End of path

Bridge

Links to object table:

Data type

Comments

Commonly used in:

Rules

Temp/Wiz

childList-->

n/a

Do not apply. These lookup items cannot have a hierarchical structure.

parent-->

PARENT_ID

(NUMBER)

displayOrder

DISPLAY_ORDER

(NUMBER)

Order

x

int

The order in which the table items will be listed in the GUI, lowest number first.

isActive

IS_ACTIVE

activate and inactivate buttons

x

int

Indicates whether the table entry is active (value 1) and can be used when editing records containing that entry. If it is inactive (value 0), records may contain that entry for reporting and historical purposes, but cannot be saved when editing, unless that entry is changed to some other, active table entry.

name

NAME

(VARCHAR2) (50)

Item Name

x

string (50)

Name of activity item.

primaryKey

PRIMARY_KEY

(NUMBER)

x

int

The unique ID of the activity item.

treePosition

TREE_POSITION

(VARCHAR2) (250)

Tree Position

x

string (250)

The unique four-character alphanumeric code that is created when the activity item is defined.

version

VERSION

(NUMBER)

x

int

Indicates how many times the activity item was updated.