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

FFS_QBI_FILL_SCHEDULE_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_QBI_FILL_SCHEDULE_LOG_PK

SCHEDULE_LOG_ID

Columns

Name Datatype Length Precision Not-null Comments
SCHEDULE_LOG_ID NUMBER 10 Yes Primary Key. Unique identifies log record of automatic populate schedule changes.
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.
AREA_ID NUMBER 8 Yes Foreign Key. Points to AREA_ID in FFS_QBI_CAPACITY_AREA.
CATEGORY_ID NUMBER 5 Yes Foreign Key. Points to WORK_SKILL_ID in FFS_WORK_SKILL.
FIELD_ID NUMBER 3 Yes Field identifier that was updated.
ACTION VARCHAR2 6 Action description that was performed.
OLD_STATUS VARCHAR2 8 Old value of status of this record that controls if the corresponding action is performed automatically.
NEW_STATUS VARCHAR2 8 New value of status of this record that controls if the corresponding action is performed automatically.
OLD_OPERATION VARCHAR2 24 Old value of an operation that should be performed.
NEW_OPERATION VARCHAR2 24 New value of an operation that should be performed.
OLD_SOURCE_FIELD_ID NUMBER 3 Old source field that should be updated.
NEW_SOURCE_FIELD_ID NUMBER 3 New source field that should be updated.
OLD_SOURCE_OFFSET NUMBER 7 Old source day offset that should be updated.
NEW_SOURCE_OFFSET NUMBER 7 New source day offset that should be updated.
OLD_SOURCE_COUNT NUMBER 7 Old value of a number of days/weeks that should be used as a source of data.
NEW_SOURCE_COUNT NUMBER 7 New value of a number of days/weeks that should be used as a source of data.
OLD_TARGET_OFFSET NUMBER 3 Old source target offset that should be updated.
NEW_TARGET_OFFSET NUMBER 3 New source target offset that should be updated.
OLD_TARGET_COUNT NUMBER 7 Old value of a number of days/weeks that should be populated.
NEW_TARGET_COUNT NUMBER 7 New value of a number of days/weeks that should be populated.
OLD_MULTIPLY_BY NUMBER 5 Old value of a percent value for the percent_shift operation.
NEW_MULTIPLY_BY NUMBER 5 New value of a percent value for the percent_shift operation.
OLD_RECURRENCE VARCHAR2 6 Old value that defines when this operation should be performed automatically.
NEW_RECURRENCE VARCHAR2 6 New value that defines when this operation should be performed automatically.
OLD_DAY_OF_WEEK NUMBER 3 Old value of schedule day of week.
NEW_DAY_OF_WEEK NUMBER 3 New value of schedule day of week.
OLD_START_TIME NUMBER 5 Old time of day when this operation should be performed.
NEW_START_TIME NUMBER 5 Yes New time of day when this operation should be performed.
OLD_WITHIN NUMBER 5 Old value in minutes when schedule should be applied after start time.
NEW_WITHIN NUMBER 5 Yes New value in minutes when schedule should be applied after start time.
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_QBI_FILL_SCHEDULE_LOG_PK Unique DATA SCHEDULE_LOG_ID