RB_RULE_SRCH_VW

(SQL View)
 Index Back

Rule Defn Search page record

Search record used by Rule Definition search page

SELECT DISTINCT DFN.SETID , DFN.RULE_ID , DFN.RULE_TYPE , RUL.PRODUCT_ID , DFN.RULE_STATUS , %Substring(DFN.DESCR254,1,30) , DFN.START_DATE , DFN.END_DATE FROM PS_RB_RULE_DFN_TBL DFN INNER JOIN PS_RB_MLPB_RULE_VW RUL ON RUL.SETID = DFN.SETID AND RUL.RULE_ID = DFN.RULE_ID

  • Related Language Record: RB_RULE_SRC_VWL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

    Default Value: OPR_DEF_TBL_RB.SETID

    Prompt Table: SP_SETID_NONVW

    2 RULE_ID Character(8) VARCHAR2(8) NOT NULL Field used for storing rule id information

    Default Value: NEXT

    3 RULE_TYPE Character(4) VARCHAR2(4) NOT NULL Field used for storing rule type information
    BAR=Brings and Removes
    BOC=Brings On Creation
    CAIN=Commercial Attrs. Incompatible
    CATR=Commercial Attrs. Restriction
    CCVR=Commitment Covering
    CEG=Commercial Eligibility
    CIN=Commercial Incompatibility
    CPRE=Commercial Prerequisite
    CRF=Commercial Relies From
    CRO=Commercial Relies On
    CTRG=Commitment Triggering
    FAIN=Functional Attrs. Incompatible
    FIN=Functional Incompatibility
    FRF=Functional Relies From
    FRO=Functional Relies On
    4 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
    5 RULE_STATUS Character(3) VARCHAR2(3) NOT NULL Field used for storing rule status information
    ACT=Active
    INA=Inactive
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 START_DATE Date(10) DATE Start Date for Gen Standing PO
    8 END_DATE Date(10) DATE End date field to store an end date.