pears.ConsentHidePerson

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

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."ConsentHidePerson" IS 
{CREATE FUNCTION 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/procedures/pears_consenthideperson.txt
  • Last modified: 2026/08/07 19:24
  • by 127.0.0.1