RC_POLICY_NAMEL (SQL View)	Index Back
AAF Policy Name view to retrieve the policy name for an action. Used in case history.

RC_POLICY_NAMEL

(SQL View)

AAF Policy Name

view to retrieve the policy name for an action. Used in case history.

SELECT B.EOCF_ACTION_ID , C.LANGUAGE_CD , C.EOCF_RULE_NAME FROM PS_EOCF_RULE_DEFN A , PS_EOCF_ACTION_SET B , PS_EOCF_RULE_LNG C WHERE B.EOCF_ACTION_SET_ID = A.EOCF_ACTION_SET_ID AND A.EOCF_RULE_ID = C.EOCF_RULE_ID

Related Language Record for RC_POLICY_NAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EOCF_ACTION_ID Number(31,0) DECIMAL(31) NOT NULL Active Analytics Framework Action ID field

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

3 EOCF_RULE_NAME Character(80) VARCHAR2(80) NOT NULL the name of a policy if the policy is named

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EOCF_ACTION_ID	Number(31,0)	DECIMAL(31) NOT NULL	Active Analytics Framework Action ID field
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	EOCF_RULE_NAME	Character(80)	VARCHAR2(80) NOT NULL	the name of a policy if the policy is named