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__StudentInterest__c
- praveen.sampath
Analytics
Fields
Name | Label | Type | Description |
|---|---|---|---|
Id | Record ID | ID |
|
OwnerId | Owner ID | LOOKUP |
|
IsDeleted | Deleted | CHECKBOX |
|
Name | Student Interest | 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__Contact__c | Contact | FORMULA (TEXT)(1300) |
|
AQB__EducationId__c | Education Link | LOOKUP |
|
AQB__EducationalInstitution__c | Educational Institution | FORMULA (TEXT)(1300) | The name of the Educational Institution with which this Interest is associated. |
AQB__InterestGroup__c | Student Interest Group | FORMULA (TEXT)(1300) | Educational Interests may be grouped using this field, into categories such as Sports, Social Clubs, Academics, etc. |
AQB__InterestType__c | Student Interest Type | LOOKUP | Choose the Type of Interest from the lookup table as defined by your institution. |
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__Position__c | Position | TEXT(50) | This field may be used to describe a position held by the Contact related to the Interest, such as Team Captain, Club President, etc. |
AQB__Source__c | Source | TEXT(100) |
|
AQB__StartDay__c | Start Day | PICKLIST | The Day (if known) within the Start Month for this Student Interest. |
AQB__StartMonth__c | Start Month | PICKLIST | The Start Month (if known) for the beginning of this Student Interest. |
AQB__StartYear__c | Start Year | TEXT(4) | The Year in which this Student Interest began. |
AQB__StopDay__c | Stop Day | PICKLIST | The Day (if known) on which this Student Interest ended. |
AQB__StopMonth__c | Stop Month | PICKLIST | The Month (if known) in which this Student Interest ended. |
AQB__StopYear__c | Stop Year | TEXT(4) | The Year (if known) in which this Student Interest ended. |
aqcv_conversionid__c | aqcv conversionid | TEXT(255) | Unique id |
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. |
Validation rules
Name | Label |
|---|---|
Start_Year | Start_Year |
Stop_Year | Stop_Year |
Triggers
Name | Label |
|---|---|
StudentInterestTrigger | AQB.StudentInterestTrigger |
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 | Student Interest |
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__Contact__c |
Label | Contact |
Type | FORMULA (TEXT)(1300) |
Name | AQB__EducationId__c |
Label | Education Link |
Type | LOOKUP |
Foreign key | Yes |
Name | AQB__EducationalInstitution__c |
Label | Educational Institution |
Type | FORMULA (TEXT)(1300) |
Help Text | The name of the Educational Institution with which this Interest is associated. |
Description | The name of the Educational Institution with which this Interest is associated. |
Name | AQB__InterestGroup__c |
Label | Student Interest Group |
Type | FORMULA (TEXT)(1300) |
Help Text | Educational Interests may be grouped using this field, into categories such as Sports, Social Clubs, Academics, etc. |
Description | Educational Interests may be grouped using this field, into categories such as Sports, Social Clubs, Academics, etc. |
Name | AQB__InterestType__c |
Label | Student Interest Type |
Type | LOOKUP |
Foreign key | Yes |
Help Text | Choose the Type of Interest from the lookup table as defined by your institution. |
Description | Choose the Type of Interest from the lookup table as defined by your institution. |
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__Position__c |
Label | Position |
Type | TEXT(50) |
Help Text | This field may be used to describe a position held by the Contact related to the Interest, such as Team Captain, Club President, etc. |
Description | This field may be used to describe a position held by the Contact related to the Interest, such as Team Captain, Club President, etc. |
Name | AQB__Source__c |
Label | Source |
Type | TEXT(100) |
Name | AQB__StartDay__c |
Label | Start Day |
Type | PICKLIST |
Help Text | The Day (if known) within the Start Month for this Student Interest. |
Picklist values | 1 |
Description | The Day (if known) within the Start Month for this Student Interest. |
Name | AQB__StartMonth__c |
Label | Start Month |
Type | PICKLIST |
Help Text | The Start Month (if known) for the beginning of this Student Interest. |
Picklist values | 1 |
Description | The Start Month (if known) for the beginning of this Student Interest. |
Name | AQB__StartYear__c |
Label | Start Year |
Type | TEXT(4) |
Help Text | The Year in which this Student Interest began. |
Description | The Year in which this Student Interest began. |
Name | AQB__StopDay__c |
Label | Stop Day |
Type | PICKLIST |
Help Text | The Day (if known) on which this Student Interest ended. |
Picklist values | 1 |
Description | The Day (if known) on which this Student Interest ended. |
Name | AQB__StopMonth__c |
Label | Stop Month |
Type | PICKLIST |
Help Text | The Month (if known) in which this Student Interest ended. |
Picklist values | 1 |
Description | The Month (if known) in which this Student Interest ended. |
Name | AQB__StopYear__c |
Label | Stop Year |
Type | TEXT(4) |
Help Text | The Year (if known) in which this Student Interest ended. |
Description | The Year (if known) in which this Student Interest ended. |
Name | aqcv_conversionid__c |
Label | aqcv conversionid |
Type | TEXT(255) |
Unique | Yes |
Description | Unique id |
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. |