Public Interface Export Function › Planning Objects › Planning Tasks › CURRENT_EFFECT (Current System/Data Effect) › Task

Task

Select the current effects for each current information system.

SELECT I.NAME, E.CREATE, E.READ, E.UPDT, E.DLET, D.NAME
  FROM
  MODEL M,
  CURRENT_DATA D,
  CURRENT_INFO_SYS I,
  CURRENT_EFFECT E
  WHERE
  M.NAME = 'my model name'
  AND E.MODEL_ID = M.ID
  AND E.CUR_DATA_ID = D.ID
  AND E.CUR_INFO_SYS_ID = I.ID;