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

SVC_STD_TXT_USR_VARS_INT

This table stores the available variables defined by the customer and its static values or object.attribute substitution.

Details

  • Schema: FUSION

  • Object owner: FUSION

  • Object type: TABLE

  • Tablespace: INTERFACE

Primary Key

Name Columns

SVC_STD_TXT_USR_VARS_INT_PK

BATCH_ID, INTERFACE_ROW_ID

Columns

Name Datatype Length Precision Not-null Comments
VARIABLE_ID NUMBER 18 variable_id is resolved during the enrichment process.
VARIABLE_NUMBER VARCHAR2 30 Variable_Number. This is a public surrogate key.
VARIABLE_UNIQUE_NUMBER VARCHAR2 30 Variable_Number. This is a public surrogate key and is a required field in the base table.
CREATED_BY VARCHAR2 64 Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP 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.
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.
VARIABLE_CODE VARCHAR2 50 Variable that is displayed in the UI for context substitution into actual value.
DESCRIPTION VARCHAR2 50 Short Description of the variable and its context.
CONTEXT VARCHAR2 50 Indicator of the application or context this variable is used.
OBJECT VARCHAR2 150 This is the reference to the object that holds the value for substituting the variable.
ATTRIBUTE VARCHAR2 50 This is the field or attribute on the object that holds the value for substitution
VAL_CHAR VARCHAR2 150 Static character value for the variable substitution.
VAL_DATE DATE Static date value for the variable substitution.
VAL_TIMESTAMP TIMESTAMP Static timestamp value for the variable substitution.
VAL_NUMBER NUMBER Static number value for the variable substitution.
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.
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 base table was successful or Erorred out.
FILE_NAME_SYSTASK_ID NUMBER 18 This column is required to track multi csv import of standard text folder 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.
ACTION_CODE VARCHAR2 30 Action code will be used to determine what operation should be done: insert,update,delete.
DATACONTROL VARCHAR2 150 This is the reference to the datacontrol that the object belongs to .
STRIPE_CD VARCHAR2 30 Lookup code that indicates the stripe code, such as CRM, HCM, or PRM.

Indexes

Index Uniqueness Tablespace Columns
SVC_STD_TXT_USR_VARS_INT_N1 Non Unique Default BATCH_ID, IMPORT_STATUS_CODE
SVC_STD_TXT_USR_VARS_INT_N2 Non Unique Default BATCH_ID, VARIABLE_NUMBER
SVC_STD_TXT_USR_VARS_INT_U1 Unique Default BATCH_ID, INTERFACE_ROW_ID