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__StageTrack__c
- praveen.sampath
Analytics
Fields
Name | Label | Type | Description |
|---|---|---|---|
Id | Record ID | ID |
|
IsDeleted | Deleted | CHECKBOX |
|
Name | Stage Track 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 |
|
AQB__Opportunity__c | Opportunity | MASTER-DETAIL | A system field used to maintain the link between the Opportunity and this Stage Track record. |
AQB__Amount__c | Amount | CURRENCY(16,2) | This field is a reflection of the anticipated Amount, as entered in the Opportunity record. |
AQB__DaysinStage__c | Days in Stage | FORMULA (NUMBER)(18,0) | Based on the current date and the Start Date of this Stage, this is a system-calculation of the number of days in the current Stage. |
AQB__EndDate__c | End Date | DATE | If a new Amount, a different Stage Name, or a different Probability is entered for this Opportunity, the End Date is set to the current date and a new Stage Track is created with the new information. |
AQB__Owner__c | Owner | FORMULA (TEXT)(1300) | The user who 'owns' this Stage Track record. |
AQB__Probability__c | Probability | PERCENT(3,0) | This is a reflection of the Probability field from the Opportunity, which is an estimate of the liklihood that the donor will fund this Opportunity. If this data is edited in the Opportunity, the Stage Track is given a Stop Date and a new one is created with the new Probability and a Start Date of the current date. |
AQB__StageComment__c | Stage Comment | TEXT AREA (LONG)(32768) |
|
AQB__Stage__c | Stage | TEXT(40) | This is a reflection of the Stage field from the Opportunity. If this data is edited in the Opportunity, the Stage Track is given an End Date and a new one is created with the new Stage Name and a Start Date of the current date. |
AQB__StartDate__c | Start Date | DATE | The date on which the Opportunity began the current Stage of cultivation. This date is automatically entered when a new Stage Track is generated by the editing of the Amount, Stage Name or Probability in the Opportunity. |
AQB__User__c | User | LOOKUP | The system user responsible for the creation of this Stage Track. |
aqcv_conversionid__c | aqcv conversionid | TEXT(255) | Unique id |
Fields Details
Name | Id |
Label | Record ID |
Type | ID |
Required | Yes |
Name | IsDeleted |
Label | Deleted |
Type | CHECKBOX |
Required | Yes |
Default value | false |
Name | Name |
Label | Stage Track 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 | AQB__Opportunity__c |
Label | Opportunity |
Type | MASTER-DETAIL |
Foreign key | Yes |
Required | Yes |
Help Text | A system field used to maintain the link between the Opportunity and this Stage Track record. |
Description | A system field used to maintain the link between the Opportunity and this Stage Track record. |
Name | AQB__Amount__c |
Label | Amount |
Type | CURRENCY(16,2) |
Help Text | This field is a reflection of the anticipated Amount, as entered in the Opportunity record. |
Description | This field is a reflection of the anticipated Amount, as entered in the Opportunity record. |
Name | AQB__DaysinStage__c |
Label | Days in Stage |
Type | FORMULA (NUMBER)(18,0) |
Help Text | Based on the current date and the Start Date of this Stage, this is a system-calculation of the number of days in the current Stage. |
Description | Based on the current date and the Start Date of this Stage, this is a system-calculation of the number of days in the current Stage. |
Name | AQB__EndDate__c |
Label | End Date |
Type | DATE |
Help Text | If a new Amount, a different Stage Name, or a different Probability is entered for this Opportunity, the End Date is set to the current date and a new Stage Track is created with the new information. |
Description | If a new Amount, a different Stage Name, or a different Probability is entered for this Opportunity, the End Date is set to the current date and a new Stage Track is created with the new information. |
Name | AQB__Owner__c |
Label | Owner |
Type | FORMULA (TEXT)(1300) |
Help Text | The user who 'owns' this Stage Track record. |
Description | The user who 'owns' this Stage Track record. |
Name | AQB__Probability__c |
Label | Probability |
Type | PERCENT(3,0) |
Help Text | A reflection of the Probability field from the Opportunity. If this data is edited in the Opportunity, the Stage Track is given a Stop Date and a new one is created with the new Probability and a Start Date of the current date. |
Description | This is a reflection of the Probability field from the Opportunity, which is an estimate of the liklihood that the donor will fund this Opportunity. If this data is edited in the Opportunity, the Stage Track is given a Stop Date and a new one is created with the new Probability and a Start Date of the current date. |
Name | AQB__StageComment__c |
Label | Stage Comment |
Type | TEXT AREA (LONG)(32768) |
Help Text | Free-formed comment field to be associated with the stage. Possible use could be record the reason for a stage change. |
Name | AQB__Stage__c |
Label | Stage |
Type | TEXT(40) |
Required | Yes |
Help Text | This is a reflection of the Stage field from the Opportunity. If this data is edited in the Opportunity, the Stage Track is given an End Date and a new one is created with the new Stage Name and a Start Date of the current date. |
Description | This is a reflection of the Stage field from the Opportunity. If this data is edited in the Opportunity, the Stage Track is given an End Date and a new one is created with the new Stage Name and a Start Date of the current date. |
Name | AQB__StartDate__c |
Label | Start Date |
Type | DATE |
Help Text | The date on which the Opportunity began the current Stage of cultivation. This date is automatically entered when a new Stage Track is generated by the editing of the Amount, Stage Name or Probability in the Opportunity. |
Description | The date on which the Opportunity began the current Stage of cultivation. This date is automatically entered when a new Stage Track is generated by the editing of the Amount, Stage Name or Probability in the Opportunity. |
Name | AQB__User__c |
Label | User |
Type | LOOKUP |
Foreign key | Yes |
Help Text | The system user responsible for the creation of this Stage Track. |
Description | The system user responsible for the creation of this Stage Track. |
Name | aqcv_conversionid__c |
Label | aqcv conversionid |
Type | TEXT(255) |
Unique | Yes |
Description | Unique id |