| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EODI_DYN_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Display ID
|
| 2 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table:
%EDITTABLE
|
| 3 |
EODI_DYN_POSX |
Number(4,0) |
SMALLINT NOT NULL |
X Position
|
| 4 |
EODI_DYN_POSY |
Number(4,0) |
SMALLINT NOT NULL |
Y Position
|
| 5 |
EODI_DYN_POS_ROW |
Character(3) |
VARCHAR2(3) NOT NULL |
Row
1=1
|
| 6 |
EODI_DYN_POS_COL |
Character(3) |
VARCHAR2(3) NOT NULL |
Column
1=1
|
| 7 |
SEQNBR |
Number(5,0) |
INTEGER NOT NULL |
Sequence Number
Default Value: 1
|
| 8 |
EODI_FIELD_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Field Type
A=Checkbox
B=Button
C=Chart
D=Date
E=Date & Time
F=Radio Button
G=Grid
H=Hyperlink
I=Image
J=Group Box Section
K=Empty
L=Separator Line
M=Time
N=Number
O=Rich Text Display
R=Tree
S=Collapsible Section
T=Text
X=Drop-Down List Box
Y=Section End
Z=HTML Area
Default Value: T
|
| 9 |
EODI_FIELD_MASK |
Character(254) |
VARCHAR2(254) NOT NULL |
Field Mask
|
| 10 |
EODI_COLLAPSED |
Character(1) |
VARCHAR2(1) NOT NULL |
Section Collapsed
Y/N Table Edit
Default Value: Y
|
| 11 |
LENGTH |
Number(5,0) |
INTEGER NOT NULL |
Length
|
| 12 |
DECIMALPOS |
Number(2,0) |
SMALLINT NOT NULL |
Decimal Positions
|
| 13 |
EDITTABLE |
Character(15) |
VARCHAR2(15) NOT NULL |
Edit Table
Prompt Table:
PSRECDEFN
|
| 14 |
EODI_DYN_PRMPTEDIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Edit Field Flag
Y/N Table Edit
Default Value: N
|
| 15 |
EODI_DYN_LBLTEXT |
Character(100) |
VARCHAR2(100) NOT NULL |
Label Text
|
| 16 |
EODI_DYN_LBLTYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Label Type
L=RFT Long
M=Message Catalog
N=None
S=RFT Short
T=Text
Default Value: L
|
| 17 |
LABEL_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
LABEL_ID identifies uniquness of DB Field Labels.
This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.
Prompt Table:
EODI_DBFLDL_VW
|
| 18 |
EODI_DYN_EVENT_FC |
Character(1) |
VARCHAR2(1) NOT NULL |
Field Change Event Flag
Y/N Table Edit
Default Value: N
|
| 19 |
EODI_VISIBLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Visible Flag
Y/N Table Edit
Default Value: Y
|
| 20 |
EODI_DISPLAY_ONLY |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Only Flag
Y/N Table Edit
Default Value: N
|
| 21 |
EODI_XFR_PROC_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Transfer Process ID
Prompt Table:
EODI_XFR_REG
|
| 22 |
EODI_DYN_BTN_ACTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Button Action
C=Capture Document Contents
D=File/Document Download
I=Insert Into Current Document
N=None
S=Capture Document Selection
U=File/Document Upload
Default Value: N
|
| 23 |
EODI_DYN_HEIGHT |
Number(4,0) |
SMALLINT NOT NULL |
Height
|
| 24 |
EODI_DYN_WIDTH |
Number(4,0) |
SMALLINT NOT NULL |
Pane Width
|
| 25 |
EODI_DYN_LBL_WIDTH |
Number(3,0) |
SMALLINT NOT NULL |
Label Width
|
| 26 |
MESSAGE_SET_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Set Number. This field refers to the Message Set Number in the Message Catalog.
Prompt Table:
PSMSGSETDEFN
|
| 27 |
MESSAGE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
Prompt Table:
PSMSGCATDEFN
|
| 28 |
EODI_LBLFOREGROUND |
Character(15) |
VARCHAR2(15) NOT NULL |
Foreground Color
|
| 29 |
EODI_LBLBACKGROUND |
Character(15) |
VARCHAR2(15) NOT NULL |
Background Color
|
| 30 |
EODI_PAD_LEFT |
Number(3,0) |
SMALLINT NOT NULL |
Pad Left
Default Value: 0
|
| 31 |
EODI_PAD_RIGHT |
Number(3,0) |
SMALLINT NOT NULL |
Pad Right
Default Value: 0
|
| 32 |
EODI_FOREGROUND |
Character(15) |
VARCHAR2(15) NOT NULL |
Foreground Color
|
| 33 |
EODI_BACKGROUND |
Character(15) |
VARCHAR2(15) NOT NULL |
Background Color
|
| 34 |
EODI_TAG |
Character(100) |
VARCHAR2(100) NOT NULL |
Tag
|
| 35 |
CONTNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Content Name
Prompt Table:
EODI_IMAGES_VW
|
| 36 |
EODI_DATETIME |
DateTime(26) |
TIMESTAMP |
Date/Time
|
| 37 |
EODI_DATE |
DateTime(26) |
TIMESTAMP |
Date
|
| 38 |
EODI_TIME |
DateTime(26) |
TIMESTAMP |
Time
|
| 39 |
EODI_TEXT |
Long Character |
CLOB |
Generic Text Field
|