Provides the details on the Goal Tasks (also called Actions)
Module: Goal Management
GOAL_ACTION_ID
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 | 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, 2023, Oracle and/or its affiliates.