Primary Key and Constraints for

RFong at PSJH

Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of):

Providence St Joseph Health

Description (Required):

Can you provide primary keys for below tables?

FA_FUSION_SOAINFRA.WFTASK

FA_FUSION_SOAINFRA.WFASSIGNEE

FA_FUSION_SOAINFRA.WFCOMMENTS

FA_FUSION_SOAINFRA.WFATTACHMENT

FA_FUSION_SOAINFRA.WFTASKASSIGNMENTSTATISTIC

FA_FUSION_SOAINFRA.WFTASKHISTORY

FA_FUSION_SOAINFRA.WFMESSAGEATTRIBUTE

FA_FUSION_SOAINFRA.WFAPPROVALGROUPS

FA_FUSION_SOAINFRA.WFAPPROVALGROUPMEMBERS

FA_FUSION_SOAINFRA.WFCOLLECTIONTARGET

Use Case and Business Need (Required):

We have operational reports that require the collection of these tables. Some tables are large and requires Primary Keys and other constraints to create ETL efficiencies.

Enhancement Request / Service Request:

SR 3-30837503261 : Required help on FA_FUSION_SOAINFRA tables

RFong at PSJH

Will help users that require WF tables to query for analysis.

Karmveer

Hi Team,

Workflow tables are required for operations support and matrix, it would be great to consider this request as an ER to track for near future.

Regards

Karmveer