EOAWCRTA_REC

(SQL Table)
 Index Back

Criteria Definition

Criteria can be defined as queries, application classes & SQL Definitions.

  • Related Language Record: EOAWCRTA_RECLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EOAWCRTA_ID Character(100) VARCHAR2(100) NOT NULL Criteria ID Field
    2 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
    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: PSRECFIELDALL

    5 AMT_RECNAME Character(15) VARCHAR2(15) NOT NULL Amount Record

    Prompt Table: EOAWAMT_REC_VW

    6 AMT_FLDNAME Character(18) VARCHAR2(18) NOT NULL Amount Field Name

    Prompt Table: EOAWAMTRECFIELD

    7 EOAWCRITERIA_FLG Character(1) VARCHAR2(1) NOT NULL Flag for whether all criteria are needed or any
    A=All
    O=One
    8 EOAWAMOUNT_SW Character(1) VARCHAR2(1) NOT NULL Amount Field
    N=No
    Y=Yes

    Default Value: N

    9 EOAWCRTA_OP_NUM Character(2) VARCHAR2(2) NOT NULL Criteria Operator
    <=Less Than or Equal To
    >=Greater Than or Equal To
    B=Between(Inclusive)

    Default Value: >

    10 AMOUNT_1 Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount Work Field
    11 AMOUNT_2 Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount Work Field
    12 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL This field stores the Currency Code value.

    Prompt Table: CURRENCY_CD_TBL

    13 CUR_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Currency Rate Type

    Prompt Table: CUR_RT_TYPE_TBL

    14 RECNAME_CUR Character(15) VARCHAR2(15) NOT NULL Currency Record

    Prompt Table: PSRECDEFNPVW

    15 FIELDNAME_CUR Character(18) VARCHAR2(18) NOT NULL Currency Field

    Prompt Table: EOAWAMTRECFIELD

    16 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description