Peoplesoft AWE Workflow configuration and setup tables. Ver 9.0
User the following scripts to move the AWE configuration / setup data from
the one instance to another instance.
Note :- add where clause if you need to move only configuration specific to
particular AWE transactions.
Export
script
-- "Register Transaction"
EXPORT PS_PTAFAW_TXN;
EXPORT PS_PTAFAW_TXN_LNG;
EXPORT PS_PTAFAW_TXN_LBL;
EXPORT PS_PTAFAW_TXN_LVL;
-- "Approvals > Workflow Transaction "
EXPORT EO_TRANSACTIONS;
EXPORT EO_TRANS_LNG;
-- "Configure Transactions"
EXPORT PS_PTAFAW_NOTIFY;
EXPORT PS_PTAFAW_NOT_USER;
EXPORT PS_PTAFAW_TXN_CFG;
-- "Setup Process Definitions"
EXPORT PS_PTAFAW_PATH;
EXPORT PS_PTAFAW_PATH_LNG;
EXPORT PS_PTAFAW_PRCS;
EXPORT PS_PTAFAW_PRCS_LNG;
EXPORT PS_PTAFAW_STAGE;
EXPORT PS_PTAFAW_STG_LNG;
EXPORT PS_PTAFAW_STEP;
EXPORT PS_PTAFAW_STEP_LNG;
-- "Criteria Definitions"
EXPORT PS_PTAFCRTA;
EXPORT PS_PTAFCRTA_REC;
EXPORT PS_PTAFCRTA_VAL;
-- "Maintain User Lists"
EXPORT PS_PTAFUSER_LIST;
EXPORT PS_PTAFUSER_LNG;
-- "Generic Templates"
EXPORT PS_WL_TEMPLATE_GEN;
EXPORT PS_WL_TEMPL_GEN_TK;
EXPORT PS_WL_TEMPL_GEN_RS
