3 SQL Query to pull data from DATA_CACHE field on HRC_TXN_DATA for Transfer status:.2 SQL Query to find Pending transaction for Assignment Changes:.1 SQL Query to find out the pending approval transactions for an employee:.
identificationkey should be mapped with the transaction id of HRC_TXN_HEADER.įA_FUSION_SOAINFRA.WFTASKHISTORY – This is the Workflow task history table.įA_FUSION_SOAINFRA.WFTASK_VIEW - filter on WFTASK where STATE IS NULL OR STATE IN (‘ERRORED’, ‘STALE’, ‘WITHDRAWN’, ‘EXPIRED’)įA_FUSION_SOAINFRA.WFTASKHISTORY_VIEW – history (join on TASKNUMBER)įA_FUSION_SOAINFRA.WFTASKTL_VIEW – title (join on TASKID)įA_FUSION_SOAINFRA.WFCOMMENTS_VIEW – comments (join on TASKID)įA_FUSION_SOAINFRA.WFATTACHMENT_VIEW – attachments (join on TASKID)įA_FUSION_SOAINFRA.WFASSIGNEE_VIEW – assignee (join on TASKID) HRC_TXN_ERROR – Any transaction related errors are stored in this tableįA_FUSION_SOAINFRA.WFTASK – This is the Workflow task table and stores the information of Created by, Assignee, Created Date, End Date, Last Updated Date, etc. DATA_CACHE field stores the actual details of transaction in xml format. HRX_TXN_DATA – Detail table which stores details of transaction for the transaction id. HRC_TXN_HEADER – Header table with details of transaction id.
0 kommentar(er)
