DW_GOAL_TASK_D

Provides the details on the Goal Tasks (also called Actions)

Details

Module: Goal Management

Key Columns

GOAL_ACTION_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
GOAL_ACTION_ID NUMBER 38 0 True Goal action Identifier
SOURCE_RECORD_ID VARCHAR2 512 This column is for Oracle Internal use only. Source Record Identifier:It is Goal action Identifier
BUSINESS_GROUP_ID NUMBER 38 0 Business Group Identifier
GOAL_ID NUMBER 38 0 Goal Identifier DW_GOAL_F GOAL_ID
ACTION_TYPE_CODE VARCHAR2 32 Type of Action DW_GOAL_ACTION_TYPE_D_TL ACTION_TYPE_CODE
PRIORITY_CODE VARCHAR2 32 Priortiy of Action DW_GOAL_PRIORITY_D_TL PRIORITY_CODE
START_DATE DATE Start Date
TARGET_COMPLETION_DATE DATE Target Completion Date
PERCENT_COMPLETE_CODE VARCHAR2 32 Percentage complete code
STATUS_CODE VARCHAR2 32 Status of the task DW_GOAL_TASK_STATUS_D_TL STATUS_CODE
ACTION_NAME VARCHAR2 256 Action/Task Name