Client Support Center

Need help? Click a product group below to select your application and get access to knowledge articles, webinars, training content, and release notes or to contact our support team.

Authorized users - log in to create a ticket, view tickets status and check your success plan details.

Workflow Automation

Corporate Legal & Claims

Governance, Risk & Compliance

Human Resources Compliance

LApptAreaItem

Last updated
Save as PDF

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.
isActive	IS_ACTIVE (NUMBER)					NUMBER