EOCF_RULACT1LVW (SQL View)	Index Back
IA Action Types rel lang view Active Analytics Framework IA action types related language view

EOCF_RULACT1LVW

(SQL View)

IA Action Types rel lang view

Active Analytics Framework IA action types related language view

SELECT A.EOCF_RULE_ID , D.LANGUAGE_CD , D.EOCF_ACT_TYP_NAME , F.EOCF_ACTION_OBJ_ID FROM PS_EOCF_RULE_DEFN A , PS_EOCF_ACTION_SET B , PS_EOCF_ACTION_LNG C , PS_EOCF_ACTTYP_LNG D , PS_EOCF_ACTION_DEF F , PS_EOCF_ACTION_OBJ E WHERE A.EOCF_ACTION_SET_ID = B.EOCF_ACTION_SET_ID AND B.EOCF_ACTION_ID = C.EOCF_ACTION_ID AND C.EOCF_ACTION_ID = F.EOCF_ACTION_ID AND F.EOCF_ACTION_TYP_ID = D.EOCF_ACTION_TYP_ID AND C.LANGUAGE_CD = D.LANGUAGE_CD AND F.EOCF_ACTION_OBJ_ID (+) = E.EOCF_ACTION_OBJ_ID AND E.STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EOCF_RULE_ID Number(31,0) DECIMAL(31) NOT NULL Active Analytics Framework unique identifier for a policy

2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

3 EOCF_ACT_TYP_NAME Character(30) VARCHAR2(30) NOT NULL user-defined name to identify the characteristics of a particular action
Prompt Table: EOCF_ACTTYP_LVW

4 EOCF_ACTION_OBJ_ID Number(31,0) DECIMAL(31) NOT NULL Action Id

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EOCF_RULE_ID	Number(31,0)	DECIMAL(31) NOT NULL	Active Analytics Framework unique identifier for a policy
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	EOCF_ACT_TYP_NAME	Character(30)	VARCHAR2(30) NOT NULL	user-defined name to identify the characteristics of a particular action Prompt Table: EOCF_ACTTYP_LVW
4	EOCF_ACTION_OBJ_ID	Number(31,0)	DECIMAL(31) NOT NULL	Action Id