SDN_INQ_FLDS

(SQL Table)
Index Back

Search Configuration work

  • Parent record: APVM_INQ
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

    Default Value: AP_MTCH_WB_HDR.OPRID

    2 SRCH_CONFIG_ID Character(20) VARCHAR2(20) NOT NULL Search Configuration ID

    Default Value: AP_MTCH_WB_HDR.SRCH_CONFIG_ID

    3 SRCH_CRITERIA Character(30) VARCHAR2(30) NOT NULL Search Criteria
    4 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
    5 ACTIVE_FLAG Character(1) VARCHAR2(1) NOT NULL Active Flag
    A=Active
    I=Inactive

    Default Value: A

    6 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

    Prompt Table: RECFLD_LABEL_VW

    7 SRCH_OPERATOR Character(4) VARCHAR2(4) NOT NULL Allowed logic operator by field type
    !IN=not in
    0=All Values
    1=equal to
    2=less than
    21=before
    3=greater than
    31=after
    4=less than or equal to
    41=on or before
    5=greater than or equal to
    51=on or after
    6=between
    7=begins with
    8=contains
    9=in
    <=<
    <==<=
    <>=not =
    ===
    >=>
    >==>=
    A=not in
    B=not equal
    BEG=begins with
    BTWN=between
    IN=in
    LIKE=contains

    Default Value: 0

    8 FROM_MIXED_NP Character(50) VARCHAR2(50) NOT NULL Equal To
    9 FROM_MIXED_P Character(50) VARCHAR2(50) NOT NULL Equal To

    Prompt Table: %EDITTABLE

    10 FROM_UPPER_NP Character(50) VARCHAR2(50) NOT NULL Equal To
    11 FROM_UPPER_P Character(50) VARCHAR2(50) NOT NULL Equal To

    Prompt Table: %EDITTABLE

    12 DATE_FROM Date(10) DATE Date From
    13 DATE_TO Date(10) DATE Date To
    14 FROM_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL From Amount
    15 TO_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL And
    16 VALUE_XLAT Character(4) VARCHAR2(4) NOT NULL Translate Value
    0=Null
    17 IN_LIST_STRING Character(254) VARCHAR2(254) NOT NULL SQL in list string
    18 TO_MIXED_NP Character(50) VARCHAR2(50) NOT NULL To Value
    19 TO_MIXED_P Character(50) VARCHAR2(50) NOT NULL To Value

    Prompt Table: %EDITTABLE

    20 TO_UPPER_NP Character(50) VARCHAR2(50) NOT NULL To Value
    21 TO_UPPER_P Character(50) VARCHAR2(50) NOT NULL To Value

    Prompt Table: %EDITTABLE

    22 TO_NUMBER_P Number(15,0) DECIMAL(15) NOT NULL To

    Prompt Table: %EDITTABLE

    23 TO_NUMBER_NP Number(15,0) DECIMAL(15) NOT NULL To
    24 FROM_NUMBER_P Number(15,0) DECIMAL(15) NOT NULL From Number

    Prompt Table: %EDITTABLE

    25 FROM_NUMBER_NP Number(15,0) DECIMAL(15) NOT NULL From Number