Skip to main content
Mitratech Success Center

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.

 

Object Model: Appointments

The tables in this appendix provide information about the object model as it relates to appointments.

TAppointment

TAppointment contains general information for an appointment record. This information includes the appointment's subject, start date and time, end date and time, default category, geographical area, location, and so on. It also links to the lists of attendees, notes, used resources, and so on.

Object: TAppointment (T_APPOINTMENT)

Attribute

 

Database column name

 

Field in UI

 

End of Path

 

Bridge

 

Links to object table:

 

Data Type

 

Comments

 

Commonly used in:

Rules Temp/Wiz

areaItem-->

AREA_
ITEM_ID (NUMBER)

Area (General block)

x

x

LApptArea
Item

object

8 Geographical area where the appointment will take place (for example, Orange County, and Chicago).

--> Links to the definition information for the appointment area item.

 

x

attendees
-->

Before TeamCon nect 3.3 SP2: attendee List-->

n/a

Attendees tab

x

x

JAppt
Attendee

 

8 The list of all attendees that are added to the appointment record.

--> Links to the join table that contains information for all attendees who have been added to the appointment.

   

categories
-->

Before TeamCon nect 3.3 SP2: detailList
-->

n/a

 

x

x

EApptDetal

In Object Navigator, links to Category list which appears in the UI only.

 

8 The list of categories added to the current object.

--> In the object model, the added categories link to the values that have been added for custom fields, according to field type.

--> In Object Navigator, this attribute is enhanced. It links to a list of all categories defined for the object definition, rather than those added to the current object. From there, you can select a category and traverse to the list of custom fields that belong to it.

   

createdBy
-->

CREATED_BY_ID 
(NUMBER)

Created By (Security block)

x

x

YUser

object

8 User who created the appointment.

--> Links to specific information about the user account.

x

x

createdOn

CREATED_ON (DATE)

Created On (Security block)

x

   

date

Date and time the appointment was created.

x

x

createdOnBehalfOf

CREATED_ON_ BEHALF_
OF_ID

   

x

TContact

object

When not null, it indicates that the record was created through an e- billing system or other external application. The contact referenced will often be a vendor in TeamConnect.

x

 

default
Category
-->

DEFAULT_CATEGORY_
ID (NUMBER)

Default Category (General block)

x

x

YRecently
Viewed
Record

object

8 Default category for the appointment.

--> Links to the definition information of the category.

 

x

document
Folder-->

DOCUMENT_FOLDER_
ID (NUMBER)

Documents block

 

x

TDocument

object

Links to specific information about the document folder.

   

endOn

END_ON (DATE)

Ends On

x

   

date time

Date and time when the appointment ends.

x

x

group
AccessList -->

n/a

   

x

EAppt
Group

 

Links to the group security information entered through the Security block of the record.

   

historyList
-->

n/a

History tab

x

x

THistory

 

8 The list of all histories that are added to the appointment record.

--> Links to history information for all of the appointment' s history records.

   

iallDay

Before TeamCon nect 3.3 SP2:

isAllDay

IS_ALL_
DAY (NUMBER)

 

x

   

boolean

Indicates whether the appointment is scheduled for the entire day.

0 - not all day
1 - all day

x

x

location

LOCATION (VARCHAR2) (250)

Location

x

   

string (250)

Location where the appointment takes place (such as Corporate Headquarters or Conference Room 3rd Floor).

 

x

modifiedBy-->

MODIFIED_BY_ID (NUMBER)

Modified By (Security block)

x

x

YUser

object

8 User who most recently modified the account.

--> Links to specific information about the user account.

   

modified
On

MODIFIED_ON (DATE)

Modified On (Security block)

x

   

date

Date and time the appointment was most recently modified.

   

note-->

NOTE_ID (NUMBER)

Notes (General block)

 

x

JNote

object

Links to the table that contains the text entered into the Notes field of the record.

   

primary
Key

PRIMARY_KEY 
(NUMBER)

 

x

   

int

Unique ID for the appointment record.

   

