ZCA_GOAL_ACTUALS

Details

Schema: FUSION
Object owner: ZCA
Object type: TABLE
Tablespace: Default

Primary Key

Name	Columns
zca_goal_actuals_PK	GOAL_ACTUAL_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
GOAL_ACTUAL_ID	NUMBER		18	Yes	Primary Key.
GOAL_ID	NUMBER		18		GOAL_ID
KPI_ID	NUMBER		18		KPI_ID
KPI_OBJECT	VARCHAR2	40			KPI_OBJECT
RESOURCE_ID	NUMBER		18		RESOURCE_ID
TARGET_START_DATE	TIMESTAMP				TARGET_START_DATE
TARGET_END_DATE	TIMESTAMP				TARGET_END_DATE
KPI_ACTUAL	NUMBER		18		KPI Actual. The calculated KPI Actual Value
X_ACTUAL	NUMBER		18		KPI Numerator Actual. The numerator value of the KPI Actual
Y_ACTUAL	NUMBER		18		KPI Denominator Actual. The denominator value of the KPI Actual
CUMULATIVE_TARGET	NUMBER		18		CUMULATIVE_TARGET
CUMULATIVE_ACTUAL	NUMBER		18		CUMULATIVE_ACTUAL
NO_OF_GOAL_PERIODS	NUMBER		18		NO_OF_GOAL_PERIODS
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
CONFLICT_ID	NUMBER		18	Yes	Disconnected Mobile: this value is used to guarantee the uniqueness of the row when duplicates are created in different databases (i.e. mobile databases or the server).

Indexes

Index	Uniqueness	Tablespace	Columns
zca_goal_actuals_U1	Unique	Default	GOAL_ACTUAL_ID
zca_goal_actuals_U2	Unique	Default	RESOURCE_ID, GOAL_ID, TARGET_START_DATE, TARGET_END_DATE