yki
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
evaluation_period_open(id bigint, at_point_in_time timestamp with time zone DEFAULT now())
Parameters
Name
Type
Mode
id
bigint
IN
at_point_in_time
timestamp with time zone
IN
Definition
BEGIN RETURN QUERY SELECT EXISTS ( SELECT eva.id FROM evaluation eva WHERE eva.id = evaluation_period_open.id AND within_dt_range(at_point_in_time, eva.evaluation_start_date, eva.evaluation_end_date) ) as exists; END;