1. Tables and Views for Sales, Fusion Service, and Field Service
  2. FFS_QTS_QUOTA_WZ_LOG

FFS_QTS_QUOTA_WZ_LOG

Stores a modification history for the corresponding parent table.

Details

  • Schema: FUSION

  • Object owner: FFS

  • Object type: TABLE

  • Tablespace: DATA

Primary Key

Name Columns

FFS_QTS_QUOTA_WZ_LOG_PK

QUOTA_LOG_ID

Columns

Name Datatype Length Precision Not-null Comments
QUOTA_LOG_ID NUMBER 10 Yes ID that is used as primary key of this table.
ACTION_ID NUMBER 19 Yes Unique identifier of the action.
ACTION_TIME TIMESTAMP Yes Who Column: Time in GMT when action was performed.
USER_ID NUMBER 18 Yes Who Column: Identifies user the operation is performed by. Zero value means internal application task. Foreign Key. Points to USER_ID in FFS_USER.
PAGE_ID NUMBER 10 Yes Foreign Key. Points to PAGE_ID in FFS_QTS_QUOTA_PAGE.
TIME_SLOT_ID NUMBER 5 Yes Foreign Key. Points to TIME_SLOT_ID in FFS_TIME_SLOT.
CATEGORY_ID NUMBER 5 Yes Foreign Key. Points to WORK_SKILL_ID in FFS_WORK_SKILL.
WORK_ZONE_ID NUMBER 8 Yes Foreign Key. Points to WORK_ZONE_ID in FFS_WORK_ZONE.
OLD_OPTIONS NUMBER 3 Yes Old value of bitmask that defines status of quota record.
NEW_OPTIONS NUMBER 3 Yes New value of bitmask that defines status of quota record.
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.

Indexes

Index Uniqueness Tablespace Columns
FFS_QTS_QUOTA_WZ_LOG_N1 Non Unique DATA PAGE_ID
FFS_QTS_QUOTA_WZ_LOG_PK Unique DATA QUOTA_LOG_ID