SCC_RULE_LV_SRL

(SQL View)
 Index Back

Rules Engine LOV Search

This view is used to search for a valid LOV in the rules engine.

SELECT A.SCC_LOV_UID ,A.SCC_SL_LOV_CONTEXT ,A.RECNAME ,A.FIELDNAME ,XL.LANGUAGE_CD ,XL.XLATLONGNAME FROM PS_SCC_SL_LOV_HDR A , PSXLATITEM X , PSXLATITEMLANG XL WHERE X.FIELDNAME = 'SCC_LOV_TYPE' AND X.FIELDVALUE = A.SCC_LOV_TYPE AND X.EFFDT = ( SELECT MAX(X1.EFFDT) FROM PSXLATITEM X1 WHERE X1.FIELDNAME = X.FIELDNAME AND X1.FIELDVALUE = X.FIELDVALUE AND X1.EFFDT <= %CurrentDateIn AND X1.EFF_STATUS = 'A') AND X.FIELDNAME = XL.FIELDNAME AND X.FIELDVALUE = XL.FIELDVALUE AND X.EFFDT = XL.EFFDT

  • Related Language Record for SCC_RULE_LV_SRC

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCC_LOV_UID Character(40) VARCHAR2(40) NOT NULL LOV Unique ID
    2 SCC_SL_LOV_CONTEXT Character(25) VARCHAR2(25) NOT NULL LOV Context
    3 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

    Prompt Table: PSRECDEFN

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

    Prompt Table: PSRECFIELDALL

    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 SCC_RULE_LOV_TDSCR Character(30) VARCHAR2(30) NOT NULL This field is used to hold the LOV Type translate value in the search views in the rules engine.