/
Validation rule: Primary_Employment_Status_EndDate_Check

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

Validation rule: Primary_Employment_Status_EndDate_Check

Validation rule Details

Name

Primary_Employment_Status_EndDate_Check

Label

Primary_Employment_Status_EndDate_Check

Object

AQB__Employment__c

Active

Yes

Formula

AND(AQB__SetAsPrimary__c = TRUE,
OR(ISNEW(), ISCHANGED(AQB__SetAsPrimary__c)),
OR( AQB__EndDate__c <= TODAY(), ISPICKVAL(AQB__Status__c,'No longer at this position') ))

Error message

You cannot set this record as the Primary Employment for the Contact if the End Date occurs in the past or if the Status is 'No Longer at this position'.

Error location

Top of Page

Description

Cannot set record to Primary if the End Date occurs in the past or if the Status = No Longer at this position.

Related content

Validation rule: Part_time_end_date
Validation rule: Part_time_end_date
More like this
Validation rule: Status_Check
Validation rule: Status_Check
More like this
Validation rule: EndDateAfterStartDate
Validation rule: EndDateAfterStartDate
More like this
Validation rule: Consult_OutcomeDate_Update_Restriction
Validation rule: Consult_OutcomeDate_Update_Restriction
More like this
Validation rule: Consult_DueDate_Restriction
Validation rule: Consult_DueDate_Restriction
More like this