Groups
NP_FLOW
Col # | Column Name | Data Type | Field Length | Not Null? | Data Def. | Comments |
|---|---|---|---|---|---|---|
1 | ID | NUMBER | 22 | N | Primary key | |
2 | SUBSCRIPTION_ID | NUMBER | 22 | Y | ID of subscription attached to number | |
3 | WORKFLOW_ID | NUMBER | 22 | Y | Workflow handling the NP process | |
4 | SIGNUP_DATE | DATE | 7 | Y | Date of number signup | |
5 | PHONE_NUMBER | VARCHAR2 | 80 | Y | Mobile number | |
6 | PORT_DATE | DATE | 7 | Y | Date of importing/exporting number | |
7 | ACTIVATION_DATE | DATE | 7 | Y | Date of activating number | |
8 | SIMCARD_SENT_DATE | DATE | 7 | Y | Date of sending SIM card | |
9 | CUSTOMER_NAME | VARCHAR2 | 400 | Y | ||
10 | CUSTOMER_ID | NUMBER | 22 | Y | ||
11 | DSP_ID | NUMBER | 22 | Y | DSP (Donor Service Provider) offering the number | |
12 | ODSP_ID | NUMBER | 22 | Y | ||
13 | RSP_ID | NUMBER | 22 | Y | ||
14 | NETWORK_ID | NUMBER | 22 | Y | ||
15 | STATUS_ID | NUMBER | 22 | Y | NP status: 0-pending, 1-completed, 2-waiting for donor, 6-cancelled, 7-waiting for activation, 8-waiting for cancel/confirm, 9-check reject, 10-waiting for npc ok | |
16 | AUTH_REF | VARCHAR2 | 120 | Y | ||
17 | CASE_NUMBER | NUMBER | 22 | Y | NP case number | |
18 | REJECT_CODE | VARCHAR2 | 40 | Y | Reject code | |
19 | NPFERD_DATE | DATE | 7 | Y | ||
20 | TERMINATION_DATE | DATE | 7 | Y | Date of terminating number | |
21 | MANUAL | NUMBER | 22 | Y | ||
22 | CODE | VARCHAR2 | 80 | Y | NP code, refers to implementation class | |
23 | DONOR_NETWORK_ID | NUMBER | 22 | Y | ||
24 | DONOR_CUT_OFF | DATE | 7 | Y | ||
25 | NEW_SIMCARD_ID | NUMBER | 22 | Y | New SIM card ID, references SIMCARD-table | |
26 | PORT_TYPE_ID | NUMBER | 22 | Y | NP type: 0-import, 2-export | |
27 | NEW_PRODUCT_ID | NUMBER | 22 | Y | New product ID, references PRODUCT-table | |
28 | PRINT_LETTER_EXTERN | VARCHAR2 | 4 | Y | ||
29 | CASE_STATUS_ID | NUMBER | 22 | Y | NP case status, 1-case active, 2-case unactive | |
30 | OLD_SIMCARD_ID | NUMBER | 22 | Y | Old SIM card id, references SIMCARD-table | |
31 | PAC | VARCHAR2 | 36 | Y | ||
32 | PAC_EXPIRY_DATE | DATE | 7 | Y | ||
33 | PAC_CREATION_DATE | DATE | 7 | Y | ||
34 | PORT_DATE_CONFIRMED | DATE | 7 | Y | ||
35 | SP_CODE | VARCHAR2 | 12 | Y | ||
36 | SP_NAME | VARCHAR2 | 200 | Y | ||
37 | DNO_CODE | VARCHAR2 | 12 | Y | ||
38 | DNO_NAME | VARCHAR2 | 200 | Y | ||
39 | REJECT_COMMENT | VARCHAR2 | 4000 | Y | Comment in case of NP rejection | |
40 | KEEP_SUB | VARCHAR2 | 4 | Y | ||
41 | FIRST_NAME | VARCHAR2 | 512 | Y | ||
42 | LAST_NAME | VARCHAR2 | 512 | Y | ||
43 | STREET | VARCHAR2 | 512 | Y | ||
44 | HOUSE_NUMBER | NUMBER | 22 | Y | ||
45 | HOUSE_EXTENSION | VARCHAR2 | 512 | Y | ||
46 | ZIP | VARCHAR2 | 512 | Y | ||
47 | CITY | VARCHAR2 | 512 | Y | ||
48 | TEMP_PHONE_NUMBER | VARCHAR2 | 512 | Y | ||
49 | PROVISIONING_REFERENCE | VARCHAR2 | 200 | Y | ||
50 | IS_PREPAID_CUSTOMER | NUMBER | 22 | Y | ||
51 | PROVISIONING_REFERENCE_2 | VARCHAR2 | 200 | Y | ||
52 | CANCEL_DATE | DATE | 7 | Y | ||
53 | SEND_NEW_SIMCARD | VARCHAR2 | 40 | Y | ||
54 | TEMP_NUMBER | VARCHAR2 | 80 | Y | ||
55 | PREPAID_ICC | VARCHAR2 | 120 | Y | ||
56 | WISH_DATE | DATE | 7 | Y | ||
57 | RENEW_NOTE | VARCHAR2 | 4000 | Y | ||
58 | PORT_WISH_DATE | DATE | 7 | Y | ||
59 | STREET_NUMBER | VARCHAR2 | 200 | Y | ||
60 | NETWORK_SUBSCRIPTION_ID | VARCHAR2 | 400 | Y | ||
61 | ETF_DUE | NUMBER | 22 | Y | ||
62 | WORKORDER_STATUS | VARCHAR2 | 200 | Y | ||
63 | EXTERNAL_ID | VARCHAR2 | 120 | Y | ||
64 | SIGNUP_IP | VARCHAR2 | 80 | Y | ||
65 | REQUESTED_ICC | VARCHAR2 | 200 | Y | ||
66 | RNO_ID | VARCHAR2 | 400 | Y | ||
67 | CHANGE_PORTDATE_TO | DATE | 7 | Y | ||
68 | CUSTOMER_CITY | VARCHAR2 | 2000 | Y | ||
69 | CUSTOMER_POSTAL_CODE | VARCHAR2 | 400 | Y | ||
70 | CUSTOMER_ADDRESS | VARCHAR2 | 2000 | Y | ||
71 | CUSTOMER_FIRST_NAME | VARCHAR2 | 200 | Y | ||
72 | CUSTOMER_LAST_NAME | VARCHAR2 | 200 | Y | ||
73 | CUSTOMER_BIRTH_DATE | DATE | 7 | Y | ||
74 | PORTIER_ID | VARCHAR2 | 200 | Y | ||
75 | ANUMBER_ID | VARCHAR2 | 80 | Y | ||
76 | STATUS_CODE | VARCHAR2 | 40 | Y | ||
77 | DNO_ID | NUMBER | 22 | Y | ||
78 | PRODUCT_TYPE_ID | NUMBER | 22 | Y | ||
79 | CUSTOMER_STREET | VARCHAR2 | 200 | Y | ||
80 | CUSTOMER_ZIP | VARCHAR2 | 40 | Y | ||
81 | COMPANY_NAME | VARCHAR2 | 200 | Y | ||
82 | SUGGESTED_PORT_DATE | DATE | 7 | Y | ||
83 | RECEIVE_DATE | DATE | 7 | Y | ||
84 | MESSAGE_SENT_DATE | DATE | 7 | Y |
Contains all MNP Flows