Attention: Confluence is not suitable for the storage of highly confidential data. Please ensure that any data classified as Highly Protected is stored using a more secure platform.
If you have any questions, please refer to the University's data classification guide or contact ict.askcyber@sydney.edu.au
Object: AQB__EventGuest__c
- praveen.sampath
Analytics
Fields
Name | Label | Type | Description |
|---|---|---|---|
Id | Record ID | ID |
|
IsDeleted | Deleted | CHECKBOX |
|
Name | Guest Number | AUTO NUMBER |
|
RecordTypeId | Record Type ID | LOOKUP |
|
CreatedDate | Created Date | DATETIME |
|
CreatedById | Created By ID | LOOKUP |
|
LastModifiedDate | Last Modified Date | DATETIME |
|
LastModifiedById | Last Modified By ID | LOOKUP |
|
SystemModstamp | System Modstamp | DATETIME |
|
LastActivityDate | Last Activity Date | DATE |
|
AQB__Event_Registration__c | Event Registration | MASTER-DETAIL |
|
AQB__Attendance__c | Attendance | PICKLIST | The Attendance specifics. |
AQB__Attended_Event__c | Attended Event | CHECKBOX |
|
AQB__Comment__c | Comment | TEXT AREA(255) |
|
AQB__Contact__c | Contact | LOOKUP |
|
AQB__EventEndDate__c | Event End Date | FORMULA (DATE) |
|
AQB__EventGuestExternalID__c | Event Guest External ID | TEXT(20) |
|
AQB__EventStartDateandTime__c | Event Start Date and Time | FORMULA (DATETIME) | The date and time that the Event starts. |
AQB__EventStopDateandTime__c | Event End Date and Time | FORMULA (DATETIME) | The date and time that the Event ends. |
AQB__EventVenue__c | Event Venue | FORMULA (TEXT)(1300) |
|
AQB__Event_Date__c | Event Start Date | FORMULA (DATE) |
|
AQB__Event_Location__c | Event Location | FORMULA (TEXT)(1300) |
|
AQB__Event__c | Event | FORMULA (TEXT)(1300) |
|
AQB__GuestFirstName__c | Guest First Name | TEXT(40) |
|
AQB__GuestFullName__c | Guest Full Name | FORMULA (TEXT)(1300) |
|
AQB__GuestLastName__c | Guest Last Name | TEXT(80) |
|
AQB__GuestTitle__c | Guest Title | TEXT(15) |
|
AQB__Registeredby__c | Registered by: | FORMULA (TEXT)(1300) |
|
AQB__Suffix__c | Suffix | PICKLIST |
|
aqcv_conversionid__c | aqcv conversionid | TEXT(255) | Unique id |
AQB__Lead__c | Lead | LOOKUP | The name of the guest. |
AQB__EngagementScoreCategory__c | Engagement Score Category | PICKLIST | Identifies the category group the engagement score will be totaled in to. |
AQB__EngagementScoreOverride__c | Engagement Score Override | CHECKBOX | This field will be used to change the value of the score manually to a value that does not meet the criteria of the defined rule within the Engagement Score parameter. |
AQB__EngagementScore__c | Engagement Score | NUMBER(4,0) | This field holds the score value associated with an override. |
Validation rules
Name | Label |
|---|---|
USYD_CommentsGT220 | USYD_CommentsGT220 |
Triggers
Name | Label |
|---|---|
EventGuest | AQB.EventGuest |
Fields Details
Name | Id |
Label | Record ID |
Type | ID |
Required | Yes |
Name | IsDeleted |
Label | Deleted |
Type | CHECKBOX |
Required | Yes |
Default value | false |
Name | Name |
Label | Guest Number |
Type | AUTO NUMBER |
Required | Yes |
Name | RecordTypeId |
Label | Record Type ID |
Type | LOOKUP |
Foreign key | Yes |
Name | CreatedDate |
Label | Created Date |
Type | DATETIME |
Required | Yes |
Name | CreatedById |
Label | Created By ID |
Type | LOOKUP |
Foreign key | Yes |
Required | Yes |
Name | LastModifiedDate |
Label | Last Modified Date |
Type | DATETIME |
Required | Yes |
Name | LastModifiedById |
Label | Last Modified By ID |
Type | LOOKUP |
Foreign key | Yes |
Required | Yes |
Name | SystemModstamp |
Label | System Modstamp |
Type | DATETIME |
Required | Yes |
Name | LastActivityDate |
Label | Last Activity Date |
Type | DATE |
Name | AQB__Event_Registration__c |
Label | Event Registration |
Type | MASTER-DETAIL |
Foreign key | Yes |
Required | Yes |
Help Text | The contact that registered this guest. |
Name | AQB__Attendance__c |
Label | Attendance |
Type | PICKLIST |
Help Text | The Attendance specifics. |
Picklist values | Attended |
Description | The Attendance specifics. |
Name | AQB__Attended_Event__c |
Label | Attended Event |
Type | CHECKBOX |
Required | Yes |
Help Text | Checked if this person attended the event. |
Default value | true |
Name | AQB__Comment__c |
Label | Comment |
Type | TEXT AREA(255) |
Help Text | Comment for this guest. |
Name | AQB__Contact__c |
Label | Contact |
Type | LOOKUP |
Foreign key | Yes |
Help Text | The guest's name if a constituent. |
Name | AQB__EventEndDate__c |
Label | Event End Date |
Type | FORMULA (DATE) |
Help Text | End date of the event. |
Name | AQB__EventGuestExternalID__c |
Label | Event Guest External ID |
Type | TEXT(20) |
Unique | Yes |
Help Text | ID to external event management system. |
Name | AQB__EventStartDateandTime__c |
Label | Event Start Date and Time |
Type | FORMULA (DATETIME) |
Help Text | The date and time that the Event starts. |
Description | The date and time that the Event starts. |
Name | AQB__EventStopDateandTime__c |
Label | Event End Date and Time |
Type | FORMULA (DATETIME) |
Help Text | The date and time that the Event ends. |
Description | The date and time that the Event ends. |
Name | AQB__EventVenue__c |
Label | Event Venue |
Type | FORMULA (TEXT)(1300) |
Help Text | The venue for the event. |
Name | AQB__Event_Date__c |
Label | Event Start Date |
Type | FORMULA (DATE) |
Help Text | Start date of the event. |
Name | AQB__Event_Location__c |
Label | Event Location |
Type | FORMULA (TEXT)(1300) |
Help Text | The location of the event. |
Name | AQB__Event__c |
Label | Event |
Type | FORMULA (TEXT)(1300) |
Help Text | Event |
Name | AQB__GuestFirstName__c |
Label | Guest First Name |
Type | TEXT(40) |
Help Text | First name of this guest. |
Name | AQB__GuestFullName__c |
Label | Guest Full Name |
Type | FORMULA (TEXT)(1300) |
Help Text | Guest Name |
Name | AQB__GuestLastName__c |
Label | Guest Last Name |
Type | TEXT(80) |
Help Text | Last name of this guest. |
Name | AQB__GuestTitle__c |
Label | Guest Title |
Type | TEXT(15) |
Help Text | Courtesy title for this guest. |
Name | AQB__Registeredby__c |
Label | Registered by: |
Type | FORMULA (TEXT)(1300) |
Help Text | The name of the contact that registered this guest. |
Name | AQB__Suffix__c |
Label | Suffix |
Type | PICKLIST |
Help Text | The suffix for this guest. |
Picklist values | Jr. |
Name | aqcv_conversionid__c |
Label | aqcv conversionid |
Type | TEXT(255) |
Unique | Yes |
Description | Unique id |
Name | AQB__Lead__c |
Label | Lead |
Type | LOOKUP |
Foreign key | Yes |
Help Text | The name of the guest. |
Description | The name of the guest. |
Name | AQB__EngagementScoreCategory__c |
Label | Engagement Score Category |
Type | PICKLIST |
Help Text | If using the override option, the appropriate engagement score category will be stored in this field. |
Picklist values | Communications |
Description | Identifies the category group the engagement score will be totaled in to. |
Name | AQB__EngagementScoreOverride__c |
Label | Engagement Score Override |
Type | CHECKBOX |
Required | Yes |
Help Text | If a manual update is needed for the Engagement Score value that is outside the parameters of the rule defined, the Engagement Score Override can be used. Marking the override checkbox, selecting the corresponding category will allow the user to manually override the "Engagement Score" field. |
Default value | false |
Description | This field will be used to change the value of the score manually to a value that does not meet the criteria of the defined rule within the Engagement Score parameter. |
Name | AQB__EngagementScore__c |
Label | Engagement Score |
Type | NUMBER(4,0) |
Help Text | When completing an Engagement Score override users will select the category, check the override box, and fill the engagement score field value to the desired score value. All three fields will need to be placed on the desired object. |
Description | This field holds the score value associated with an override. |