EOCF_RULESET_IDEOCF_RSET_ITEM_ID00=Policy
01=Policy Group
EOCF_RSET_SEQ(SQL Table) |
Index Back |
|---|---|
ruleset detailsruleset detail table holding line-items within the ruleset |
| # | 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_RSET_ITEM_ID |
Number(31,0) | DECIMAL(31) NOT NULL | a ruleset to use as a line item within another ruleset |
| 3 | EOCF_RULE_ITEM_TYP | Character(2) | VARCHAR2(2) NOT NULL |
the choice of rule or ruleset for this ruleset line item
00=Policy 01=Policy Group |
| 4 | EOCF_ORDERNUM | Number(3,0) | SMALLINT NOT NULL | sequence number for line item rows |