Re: insert data with invalid input syntax for integer:"42P01"

your trigger is defined to call cidr_staging.trigger_fct_tr_stg_adjudicative_status_ins, the error is report from
there,but you give a definition for cidr_staging.trigger_fct_tr_stg_adjudicative_status_in, is that a copy/paste error,
orhave you actually posted the definition of a different procedure than the one in question? 

> even I take the "E" values out the error is still occurred but if I dropped the function and trigger, the insert is
fine

One more time: ***WHY*** are doing that?