EOCF_RULESET

(SQL Table)
Index Back

ruleset definition

ruleset definition

  • Related Language Record: EOCF_RSET_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EOCF_RULESET_ID Number(31,0) DECIMAL(31) NOT NULL the ID for a set of policies
    2 EOCF_RULESET_NAME Character(80) VARCHAR2(80) NOT NULL the name identifying this ruleset if it has a name
    3 EOCF_RSET_STATUS Character(1) VARCHAR2(1) NOT NULL policy group status
    A=Active
    I=Inactive
    U=In Design

    Default Value: U

    4 EOCF_FIRING_LIMIT Number(3,0) SMALLINT NOT NULL the maximum number of rules from a ruleset to fire
    5 EOCF_FIRING_POLICY Character(2) VARCHAR2(2) NOT NULL choice of how rules should be fired
    00=Fire Any
    01=Execute All
    02=Execute Limited Number
    6 EOCF_ACTION_SET_ID Number(31,0) DECIMAL(31) NOT NULL set of actions to be run from an event
    7 EOCF_PHRASE_ID Number(31,0) DECIMAL(31) NOT NULL the unique identifier for a phrase definition (ignoring versioning)
    8 EOCF_IS_NAMED_FLAG Character(1) VARCHAR2(1) NOT NULL does this object have a user-defined name
    9 DESCRLONG Long Character CLOB Long Description
    10 EOCF_CREATEDTTM DateTime(26) TIMESTAMP CLAF - Created DateTime
    11 EOCF_CREATEOPRID Character(30) VARCHAR2(30) NOT NULL A user's ID
    12 EOCF_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.
    13 EOCF_LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry.