BPEL_VARIABLE_SENSOR_VALUES
Table D-4 contains all the variable sensor values.
Table D-4 BPEL_VARIABLE_SENSOR_VALUES View
| Attribute Name | SQL Type | Attribute Size | Indexed or Unique? | Null? | Comment |
|---|---|---|---|---|---|
|
|
|
-- |
PK |
N |
Unique ID |
|
|
|
-- |
U1,1 |
N |
BPEL process ID |
|
|
|
500 |
-- |
N |
User-defined application name |
|
|
|
500 |
-- |
N |
User-defined composite name |
|
|
|
50 |
-- |
N |
User-defined revision number |
|
|
|
500 |
-- |
N |
User-defined label |
|
|
|
500 |
-- |
N |
User-defined component name |
|
|
|
200 |
U1,2 |
N |
Name of the sensor that fired |
|
|
|
512 |
-- |
N |
Target of the sensor |
|
|
|
200 |
U1,3 |
N |
Name of the action |
|
|
|
512 |
-- |
Y |
Filter of the action |
|
|
|
-- |
-- |
Y |
ID of the corresponding activity sensor value |
|
|
|
6 |
-- |
N |
Creation date |
|
|
|
-- |
-- |
N |
Date portion of |
|
|
|
-- |
-- |
N |
Hour portion of |
|
|
|
512 |
-- |
N |
The name of the BPEL variable |
|
|
|
30 |
-- |
Y |
Evaluation point of the corresponding activity sensor |
|
|
|
1 |
-- |
Y |
|
|
|
|
512 |
-- |
-- |
-- |
|
|
|
200 |
-- |
N |
The name of the activity or event that updated the variable |
|
|
|
200 |
-- |
N |
The type of the BPEL activity or event |
|
|
|
512 |
-- |
Y |
Namespace of variable sensor value |
|
|
|
512 |
-- |
Y |
Data type of the variable sensor value |
|
|
|
-- |
-- |
N |
The value type of the variable (corresponds to |
|
|
|
4000 |
-- |
Y |
The value of string-like variables |
|
|
|
-- |
-- |
Y |
|
|
|
|
6 |
-- |
Y |
User-defined date |
|
|
|
10 |
-- |
Y |
User-defined time zone |
|
|
|
-- |
-- |
Y |
|
|
|
|
-- |
-- |
Y |