DataImportTemplateOption (ver24.5.1.0)
The table stores the import options associated with a template. One template can be associated with many import options. Data gets entered into this table on saving an import template.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
DATAIMPORTTEMPLATEID | 24.5.1.0 | NUMBER(19,0) | Foreign key. Associated to DATAIMPORTTEMPLATE table |
DATAIMORTTEMPLATEOPTIONID | 24.5.1.0 | NUMBER(19,0) | Primary Key of table. |
OPTION_NAME | 24.5.1.0 | VARCHAR2(20 CHAR) | Represents the name of the import option. |
OPTION_TYPE | 24.5.1.0 | VARCHAR2(100 CHAR) | Represents the type of the import option. |
OPTION_VALUE | 24.5.1.0 | VARCHAR2(2000 CHAR) | Represents the value of the import option. |
WHENCREATED | 24.5.1.0 | Timestamp(6) | Date and time the record was created. Defaults to system date. Required. |
WHENMODIFIED | 24.5.1.0 | Timestamp(6) | Date and time the record was modified. Defaults to system date. Required. |
WHOCREATED | 24.5.1.0 | Varchar2(100) | The user login that created the record. Defaults to database user. Required. |
WHOMODIFIED | 24.5.1.0 | Varchar2(100) | The user login that created the record. Defaults to database user. Required. |