PTAFCRTA_REC

index back

Criteria Definition

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

  • Related language record: PTAFCRTA_RECLNG
  • PeopleSoft Field Name Field Type Column Type Description
    PTAFCRTA_ID Character(100) VARCHAR2(100) NOT NULL Criteria ID
    SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
    RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

    Prompt Table: RECDEFN_VW

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

    Prompt Table: PSRECFIELDALL

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

    Prompt Table: PTAFAMT_REC_VW

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

    Prompt Table: PTAFAMTRECFIELD

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

    Default: N

    PTAFCRTA_OP_NUM Character(2) VARCHAR2(2) NOT NULL Criteria Operator
    <=Less Than
    >=Greater Than
    B=Between(Inclusive)

    Default: >

    AMOUNT_1 Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount Work Field
    AMOUNT_2 Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount Work Field
    CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

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

    Prompt Table: CUR_RT_TYPE_TBL

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

    Prompt Table: PSRECDEFNPVW

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

    Prompt Table: PTAFAMTRECFIELD

    DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
    index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
    PTRef generated on 21-DEC-20