EODI_DYN(SQL Table) |
Index Back |
|---|---|
Dynamic Display InfoDynamic Display Info |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(15) | VARCHAR2(15) NOT NULL | Display ID | |
| 2 | OBJECTOWNERID | Character(4) | VARCHAR2(4) NOT NULL | Object owner identifier |
| 3 | EODI_RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Recname
Prompt Table: EODI_DYN_REC_VW |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | EODI_DYN_PRIORITY | Number(3,0) | SMALLINT NOT NULL | Display Priority |
| 6 | EODI_DISABLED | Character(1) | VARCHAR2(1) NOT NULL |
Disabled
Y/N Table Edit Default Value: N |
| 7 | EODI_REFRESH_RATE | Number(9,0) | DECIMAL(9) NOT NULL |
Automatic Refresh Rate
Default Value: 0 |
| 8 | EODI_SAVE_USR_PREF | Character(1) | VARCHAR2(1) NOT NULL |
Save User Settings
Y/N Table Edit Default Value: Y |
| 9 | EODI_SCROLL_H | Character(1) | VARCHAR2(1) NOT NULL |
Enable Horizontal Scrollbar
Y/N Table Edit Default Value: Y |
| 10 | EODI_SCROLL_V | Character(1) | VARCHAR2(1) NOT NULL |
Enable Vertical Scrollbar
Y/N Table Edit Default Value: N |
| 11 | EODI_TIMEZONE | Character(1) | VARCHAR2(1) NOT NULL |
Enable Timezone
Y/N Table Edit Default Value: Y |
| 12 | EODI_DYN_TYPE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Display Type
A=Automatic D=On Request Default Value: D |
| 13 | EODI_DYN_WORD_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Display In Microsoft Word
Y/N Table Edit Default Value: N |
| 14 | EODI_DYN_OMAIL_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Display in EMAIL flag
Y/N Table Edit Default Value: N |
| 15 | EODI_DYN_OHOME_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Display in EMAIL flag
Y/N Table Edit Default Value: N |
| 16 | EODI_DYN_OSCHD_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Display in EMAIL flag
Y/N Table Edit Default Value: N |
| 17 | EODI_DYN_OTSK_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Display In task Flag
Y/N Table Edit Default Value: N |
| 18 | EODI_DYN_OCON_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Display In Contacts Flag
Y/N Table Edit Default Value: N |
| 19 | EODI_DYN_OAPT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Appointment Flag
Y/N Table Edit Default Value: N |
| 20 | EODI_DOC_MODE | Character(1) | VARCHAR2(1) NOT NULL |
Email display mode
B=Read and Compose C=Compose R=Read Default Value: B |
| 21 | EODI_DISPLAY_POS | Character(1) | VARCHAR2(1) NOT NULL |
Display Position
B=Bottom F=Floating L=Left R=Right T=Top Default Value: R |
| 22 | EODI_DISP_RESTRICT | Character(1) | VARCHAR2(1) NOT NULL |
Display Restriction
F=Frozen H=No Horizontal N=None V=No Vertical Default Value: N |
| 23 | EODI_DYN_LAYOUT | Character(1) | VARCHAR2(1) NOT NULL |
Layout Mode
A=Automatic C=Custom Default Value: A |
| 24 | EODI_WIDTH | Number(4,0) | SMALLINT NOT NULL |
Width
Default Value: 300 |
| 25 | EODI_HEIGHT | Number(4,0) | SMALLINT NOT NULL |
Height
Default Value: 300 |
| 26 | EODI_EVENT_CLOSE | Character(1) | VARCHAR2(1) NOT NULL |
Document Close
Y/N Table Edit Default Value: N |
| 27 | EODI_EVENT_DELETE | Character(1) | VARCHAR2(1) NOT NULL |
Document Delete
Y/N Table Edit Default Value: N |
| 28 | EODI_EVENT_SAVE | Character(1) | VARCHAR2(1) NOT NULL |
Document Save
Y/N Table Edit Default Value: N |
| 29 | EODI_DYN_LBL_WIDTH | Number(3,0) | SMALLINT NOT NULL |
Label Width
Default Value: 100 |
| 30 | EODI_DYN_COLS | Number(3,0) | SMALLINT NOT NULL |
Number of columns
Default Value: 1 |
| 31 | EODI_COL_WIDTH | Number(4,0) | SMALLINT NOT NULL |
Width
Default Value: 300 |
| 32 | EODI_DYN_ROWS | Number(6,0) | INTEGER NOT NULL |
Row Number
Default Value: 15 |
| 33 | EODI_ROW_HEIGHT | Number(3,0) | SMALLINT NOT NULL |
Row Height
Default Value: 20 |
| 34 | EODI_PACKAGE_NAME | Character(30) | VARCHAR2(30) NOT NULL |
Package Name
Prompt Table: EODI_PACKAGE_VW |
| 35 | EODI_PATH | Character(127) | VARCHAR2(127) NOT NULL |
Path
Prompt Table: EODI_PATH_VW |
| 36 | EODI_CLASS_ID | Character(30) | VARCHAR2(30) NOT NULL | Class ID |