Custom Data field specifications

This table lists the field-column specifications in the Custom Data import interface. Fields with the asterisk (*) symbol are required.
Note: Previously, WFM only allowed the values Y and N when importing into single character fields for the WB_CUSTOM_DATA table. With release 2023.11, you can import other single character values as well, such as A, B, C.

To enable this option, update the WBCD_CHAR field with the additional parameter as shown in Sample XML and CSV files.

Col. Field Name Type Size/Format Description
1 WBCDT_ID* Number 22 The custom data ID from the WB_CUSTOM_DATA_TYPE table.
2 WBCD_TEXT1 Varchar2 400 User defined field.
3 WBCD_TEXT2 400 User defined field.
4 WBCD_TEXT3 400 User defined field.
5 WBCD_TEXT4 400 User defined field.
6 WBCD_TEXT5 400 User defined field.
7 WBCD_TEXT6 400 User defined field.
8 WBCD_TEXT7 400 User defined field.
9 WBCD_TEXT8 400 User defined field.
10 WBCD_TEXT9 400 User defined field.
11 WBCD_TEXT10 400 User defined field.
12 WBCD_CHAR1 Varchar2 1 One-character flag for general use.

A {space} in one of the flag positions indicates no processing is to be done for that flag.

An ampersand (&) in one of the flag positions indicates the flag is to be blanked.

13 WBCD_CHAR2 Varchar2 1 One-character flag for general use.
14 WBCD_CHAR3 Varchar2 1 One-character flag for general use.
15 WBCD_CHAR4 Varchar2 1 One-character flag for general use.
16 WBCD_CHAR5 Varchar2 1 One-character flag for general use.
17 WBCD_CHAR6 Varchar2 1 One-character flag for general use.
18 WBCD_CHAR7 Varchar2 1 One-character flag for general use.
19 WBCD_CHAR8 Varchar2 1 One-character flag for general use.
20 WBCD_CHAR9 Varchar2 1 One-character flag for general use.
21 WBCD_CHAR10 Varchar2 1 One-character flag for general use.
22 WBCD_DATE1 Date yyyyMMdd User defined field.
23 WBCD_DATE2 Date yyyyMMdd User defined field.
24 WBCD_DATE3 Date yyyyMMdd User defined field.
25 WBCD_DATE4 Date yyyyMMdd User defined field.
26 WBCD_DATE5 Date yyyyMMdd User defined field.
27 WBCD_DATE6 Date yyyyMMdd User defined field.
28 WBCD_DATE7 Date yyyyMMdd User defined field.
29 WBCD_DATE8 Date yyyyMMdd User defined field.
30 WBCD_DATE9 Date yyyyMMdd User defined field.
31 WBCD_DATE10 Date yyyyMMdd User defined field.
32 WBCD_NUM1 Number 22 User defined field.
33 WBCD_NUM2 Number 22 User defined field.
34 WBCD_NUM3 Number 22 User defined field.
35 WBCD_NUM4 Number 22 User defined field.
36 WBCD_NUM5 Number 22 User defined field.
37 WBCD_NUM6 Number 22 User defined field.
38 WBCD_NUM7 Number 22 User defined field.
39 WBCD_NUM8 Number 22 User defined field.
40 WBCD_NUM9 Number 22 User defined field.
41 WBCD_NUM10 Number 22 User defined field.
42 WBCD_DEC1 Number 22 User defined field.
43 WBCD_DEC2 Number 22 User defined field.
44 WBCD_DEC3 Number 22 User defined field.
45 WBCD_DEC4 Number 22 User defined field.
46 WBCD_DEC5 Number 22 User defined field.
47 WBCD_DEC6 Number 22 User defined field.
48 WBCD_DEC7 Number 22 User defined field.
49 WBCD_DEC8 Number 22 User defined field.
50 WBCD_DEC9 Number 22 User defined field.
51 WBCD_DEC10 Number 22 User defined field.