RA_WAVE_CLA_VW1(SQL View) |
Index Back |
---|---|
CLA Actions for a Wave 2This view will list all CLA actions for a given wave - part 2 |
SELECT H.EOCF_EVENT_ID , G.EOCF_RULESET_ID , E.EOCF_ORDERNUM , H.EOCF_EVENT_NAME , F.EOCF_RULESET_NAME , F.EOCF_IS_NAMED_FLAG , E.EOCF_RSET_ITEM_ID , E.EOCF_RULE_ITEM_TYP FROM PS_EOCF_EVENT_DEFN H , PS_EOCF_EVENT_SEQ G , PS_EOCF_RULESET F , PS_EOCF_RSET_SEQ E WHERE H.EOCF_EVENT_ID = G.EOCF_EVENT_ID AND G.EOCF_RULESET_ID = F.EOCF_RULESET_ID AND F.EOCF_RULESET_ID = E.EOCF_RULESET_ID |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Number(31,0) | DECIMAL(31) NOT NULL | unique identifier for an event definition | |
2 | Number(31,0) | DECIMAL(31) NOT NULL | the ID for a set of policies | |
3 | Number(3,0) | SMALLINT NOT NULL | sequence number for line item rows | |
4 | EOCF_EVENT_NAME | Character(80) | VARCHAR2(80) NOT NULL | user-defined name to identify the characteristics of a particular action |
5 | EOCF_RULESET_NAME | Character(80) | VARCHAR2(80) NOT NULL | the name identifying this ruleset if it has a name |
6 | EOCF_IS_NAMED_FLAG | Character(1) | VARCHAR2(1) NOT NULL | does this object have a user-defined name |
7 | EOCF_RSET_ITEM_ID | Number(31,0) | DECIMAL(31) NOT NULL | a ruleset to use as a line item within another ruleset |
8 | 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 |