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 | 2048 | DFF Prompt Value | ||||
COLUMN_ORDER | VARCHAR2 | 16 | DFF column position | ||||
SOURCE_TYPE_CODE | VARCHAR2 | 64 | Source type code for example fusion or netsuite | ||||
TABLE_TYPE | VARCHAR2 | 32 | Table type either DFF or DE |