NP_FLOW

Groups

Unknown macro: {float}

NP_FLOW

Col #	Column Name	Data Type	Field Length	Null?	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	128	Y	With 9.9 - from 512 to 128
42	LAST_NAME	VARCHAR2	128	Y	With 9.9 - from 512 to 128
43	STREET	VARCHAR2	128	Y	With 9.9 - from 512 to 128
44	HOUSE_NUMBER	NUMBER	22	Y
45	HOUSE_EXTENSION	VARCHAR2	512	Y
46	ZIP	VARCHAR2	128	Y	With 9.9 - from 512 to 128
47	CITY	VARCHAR2	128	Y	With 9.9 - from 512 to 128
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	50	Y	With 9.9 - from 200 to 50
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	NUMBER	22	Y	With 9.9 - from VARCHAR to NUMBER
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	50	Y	With 9.9 - from 200 to 50 chars
82	SUGGESTED_PORT_DATE	DATE	7	Y
83	RECEIVE_DATE	DATE	7	Y
84	MESSAGE_SENT_DATE	DATE	7	Y
85	CREATE_DATE	DATE	7		With 9.9
86	ERROR_CODE	VARCHAR2	10	Y	With 9.9
87	ERROR_DESCRIPTION	VARCHAR2	250	Y	With 9.9
88	COMMENTS	VARCHAR2	4000	Y	With 9.9
89	REJECT_DATE	DATE	7	Y	With 9.9
90	CANCEL_DATE	DATE	7	Y	With 9.9
91	BIRTH_DATE	DATE	7	Y	With 9.9

Contains all MNP Flows.