FND_TABLE_DATASHAPES
This table will be used to maintain the Table level Datashape Info for all Fusion Tables. 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_TABLE_DATASHAPES_PK |
TABLE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TABLE_ID | NUMBER | 18 | Yes | This value comes from FND_TABLES | |
| TABLE_NAME | VARCHAR2 | 30 | Yes | This value comes from FND_TABLES | |
| TABLE_ROWCOUNT_TARGET | NUMBER | 15 | Target # of Rows the Table should contain | ||
| TABLE_ROWCOUNT_ACTUAL | NUMBER | 15 | Current # of Rows in the Table, Read-Only value | ||
| PRODUCT_FAMILY_NAME | VARCHAR2 | 30 | Product Family Name this table belongs to | ||
| MISMATCH_FLAG | VARCHAR2 | 1 | This value is automatically updated based on the values of Target and Actual values. If Target Value != Actual Value then Mismatch_Flag = 'Y'. Valid values are 'Y' and 'N', Read-Only value | ||
| 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). |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FND_TABLE_DATASHAPES_U1 | Unique | Default | TABLE_NAME |
| fnd_table_datashapes_U1 | Unique | Default | TABLE_ID |