Download User Manual Oracle FLEXCUBE Development Workbench for Direct

8. Data Dictionary Registration
Data Dictionary Types
The term Data Types in Oracle Flexcube Direct Banking identifies the types of the various data field
elements in a request. The standard data types supported by the Oracle FCDB system are defined in the
table data_dictionary_types.
FCDB supports a list of standard data types to be used and have the flexibility to support custom data
types. All the standard data types and custom data types are stored in the data_dictionary_types table.
For Example, The Account Number can be treated as a new data type with specific validator associated
with the data type to only validate for the rules for account numbers. Similarly, Credit Card can be a new
data type defined.
Data Dictionary Types Definition
Column Name
DATATYPE
Type
CHAR(20 CHAR)
VARCHAR2(1020
DATATYPE_DESC
CHAR)
VARCHAR2(1020
DATATYPE_VALIDATOR
CHAR)
POOLSIZE
NUMBER(22)
BASE_TYPE
VARCHAR2(40 CHAR)
VARCHAR2(1020
COMMENTS
CHAR)
Nullable Default
Comments
No
Data Type. Primary Key of table.
Yes
Description of Data Type.
Yes
Yes
Yes
Yes
3
Validator to be used for Data
Type.
Pool Size.
Base Type of Data Type ID.
Comments if any.
Data Dictionary
The Data Dictionary is the master set of data elements used within the application. In Oracle Flexcube
Direct Banking, these Data Dictionary values are maintained in the table data_dictionary.
The Data Dictionary identifies the data type of the base data element and also the attributes like the
minimum and maximum length of the data. Data Dictionary elements can be reused for multiple fields
hence applying common validations to fields across various requests.
Data Dictionary Definition
Column Name
Type
VARCHAR2(1020
CHAR)
VARCHAR2(400
CHAR)
Nullable Default
FIELDTYPE
CHAR(12 CHAR)
Yes
MINLENGTH
MAXLENGTH
NUMBER(22)
NUMBER(22)
Yes
Yes
FIELDNAME
FIELDDESC
No
Yes
Comments
Field Name of Data Dictionary. Primary Key of
table.
Field Description of Data Dictionary.
Field Type of Data Dictionary. Foreign Key
reference Data Type of table
data_dictionary_types
Minimum Length.
Maximum Length.
Development Workbench for Direct and Mobile Banking User Manual
166