| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 RY_INSTANCE_ID |
Number(4,0) |
SMALLINT NOT NULL |
Runtime Mail Engine Instance ID
|
| 2 |
RY_INSTANCE_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Field used by Online Marketing.
DES=Dialog Execution Server
ERP=E-mail Response Processor
MAIL=Mail Service
MCR=Broadcaster E-mail Server
SMR=Single E-mailer Server
WDG=Watch Dog
|
| 3 |
SERVERNAME |
Character(8) |
VARCHAR2(8) NOT NULL |
Server Name
Prompt Table:
RY_SERVERS_VW
|
| 4 |
RY_HOSTNAME |
Character(254) |
VARCHAR2(254) NOT NULL |
Field used by Online Marketing.
|
| 5 |
RY_HOST_IP |
Character(30) |
VARCHAR2(30) NOT NULL |
Field used by Online Marketing.
|
| 6 |
RY_START_DTTM |
DateTime(26) |
TIMESTAMP |
Field used by Online Marketing.
|
| 7 |
RY_LAST_DTTM |
DateTime(26) |
TIMESTAMP |
Field used by Online Marketing.
Default Value: %Datetime
|
| 8 |
RY_INSTANCE_STATUS |
Character(4) |
VARCHAR2(4) NOT NULL |
Field used by Online Marketing.
RUNG=Running
STOP=Stopped
Default Value: STOP
|
| 9 |
RY_COMMENT |
Character(4) |
VARCHAR2(4) NOT NULL |
Field used by Online Marketing.
ABRT=Timed out or killed
CRFL=Create Failed
CRRQ=Create Requested
CRSC=Create Successful
DELR=Delete Requested
DOWN=Shutdown normally
INIT=Initializing
RUNF=Run Request Failed
RUNR=Run Requested
SHUT=Shutting down
STPF=Stop Request Failed
STPR=Stop Requested
UNKN=Unknown
UP=fully functional
Default Value: CRRQ
|