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

  • Related Language Record: EOCF_FLTLBL_LNG
  • # 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=
  • If Fieldtype=0 (Character) then Upper Case
  • If Fieldtype=6 (DateTime) then HH:MM
    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