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__NotesAndComments__c
- praveen.sampath
Analytics
Fields
Name | Label | Type | Description |
|---|---|---|---|
Id | Record ID | ID |
|
OwnerId | Owner ID | LOOKUP |
|
IsDeleted | Deleted | CHECKBOX |
|
Name | Note/Comment 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 | Link to the Account to which this note belongs. |
AQB__Amount__c | Amount | CURRENCY(10,2) | To associate a value with the Notes and Comments record that might not be same value as the gift/pledge. |
AQB__Contact__c | Contact | LOOKUP | Link to the Contact to which this note belongs. |
AQB__DateOfPublication__c | Date of Publication | DATE | The date the note was published. |
AQB__Gift__c | Gift/Pledge | LOOKUP | Link to the Gift/Pledge to which this note belongs. |
AQB__Note__c | Note | TEXT AREA (RICH)(20000) | Text of the Note/Comment |
AQB__Opportunity__c | Opportunity | LOOKUP | Link to the Opportunity to which this note belongs. |
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__Source__c | Source | PICKLIST |
|
AQB__Subtype__c | Subtype | PICKLIST |
|
AQB__Type__c | Type | PICKLIST | Describes the type of Note or Comment. |
aqcv_conversionid__c | aqcv conversionid | TEXT(255) | Unique id |
AQB__LLChartofAccountsId__c | LL- Chart of Accounts | LOOKUP | Id for LL - Chart of Accounts row |
Employment__c | Employment | LOOKUP | TAPSS-914: used to link Notes and Comments to AQB__Employment__c object |
Membership__c | Membership | LOOKUP | TAPSS-914: used to link Notes and Comments to AQB__Membership__c object |
Relationship_Management_Team__c | Relationship Management Team | LOOKUP | TAPSS-914: used to link Notes and Comments to AQB__PMTeam__c object |
Relationship__c | Relationship | LOOKUP | TAPSS-914: used to link Notes and Comments to AQB__Affiliation__c object |
Relationship_with_Contact__c | Relationship with Contact | LOOKUP | TAPSS-914: used to link Notes and Comments to AQB__RelationshipContact__c object |
Stewardship__c | Stewardship | LOOKUP | TAPSS-914: used to link Notes and Comments to AQB__StewardshipPlan__c object |
Volunteer_Position__c | Volunteer Position | LOOKUP | TAPSS-914: used to link Notes and Comments to AQB__VolunteerPosition__c object |
USYD_Rating__c | Rating | LOOKUP |
|
Triggers
Name | Label |
|---|---|
NotesAndCommentsTrigger | AQB.NotesAndCommentsTrigger |
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 | Note/Comment 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 |
Help Text | Link to the Account to which this note belongs. |
Description | Link to the Account to which this note belongs. |
Name | AQB__Amount__c |
Label | Amount |
Type | CURRENCY(10,2) |
Help Text | Enter an amount for this Note. |
Description | To associate a value with the Notes and Comments record that might not be same value as the gift/pledge. |
Name | AQB__Contact__c |
Label | Contact |
Type | LOOKUP |
Foreign key | Yes |
Help Text | Link to the Contact to which this note belongs. |
Description | Link to the Contact to which this note belongs. |
Name | AQB__DateOfPublication__c |
Label | Date of Publication |
Type | DATE |
Help Text | The date the note was published. |
Description | The date the note was published. |
Name | AQB__Gift__c |
Label | Gift/Pledge |
Type | LOOKUP |
Foreign key | Yes |
Help Text | Link to the Gift/Pledge to which this note belongs. |
Description | Link to the Gift/Pledge to which this note belongs. |
Name | AQB__Note__c |
Label | Note |
Type | TEXT AREA (RICH)(20000) |
Help Text | Text of the Note/Comment |
Description | Text of the Note/Comment |
Name | AQB__Opportunity__c |
Label | Opportunity |
Type | LOOKUP |
Foreign key | Yes |
Help Text | Link to the Opportunity to which this note belongs. |
Description | Link to the Opportunity to which this note belongs. |
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__Source__c |
Label | Source |
Type | PICKLIST |
Picklist values | Constituent |
Name | AQB__Subtype__c |
Label | Subtype |
Type | PICKLIST |
Help Text | Subtype for the note. |
Picklist values | Acceptable Source |
Name | AQB__Type__c |
Label | Type |
Type | PICKLIST |
Help Text | Describes the type of Note or Comment. |
Picklist values | Awards and Honours |
Description | Describes the type of Note or Comment. |
Name | aqcv_conversionid__c |
Label | aqcv conversionid |
Type | TEXT(255) |
Unique | Yes |
Description | Unique id |
Name | AQB__LLChartofAccountsId__c |
Label | LL- Chart of Accounts |
Type | LOOKUP |
Foreign key | Yes |
Help Text | Id for LL - Chart of Accounts row |
Description | Id for LL - Chart of Accounts row |
Name | Employment__c |
Label | Employment |
Type | LOOKUP |
Foreign key | Yes |
Help Text | Link to the Employment record to which this note belongs. |
Description | TAPSS-914: used to link Notes and Comments to AQB__Employment__c object |
Name | Membership__c |
Label | Membership |
Type | LOOKUP |
Foreign key | Yes |
Help Text | Link to the Membership record to which this note belongs. |
Description | TAPSS-914: used to link Notes and Comments to AQB__Membership__c object |
Name | Relationship_Management_Team__c |
Label | Relationship Management Team |
Type | LOOKUP |
Foreign key | Yes |
Help Text | Link to the Employment record to which this note belongs. |
Description | TAPSS-914: used to link Notes and Comments to AQB__PMTeam__c object |
Name | Relationship__c |
Label | Relationship |
Type | LOOKUP |
Foreign key | Yes |
Help Text | Link to the Relationship with Account record to which this note belongs. |
Description | TAPSS-914: used to link Notes and Comments to AQB__Affiliation__c object |
Name | Relationship_with_Contact__c |
Label | Relationship with Contact |
Type | LOOKUP |
Foreign key | Yes |
Help Text | Link to the Relationship with Contact record to which this note belongs. |
Description | TAPSS-914: used to link Notes and Comments to AQB__RelationshipContact__c object |
Name | Stewardship__c |
Label | Stewardship |
Type | LOOKUP |
Foreign key | Yes |
Help Text | Link to the Stewardship record to which this note belongs. |
Description | TAPSS-914: used to link Notes and Comments to AQB__StewardshipPlan__c object |
Name | Volunteer_Position__c |
Label | Volunteer Position |
Type | LOOKUP |
Foreign key | Yes |
Help Text | Link to the Volunteer record to which this note belongs. |
Description | TAPSS-914: used to link Notes and Comments to AQB__VolunteerPosition__c object |
Name | USYD_Rating__c |
Label | Rating |
Type | LOOKUP |
Foreign key | Yes |