project-->

PROJECT_ID (NUMBER)

Project (General block)

x

x

TProject

object

8 Project for which the appointment is created.

--> Links to specific information about the project record.

x

x

resources
-->

Before TeamCon nect 3.3 SP2:

resource List-->

n/a

Resources tab

x

x

JAppt
Resource

 

8 The list of all resources that are added to the appointment record.

--> Links to the join table that contains information for all resources added to the appointment.

In Object Navigator, this attribute links to a table named Resource Type that allows you to filter the resources based on a type, if desired.

 

x

security
TypeIID

SECURITY_TYPE_IID (NUMBER)

Security (Security block)

x

   

Enum

Specifies whether the appointment is public or private.

0 - Public (PUBLIC)
2 - Private (PRIVATE)

   

startOn

START_ON (DATE)

Begins On (General block)

x

   

date time

Date and time when the appointment begins.

x

x

subject

SUBJECT

Subject (General block)

x

   

string (250)

Description of the appointment (e.g. Meeting with client).

 

x

user
AccessList-->

n/a

   

x

EApptUser
Access

 

Links to the user security information entered through the Security block of the record.

   

version

VERSION (NUMBER)

 

x

   

int

Indicates how many times the appointment record was updated.

   

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.

   

JApptAttendee

JApptAttendee contains information about the attendees in an appointment record. This information includes the user who has been added as an attendee, attendance status, and starting and ending date and time. This table represents the Attendees block on the Attendees tab of an appointment.

Object: JApptAttendee (J_APPT_ATTENDEE)

Attribute

Database column name

Field in UI

End of path

Bridge

Links to object table:

Data type

Comments

Commonly used in:

Rules

Temp/Wiz

attendanceType

Before TeamConnect 3.3 SP2: attendanceTypeIID

ATTENDAN CE_TYPE_
IID (NUMBER)

Attendance (Attendees block)

x

   

int

Indicates the attendance status of the attendee:

0 - Will Attend (WILL_
ATTEND)
1 - Tentative (TENTATIVE)
2 - Will Not Attend
(WILL_NOT_
ATTEND)
3 - Unknown

 

x

endOn

END_ON (DATE)

End Time (Attendees block)

x

   

date
Time

End date and time until which the user is scheduled to attend.

 

x

owner-->

APPOINTM ENT_ID (NUMBER)

   

x

TAppointment

object

The appointment which the user is scheduled to attend.

   

primary
Key

PRIMARY_KEY (NUMBER)

 

x

   

int

Unique ID given to each attendee added to an appointment record.

   

startOn

START_ON (DATE)

Start Time (Attendees block)

x

   

date Time

Start date and time when the user is scheduled to attend.

 

x

user-->

USER_ID (NUMBER)

Attendee (Attendees block)

x

x

YUser

object

8 User who is added as an attendee to the appointment record.

--> Links to specific information about the user account.

x

x

version

VERSION (NUMBER)

 

x

   

int

Indicates how many times the appointment attendee was updated.

   

JApptResource

JApptResource contains information about the resources used in an appointment record. This information includes resource type (such as Projector or Conference Room) and the starting and ending date and time the resource is needed. This table represents the Resources block on the Resources tab of an appointment record.

Object: JApptResource (J_APPT_RESOURCE)

Attribute

Database column name

Field in UI

End of path

Bridge

Links to object table:

Data type

Comments

Commonly used in:

Rules

Temp/Wiz

endOn

END_ON (DATE)

To
(Resources block)

x

   

date Time

Date and time until which the resource is needed.

 

x

owner-->

APPOINT MENT_ID (NUMBER)

   

x

TAppointment

object

The appointment for which the resource is needed.

   

primary
Key

PRIMARY_KEY (NUMBER)

 

x

   

int

Unique ID given to each resource added to an appointment record.

   

startOn

START_ON(NUMBER)

From 
(Resources block)

x

   

date Time

Date and time when the resource is needed.

 

x

type-->

TYPE_ID (NUMBER)

