Skip to main content
Mitratech Success Center

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

LApptArea
Item

 

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
(Look up Tables, System tab)

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

LApptArea
Item

object

Links to the parent item of this area item in the Area Item system lookup table.

   

primary
Key

PRIMARY_KEY
(NUMBER)

 

x

   

int

The unique ID of the area list item.

   

tree
Position

TREE_
POSITION (VARCHAR2) (250)

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.

   

 

  • Was this article helpful?