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__AreaOfStudy__c
- praveen.sampath
Analytics
Fields
Name | Label | Type | Description |
|---|---|---|---|
Id | Record ID | ID |
|
IsDeleted | Deleted | CHECKBOX |
|
Name | Area of Study Name | 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 |
|
LastViewedDate | Last Viewed Date | DATETIME |
|
LastReferencedDate | Last Referenced Date | DATETIME |
|
AQB__Education__c | Education | MASTER-DETAIL |
|
AQB__AreaOfStudy__c | Area of Study | LOOKUP |
|
AQB__ConcentrationLevel__c | Concentration Level | PICKLIST |
|
AQB__Contact__c | Contact | LOOKUP | The contact that has this area of study. |
AQB__DegreeIncludesThisConcentration__c | Degree Includes this Concentration? | CHECKBOX |
|
AQB__EndYear__c | End Year | TEXT(4) |
|
AQB__Institution__c | LL- Institution | LOOKUP | The school or institution associated with this Area of Study. |
AQB__PrimaryAreaOfStudy__c | Primary Area of Study | CHECKBOX |
|
AQB__StartYear__c | Start Year | TEXT(4) |
|
aqcv_conversionid__c | aqcv conversionid | TEXT(255) | Unique id |
usyd_student_pathway_code__c | USYD student pathway code | TEXT(60) | student code plus pathway code to uniquely identify pathway records while upserting data. |
code__c | code | FORMULA (TEXT)(1300) |
|
SITS_award_code__c | SITS award code | FORMULA (TEXT)(1300) |
|
Advance_ID__c | Advance ID | FORMULA (TEXT)(1300) |
|
Flag__c | Flag | TEXT(2) |
|
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. |
Usyd_Comments__c | Comments | TEXT(120) | Comments to keep notes |
Validation rules
Name | Label |
|---|---|
End_Year_Must_be_Numeric | End_Year_Must_be_Numeric |
Offered_at_this_Institution_Validation | Offered_at_this_Institution_Validation |
Start_Year_Must_be_Numeric | Start_Year_Must_be_Numeric |
Triggers
Name | Label |
|---|---|
AreaOfStudyTriggers | AQB.AreaOfStudyTriggers |
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 | Area of Study Name |
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 | LastViewedDate |
Label | Last Viewed Date |
Type | DATETIME |
Name | LastReferencedDate |
Label | Last Referenced Date |
Type | DATETIME |
Name | AQB__Education__c |
Label | Education |
Type | MASTER-DETAIL |
Foreign key | Yes |
Required | Yes |
Name | AQB__AreaOfStudy__c |
Label | Area of Study |
Type | LOOKUP |
Foreign key | Yes |
Name | AQB__ConcentrationLevel__c |
Label | Concentration Level |
Type | PICKLIST |
Picklist values | Major |
Name | AQB__Contact__c |
Label | Contact |
Type | LOOKUP |
Foreign key | Yes |
Help Text | The contact that has this area of study. |
Description | The contact that has this area of study. |
Name | AQB__DegreeIncludesThisConcentration__c |
Label | Degree Includes this Concentration? |
Type | CHECKBOX |
Required | Yes |
Default value | false |
Name | AQB__EndYear__c |
Label | End Year |
Type | TEXT(4) |
Name | AQB__Institution__c |
Label | LL- Institution |
Type | LOOKUP |
Foreign key | Yes |
Help Text | The school or institution associated with this Area of Study. |
Description | The school or institution associated with this Area of Study. |
Name | AQB__PrimaryAreaOfStudy__c |
Label | Primary Area of Study |
Type | CHECKBOX |
Required | Yes |
Default value | false |
Name | AQB__StartYear__c |
Label | Start Year |
Type | TEXT(4) |
Name | aqcv_conversionid__c |
Label | aqcv conversionid |
Type | TEXT(255) |
Unique | Yes |
Description | Unique id |
Name | usyd_student_pathway_code__c |
Label | USYD student pathway code |
Type | TEXT(60) |
Description | student code plus pathway code to uniquely identify pathway records while upserting data. |
Name | code__c |
Label | code |
Type | FORMULA (TEXT)(1300) |
Name | SITS_award_code__c |
Label | SITS award code |
Type | FORMULA (TEXT)(1300) |
Name | Advance_ID__c |
Label | Advance ID |
Type | FORMULA (TEXT)(1300) |
Name | Flag__c |
Label | Flag |
Type | TEXT(2) |
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. |
Name | Usyd_Comments__c |
Label | Comments |
Type | TEXT(120) |
Help Text | Comments to keep notes |
Description | Comments to keep notes |