# |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
1 |
RY_RECORD_ID |
Number(18,0) |
DECIMAL(18) NOT NULL |
Field used by Online Marketing.
|
2 |
RY_IND_ID |
Number(18,0) |
DECIMAL(18) NOT NULL |
Field used by Online Marketing.
|
3 |
RY_ACTION_ID |
Number(18,0) |
DECIMAL(18) NOT NULL |
Id for a dialog element for the dialog designer.
|
4 |
RY_LIST_ID |
Number(18,0) |
DECIMAL(18) NOT NULL |
Audience ID for Dialogs, used in the dialog designer.
|
5 |
ROW_ADDED_DTTM |
DateTime(26) |
TIMESTAMP |
This is a datetime field for record creation.
|
6 |
RY_VC_REFER_ID |
Number(18,0) |
DECIMAL(18) NOT NULL |
Field used by Online Marketing.
|
7 |
RY_PRNT_VC_REF_ID |
Number(18,0) |
DECIMAL(18) NOT NULL |
Field used by Online Marketing.
|
8 |
RY_SR_ACTION_ID |
Number(18,0) |
DECIMAL(18) NOT NULL |
Field used by Online Marketing.
|
9 |
REPEAT_SEQ_NUMBER |
Number(18,0) |
DECIMAL(18) NOT NULL |
Repeat Number
|
10 |
DEFLT_IMPRESS_CODE |
Character(100) |
VARCHAR2(100) NOT NULL |
Default Impression Code
|
11 |
RY_MERGE_FLD_ID |
Number(18,0) |
DECIMAL(18) NOT NULL |
Field used by Online Marketing.
|
12 |
EXTERN_CONT_ID |
Character(100) |
VARCHAR2(100) NOT NULL |
External Content ID
|
13 |
OPTIONAL_ID_1 |
Character(100) |
VARCHAR2(100) NOT NULL |
OPTIONAL_ID_1
|
14 |
OPTIONAL_ID_2 |
Character(100) |
VARCHAR2(100) NOT NULL |
OPTIONAL_ID_2
|
15 |
OPTIONAL_ID_3 |
Character(100) |
VARCHAR2(100) NOT NULL |
OPTIONAL_ID_3
|