Resource (Resources block)

x

x

LAppt
Resource
Type

object

8 The type of resource (such as Projector or Conference Room).

--> Links to the definition information for the appointment resource type.

 

x

version

VERSION (NUMBER)

 

x

   

int

Indicates how many times the appointment resource was updated.

   

LApptResourceType

LApptResourceType contains information about the resource types defined for appointment records. This information includes the resource name, tree position, and display order. This table represents the Resource Type system lookup table.

Object: LApptResourceType (L_APPT_RESOURCE_TYPE)

Attributexxx

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

LAppt
Resource
Type

 

Links to the list of child resource types that belong to this resource type.

   

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) (50)

Item Name

x

   

string (50)

The name of the resource type (e.g. Projector).

   

parent-->

PARENT_ ID (NUMBER)

Show items in node

x

x

LAppt
Resource
Type

object

8 The parent of the current resource type.

--> Links to the definition information for the appointment resource type.

   

primary
Key

PRIMARY_KEY (NUMBER)

 

x

   

int

The unique ID of the resource list item.

   

tree
Position

TREE_
POSITION (VARCHAR2) (250)

Tree Position

x

   

string (250)

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

   

version

VERSION (NUMBER)

 

x

   

int

Indicates how many times the resource type was updated.

   

EApptDetail

EApptDetail contains all categories added to appointment records. Each time a category is added to an appointment record, an entry is made in this table in the database.

In Object Navigator, EApptDetail is not displayed when you traverse using the detailList--> bridge. Instead, a list of all categories that have been defined for the object definition appears. This list is labeled Category. From each category, you can traverse to a table called Detail Fields, which displays all custom fields belonging to the category you selected.

For more information about how custom field values are stored in the database, see Object Model: Custom Fields.

Object: EApptDetail (E_APPT_DETAIL)

Attribute

Database column name

Field in UI

End of path

Bridge

Links to object table:

Data type

Comments

Commonly used in:

Rules

Temp/Wiz

category-->

CATEGORY_ID 
(NUMBER)

Category

x

x

YRecently
Viewed
Record

object

The category of the appointment with which the details are associated.

   

owner-->

ENTERPRISE_
OBJECT_
ID (NUMBER)

   

x

TAppointme nt

object

The appointment with which the custom fields are associated.

   

isManual

IS_
MANUAL (NUMBER)

 

x

   

boolean

Specifies whether the category is added manually or automatically to the appointment.

Categories are added automatically when they are the parent of the category that is added manually.

0 - Added Automatically
1 - Added Manually

   

primary
Key

PRIMARY_KEY 
(NUMBER)

 

x

   

int

The unique ID of the appointment category record.

   

version

VERSION(NUMBER)

 

x

   

int

Indicates how many times the added category was updated.

   

EApptUserAccess

EApptUserAccess contains the user access information that is set in the Security block of each appointment record. For example, this information includes whether each user that is listed in the Security block is allowed or denied the Read, Update, Delete, and Perm(ission) rights.

Object: EApptUserAccess (E_APPT_USER_ACCESS)

Attribute

Database column name

Field in UI

End of path

Bridge

Links to object table:

Data type

Comments

Commonly used in:

Rules

Temp/Wiz

isRead

IS_READ (NUMBER)

Read check box

x

   

int

Specifies whether the Read operation has been selected for granting or denial. Value is 1 (selected) or 0 (not selected).

This attribute does not determine whether the operations are allowed or denied. (See allowDenyIID.)

   

isUpdate

IS_
UPDATE (NUMBER)

Update check box

x

   

int

Specifies whether the Update operation has been selected for granting or denial. Value is 1 (selected) or 0 (not selected).

This attribute does not determine whether the operations are allowed or denied. (See allowDenyIID.)

   

isDelete

IS_DELETE (NUMBER)

Delete check box

x

   

int

Specifies whether the Delete operation has been selected for granting or denial. Value is 1 (selected) or 0 (not selected).

This attribute does not determine whether the operations are allowed or denied. (See allowDenyIID.)

   

