Purge Staged Cost Template Data (wf_cost_template_purge_job)
Module Name |
wf_cost_template_purge_job |
Description |
Purge Staged Cost Template Data |
Functional Area |
Franchise Management |
Module Type |
Admin - Ad hoc |
Module Technology |
Background Processing |
Catalog ID |
N/A |
Wrapper Script |
b8dwrap.ksh |
Design Overview
This background job is composed of one step processing only. It will retain the business logic processing from original KSH script algorithm.
The Business logic program will remove all old/aged records from the staging tables used by the Cost Buildup Template Upload process which have passed the purge criteria from the system parameter setting, Foundation Staging Retention Days.
Key Tables Affected
Table 18-5 Key Tables Affected
Table | Select | Insert | Update | Delete |
---|---|---|---|---|
SVC_WF_COST_TMPL_UPLD_FHEAD |
No |
No |
No |
Yes |
SVC_WF_COST_TMPL_UPLD_THEAD |
No |
No |
No |
Yes |
SVC_WF_COST_TMPL_UPLD_TDETL |
No |
No |
No |
Yes |
SVC_WF_COST_TMPL_UPLD_TTAIL |
No |
No |
No |
Yes |
SVC_WF_COST_TMPL_UPLD_FTAIL |
No |
No |
No |
Yes |
SVC_WF_COST_TMPL_UPLD_STATUS |
No |
No |
No |
Yes |
SYSTEM_OPTIONS |
Yes |
No |
No |
No |