ZCA_AG_RULES_PREVIEW_GT

This table would be populated when the user clicks the "Explore" button and would be retained there-after.

Details

• Schema: FUSION

• Object owner: ZCA

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
zca_ag_rules_preview_gt_PK	RULE_GUID, ACC_EXT_RULE_ID, OBJECT_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
RULE_GUID	VARCHAR2	64		Yes	This field contains the Rule Guid which is a FK to the MOW_RULES table. This would be populated for Custom and Predefined Rules
ACC_EXT_RULE_ID	NUMBER		18	Yes	This field contains the Extension Rule Id which is a FK to the ZCA_AG_ACC_EXT_RULES table. This would be populated for Access Extension Rules
CONDITION_CODE	VARCHAR2	240			This field contains the Condition Code for Predefined Rules
EXTENSION_RULE_FLAG	VARCHAR2	1		Yes	Indicates if this rule is an extension rule. Value of "N" indicates it is a Custom or Predefined Rule.
OBJECT_TYPE_CODE	VARCHAR2	128		Yes	References values in ZCA_OBJECTS.LANG_INDEPENDENT_CODE for both standard and custom objects
OBJECT_ID	NUMBER		18	Yes	PK of the object. Eg., for Opportunity, this column will contain OPTY_ID.
OBJECT_NUMBER	VARCHAR2	300		Yes	PUID of the object. Eg., for Opportunity, this column will contain OPTY_NUMBER.

Indexes

Index	Uniqueness	Columns
ZCA_AG_RULES_PREVIEW_GT_U1	Unique	RULE_GUID, ACC_EXT_RULE_ID, OBJECT_ID