| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EODI_XFR_TRANS_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Transfer ID
|
| 2 |
EODI_DYN_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Display ID
|
| 3 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table:
EODI_DYN_FLD_VW
|
| 4 |
EODI_DYN_POSX |
Number(4,0) |
SMALLINT NOT NULL |
X Position
|
| 5 |
EODI_DYN_POSY |
Number(4,0) |
SMALLINT NOT NULL |
Y Position
|
| 6 |
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
|
| 7 |
LENGTH |
Number(5,0) |
INTEGER NOT NULL |
Length
|
| 8 |
DECIMALPOS |
Number(2,0) |
SMALLINT NOT NULL |
Decimal Positions
|
| 9 |
EDITTABLE |
Character(15) |
VARCHAR2(15) NOT NULL |
Edit Table
Prompt Table:
PSRECDEFN
|
| 10 |
EODI_DYN_LBLTEXT |
Character(100) |
VARCHAR2(100) NOT NULL |
Label Text
|
| 11 |
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
|
| 12 |
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
|
| 13 |
EODI_DYN_EVENT_FC |
Character(1) |
VARCHAR2(1) NOT NULL |
Field Change Event Flag
Y/N Table Edit
Default Value: N
|
| 14 |
EODI_VISIBLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Visible Flag
Y/N Table Edit
Default Value: Y
|
| 15 |
EODI_DISPLAY_ONLY |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Only Flag
Y/N Table Edit
Default Value: N
|
| 16 |
EODI_XFR_PROC_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Transfer Process ID
Prompt Table:
EODI_XFR_REG
|
| 17 |
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
|
| 18 |
EODI_DYN_HEIGHT |
Number(4,0) |
SMALLINT NOT NULL |
Height
|
| 19 |
EODI_DYN_WIDTH |
Number(4,0) |
SMALLINT NOT NULL |
Pane Width
|
| 20 |
EODI_DYN_LBL_WIDTH |
Number(3,0) |
SMALLINT NOT NULL |
Label Width
|
| 21 |
EODI_DATE |
DateTime(26) |
TIMESTAMP |
Date
|
| 22 |
EODI_TEXT |
Long Character |
CLOB |
Generic Text Field
|