Groups
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 |
Holds messages retrieved from a porting authority or sent by Rator with text. Not used in the NRDB process.