SCC_ENT_STMTLVW

(SQL View)
 Index Back

Rule Engine Entity Search

This related language view is used to search for entities used by statements in the rules engine.

SELECT A.SCC_ENTITY_ID , L.LANGUAGE_CD , L.SCC_ENTITY_NAME , L.SCC_ENTITY_DESCR FROM PS_SCC_ENTITY_REG A , PS_SCC_ENT_REG_LNG L WHERE A.SCC_ENTITY_ID = L.SCC_ENTITY_ID

  • Related Language Record for SCC_ENT_STMT_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCC_RULE_STMT_ENT Character(40) VARCHAR2(40) NOT NULL This field is used to assign entities when using for-each statements in the rules engine.
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 SCC_ENTITY_NAME Character(30) VARCHAR2(30) NOT NULL Entitiy Name
    4 SCC_ENTITY_DESCR Character(254) VARCHAR2(254) NOT NULL Entitiy Description