Performance goals report - which should iclude all stages of goal details (Approved,Saved,Sumitted)

Summary

Need to develop a BI report for the Goal Plan Goals which are in saved state and submitted state and approved state.

Content

When employee runs the report , the report need to get the all details of goals which are there in goal plan.

Report should consider below three cases of goals which are SAVED ,SUBMITTED and APPROVED goals data.

1.Report need to get newly added goals data
2.Report need to get approved goals data
    if approved goals are updated ,  then we need to populate Updated/Changed values in same f row only.

while parsing the data_cache column of hrc_txn_data  table for the newly added goals and updated goals data ,