EOCF_FLT_LBL_VW(SQL View) |
Index Back |
---|---|
Filter Fields |
SELECT A.PNLGRPNAME ,A.MARKET ,A.PNLNAME ,A.RECNAME ,A.FIELDNAME ,A.FIELDNUM ,A.LABEL_ID ,A.LBLTYPE_CHAR ,A.PROMPT_EDITTYPE ,A.EDITTABLE ,A.REQUIRED_FLG ,A.SETCNTRLFLD ,A.EOCF_BU_FLDNAME ,A.EOCF_SETID_FLDNAME ,A.EOCF_EFFDT_FLDNAME ,A.KEY1_FLDNAME ,A.KEY2_FLDNAME ,A.KEY3_FLDNAME ,A.MESSAGE_SET_NBR ,A.MESSAGE_NBR ,A.EOCF_RECNAME_ALT ,A.EOCF_DROPDOWN_DESC ,A.EOCF_FLT_CONSTANT ,A.EOCF_CB_USE_SEARCH ,A.EOCF_CB_USE_RESULT ,A.EOCF_CB_DISP_ONLY ,A.EOCF_FLT_FLDDSPTYP ,A.EOCF_ADV_BAS_LKUP ,A.EOCF_ADV_BASLKPDFL ,A.EOCF_DISP_CNTL_FLD ,A.EOCF_DISPCNTL_FLD2 ,A.EOCF_OPERATORS ,A.EOCF_DEFAULT_OPER ,A.EOCF_REL_DISP_FLD ,A.EOCF_MSG_SETNBR_TX ,A.EOCF_MSG_NBR_TX ,A.EOCF_UNHIDE ,A.EOCF_CB_HIDDEN ,%subrec(EOCF_AUDIT_SBR,A) ,B.FIELDTYPE , B.LENGTH , B.DECIMALPOS , B.FORMAT , C.LONGNAME , C.SHORTNAME , A.EOCF_UPPR_SRCH_FLD , A.EOCF_JOIN_FROM_FLD , A.EOCF_JOIN_TO_FLD FROM PS_EOCF_FILTER_FLD A , PSDBFIELD B , PSDBFLDLABL C WHERE A.FIELDNAME = B.FIELDNAME AND A.FIELDNAME = C.FIELDNAME AND A.LABEL_ID = C.LABEL_ID |
# | 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 | 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 |
8 | 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 |
9 | PROMPT_EDITTYPE | Character(1) | VARCHAR2(1) NOT NULL |
Edit Type
1=No Table Edit 2=Prompt Table 3=Translate Table 4=Yes/No Default Value: 1 |
10 | EDITTABLE | Character(15) | VARCHAR2(15) NOT NULL |
Edit Table
Prompt Table: PSRECDEFN |
11 | REQUIRED_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Required Flag
Y/N Table Edit Default Value: N |
12 | SETCNTRLFLD | Character(18) | VARCHAR2(18) NOT NULL |
Tree Structure Node User Key Field Name
Prompt Table: PSRECFIELDDB |
13 | EOCF_BU_FLDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Business Unit Field Name
Prompt Table: PSRECFIELDDB |
14 | EOCF_SETID_FLDNAME | Character(18) | VARCHAR2(18) NOT NULL |
SetID Field Name
Prompt Table: PSRECFIELDDB |
15 | EOCF_EFFDT_FLDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Effective Date Field Name
Prompt Table: PSRECFIELDDB |
16 | KEY1_FLDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Key 1 Field Name
Prompt Table: PSRECFIELDDB |
17 | KEY2_FLDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Key 2 Field Name
Prompt Table: PSRECFIELDDB |
18 | KEY3_FLDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Key 3 Field Name
Prompt Table: PSRECFIELDDB |
19 | 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 |
20 | 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 |
21 | EOCF_RECNAME_ALT | Character(15) | VARCHAR2(15) NOT NULL |
Record Name
Prompt Table: PSRECDEFN |
22 | EOCF_DROPDOWN_DESC | Character(18) | VARCHAR2(18) NOT NULL |
Description Field
Prompt Table: EOCF_FLTDROP_VW |
23 | EOCF_FLT_CONSTANT | Character(100) | VARCHAR2(100) NOT NULL | Constant Value |
24 | EOCF_CB_USE_SEARCH | Character(1) | VARCHAR2(1) NOT NULL |
Use as Search Field
Y/N Table Edit |
25 | EOCF_CB_USE_RESULT | Character(1) | VARCHAR2(1) NOT NULL |
Show in Search Results
Y/N Table Edit |
26 | EOCF_CB_DISP_ONLY | Character(1) | VARCHAR2(1) NOT NULL |
Display Only
Y/N Table Edit |
27 | EOCF_FLT_FLDDSPTYP | Character(1) | VARCHAR2(1) NOT NULL |
Display Type
A=Always Show in Results H=Hide When Exact Match |
28 | 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 |
29 | EOCF_ADV_BASLKPDFL | Character(1) | VARCHAR2(1) NOT NULL |
Default Lookup Type
A=Advanced Lookup B=Basic Lookup |
30 | EOCF_DISP_CNTL_FLD | Character(18) | VARCHAR2(18) NOT NULL |
BO_ID Search Field
Prompt Table: EOCF_RECFLD_ALT |
31 | EOCF_DISPCNTL_FLD2 | Character(18) | VARCHAR2(18) NOT NULL |
Role Type Search Field
Prompt Table: EOCF_RECFLD_ALT |
32 | EOCF_OPERATORS | Character(40) | VARCHAR2(40) NOT NULL | Filter Search Definition Operator value field |
33 | EOCF_DEFAULT_OPER | Character(2) | VARCHAR2(2) NOT NULL | Filter Search Definition Default Operator value field |
34 | EOCF_REL_DISP_FLD | Character(18) | VARCHAR2(18) NOT NULL | Field Name |
35 | 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 |
36 | 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 |
37 | EOCF_UNHIDE | Character(254) | VARCHAR2(254) NOT NULL |
Unhide Related Fields
Prompt Table: EOCF_FLTRELFVW |
38 | EOCF_CB_HIDDEN | Character(1) | VARCHAR2(1) NOT NULL |
Hidden
Y/N Table Edit |
39 | EOCF_CREATEDTTM | DateTime(26) | TIMESTAMP | CLAF - Created DateTime |
40 | EOCF_CREATEOPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID |
41 | EOCF_LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. |
42 | EOCF_LASTUPDOPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the last update to an entry. |
43 | FIELDTYPE | Number(2,0) | SMALLINT NOT NULL | Field Type (from PSST0101 Ref.) |
44 | LENGTH | Number(5,0) | INTEGER NOT NULL | Length |
45 | DECIMALPOS | Number(2,0) | SMALLINT NOT NULL | Decimal Positions |
46 | FORMAT | Number(2,0) | SMALLINT NOT NULL |
Field Format
0= 1=Name 2=Phone Number North American (mandatory length 12 characters) 3=Zip/Postal Code North American (mandatory length 10 characters) 4=US Social Security Number (mandatory length 9 characters) 5= 6=Mixed Case 7=Raw/Binary 8=Numbers only 9=SIN (mandatory length 9 characters) 10=International Phone Number 11=Zip/Postal Code International 12=Time HH:MM:SS 13=Time HH:MM:SS.999999 14=Custom (FORMATFAMILY and DISPFMTNAME must be completed) |
47 | LONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Long Name |
48 | SHORTNAME | Character(15) | VARCHAR2(15) NOT NULL | Field Short Name |
49 | EOCF_UPPR_SRCH_FLD | Character(18) | VARCHAR2(18) NOT NULL | Uppercase Search Field |
50 | EOCF_JOIN_FROM_FLD | Character(18) | VARCHAR2(18) NOT NULL | Join From Field |
51 | EOCF_JOIN_TO_FLD | Character(18) | VARCHAR2(18) NOT NULL | Join To Field |