PROVISIONING_TASK
- Søren Duusgaard (Deactivated)
Groups
PROVISIONING_TASK
| Column Name | Data Type | Not Null? | Data Def. | Comments | |
|---|---|---|---|---|---|
ID | NUMBER | 22 | N | Primary key | |
SERVICE_ID | NUMBER | 22 | Y | Service to which the task belongs | |
WORKFLOW_ID | NUMBER | 22 | Y | Workflow processing the task | |
STATUS_ID | NUMBER | 22 | Y | Task status: 0-new, 1-sent, 2-completed, 3-error, 4-cancelled, 5-fatal error, 6-response received, 7-internal error, 8-workflow started, 10-request created | |
CREATE_DATE | DATE | 7 | Y | Date of creating the task | |
NETWORK_ID | NUMBER | 22 | Y | Network operator handling the task | |
START_DATE | DATE | 7 | Y | Date of starting the task | |
PRIORITY | VARCHAR2 | 40 | Y | Task priority | |
DESCRIPTION | VARCHAR2 | 100 | Y | Task description | |
COMMENTS | VARCHAR2 | 4000 | Y | Additional task description | |
NETWORK | VARCHAR2 | 40 | Y | Name of network operation | |
PROVISIONING_AGENT | VARCHAR2 | 40 | Y | Name of agent handling the task | |
CODE | VARCHAR2 | 40 | Y | Type of task as described by the following:
| |
END_DATE | DATE | 7 | Y | Date of ending the task | |
RESULT | VARCHAR2 | 4000 | Y | Result of the task | |
ICC | VARCHAR2 | 40 | Y | ICC (Integrated Circuit Number) number | |
MSISDN | VARCHAR2 | 40 | Y | MSISDN (Mobile Station Integrated Services Digital Network) number | |
REFERENCE | VARCHAR2 | 40 | Y | ||
COMPLETE_DATE | DATE | 7 | Y | Date of completing task | |
TRIES | NUMBER | 22 | Y | ||
CHECK_DATE | DATE | 7 | Y | For asynchronous cases - updated when reader engine polls the provisioning result | |
OLDICC | VARCHAR2 | 40 | Y | Previous ICC number | |
PARENT_TASK_ID | NUMBER | 22 | Y | Parent task to which current task belongs | |
| OBJECT_ID | VARCHAR2 | 200 | With v 9.8 | ||
| OBJECT_CLASS_NAME | VARCHAR2 | 200 | With v 9.8 |
Contains all requests sent to the provisioning gateway