HZ_PARTIES_PURGE

hz_parties_purge table stores all filter parameters used by user while parties purge

Details

• Schema: FUSION

• Object owner: HZ

• Object type: TABLE

• Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
HZ_PARTIES_PURGE_PK	PURGE_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
PURGE_ID	NUMBER		18	Yes	PURGE_ID
OBJECT_NAME	VARCHAR2	120		Yes	OBJECT_NAME
ENABLED_FLAG	VARCHAR2	1			ENABLED_FLAG
CREATED_BY_FILTER	VARCHAR2	120			CREATED_BY_FILTER
CREATION_DATE_FILTER	TIMESTAMP				CREATION_DATE_FILTER
ORIG_SYSTEM	VARCHAR2	120			ORIG_SYSTEM
ORIG_SYSTEM_REFERENCE	VARCHAR2	120			ORIG_SYSTEM_REFERENCE
LAST_UPDATE_DATE_FILTER	TIMESTAMP				LAST_UPDATE_DATE_FILTER
PARTY_NUMBER	VARCHAR2	120			PARTY_NUMBER
CREATED_BY_MODULE_FILTER	VARCHAR2	64			CREATED_BY_MODULE_FILTER
AGED_BY	NUMBER		9		AGED_BY
STATUS	VARCHAR2	300			STATUS
CREATION_DATE_TIMESTAMP	TIMESTAMP				CREATION_DATE_TIMESTAMP
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.

Indexes

Index	Uniqueness	Tablespace	Columns
HZ_PARTIES_PURGE_N1	Non Unique	Default	OBJECT_NAME
HZ_PARTIES_PURGE_U1	Unique	Default	PURGE_ID