{float:left|width=200px|background=lightgrey|border=solid blue 2px|margin=1px|padding=0px}
{children:page=Rator DB ER Diagram Navigator|depth=1|excerpt=trueindent=1px}
{float}
Column
width
33%
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
Column
width
33%
Contains all requests sent to the provisioning gateway