pears.ConsentHidePerson

Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.

CREATE FUNCTION "pears"."ConsentHidePerson"( 
  IN "PersID" CHAR(20),IN "Source" CHAR(4) ) 
RETURNS SMALLINT
BEGIN
  --  return 1 to hide 0 to show		
  --  use	userstaffid + role to decide if DPC	
  --  Source - PSEL = person selector, VRES = vacancy search result, CEVE contact event (to hide details and disable new contact)		
  --  Source - TTEM tempdesk temps entire pool, VSLI = vacancy shortlist, TEXP tempdesk expiry dates all options 
  RETURN 0
END
  • database/functions/pears_consenthideperson.txt
  • Last modified: 2026/08/07 19:24
  • by 127.0.0.1