Database Table "hyp_Meetings"

Table Description

Normal Storage

All of the meetings from the last 6 months, and the future meetings.

Archive Storage

All of the meetings that from 6 months ago or earlier.

Deleted Storage(Recycle)

All of the cancelled meetings.

Field Name	English Title	Data Type	Text Length	Editor	Attributes	json
Key		Real	0	Edit	Hidden Read Only Key Field	Key
For User		String	40	Select	Mandatory	ForUser
Subject		String	120	SelectEdit	Mandatory /G:1	Subject
From Hour		Hour	0	Edit	Mandatory	FromHour
Until Hour		Hour	0	Edit	Mandatory	UntilHour
Status	Values List: 0 = Tentative 1 = Confirmed 2 = Cancelled	Status	0	Select		Status
Starts		FixDT	0	SelectEdit	Mandatory	Starts
Ends		FixDT	0	SelectEdit	Mandatory	Ends
Location		String	120	SelectEdit		Location
Number of Participants		Integer	0	Edit		NumberOfParticipants
Public Shared Notes		String	1000	Memo		PublicSharedNotes
Popup Window	Values List: 00 = Never 01 = On Time 02 = 15 Minutes Before 03 = 30 Minutes Before 04 = 45 Minutes Before 05 = 1 Hour Before 06 = 1.5 Hours Before 07 = 2 Hours Before 08 = 3 Hours Before 09 = 4 Hours Before 10 = 6 Hours Before	Status	0	Select		PopupWindow
Private		String	1	Edit	Hidden	Private
Summary Status	Values List: 0 = No Need 1 = Waiting for User 2 = Complete 3 = Postpone 24hr	Status	0	Select	Hidden	SummaryStatus
Meeting Summary		String	1000	Memo		MeetingSummary
Sequence		Integer	0	Edit	Read Only	Sequence
Invited by Email		String	1	Edit	Hidden	InvitedByEmail
UniqueID		String	140	Edit	Read Only	Uniqueid
Organizer Mail Address		String	80	Edit	Read Only	OrganizerMailAddress
Attendees List		String	120	Edit	Read Only Mandatory /G:1	AttendeesList
Agency		Status	0	Select	Hidden	Agency
Created On		FixDT	0	Edit	Read Only	CreatedOn
Created By		String	40	Edit	Read Only	CreatedBy
Last Update		FixDT	0	Edit	Read Only	LastUpdate
Updated By		String	40	Edit	Read Only	UpdatedBy
Parent Meeting Key		Real	0	Edit	Hidden Read Only	ParentMeetingKey
Repeating Original Meeting Key		Real	0	Edit	Hidden Read Only	RepeatingOriginalMeetingKey
Link to Document Type	Values List: 0 = null, Empty 1 = Service 2 = Opportunity 3 = Task	Status	0	Select	Read Only	LinkToDocumentType
Link to Document Key		Real	0	Edit	Read Only	LinkToDocumentKey
Color		Integer	0	PopupList		Color

Jump to tables index

Database Table "hyp_Meetings Invitations"

Table Description

Sub-table with the list of invitees for the meeting.

Normal Storage

All the meetings from six months ago to the future

Archive Storage

All the meetings from six months ago - back to the distant past

Deleted Storage(Recycle)

Canceled meetings from any period

Field Name	English Title	Data Type	Text Length	Editor	Attributes	json
Key		Real	0	Edit	Hidden Read Only Key Field	Key
Attendee FullName		String	105	Edit	Mandatory	AttendeeFullname
Attendance Status	Values List: 0 = Tentative 1 = Confirmed 2 = Cancelled 3 = Needs Action	Status	0	Select	Read Only	AttendanceStatus
Attendee Email		String	80	Edit	Mandatory /G:1	AttendeeEmail
Attendee Cellphone (for SMS)		Phone	20	Edit	Mandatory /G:1	AttendeeCellphoneForSms
Required	Values List: 0 = Yes 1 = Optional 2 = None - Information	Status	0	Select		Required
User Type	Values List: 0 = Individual 1 = Group 2 = Resource 3 = Room	Status	0	Select		UserType
Entity Number		Integer	0	Edit	Hidden Read Only Mandatory /G:	EntityNumber
Entity Full Name		String	105	Edit	Read Only	EntityFullName
Not Arrived		Bool	0	Select		NotArrived
Next Phone call On		FixDT	0	SelectEdit		NextPhoneCallOn
Next Phone call By		String	40	PopupList		NextPhoneCallBy

Jump to tables index