select count(*) as status_types_defined_p from recruiting_status_types where enabled_p = 't'; select count(*) as criteria_defined_p from recruiting_criteria where enabled_p = 't'; select count(*) as num_candidates from recruiting_candidates select count(*) as pending_interviews from recruiting_interviews i where (select count(*) from recruiting_ratings r where r.interview_id = i.interview_id) = 0 select count(*) as num_archived_candidates from archived_recruiting_candidates