/
Validation rule: Status_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: Status_Check

Owned by praveen.sampath
Aug 16, 2024
1 min read

Validation rule Details

Name

Status_Check

Label

Status_Check

Object

AQB__Employment__c

Active

Yes

Formula

AND(AQB__EndDate__c <= TODAY() , ISPICKVAL(AQB__Status__c, "Current") )

Error message

The Status cannot be "Current" if the End Date occurs in the past.

Error location

Status

Related content

Validation rule: Part_time_end_date
Validation rule: Part_time_end_date
TAP - Advancement Portfolio Product
More like this
Validation rule: Primary_Employment_Status_EndDate_Check
Validation rule: Primary_Employment_Status_EndDate_Check
TAP - Advancement Portfolio Product
More like this
Validation rule: EndDateAfterStartDate
Validation rule: EndDateAfterStartDate
TAP - Advancement Portfolio Product
More like this
Validation rule: Consult_OutcomeDate_Allowed_Values
Validation rule: Consult_OutcomeDate_Allowed_Values
TAP - Advancement Portfolio Product
More like this
Validation rule: Date_Check
Validation rule: Date_Check
TAP - Advancement Portfolio Product
More like this
Validation rule: ValidateInProgressDate
Validation rule: ValidateInProgressDate
TAP - Advancement Portfolio Product
More like this