ExternalEvent Table (233)
•
Environment: onsite, online
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 |
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.