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__Employment__c
- praveen.sampath
Analytics
Fields
Name | Label | Type | Description |
|---|---|---|---|
Id | Record ID | ID |
|
OwnerId | Owner ID | LOOKUP |
|
IsDeleted | Deleted | CHECKBOX |
|
Name | Employment | AUTO NUMBER |
|
RecordTypeId | Record Type ID | LOOKUP |
|
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__Assistant_s_Email__c | Assistant's Email |
| |
AQB__Assistant_s_Name__c | Assistant's Name | TEXT(50) |
|
AQB__Assistant_s_Phone__c | Assistant's Phone | PHONE |
|
AQB__BusinessPhone__c | Business Phone | PHONE | The phone number at the Contact's business location. |
AQB__ContactId__c | Contact | LOOKUP | The contact for this Employment. |
AQB__Corporate_Phone__c | Corporate Phone | PHONE |
|
AQB__DoNotArchive__c | Do Not Archive | CHECKBOX | Indicates that the phone and/or email should not be archived. |
AQB__Earnings__c | Earnings | PICKLIST | The approximate earnings associated with this Employment record. |
AQB__EmployerNameDisplay__c | Employer Name | FORMULA (TEXT)(1300) |
|
AQB__EmployerName__c | Non-linked Employer Name | TEXT(255) | The name of the Employer for this Employment record. |
AQB__EmploymentComment__c | Comment | TEXT AREA (LONG)(32768) |
|
AQB__EmploymentExternalID__c | Employment External ID | TEXT(20) |
|
AQB__EndDate__c | End Date | DATE | The date on which this Employment ended. |
AQB__Ended__c | Ended | PICKLIST | Indicates whether the End Date is precise or only known to have been on or prior to the End Date. |
AQB__Fax_Number__c | Fax Number | PHONE |
|
AQB__Industry__c | Industry | PICKLIST |
|
AQB__IsPrimaryEmployer__c | Is Primary Employer | FORMULA (TEXT)(1300) |
|
AQB__Level__c | Level | PICKLIST | Describes the level of the Contact's position in a standardized list. |
AQB__LinkedAddress__c | Linked Address | LOOKUP |
|
AQB__LinkedEmployer__c | Linked Employer | LOOKUP | The name of the Employer. Linked indicates that the Employer also has an Account record in the system. |
AQB__Occupation__c | Occupation | PICKLIST | A description of the nature of the work that the Contact does for the Employer. |
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__PrimaryEmployment__c | Deprecated Primary Employment | CHECKBOX |
|
AQB__Source__c | Source | TEXT(100) |
|
AQB__StartDate__c | Start Date | DATE | The date on which this Employment began. |
AQB__Started__c | Started | PICKLIST | Indicates whether the Start Date is precise or only known to have been on or prior to the Start Date. |
AQB__Status__c | Status | PICKLIST | Indicates whether this Employment is current, no longer at the position, or retired. The values of "Current", "Part Time", and "Retired" are used specifically to determine whether companies in the HEP database will match gifts to your organization. These values are specific to HEP so any changes to this list could result in the lost of this functionality. |
AQB__Title__c | Title | TEXT(100) | The Contact's exact job title. |
aqcv_conversionid__c | aqcv conversionid | TEXT(255) | Unique id |
AQB__SetAsPrimary__c | Set as Primary | CHECKBOX | When checked during data entry, the record is automatically set as the Primary Employment record for the Contact. The system will automatically uncheck the flag when the record is removed as the Primary Employment. Do not use this field in reporting. |
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_Global_Industry__c | Industry | PICKLIST |
|
Validation rules
Name | Label |
|---|---|
EndDateAfterStartDate | EndDateAfterStartDate |
Industry | Industry |
No_Business_Phone_Change | No_Business_Phone_Change |
Part_time_end_date | Part_time_end_date |
Status_Check | Status_Check |
Blank_Phone_On_Primary_Employment | Blank_Phone_On_Primary_Employment |
Primary_Employment_Status_EndDate_Check | Primary_Employment_Status_EndDate_Check |
Triggers
Name | Label |
|---|---|
EmploymentDeleteBefore | AQB.EmploymentDeleteBefore |
EmploymentInsertAfter | AQB.EmploymentInsertAfter |
EmploymentInsertBefore | AQB.EmploymentInsertBefore |
EmploymentUpdateBefore | AQB.EmploymentUpdateBefore |
EmploymentUpsertAfter | AQB.EmploymentUpsertAfter |
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 | Employment |
Type | AUTO NUMBER |
Required | Yes |
Name | RecordTypeId |
Label | Record Type ID |
Type | LOOKUP |
Foreign key | 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__Assistant_s_Email__c |
Label | Assistant's Email |
Type | |
Help Text | Email for Assistant for this employment. |
Name | AQB__Assistant_s_Name__c |
Label | Assistant's Name |
Type | TEXT(50) |
Help Text | Name of Assistant for this employment. |
Name | AQB__Assistant_s_Phone__c |
Label | Assistant's Phone |
Type | PHONE |
Help Text | Phone number of Assistant. |
Name | AQB__BusinessPhone__c |
Label | Business Phone |
Type | PHONE |
Help Text | The direct phone number at the Contact's business location. |
Description | The phone number at the Contact's business location. |
Name | AQB__ContactId__c |
Label | Contact |
Type | LOOKUP |
Foreign key | Yes |
Help Text | The contact for this Key Contact. |
Description | The contact for this Employment. |
Name | AQB__Corporate_Phone__c |
Label | Corporate Phone |
Type | PHONE |
Help Text | The main phone number for this corporation. |
Name | AQB__DoNotArchive__c |
Label | Do Not Archive |
Type | CHECKBOX |
Required | Yes |
Help Text | Indicates that the address, phone and/or email should not be archived. |
Default value | false |
Description | Indicates that the phone and/or email should not be archived. |
Name | AQB__Earnings__c |
Label | Earnings |
Type | PICKLIST |
Help Text | The approximate earnings associated with this Employment record. |
Picklist values | Unknown |
Description | The approximate earnings associated with this Employment record. |
Name | AQB__EmployerNameDisplay__c |
Label | Employer Name |
Type | FORMULA (TEXT)(1300) |
Help Text | Displays the employer name for both Linked and Non-Linked Employers. |
Name | AQB__EmployerName__c |
Label | Non-linked Employer Name |
Type | TEXT(255) |
Help Text | The name of the Employer for this Employment record. |
Description | The name of the Employer for this Employment record. |
Name | AQB__EmploymentComment__c |
Label | Comment |
Type | TEXT AREA (LONG)(32768) |
Help Text | Additional information about this employment. |
Name | AQB__EmploymentExternalID__c |
Label | Employment External ID |
Type | TEXT(20) |
Unique | Yes |
Name | AQB__EndDate__c |
Label | End Date |
Type | DATE |
Help Text | The date on which this Employment ended. |
Description | The date on which this Employment ended. |
Name | AQB__Ended__c |
Label | Ended |
Type | PICKLIST |
Help Text | Indicates whether the End Date is precise or only known to have been on or prior to the End Date. |
Picklist values | On |
Description | Indicates whether the End Date is precise or only known to have been on or prior to the End Date. |
Name | AQB__Fax_Number__c |
Label | Fax Number |
Type | PHONE |
Help Text | The fax phone number for this contact at this employer. |
Name | AQB__Industry__c |
Label | Industry |
Type | PICKLIST |
Help Text | The type of business represented by this employer. |
Picklist values | Agriculture, Forestry and Fishing |
Name | AQB__IsPrimaryEmployer__c |
Label | Is Primary Employer |
Type | FORMULA (TEXT)(1300) |
Help Text | Indicates that this Employment record is the Primary Employment record. |
Name | AQB__Level__c |
Label | Level |
Type | PICKLIST |
Help Text | Describes the level of the Contact's position in a standardized list. |
Picklist values | Executive Management |
Description | Describes the level of the Contact's position in a standardized list. |
Name | AQB__LinkedAddress__c |
Label | Linked Address |
Type | LOOKUP |
Foreign key | Yes |
Name | AQB__LinkedEmployer__c |
Label | Linked Employer |
Type | LOOKUP |
Foreign key | Yes |
Help Text | The name of the Employer. Linked indicates that the Employer also has an Account record in the system. |
Description | The name of the Employer. Linked indicates that the Employer also has an Account record in the system. |
Name | AQB__Occupation__c |
Label | Occupation |
Type | PICKLIST |
Help Text | A description of the nature of the work that the Contact does for the Employer. |
Picklist values | Accounting and finance |
Description | A description of the nature of the work that the Contact does for the Employer. |
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__PrimaryEmployment__c |
Label | Deprecated Primary Employment |
Type | CHECKBOX |
Required | Yes |
Default value | false |
Name | AQB__Source__c |
Label | Source |
Type | TEXT(100) |
Name | AQB__StartDate__c |
Label | Start Date |
Type | DATE |
Help Text | The date on which this Employment began. |
Description | The date on which this Employment began. |
Name | AQB__Started__c |
Label | Started |
Type | PICKLIST |
Help Text | Indicates whether the Start Date is precise or only known to have been on or prior to the Start Date. |
Picklist values | On |
Description | Indicates whether the Start Date is precise or only known to have been on or prior to the Start Date. |
Name | AQB__Status__c |
Label | Status |
Type | PICKLIST |
Help Text | Indicates whether this Employment is current, no longer at the position, or retired. The values are used to determine whether companies in the Double the Donation database will match gifts to your organization. |
Picklist values | Current |
Description | Indicates whether this Employment is current, no longer at the position, or retired. The values of "Current", "Part Time", and "Retired" are used specifically to determine whether companies in the HEP database will match gifts to your organization. These values are specific to HEP so any changes to this list could result in the lost of this functionality. |
Name | AQB__Title__c |
Label | Title |
Type | TEXT(100) |
Help Text | The Contact's exact job title. |
Description | The Contact's exact job title. |
Name | aqcv_conversionid__c |
Label | aqcv conversionid |
Type | TEXT(255) |
Unique | Yes |
Description | Unique id |
Name | AQB__SetAsPrimary__c |
Label | Set as Primary |
Type | CHECKBOX |
Required | Yes |
Help Text | When checked during data entry, the record is automatically set as the Primary Employment record for the Contact. The system will automatically uncheck the flag when the record is removed as the Primary Employment. Do not use this field in reporting. |
Default value | false |
Description | When checked during data entry, the record is automatically set as the Primary Employment record for the Contact. The system will automatically uncheck the flag when the record is removed as the Primary Employment. Do not use this field in reporting. |
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_Global_Industry__c |
Label | Industry |
Type | PICKLIST |
Picklist values | Agriculture, Forestry and Fishing |