ZCA_SIGNAL_ATTRIBUTES

ZCA_SIGNAL_ATTRIBUTES: This table stores the attribute values for a signal definition generated by a Business Object event.

Details

• Schema: FUSION

• Object owner: ZCA

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
ZCA_SIGNAL_ATTRIBUTES_PK	SIGNAL_ATTRIBUTE_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
SIGNAL_ATTRIBUTE_ID	NUMBER		18	Yes	Auto generated primary key of the table
SIGNAL_ID	NUMBER		18	Yes	Parent foreign key referring to ZCA_SIGNALS table.
ATTR_VALUE_TYPE	VARCHAR2	1		Yes	Discriminator column to determine whether row is for a single value, or for an "Old and New" value. 'S' (simple) or 'C' (change value)
ATTR_OBJECT_NAME	VARCHAR2	128		Yes	The name of the object or related object to which the attribute value belongs
ATTR_NAME	VARCHAR2	100		Yes	Name of attribute this row represents
PRIMARY_KEY_FLAG	VARCHAR2	1			Specifies whether this is a PK attribute
PUID_FLAG	VARCHAR2	1			Specifies whether this is a PUID attribute
ATTR_VALUE	VARCHAR2	1000			Value of attribute this row represents.
ATTR_OLD_VALUE	VARCHAR2	1000			Old value of attribute this row represents - only applies to rows where ATTR_VALUE_TYPE = 'C'.
PII_TARGET_ENTITY_ID	NUMBER		18		Stores the ID of the target PII Entity when the current attribute was generated from an object that is potentially subject to PII visibility rules.
PII_CONSTRAINT_TYPE	VARCHAR2	64			Stores the type of PII constraint to apply when the current attribute was generated from an object that is potentially subject to PII visibility rules.
PII_ENTITY_ATTR_NAME	VARCHAR2	128			Stores the Entity Name of the target PII Entity when the current attribute was generated from an object that is potentially subject to PII visibility rules.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.

Foreign Keys

Table	Foreign Table	Foreign Key Column
ZCA_SIGNAL_ATTRIBUTES	zca_signals	SIGNAL_ID

Indexes

Index	Uniqueness	Tablespace	Columns
ZCA_SIGNAL_ATTRIBUTES_N1	Non Unique	Default	SIGNAL_ID, ATTR_OBJECT_NAME, PUID_FLAG
ZCA_SIGNAL_ATTRIBUTES_U1	Unique	Default	SIGNAL_ATTRIBUTE_ID