PROVISIONING_REQUEST
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