PSC_COM_PARCEL_IMPORT_INT
The interface table psc_com_parcel_import_int stores information for parcels and load into PSC_COM_PARCEL_TL and PSC_COM_PARCEL_B tables.
Details
-
Schema: FUSION
-
Object owner: PSC_CC
-
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 psc_com_parcel_import_int interface record. Internal use only. | |
| 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 | 18 | 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. | ||
| ERROR_MESSAGE | VARCHAR2 | 3000 | Indicates the error associated with the row in the interface table. | ||
| LANGUAGE | VARCHAR2 | 4 | Yes | Indicates the code of the language into which the contents of the translatable columns are translated. | |
| SOURCE_LANG_FLAG | VARCHAR2 | 1 | The purpose of this flag is to identify the row that will be responsible to perform update/insert on the _B table in the fusion schema. If the value is ''Y'', the row will be used to Perform insert/update in _B table.Create rows in _TL table for languages that are enabled in fusion but have no data in the interface table. | ||
| PARCEL_ID | NUMBER | 18 | System generated key to identify the parcel of real estate. | ||
| PROV_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. | ||
| 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. | ||
| 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. | ||
| PARCEL_TYPE | VARCHAR2 | 30 | Attribute that classifies parcels into groups of similar characteristics. | ||
| ENABLED_FLAG | VARCHAR2 | 1 | Attribute that indicates whether the parcel of real estate is available for use. | ||
| JURISDICTION | VARCHAR2 | 50 | Name of the city or county that has jurisdiction over the parcel of real estate. | ||
| PRIMARY_ZONING_ID | VARCHAR2 | 30 | Identifier for the zoning of the parcel of real estate. | ||
| BLOCK_NUM | VARCHAR2 | 30 | Identifier for the block number of the land information related to the parcel of real estate. In the USA, this is part of the Assessor Parcel Number. | ||
| UNIT_NUM | VARCHAR2 | 30 | Identifier for the unit number of the land information related to the parcel of real estate. In the USA, this is part of the Assessor Parcel Number. | ||
| LOT_NUM | VARCHAR2 | 30 | Identifier for the lot number of the land information related to the parcel of real estate. In the USA, this is part of the Assessor Parcel Number. | ||
| BOOK_NUM | VARCHAR2 | 30 | Location information for the city, county, or state records that refer to the book where a user can find information about the parcel of real estate. | ||
| SECTION_NUM | VARCHAR2 | 30 | Location information for the city, county, or state records that contain information about the parcel of real estate. | ||
| PAGE_NUM | VARCHAR2 | 30 | Location information for the city, county, or state records that refer to a page in the book where a user can find information about the parcel of real estate. | ||
| SUBDIVISION | VARCHAR2 | 30 | Land information about the location of the parcel of real estate. | ||
| LAND_USE_CODE | VARCHAR2 | 30 | Zoning information related to the location of the parcel of real estate. | ||
| MAP_NAME | VARCHAR2 | 50 | Location information for the city, county, or state records that refer to the map where a user can find information about the parcel of real estate. | ||
| MAP_BOOK_PAGE | VARCHAR2 | 50 | Location information for the city, county, or state records that refer to the map, book, an page, where a user can find information about the parcel of real estate. | ||
| LONGITUDE | NUMBER | Geographical longitude location of the parcel. | |||
| LATITUDE | NUMBER | Geographical latitude location of the parcel. | |||
| SRID | NUMBER | 10 | Spatial Reference System Identifier (SRID) is a unique value used to unambiguously identify projected, unprojected, and local spatial coordinate system definitions for the parcel. | ||
| MODULE_ID | VARCHAR2 | 32 | Seed Data Framework: indicates the module that owns the row. A module is an entry in Application Taxonomy such as a Logical Business Area. When the MODULE_ID column exists and the owner of the row is not specified, then the Seed Data Framework will not extract the row as seed data. | ||
| COORDINATE_X | NUMBER | Geographic x coordinate of the parcel location. | |||
| COORDINATE_Y | NUMBER | Geographic y coordinate of the parcel location. | |||
| PARCEL_STATUS | VARCHAR2 | 20 | This column describes the status of the parcel. | ||
| PARCEL_SIZE1 | NUMBER | 20 | Size of the parcel. | ||
| PARCEL_SIZE1_UNIT | VARCHAR2 | 10 | Unit of measurement for the size of the parcel. | ||
| PARCEL_SIZE2 | NUMBER | 20 | Alternate size of the parcel. | ||
| PARCEL_SIZE2_UNIT | VARCHAR2 | 10 | Unit of measurement for the alternate size of the parcel. | ||
| STRUCTURE_SIZE1 | NUMBER | 20 | Size of the structure. | ||
| STRUCTURE_SIZE1_UNIT | VARCHAR2 | 10 | Unit of measurement for the size of the structure. | ||
| STRUCTURE_SIZE2 | NUMBER | 20 | Alternate size of the structure. | ||
| STRUCTURE_SIZE2_UNIT | VARCHAR2 | 10 | Unit of measurement for the alternate size of the structure. | ||
| DWELLING_UNIT_COUNT | NUMBER | 10 | Number of Dwelling Units. | ||
| ZONING_CODE2 | VARCHAR2 | 30 | Secondary Zoning Code of the zoning related to the parcel. | ||
| GENERAL_PLAN2 | VARCHAR2 | 30 | Alternate Land Information of the Parcel. | ||
| TAX_RATE_AREA | VARCHAR2 | 100 | Area Identifier of the parcel location for taxation purposes. | ||
| CENSUS_TRACT | VARCHAR2 | 100 | Neighborhood information related to the location of the parcel. | ||
| CENSUS_BLOCK | VARCHAR2 | 100 | Neighborhood information related to the location of the parcel. | ||
| CLIMATE_ZONE | VARCHAR2 | 100 | Detailed land information of the parcel. | ||
| FLOOD_ZONE | VARCHAR2 | 200 | Detailed land information of the parcel. | ||
| FLOOD_INS_RATE_MAP | VARCHAR2 | 200 | Flood Insurance Rate Map related to the parcel location for floodplain management and insurance purposes. | ||
| LIQUEFACTION_RISK | VARCHAR2 | 200 | Detailed land information of the parcel. | ||
| FIRE_RISK | VARCHAR2 | 200 | Detailed land information of the parcel. | ||
| LANDSLIDE_RISK | VARCHAR2 | 200 | Detailed land information of the parcel. | ||
| SOIL_TYPE | VARCHAR2 | 200 | Detailed land information of the parcel. | ||
| YEAR_BUILT | VARCHAR2 | 4 | Year in which the building on the parcel was built (format: YYYY). | ||
| BEDROOMS | VARCHAR2 | 20 | Number of bedrooms for the building on the parcel. | ||
| BATHROOMS | VARCHAR2 | 20 | Number of bathrooms for the building on the parcel. | ||
| POOL | VARCHAR2 | 200 | Information about pools located on the parcel. | ||
| PATIO | VARCHAR2 | 200 | Information about patios located on the parcel. | ||
| ADDITIONAL_STRUCTURE | VARCHAR2 | 200 | Information about additional structures located on the parcel. | ||
| BOUNDARY_DESCRIPTION | VARCHAR2 | 480 | Information about the boundary description of the parcel. | ||
| PROPERTY_DESCRIPTION | VARCHAR2 | 240 | Information about the property description of the parcel. | ||
| ZONING_DESCRIPTION | VARCHAR2 | 240 | Information about the zoning description of the parcel. | ||
| 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. | |
| LAST_UPDATE_DATE | TIMESTAMP | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Who column: indicates the user who last updated the row. | ||
| CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||
| CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PSC_COM_PARCEL_IMPORT_INT_N1 | Non Unique | Default | BATCH_ID, IMPORT_STATUS_CODE |
| PSC_COM_PARCEL_IMPORT_INT_U1 | Unique | Default | BATCH_ID, INTERFACE_ROW_ID |