| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 RY_MD_ELEM_ID |
Number(18,0) |
DECIMAL(18) NOT NULL |
Metadata Element ID - Dialog Document
|
| 2 |
RY_VARIANT_ID |
Number(4,0) |
SMALLINT NOT NULL |
Field used by Online Marketing.
|
| 3 |
PRESENTATION_TYPE |
Number(4,0) |
SMALLINT NOT NULL |
PRESENTATION_TYPE
|
| 4 |
ELEM_INDEX |
Number(4,0) |
SMALLINT NOT NULL |
Enter a positive integer
|
| 5 |
ELEM_GROUP_ID |
Number(18,0) |
DECIMAL(18) NOT NULL |
ELEM_GROUP_ID
|
| 6 |
ELEM_DETAIL |
Character(254) |
VARCHAR2(254) NOT NULL |
Document Element Detail - hold long description of the element
|
| 7 |
ELEM_DETAIL_A |
Character(254) |
VARCHAR2(254) NOT NULL |
Document Element Detail, hold long description of the element
|
| 8 |
ELEM_DETAIL_BOOL |
Character(1) |
VARCHAR2(1) NOT NULL |
ELEM_DETAIL_BOOL
|
| 9 |
VALIDATION_RULE |
Character(1) |
VARCHAR2(1) NOT NULL |
VALIDATION_RULE
|
| 10 |
IS_REQUIRED |
Character(1) |
VARCHAR2(1) NOT NULL |
IS_REQUIRED
|
| 11 |
RY_ACT |
Character(1) |
VARCHAR2(1) NOT NULL |
Field used by Online Marketing.
A=Auto-Submit
B=Submit & Clear
C=Clear
P=Special
S=Submit
|
| 12 |
ACT_DETAIL |
Character(254) |
VARCHAR2(254) NOT NULL |
ACT_DETAIL
|
| 13 |
RY_ROW_NUMBER |
Number(12,0) |
DECIMAL(12) NOT NULL |
Field used by Online Marketing.
|
| 14 |
RY_COLUMN_NUMBER |
Number(4,0) |
SMALLINT NOT NULL |
Field used by Online Marketing.
|
| 15 |
LABEL_TEXT |
Character(254) |
VARCHAR2(254) NOT NULL |
Activity Name
|
| 16 |
RY_LABEL_POSITION |
Character(1) |
VARCHAR2(1) NOT NULL |
Label Position Field - Dialog Document
A=Below
L=Right
R=Left
|
| 17 |
RY_LABEL_JUSTIFIC |
Character(1) |
VARCHAR2(1) NOT NULL |
Label Justification - Document Element
C=Center
L=Left
R=Right
|
| 18 |
LABEL_INDENTATION |
Number(4,0) |
SMALLINT NOT NULL |
Document Element Label Indentation Field
|
| 19 |
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
|
| 20 |
LABEL_FONT_SIZE |
Signed Number(5,0) |
DECIMAL(4) NOT NULL |
Long Description for Label Font Size
|
| 21 |
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
|
| 22 |
LABEL_FONT_STYLE |
Character(2) |
VARCHAR2(2) NOT NULL |
LABEL_FONT_STYLE
0=Normal
1=Bold
2=Italics
3=Bold and Italics
|
| 23 |
RY_FLD_JUSTIFIC |
Character(1) |
VARCHAR2(1) NOT NULL |
Justify field for the Document
C=Center
L=Left
R=Right
|
| 24 |
RY_FLD_INDENTATION |
Number(4,0) |
SMALLINT NOT NULL |
Document Element Field Indentation
|
| 25 |
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
|
| 26 |
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
|
| 27 |
RY_FLD_FONT_SIZE |
Signed Number(5,0) |
DECIMAL(4) NOT NULL |
Field Font Size - Document Element
|
| 28 |
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
|
| 29 |
RY_FLD_WIDTH |
Number(4,0) |
SMALLINT NOT NULL |
Field Width - Document ELement Properties
|
| 30 |
RY_FLD_HEIGHT |
Number(4,0) |
SMALLINT NOT NULL |
Field Height - Document Element
|
| 31 |
IS_TAB |
Character(1) |
VARCHAR2(1) NOT NULL |
IS_TAB
|
| 32 |
TAB_ORDER |
Number(4,0) |
SMALLINT NOT NULL |
TAB_ORDER
|
| 33 |
RY_CHOICE_STYLE |
Character(4) |
VARCHAR2(4) NOT NULL |
Choice Element Style Field - Dialog Document
CBOX=Check Box
DLST=Drop List
LBOX=List Box
RADB=Radio Button
|
| 34 |
IS_PROMPT_VISIBLE |
Character(1) |
VARCHAR2(1) NOT NULL |
IS_PROMPT_VISIBLE
|
| 35 |
FLOW_COLUMNS |
Number(4,0) |
SMALLINT NOT NULL |
Number of Columns
|
| 36 |
IS_PROF_FOR_DEFLT |
Character(1) |
VARCHAR2(1) NOT NULL |
IS_PROF_FOR_DEFLT
|
| 37 |
FORMAT_PROMPT |
Character(20) |
VARCHAR2(20) NOT NULL |
FORMAT_PROMPT
|
| 38 |
RY_DISPLAY_SCALE |
Character(1) |
VARCHAR2(1) NOT NULL |
Horizontal Display : display numeric scale
Y/N Table Edit
Default Value: N
|
| 39 |
RY_QUESTION_WEIGHT |
Signed Number(3,0) |
DECIMAL(2) NOT NULL |
Survey Document quesion weight
|
| 40 |
RY_ELEM_SCALE_Y |
Number(4,0) |
SMALLINT NOT NULL |
Scale value for booleam element Yes.
|
| 41 |
RY_ELEM_SCALE_N |
Number(4,0) |
SMALLINT NOT NULL |
Scale value for booleam element No.
|
| 42 |
RY_ELEM_WEIGHT_Y |
Signed Number(3,0) |
DECIMAL(2) NOT NULL |
Weight value for booleam element Yes.
|
| 43 |
RY_ELEM_WEIGHT_N |
Signed Number(3,0) |
DECIMAL(2) NOT NULL |
Weight value for booleam element No.
|
| 44 |
ROW_ADDED_DTTM |
DateTime(26) |
TIMESTAMP |
This is a datetime field for record creation.
|
| 45 |
ROW_ADDED_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who added the row.
|
| 46 |
ROW_LASTMANT_DTTM |
DateTime(26) |
TIMESTAMP |
The date and time that the row was last updated.
|
| 47 |
ROW_LASTMANT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who last modified the row.
|
| 48 |
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.
|
| 49 |
SYNCDTTM |
DateTime(26) |
TIMESTAMP |
Synchronization Last Update Date Time
|