PSC_COM_PARCEL_IMP_OPTIONS
This is a setup table that contains parcel information for the parcels of real estate of a city, county, or state.
Details
-
Schema: FUSION
-
Object owner: PSC_CC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
PSC_COM_PARCEL_IMP_OPT_PK |
AGENCY_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| AGENCY_ID | NUMBER | 8 | Yes | Attribute identifying the agency associated with the row. | ||
| MISSING_PARCEL_FLAG | VARCHAR2 | 1 | When a parcel is missing in the import file, it will be retired. | |||
| MISSING_ADDRESS_FLAG | VARCHAR2 | 1 | When an address is missing in the import file, it will be disabled. | |||
| MISSING_OWNER_FLAG | VARCHAR2 | 1 | When an owner is missing in the import file, it will be disabled. | |||
| MISSING_DISTRICT_FLAG | VARCHAR2 | 1 | When a district is missing in the import file, it will be disabled. | |||
| STREET_NUMBER_FLAG | VARCHAR2 | 1 | STREET_NUMBER value will be used for address comparison during import process. | |||
| STREET_TYPE_FLAG | VARCHAR2 | 1 | STREET_TYPE value will be used for address comparison during import process. | |||
| STREET_DIRECTION_FLAG | VARCHAR2 | 1 | STREET_DIRECTION value will be used for address comparison during import process. | |||
| STREET_NAME_FLAG | VARCHAR2 | 1 | STREET_NAME value will be used for address comparison during import process. | Active | ||
| STREET_SUFFIX_FLAG | VARCHAR2 | 1 | STREET_SUFFIX value attribute will be used for address comparison during import process. | |||
| UNIT_NUMBER_FLAG | VARCHAR2 | 1 | UNIT_NUMBER value will be used for address comparison during import process. | |||
| FLOOR_FLAG | VARCHAR2 | 1 | FLOOR value will be used for address comparison during import process. | |||
| CITY_FLAG | VARCHAR2 | 1 | CITY value will be used for address comparison during import process. | |||
| STATE_FLAG | VARCHAR2 | 1 | STATE value will be used for address comparison during import process. | |||
| POSTAL_CODE_FLAG | VARCHAR2 | 1 | POSTAL_CODE value will be used for address comparison during import process. | |||
| ADDRESS1_FLAG | VARCHAR2 | 1 | ADDRESS1 value will be used for address comparison during import process. | Active | ||
| ADDRESS2_FLAG | VARCHAR2 | 1 | ADDRESS2 value will be used for address comparison during import process. | Active | ||
| NAME1_FLAG | VARCHAR2 | 1 | NAME1 value will be used for owner comparison during import process. | Active | ||
| NAME2_FLAG | VARCHAR2 | 1 | NAME2 value will be used for owner comparison during import process. | Active | ||
| OWNER_ADDRESS1_FLAG | VARCHAR2 | 1 | OWNER_ADDRESS1 value will be used for owner comparison during import process. | Active | ||
| OWNER_ADDRESS2_FLAG | VARCHAR2 | 1 | OWNER_ADDRESS2 value will be used for owner comparison during import process. | |||
| OWNER_STATE_FLAG | VARCHAR2 | 1 | OWNER_STATE value will be used for owner comparison during import process. | |||
| OWNER_CITY_FLAG | VARCHAR2 | 1 | OWNER_CITY value will be used for owner comparison during import process. | |||
| OWNER_POSTAL_CODE_FLAG | VARCHAR2 | 1 | OWNER_POSTAL_CODE value will be used for owner comparison during import process. | |||
| EMAIL_ID_FLAG | VARCHAR2 | 1 | EMAIL_ID value will be used for owner comparison during import process. | Active | ||
| HOME_PHONE_COUNTRY_FLAG | VARCHAR2 | 1 | HOME_PHONE_COUNTRY value will be used for owner comparison during import process. | Active | ||
| HOME_PHONE_NUM_FLAG | VARCHAR2 | 1 | HOME_PHONE_NUM value will be used for owner comparison during import process. | Active | ||
| WORK_PHONE_COUNTRY_FLAG | VARCHAR2 | 1 | WORK_PHONE_COUNTRY value will be used for owner comparison during import process. | Active | ||
| WORK_PHONE_NUM_FLAG | VARCHAR2 | 1 | WORK_PHONE_NUM value will be used for owner comparison during import process. | Active | ||
| CELL_PHONE_COUNTRY_FLAG | VARCHAR2 | 1 | CELL_PHONE_COUNTRY value will be used for owner comparison during import process. | Active | ||
| CELL_PHONE_NUM_FLAG | VARCHAR2 | 1 | CELL_PHONE_NUM value will be used for owner comparison during import process. | Active | ||
| OPTIONAL_PROCESS_01 | VARCHAR2 | 20 | Optional process run during parcel import process. | |||
| OPTIONAL_PROCESS_02 | VARCHAR2 | 20 | Optional process run during parcel import process. | |||
| OPTIONAL_PROCESS_03 | VARCHAR2 | 20 | Optional process run during parcel import process. | |||
| OPTIONAL_PROCESS_04 | VARCHAR2 | 20 | Optional process run during parcel import process. | |||
| OPTIONAL_PROCESS_05 | VARCHAR2 | 20 | Optional process run during parcel import process. | |||
| OPTIONAL_PROCESS_06 | VARCHAR2 | 20 | Optional process run during parcel import process. | |||
| OPTIONAL_PROCESS_07 | VARCHAR2 | 20 | Optional process run during parcel import process. | |||
| OPTIONAL_PROCESS_08 | VARCHAR2 | 20 | Optional process run during parcel import process. | |||
| OPTIONAL_PROCESS_09 | VARCHAR2 | 20 | Optional process run during parcel import process. | |||
| IMPORT_PARCEL_FLAG | VARCHAR2 | 1 | Perform parcel import as part of the import process. | |||
| IMPORT_PARCEL_ADDRESS_FLAG | VARCHAR2 | 1 | Perform parcel address import as part of the import process. | |||
| IMPORT_PARCEL_OWNER_FLAG | VARCHAR2 | 1 | Perform parcel owner import as part of the import process. | |||
| IMPORT_PARCEL_DISTRICT_FLAG | VARCHAR2 | 1 | Perform parcel district import as part of the import process. | |||
| IMPORT_PARCEL_VALUE_FLAG | VARCHAR2 | 1 | Perform parcel value import as part of the import process. | |||
| IMPORT_ADDRESS_DISTRICT_FLAG | VARCHAR2 | 1 | Perform address district import as part of the import process. | |||
| MAP_PARCEL | VARCHAR2 | 50 | Map applied to parcel file data during import process. | |||
| MAP_PARCEL_ADDRESS | VARCHAR2 | 50 | Map applied to parcel address file data during import process. | |||
| MAP_PARCEL_OWNER | VARCHAR2 | 50 | Map applied to parcel owner file data during import process. | |||
| MAP_PARCEL_DISTRICT | VARCHAR2 | 50 | Map applied to parcel district file data during import process. | |||
| MAP_PARCEL_VALUE | VARCHAR2 | 50 | Map applied to parcel value file data during import process. | |||
| MAP_ADDRESS_DISTRICT | VARCHAR2 | 50 | Map applied to address district file data during import process. | |||
| PREVIEW_MODE | VARCHAR2 | 1 | Perform parcel import process in preview mode. | |||
| 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 | |
| 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. | |||
| MISSING_PARCON_FLAG | VARCHAR2 | 1 | Yes | When a parcel condition is missing in the import file, it will be resolved. | ||
| MISSING_ADDCON_FLAG | VARCHAR2 | 1 | Yes | When an address condition is missing in the import file, it will be resolved. | ||
| IMPORT_PARCEL_CONDITION_FLAG | VARCHAR2 | 1 | Yes | Perform parcel condition import as part of the import process. | ||
| IMPORT_ADDRESS_CONDITION_FLAG | VARCHAR2 | 1 | Yes | Perform address condition import as part of the import process. |
Indexes
| Index | Uniqueness | Tablespace | Columns | Status |
|---|---|---|---|---|
| PSC_COM_PARCEL_IMP_OPTIONS_PK | Unique | Default | AGENCY_ID | Active |