• Share
    • Twitter
    • LinkedIn
    • Facebook
    • Email
  • Feedback
  • Edit
Show / Hide Table of Contents

ExternalEvent Table (233)

Some tooltip text!
• 3 minutes to read
 • 3 minutes to read

The definition of projects as events in Audience (or other Collaborative apps)

Fields

Name Description Type Null
ExternalEvent_id Primary key PK
eventEnabled Is the event enabled Bool
eventDate Dateof the event; publishing/visibility dates are in Publish, and restrictions are in AudienceVisibility DateTime
parentTable The thing, that has now become an Event TableNumber
parentRecord The thing, that has now become an Event RecordId
signOn Is Sign On functionality enabled Bool
signOnTaskEnable If not 0, a task should be created when the external user Signs On to an event Bool
signOnTaskId If not 0, sign on should cause an Activity of this type to be registered FK Task
signOnAssocId If 0, the signOn Activity should go into the persons Our Contact; if not 0, this is the Associate whose diary should get the activity FK associate
signOnTextId If not 0, the given text should be entered into the appointment FK text
signOnConfTextId If not 0, the given text should be shown as a confirmation text before accpting Sign On FK text
signOnTriggersAssign If 1, the SignOn task should be created as an Assigned task, triggering the invitation dialog Bool
signOff Is Sign Off functionality enabled Bool
signOffTaskEnable If not 0, a task should be created when the external user Signs Off an event Bool
signOffTaskId If not 0, sign off should cause an Activity of this type to be registered FK Task
signOffAssocId If 0, the signOn Activity should go into the persons Our Contact; if not 0, this is the Associate whose diary should get the activity FK associate
signOffTextId If not 0, the given text should be shown as a confirmation text before accpting Sign Off FK text
signOffConfTextId If not 0, the given text should be shown as a confirmation text before accpting Sign Off FK text
signOffTriggersAssign If 1, the SignOff task should be created as an Assigned task, triggering the invitation dialog Bool
registered Registered when UtcDateTime
registered_associate_id Registered by whom FK associate
updated Last updated when UtcDateTime
updated_associate_id Last updated by whom FK associate
updatedCount Number of updates made to this record UShort

ExternalEvent table relationship diagram

Indexes

Fields Types Description
ExternalEvent_id PK Clustered, Unique
eventEnabled Bool Index
eventDate DateTime Index
parentTable TableNumber Index
parentRecord RecordId Index

Relationships

Table Description
associate Employees, resources and other users - except for External persons
Task Task list table, activity types, like Phone, Meeting
text Long text fields from all over the system

Replication Flags

  • Replicate changes DOWN from central to satellites and travellers.
  • Replicate changes UP from satellites and travellers back to central.
  • Copy to satellite and travel prototypes.

Security Flags

  • No access control via user's Role.
© SuperOffice. All rights reserved.
SuperOffice |  Community |  Release Notes |  Privacy |  Site feedback |  Search Docs |  About Docs |  Contribute |  Back to top