Hey guys thnxs for all the help. I now have things working the way I'd hoped.

I think we're close although when trying to execute I got Ambiguous column name 'DEPTID'. and Ambiguous column name 'EFFDT' (noted change in bold).

Here was the statement:

CREATE TRIGGER PS_DEPT_TBL_TRG...