{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
Col#
Column Name
Data Type
Field Length
Not Null?
Data Def.
Comments
1
ID
NUMBER
22
N
Primary key2
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 operator20
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
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