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__QuidSpecification__c
- praveen.sampath
Analytics
Fields
Name | Label | Type | Description |
|---|---|---|---|
Id | Record ID | ID |
|
OwnerId | Owner ID | LOOKUP |
|
IsDeleted | Deleted | CHECKBOX |
|
Name | Activity 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 |
|
AQB__Active__c | Active | CHECKBOX | Use the checkbox to indicate whether or not this Quid is currently available for use. |
AQB__Campaign__c | Eligible Campaign Appeal | LOOKUP | To qualify for this Quid, the gift must be attributed to the Campaign named in this field. |
AQB__CampaignandDesignationRequired__c | Campaign and Designation Required | CHECKBOX | This checkbox is used to indicate whether the specified Campaign and Designation are both required in order for a donation to qualify for this Quid Pro Quo item. |
AQB__EligibleDesignation__c | Eligible Designation | LOOKUP | To qualify for this Quid, the gift must have the Designation from the Chart of Accounts, named in this field. |
AQB__EligibleFund__c | Eligible Fundraising Campaign | LOOKUP | To qualify for this Quid, the gift must be attributed to the Campaign Fund named in this field. |
AQB__EndofEligiblePeriod__c | End of Eligible Period | DATE | This is the last date on which gifts may qualify for this Quid. |
AQB__InventoryItem__c | Inventory Item | LOOKUP | This is the Quid item that is awarded according to the specifications in this record. |
AQB__MaximumAmount__c | Maximum Amount | CURRENCY(9,2) | Enter the maximum amount of a gift or transaction which will qualify for this quid pro quo item. |
AQB__MinimumAmount__c | Minimum Amount | CURRENCY(9,2) | Enter the minimum amount of a gift or transaction which will qualify for this quid pro quo item. |
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__StartofEligiblePeriod__c | Start of Eligible Period | DATE | This is the first date on which gifts may qualify for this Quid. |
AQB__TemplateName__c | Template Name | TEXT(50) |
|
AQB__Level__c | Level | PICKLIST | Indicates whether the Quid is based on the total gift or is transaction based. |
Validation rules
Name | Label |
|---|---|
Amount_Check | Amount_Check |
Date_Check | Date_Check |
Minimum_Amount_Check | Minimum_Amount_Check |
Triggers
Name | Label |
|---|---|
QuidSpecificationTrigger | AQB.QuidSpecificationTrigger |
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 | Activity 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 | AQB__Active__c |
Label | Active |
Type | CHECKBOX |
Required | Yes |
Help Text | Use the checkbox to indicate whether or not this Quid is currently available for use. |
Default value | true |
Description | Use the checkbox to indicate whether or not this Quid is currently available for use. |
Name | AQB__Campaign__c |
Label | Eligible Campaign Appeal |
Type | LOOKUP |
Foreign key | Yes |
Help Text | To qualify for this Quid, the gift must be attributed to the Campaign named in this field. |
Description | To qualify for this Quid, the gift must be attributed to the Campaign named in this field. |
Name | AQB__CampaignandDesignationRequired__c |
Label | Campaign and Designation Required |
Type | CHECKBOX |
Required | Yes |
Help Text | This checkbox is used to indicate whether the specified Campaign and Designation are both required in order for a donation to qualify for this Quid Pro Quo item. |
Default value | true |
Description | This checkbox is used to indicate whether the specified Campaign and Designation are both required in order for a donation to qualify for this Quid Pro Quo item. |
Name | AQB__EligibleDesignation__c |
Label | Eligible Designation |
Type | LOOKUP |
Foreign key | Yes |
Help Text | To qualify for this Quid, the gift must have the Designation from the Chart of Accounts, named in this field. |
Description | To qualify for this Quid, the gift must have the Designation from the Chart of Accounts, named in this field. |
Name | AQB__EligibleFund__c |
Label | Eligible Fundraising Campaign |
Type | LOOKUP |
Foreign key | Yes |
Help Text | To qualify for this Quid, the gift must be attributed to the Campaign Fund named in this field. |
Description | To qualify for this Quid, the gift must be attributed to the Campaign Fund named in this field. |
Name | AQB__EndofEligiblePeriod__c |
Label | End of Eligible Period |
Type | DATE |
Required | Yes |
Help Text | This is the last date on which gifts may qualify for this Quid. |
Description | This is the last date on which gifts may qualify for this Quid. |
Name | AQB__InventoryItem__c |
Label | Inventory Item |
Type | LOOKUP |
Foreign key | Yes |
Help Text | This is the Quid item that is awarded according to the specifications in this record. |
Description | This is the Quid item that is awarded according to the specifications in this record. |
Name | AQB__MaximumAmount__c |
Label | Maximum Amount |
Type | CURRENCY(9,2) |
Required | Yes |
Help Text | Enter the maximum amount of a gift or transaction which will qualify for this quid pro quo item. |
Description | Enter the maximum amount of a gift or transaction which will qualify for this quid pro quo item. |
Name | AQB__MinimumAmount__c |
Label | Minimum Amount |
Type | CURRENCY(9,2) |
Required | Yes |
Help Text | Enter the minimum amount of gift or transaction which will qualify for this quid pro quo item. |
Description | Enter the minimum amount of a gift or transaction which will qualify for this quid pro quo item. |
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__StartofEligiblePeriod__c |
Label | Start of Eligible Period |
Type | DATE |
Required | Yes |
Help Text | This is the first date on which gifts may qualify for this Quid. |
Description | This is the first date on which gifts may qualify for this Quid. |
Name | AQB__TemplateName__c |
Label | Template Name |
Type | TEXT(50) |
Name | AQB__Level__c |
Label | Level |
Type | PICKLIST |
Help Text | Indicates whether the Quid is based on the total gift or is transaction based. |
Picklist values | Gift Level |
Description | Indicates whether the Quid is based on the total gift or is transaction based. |