Stores information about the extended DFF Attributes. This table Contains all the Extended DFF tables and its corresponding attributes and labels.
Module:
DATASOURCE_CODE, DW_TABLE_NAME, DW_COLUMN_NAME
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| DATASOURCE_CODE | VARCHAR2 | 32 | True | Datasource code. | |||
| DW_TABLE_NAME | VARCHAR2 | 128 | True | DFF Target table name | |||
| DW_COLUMN_NAME | VARCHAR2 | 128 | True | DFF Attribute Name | |||
| DW_DATA_TYPE | VARCHAR2 | 32 | DFF Data Type | ||||
| DW_DATA_LENGTH | VARCHAR2 | 16 | DFF Data Length | ||||
| DW_DATA_SCALE | VARCHAR2 | 16 | DFF Data scale | ||||
| DW_IS_PRIMARY | VARCHAR2 | 16 | DFF IS Primary Column | ||||
| DISPLAY_LABEL | VARCHAR2 | 999 | DFF Prompt Value | ||||
| COLUMN_ORDER | VARCHAR2 | 16 | DFF column position | ||||
| FOLDER | VARCHAR2 | 128 | DFF column folder | ||||
| SOURCE_TYPE_CODE | VARCHAR2 | 64 | Source type code for example fusion or netsuite | ||||
| TABLE_TYPE | VARCHAR2 | 32 | Table type either DFF or DE | ||||
| FUNCTIONAL_AREA_CODE | VARCHAR2 | 256 | Functional area code | ||||
| CLASS_CODE | VARCHAR2 | 256 | Represents the custom object generation source application. | ||||
| IS_HIDDEN | VARCHAR2 | 16 | If column need to be hidden. |
Copyright © 2019, 2024, Oracle and/or its affiliates.