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__Registration__c
- praveen.sampath
Analytics
Fields
Name | Label | Type | Description |
|---|---|---|---|
Id | Record ID | ID |
|
IsDeleted | Deleted | CHECKBOX |
|
Name | Registration 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__c | Event | MASTER-DETAIL |
|
AQB__Campaign__c | Campaign | LOOKUP |
|
AQB__ChartofAccounts__c | Designation | LOOKUP |
|
AQB__Comment__c | Comment | TEXT AREA(255) |
|
AQB__Contact__c | Contact | LOOKUP |
|
AQB__Date_of_Registration__c | Date of Registration | DATE |
|
AQB__EventDate__c | Event Start Date | FORMULA (DATE) |
|
AQB__EventEndDate__c | Event End Date | FORMULA (DATE) |
|
AQB__EventLocality__c | Event Location | FORMULA (TEXT)(1300) |
|
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__Event_Venue__c | Event Venue | FORMULA (TEXT)(1300) |
|
AQB__RegistrationExternalID__c | Registration External ID | TEXT(20) |
|
AQB__Total_Registration_Amount__c | Total Registration Amount | CURRENCY(9,2) |
|
AQB__NumberofGuestsAttended__c | Number of Guests Attended | ROLL-UP SUMMARY |
|
AQB__NumberofGuests__c | Number of Guests | ROLL-UP SUMMARY |
|
aqcv_conversionid__c | aqcv conversionid | TEXT(255) | Unique id |
AQB__Lead__c | Lead | LOOKUP | The name of the registrant. |
AQB__RegistrationFullName__c | Registration Full Name | FORMULA (TEXT)(1300) |
|
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. |
Event_Id__c | Event Id | TEXT(20) | This field is populated by a flow.(USYD create records in event registration) |
Validation rules
Name | Label |
|---|---|
Usyd_comments_cant_be_gt_220 | Usyd_comments_cant_be_gt_220 |
Triggers
Name | Label |
|---|---|
EventRegistration | AQB.EventRegistration |
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 | Registration 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__c |
Label | Event |
Type | MASTER-DETAIL |
Foreign key | Yes |
Required | Yes |
Help Text | The event for this registration. |
Name | AQB__Campaign__c |
Label | Campaign |
Type | LOOKUP |
Foreign key | Yes |
Help Text | Event Campaign that generated this registration. |
Name | AQB__ChartofAccounts__c |
Label | Designation |
Type | LOOKUP |
Foreign key | Yes |
Help Text | Link to a designation in the chart of accounts. |
Name | AQB__Comment__c |
Label | Comment |
Type | TEXT AREA(255) |
Help Text | Comment about this registration can't exceed 220. If exceeds create notes from the new note button or notes and attachments tab in the related tab. If blank check notes in the related tab. |
Name | AQB__Contact__c |
Label | Contact |
Type | LOOKUP |
Foreign key | Yes |
Help Text | The name of the registrant. |
Name | AQB__Date_of_Registration__c |
Label | Date of Registration |
Type | DATE |
Help Text | Date this registration was made. |
Name | AQB__EventDate__c |
Label | Event Start Date |
Type | FORMULA (DATE) |
Help Text | The date that the event started. |
Name | AQB__EventEndDate__c |
Label | Event End Date |
Type | FORMULA (DATE) |
Help Text | Date that the event ended. |
Name | AQB__EventLocality__c |
Label | Event Location |
Type | FORMULA (TEXT)(1300) |
Help Text | The locality where this event took place. |
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__Event_Venue__c |
Label | Event Venue |
Type | FORMULA (TEXT)(1300) |
Help Text | The venue where this event took place. |
Name | AQB__RegistrationExternalID__c |
Label | Registration External ID |
Type | TEXT(20) |
Unique | Yes |
Help Text | ID to external event system registration. |
Name | AQB__Total_Registration_Amount__c |
Label | Total Registration Amount |
Type | CURRENCY(9,2) |
Help Text | Total amount paid for registration for all guests. |
Name | AQB__NumberofGuestsAttended__c |
Label | Number of Guests Attended |
Type | ROLL-UP SUMMARY |
Help Text | Total number of guests for this registrant that attended the event. |
Name | AQB__NumberofGuests__c |
Label | Number of Guests |
Type | ROLL-UP SUMMARY |
Help Text | Total number of guests for this registrant. |
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 registrant. |
Description | The name of the registrant. |
Name | AQB__RegistrationFullName__c |
Label | Registration Full Name |
Type | FORMULA (TEXT)(1300) |
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. |
Name | Event_Id__c |
Label | Event Id |
Type | TEXT(20) |
Description | This field is populated by a flow.(USYD create records in event registration) |