Operation Details |
Description: | Counts how many Active Screening configuration links exist outside the specified dates for a Screening Configuration. |
Sterotype: | ns |
SQL |
SELECT COUNT(*) INTO :count FROM ScreeningAssessmentConfig WHERE screeningConfigID = :screeningConfigID AND recordStatus = :recordStatus AND ( startDate < :startDate OR endDate > :endDate ) |