1. Tables and Views for Sales and Fusion Service
  2. SVC_WO_TYPE_MAP

SVC_WO_TYPE_MAP

This table is used to store properties for work order types for each work order integration and are updated by admin users. WO_TYPE_ID is the primary / unique key in this table.

Details

  • Schema: FUSION

  • Object owner: SVC

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

SVC_WO_TYPE_MAP_PK

WO_TYPE_ID

Columns

Name Datatype Length Precision Not-null Comments
WO_TYPE_ID NUMBER 18 Yes Auto-generated number and primary key for this table
WO_TYPE_LOOKUP_TYPE VARCHAR2 30 Yes The work order type lookup type from FND_LOOKUP_VALUES.LOOKUP_TYPE to map to the integration application work order type code.
WO_TYPE_LOOKUP_TYPE_CD VARCHAR2 64 Yes The work order wo_type_cd is concatenated with wo_type_look_type. This is required by elastic search for enum sqlLookups.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated 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.
WO_TYPE_CD VARCHAR2 30 Yes The work order type code from FND_LOOKUP_VALUES.LOOKUP_CODE to map to the integration application work order type code.
FS_TYPE_CD VARCHAR2 30 The work order type code of the corresponding work order type code from the integrating application.
WO_INTEGRATION_CD VARCHAR2 30 Yes Work order integration code to represent the integration the type is associated with.
DEFAULT_DURATION NUMBER 9 The default duration time in minutes it is expected to take in order to complete a work order of this type.
SOURCE_CD VARCHAR2 30 Identifies the work order type code-owning application updated during the synchronization process. The work order type code can only be updated by the owning application.
MULTI_DAY_FLAG VARCHAR2 1 Property used for a work order type code to identify that the work order will take multiple days to complete.
ALLOW_RESCHEDULE_FLAG VARCHAR2 1 Property used for work order type code to identify that the work order can be rescheduled for another date.
ALLOW_NON_SCHEDULED_FLAG VARCHAR2 1 Property used for a work order type code to identify that the work order can be created with only a resolution due.
ENABLE_REMINDER_FLAG VARCHAR2 1 Property used for a work order type code to identify that the reminder time can be included on the work order.
SUPP_INVENTORY_FLAG VARCHAR2 1 Property used for a work order type code to identify that inventory can be used on the work order.
SUPP_REQ_INVENTORY_FLAG VARCHAR2 1 Property used for a work order type code to identify that required inventory can be used on this work order. The assigned field technician is then notified.
SUPP_LINKS_FLAG VARCHAR2 1 Property used for a work order type code to identify whether the linking of predecessor and successor activity relationships is allowed on the work order.
SUPP_PREF_RESOURCES_FLAG VARCHAR2 1 Property used for a work order type code to identify if resource preferences can be defined on the work order.
DELETED_FLAG VARCHAR2 1 Indicates whether the work order type is logically deleted (Y or N).

Foreign Keys

Table Foreign Table Foreign Key Column
svc_work_orders svc_wo_type_map WO_TYPE_ID

Indexes

Index Uniqueness Tablespace Columns
SVC_WO_TYPE_MAP_PK Unique Default WO_TYPE_ID
SVC_WO_TYPE_MAP_U1 Unique Default WO_TYPE_LOOKUP_TYPE, WO_TYPE_CD
SVC_WO_TYPE_MAP_U2 Unique Default WO_INTEGRATION_CD, WO_TYPE_CD
SVC_WO_TYPE_MAP_U3 Unique Default WO_TYPE_LOOKUP_TYPE_CD