LApptAreaItem
LApptAreaItem
LApptAreaItem contains information about the area items defined for appointment records. This information includes the name of the area item, tree position, and display order. This table represents the Area Item system lookup table.
Object: LApptAreaItem (L_APPT AREA_ITEM)
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 |
x |
Links to the child items in the Area Item system lookup table that belong to this area list item. |
||||||
display Order |
DISPLAY _ORDER (NUMBER) |
Order |
x |
int |
The order in which the table items will be listed in the GUI, lowest number first. |
||||
name |
NAME (VARCHAR2) (250) |
Item Name (Look up Tables, System tab) |
x |
string (50) |
The name of the area item (for example, Orange County, Los Angeles). |
||||
parent--> |
PARENT_ ID (NUMBER) |
Show items in node (Look up Tables, System tab) |
x |
x |
object |
Links to the parent item of this area item in the Area Item system lookup table. |
|||
primary |
PRIMARY_KEY |
x |
int |
The unique ID of the area list item. |
|||||
tree |
TREE_ |
Tree Position (Look up Tables, System tab) |
x |
string (250) |
The unique four- character alphanumeric code that is created when the area list item is defined. |
||||
version |
(VERSION) (NUMBER) |
x |
int |
Indicates how many times the area list item was updated. |
|||||
isActive | IS_ACTIVE (NUMBER) | NUMBER |