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__Membership__c
- praveen.sampath
Analytics
Fields
Name | Label | Type | Description |
|---|---|---|---|
Id | Record ID | ID |
|
OwnerId | Owner ID | LOOKUP |
|
IsDeleted | Deleted | CHECKBOX |
|
Name | Membership Number | AUTO NUMBER |
|
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__Account__c | Account | LOOKUP |
|
AQB__Active__c | Active | CHECKBOX |
|
AQB__AffiliatedOrganization__c | Affiliated Organization | LOOKUP | Organization Affiliated with this Membership. |
AQB__AutoRenew__c | Auto-Renew | CHECKBOX |
|
AQB__Comment__c | Comment | TEXT AREA (LONG)(32768) |
|
AQB__ContactId__c | Contact | LOOKUP | The contact for this Membership. |
AQB__Downgrade__c | Downgrade | CHECKBOX | Indicates that this membership is an downgrade from a previous membership. |
AQB__DuesPaid__c | Dues Paid | CURRENCY(9,2) | Dues paid for this Membership. |
AQB__Dues__c | Dues | LOOKUP | The dues payment that resulted in this membership. |
AQB__Honorary__c | Honorary | CHECKBOX | This is checked if the membership was gifted to the contact. |
AQB__LastPaymentDate__c | Last Payment Date | DATE |
|
AQB__MembershipType__c | Membership Type | TEXT(80) | Indicates the membership type of the membership. |
AQB__Membership_Level__c | Membership Level | PICKLIST |
|
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__StartDate__c | Start Date | DATE |
|
AQB__StopDate__c | Stop Date | DATE |
|
AQB__Upgrade__c | Upgrade | CHECKBOX | Indicates that this membership is an upgrade from a previous membership. |
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. |
Triggers
Name | Label |
|---|---|
MembershipTrigger | AQB.MembershipTrigger |
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 | Membership Number |
Type | AUTO NUMBER |
Required | 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__Account__c |
Label | Account |
Type | LOOKUP |
Foreign key | Yes |
Name | AQB__Active__c |
Label | Active |
Type | CHECKBOX |
Required | Yes |
Default value | false |
Name | AQB__AffiliatedOrganization__c |
Label | Affiliated Organization |
Type | LOOKUP |
Foreign key | Yes |
Help Text | Organization Affiliated with this Membership. |
Description | Organization Affiliated with this Membership. |
Name | AQB__AutoRenew__c |
Label | Auto-Renew |
Type | CHECKBOX |
Required | Yes |
Help Text | Indicates that this membership is automatically renewed. |
Default value | false |
Name | AQB__Comment__c |
Label | Comment |
Type | TEXT AREA (LONG)(32768) |
Name | AQB__ContactId__c |
Label | Contact |
Type | LOOKUP |
Foreign key | Yes |
Help Text | The contact for this Membership. |
Description | The contact for this Membership. |
Name | AQB__Downgrade__c |
Label | Downgrade |
Type | CHECKBOX |
Required | Yes |
Help Text | Indicates that this membership is an downgrade from a previous membership. |
Default value | false |
Description | Indicates that this membership is an downgrade from a previous membership. |
Name | AQB__DuesPaid__c |
Label | Dues Paid |
Type | CURRENCY(9,2) |
Help Text | Dues paid for this Membership. |
Description | Dues paid for this Membership. |
Name | AQB__Dues__c |
Label | Dues |
Type | LOOKUP |
Foreign key | Yes |
Help Text | The dues payment that resulted in this membership. |
Description | The dues payment that resulted in this membership. |
Name | AQB__Honorary__c |
Label | Honorary |
Type | CHECKBOX |
Required | Yes |
Help Text | This is checked if the membership was gifted to the contact. |
Default value | false |
Description | This is checked if the membership was gifted to the contact. |
Name | AQB__LastPaymentDate__c |
Label | Last Payment Date |
Type | DATE |
Help Text | The date that a payment was last made for this membership. |
Name | AQB__MembershipType__c |
Label | Membership Type |
Type | TEXT(80) |
Help Text | Indicates the membership type of the membership. |
Description | Indicates the membership type of the membership. |
Name | AQB__Membership_Level__c |
Label | Membership Level |
Type | PICKLIST |
Help Text | The level of membership. |
Picklist values | Single |
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__StartDate__c |
Label | Start Date |
Type | DATE |
Name | AQB__StopDate__c |
Label | Stop Date |
Type | DATE |
Name | AQB__Upgrade__c |
Label | Upgrade |
Type | CHECKBOX |
Required | Yes |
Help Text | Indicates that this membership is an upgrade from a previous membership. |
Default value | false |
Description | Indicates that this membership is an upgrade from a previous membership. |
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. |