HZ_ADDTNL_PARTYIDS

Details

Schema: FUSION
Object owner: HZ
Object type: TABLE
Tablespace: INTERFACE

Columns

Name	Datatype	Length	Precision	Not-null	Comments
BATCH_ID	NUMBER		18	Yes	Unique Identifier for a Batch.
INTERFACE_ROW_ID	NUMBER		18	Yes	Unique identifier of the HZ_ACCOUNTS_INT interface record.
IMPORT_STATUS_CODE	VARCHAR2	30			Status code for Import.
ACTION_CODE	VARCHAR2	30			Indicates action entered by user.
INTERNAL_ACTION_CODE	VARCHAR2	30			Indicates the action of insert or update for internal use.
FILE_RECORD_NUM	NUMBER		10		This column is required by file import to relate record in the interface table to the file row.
FILE_NAME_SYSTASK_ID	NUMBER		18		Stores systask id for each import csv file.
CREATED_BY	VARCHAR2	64			Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP				Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64			Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP				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.
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or 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.
PARTY_ID	NUMBER		18		Identifier of the Party.
PARTY_NUMBER	VARCHAR2	30			Unique identification number for this party.
PARTY_SOURCE_SYSTEM	VARCHAR2	30			Original System for the Party.
PARTY_SOURCE_SYSTEM_REFERENCE	VARCHAR2	240			Original System Reference for the Party.
SOURCE_SYSTEM	VARCHAR2	30			Original System for the additional PartyId.
SOURCE_SYSTEM_REFERENCE	VARCHAR2	240			Original System Reference for the additional PartyId.
PARTY_IDENTIFIER_ID	NUMBER		18		Unique identifier of the base table hz_addtnl_partyids_int.
PARTY_IDENTIFIER_TYPE	VARCHAR2	30			Identifier type for this ID. Values are defined in TYPE_CODE of HZ_NAME_AND_ID_TYPE_B. The party type should be consistent with the party type that the PARTY_IDENTIFIER_TYPE can be applied to.
PARTY_IDENTIFIER_VALUE	VARCHAR2	60			Value of the Identifier for the Party.
STATUS_FLAG	VARCHAR2	1			Record Status Flag used to soft delete entity. Possible values are 'A' (active), 'I' (inactive).
COUNTRY	VARCHAR2	2			Foreign key to FND_TERRITORY. TERRITORY_CODE.From UI, COUNTRY and STATE should be displayed based on geography setup. Used for certain types of identifiers such as Passports or Driving licenses.
STATE_PROVINCE	VARCHAR2	60			From UI, COUNTRY and STATE should be displayed based on geography setup. Used for certain types of identifiers such as Passports or Driving licenses.
ISSUING_AUTHORITY_NAME	VARCHAR2	500			Name of the Issuing authority.
ISSUING_AUTHORITY_PARTY_ID	NUMBER		18		Party Id of the issuing authority, if that happens to be in the system.
ISSUE_DATE	DATE				Date in which the Identifier was issued. It may be NULL as it does not apply to all types of identifiers.
EXPIRATION_DATE	DATE				Expiration date for the identifier. It may be NULL as it does not apply to all types of identifiers.
DESCRIPTION	VARCHAR2	240			Free text comment/description.

Indexes

Index	Uniqueness	Tablespace	Columns
HZ_ADDTNL_PARTYIDS_INT_N1	Non Unique	Default	BATCH_ID, IMPORT_STATUS_CODE, INTERNAL_ACTION_CODE, PARTY_IDENTIFIER_TYPE, PARTY_IDENTIFIER_VALUE
HZ_ADDTNL_PARTYIDS_INT_N2	Non Unique	Default	BATCH_ID, PARTY_ID, PARTY_IDENTIFIER_TYPE, PARTY_IDENTIFIER_VALUE, STATUS_FLAG
HZ_ADDTNL_PARTYIDS_INT_N3	Non Unique	Default	BATCH_ID, PARTY_IDENTIFIER_ID
HZ_ADDTNL_PARTYIDS_INT_U1	Unique	Default	BATCH_ID, INTERFACE_ROW_ID