====== pears.ConsentHidePerson ======
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
===== Original SQL =====
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
}