4.1.2 Business Term Data Type
Data Types provide a framework for classification that defines the nature of data within a system, ensuring proper interpretation, storage, and manipulation. Each logical data type is designed for specific use cases, clearly distinguishing how different types of data should be handled. For instance, types like amount, amount_long, and amount_medium represent financial figures with varying levels of precision and scale, while currency denotes monetary values linked to a specific currency. These logical data types help maintain the structure, integrity, and compatibility of data models across various systems and applications.
Following are the list of Data Types supported in DFCS:
Table 4-1 List of Data Types supported in DFCS
| Logical Data Type | Oracle Data Type |
|---|---|
| Amount | NUMBER(22,3) |
| Amount_Long | NUMBER(38,6) |
| Amount_Medium | NUMBER(30,11) |
| Clob | CLOB |
| Blob | BLOB |
| Code_Alphanumeric | VARCHAR2(20) |
| Code_Alphanumeric_Long | VARCHAR2(60) |
| Code_Numeric | NUMBER(14) |
| Currency | VARCHAR2(3) |
| Date | DATE |
| Description_Short | VARCHAR2(100) |
| Description | VARCHAR2(255) |
| Description_Medium | VARCHAR2(1000) |
| Description_Long | VARCHAR2(4000) |
| Flag | CHAR(1) |
| Indicator | VARCHAR2(1) |
| Number_Factor | NUMBER(10,6) |
| Number_Factor_Long | NUMBER(38,15) |
| Numeric | NUMBER(10) |
| Numeric_Long | NUMBER(30) |
| Rate_Percent | NUMBER(11,6) |
| Rate_Percent_Medium | NUMBER(15,11) |
| Rate_Percent_Long | NUMBER(30,11) |
| SurrogateKey | NUMBER(10) |
| SurrogateKey_Long | NUMBER(15) |
| Timestamp | TIMESTAMP |
| Amount_Currency | NUMBER(22,3) |
| Amount_Currency_Long | NUMBER(38,6) |
| Amount_Currency_Date | NUMBER(22,3) |
| Amount_Currency_Date_Long | NUMBER(38,6) |
| Number_Area | NUMBER(30,3) |
| Number_Geog_Temp | NUMBER(3,2) |
| Number_Speed | NUMBER(4,2) |
| Number_Weight_Ltrs | NUMBER(7,2) |
| Number_Distance | NUMBER(10,2) |
| Number_Elec_Str | NUMBER(4,2) |