It's specifically a non-Jewish woman; the male form is sheygetz. It's not a clinical or legal term: it's very definitely derogatory.