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__Names__c
- praveen.sampath
Analytics
Fields
Name | Label | Type | Description |
|---|---|---|---|
Id | Record ID | ID |
|
OwnerId | Owner ID | LOOKUP |
|
IsDeleted | Deleted | CHECKBOX |
|
Name | Name 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 |
|
LastViewedDate | Last Viewed Date | DATETIME |
|
LastReferencedDate | Last Referenced Date | DATETIME |
|
AQB__Comments__c | Comments | TEXT AREA(255) |
|
AQB__ContactId__c | Contact | LOOKUP | The contact for this Name. |
AQB__FirstName__c | First Name | TEXT(40) | The first name may be 40 characters. |
AQB__FullName__c | Full Name | TEXT(255) | The full name of the Contact, including Salutation, First, Middle, Last and Suffix. May be 80 characters. |
AQB__GreetingOverride__c | Greeting Override | TEXT(200) |
|
AQB__Greeting__c | Greeting | TEXT(200) |
|
AQB__LastName__c | Last Name | TEXT(50) |
|
AQB__MiddleName__c | Middle Name | TEXT(40) | The middle name may be 40 characters. |
AQB__NameGroupingOverride__c | Name Grouping Override | TEXT(200) |
|
AQB__NameGrouping__c | Name Grouping | TEXT(200) |
|
AQB__NameOverride__c | Name Override | TEXT(200) | For use with defined named |
AQB__NameType__c | Name Type | LOOKUP |
|
AQB__Name__c | Name | TEXT(200) |
|
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__SalutationLookupOverride__c | Salutation Lookup Override | TEXT(40) |
|
AQB__SalutationLookup__c | Salutation Lookup | FORMULA (TEXT)(1300) |
|
AQB__Salutation__c | Greeting Salutation | TEXT(200) | The form of this name that would be used in the salutation portion of a letter. This may be formal or informal, in accordance with the preference at your institution. |
AQB__Source__c | Source | TEXT(100) |
|
AQB__Suffix__c | Suffix | PICKLIST | The suffix associated with this Name and Contact. |
AQB__Title__c | Salutation | PICKLIST | The title associated with this Name and Contact. |
AQB__Type__c | Type | PICKLIST | A classification of the Name in this record, e.g. Maiden, Stage, Nickname. |
AQB__UseAsAlternateName__c | Use As Alternate Name | CHECKBOX |
|
AQB__UseAsCommunityName__c | Use As Community Name | CHECKBOX |
|
AQB__UseAsFormalName__c | Use As Formal Name | CHECKBOX |
|
AQB__UseAsPreferredName__c | Use As Preferred Name | CHECKBOX |
|
AQB__Uses__c | Uses | FORMULA (TEXT)(1300) |
|
aqcv_conversionid__c | aqcv conversionid | TEXT(255) | Unique id |
AQB__ProfessionalSuffix__c | Professional Suffix | TEXT(40) |
|
Triggers
Name | Label |
|---|---|
Names | AQB.Names |
NamesUpsert | AQB.NamesUpsert |
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 | Name 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 | LastViewedDate |
Label | Last Viewed Date |
Type | DATETIME |
Name | LastReferencedDate |
Label | Last Referenced Date |
Type | DATETIME |
Name | AQB__Comments__c |
Label | Comments |
Type | TEXT AREA(255) |
Help Text | Comments regarding this name. |
Name | AQB__ContactId__c |
Label | Contact |
Type | LOOKUP |
Foreign key | Yes |
Help Text | The contact for this Name. |
Description | The contact for this Name. |
Name | AQB__FirstName__c |
Label | First Name |
Type | TEXT(40) |
Help Text | The first name may be 40 characters. |
Description | The first name may be 40 characters. |
Name | AQB__FullName__c |
Label | Full Name |
Type | TEXT(255) |
Help Text | The full name of the Contact, including Salutation, First, Middle, Last and Suffix. May be 80 characters. |
Description | The full name of the Contact, including Salutation, First, Middle, Last and Suffix. May be 80 characters. |
Name | AQB__GreetingOverride__c |
Label | Greeting Override |
Type | TEXT(200) |
Help Text | The Greeting to be used to override the standard Greeting for this Contact. |
Name | AQB__Greeting__c |
Label | Greeting |
Type | TEXT(200) |
Help Text | The Greeting to be used with this Name. |
Name | AQB__LastName__c |
Label | Last Name |
Type | TEXT(50) |
Name | AQB__MiddleName__c |
Label | Middle Name |
Type | TEXT(40) |
Help Text | The middle name may be 40 characters. |
Description | The middle name may be 40 characters. |
Name | AQB__NameGroupingOverride__c |
Label | Name Grouping Override |
Type | TEXT(200) |
Help Text | The text in this field will override the defined named grouping. |
Name | AQB__NameGrouping__c |
Label | Name Grouping |
Type | TEXT(200) |
Help Text | The Name Grouping to be used to sort this name. |
Name | AQB__NameOverride__c |
Label | Name Override |
Type | TEXT(200) |
Help Text | A manually entered name which will override the name formula for this type of name. |
Description | For use with defined named |
Name | AQB__NameType__c |
Label | Name Type |
Type | LOOKUP |
Foreign key | Yes |
Help Text | Indicates the Name Definition for this name which is used to format the name. |
Name | AQB__Name__c |
Label | Name |
Type | TEXT(200) |
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__SalutationLookupOverride__c |
Label | Salutation Lookup Override |
Type | TEXT(40) |
Help Text | The Salutation to be used to override the standard Salutation in an Address for this Contact. |
Name | AQB__SalutationLookup__c |
Label | Salutation Lookup |
Type | FORMULA (TEXT)(1300) |
Help Text | The Salutation to be used in an Address for this Contact. |
Name | AQB__Salutation__c |
Label | Greeting Salutation |
Type | TEXT(200) |
Help Text | The form of this name that would be used in the salutation portion of a letter. This may be formal or informal, in accordance with the preference at your institution. Forty characters. |
Description | The form of this name that would be used in the salutation portion of a letter. This may be formal or informal, in accordance with the preference at your institution. |
Name | AQB__Source__c |
Label | Source |
Type | TEXT(100) |
Name | AQB__Suffix__c |
Label | Suffix |
Type | PICKLIST |
Help Text | The suffix associated with this Name and Contact. |
Picklist values | Jr. |
Description | The suffix associated with this Name and Contact. |
Name | AQB__Title__c |
Label | Salutation |
Type | PICKLIST |
Help Text | The title associated with this Name and Contact. |
Picklist values | Mr. |
Description | The title associated with this Name and Contact. |
Name | AQB__Type__c |
Label | Type |
Type | PICKLIST |
Help Text | A classification of the Name in this record, e.g. Maiden, Stage, Nickname. |
Picklist values | Also Known As |
Description | A classification of the Name in this record, e.g. Maiden, Stage, Nickname. |
Name | AQB__UseAsAlternateName__c |
Label | Use As Alternate Name |
Type | CHECKBOX |
Required | Yes |
Help Text | Indicates that this name should be utilized as the "Alternate" name for the contact. |
Default value | false |
Name | AQB__UseAsCommunityName__c |
Label | Use As Community Name |
Type | CHECKBOX |
Required | Yes |
Help Text | Indicates that this name should be utilized as the "Community" name for the contact. |
Default value | false |
Name | AQB__UseAsFormalName__c |
Label | Use As Formal Name |
Type | CHECKBOX |
Required | Yes |
Help Text | Indicates that this name should be utilized as the "Formal" name for the contact. |
Default value | false |
Name | AQB__UseAsPreferredName__c |
Label | Use As Preferred Name |
Type | CHECKBOX |
Required | Yes |
Help Text | Indicates that this name should be utilized as the "Preferred" name for the contact. |
Default value | false |
Name | AQB__Uses__c |
Label | Uses |
Type | FORMULA (TEXT)(1300) |
Help Text | Indicates if this name is used as any of the four Contact names. |
Name | aqcv_conversionid__c |
Label | aqcv conversionid |
Type | TEXT(255) |
Unique | Yes |
Description | Unique id |
Name | AQB__ProfessionalSuffix__c |
Label | Professional Suffix |
Type | TEXT(40) |