EO_INQ_SPTH_VW

(SQL View)
 Index Back

Rule Selection Path View


SELECT A.PROC_GRP_ID , A.PROD_ID , A.RULE_INSTNC_NBR , A.CR_INSTNC_NBR , A.SEQNUM , A.LEFT_PAREN , A.AND_OR_OPR , A.RECNAME_1 , A.FLDNAME_1 , A.RECNAME_2 , A.FLDNAME_2 , A.COMP_INSTNC_NBR , A.DATE_IND , A.OPR_PREDICATE1 , A.RCNTL_COMP_NBR , A.SELECT_VALUES , A.RIGHT_PAREN , A.SELECT_X , A.SQL_FUNCTION , A.SBSEL_RECNAME , A.SBSEL_FLDNAME , A.RCD_ALIAS FROM PS_EO_CCR_SEL_PATH A

  • Parent record: EO_CURRCNV_R_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PROC_GRP_ID Character(10) VARCHAR2(10) NOT NULL Uniquely identifies a Currency Conversion Process Group
    2 PROD_ID Character(2) VARCHAR2(2) NOT NULL This is an XLAT field listing all PeopleSoft 7.5 Product codes.
    AM=Asset Management
    AP=Payables
    AR=Receivables
    BD=Budgets
    BI=Billing
    CA=Contracts
    CE=Cost Management
    CP=Product Configurator
    DM=Deduction Management
    DP=Demand Planning
    EN=Manufactuing Bills and Routing
    EO=Enterprise Components
    EP=Enterprise Planning
    EX=Expenses
    FG=Federal Government
    GF=Global Financials
    GL=General Ledger
    HP=HRMS Education & Government
    IN=Inventory
    MG=Manufacturing
    OM=Order Management
    OP=Order Promising
    PC=Projects
    PL=Production Planning
    PO=Purchasing
    QS=Quality
    SF=Production Management
    TR=Treasury
    3 RULE_INSTNC_NBR Number(3,0) SMALLINT NOT NULL Rule Occurrence Number
    4 CR_INSTNC_NBR Number(3,0) SMALLINT NOT NULL Criteria Instance Nbr

    Default Value: 1

    5 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
    6 LEFT_PAREN Character(1) VARCHAR2(1) NOT NULL Left Parenthesis
    1=(
    2=((
    3=(((
    4=((((
    5=(((((
    6=((((((
    7=(((((((

    Y/N Table Edit

    Default Value: N

    7 AND_OR_OPR Character(1) VARCHAR2(1) NOT NULL And/Or Operator
    1=None
    2=Or
    3=And

    Default Value: 1

    8 RECNAME_1 Character(15) VARCHAR2(15) NOT NULL Record 1 Name

    Prompt Table: PSRECDEFN

    9 FLDNAME_1 Character(18) VARCHAR2(18) NOT NULL Field 1 Name

    Prompt Table: EO_RECFIELD9_VW

    10 RECNAME_2 Character(15) VARCHAR2(15) NOT NULL Record 2 Name

    Prompt Table: PSRECDEFN

    11 FLDNAME_2 Character(18) VARCHAR2(18) NOT NULL Field 2 Name

    Prompt Table: EO_RECFLD10_VW

    12 COMP_INSTNC_NBR Number(3,0) SMALLINT NOT NULL Selection Component Number

    Prompt Table: EO_PG_COMP_VW

    13 DATE_IND Character(1) VARCHAR2(1) NOT NULL Date Indicator
    14 OPR_PREDICATE1 Character(2) VARCHAR2(2) NOT NULL Tanslate values in this field are different from those in commercial HRMS and ERP 8 Databases and should be migrated to the Release 8 Currency Conversion Project.
    00=(none)
    01==
    02=<>
    03=<
    04=<=
    05=> .
    06=>=
    07=BETWEEN
    08=NOT BETWEEN
    09=IN
    10=NOT IN
    11=LIKE
    12=NOT LIKE
    13=EXISTS
    14=NOT EXISTS

    Default Value: 00

    15 RCNTL_COMP_NBR Number(3,0) SMALLINT NOT NULL Run Control Component Number

    Prompt Table: EO_CURRCNV_COMP

    16 SELECT_VALUES Character(50) VARCHAR2(50) NOT NULL Selection Values
    17 RIGHT_PAREN Character(1) VARCHAR2(1) NOT NULL Right Parenthesis
    1=)
    2=))
    3=)))
    4=))))
    5=)))))
    6=))))))
    7=)))))))

    Y/N Table Edit

    Default Value: N

    18 SELECT_X Character(1) VARCHAR2(1) NOT NULL Select 'X'
    19 SQL_FUNCTION Character(2) VARCHAR2(2) NOT NULL SQL Function
    1=MAX
    2=MIN
    3=SUM
    4=AVG
    20 SBSEL_RECNAME Character(15) VARCHAR2(15) NOT NULL Subselect Record Name

    Prompt Table: PSRECDEFN

    21 SBSEL_FLDNAME Character(18) VARCHAR2(18) NOT NULL Subselect Field Name

    Prompt Table: EO_RECFIELD5_VW

    22 RCD_ALIAS Character(3) VARCHAR2(3) NOT NULL Record Alias