PSC_PZ_PARCEL_TRANS_MST_VL

Details

• Schema: FUSION

• Object owner: PSC_CC

• Object type: VIEW

Columns

Name

PARCEL_TRX_MST_KEY PARCEL_TRX_KEY PARCEL_TRX_DTL_KEY PARCEL_TRX_MST_PUID PARCEL_TRX_DTL_PUID PARCEL_ADJUSTMENT PARCEL_ID_ENTERED PROV_PARCEL_ID_ENTERED FINAL_PARCEL_ID_ENTERED PARENT_PARCEL_ID PARENT_PARCEL_ID_ENTERED PARCEL_TYPE ENABLED_FLAG JURISDICTION PRIMARY_ZONING_ID BLOCK_NUM UNIT_NUM LOT_NUM BOOK_NUM SECTION_NUM PAGE_NUM SUBDIVISION LAND_USE_CODE MAP_NAME MAP_BOOK_PAGE LONGITUDE LATITUDE SRID SHAPE BOUNDARY_DESCRIPTION PROPERTY_DESCRIPTION ZONING_DESCRIPTION CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER COORDINATE_X COORDINATE_Y PARCEL_STATUS PARCEL_SIZE1 PARCEL_SIZE1_UNIT PARCEL_SIZE2 PARCEL_SIZE2_UNIT STRUCTURE_SIZE1 STRUCTURE_SIZE1_UNIT STRUCTURE_SIZE2 STRUCTURE_SIZE2_UNIT DWELLING_UNIT_COUNT ZONING_CODE2 GENERAL_PLAN2 TAX_RATE_AREA CENSUS_TRACT CENSUS_BLOCK CLIMATE_ZONE FLOOD_ZONE FLOOD_INS_RATE_MAP LIQUEFACTION_RISK FIRE_RISK LANDSLIDE_RISK SOIL_TYPE YEAR_BUILT BEDROOMS BATHROOMS POOL PATIO ADDITIONAL_STRUCTURE MODULE_ID TEMPORARY EXISTING_PARCEL SELECTED PREVIOUS_STATE PARENT_PARCEL_ADDRESS MIGRATED_DATA_FLAG

Query

SQL_Statement

select B.PARCEL_TRX_MST_KEY, B.PARCEL_TRX_KEY, B.PARCEL_TRX_DTL_KEY, B.PARCEL_TRX_MST_PUID, B.PARCEL_TRX_DTL_PUID, B.PARCEL_ADJUSTMENT, B.PARCEL_ID_ENTERED, B.PROV_PARCEL_ID_ENTERED, B.FINAL_PARCEL_ID_ENTERED, B.PARENT_PARCEL_ID, B.PARENT_PARCEL_ID_ENTERED, B.PARCEL_TYPE, B.ENABLED_FLAG, B.JURISDICTION, B.PRIMARY_ZONING_ID, B.BLOCK_NUM, B.UNIT_NUM, B.LOT_NUM, B.BOOK_NUM, B.SECTION_NUM, B.PAGE_NUM, B.SUBDIVISION, B.LAND_USE_CODE, B.MAP_NAME, B.MAP_BOOK_PAGE, B.LONGITUDE, B.LATITUDE, B.SRID, B.SHAPE, L.BOUNDARY_DESCRIPTION, L.PROPERTY_DESCRIPTION, L.ZONING_DESCRIPTION, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.OBJECT_VERSION_NUMBER,B.COORDINATE_X,B.COORDINATE_Y,B.PARCEL_STATUS,B.PARCEL_SIZE1,B.PARCEL_SIZE1_UNIT,B.PARCEL_SIZE2,B.PARCEL_SIZE2_UNIT,B.STRUCTURE_SIZE1,B.STRUCTURE_SIZE1_UNIT,B.STRUCTURE_SIZE2,B.STRUCTURE_SIZE2_UNIT,B.DWELLING_UNIT_COUNT,ZONING_CODE2,GENERAL_PLAN2,TAX_RATE_AREA,CENSUS_TRACT,CENSUS_BLOCK,CLIMATE_ZONE,FLOOD_ZONE,FLOOD_INS_RATE_MAP,LIQUEFACTION_RISK,FIRE_RISK,LANDSLIDE_RISK,SOIL_TYPE,YEAR_BUILT,BEDROOMS,BATHROOMS,POOL,PATIO,ADDITIONAL_STRUCTURE, B.MODULE_ID, B.TEMPORARY,B.EXISTING_PARCEL, B.SELECTED, B.PREVIOUS_STATE, B.PARENT_PARCEL_ADDRESS,B.MIGRATED_DATA_FLAG from PSC_PZ_PARCEL_TRANS_MST_B B,PSC_PZ_PARCEL_TRANS_MST_TL L where B.PARCEL_TRX_MST_KEY = L.PARCEL_TRX_MST_KEY AND L.LANGUAGE = USERENV('LANG')