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    

Copyright © 2019, 2024, Oracle and/or its affiliates.