PSC_PZ_PARCEL_TRANS_HDR

This is a transaction table that contains information of transactions such as Parcel merges, splits, lot alignment.

Details

• Schema: FUSION

• Object owner: PSC_CC

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
PSC_PZ_PARCEL_TRANS_HDR_PK	PARCEL_TRX_KEY

Columns

Name	Datatype	Length	Precision	Not-null	Comments
PARCEL_TRX_KEY	NUMBER		18	Yes	System generated key to identify the parcel transaction. Parcel transactions can be used to merge or split existing parcels generating new ones, or to perform lot line adjustment on existing parcels.
PARCEL_TRX_PUID	VARCHAR2	480		Yes	Alternate key used by CRM Import
PARCEL_TRX_DTTM	TIMESTAMP			Yes	Date in which the parcel transaction was performed.
PARCEL_TRX_TYPE	VARCHAR2	20		Yes	Type of parcel transaction being performed. It can be merge, split or lot line adjustment.
PARCEL_TRX_STATUS	VARCHAR2	10			Status of the parcel transaction.
PARENT_PARCEL	VARCHAR2	50			The parent parcel of the parcel transaction
CHILD_PARCEL	VARCHAR2	50			The child parcel of the parcel transaction
LNP_RECORD_KEY	NUMBER		18		Permit that authorized the parcel transaction.
LNP_RECORD_ID	VARCHAR2	50			This is the id of the permit used to authorize the parcel transaction.
TEMPORARY	VARCHAR2	1			Determines if this row is part of the final transaction.
PREVIOUS_STATE	VARCHAR2	20			Store the previous state of the row. This field is used together with field TEMPORARY to implement temporary saving logic and allow functional row back in case the user cancels the transaction changes.
GROUP_ID	NUMBER		18		Internal Id that allows grouping transactions.
MIGRATED_DATA_FLAG	VARCHAR2	3			Indicates In-flight or Historical transaction for data migration
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.
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.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated 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.

Foreign Keys

Table	Foreign Table	Foreign Key Column
psc_pz_parcel_trans_dtl	psc_pz_parcel_trans_hdr	PARCEL_TRX_KEY

Indexes

Index	Uniqueness	Tablespace	Columns
PSC_PZ_PARCEL_TRANS_HDR_PK	Unique	Default	PARCEL_TRX_KEY