isPerm

IS_PERM (NUMBER)

Perm check box

x

   

int

Specifies whether the Set Permission operation has been selected for granting or denial. Value is 1 (selected) or 0 (not selected).

This attribute does not determine whether the operations are allowed or denied. (See allowDenyIID.)

   

allow
DenyIID

ALLOW_
DENY_IID (NUMBER)

Option

x

   

Enum

Indicates whether the user is allowed or denied access to the record.

a - Allow (ALLOW)
d - Deny (DENY)

   

isManual

IS_
MANUAL (NUMBER)

 

x

   

boolean

Indicates whether the user rights were assigned manually through the Security block of the record or automatically by the system.

0 - Assigned manually
1 - Assigned automatically

   

owner-->

ENTERPRISE_
OBJECT_
ID (NUMBER)

 

x

x

TAppointment

object

8 The appointment record with which this user access setting is associated.

--> Links to the specific information about the appointment record.

   

primary
Key

PRIMARY_KEY 
(NUMBER)

 

x

   

int

Unique ID for the user access rights.

   

user-->

USER_ID (NUMBER)

List

x

x

YUser

object

8 Specifies the user the access rights pertain to.

--> Links to specific information about the user account.

   

version

VERSION (NUMBER)

 

x

   

int

Indicates how many times the user access rights have been updated.

   

EApptGroupAccess

EApptGroupAccess contains the group access information that is set in the Security block of each appointment record. For example, it includes whether each group that is listed in the Security block is allowed or denied the Read, Update, Delete, and Perm(ission) rights.

Object: EApptGroupAccess (E_APPT_GROUP_ACCESS)

Attribute

Database column name

Field in UI

End of path

Bridge

Links to object table:

Data type

Comments

Commonly used in:

Rules

Temp/Wiz

isRead

IS_READ (NUMBER)

Read check box

x

   

int

Specifies whether the Read operation has been selected for granting or denial. Value is 1 (selected) or 0 (not selected).

This attribute does not determine whether the operations are allowed or denied. (See allowDenyIID.)

   

isUpdate

IS_
UPDATE (NUMBER)

Update check box

x

   

int

Specifies whether the Update operation has been selected for granting or denial. Value is 1 (selected) or 0 (not selected).

This attribute does not determine whether the operations are allowed or denied. (See allowDenyIID.)

   

isDelete

IS_DELETE (NUMBER)

Delete check box

x

   

int

Specifies whether the Delete operation has been selected for granting or denial. Value is 1 (selected) or 0 (not selected).

This attribute does not determine whether the operations are allowed or denied. (See allowDenyIID.)

   

isPerm

IS_PERM (NUMBER)

Perm check box

x

   

int

Specifies whether the Set Permission operation has been selected for granting or denial. Value is 1 (selected) or 0 (not selected).

This attribute does not determine whether the operations are allowed or denied. (See allowDenyIID.)

   

allowDeny
IID

ALLOW_
DENY_IID 

(CHAR) (1)

Option

x

   

Enum

Indicates whether the group is allowed or denied access to the record.

a - Allow (ALLOW)
d - Deny (DENY)

   

group-->

GROUP_ID (NUMBER)

List

x

x

YGroup

object

8 Specifies the group that the access rights pertain to.

--> Links to specific information about the group account.

   

isManual

IS_
MANUAL (NUMBER)

 

x

   

boolean

Indicates whether the group access rights were assigned manually through the Security block of the record or automatically by the system.

0 - Assigned manually
1 - Assigned automatically

   

owner-->

ENTERPRISE_
OBJECT_
ID (NUMBER)

 

x

x

TAppointment

object

8 The appointment record with which this group access setting is associated.

--> Links to the specific information about the appointment record.

   

primary
Key

PRIMARY_KEY (NUMBER)

 

x

   

int

Unique ID for the group access rights.

   

version

VERSION (NUMBER)

 

x

   

int

Indicates how many times the group access rights have been updated.

   
  • Was this article helpful?