PSC_PZ_PARCEL_TRANS_OWNER
This is a setup table that contains parcel ownership information for the parcels of real estate of a city, county, or state.
Details
-
Schema: FUSION
-
Object owner: PSC_CC
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
| Name | Columns |
|---|---|
|
PSC_PZ_PARCEL_TRANS_OWNER_PK |
PARCEL_TRX_OWN_KEY |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| PARCEL_TRX_OWN_KEY | NUMBER | 18 | Yes | System generated key to identify the parcel transaction owners. | ||
| PARCEL_TRX_OWN_PUID | VARCHAR2 | 480 | Yes | Alternate key used by CRM Import | ||
| PARCEL_TRX_DTL_KEY | NUMBER | 18 | Yes | System generated key to identify the parcel transaction parcels. | ||
| 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 or split existing parcels generating new ones, or to perform lot line adjustment on existing parcels. | ||
| 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. | |||
| 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. | |||
| PARENT_PARCEL_ID | NUMBER | 18 | Identifier of the disabled parent parcel after a parcel split or merge. | |||
| PARENT_PARCEL_ID_ENTERED | VARCHAR2 | 50 | Assessor Parcel Number of the Parent Parcel. | |||
| ASSIGNED_TO_CHILD | VARCHAR2 | 50 | This parent owner was assigned to this child parcel | |||
| SUMMARY_ROW | VARCHAR2 | 1 | Determines if this row displays summary owner assignment information for this child parcel | |||
| DISPLAY_PARENT_PARCEL | VARCHAR2 | 50 | Parent Parcel of the assigned owner | |||
| PROVINCE | VARCHAR2 | 60 | Province in which the address of the parcel owner is located. | |||
| POSTAL_PLUS4_CODE | VARCHAR2 | 10 | For US addresses, the full postal code is often quoted as a 5 digit number, followed by a 4 digit number. This column represents the second number having 4 digits. | |||
| COUNTY | VARCHAR2 | 60 | County in which the address of the parcel owner is located. | |||
| OWNER_CODE | VARCHAR2 | 32 | Unique identifier for the parcel owner. | |||
| OWNER_ID | NUMBER | 18 | System generated sequence key for the parcel owner. | Active | ||
| ENABLED_FLAG | VARCHAR2 | 1 | Attribute that indicates whether the parcel owner information is available for use. | Active | ||
| OWNER_TYPE | VARCHAR2 | 20 | Identifier to classify the parcel owner into groups of common characteristics. | Active | ||
| NAME1 | VARCHAR2 | 150 | First Name that identifies the parcel owner. | Active | ||
| NAME2 | VARCHAR2 | 150 | Second Name that identifies the parcel owner. | Active | ||
| ADDRESS1 | VARCHAR2 | 240 | Address Line 1 that is part of the parcel owner address. | Active | ||
| ADDRESS2 | VARCHAR2 | 240 | Address Line 2 that is part of the parcel owner address. | Active | ||
| ADDRESS3 | VARCHAR2 | 240 | Address Line 3 that is part of the parcel owner address. | Active | ||
| ADDRESS4 | VARCHAR2 | 240 | Address Line 4 that is part of the parcel owner address. | Active | ||
| CITY | VARCHAR2 | 60 | City that is part of the parcel owner address. | Active | ||
| POSTAL_CODE | VARCHAR2 | 60 | Postal code that is part of the parcel owner address. | Active | ||
| COUNTRY | VARCHAR2 | 3 | Country that is part of the parcel owner address. | Active | ||
| STATE | VARCHAR2 | 60 | State that is part of the parcel owner address. | Active | ||
| STREET_NUMBER | VARCHAR2 | 20 | Street number used for parcel owner address searches. | Active | ||
| STREET_DIRECTION | VARCHAR2 | 10 | Street direction used for parcel owner address searches. | Active | ||
| STREE_NAME | VARCHAR2 | 240 | Street name used for parcel owner address searches. | Active | ||
| STREET_TYPE | VARCHAR2 | 20 | Street type used for parcel owner address searches. | Active | ||
| BUILDING_TYPE | VARCHAR2 | 20 | Buiding type used for parcel owner address searches. | Active | ||
| FLOOR | VARCHAR2 | 20 | Floor number used for parcel owner address searches. | Active | ||
| UNIT_NUMBER | VARCHAR2 | 30 | Apartment unit number used for parcel owner address searches. | Active | ||
| ADDRESS_FIELD1 | VARCHAR2 | 20 | Additional parcel owner address information 1 used for parcel owner address searches. | Active | ||
| ADDRESS_FIELD2 | VARCHAR2 | 20 | Additional parcel owner address information 2 used for parcel owner address searches. | Active | ||
| ADDRESS_FIELD3 | VARCHAR2 | 20 | Additional parcel owner address information 3 used for parcel owner address searches. | Active | ||
| EMAIL_ID | VARCHAR2 | 50 | Email id of the owner of the parcel. | Active | ||
| HOME_PHONE_COUNTRY | VARCHAR2 | 10 | Phone country code of the home phone number of the parcel owner. | Active | ||
| HOME_PHONE_NUM | VARCHAR2 | 40 | Home phone number of the parcel owner. | Active | ||
| WORK_PHONE_COUNTRY | VARCHAR2 | 10 | Phone country code of the work phone number of the parcel owner. | Active | ||
| WORK_PHONE_NUM | VARCHAR2 | 40 | Work phone number of the parcel owner. | Active | ||
| CELL_PHONE_COUNTRY | VARCHAR2 | 10 | Phone country code of the cell phone number of the parcel owner. | Active | ||
| CELL_PHONE_NUM | VARCHAR2 | 40 | Cell phone number of the parcel owner. | Active | ||
| FAX_COUNTRY | VARCHAR2 | 10 | Country code of the fax number of the parcel owner. | Active | ||
| FAX_NUM | VARCHAR2 | 40 | Fax number of the parcel owner. | Active | ||
| LAST_TRANSFER_TYPE | VARCHAR2 | 50 | Identifier that classifies transfer of parcel ownerships into groups of common characteristics. | Active | ||
| LAST_TRANSFER_DATE | DATE | Date when the parcel changed owner previously. | Active | |||
| DOCUMENT_NUM | VARCHAR2 | 50 | Document number recording previous transfer of ownership. | Active | ||
| TEMPORARY | VARCHAR2 | 1 | Determines if this row is part of the final transaction. | |||
| SELECTED | VARCHAR2 | 1 | Determines if this child parcel is using this owner from this parent parcel. | |||
| 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. | Active | |
| PRIMARY_FLAG | VARCHAR2 | 1 | Identifies the parcel owner as the primary owner. | Active | ||
| 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. | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | Active | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | Active | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | Active | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | Active | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | Active |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| PSC_PZ_PARCEL_TRANS_OWNER | psc_pz_parcel_trans_dtl | PARCEL_TRX_DTL_KEY |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PSC_PZ_PARCEL_TRANS_OWNER_PK | Unique | Default | PARCEL_TRX_OWN_KEY |