Skip to main content
Mitratech Success Center

TAppointment

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

LApptAreaItem

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

JApptAttendee

 

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

YRecentlyViewedRecord

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

EApptGroup

 

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

JApptResource

 

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

EApptUserAccess

 

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.

   
  • Was this article helpful?