TAppointment

Last updated
Save as PDF

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.
emailAlertNumDaysAdvance	EMAIL_ALERT_NUM_DAYS_ADVANCE (NUMBER)					NUMBER
isAppointmentExpirationSent	IS_APPOINTMENT_EXPIRATION_SENT (NUMBER)					NUMBER
isEmailNotificationActive	IS_EMAIL_NOTIFICATION_ACTIVE (NUMBER)					NUMBER
approvalStatusID	APPROVAL_STATUS_ID (NUMBER)					NUMBER
docuSourceLocationID	DOCU_SOURCE_LOCATION_ID (NUMBER)					NUMBER
forumID	FORUM_ID (NUMBER)					NUMBER
milestoneID	MILESTONE_ID (NUMBER)					NUMBER