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

SVC_CHANNEL_VIA_INT

This table stores detailed information about how a service request was received or how an SR Channel was received or sent, and whom it was sent to.

Details

  • Schema: FUSION

  • Object owner: FUSION

  • Object type: TABLE

  • Tablespace: INTERFACE

Primary Key

Name Columns

SVC_CHANNEL_VIA_INT_PK

BATCH_ID, INTERFACE_ROW_ID

Columns

Name Datatype Length Precision Not-null Comments
VIA_ID NUMBER 18 This column is same as base table primary key column .
CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Who column: indicates the user who created the row.
ACTION_CODE VARCHAR2 30 Action code will be used to determine what operation should be done: insert,update,delete.
INTERNAL_ACTION_CODE VARCHAR2 30 Internal action code will be populated internally by framework based on ourcome of match step.
INTERNAL_OVN NUMBER 9 The Object Version Number of the record begin updated. Used for Optimistic Locking as part of Incremental Update.
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
LAST_UPDATE_DATE TIMESTAMP Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 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.
OBJECT_ID NUMBER 18 Foreign key that references SVC_SERVICES_REQUESTS (SR_ID) if this channel is for an SR, or SVC_SR_MESSAGES (MESSAGE_ID) if this channel is for an SR MESSAGE.
OBJECT_TYPE_CD VARCHAR2 30 Lookup code that indicates whether the OBJECT_ID is for SR or for SR_Message.
CHANNEL_ID NUMBER 18 Foreign key that references SVC_CHANNELS_B (CHANNEL_ID).
CONTACT_POINT_ID NUMBER 18 Foreign key that references HZ_CONTACT_POINTS (CONTACT_POINT_ID). The CONTACT_POINT_TYPE column in HZ_CONTACT_POINT will indicate phone, email, etc. The OWNER_TABLE_NAME column will indicate the table name (such as HZ_PARTIES) that stores the owner of the contact point, and OWNER_TABLE_ID is the foreign key to OWNER_TABLE_NAME that identifies the owner of the contact point.
PARTY_ID NUMBER 18 Foreign key that references HZ_PARTIES (PARTY_ID).
PARTY_VIA_END_POINT VARCHAR2 1000 Stores the end point used to send the communication to the owner of the PARTY_ID. This column can be an email address, phone number, etc. When PARTY_ID is null and this column is not null, this end point belongs to an adhoc party.
ROUTING_CD VARCHAR2 30 Lookup code that indicates how the message was routed to the PARTY_VIA_END_POINT. For example, if the message is an email, whether the recipient is a TO, CC, or BCC recipient.
POST_IDENTIFIER VARCHAR2 1000 Stores the unique identifier for the social media posting that can be used to respond via the same channel instance.
DELETED_FLAG VARCHAR2 1 Indicates whether this via record is logically deleted (Y or N).
FILE_RECORD_NUM NUMBER 10 This column is required by import wizard to relate record in the interface table to the file row.
ERROR_MESSAGE VARCHAR2 3000 This is an optional column and would be useful if consumers want any error message as the first error.
IMPORT_STATUS_CODE VARCHAR2 1 This column indicates import wizard if the import to the table was successful or Erorred out.
FILE_NAME_SYSTASK_ID NUMBER 18 This column is required to track multi csv import of service request objects.
BATCH_ID NUMBER 18 Yes For each run of the job, import wizard generates a new batch id and this batch id will be used uniquely.
INTERFACE_ROW_ID NUMBER 18 Yes Used to link this record with the error record.
ORIGINAL_SYSTEM_REFERENCE VARCHAR2 255 Specifies the original system reference if record was imported.
CHANNEL_OSR VARCHAR2 255 Specifies the original system reference of channels if record was imported.
OBJECT_OSR VARCHAR2 255 Specifies the original system reference of Object,if record was imported.
CHANNEL_VIA_PARTY_NUMBER VARCHAR2 30 Additional column to resolve PARTY_ID using alternate key CHANNEL_VIA_PARTY_NUMBER
CHANNEL_VIA_PARTY_ORIG_SYS VARCHAR2 30 Additional column to resolve PARTY_ID using origninal system key
CHANNEL_VIA_PARTY_ORIG_SYS_REF VARCHAR2 255 Additional column to resolve PARTY_ID using origninal system reference
CHANNEL_VIA_CONT_PT_ORIGSYSREF VARCHAR2 255 Additional column to resolve CONTACT_POINT_ID using origninal system reference
INBOUND_OBJECT_ID NUMBER 18 Stores the Id value of the Inbound Object, ex: email, social etc

Indexes

Index Uniqueness Tablespace Columns
SVC_CHANNEL_VIA_INT_U1 Unique Default BATCH_ID, INTERFACE_ROW_ID