# |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
1 |
RY_MSG_ID |
Number(18,0) |
DECIMAL(18) NOT NULL |
Field used by Online Marketing.
|
2 |
RY_MSG_PROTOCOL |
Character(4) |
VARCHAR2(4) NOT NULL |
Field used by Online Marketing.
|
3 |
RY_MSG_SYNC |
Character(1) |
VARCHAR2(1) NOT NULL |
Field used by Online Marketing.
|
4 |
RY_MSG_OP |
Character(4) |
VARCHAR2(4) NOT NULL |
Field used by Online Marketing.
|
5 |
RY_MSG_SENDER |
Character(30) |
VARCHAR2(30) NOT NULL |
Field used by Online Marketing.
|
6 |
RY_MSG_RESPONDER |
Character(30) |
VARCHAR2(30) NOT NULL |
Field used by Online Marketing.
|
7 |
RY_MSG_OBJ_OP |
Character(4) |
VARCHAR2(4) NOT NULL |
Field used by Online Marketing.
|
8 |
RY_MSG_OBJ |
Character(4) |
VARCHAR2(4) NOT NULL |
Field used by Online Marketing.
|
9 |
RY_MSG_OBJ_ID |
Number(18,0) |
DECIMAL(18) NOT NULL |
Field used by Online Marketing.
|
10 |
RY_MSG_OBJ_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Field used by Online Marketing.
|
11 |
RY_MSG_STATUS |
Character(4) |
VARCHAR2(4) NOT NULL |
Field used by Online Marketing.
|
12 |
RY_MSG_RESP_STS |
Character(4) |
VARCHAR2(4) NOT NULL |
Field used by Online Marketing.
|
13 |
RY_MSG_RESP_CODE |
Character(4) |
VARCHAR2(4) NOT NULL |
Field used by Online Marketing.
|
14 |
DESCR254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Description of length 254
|
15 |
RY_MSG_DTTM |
DateTime(26) |
TIMESTAMP |
Field used by Online Marketing.
|
16 |
RY_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Field used by Online Marketing.
|