prevent absence re-submit when timecard submitted

Summary: We needed a way to prevent an absence from being submitted / re-submitted when the timecard associated with that absence was already submitted. We're still testing the finer details. But here it is. There is a fast formula and 2 value set queries.

Content (please ensure you mask any confidential information):

/*

Name:

ABS_ABSENCE_ENTRY_VALIDATE_HOURS1

Type:

Global Absence Entry Validation

*/

DEFAULT for IV_START_DATE is '4712/12/31 00:00:00' (date)

DEFAULT for IV_END_DATE is '4712/12/31 00:00:00' (date)

DEFAULT for IV_START_DURATION is 0

DEFAULT for IV_END_DURATION is 0

DEFAULT for IV_ATTRIBUTE_ARR is EMPTY_TEXT_NUMBER