Peoplesoft AWE Workflow configuration DMS scripts

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