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__Event__c
- praveen.sampath
Analytics
Fields
Name | Label | Type | Description |
|---|---|---|---|
Id | Record ID | ID |
|
OwnerId | Owner ID | LOOKUP |
|
IsDeleted | Deleted | CHECKBOX |
|
Name | Event Name | TEXT(80) |
|
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 |
|
LastViewedDate | Last Viewed Date | DATETIME |
|
LastReferencedDate | Last Referenced Date | DATETIME |
|
AQB__AffiliatedOrganizationSponsor__c | Affiliated Organization Sponsor | LOOKUP |
|
AQB__City__c | Venue City | TEXT(20) |
|
AQB__Comment__c | Comment | TEXT AREA(255) |
|
AQB__Country__c | Venue Country | PICKLIST |
|
AQB__Date__c | Start Date | DATE |
|
AQB__EndDate__c | End Date | DATE |
|
AQB__EventExternalID__c | Event External ID | TEXT(20) |
|
AQB__EventLocality__c | Event Locality | FORMULA (TEXT)(1300) |
|
AQB__Event_Type__c | Event Type | PICKLIST |
|
AQB__HostingAccount__c | Hosting Account | LOOKUP |
|
AQB__Note__c | Note | TEXT AREA (LONG)(32768) |
|
AQB__OwnerUnit__c | Owner Unit | PICKLIST | Designates the Unit of the User that created this record. This field is intended for use in creating Sharing Rules for the purpose of controlling access to the record. |
AQB__StartDateandTime__c | Start Date and Time | DATETIME |
|
AQB__State__c | Venue State | PICKLIST |
|
AQB__Status__c | Status | PICKLIST |
|
AQB__StopDateandTime__c | End Date and Time | DATETIME |
|
AQB__VenueStreetAddressLineThree__c | Venue Street Address Line Three | TEXT(80) |
|
AQB__VenueStreetAddressOne__c | Venue Street Address One | TEXT(80) |
|
AQB__VenueStreetAddressTwo__c | Venue Street Address Two | TEXT(80) |
|
AQB__Venue__c | Venue | TEXT(60) |
|
AQB__TotalNumberofGuests__c | Total Number of Guests | ROLL-UP SUMMARY |
|
AQB__TotalNumberofRegistrants__c | Total Number of Registrants | ROLL-UP SUMMARY |
|
AQB__Total_NumberofGuestsAttended__c | Total Number of Guests Attended | ROLL-UP SUMMARY |
|
AQB__Total_Registration_Revenue__c | Total Registration Revenue | ROLL-UP SUMMARY |
|
AQC_Hosting_Faculty_School__c | Hosting Faculty/School | PICKLIST | AQ_Custom |
aqcv_conversionid__c | aqcv conversionid | TEXT(255) | Unique id |
Usyd_Event_Mode__c | Event Mode | PICKLIST |
|
Triggers
Name | Label |
|---|---|
AQB_EventTrigger | AQB.AQB_EventTrigger |
Fields Details
Name | Id |
Label | Record ID |
Type | ID |
Required | Yes |
Name | OwnerId |
Label | Owner ID |
Type | LOOKUP |
Foreign key | Yes |
Required | Yes |
Name | IsDeleted |
Label | Deleted |
Type | CHECKBOX |
Required | Yes |
Default value | false |
Name | Name |
Label | Event Name |
Type | TEXT(80) |
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 | LastViewedDate |
Label | Last Viewed Date |
Type | DATETIME |
Name | LastReferencedDate |
Label | Last Referenced Date |
Type | DATETIME |
Name | AQB__AffiliatedOrganizationSponsor__c |
Label | Affiliated Organization Sponsor |
Type | LOOKUP |
Foreign key | Yes |
Help Text | The Affiliated Organization that sponsored this event. |
Name | AQB__City__c |
Label | Venue City |
Type | TEXT(20) |
Help Text | City where event took place. |
Name | AQB__Comment__c |
Label | Comment |
Type | TEXT AREA(255) |
Help Text | Comments concerning this event. |
Name | AQB__Country__c |
Label | Venue Country |
Type | PICKLIST |
Help Text | The country in which the event took place. |
Picklist values | Afghanistan |
Name | AQB__Date__c |
Label | Start Date |
Type | DATE |
Help Text | Date on which this event started. |
Name | AQB__EndDate__c |
Label | End Date |
Type | DATE |
Help Text | Date on which this event ended. |
Name | AQB__EventExternalID__c |
Label | Event External ID |
Type | TEXT(20) |
Unique | Yes |
Help Text | ID to an external event system. |
Name | AQB__EventLocality__c |
Label | Event Locality |
Type | FORMULA (TEXT)(1300) |
Help Text | The locality where this event took place. |
Name | AQB__Event_Type__c |
Label | Event Type |
Type | PICKLIST |
Help Text | The type of event. |
Picklist values | 1850 Society Cocktail Reception |
Name | AQB__HostingAccount__c |
Label | Hosting Account |
Type | LOOKUP |
Foreign key | Yes |
Help Text | If this event was hosted by an individual account, this is link to that Account. |
Name | AQB__Note__c |
Label | Note |
Type | TEXT AREA (LONG)(32768) |
Help Text | Note regarding this Event. |
Name | AQB__OwnerUnit__c |
Label | Owner Unit |
Type | PICKLIST |
Help Text | Designates the Unit of the User that created this record. This field is intended for use in creating Sharing Rules for the purpose of controlling access to the record. |
Picklist values | Advancement Services |
Description | Designates the Unit of the User that created this record. This field is intended for use in creating Sharing Rules for the purpose of controlling access to the record. |
Name | AQB__StartDateandTime__c |
Label | Start Date and Time |
Type | DATETIME |
Help Text | Date and Time that the event started. |
Name | AQB__State__c |
Label | Venue State |
Type | PICKLIST |
Help Text | State or province where the event took place. |
Picklist values | Alabama |
Name | AQB__Status__c |
Label | Status |
Type | PICKLIST |
Help Text | Status of this event. |
Picklist values | Planned |
Name | AQB__StopDateandTime__c |
Label | End Date and Time |
Type | DATETIME |
Help Text | Date and time that the event ended. |
Name | AQB__VenueStreetAddressLineThree__c |
Label | Venue Street Address Line Three |
Type | TEXT(80) |
Help Text | Third line of address where event was held. |
Name | AQB__VenueStreetAddressOne__c |
Label | Venue Street Address One |
Type | TEXT(80) |
Help Text | First line of address where event was held. |
Name | AQB__VenueStreetAddressTwo__c |
Label | Venue Street Address Two |
Type | TEXT(80) |
Help Text | Second line of address where event was held. |
Name | AQB__Venue__c |
Label | Venue |
Type | TEXT(60) |
Help Text | Building or other location where the event took place. |
Name | AQB__TotalNumberofGuests__c |
Label | Total Number of Guests |
Type | ROLL-UP SUMMARY |
Help Text | Total number of guests registered for this event. |
Name | AQB__TotalNumberofRegistrants__c |
Label | Total Number of Registrants |
Type | ROLL-UP SUMMARY |
Help Text | The total number of registrants for this event. |
Name | AQB__Total_NumberofGuestsAttended__c |
Label | Total Number of Guests Attended |
Type | ROLL-UP SUMMARY |
Help Text | The total number of guests attending this event. |
Name | AQB__Total_Registration_Revenue__c |
Label | Total Registration Revenue |
Type | ROLL-UP SUMMARY |
Help Text | The total amount of all registrations. |
Name | AQC_Hosting_Faculty_School__c |
Label | Hosting Faculty/School |
Type | PICKLIST |
Help Text | Indicates the faculty or school responsible for the event. |
Picklist values | AAIA |
Description | AQ_Custom |
Name | aqcv_conversionid__c |
Label | aqcv conversionid |
Type | TEXT(255) |
Unique | Yes |
Description | Unique id |
Name | Usyd_Event_Mode__c |
Label | Event Mode |
Type | PICKLIST |
Help Text | AVE-478: capture the mode of delivery |
Picklist values | In Person |