| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PNLGRPNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Component Name
Prompt Table:
EOCF_PNLGRP_VW
|
| 2 |
MARKET |
Character(3) |
VARCHAR2(3) NOT NULL |
Market
Default Value: GBL
|
| 3 |
PNLNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Panel Name (see PSPNLDEFN).
Prompt Table:
PSPNLGROUP_VW
|
| 4 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
|
| 5 |
EOCF_FLT_PERS_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow User Personalization?
Y/N Table Edit
Default Value: Y
|
| 6 |
EOCF_FLT_SAVE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Saved Filter Option
N=No
Y=Yes
Default Value: Y
|
| 7 |
EOCF_FLT_FLDS_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Filter Field Option
N=No
Y=Yes
Default Value: Y
|
| 8 |
EOCF_FLT_FILL_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Filter Options
D=Default
L=Last
N=No
Default Value: L
|
| 9 |
EOCF_USER_CFG_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow user to decide
Y/N Table Edit
Default Value: Y
|
| 10 |
EOCF_FLT_SECUR_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Is this filter secured?
Y/N Table Edit
Default Value: N
|
| 11 |
EOCF_FLT_NORULEOPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Let user see search results
Y/N Table Edit
Default Value: N
|
| 12 |
EOCF_DATASETNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Dataset Name
|
| 13 |
EOCF_FLT_BUTON_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Search Button Position
B=Bottom
T=Top
X=Both Top and Bottom
Default Value: B
|
| 14 |
EOCF_FILTER_DEBUG |
Character(1) |
VARCHAR2(1) NOT NULL |
Show the Search SQL Statement
Y/N Table Edit
Default Value: N
|
| 15 |
EOCF_FLT_CACHE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Caching
Y/N Table Edit
Default Value: Y
|
| 16 |
EOCF_SEARCH_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
When No Search Criteria Input
A=Search for everything
E=Show error message, No search
Default Value: A
|
| 17 |
UPDATE_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Update Option
Y/N Table Edit
Default Value: N
|
| 18 |
BCNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Business Component Name (see PSBCDEFN).
Prompt Table:
PSBCDEFN
|
| 19 |
APPCLASSID |
Character(30) |
VARCHAR2(30) NOT NULL |
Application Class ID
Prompt Table:
EOCF_APPCLASS_V
|
| 20 |
EOCF_APPCLASS_PATH |
Character(167) |
VARCHAR2(167) NOT NULL |
Application Class Full Path
Prompt Table:
EOCF_APPRTPATHV
|
| 21 |
EOCF_FLT_MAX_ROWS |
Number(10,0) |
DECIMAL(10) NOT NULL |
Maximum Number of Rows to Show
|
| 22 |
EOCF_HIGH_KEYS_REC |
Character(15) |
VARCHAR2(15) NOT NULL |
Work Record for Cascading Keys
Prompt Table:
EOCF_HKEYREC_VW
|
| 23 |
EOCF_CI_ERR_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Errors Handling for CI
A=App Class to Handle Errors
N=No Error Handling
P=Show Errors and Proceed
S=Show Errors and Stop
Default Value: S
|
| 24 |
EOCF_SHOMOREDATTXT |
Character(1) |
VARCHAR2(1) NOT NULL |
Show More Rows Found Help Text
Y/N Table Edit
Default Value: N
|
| 25 |
MESSAGE_SET_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Set Number. This field refers to the Message Set Number in the Message Catalog.
Default Value: 18112
|
| 26 |
MESSAGE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
|
| 27 |
EOCF_MSG_TXTOREXPL |
Character(1) |
VARCHAR2(1) NOT NULL |
Message Text
E=Explanation
T=Text
Default Value: E
|
| 28 |
EOCF_REC_HELPTXT |
Character(15) |
VARCHAR2(15) NOT NULL |
Recname
Prompt Table:
PSRECDEFN
|
| 29 |
EOCF_FLD_HELPTEXT |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name
Prompt Table:
EOCF_RECFIELDVW
|
| 30 |
EOCF_ADV_BAS_LKUP |
Character(1) |
VARCHAR2(1) NOT NULL |
Lookup Type
A=Advanced Lookup Only
B=Basic Lookup Only
C=Both Adv and Basic Available
Default Value: C
|
| 31 |
EOCF_ADV_BASLKPDFL |
Character(1) |
VARCHAR2(1) NOT NULL |
Default Lookup Type
A=Advanced Lookup
B=Basic Lookup
Default Value: A
|
| 32 |
EOCF_COLLAPSED |
Character(1) |
VARCHAR2(1) NOT NULL |
Collapsed
Y/N Table Edit
Default Value: N
|
| 33 |
EOCF_COLLAPSE_SECT |
Character(1) |
VARCHAR2(1) NOT NULL |
Collapse Section
Y/N Table Edit
Default Value: N
|
| 34 |
EOCF_MENUNAME_TRN |
Character(30) |
VARCHAR2(30) NOT NULL |
Menu Name
Prompt Table:
EOCF_MENUDFN_VW
|
| 35 |
EOCF_BARNAME_TRN |
Character(30) |
VARCHAR2(30) NOT NULL |
Menu Bar Name
Prompt Table:
EOCF_MENUBAR_VW
|
| 36 |
EOCF_ITEMNAME_TRN |
Character(60) |
VARCHAR2(60) NOT NULL |
Menu/Bar/Item
Prompt Table:
EOCF_MENUITM_VW
|
| 37 |
EOCF_COMPONENT_TRN |
Character(18) |
VARCHAR2(18) NOT NULL |
Trasaction Component
|
| 38 |
EOCF_PAGE_TRN |
Character(30) |
VARCHAR2(30) NOT NULL |
Transfer Page
Prompt Table:
EOCF_PNLGRPVW
|
| 39 |
EOCF_TRANSFER_MODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Transfer Mode
A=Add
C=Correction
E=Data Entry
L=Update/Display All
U=Update/Display
Default Value: U
|
| 40 |
EOCF_MSG_NBR_SRCH |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
Prompt Table:
EOCF_MSGCATR_VW
|
| 41 |
EOCF_MSG_SETNBR_SR |
Number(5,0) |
INTEGER NOT NULL |
Message Set Number. This field refers to the Message Set Number in the Message Catalog.
Prompt Table:
EOCF_MSGSETR_VW
|
| 42 |
EOCF_SORTCODE |
Character(254) |
VARCHAR2(254) NOT NULL |
BOM Sort Code
|
| 43 |
EOCF_CREATEDTTM |
DateTime(26) |
TIMESTAMP |
CLAF - Created DateTime
|
| 44 |
EOCF_CREATEOPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID
|
| 45 |
EOCF_LASTUPDDTTM |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry.
|
| 46 |
EOCF_LASTUPDOPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the User ID which made the last update to an entry.
|
| 47 |
EOCF_FLT_DEBUG_USR |
Long Character |
CLOB |
Only These Users May See SQL
|