| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 RB_SMS_REQST_ID |
Character(36) |
VARCHAR2(36) NOT NULL |
SMS Request ID
Default Value: NEXT
|
| 2 |
RB_SMS_REQST_SRC |
Character(18) |
VARCHAR2(18) NOT NULL |
SMS request source application code
|
| 3 |
RB_LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
ARA=Arabic
CFR=Canadian French
CZE=Czech
DAN=Danish
DUT=Dutch
ENG=English
ESP=Spanish
FIN=Finnish
FRA=French
GER=German
GRK=Greek
HEB=Hebrew
HUN=Hungarian
ITA=Italian
JPN=Japanese
KOR=Korean
MAY=Bahasa Malay
NOR=Norwegian
POL=Polish
POR=Portuguese
RUS=Russian
SVE=Swedish
THA=Thai
TUR=Turkish
ZHS=Simplified Chinese
ZHT=Traditional Chinese
Default Value: ENG
Prompt Table:
RY_DOC_LANG_VW
|
| 4 |
RB_SMSREQST_STATUS |
Character(4) |
VARCHAR2(4) NOT NULL |
Short Massage Request Status
CNCL=Canceled
COMP=Completed
FAIL=Failed
NEW=New
SBMT=Submitted
SCHD=Scheduled
Default Value: NEW
|
| 5 |
RB_PROCESSING_MODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Processing Mode - indicates processing mode:
0 - Foreground (Synchronous)
1 - Background (Asynchronous)
0=Foreground
1=Background and Sending
Default Value: 0
|
| 6 |
RB_SMS_ERROR_MSG |
Character(254) |
VARCHAR2(254) NOT NULL |
Field used by Online Marketing.
|
| 7 |
RB_SMS_TMPL_ID |
Number(18,0) |
DECIMAL(18) NOT NULL |
SMS Template ID
|
| 8 |
RB_SMS_MSG_CONTENT |
Character(160) |
VARCHAR2(160) NOT NULL |
Short Text Message content
|
| 9 |
RB_SMS_SEND_OPTN |
Character(4) |
VARCHAR2(4) NOT NULL |
Short Message Send options
IMDT=Send Immediately
LATE=Send Later
Default Value: IMDT
|
| 10 |
SEND_DATE |
Date(10) |
DATE |
Correspondence Send Date
|
| 11 |
SEND_TIME |
Time(15) |
TIMESTAMP |
Correspondence Send Time
|
| 12 |
DESCR254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Description of length 254
|
| 13 |
ROW_ADDED_DTTM |
DateTime(26) |
TIMESTAMP |
This is a datetime field for record creation.
|
| 14 |
ROW_ADDED_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who added the row.
|
| 15 |
ROW_LASTMANT_DTTM |
DateTime(26) |
TIMESTAMP |
The date and time that the row was last updated.
|
| 16 |
ROW_LASTMANT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who last modified the row.
|
| 17 |
SYNCID |
Number(10,0) |
DECIMAL(10) NOT NULL |
The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
|
| 18 |
SYNCDTTM |
DateTime(26) |
TIMESTAMP |
Synchronization Last Update Date Time
|