If you are working on Time and Labor Template Built rule and if you happen to create a rule by mistake or realize
that you did not want the rule
to be in specific name and want to create a new one, there is no option
in PeopleSoft Time and Labor to delete the Rule that you just created
using the
Templates. The only way would be using the backend method.
Below are the Time and Labor Tables that you will use to delete the rule using a SQL Editor.
DELETE FROM PS_TL_TMPLT_RULE WHERE TL_RULE_ID = 'Rule Name';
DELETE FROM PS_TL_TMPLT_RULE2 WHERE TL_RULE_ID = 'Rule Name';
DELETE FROM PS_TL_RULE_TMPLT WHERE TL_RULE_ID = 'Rule Name';
DELETE FROM PS_TL_RULE_DEFN WHERE TL_RULE_ID = 'Rule Name';
DELETE FROM PS_TL_RULE_STEPS WHERE TL_RULE_ID = 'Rule Name';
Also, go to TL_TA_RULES Application Engine Program and delete the section of the template rule.
