IT_SEARCH_FILL

(SQL View)
 Index Back

SELECT A.SEARCH_NAME , A.FIELDNUM , A.RECNAME , A.RECALIAS , A.FIELDNAME , B.LABEL_ID , B.LONGNAME , C.FIELDTYPE , A.PROMPT_EDITTYPE , A.PROMPT_TBL , '1' , '1' , '1' , %subrec(IT_SRCH_PROPS, A) FROM %Table(IT_SEARCH_01) A , %Table(PSDBFLDLABL) B , %Table(PSDBFIELD) C WHERE A.FIELDNAME = B.FIELDNAME AND A.LABEL_ID = B.LABEL_ID AND B.FIELDNAME = C.FIELDNAME AND A.ACTIVE_STATUS = 'A'

  • Related Language Record: IT_SRCH_FILL_LG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SEARCH_NAME Character(30) VARCHAR2(30) NOT NULL Search Name
    2 FIELDNUM Number(4,0) SMALLINT NOT NULL Field Number
    3 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

    Prompt Table: PSRECDEFN_VW3

    4 RECALIAS Character(15) VARCHAR2(15) NOT NULL Record Alias
    5 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    6 LABEL_ID Character(18) VARCHAR2(18) NOT NULL LABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.
    7 FIELDLABEL Character(60) VARCHAR2(60) NOT NULL Field Label
    8 FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101 Ref.)
    9 PROMPT_EDITTYPE Character(1) VARCHAR2(1) NOT NULL Edit Type
    1=No Table Edit
    2=Prompt Table
    3=Translate Table
    4=Yes/No
    5=Currency Controlled
    10 PROMPT_TBL Character(15) VARCHAR2(15) NOT NULL Prompt Table

    Prompt Table: PSRECDEFN_VW3

    11 LOGIC_OPER_CHAR Character(1) VARCHAR2(1) NOT NULL Logic Operator
    1==
    2=<>
    3=>
    4=<
    5=>=
    6=<=
    7=Like
    8=Not Like
    9=Is Empty
    A=Between
    B=Not Between
    12 LOGIC_OPER_DATE Character(1) VARCHAR2(1) NOT NULL Logic Operator
    1==
    2=<>
    3=>
    4=<
    5=>=
    6=<=
    7=Begins with
    8=Does NOT begins with
    9=Is Empty
    A=Between
    B=Not Between
    13 LOGIC_OPER_NUM Character(1) VARCHAR2(1) NOT NULL Logic Operator
    1==
    2=<>
    3=>
    4=<
    5=>=
    6=<=
    7=Like
    8=Does NOT begins with
    9=Is Empty
    A=Between
    B=Not Between
    14 UPDT_SETID_FROM Number(4,0) SMALLINT NOT NULL Field Number
    15 UPDT_BUS_UNIT_FROM Number(4,0) SMALLINT NOT NULL Field Number
    16 UPDT_KEY_FROM Number(4,0) SMALLINT NOT NULL Field Number
    17 UPDT_KEY_CURR_FROM Number(4,0) SMALLINT NOT NULL Field Number
    18 SETID_FIELD Character(18) VARCHAR2(18) NOT NULL SetID Field
    19 RECNAME_SETID Character(15) VARCHAR2(15) NOT NULL Set Id Record Name