SCC_ENT_RULE_VW

(SQL View)
 Index Back

Entity Rule View

This view is used to search for entities in the rules engine.

SELECT SCC_ENTITY_ID , SCC_ENTITY_NAME , SCC_ENTITY_DESCR , SCC_APPCLASSNAME , SCC_STATUS FROM PS_SCC_ENTITY_REG

  • Related Language Record: SCC_ENT_RULELVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCC_RULE_BASE_ENT Character(40) VARCHAR2(40) NOT NULL This field is used to identify the base entity attached to a rule in the Rules Engine
    2 SCC_ENTITY_NAME Character(30) VARCHAR2(30) NOT NULL Entitiy Name
    3 SCC_ENTITY_DESCR Character(254) VARCHAR2(254) NOT NULL Entitiy Description
    4 SCC_APPCLASSNAME Character(190) VARCHAR2(190) NOT NULL Used to represent an application class as a single string. Usually RTRIM(PACKAGEROOT) + ':' + RTRIM(QUALIFYPATH) + ':' + RTRIM(APPCLASSID)

    Prompt Table: HRS_APPCLASS_PT

    5 SCC_STATUS Character(1) VARCHAR2(1) NOT NULL Transaction Status
    A=Active
    I=Inactive