FND_COLUMN_DATASHAPES
This table will be used to maintain the Column level Datashape Info for all Fusion Tables and Columns. It will store the current Datashape Info (Actual) which will be automatically populated by a script and also the Target Datashape Info to be populated by the Table Owners based on their requirements. The goal is to match both Target and Actual values.
Details
-
Schema: DatashapeTables
-
Object owner: FUSION
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
FND_COLUMN_DATASHAPES_PK |
TABLE_ID, COLUMN_ID, ENTERPRISE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ENTERPRISE_ID | NUMBER | 18 | Yes | ENTERPRISE_ID | |
| TABLE_ID | NUMBER | 18 | Yes | This value comes from FND_TABLES | |
| COLUMN_ID | NUMBER | 18 | Yes | This value comes from FND_COLUMNS | |
| COLUMN_NAME | VARCHAR2 | 30 | Yes | This value comes from FND_COLUMNS | |
| COLUMN_TYPE | VARCHAR2 | 30 | User provided, could me 'LOV', 'FK', 'PK' or anything else | ||
| PERCENT_NULLS | NUMBER | 3 | Percentage values that are NULL | ||
| MIN_DISTRIBUTION_TARGET | NUMBER | 15 | Minimum # of Duplicates that should eventually be in the DB | ||
| MIN_DISTRIBUTION_ACTUAL | NUMBER | 15 | Minimum # of Duplicates that are currently there in the DB | ||
| MAX_DISTRIBUTION_TARGET | NUMBER | 15 | Maximum # of Duplicates that should eventually be in the DB | ||
| MAX_DISTRIBUTION_ACTUAL | NUMBER | 15 | Maximum # of Duplicates that are currently there in the DB | ||
| DISTRIBUTION_CURVE_TARGET | VARCHAR2 | 30 | Distribution Curve Type that should eventually be in the DB (Progressive, Regressive, Even, Bell-Shaped) | ||
| DISTRIBUTION_CURVE_ACTUAL | VARCHAR2 | 30 | Distribution Curve Type currently in the DB (Progressive, Regressive, Even, Bell-Shaped) | ||
| LOV_TABLE_NAME | VARCHAR2 | 30 | Table Name that contains the LOV Values (i.e FND_LOOKUPS) | ||
| LOV_LOOKUP_TYPE | VARCHAR2 | 30 | Lookup Type specified for this LOV in the LOV Table (i.e Opty Type) | ||
| CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||
| CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||
| LAST_UPDATE_DATE | TIMESTAMP | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Who column: indicates the user who last updated the row. | ||
| USER_LAST_UPDATE_DATE | TIMESTAMP | Disconnected Mobile: indicates the date and time of the last update of the row. This value is different from LAST_UPDATE_DATE if the update originally happened in a different database (i.e. a different mobile database or the server). | |||
| LOV_VALUES_TARGET | VARCHAR2 | 2000 | Target LOV Values | ||
| LOV_VALUES_ACTUAL | VARCHAR2 | 2000 | Actual LOV Values currently in the DB | ||
| ADDITIONAL_DATASHAPE_INFO | VARCHAR2 | 2000 | Any Additional Datashape Information |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FND_COLUMN_DATASHAPES_U1 | Unique | Default | TABLE_ID, COLUMN_ID, ENTERPRISE_ID |