FO_MC_SRCH_CRIT

(SQL Table)
 Index Back

Mass Change Search Criteria

Mass Change Search Criteria

  • Parent record: FO_MC_REQUEST

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FO_MC_USR_TYPE Character(10) VARCHAR2(10) NOT NULL User Mass Change Type

    Prompt Table: FO_MC_TYPE_TBL

    2 FO_MC_REQ_ID Character(30) VARCHAR2(30) NOT NULL Mass Change Request ID.
    3 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

    Prompt Table: RECDEFN_VW

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

    Prompt Table: RECFLD_LABEL_VW

    5 ORDERNO Number(5,0) INTEGER NOT NULL Sort Order
    6 SELECTED_FLAG Character(1) VARCHAR2(1) NOT NULL Selected Flag
    N=Not Selected
    Y=Seleted

    Y/N Table Edit

    Default Value: N

    7 FO_SC_CRIT_NAME Character(30) VARCHAR2(30) NOT NULL Defines the name of the field criteria that will show up in the search criteria.
    8 FO_SC_EDIT_TYPE Character(1) VARCHAR2(1) NOT NULL Defines editing validation method. Used in Search Criteria.
    N=No Table Edit
    P=Prompt Table Edit
    T=Translate Table Edit
    Y=Yes/No

    Default Value: N

    9 FO_SC_OPERATOR Character(2) VARCHAR2(2) NOT NULL Mass Change Comparison Operator. Can assume the following values: =, >, >=, <, <=, Between, In, Is Blank, Is not Blank, Not =, Not in, Begins With, Contains.
    BL=Is Blank
    BT=Between
    BW=Begins With
    CN=Contains
    EQ=Equal To
    GE=Greater Than or Equal To
    GT=Greater Than
    IN=In
    LE=Less Than or Equal To
    LT=Less Than
    NB=Is not Blank
    NE=Not Equal To
    NI=Not In

    Default Value: EQ

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

    Prompt Table: RECDEFN_VW

    11 FO_SC_BLD_IN_LIST Character(1) VARCHAR2(1) NOT NULL Build In List Flag. Used in Search Criteria.

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

    13 DECIMAL_POS Number(2,0) SMALLINT NOT NULL Decimal Position
    14 PARENTFIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name
    15 BASE_RECORD Character(15) VARCHAR2(15) NOT NULL Base Record

    Prompt Table: FO_SC_SRC_RCDS

    16 FO_SC_STR_VALUE Character(60) VARCHAR2(60) NOT NULL Used in Search Criteria for String Values.
    17 FO_SC_STR_VALUE_TO Character(60) VARCHAR2(60) NOT NULL Used in Search Criteria for string values in range.
    18 FO_SC_STR_NPVAL Character(60) VARCHAR2(60) NOT NULL Prompted (No Edit) String Value. Used in Staffing Search Criteria.

    Prompt Table: %EDITTABLE

    19 FO_SC_STR_NPVAL_TO Character(60) VARCHAR2(60) NOT NULL Prompted (No Edit) String Value. Used in Staffing Search Criteria.

    Prompt Table: %EDITTABLE

    20 FO_SC_STR_PVALUE Character(60) VARCHAR2(60) NOT NULL Used in Search Criteria for String Values.

    Prompt Table: %EDITTABLE

    21 FO_SC_STR_PVAL_TO Character(60) VARCHAR2(60) NOT NULL Used in Search Criteria for string values in range.

    Prompt Table: %EDITTABLE

    22 FO_SC_STR_MIXED Character(60) VARCHAR2(60) NOT NULL Used in Search Criteria for String Values.
    23 FO_SC_STR_MIX_TO Character(60) VARCHAR2(60) NOT NULL Used in Search Criteria for string values in range.
    24 FO_SC_STR_NPMIX Character(60) VARCHAR2(60) NOT NULL Prompted (No Edit) String Value. Used in Staffing Search Criteria.

    Prompt Table: %EDITTABLE

    25 FO_SC_STR_NPMIX_TO Character(60) VARCHAR2(60) NOT NULL Prompted (No Edit) String Value. Used in Staffing Search Criteria.

    Prompt Table: %EDITTABLE

    26 FO_SC_STR_PMIXED Character(60) VARCHAR2(60) NOT NULL Used in Search Criteria for String Values.

    Prompt Table: %EDITTABLE

    27 FO_SC_STR_PMIX_TO Character(60) VARCHAR2(60) NOT NULL Used in Search Criteria for string values in range.

    Prompt Table: %EDITTABLE

    28 FO_SC_STR_NAME Character(60) VARCHAR2(60) NOT NULL Used in Search Criteria for Names.
    29 FO_SC_STR_NAME_TO Character(60) VARCHAR2(60) NOT NULL Used in Search Criteria for Names in range.
    30 FO_SC_STR_NPNAME Character(60) VARCHAR2(60) NOT NULL Prompted (No Edit) Name. Used in Staffing Search Criteria.

    Prompt Table: %EDITTABLE

    31 FO_SC_STR_NPNAM_TO Character(60) VARCHAR2(60) NOT NULL Prompted (No Edit) Name. Used in Staffing Search Criteria.

    Prompt Table: %EDITTABLE

    32 FO_SC_STR_PNAME Character(60) VARCHAR2(60) NOT NULL Used in Search Criteria for Names.

    Prompt Table: %EDITTABLE

    33 FO_SC_STR_PNAME_TO Character(60) VARCHAR2(60) NOT NULL Used in Search Criteria for Names in range.

    Prompt Table: %EDITTABLE

    34 FO_SC_XLAT_VALUE Character(4) VARCHAR2(4) NOT NULL Used in Search Criteria for string values presented as ComboBox/DropDown list fields.
    D=Dummy
    35 FO_SC_IN_LIST Character(60) VARCHAR2(60) NOT NULL Used in Search Criteria for a List of String Values.
    36 FO_SC_NUM_VALUE Signed Number(32,10) DECIMAL(30,10) NOT NULL Used in Search Criteria for numeric values.
    37 FO_SC_NUM_VALUE_TO Signed Number(32,10) DECIMAL(30,10) NOT NULL Used in Search Criteria for Numeric values in range.
    38 FO_SC_NUM_NPVAL Signed Number(32,10) DECIMAL(30,10) NOT NULL Prompted (No Edit) Numeric Value. Used in Staffing Search Criteria.

    Prompt Table: %EDITTABLE

    39 FO_SC_NUM_NPVAL_TO Signed Number(32,10) DECIMAL(30,10) NOT NULL Prompted (No Edit) Numeric Value. Used in Staffing Search Criteria.

    Prompt Table: %EDITTABLE

    40 FO_SC_NUM_PVALUE Signed Number(32,10) DECIMAL(30,10) NOT NULL Used in Search Criteria for numeric values.

    Prompt Table: %EDITTABLE

    41 FO_SC_NUM_PVAL_TO Signed Number(32,10) DECIMAL(30,10) NOT NULL Used in Search Criteria for numeric values in range.

    Prompt Table: %EDITTABLE

    42 FO_SC_DTTM_VALUE DateTime(26) TIMESTAMP Used in Search Criteria for DateTime values.
    43 FO_SC_DTTM_VAL_TO DateTime(26) TIMESTAMP Used in Search Criteria for DateTime values.
    44 FO_SC_DATE_VALUE Date(10) DATE Used in Search Criteria for Date values.
    45 FO_SC_DATE_VAL_TO Date(10) DATE Used in Search Criteria for Date values.
    46 FO_SC_TIME_VALUE Time(15) TIMESTAMP Used in Search Criteria for Time values.
    47 FO_SC_TIME_VAL_TO Time(15) TIMESTAMP Used in Search Criteria for Time values.