{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
Col #
Column Name
Data Type
Field Length
Not Null?
Data Def.
Comments
1
ID
NUMBER
22
N
Primary key
2
CODE
VARCHAR2
20
Y
3
TIME_STAMP
DATE
7
Y
4
READ_DATE
DATE
7
Y
5
STATUS_ID
NUMBER
22
Y
6
PHONE_NUMBER
VARCHAR2
20
Y
7
PORTIER_ID
VARCHAR2
30
Y
8
PORT_DATE
DATE
7
Y
9
SUGGESTED_PORT_DATE
DATE
7
Y
10
FIRST_NAME
VARCHAR2
100
Y
11
LAST_NAME
VARCHAR2
100
Y
12
BIRTH_DATE
DATE
7
Y
13
COMPANY_NAME
VARCHAR2
100
Y
14
STREET
VARCHAR2
100
Y
15
ZIP
VARCHAR2
10
Y
16
CITY
VARCHAR2
100
Y
17
CUSTOMER_NUMBER
VARCHAR2
30
Y
18
MESSAGE
VARCHAR2
4000
Y
19
FREE_TEXT
VARCHAR2
1000
Y
20
VERSION
VARCHAR2
10
Y
21
STATUS
VARCHAR2
4
Y
22
RSP
VARCHAR2
10
Y
23
DSP
VARCHAR2
10
Y
24
RNO
VARCHAR2
10
Y
25
DNO
VARCHAR2
10
Y
26
FILENAME
VARCHAR2
200
Y
27
MNP_REFERENCE_ID
NUMBER
22
Y
28
WORKFLOW_ID
NUMBER
22
Y
29
NP_FLOW_ID
NUMBER
22
Y
30
TYPE
VARCHAR2
10
Y
31
ICC
VARCHAR2
100
Y
32
TRANSACTION_ID
VARCHAR2
10
Y
33
REJECT_CODE
NUMBER
22
Y
34
PORTING_ORDER_REFERENCE
VARCHAR2
50
Y
Column
width
33%
Holds messages retrieved from a porting authority or sent by Rator with text. Not used in the NRDB process.