Groups
PROVISIONING_REQUEST
| Column Name | Data Type | Field Length | Not Null? | Data Def. | Comments |
|---|---|---|---|---|---|
ID | NUMBER | 22 | N | Primary key | |
PROVISIONING_TASK_ID | NUMBER | 22 | N | Provisioning task to which the request belongs | |
STATUS_ID | NUMBER | 22 | N | Status of request, 0-new, 1-sent, 5-error, 2-complete, 6-cancel, 99-fatal error, 7-read error, 8-read fatal error, 10-request engine error | |
TRANSACTION_ID | VARCHAR2 | 400 | Y | ||
REQUEST_DATE | DATE | 7 | Y | Date of sending request | |
RESPONS_DATE | DATE | 7 | Y | Date of receiving response | |
RESPONS_CODE | VARCHAR2 | 128 | Y | ||
TRIES | NUMBER | 22 | Y | ||
PARENT_TRANSACTION_ID | VARCHAR2 | 400 | Y | ||
DESCRIPTION | VARCHAR2 | 4000 | Y | Description of task | |
WAIT_ON_CHILDS | VARCHAR2 | 4 | Y | ||
CHILD_OK_CODES | VARCHAR2 | 2048 | Y | ||
CODE | VARCHAR2 | 128 | Y | ||
SERVICE_ID | NUMBER | 22 | Y | ||
TYPECODE | VARCHAR2 | 128 | Y | ||
ERROR_MESSAGE | VARCHAR2 | 4000 | Y | Message in case requested provisioning fails | |
CHECK_DATE | DATE | 7 | Y | ||
EXTERNAL_ID | VARCHAR2 | 400 | Y | ||
NETWORK | VARCHAR2 | 800 | Y | Name of network operator | |
RESULT_TEXT | VARCHAR2 | 4000 | Y | ||
SEQUENCE | NUMBER | 22 | Y | ||
READ_TRIES | NUMBER | 22 | Y | ||
RESPONSE_CODE | VARCHAR2 | 100 | Y | ||
RESPONSE_DATE | DATE | 7 | Y | ||
RESPONSE | CLOB | 4000 | Y | ||
OPTION_ID | NUMBER | 22 | Y | ||
REQUEST | CLOB | 4000 | Y | ||
| 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