Versions Compared

Old Version 2

changes.mady.by.user Søren Duusgaard (Deactivated)

Saved on

compared with

New Version Current

changes.mady.by.user Søren Duusgaard (Deactivated)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Section
Column
width33%

Groups

Wiki Markup
{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
width33%

NP_FLOW

SIGNUP_IP301022

Col #

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

20

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 number10

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 ok11

16

AUTH_REF

VARCHAR2

120

Y

  

17

CASE_NUMBER

NUMBER

22

Y

 NP case number12

18

REJECT_CODE

VARCHAR2

10

40

Y

 Reject code13

19

NPFERD_DATE

DATE

7

Y

  

20

TERMINATION_DATE

DATE

7

Y

 Date of terminating number14

21

MANUAL

NUMBER

22

Y

  

22

CODE

VARCHAR2

20

80

Y

 NP code, refers to implementation class15

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-table16

26

PORT_TYPE_ID

NUMBER

22

Y

 NP type: 0-import, 2-export17

27

NEW_PRODUCT_ID

NUMBER

22

Y

 New product ID, references PRODUCT-table18

28

PRINT_LETTER_EXTERN

VARCHAR2

4

Y

  

29

CASE_STATUS_ID

NUMBER

22

Y

 NP case status, 1-case active, 2-case unactive19

30

OLD_SIMCARD_ID

NUMBER

22

Y

 Old SIM card id, references SIMCARD-table20

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 rejection21

40

KEEP_SUB

VARCHAR2

4

Y

  

41

FIRST_NAME

VARCHAR2

80

128

Y

 

Signup IP address

22

PORTING_ID

VARCHAR2

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

 

Porting ID

23

ACCOUNT_PAY_TYPE

VARCHAR2

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

 Account payment type24

PHONE_NUMBER_FLAG

NUMBER

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

  25

54

ACCOUNT

TEMP_NUMBER

VARCHAR2

80

Y

  

55

PREPAID_ICC

VARCHAR2

120

Y

  

56

WISH_DATE

DATE

7

Y

  

57

RENEW_NOTE

VARCHAR2

4000

Y

  Account number
26

ACCOUNT_IDENTIFIER

VARCHAR2

120

Y

 Account name
27

CORPORATE_REG_NUMBER

VARCHAR2

120

Y

 Corporation registration number
28

CORPORATE_CONTACT_PERSON

VARCHAR2

120

Y

 Corporate contact person
29

CORPORATE_CONTACT_PHONE

VARCHAR2

120

Y

 Corporate contact phone

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

DATE7  With 9.9
86ERROR_CODEVARCHAR210Y With 9.9
87ERROR_DESCRIPTIONVARCHAR2250Y With 9.9
88COMMENTSVARCHAR24000Y With 9.9
89REJECT_DATEDATE7Y With 9.9
91BIRTH_DATEDATE7Y With 9.9
Column
width33%

Contains all MNP Flows.