| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PNLGRPNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Component Name
|
| 2 |
MARKET |
Character(3) |
VARCHAR2(3) NOT NULL |
Market
|
| 3 |
PNLNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Panel Name (see PSPNLDEFN).
|
| 4 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
|
| 5 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table:
EOCF_RECFLD_ALT
|
| 6 |
FIELDNUM |
Number(4,0) |
SMALLINT NOT NULL |
Field Number
Default Value: 1
|
| 7 |
EOCF_RECNAME_ALT |
Character(15) |
VARCHAR2(15) NOT NULL |
Record Name
Prompt Table:
PSRECDEFN
|
| 8 |
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:
EOCF_DBFLDLBLVW
|
| 9 |
LBLTYPE_CHAR |
Character(1) |
VARCHAR2(1) NOT NULL |
Label Type
0=None
1=Text
2=RFT Short
3=RFT Long
4=Xlat Short
5=Xlat Long
6=Image
7=Message Catalog (Not Impl.)
Default Value: 2
|
| 10 |
PROMPT_EDITTYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Edit Type
1=No Table Edit
2=Prompt With No Edit
3=Translate Table
4=Yes/No
5=BO Search
6=Constant Value
7=Prompt With Edit
8=Dropdown List
Default Value: 1
|
| 11 |
EDITTABLE |
Character(15) |
VARCHAR2(15) NOT NULL |
Edit Table
Prompt Table:
PSRECDEFN
|
| 12 |
EOCF_DROPDOWN_DESC |
Character(18) |
VARCHAR2(18) NOT NULL |
Description Field
Prompt Table:
EOCF_FLTDRP_VW
|
| 13 |
EOCF_FLT_CONSTANT |
Character(100) |
VARCHAR2(100) NOT NULL |
Constant Value
|
| 14 |
REQUIRED_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Required Flag
Y/N Table Edit
Default Value: N
|
| 15 |
EOCF_CB_DISP_ONLY |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Only
Y/N Table Edit
Default Value: N
|
| 16 |
EOCF_CB_HIDDEN |
Character(1) |
VARCHAR2(1) NOT NULL |
Hidden
Y/N Table Edit
Default Value: N
|
| 17 |
EOCF_CB_USE_SEARCH |
Character(1) |
VARCHAR2(1) NOT NULL |
Use as Search Field
Y/N Table Edit
Default Value: Y
|
| 18 |
EOCF_CB_USE_RESULT |
Character(1) |
VARCHAR2(1) NOT NULL |
Show in Search Results
Y/N Table Edit
Default Value: Y
|
| 19 |
EOCF_FLT_FLDDSPTYP |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Type
A=Always Show in Results
H=Hide When Exact Match
Default Value: A
|
| 20 |
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
|
| 21 |
EOCF_ADV_BASLKPDFL |
Character(1) |
VARCHAR2(1) NOT NULL |
Default Lookup Type
A=Advanced Lookup
B=Basic Lookup
|
| 22 |
EOCF_DISP_CNTL_FLD |
Character(18) |
VARCHAR2(18) NOT NULL |
BO_ID Search Field
Prompt Table:
EOCF_RECFLD_ALT
|
| 23 |
EOCF_DISPCNTL_FLD2 |
Character(18) |
VARCHAR2(18) NOT NULL |
Role Type Search Field
Prompt Table:
EOCF_RECFLD_ALT
|
| 24 |
SETCNTRLFLD |
Character(18) |
VARCHAR2(18) NOT NULL |
Tree Structure Node User Key Field Name
Prompt Table:
PSRECFIELDDB
|
| 25 |
EOCF_BU_FLDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Business Unit Field Name
Prompt Table:
PSRECFIELDDB
|
| 26 |
EOCF_SETID_FLDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
SetID Field Name
Prompt Table:
PSRECFIELDDB
|
| 27 |
EOCF_EFFDT_FLDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Effective Date Field Name
Prompt Table:
PSRECFIELDDB
|
| 28 |
KEY1_FLDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Key 1 Field Name
Prompt Table:
PSRECFIELDDB
|
| 29 |
KEY2_FLDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Key 2 Field Name
Prompt Table:
PSRECFIELDDB
|
| 30 |
KEY3_FLDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Key 3 Field Name
Prompt Table:
PSRECFIELDDB
|
| 31 |
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:
EOCF_MSGSET_VW
|
| 32 |
MESSAGE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
Prompt Table:
EOCF_MSGCAT_VW
|
| 33 |
EOCF_OPERATORS |
Character(40) |
VARCHAR2(40) NOT NULL |
Filter Search Definition Operator value field
|
| 34 |
EOCF_DEFAULT_OPER |
Character(2) |
VARCHAR2(2) NOT NULL |
Filter Search Definition Default Operator value field
|
| 35 |
EOCF_REL_DISP_FLD |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name
|
| 36 |
EOCF_MSG_SETNBR_TX |
Number(5,0) |
INTEGER NOT NULL |
Message Set Number. This field refers to the Message Set Number in the Message Catalog.
Prompt Table:
EOCF_MSGSETX_VW
|
| 37 |
EOCF_MSG_NBR_TX |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
Prompt Table:
EOCF_MSGCATX_VW
|
| 38 |
EOCF_UNHIDE |
Character(254) |
VARCHAR2(254) NOT NULL |
Unhide Related Fields
Prompt Table:
EOCF_FLTRELFVW
|
| 39 |
EOCF_UPPR_SRCH_FLD |
Character(18) |
VARCHAR2(18) NOT NULL |
Uppercase Search Field
Prompt Table:
EOCF_UPPSRCH_VW
|
| 40 |
EOCF_JOIN_FROM_FLD |
Character(18) |
VARCHAR2(18) NOT NULL |
Join From Field
Prompt Table:
EOCF_RECFLD_ALT
|
| 41 |
EOCF_JOIN_TO_FLD |
Character(18) |
VARCHAR2(18) NOT NULL |
Join To Field
Prompt Table:
EOCF_RECFLD_ALT
|
| 42 |
EOCF_MAINT_OWNER |
Character(1) |
VARCHAR2(1) NOT NULL |
data library - Maint Owner, possible values are Peoplesoft, Customer, Modified
0=PeopleSoft
1=PeopleSoft / Customer Modified
2=Customer
Default Value: 2
|
| 43 |
EOCF_IS_SYSTEM |
Character(1) |
VARCHAR2(1) NOT NULL |
data library - is system data
|
| 44 |
EOCF_CREATEDTTM |
DateTime(26) |
TIMESTAMP |
CLAF - Created DateTime
|
| 45 |
EOCF_CREATEOPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID
|
| 46 |
EOCF_LASTUPDDTTM |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry.
|
| 47 |
EOCF_LASTUPDOPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the User ID which made the last update to an entry.
|