FFS_SERVICE_REQUEST_HIST

Used to store service request submit history.

Details

  • Schema: FUSION

  • Object owner: FFS

  • Object type: TABLE

  • Tablespace: DATA

Columns

Name Datatype Length Precision Not-null Comments
SERVICE_REQUEST_ID NUMBER 10 Yes ID of the related support request. Reference to the FFS_SERVICE_REQUEST -> SERVICE_REQUEST_ID.
ACTION_ID NUMBER 19 Yes ID of a parent action_log record.
ACTION_TIME TIMESTAMP Time of the service request action (Gmt).
OPERATION_TIME TIMESTAMP Time when this operation is performed by user (GMT).
TRANSACTION_ID NUMBER 19 Yes Sequential ID of transaction that defines an order of operations inside of the system.
INTERFACE NUMBER 3 Yes Interface the action is performed from.
SCREEN_ID NUMBER 10 Yes ID of the screen the action is performed from (reserved for a future use).
USER_ID NUMBER 18 ID of the user the operation is performed by.
USER_AGENT_ID NUMBER 8 Id of the user agent which was used by action.
OPERATION VARCHAR2 20 Identifier of the performed operation.
REQUEST_DATE DATE Date of the submit of the service request.
TYPE_ID NUMBER 10 Yes Submitted service request type ID.
RESOURCE_ID NUMBER 8 Link to the related resource ID - FFS_RESOURCE->RESOURCE_ID.
ACTIVITY_ID NUMBER 10 Link to the related activity ID - FFS_ACTIVITY->ACTIVITY_ID.
INVENTORY_ID NUMBER 10 Reference to the related inventory ID - FFS_INVENTORY->INVENTORY_ID.
NEW_VALUE CLOB New values of affected fields and properties.
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.
SERVICE_REQUEST_HIST_ID NUMBER 18 Contains unique identifier of the row. System generated.

Indexes

Index Uniqueness Tablespace Columns
FFS_SERVICE_REQUEST_HIST_N1 Non Unique DATA ACTIVITY_ID
FFS_SERVICE_REQUEST_HIST_N2 Non Unique DATA INVENTORY_ID
FFS_SERVICE_REQUEST_HIST_N3 Non Unique DATA RESOURCE_ID
FFS_SERVICE_REQUEST_HIST_N4 Non Unique DATA SERVICE_REQUEST_ID
FFS_SERVICE_REQUEST_HIST_U1 Unique DATA SERVICE_REQUEST_HIST_ID