PSC_PZ_PARCEL_TRANS_DTL
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_DTL_PK |
PARCEL_TRX_DTL_KEY |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PARCEL_TRX_DTL_KEY | NUMBER | 18 | Yes | System generated key to identify the parcel transaction detail. | |
| PARCEL_TRX_DTL_PUID | VARCHAR2 | 480 | Yes | Alternate key used by CRM Import. | |
| PARCEL_TRX_KEY | NUMBER | 18 | Yes | System generated key to identify the parcel transaction. Parcel transactions can be used to merge, split or to adjust lot alignment. | |
| PARCEL_TRX_PUID | VARCHAR2 | 480 | Yes | Alternate key used by CRM import. | |
| PARCEL_ID_ENTERED | VARCHAR2 | 50 | Identifier given by the user for the parcel of real estate. In the USA this is the Assessor Parcel Number. | ||
| PARCEL_ID | NUMBER | 18 | System generated key to identify the parcel of real estate | ||
| PROV_PARCEL_ID_ENTERED | VARCHAR2 | 50 | Provisional parcel id | ||
| FINAL_PARCEL_ID_ENTERED | VARCHAR2 | 50 | Identifier given by the user for the parcel of real estate. In the USA, this is the assessor Parcel Number. | ||
| RELATIONSHIP | VARCHAR2 | 15 | Yes | Identifies the realationship of the parcel within a transaction | |
| PROVISIONAL_PARCEL_NB | VARCHAR2 | 5 | Flag to indicate if this is a provisional parcel number | ||
| TEMPORARY | VARCHAR2 | 1 | Determines if this row is part of the final transaction. | ||
| EXISTING_PARCEL | 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 the field TEMPORARY to implement temporary saving logic and allow functional row back in case the user cancels the transaction changes. | ||
| 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 |
| psc_pz_parcel_trans_condition | psc_pz_parcel_trans_dtl | PARCEL_TRX_DTL_KEY |
| psc_pz_parcel_trans_owner | psc_pz_parcel_trans_dtl | PARCEL_TRX_DTL_KEY |
| psc_pz_parcel_trans_district | psc_pz_parcel_trans_dtl | PARCEL_TRX_DTL_KEY |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PSC_PZ_PARCEL_TRANS_DTL_PK | Unique | Default | PARCEL_TRX_DTL_KEY |