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__Award__c
- praveen.sampath
Analytics
Fields
Name | Label | Type | Description |
|---|---|---|---|
Id | Record ID | ID |
|
OwnerId | Owner ID | LOOKUP |
|
IsDeleted | Deleted | CHECKBOX |
|
Name | Award Name | TEXT(80) |
|
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__AwardTerms__c | Award Terms | TEXT AREA (LONG)(32768) |
|
AQB__AwardType__c | Award Renewal Type | PICKLIST |
|
AQB__AwardedBy__c | Awarded By | PICKLIST |
|
AQB__DateofFirstAward__c | Date of First Award | DATE |
|
AQB__DateofLastAward__c | Date of Last Award | DATE |
|
AQB__Description__c | Description | TEXT AREA (LONG)(32768) |
|
AQB__LLChartofAccountsId__c | LL- Chart of Accounts | LOOKUP |
|
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__TermofAward__c | Term of Award | PICKLIST |
|
AQB__TotalAmountAwarded__c | Total Amount Awarded | CURRENCY(9,2) |
|
aqcv_conversionid__c | aqcv conversionid | TEXT(255) | Unique id |
Usyd_Award_Category__c | Award Category | PICKLIST |
|
Usyd_Comment__c | Comment | TEXT AREA (LONG)(32768) |
|
Usyd_Fund_Code__c | Fund Code | TEXT(6) |
|
Usyd_Granting_Entity__c | Granting Entity | TEXT AREA(255) |
|
Usyd_IAP_Approved__c | IAP Approved | CHECKBOX | Tick when It is approved by IAP |
Usyd_Source__c | Source | TEXT AREA(255) |
|
Triggers
Name | Label |
|---|---|
AwardTrigger | AQB.AwardTrigger |
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 | Award Name |
Type | TEXT(80) |
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__AwardTerms__c |
Label | Award Terms |
Type | TEXT AREA (LONG)(32768) |
Help Text | The terms of this award. |
Name | AQB__AwardType__c |
Label | Award Renewal Type |
Type | PICKLIST |
Help Text | The renewal method for this award. |
Picklist values | Auto |
Name | AQB__AwardedBy__c |
Label | Awarded By |
Type | PICKLIST |
Help Text | The department or group making award. |
Picklist values | Other Sources |
Name | AQB__DateofFirstAward__c |
Label | Date of First Award |
Type | DATE |
Help Text | The date that an award was first made from this chart of accounts item. |
Name | AQB__DateofLastAward__c |
Label | Date of Last Award |
Type | DATE |
Help Text | Date of last award from this chart of accounts item. |
Name | AQB__Description__c |
Label | Description |
Type | TEXT AREA (LONG)(32768) |
Help Text | Description of the terms for this scholarship. |
Name | AQB__LLChartofAccountsId__c |
Label | LL- Chart of Accounts |
Type | LOOKUP |
Foreign key | Yes |
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__TermofAward__c |
Label | Term of Award |
Type | PICKLIST |
Help Text | The term for which the award applies. |
Picklist values | Annual |
Name | AQB__TotalAmountAwarded__c |
Label | Total Amount Awarded |
Type | CURRENCY(9,2) |
Help Text | The total of awards for this award. |
Name | aqcv_conversionid__c |
Label | aqcv conversionid |
Type | TEXT(255) |
Unique | Yes |
Description | Unique id |
Name | Usyd_Award_Category__c |
Label | Award Category |
Type | PICKLIST |
Picklist values | PR (Prize) |
Name | Usyd_Comment__c |
Label | Comment |
Type | TEXT AREA (LONG)(32768) |
Name | Usyd_Fund_Code__c |
Label | Fund Code |
Type | TEXT(6) |
Name | Usyd_Granting_Entity__c |
Label | Granting Entity |
Type | TEXT AREA(255) |
Name | Usyd_IAP_Approved__c |
Label | IAP Approved |
Type | CHECKBOX |
Required | Yes |
Help Text | IAP Approved is to be ticked for University of Sydney verified scholarships and awards |
Default value | false |
Description | Tick when It is approved by IAP |
Name | Usyd_Source__c |
Label | Source |
Type | TEXT AREA(255) |