RA_WAVE_CLA_VW1

(SQL View)
Index Back

CLA Actions for a Wave 2

This 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 EOCF_EVENT_ID Number(31,0) DECIMAL(31) NOT NULL unique identifier for an event definition
2 EOCF_RULESET_ID Number(31,0) DECIMAL(31) NOT NULL the ID for a set of policies
3 EOCF_ORDERNUM 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