Contains Enrichment Table Column Information
Module:
COLUMN_NAME, DATASOURCE_CODE, TABLE_NAME
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| DATASOURCE_CODE | VARCHAR2 | 32 | True | Datasource code. | |||
| TABLE_NAME | VARCHAR2 | 128 | True | Table name | |||
| COLUMN_NAME | VARCHAR2 | 128 | True | Column name | |||
| SOURCE_RECORD_ID | VARCHAR2 | 512 | This column is for Oracle Internal use only. Source record identifier | ||||
| COLUMN_TYPE | VARCHAR2 | 64 | Column type | ||||
| CONTAINER_DOMAIN_CODE | VARCHAR2 | 128 | Set of columns explaining the given domain | ||||
| COLUMN_DOMAIN_CODE | VARCHAR2 | 128 | Container domain code which this column refers to | ||||
| AGGREGATION_LOGIC | VARCHAR2 | 999 | Column aggregation logic Default NULL if there is no aggregation logic | ||||
| FUNCTIONAL_AREA_CODE | VARCHAR2 | 256 | Functional area code | ||||
| CLASS_CODE | VARCHAR2 | 256 | Represents the custom object generation source application. |
Copyright © 2019, 2024, Oracle and/or its affiliates.