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