| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 RY_DOC_VAR_ID |
Number(19,0) |
DECIMAL(19) NOT NULL |
Document Variant Id - RYEDOC_VAR
|
| 2 |
RY_MD_ID |
Number(18,0) |
DECIMAL(18) NOT NULL |
Metadata ID - Dialog document metadata table
|
| 3 |
RY_VARIANT_ID |
Number(4,0) |
SMALLINT NOT NULL |
Field used by Online Marketing.
|
| 4 |
RY_NAME254 |
Character(254) |
VARCHAR2(254) NOT NULL |
254 character name field for names.
|
| 5 |
DESCR254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Description of length 254
|
| 6 |
RY_DOC_TYPE |
Number(4,0) |
SMALLINT NOT NULL |
Document Type for Dialog Document, Either Email or Web
|
| 7 |
RY_LEFT_MARGIN |
Number(4,0) |
SMALLINT NOT NULL |
Field used by Online Marketing.
|
| 8 |
RY_TOP_MARGIN |
Number(4,0) |
SMALLINT NOT NULL |
Field used by Online Marketing.
|
| 9 |
RY_BACKGRND_COLOR |
Character(50) |
VARCHAR2(50) NOT NULL |
Field used by Online Marketing.
|
| 10 |
RY_BACKGRND_IMAGE |
Character(150) |
VARCHAR2(150) NOT NULL |
Field used by Online Marketing.
|
| 11 |
RY_TEXT_COLOR |
Character(50) |
VARCHAR2(50) NOT NULL |
Field used by Online Marketing.
|
| 12 |
RY_VISIT_LINK_CLR |
Character(50) |
VARCHAR2(50) NOT NULL |
Field used by Online Marketing.
|
| 13 |
RY_UNVISITLINK_CLR |
Character(50) |
VARCHAR2(50) NOT NULL |
Field used by Online Marketing.
|
| 14 |
RY_FROM_MAIL_ID |
Number(18,0) |
DECIMAL(18) NOT NULL |
Field used by Online Marketing.
|
| 15 |
RY_RPLY_MAIL_ID |
Number(18,0) |
DECIMAL(18) NOT NULL |
Field used by Online Marketing.
|
| 16 |
RY_BOUN_MAIL_ID |
Number(18,0) |
DECIMAL(18) NOT NULL |
Field used by Online Marketing.
|
| 17 |
RY_EMAIL_SUBJECT |
Character(254) |
VARCHAR2(254) NOT NULL |
OLM Email Document Subject Area
|
| 18 |
RY_LABEL_POSITION |
Character(1) |
VARCHAR2(1) NOT NULL |
Label Position Field - Dialog Document
A=Below
L=Right
R=Left
|
| 19 |
RY_LABEL_JUSTIFIC |
Character(1) |
VARCHAR2(1) NOT NULL |
Label Justification - Document Element
C=Center
L=Left
R=Right
|
| 20 |
LABEL_INDENTATION |
Number(4,0) |
SMALLINT NOT NULL |
Document Element Label Indentation Field
|
| 21 |
LABEL_FGRD_COLOR |
Character(4) |
VARCHAR2(4) NOT NULL |
Label Foreground Color - Document ELement
AQUA=Aqua
BLAK=Black
BLUE=Blue
DEFL=Default
FUSA=Fuchsia
GRAY=Gray
GREN=Green
LIME=Lime
MARO=Maroon
NAVY=Navy
OLIV=Olive
PURP=Purple
RED=Red
SILV=Silver
TEAL=Teal
WHTE=White
YELO=Yellow
|
| 22 |
LABEL_FONT_SIZE |
Signed Number(5,0) |
DECIMAL(4) NOT NULL |
Long Description for Label Font Size
|
| 23 |
LABEL_FONT_FACE |
Character(4) |
VARCHAR2(4) NOT NULL |
Label Font Type - Document ELement
ARBK=Arial Black
ARIA=Arial
ARNW=Arial Narrow
BOOS=Bookman Old Style
CORN=Courier New
CSMS=Comic Sans Ms
DEFL=Default
GARA=Garamond
HAET=Haettenschweiler
IMPT=Impact
LUCO=Lucinda Console
LUSU=Lucinda Sans Unicode
MAPS=Map Symbols
MODN=Modern
ROMN=Roman
SCRP=Script
TAHO=Tahoma
TIMR=Times New Roman
VERD=Verdana
|
| 24 |
LABEL_FONT_STYLE |
Character(2) |
VARCHAR2(2) NOT NULL |
LABEL_FONT_STYLE
0=Normal
1=Bold
2=Italics
3=Bold and Italics
|
| 25 |
RY_FLD_JUSTIFIC |
Character(1) |
VARCHAR2(1) NOT NULL |
Justify field for the Document
C=Center
L=Left
R=Right
|
| 26 |
RY_FLD_INDENTATION |
Number(4,0) |
SMALLINT NOT NULL |
Document Element Field Indentation
|
| 27 |
RY_FLD_FGRD_COLOR |
Character(4) |
VARCHAR2(4) NOT NULL |
Document Element Field Foreground Color.
AQUA=Aqua
BLAK=Black
BLUE=Blue
DEFL=Default
FUSA=Fuchsia
GRAY=Gray
GREN=Green
LIME=Lime
MARO=Maroon
NAVY=Navy
OLIV=Olive
PURP=Purple
RED=Red
SILV=Silver
TEAL=Teal
WHTE=White
YELO=Yellow
|
| 28 |
RY_FLD_FONT_STYLE |
Character(2) |
VARCHAR2(2) NOT NULL |
Field used by Online Marketing.
0=Normal
1=Bold
2=Italics
3=Bold and Italics
|
| 29 |
RY_FLD_FONT_SIZE |
Signed Number(5,0) |
DECIMAL(4) NOT NULL |
Field Font Size - Document Element
|
| 30 |
RY_FLD_FONT_FACE |
Character(4) |
VARCHAR2(4) NOT NULL |
Document Element Field Font Type
ARBK=Arial Black
ARIA=Arial
ARNW=Arial Narrow
BOOS=Bookman Old Style
CORN=Courier New
CSMS=Comic Sans Ms
DEFL=Default
GARA=Garamond
HAET=Haettenschweiler
IMPT=Impact
LUCO=Lucinda Console
LUSU=Lucinda Sans Unicode
MAPS=Map Symbols
MODN=Modern
ROMN=Roman
SCRP=Script
TAHO=Tahoma
TIMR=Times New Roman
VERD=Verdana
|
| 31 |
RY_FLD_WIDTH |
Number(4,0) |
SMALLINT NOT NULL |
Field Width - Document ELement Properties
|
| 32 |
RY_FLD_HEIGHT |
Number(4,0) |
SMALLINT NOT NULL |
Field Height - Document Element
|
| 33 |
ROW_ADDED_DTTM |
DateTime(26) |
TIMESTAMP |
This is a datetime field for record creation.
|
| 34 |
ROW_ADDED_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who added the row.
|
| 35 |
ROW_LASTMANT_DTTM |
DateTime(26) |
TIMESTAMP |
The date and time that the row was last updated.
|
| 36 |
ROW_LASTMANT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who last modified the row.
|
| 37 |
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.
|
| 38 |
SYNCDTTM |
DateTime(26) |
TIMESTAMP |
Synchronization Last Update Date Time
|