Workflow Item Attributes for Model Apply

The Oracle Workflow item attributes for model apply are as follows:


case_table             VARCHAR2(62)
table_1                VARCHAR2(62)
table_n                VARCHAR2(62)
case_sql               VARCHAR2(32767)
additional_sql_1       VARCHAR2(32767)
additional_sql_n       VARCHAR2(32767)
use_table_view_input   VARCHAR2(1), 'Y' or 'N'
model_name             VARCHAR2(25)
feature_table_name     VARCHAR2(30); 
apply_result_name      VARCHAR2(32)
table_output           VARCHAR2(1), 'Y' or 'N'
drop_output            VARCHAR2(1)
isDropOutput           BOOLEAN (TRUE or FALSE)

USE_TABLE_VIEW_INPUT takes on the values 'Y' and 'N'. 'Y' indicates that the input is tables or views; 'N' indicates that the input is SQL. The meaning of the values is described in the following pseudo code:


If USE_TABLE_VIEW_INPUT = 'Y', get the input data from 
    CASE_TABLE
    TABLE_1
    TABLE_N
ELSE get the input data from 
    CASE_SQL
    ADDITIONAL_SQL_1
    ADDITIONAL_SQL_N

Item attributes that describe tables specify the schema name and the table name in one attribute.