The two applications involved in my data feed are:
Control Standards Application: which is a repository of all control standards
On Demand Application(ODA): this application captures the requests and related information.
On the basis of the policy type requested and risk ratings available in the ODA application, the controls from the control standard application should be fetched using the data feed and populated in the control standard reference field created in the ODA application.
In the control standard application, we have policy type field available for each control record. So if the policy type field selected in the ODA application is "Test", all the control standard records with policy type "test" should be fetched from control standards and populated in ODA
Another criteria to be met is , based on the risk ratings of the ODA( say the rating is "High"), feed should fetch all the controls which are must to be used in case of high risk rating. the problem is , there are three separate values created to capture if the control is "Must/Should" when the risk rating is high/medium/low.
Control-High : Must/Should
Control-Low : Must/Should
For a particular control record, if the values for the above 3 fields are as given below, then that means if the risk rating for the ODA is "High" then this control record should get populated because control-high is "Must"
Due to complexity as given above, I am not able to map and decide upon the key fields. Report is created in Control standard application.