EXM_EXPENSE_PREDICTIONS
EXM_EXPENSE_PREDICTIONS contains the predicted values from Intelligent Document Recognition and smart defaulting logic such as currency locations and expense types.
Details
-
Schema: FUSION
-
Object owner: EXM
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
EXM_EXPENSE_PREDICTIONS_PK |
PREDICTION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PREDICTION_ID | NUMBER | 18 | Yes | Unique identifier of the prediction. | |
| EXPENSE_ID | NUMBER | 18 | Yes | Identifier of the associated expense record. | |
| IDR_REQUEST_IDENTIFIER | VARCHAR2 | 32 | Request ID of the Intelligent Document Recognition prediction. | ||
| ATTACHMENT_ID | NUMBER | 18 | Identifier of the attachment associated with the expense record. | ||
| FIELD_NAME | VARCHAR2 | 64 | Name of the field whose value is predicted. | ||
| FIELD_VALUE | VARCHAR2 | 240 | Predicted value of the associated field. | ||
| FIELD_ACCURACY_SCORE | NUMBER | 3 | Value of the confidence score predicted by Intelligent Document Recognition. | ||
| VERSION_NUMBER | VARCHAR2 | 32 | Version of data prediction source used. | ||
| PREDICTION_SOURCE | VARCHAR2 | 32 | Data prediction source.Indicates prediction source as sources apart from Intelligent Document Recognition when also applicable. | ||
| RULE_CODE | VARCHAR2 | 32 | Defaulting rule used for the smart defaulting logic. | ||
| SOURCE_OBJECT_CODE | VARCHAR2 | 30 | Identifer of the object that provides data for expense creation or updation. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | 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. | ||
| DRIVER_NAME1 | VARCHAR2 | 100 | Name of the driver used for smart defaulting logic. | ||
| DRIVER_VALUE1 | VARCHAR2 | 2000 | Value of the driver used in smart defaulting logic. | ||
| DRIVER_NAME2 | VARCHAR2 | 100 | Name of the driver used for smart defaulting logic. | ||
| DRIVER_VALUE2 | VARCHAR2 | 2000 | Value of the driver used in smart defaulting logic. | ||
| DRIVER_NAME3 | VARCHAR2 | 100 | Name of the driver used for smart defaulting logic. | ||
| DRIVER_VALUE3 | VARCHAR2 | 2000 | Value of the driver used in smart defaulting logic. | ||
| DRIVER_NAME4 | VARCHAR2 | 100 | Name of the driver used for smart defaulting logic. | ||
| DRIVER_VALUE4 | VARCHAR2 | 2000 | Value of the driver used in smart defaulting logic. | ||
| DRIVER_NAME5 | VARCHAR2 | 100 | Name of the driver used for smart defaulting logic. | ||
| DRIVER_VALUE5 | VARCHAR2 | 2000 | Value of the driver used in smart defaulting logic. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| EXM_EXPENSE_PREDICTIONS_PK | Unique | FUSION_TS_TX_DATA | PREDICTION_ID |
| EXM_EXPENSE_PREDICTIONS_U1 | Unique | FUSION_TS_TX_DATA | EXPENSE_ID, FIELD_NAME |