▪ActionplanID - ID # of the action plan to which the action belongs ▪ActionID - Action ID # ▪ActionTitle - Action title (What?) ▪CatID - Action category ID # ▪FgStatus - Action status •1 – Planning; •2 - Planning approval; •3 - To be started/In progress; •4 - Action verification; •5 - Finished; •6 – Cancelled. ▪FgTypeAction - Action execution type: 1 – Immediate; 2 – Planned ▪TeamID - Action team ID #. ▪RespID - User ID of the Responsible for execution (Who?) ▪DtPlanStart - Planning start date (When). ▪TmPlanStart - Planning start time (When?) ▪DtPlanEnd - Planning end date (When?). ▪TmPlanEnd - Planning end time (When?) ▪VlPlanCost - Planned cost (How much?) ▪DtExecStart - Execution start date (When?) ▪TmExecStart - Execution start time (When?) ▪DtExecEnd - Execution end date (When?) ▪TmExecEnd - Execution end time (When?) ▪VlPercent - Actual % ▪VlExecCost - Executed cost (How much?) ▪DsResult - Result ▪DsWhy - Why? ▪DsWhere - Where? ▪DsHow - How? |