Groups
PROVISIONING_REQUEST
Col # | Column Name | Data Type | Field Length | Not Null? | Data Def. | Comments |
|---|---|---|---|---|---|---|
| 1 | ID | NUMBER | 22 | N | Primary key | |
| 2 | PROVISIONING_TASK_ID | NUMBER | 22 | N | Provisioning task to which the request belongs | |
| 3 | 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 | |
| 4 | TRANSACTION_ID | VARCHAR2 | 400 | Y | ||
| 5 | REQUEST_DATE | DATE | 7 | Y | Date of sending request | |
| 6 | RESPONS_DATE | DATE | 7 | Y | Date of receiving response | |
| 7 | RESPONS_CODE | VARCHAR2 | 128 | Y | ||
| 8 | TRIES | NUMBER | 22 | Y | ||
| 9 | PARENT_TRANSACTION_ID | VARCHAR2 | 400 | Y | ||
| 10 | DESCRIPTION | VARCHAR2 | 4000 | Y | Description of task | |
| 11 | WAIT_ON_CHILDS | VARCHAR2 | 4 | Y | ||
| 12 | CHILD_OK_CODES | VARCHAR2 | 2048 | Y | ||
| 13 | CODE | VARCHAR2 | 128 | Y | ||
| 14 | SERVICE_ID | NUMBER | 22 | Y | ||
| 15 | TYPECODE | VARCHAR2 | 128 | Y | ||
| 16 | ERROR_MESSAGE | VARCHAR2 | 4000 | Y | Message in case requested provisioning fails | |
| 17 | CHECK_DATE | DATE | 7 | Y | ||
| 18 | EXTERNAL_ID | VARCHAR2 | 400 | Y | ||
| 19 | NETWORK | VARCHAR2 | 800 | Y | Name of network operator | |
| 20 | RESULT_TEXT | VARCHAR2 | 4000 | Y | ||
| 21 | SEQUENCE | NUMBER | 22 | Y | ||
| 22 | READ_TRIES | NUMBER | 22 | Y | ||
| 23 | RESPONSE_CODE | VARCHAR2 | 100 | Y | ||
| 24 | RESPONSE_DATE | DATE | 7 | Y | ||
| 25 | RESPONSE | CLOB | 4000 | Y | ||
| 26 | OPTION_ID | NUMBER | 22 | Y | ||
| 27 | REQUEST | CLOB | 4000 | Y |
Contains all requests sent to the provisioning gateway