PROVISIONING_TASK

Owned by Søren Duusgaard (Deactivated)
Last updated: 10.11.2014

Groups

PROVISIONING_TASK

Column NameData Type Not Null?Data Def.Comments

ID

NUMBER

22

N

 Primary key

SERVICE_ID

NUMBER

22

Y

 Service to which the task belongs

WORKFLOW_ID

NUMBER

22

Y

 Workflow processing the task

STATUS_ID

NUMBER

22

Y

 

Task status: 0-new, 1-sent, 2-completed, 3-error, 4-cancelled, 5-fatal error, 6-response received, 7-internal error, 8-workflow started, 10-request created

CREATE_DATE

DATE

7

Y

 Date of creating the task

NETWORK_ID

NUMBER

22

Y

 Network operator handling the task

START_DATE

DATE

7

Y

 Date of starting the task

PRIORITY

VARCHAR2

40

Y

 Task priority

DESCRIPTION

VARCHAR2

100

Y

 Task description

COMMENTS

VARCHAR2

4000

Y

 Additional task description

NETWORK

VARCHAR2

40

Y

 Name of network operation

PROVISIONING_AGENT

VARCHAR2

40

Y

 Name of agent handling the task

CODE

VARCHAR2

40

Y

 

Type of task as described by the following:

  • ACTSUB - activate a subscription
  • UPDATE - update service option
  • TERMINATE - terminate SIM card
  • CHANGESIM - change SIM card
  • CHANGE_ANUMBER - change mobile number
  • BLOCK - block SIM card
  • SOFTBLOCK - soft block SIM card
  • UNBLOCK - unblock SIM card
  • UNSOFTBLOCK - unsoftblock SIM card
  • TOPUP - top-up an account

END_DATE

DATE

7

Y

 Date of ending the task

RESULT

VARCHAR2

4000

Y

 Result of the task

ICC

VARCHAR2

40

Y

 ICC (Integrated Circuit Number) number

MSISDN

VARCHAR2

40

Y

 

MSISDN (Mobile Station Integrated Services Digital Network) number

REFERENCE

VARCHAR2

40

Y

  

COMPLETE_DATE

DATE

7

Y

 Date of completing task

TRIES

NUMBER

22

Y

  

CHECK_DATE

DATE

7

Y

 

For asynchronous cases - updated when reader engine polls the provisioning result

OLDICC

VARCHAR2

40

Y

 

Previous ICC number

PARENT_TASK_ID

NUMBER

22

Y

 Parent task to which current task belongs
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