EOCF_RULESET(SQL Table) |
Index Back |
---|---|
ruleset definitionruleset definition |
# | 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. |