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__AlternateID__c
- praveen.sampath
Analytics
Fields
Name | Label | Type | Description |
|---|---|---|---|
Id | Record ID | ID |
|
OwnerId | Owner ID | LOOKUP |
|
IsDeleted | Deleted | CHECKBOX |
|
Name | Alternate ID 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__AccountReferenced__c | Account Referenced | LOOKUP |
|
AQB__AlternateID__c | Unique Alternate ID | TEXT(40) |
|
AQB__ContactReferenced__c | Contact Referenced | LOOKUP |
|
AQB__NonuniqueAlternateId__c | Nonunique Alternate Id | TEXT(40) | The value of the nonunique Alternate ID being stored in this object. |
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__Type__c | Type | PICKLIST | Indicates the type of Alternate Id. |
AQCV_Conversionid__c | AQCV Conversionid | TEXT(255) | External Id |
USYD_Alternate_Channels__c | Alternate Channels | LOOKUP |
|
USYD_contactID__c | contactID | FORMULA (TEXT)(1300) |
|
Flag__c | Flag | TEXT(1) |
|
length_NonuniqueID__c | length_NonuniqueID | FORMULA (NUMBER)(16,2) |
|
Validation rules
Name | Label |
|---|---|
Imod_and_SS | Imod_and_SS |
Triggers
Name | Label |
|---|---|
AlternateIdTrigger | AQB.AlternateIdTrigger |
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 | Alternate ID 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__AccountReferenced__c |
Label | Account Referenced |
Type | LOOKUP |
Foreign key | Yes |
Help Text | The Account to which this Alternate ID references, if applicable. This field will be blank if the Alternate ID references a Contact. |
Name | AQB__AlternateID__c |
Label | Unique Alternate ID |
Type | TEXT(40) |
Unique | Yes |
Required | Yes |
Help Text | The value of the unique Alternate ID being stored in this object. |
Name | AQB__ContactReferenced__c |
Label | Contact Referenced |
Type | LOOKUP |
Foreign key | Yes |
Help Text | The Contact to which this Alternate ID references, if applicable. This field will be blank if the Alternate ID references an Account. |
Name | AQB__NonuniqueAlternateId__c |
Label | Nonunique Alternate Id |
Type | TEXT(40) |
Help Text | The value of the nonunique Alternate ID being stored in this object. |
Description | The value of the nonunique Alternate ID being stored in this object. |
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__Type__c |
Label | Type |
Type | PICKLIST |
Help Text | Indicates the type of Alternate Id. |
Picklist values | Australian Graduate School of Management ID |
Description | Indicates the type of Alternate Id. |
Name | AQCV_Conversionid__c |
Label | AQCV Conversionid |
Type | TEXT(255) |
Unique | Yes |
Description | External Id |
Name | USYD_Alternate_Channels__c |
Label | Alternate Channels |
Type | LOOKUP |
Foreign key | Yes |
Name | USYD_contactID__c |
Label | contactID |
Type | FORMULA (TEXT)(1300) |
Name | Flag__c |
Label | Flag |
Type | TEXT(1) |
Name | length_NonuniqueID__c |
Label | length_NonuniqueID |
Type | FORMULA (NUMBER)(16,2) |