Comment:
Migration of unmigrated content due to installation of a new plugin
Section
Column
width
33%
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
width
33%
NP_MESSAGE
Column Name
Data Type
Field Length
Not Null?
Data Def.
Comments
ID
NUMBER
22
N
Primary key
CODE
VARCHAR2
20
Y
TIME_STAMP
DATE
7
Y
READ_DATE
DATE
7
Y
STATUS_ID
NUMBER
22
Y
PHONE_NUMBER
VARCHAR2
20
Y
PORTIER_ID
VARCHAR2
30
Y
PORT_DATE
DATE
7
Y
SUGGESTED_PORT_DATE
DATE
7
Y
FIRST_NAME
VARCHAR2
100
Y
LAST_NAME
VARCHAR2
100
Y
BIRTH_DATE
DATE
7
Y
COMPANY_NAME
VARCHAR2
100
Y
STREET
VARCHAR2
100
Y
ZIP
VARCHAR2
10
Y
CITY
VARCHAR2
100
Y
CUSTOMER_NUMBER
VARCHAR2
30
Y
MESSAGE
VARCHAR2
4000
Y
FREE_TEXT
VARCHAR2
1000
Y
VERSION
VARCHAR2
10
Y
STATUS
VARCHAR2
4
Y
RSP
VARCHAR2
10
Y
DSP
VARCHAR2
10
Y
RNO
VARCHAR2
10
Y
DNO
VARCHAR2
10
Y
FILENAME
VARCHAR2
200
Y
MNP_REFERENCE_ID
NUMBER
22
Y
WORKFLOW_ID
NUMBER
22
Y
NP_FLOW_ID
NUMBER
22
Y
TYPE
VARCHAR2
10
Y
ICC
VARCHAR2
100
Y
TRANSACTION_ID
VARCHAR2
10
Y
REJECT_CODE
NUMBER
22
Y
PORTING_ORDER_REFERENCE
VARCHAR2
50
Y
TRIES
NUMBER
Vs. 10
Column
width
33%
Holds messages retrieved from a porting authority or sent by Rator with text. Not used in the NRDB process.