Queries on Valid Date Time State Tables

Some tables in Ops have valid time state enable like the below example on hcmemployment table:

in order to find a valid record in this kind of table, a simple select statement is not what you have to use.

you have to provide the date range "from" and "to" to see is the record is exists in these date ranges or not.if it exists then its a valid record and if it does not exist then it's not a valid record irrespective of either record exists with other date ranges or not.

For more details, you can check the hcmworker.isEmployee method.

Thanks,
Zahid