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

RC_POLICY_NAME

(SQL View)

AAF Policy Name

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

SELECT B.EOCF_ACTION_ID , A.EOCF_RULE_ID , A.EOCF_RULE_NAME FROM PS_EOCF_RULE_DEFN A , PS_EOCF_ACTION_SET B WHERE B.EOCF_ACTION_SET_ID = A.EOCF_ACTION_SET_ID

Related Language Record: RC_POLICY_NAMEL

# 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 EOCF_RULE_ID Number(31,0) DECIMAL(31) NOT NULL Active Analytics Framework unique identifier for a policy

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	EOCF_RULE_ID	Number(31,0)	DECIMAL(31) NOT NULL	Active Analytics Framework unique identifier for a policy
3	EOCF_RULE_NAME	Character(80)	VARCHAR2(80) NOT NULL	the name of a policy if the policy is named