RB_FLT_LABEL_VW

(SQL View)
 Index Back

Filter Fields

Common Object Record used for Filter fields information

SELECT A.PNLGRPNAME ,A.MARKET ,A.PNLNAME ,A.RECNAME ,A.SEQ_NUM ,A.FIELDNAME ,A.DEEP_QUERY_OPERAND ,A.FIELDNUM ,A.LABEL_ID ,A.LBLTYPE_CHAR ,A.PROMPT_EDITTYPE ,A.EDITTABLE ,A.REQUIRED_FLG ,A.SETCNTRLFLD ,A.BU_FLDNAME ,A.EFFDT_FLDNAME ,A.KEY1_FLDNAME ,A.KEY2_FLDNAME ,A.KEY3_FLDNAME ,A.MESSAGE_SET_NBR ,A.MESSAGE_NBR ,A.RECNAME_ALT ,A.DROPDOWN_DESCR ,A.FILTER_CONSTANT ,A.CB_USE_SEARCH ,A.CB_USE_RESULTS ,A.APPCLASSID ,A.PACKAGEROOT ,A.QUALIFYPATH ,A.RELATED_FIELD ,A.CUST_CONTACT_RB ,A.CB_DISPLAY_ONLY ,A.FILTER_FLD_DSP_TYP ,A.ADV_BASIC_LOOKUP ,A.ADV_BASIC_LKP_DFLT ,A.DISPLAY_CNTRL_FLD ,A.DISPLAY_CNTRL_FLD2 ,A.COMPONENT_DRILL ,A.CUST_CONTACT_RB2 ,A.RA_OPERATORS ,A.RA_DEFAULT_OPER ,A.RELATED_DISP_FIELD ,A.MESSAGE_SET_NBR_TX ,A.MESSAGE_NBR_TX ,A.RB_UNHIDE ,A.CB_HIDDEN ,A.ROW_ADDED_DTTM ,A.ROW_ADDED_OPRID ,A.ROW_LASTMANT_DTTM ,A.ROW_LASTMANT_OPRID ,B.FIELDTYPE , B.LENGTH , B.DECIMALPOS , B.FORMAT , C.LONGNAME , C.SHORTNAME , A.UPPER_SEARCH_FIELD , A.ALT_CHAR_ENABLED , A.RB_FIELD_TYPE , A.RA_PROFILE_ID , A.RA_ATTRIBUTE_ID , A.PRFL_BO_ID_FIELD , A.RETURN_BO_DATA , A.RECNAME_SECT , A.FIELD_SEQ_NBR , A.PARTNER , A.PARTNER_USER , A.RSEC_OBJECT_ID FROM PS_RB_FILTER_FIELD 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: RB_FLT_LABL_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 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
    6 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

    Prompt Table: RB_RECFIELD_ALT

    7 DEEP_QUERY_OPERAND Character(1) VARCHAR2(1) NOT NULL Used by Configurable Search setup to assign IN or EXISTS operand to a given deep query.
    E=EXISTS
    I=IN
    8 FIELDNUM Number(4,0) SMALLINT NOT NULL Field Number

    Default Value: 1

    9 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: RB_DBFLDLABL_VW

    10 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

    11 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

    12 EDITTABLE Character(15) VARCHAR2(15) NOT NULL Edit Table

    Prompt Table: PSRECDEFN

    13 REQUIRED_FLG Character(1) VARCHAR2(1) NOT NULL Required Flag

    Y/N Table Edit

    Default Value: N

    14 SETCNTRLFLD Character(18) VARCHAR2(18) NOT NULL Tree Structure Node User Key Field Name

    Prompt Table: PSRECFIELDDB

    15 BU_FLDNAME Character(18) VARCHAR2(18) NOT NULL Business Unit Field Name

    Prompt Table: PSRECFIELDDB

    16 EFFDT_FLDNAME Character(18) VARCHAR2(18) NOT NULL Effective Date Field Name

    Prompt Table: PSRECFIELDDB

    17 KEY1_FLDNAME Character(18) VARCHAR2(18) NOT NULL Key 1 Field Name

    Prompt Table: PSRECFIELDDB

    18 KEY2_FLDNAME Character(18) VARCHAR2(18) NOT NULL Key 2 Field Name

    Prompt Table: PSRECFIELDDB

    19 KEY3_FLDNAME Character(18) VARCHAR2(18) NOT NULL Key 3 Field Name

    Prompt Table: PSRECFIELDDB

    20 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: RB_MSGSET_VW

    21 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.

    Prompt Table: RB_MSGCAT_VW

    22 RECNAME_ALT Character(15) VARCHAR2(15) NOT NULL Record Name

    Prompt Table: PSRECDEFN

    23 DROPDOWN_DESCR Character(18) VARCHAR2(18) NOT NULL Description Field

    Prompt Table: RB_FLT_DROP_VW

    24 FILTER_CONSTANT Character(100) VARCHAR2(100) NOT NULL Constant Value
    25 CB_USE_SEARCH Character(1) VARCHAR2(1) NOT NULL Use as Search Field

    Y/N Table Edit

    Default Value: Y

    26 CB_USE_RESULTS Character(1) VARCHAR2(1) NOT NULL Show in Search Results

    Y/N Table Edit

    Default Value: Y

    27 APPCLASSID Character(30) VARCHAR2(30) NOT NULL Application Class ID

    Prompt Table: RB_CLASS_VW

    28 PACKAGEROOT Character(30) VARCHAR2(30) NOT NULL Root Package ID

    Default Value: BO_SEARCH

    29 QUALIFYPATH Character(127) VARCHAR2(127) NOT NULL Qualified Package/Class Path

    Prompt Table: RB_CLASSPATH_VW

    30 RELATED_FIELD Character(18) VARCHAR2(18) NOT NULL Related Directory Search Field

    Prompt Table: RB_FLT_FIELD_VW

    31 CUST_CONTACT_RB Character(1) VARCHAR2(1) NOT NULL Customer or Contact?
    C=Customer
    N=Neither
    R=Contact
    S=Site

    Default Value: C

    32 CB_DISPLAY_ONLY Character(1) VARCHAR2(1) NOT NULL Display Only

    Y/N Table Edit

    Default Value: N

    33 FILTER_FLD_DSP_TYP Character(1) VARCHAR2(1) NOT NULL Display Type
    A=Always Show in Results
    H=Hide When Exact Match

    Default Value: A

    34 ADV_BASIC_LOOKUP Character(1) VARCHAR2(1) NOT NULL Advanced / Basic Lookup.................
    A=Advanced Lookup Only
    B=Basic Lookup Only
    C=Both Adv and Basic Available

    Default Value: C

    35 ADV_BASIC_LKP_DFLT Character(1) VARCHAR2(1) NOT NULL Common Object........................................................
    A=Advanced Lookup
    B=Basic Lookup
    36 DISPLAY_CNTRL_FLD Character(18) VARCHAR2(18) NOT NULL BO_ID Search Field

    Prompt Table: RB_RECFIELD_ALT

    37 DISPLAY_CNTRL_FLD2 Character(18) VARCHAR2(18) NOT NULL Role Type Search Field

    Prompt Table: RB_RECFIELD_ALT

    38 COMPONENT_DRILL Character(1) VARCHAR2(1) NOT NULL Show Transfer Button

    Y/N Table Edit

    39 CUST_CONTACT_RB2 Character(1) VARCHAR2(1) NOT NULL Customer or Contact?
    C=Customer
    N=Neither
    R=Contact
    S=Site
    40 RA_OPERATORS Character(40) VARCHAR2(40) NOT NULL Filter Search Definition Operator value field
    41 RA_DEFAULT_OPER Character(2) VARCHAR2(2) NOT NULL Filter Search Definition Default Operator value field
    42 RELATED_DISP_FIELD Character(18) VARCHAR2(18) NOT NULL Field Name
    43 MESSAGE_SET_NBR_TX Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.

    Prompt Table: RB_MSGSET_TX_VW

    44 MESSAGE_NBR_TX Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.

    Prompt Table: RB_MSGCAT_TX_VW

    45 RB_UNHIDE Character(254) VARCHAR2(254) NOT NULL Unhide Related Fields

    Prompt Table: RB_FLT_RELF_VW

    46 CB_HIDDEN Character(1) VARCHAR2(1) NOT NULL Hidden

    Y/N Table Edit

    Default Value: N

    47 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    48 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    49 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    50 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    51 FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101 Ref.)
    52 LENGTH Number(5,0) INTEGER NOT NULL Length
    53 DECIMALPOS Number(2,0) SMALLINT NOT NULL Decimal Positions
    54 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)
    • 55 LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name
    56 SHORTNAME Character(15) VARCHAR2(15) NOT NULL Field Short Name
    57 UPPER_SEARCH_FIELD Character(18) VARCHAR2(18) NOT NULL Uppercase Search Field
    58 ALT_CHAR_ENABLED Character(1) VARCHAR2(1) NOT NULL Alternate Character Enabled
    59 RB_FIELD_TYPE Character(1) VARCHAR2(1) NOT NULL It holds field type definition. See translate values for details.
    P=Profile Field
    R=Record Field
    60 RA_PROFILE_ID Number(18,0) DECIMAL(18) NOT NULL Profile - profile ID
    61 RA_ATTRIBUTE_ID Number(18,0) DECIMAL(18) NOT NULL Profile / Attribute ID
    62 PRFL_BO_ID_FIELD Character(18) VARCHAR2(18) NOT NULL Profile BO ID Field
    63 RETURN_BO_DATA Character(1) VARCHAR2(1) NOT NULL Show Identifying Information
    64 RECNAME_SECT Character(15) VARCHAR2(15) NOT NULL Section Record Name
    65 FIELD_SEQ_NBR Number(3,0) SMALLINT NOT NULL Field Sequence Number
    66 PARTNER Character(1) VARCHAR2(1) NOT NULL Partner

    Y/N Table Edit

    67 PARTNER_USER Character(1) VARCHAR2(1) NOT NULL Hide when User is a Partner
    68 RSEC_OBJECT_ID Character(30) VARCHAR2(30) NOT NULL Security Object ID used for defining application security objects.