PROVISIONING_REQUEST

Groups

PROVISIONING_REQUEST

Column NameData TypeField LengthNot 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