FUN_SENSORS_B
This table is to store the seed data of the sensor such as the sensor code and the sensor type, the implicit business conditions that are seeded which are the main entry point for the evaluation of the sensor business conditions, the default schedule of the sensor and the possible actions supported by a particular sensor.
Details
-
Schema: FUSION
-
Object owner: FUN
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
fun_sensors_b_PK |
SENSOR_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| SENSOR_ID | NUMBER | 18 | Yes | Primary identifier to identify a Sensor uniquely | |
| SENSOR_CODE | VARCHAR2 | 30 | Yes | Specifies the type of the Sensor category, like Payable Invoice Approval | |
| SENSOR_TYPE | VARCHAR2 | 128 | Yes | Defines the sensor type, like Approval | |
| DEFAULT_COUNT_THRESHOLD | NUMBER | 9 | Yes | Minimum number of transactions that have to be present for the sensor evaluation to take place. | |
| DEFAULT_TIME_THRESHOLD | NUMBER | 9 | Yes | Valid Value - Minutes. Minimum amount of time after the last execution of the sensor for the evaluation to take place. | |
| MAX_FETCH_SIZE | NUMBER | 9 | Yes | Maximum Number of transactions to be picked for processing. | |
| MINIMUM_TIME_THRESHOLD | NUMBER | 9 | Yes | Valid Value - Minutes. Minimum amount of time that can be changed by the customer for the time threshold after which the sensor has to be executed if count threshold is not met. | |
| SENSOR_PARAMETER | BLOB | Parameters that could be used in implicit conditions and supplied by end user. This are seeded parameters without any value or with default values | |||
| SENSOR_ACTION_TYPE_CODE | VARCHAR2 | 30 | Yes | Actions supported for sensor of a particular category | |
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. | ||
| ORA_SEED_SET1 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N. | |
| ORA_SEED_SET2 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N. | |
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| 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_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FUN_SENSORS_B_U1 | Unique | Default | SENSOR_ID, ORA_SEED_SET1 |
| FUN_SENSORS_B_U11 | Unique | Default | SENSOR_ID, ORA_SEED_SET2 |
| FUN_SENSORS_B_U2 | Unique | Default | SENSOR_CODE, SENSOR_TYPE, ORA_SEED_SET1 |
| FUN_SENSORS_B_U21 | Unique | Default | SENSOR_CODE, SENSOR_TYPE, ORA_SEED_SET2 |