PSC_LNP_FIELD_GROUPS
This table contains license and permit functional grouping of fields for intake.
Details
-
Schema: FUSION
-
Object owner: PSC_PER
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
| Name | Columns |
|---|---|
|
PSC_LNP_FIELD_GROUPS_PK |
LNP_RECORD_KEY |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| LNP_RECORD_KEY | NUMBER | 18 | Yes | This column is used to indicate lnp record key | Active | |
| LNP_FIELD_GROUP_PUID | VARCHAR2 | 480 | Yes | Indicates unique identifier of the field group transaction record in the legacy system. | ||
| RECORD_NUMBER | VARCHAR2 | 64 | Indicates Parent PUID. | |||
| LNP_RECORD_ID | VARCHAR2 | 50 | Yes | This column is used to indicate lnp record id | Active | |
| CURRENCY_CODE | VARCHAR2 | 3 | This column is used to indicate currency code | Active | ||
| MIGRATED_DATA_FLAG | VARCHAR2 | 3 | Indicates In-flight or Historical transaction for data migration. | |||
| GEN_FLOOR_AREA_EXIST | NUMBER | This column is used to indicate gen floor area exist | Active | |||
| GEN_FLOOR_AREA_ADDL | NUMBER | This column is used to indicate gen floor area addl | Active | |||
| GEN_OCCUPANT_LOAD | NUMBER | This column is used to indicate gen occupant load | Active | |||
| GEN_FIRE_SPRINK_TYPE | VARCHAR2 | 100 | This column is used to indicate gen fire sprink type | Active | ||
| GEN_FIRE_ALARM_COMMENTS | VARCHAR2 | 500 | This column is used to indicate gen fire alarm comments | Active | ||
| GEN_EXISTING_NUM_STORIES | NUMBER | This column is used to indicate gen existing num stories | Active | |||
| GEN_ADDL_NUM_STORIES | NUMBER | This column is used to indicate gen addl num stories | Active | |||
| GEN_TYPE_CONSTRUCTION | VARCHAR2 | 100 | This column is used to indicate gen type construction | Active | ||
| GEN_FIRE_SPRINK_COMMENTS | VARCHAR2 | 500 | This column is used to indicate gen fire sprink comments | Active | ||
| GEN_WATER_METER_SIZE | NUMBER | This column is used to indicate gen water meter size | Active | |||
| GEN_PROPOSED_BLDG_HEIGHT | NUMBER | This column is used to indicate gen proposed bldg height | Active | |||
| GEN_EXIST_BLDG_HEIGHT | NUMBER | This column is used to indicate gen exist bldg height | Active | |||
| GEN_EXIST_FIRE_SPRINK_FLAG | VARCHAR2 | 1 | This column is used to indicate gen exist fire sprink flag | Active | ||
| GEN_IRRIGATION_METER_SIZE | NUMBER | This column is used to indicate gen irrigation meter size | Active | |||
| GEN_NEW_FLOOR_AREA_CLASS | VARCHAR2 | 50 | This column is used to indicate gen new floor area class | Active | ||
| GEN_FIRE_SPRINK_PROJECT | NUMBER | This column is used to indicate gen fire sprink project | Active | |||
| GEN_BACKFLOW_DEVICE_FLAG | VARCHAR2 | 1 | This column is used to indicate gen backflow device flag | Active | ||
| GEN_TYPE_OF_WORK | VARCHAR2 | 100 | This column is used to indicate gen type of work | Active | ||
| GEN_TYPE_OF_USE | VARCHAR2 | 100 | This column is used to indicate gen type of use | Active | ||
| GEN_JOB_COST | NUMBER | This column is used to indicate gen job cost | Active | |||
| ZON_TOTAL_ACREAGE | NUMBER | This column is used to indicate zon total acreage | Active | |||
| ZON_FLOOD_ZONE_FLAG | VARCHAR2 | 1 | This column is used to indicate zon flood zone flag | Active | ||
| ZON_DISTURBED_ACREAGE | NUMBER | This column is used to indicate zon disturbed acreage | Active | |||
| ZON_FLOOD_ZONE | VARCHAR2 | 100 | This column is used to indicate zon flood zone | Active | ||
| ZON_BASE_FLOOD_ELEVATION | NUMBER | This column is used to indicate zon base flood elevation | Active | |||
| ZON_ZONING_PRIM | VARCHAR2 | 100 | This column is used to indicate the primary zoning. | Active | ||
| ZON_ZONING_SEC | VARCHAR2 | 100 | This column is used to indicate the secondary zoning. | Active | ||
| ZON_ZONING_TERT | VARCHAR2 | 100 | This column is used to indicate the tertiary zoning. | Active | ||
| ZON_LAND_USE_PRIM | VARCHAR2 | 100 | This column is used to indicate the primary land use. | Active | ||
| ZON_LAND_USE_SEC | VARCHAR2 | 100 | This column is used to indicate the secondary land use. | Active | ||
| ZON_LAND_USE_TERT | VARCHAR2 | 100 | This column is used to indicate the tertiary land use. | Active | ||
| ZON_PARKING_REQUIRED_FLAG | VARCHAR2 | 1 | This column is used to indicate zon parking required flag | Active | ||
| ZON_PARKING_SPACES_PROVIDED | NUMBER | This column is used to indicate zon parking spaces provided | Active | |||
| ZON_PLAN_CASE_REQ_FLAG | VARCHAR2 | 1 | This column is used to indicate zon plan case req flag | Active | ||
| ZON_REQ_PLAN_CASE_TYPE | VARCHAR2 | 100 | This column is used to indicate zon req plan case type | Active | ||
| ZON_ENV_MGMT_AREA_FLAG | VARCHAR2 | 1 | This column is used to indicate site is on environmental management area | |||
| ZON_EXISTING_ZONE_EAST | VARCHAR2 | 100 | This column is used to indicate existing zone east | |||
| ZON_EXISTING_ZONE_NORTH | VARCHAR2 | 100 | This column is used to indicate existing zone north | |||
| ZON_EXISTING_ZONE_SOUTH | VARCHAR2 | 100 | This column is used to indicate existing zone south | |||
| ZON_EXISTING_ZONE_WEST | VARCHAR2 | 100 | This column is used to Indicate existing zone west | |||
| ZON_GRDWATER_CONTAMINAT_FLAG | VARCHAR2 | 1 | This column is used to Indicate site is on groundwater contamination | |||
| ZON_PROPOSED_ZONE_EAST | VARCHAR2 | 100 | This column is used to indicate proposed zone east | |||
| ZON_PROPOSED_ZONE_NORTH | VARCHAR2 | 100 | This column is used to indicate proposed zone north | |||
| ZON_PROPOSED_ZONE_SOUTH | VARCHAR2 | 100 | This column is used to indicate proposed zone south | |||
| ZON_PROPOSED_ZONE_WEST | VARCHAR2 | 100 | This column is used to indicate proposed zone west | |||
| ZON_WAIVE_REDUCE_PARKING_FLAG | VARCHAR2 | 1 | This column is used to indicate a request to waive or reduce required parking spaces | |||
| ZON_WITHIN_OPEN_CREEK_FLAG | VARCHAR2 | 1 | This column is used to Indicate site is within allowed distance to open or culverted creek | |||
| DEM_STRUCTURE_DESCR | VARCHAR2 | 200 | This column is used to indicate dem structure descr | Active | ||
| DEM_OVERALL_HEIGHT | NUMBER | This column is used to indicate dem overall height | Active | |||
| DEM_METHOD | VARCHAR2 | 100 | This column is used to indicate dem method | Active | ||
| DEM_ENTIRE_STRUCTURE_FLAG | VARCHAR2 | 1 | This column is used to indicate dem entire structure flag | Active | ||
| DEM_HAZ_MAT_CERT_NUMBER | VARCHAR2 | 50 | This column is used to indicate dem haz mat cert number | Active | ||
| DEM_SEWER_FLAG | VARCHAR2 | 1 | This column is used to indicate dem sewer flag | Active | ||
| DEM_GAS_FLAG | VARCHAR2 | 1 | This column is used to indicate dem gas flag | Active | ||
| DEM_WATER_FLAG | VARCHAR2 | 1 | This column is used to indicate dem water flag | Active | ||
| DEM_HAZ_MAT_CERT_REQ_FLAG | VARCHAR2 | 1 | This column is used to indicate dem haz mat cert req flag | Active | ||
| DEM_ELECTRIC_RELEASE_DATE | DATE | This column is used to indicate dem electric release date | Active | |||
| DEM_DEMOLITION_REASON | VARCHAR2 | 500 | This column is used to indicate dem demolition reason | Active | ||
| DEM_WATER_UTIL_RELEASE_DATE | DATE | This column is used to indicate dem water util release date | Active | |||
| DEM_STRUCTURE_FLOOR_AREA | NUMBER | This column is used to indicate dem structure floor area | Active | |||
| DEM_DISPOSAL_SITE | VARCHAR2 | 200 | This column is used to indicate dem disposal site | Active | ||
| DEM_POWER_FLAG | VARCHAR2 | 1 | This column is used to indicate dem power flag | Active | ||
| DEM_HISTORIC_DISTRICT_FLAG | VARCHAR2 | 1 | This column is used to indicate dem historic district flag | Active | ||
| DEM_SEWER_UTIL_RELEASE_DATE | DATE | This column is used to indicate dem sewer util release date | Active | |||
| DEM_NUM_STORIES | NUMBER | This column is used to indicate dem num stories | Active | |||
| DEM_MATL_TRANSPORT_MTHD | VARCHAR2 | 100 | This column is used to indicate dem matl transport mthd | Active | ||
| DEM_UG_FLAME_LIQ_STOR_FLAG | VARCHAR2 | 1 | This column is used to indicate dem ug flame liq stor flag | Active | ||
| DEM_GAS_UTIL_RELEASE_DATE | DATE | This column is used to indicate dem gas util release date | Active | |||
| DEM_LANDMARK_FLAG | VARCHAR2 | 1 | This column is used to indicate dem on designated landmark flag | |||
| DEM_STRUCTURE_MERIT_FLAG | VARCHAR2 | 1 | This column is used to indicate dem on structure of merit flag | |||
| ELC_DISHWASHERS | NUMBER | 6 | This column is used to indicate the number of dishwashers. | Active | ||
| ELC_EXISTING_SERVICE_AMPS | NUMBER | This column is used to indicate elc existing service amps | Active | |||
| ELC_EXISTING_SERVICE_FLAG | VARCHAR2 | 1 | This column is used to indicate elc existing service flag | Active | ||
| ELC_FIRE_ALARMS | NUMBER | 6 | This column is used to indicate the number of fire alarms. | Active | ||
| ELC_HEATING_APPLIANCES | NUMBER | 6 | This column is used to indicate the number of heating appliances. | Active | ||
| ELC_MOTORS | NUMBER | 6 | This column is used to indicate the number of electric motors. | Active | ||
| ELC_NUM_FIXTURES_OUTLETS_SWS | NUMBER | This column is used to indicate elc num fixtures outlets sws | Active | |||
| ELC_NUM_POWER_OUTLETS | NUMBER | 6 | This column is used to indicate the number of 110V power outlets | Active | ||
| ELC_NUM_POWER_OUTLETS_OTHER | NUMBER | 6 | This column is used to indicate the number of 220V power outlets. | Active | ||
| ELC_NUM_TELECOMM | NUMBER | 6 | This column is used to indicate the number of telecommunication outlets. | Active | ||
| ELC_SERV_EQUIPMENT | NUMBER | 6 | This column is used to indicate the number of service equipment. | Active | ||
| ELC_SIGN_FLAG | VARCHAR2 | 1 | This column is used to indicate elc sign flag | Active | ||
| ELC_SMOKE_DETECTORS | NUMBER | 6 | This column is used to indicae the number of smoke detectors. | Active | ||
| ELC_SWIMMING_POOLS | NUMBER | 6 | This column is used to indicate the number of swimming pools. | Active | ||
| ELC_TEMPORARY_POLES | NUMBER | 6 | This column is used to indicate the number of temporary electrical poles. | Active | ||
| ELC_WATER_HEATER_KVA_HP | NUMBER | This column is used to indicate elc water heater kva hp | Active | |||
| MEC_AIRHDLR_MIN | NUMBER | 6 | This column is used to indicate the minimum air handler volume. | Active | ||
| MEC_AIRHDLR_MAX | NUMBER | 6 | This column is used to indicate the maximum air handler volume. | Active | ||
| MEC_BATH_KITCHEN_EXHAUST | NUMBER | 6 | This column is used to indicate the number of exhausts. | Active | ||
| MEC_CHILLERS | NUMBER | 6 | This column is used to indicate mec chiller flag | Active | ||
| MEC_CHIMNEYS | NUMBER | 6 | This column is used to indicate the number of chimneys. | Active | ||
| MEC_COMMERCIAL_HOODS | NUMBER | 6 | This column is used to indicate the number of commercial hoods. | Active | ||
| MEC_COMPRESSORS | NUMBER | 6 | This column is used to indicate the number of compressors. | Active | ||
| MEC_COOLING_TOWERS | NUMBER | 6 | This column is used to indicate the number of cooling towers. | Active | ||
| MEC_DUCT_SYSTEM_FLAG | VARCHAR2 | 1 | This column is used to indicate mec duct system flag | Active | ||
| MEC_ELECTRIC_HEAT_EQUIP | NUMBER | 6 | This column is used to indicate the number of electric heating equipment. | Active | ||
| MEC_EVAPORATOR_COILS | NUMBER | 6 | This column is used to indicate the number of evaporator coils. | Active | ||
| MEC_FIRE_SUPRS_PIPING_FLAG | VARCHAR2 | 1 | This column is used to indicate mec fire suprs piping flag | Active | ||
| MEC_FIRE_SUPRS_SPRINKLER | NUMBER | 6 | This column is used to indicate the number of fire suppression sprinklers. | Active | ||
| MEC_FLUE_LINER_FLAG | VARCHAR2 | 1 | This column is used to indicate mec flue liner flag | Active | ||
| MEC_FLUE_VENT_DAMPER_FLAG | VARCHAR2 | 1 | This column is used to indicate mec flue vent damper flag | Active | ||
| MEC_HEAT_PUMPS | NUMBER | 6 | This column is used to indicate the number of heat pumps. | Active | ||
| MEC_HEAT_RECOVRY_FLAG | VARCHAR2 | 1 | This column is used to indicate mec heat recovry flag | Active | ||
| MEC_HEAT_BTU_MIN | NUMBER | 6 | This column is used to indicate the minimum heating BTU. | Active | ||
| MEC_HEAT_BTU_MAX | NUMBER | 6 | This column is used to indicate the maximum heating BTU. | Active | ||
| MEC_HOT_WATER_HEATER_TANKS | NUMBER | 6 | This column is used to indicate the number of water heater tanks. | Active | ||
| MEC_HUMIDIFIERS | NUMBER | 6 | This column is used to indicate the number of humidifiers. | Active | ||
| MEC_NEW_GAS_PIPING_FLAG | VARCHAR2 | 1 | This column is used to indicate mec new gas piping flag | Active | ||
| MEC_POOL_HEATERS | NUMBER | 6 | This column is used to indicate the number of pool heaters. | Active | ||
| MEC_REFRIG_HP_MIN | NUMBER | 6 | This column is used to indicate the minimum refrigeration power. | Active | ||
| MEC_REFRIG_HP_MAX | NUMBER | 6 | This column is used to indicate the maximum refrigeration power. | Active | ||
| MEC_RESIDENTIAL_BOILER_FLAG | VARCHAR2 | 1 | This column is used to indicate mec residential boiler flag | Active | ||
| MEC_RESIDENTIAL_HEAT_FLAG | VARCHAR2 | 1 | This column is used to indicate mec residential heat flag | Active | ||
| MEC_TANK_ABOVE_GROUND_FLAG | VARCHAR2 | 1 | This column is used to indicate mec tank above ground flag | Active | ||
| MEC_TANK_BELOW_GROUND_FLAG | VARCHAR2 | 1 | This column is used to indicate mec tank below ground flag | Active | ||
| MEC_UNIT_HEATERS | NUMBER | 6 | This column is used to indicate the number of heaters. | Active | ||
| MEC_UNIT_VENTILATORS | NUMBER | 6 | This column is used to indicate the number of ventilators. | Active | ||
| MEC_VAV_BOX_FLAG | VARCHAR2 | 1 | This column is used to indicate mec vav box flag | Active | ||
| MEC_WATER_HEATER_FLAG | VARCHAR2 | 1 | This column is used to indicate mec water heater flag | Active | ||
| PLB_BACKFLOW_PREVENTER_FLAG | VARCHAR2 | 1 | This column is used to indicate plb backflow preventer flag | Active | ||
| PLB_BLDG_SEWER_FLAG | VARCHAR2 | 1 | This column is used to indicate that a sewage connection exists. | Active | ||
| PLB_BLDG_SEWER_SIZE | NUMBER | 6 | This column is used to indicate the sewage connection dismeter size. | Active | ||
| PLB_DRAINAGE_REPAIR_FLAG | VARCHAR2 | 1 | This column is used to indicate plb drainage repair flag | Active | ||
| PLB_FIRE_SPRINKER_NUM_HEADS | NUMBER | This column is used to indicate plb fire sprinker num heads | Active | |||
| PLB_GAS_OUTLETS | NUMBER | 6 | This column is used to indicate the number of gas outlets. | Active | ||
| PLB_GAS_RECONNECTIONS | NUMBER | 6 | This column is used to indicate the number of gas connections. | Active | ||
| PLB_GAS_TANKS_PUMPS | NUMBER | 6 | This column is used to indicate the number of gas tank pumps. | Active | ||
| PLB_LAWN_SPRINKLERS | NUMBER | 6 | This column is used to indicate the number of lawn sprinklers. | Active | ||
| PLB_FIXTURE_TRAP_FLAG | VARCHAR2 | 1 | This column is used to indicate plb fixture trap flag | Active | ||
| PLB_RAINWATER_DRAIN_FLAG | VARCHAR2 | 1 | This column is used to indicate plb rainwater drain flag | Active | ||
| PLB_SEWER_TAP_COMMERCIAL_FLAG | VARCHAR2 | 1 | This column is used to indicate plb sewer tap commercial flag | Active | ||
| PLB_WATER_HEATERS | NUMBER | 6 | This column is used to indicate the number of water heaters. | Active | ||
| PLB_WATER_SOFTENERS | NUMBER | 6 | This column is used to indicate the number of water softeners. | Active | ||
| ROF_EXIST_ROOF_TYPE | VARCHAR2 | 100 | This column is used to indicate rof exist roof type | Active | ||
| ROF_FIRE_LAYERS | NUMBER | 6 | This column is used to indicate the number of fire layers on the roof. | Active | ||
| ROF_NEW_ROOF_TYPE | VARCHAR2 | 100 | This column is used to indicate rof new roof type | Active | ||
| ROF_NUM_EXIST_ROOF_LAYERS | NUMBER | This column is used to indicate rof num exist roof layers | Active | |||
| ROF_ROOF_NUM_SQUARES | NUMBER | This column is used to indicate rof roof num squares | Active | |||
| ROF_REMOVE_ALL_EXIST_ROOF_FLAG | VARCHAR2 | 1 | This column is used to indicate rof remove all exist roof flag | Active | ||
| ROF_SHEATHING_REPAIR_FLAG | VARCHAR2 | 1 | This column is used to indicate rof sheathing repair flag | Active | ||
| FEN_TYPE_OF_WORK | VARCHAR2 | 100 | This column is used to indicate fen type of work | Active | ||
| FEN_TYPE | VARCHAR2 | 100 | This column is used to indicate fen type | Active | ||
| FEN_HEIGHT_FRONT | NUMBER | This column is used to indicate fen height front | Active | |||
| FEN_HEIGHT_REAR | NUMBER | This column is used to indicate fen height rear | Active | |||
| FEN_HEIGHT_LEFT | NUMBER | 6 | This column is used to indicate the height of the left side fence. | Active | ||
| FEN_HEIGHT_RIGHT | NUMBER | 6 | This column is used to indicate the height of the right side fence. | Active | ||
| FEN_CORNER_LOT_FLAG | VARCHAR2 | 1 | This column is used to indicate fen corner lot flag | Active | ||
| FEN_TYPE_OF_USE | VARCHAR2 | 100 | This column is used to indicate fen type of use | Active | ||
| FEN_TYPE_OTHER | VARCHAR2 | 200 | This column is used to indicate fen type other | Active | ||
| FEN_FOUNDATION_TYPE | VARCHAR2 | 100 | This column is used to indicate fen foundation type | Active | ||
| FEN_AUTOCLOSE_GATE_FLAG | VARCHAR2 | 1 | This column is used to indicate fen autoclose gate flag | Active | ||
| FEN_LOCK_FLAG | VARCHAR2 | 1 | This column is used to indicate fen lock flag | Active | ||
| FEN_POOL_ENCLOSURE_FLAG | VARCHAR2 | 1 | This column is used to indicate fen pool enclosure flag | Active | ||
| FEN_MATERIAL | VARCHAR2 | 100 | This column is used to indicate fen material | Active | ||
| FEN_MATERIAL_OTHER | VARCHAR2 | 200 | This column is used to indicate fen material other | Active | ||
| FEN_LOCATION | VARCHAR2 | 200 | This column is used to indicate fen location | Active | ||
| GRD_TYPE_PROJECT | VARCHAR2 | 200 | This column is used to indicate grd type project | Active | ||
| GRD_CUT_AMOUNT | NUMBER | This column is used to indicate grd cut amount | Active | |||
| GRD_SOURCE_IMPORT | VARCHAR2 | 100 | This column is used to indicate grd source import | Active | ||
| GRD_NUM_LOTS | NUMBER | This column is used to indicate grd num lots | Active | |||
| GRD_FILL_AMOUNT | NUMBER | This column is used to indicate grd fill amount | Active | |||
| GRD_DISTURBED_ACREAGE | NUMBER | This column is used to indicate grd disturbed acreage | Active | |||
| GRD_TOTAL_ACREAGE | NUMBER | This column is used to indicate grd total acreage | Active | |||
| GRD_IMPORT_AMOUNT | NUMBER | This column is used to indicate grd import amount | Active | |||
| GRD_EXPORT_AMOUNT | NUMBER | This column is used to indicate grd export amount | Active | |||
| GRD_CUT_MATERIAL | VARCHAR2 | 100 | This column is used to indicate grd cut material | Active | ||
| GRD_CUT_DISPOSE_SITE | VARCHAR2 | 100 | This column is used to indicate grd cut dispose site | Active | ||
| GRD_FILL_MATERIAL | VARCHAR2 | 100 | This column is used to indicate grd fill material | Active | ||
| PLN_PROPOSED_NUM_UNITS | NUMBER | 6 | This column is used to indicate the proposed Number of Units | |||
| PLN_BUILDING_ASSESSED_VALUE | NUMBER | This column is used to indicate the Current Building Assessed Value | ||||
| PLN_DEVELOPMENT_TYPE | VARCHAR2 | 100 | This column is used to indicate the Development Type | |||
| PLN_EXISTING_COMMERCIAL_AREA | NUMBER | This column is used to indicate the Existing Commercial Area | ||||
| PLN_PROPOSED_COMMERCIAL_AREA | NUMBER | This column is used to indicate the Proposed Commercial Area | ||||
| PLN_EXISTING_NUM_UNITS | NUMBER | 6 | This column is used to indicate the Existing Number of Units | |||
| PLN_EXISTING_TYPE_OF_USE | VARCHAR2 | 100 | This column is used to indicate the Existing Use | |||
| PLN_GROSS_LOT_AREA | NUMBER | This column is used to indicate the Gross Lot Area | ||||
| PLN_LAND_ASSESSED_VALUE | NUMBER | This column is used to indicate the Current Land Assessed Value | ||||
| PLN_NET_LOT_AREA | NUMBER | This column is used to indicate the Net Lot Area | ||||
| PLN_PROJECT_AREA | NUMBER | This column is used to indicate the Total project area | ||||
| PLN_PROJECT_LOT_AREA_UOM | VARCHAR2 | 5 | This column is used to indicate the Project Lot Area UOM | |||
| PLN_PROPOSED_SETBACK_FRONT | NUMBER | This column is used to indicate the Proposed Setback: Front | ||||
| PLN_PROPOSED_SETBACK_REAR | NUMBER | This column is used to indicate the Proposed Setback: Rear | ||||
| PLN_PROPOSED_SETBACK_SIDES | NUMBER | This column is used to indicate the Proposed Setback: Sides | ||||
| PLN_PROPOSED_TYPE_OF_USE | VARCHAR2 | 100 | This column is used to indicate the Proposed Use | |||
| PLN_REQUIRED_SETBACK_FRONT | NUMBER | This column is used to indicate the Required Setback: Front | ||||
| PLN_REQUIRED_SETBACK_REAR | NUMBER | This column is used to indicate the Required Setback: Rear | ||||
| PLN_REQUIRED_SETBACK_SIDES | NUMBER | This column is used to indicate the Required Setback: Sides | ||||
| PLN_SETBACK_UOM | VARCHAR2 | 5 | This column is used to indicate the Setback UOM | |||
| PLN_CHANGE_NUM_UNITS | NUMBER | 6 | This column is used to indicate the Changes to Number of Units | |||
| POL_MAX_DEPTH | NUMBER | This column is used to indicate pol max depth | Active | |||
| POL_NUM_POOL_LIGHTS | NUMBER | This column is used to indicate pol num pool lights | Active | |||
| POL_LOCATION | VARCHAR2 | 200 | This column is used to indicate pol location | Active | ||
| POL_FENCED_FLAG | VARCHAR2 | 1 | This column is used to indicate pol fenced flag | Active | ||
| POL_TYPE_FENCE | VARCHAR2 | 200 | This column is used to indicate pol type fence | Active | ||
| POL_FENCE_HEIGHT | NUMBER | This column is used to indicate pol fence height | Active | |||
| POL_HEATER_FLAG | VARCHAR2 | 1 | This column is used to indicate pol heater flag | Active | ||
| POL_HEATER_TYPE | VARCHAR2 | 200 | This column is used to indicate pol heater type | Active | ||
| POL_FRONT_SETBACK | NUMBER | This column is used to indicate pol front setback | Active | |||
| POL_REAR_SETBACK | NUMBER | This column is used to indicate pol rear setback | Active | |||
| POL_LEFT_SIDE_SETBACK | NUMBER | 6 | This column is used to indicate the pool left side setback. | Active | ||
| POL_RIGHT_SIDE_SETBACK | NUMBER | 6 | This column is used to indicate the pool right side setback. | Active | ||
| POL_TYPE_OF_POOL | VARCHAR2 | 200 | This column is used to indicate pol type of pool | Active | ||
| POL_SURFACE_AREA | NUMBER | This column is used to indicate pol surface area | Active | |||
| POL_AUTOCLOSE_GATE_FLAG | VARCHAR2 | 1 | This column is used to indicate pol autoclose gate flag | Active | ||
| ROW_NUM_BUS_STOPS_BLOCKED | NUMBER | This column is used to indicate row num bus stops blocked | Active | |||
| ROW_SIDEWALK_IMPACT_FLAG | VARCHAR2 | 1 | This column is used to indicate row sidewalk impact flag | Active | ||
| ROW_NUM_PAVE_EXCAVAIONS | NUMBER | This column is used to indicate row num pave excavaions | Active | |||
| ROW_NUM_NONPAVE_EXCAVATIONS | NUMBER | This column is used to indicate row num nonpave excavations | Active | |||
| ROW_NUM_METERS_RESERVED | NUMBER | This column is used to indicate row num meters reserved | Active | |||
| ROW_ALLEY_IMPACT_FLAG | VARCHAR2 | 1 | This column is used to indicate row alley impact flag | Active | ||
| ROW_TRAFFIC_LANE_IMPACT_FLAG | VARCHAR2 | 1 | This column is used to indicate row traffic lane impact flag | Active | ||
| ROW_PARKWAY_IMPACT_FLAG | VARCHAR2 | 1 | This column is used to indicate row parkway impact flag | Active | ||
| ROW_PARKING_LANE_IMPACT_FLAG | VARCHAR2 | 1 | This column is used to indicate row parking lane impact flag | Active | ||
| ROW_RIGHT_OF_WAY_TYPE_USE | VARCHAR2 | 500 | This column is used to indicate row right of way type use | Active | ||
| ROW_CLOSURE_TYPE | VARCHAR2 | 10 | This column is used to indicate row closure type | Active | ||
| ROW_LOCATION | VARCHAR2 | 200 | This column is used to indicate row location | Active | ||
| ROW_TRAFFIC_PLAN_PROVIDED_FLAG | VARCHAR2 | 1 | This column is used to indicate row traffic plan provided flag | Active | ||
| ROW_TOTAL_PROJECT_AREA_LENGTH | NUMBER | This column is used to indicate row total project area length | Active | |||
| ROW_NUM_CALENDAR_DAYS | NUMBER | This column is used to indicate row num calendar days | Active | |||
| SOL_SERVICE_ID | VARCHAR2 | 100 | This column is used to indicate sol service id | Active | ||
| SOL_INVERTER_POWER | NUMBER | This column is used to indicate sol inverter power | Active | |||
| SOL_ROOF_COVERAGE | NUMBER | This column is used to indicate sol roof coverage | Active | |||
| SOL_METER_ID | VARCHAR2 | 100 | This column is used to indicate sol meter id | Active | ||
| SOL_NUM_PHOTOVOLTAIC_MODULES | NUMBER | This column is used to indicate sol num photovoltaic modules | Active | |||
| SOL_TYPE_OF_ROOF | VARCHAR2 | 100 | This column is used to indicate sol type of roof | Active | ||
| SOL_TYPE_OF_USE | VARCHAR2 | 100 | This column is used to indicate sol type of use | Active | ||
| SOL_NUMBER_OF_INVERTERS | NUMBER | This column is used to indicate sol number of inverters | Active | |||
| SOL_ROOF_MATERIAL | VARCHAR2 | 200 | This column is used to indicate sol roof material | Active | ||
| SOL_TOTAL_ROOF_AREA | NUMBER | This column is used to indicate sol total roof area | Active | |||
| SOL_ROOF_LAYERS | NUMBER | This column is used to indicate sol roof layers | Active | |||
| SOL_ROOF_CONNECT_TYPE | VARCHAR2 | 100 | This column is used to indicate sol roof connect type | Active | ||
| SOL_NUM_ROOF_CONNECTS | NUMBER | This column is used to indicate sol num roof connects | Active | |||
| SOL_INVERTER_TYPE | VARCHAR2 | 100 | This column is used to indicate sol inverter type | Active | ||
| QAL_LICENSE_TYPE | VARCHAR2 | 50 | This column is used to indicate qal license type | Active | ||
| QAL_LICENSE_CLASS_CODE | VARCHAR2 | 50 | This column is used to indicate qal license class code | Active | ||
| QAL_STATE_LIC_NUMBER | VARCHAR2 | 50 | This column is used to indicate qal state lic number | Active | ||
| QAL_STATE_LIC_EXPIRE | DATE | This column is used to indicate qal state lic expire | Active | |||
| INS_BONDED_FLAG | VARCHAR2 | 1 | This column is used to indicate ins bonded flag | Active | ||
| INS_INSURED_FLAG | VARCHAR2 | 1 | This column is used to indicate ins insured flag | Active | ||
| INS_INSURANCE_TYPE | VARCHAR2 | 50 | This column is used to indicate ins insurance type | Active | ||
| INS_INSURANCE_COMPANY | VARCHAR2 | 50 | This column is used to indicate ins insurance company | Active | ||
| INS_POLICY_NUMBER | VARCHAR2 | 50 | This column is used to indicate ins policy number | Active | ||
| INS_POLICY_EXPIRATION | DATE | This column is used to indicate ins policy expiration | Active | |||
| RBA_ADULT_ORIENTED_FLAG | VARCHAR2 | 1 | This column is used to indicate rba adult oriented flag | Active | ||
| RBA_ALCOHOL_LICENSE_NUM | VARCHAR2 | 50 | This column is used to indicate rba alcohol license num | Active | ||
| RBA_ALCOHOL_LICENSE_TYPE | VARCHAR2 | 50 | This column is used to indicate rba alcohol license type | Active | ||
| RBA_ALCOHOL_SERVED | VARCHAR2 | 1 | This column is used to indicate rba alcohol served | Active | ||
| RBA_AQUATIC_FEATURES | NUMBER | 6 | This column is used to indicate the number of aquatic features. | Active | ||
| RBA_CANNABIS_FLAG | VARCHAR2 | 1 | This column is used to indicate rba cannabis flag | Active | ||
| RBA_CARNIVAL_GAMES | NUMBER | 6 | This column is used to indicate the number of carnival games. | Active | ||
| RBA_CARNIVAL_RIDES | NUMBER | 6 | This column is used to indicate the number of carnival rides. | Active | ||
| RBA_CASINO_GAMES | NUMBER | 6 | This column is used to indicate the number of casino games. | Active | ||
| RBA_FIREARM_FLAG | VARCHAR2 | 1 | This column is used to indicate rba firearm flag | Active | ||
| RBA_LIVE_ANIMALS_FLAG | VARCHAR2 | 1 | This column is used to indicate rba live animals flag | Active | ||
| RBA_LIVE_ENTERTAINMENT_FLAG | VARCHAR2 | 1 | This column is used to indicate rba live entertainment flag | Active | ||
| RBA_PLAY_EQUIPMENT_FLAG | VARCHAR2 | 1 | This column is used to indicate rba play equipment flag | Active | ||
| RBA_PYROTECHNICS_FLAG | VARCHAR2 | 1 | This column is used to indicate rba pyrotechnics flag | Active | ||
| RBA_TOBACCO_FLAG | VARCHAR2 | 1 | This column is used to indicate rba tobacco flag | Active | ||
| RBA_OTHER_FLAG | VARCHAR2 | 1 | This column is used to indicate rba other flag | Active | ||
| RBA_OTHER_SPECIFY | VARCHAR2 | 200 | This column is used to indicate rba other specify | Active | ||
| YRD_DESCRIPTION | VARCHAR2 | 200 | This column is used to indicate yrd description | Active | ||
| YRD_START_DATETIME | TIMESTAMP | This column is used to indicate yrd start datetime | Active | |||
| YRD_END_DATETIME | TIMESTAMP | This column is used to indicate yrd end datetime | Active | |||
| YRD_NUM_DAYS | NUMBER | This column is used to indicate yrd num days | Active | |||
| SPE_EVENT_NAME | VARCHAR2 | 50 | This column is used to indicate spe event name | Active | ||
| SPE_EVENT_DESCRIPTION | VARCHAR2 | 100 | This column is used to indicate spe event description | Active | ||
| SPE_EVENT_TYPE | VARCHAR2 | 30 | This column is used to indicate spe event type | Active | ||
| SPE_START_DATETIME | TIMESTAMP | This column is used to indicate spe start datetime | Active | |||
| SPE_END_DATETIME | TIMESTAMP | This column is used to indicate spe end datetime | Active | |||
| SPE_SETUP_DATETIME | TIMESTAMP | This column is used to indicate spe setup datetime | Active | |||
| SPE_DISMANTLE_DATETIME | TIMESTAMP | This column is used to indicate spe dismantle datetime | Active | |||
| SPE_OPEN_TO_PUBLIC_FLAG | VARCHAR2 | 1 | This column is used to indicate spe open to public flag | Active | ||
| SPE_EST_DAILY_ATTENDANCE | NUMBER | This column is used to indicate spe est daily attendance | Active | |||
| SPE_GENERAL_ADMISSION | NUMBER | This column is used to indicate spe general admission | Active | |||
| SPE_SENIOR_ADMISSION | NUMBER | This column is used to indicate spe senior admission | Active | |||
| SPE_YOUTH_ADMISSION | NUMBER | This column is used to indicate spe youth admission | Active | |||
| SPE_DISCOUNT_FEE | NUMBER | This column is used to indicate spe discount fee | Active | |||
| SPE_MEDIA_FLAG | VARCHAR2 | 1 | This column is used to indicate spe media flag | Active | ||
| SPE_NOTIFICATION_METHOD | VARCHAR2 | 100 | This column is used to indicate spe notification method | Active | ||
| SPE_COPY_NOTIFICATION_FLAG | VARCHAR2 | 1 | This column is used to indicate spe copy notification flag | Active | ||
| SPE_OTHER | VARCHAR2 | 200 | This column is used to indicate spe other | Active | ||
| SPE_SECURITY_PLAN | VARCHAR2 | 200 | This column is used to indicate spe security plan | Active | ||
| SPE_SECURITY_COMPANY | VARCHAR2 | 50 | This column is used to indicate spe security company | Active | ||
| SPE_PROF_SECURITY_FLAG | VARCHAR2 | 1 | This column is used to indicate spe prof security flag | Active | ||
| SPE_NUM_SECURITY | NUMBER | This column is used to indicate spe num security | Active | |||
| SPE_TRAFFIC_EQUIP_FLAG | VARCHAR2 | 1 | This column is used to indicate that traffic equipment will be used. | Active | ||
| SPE_FIRST_AID_STATIONS | NUMBER | 6 | This column is used to indicate the number of first aid stations. | Active | ||
| SPE_FIRST_AID_DESCR | VARCHAR2 | 100 | This column is used to indicate spe first aid descr | Active | ||
| SPE_NUM_AMBULANCES | NUMBER | This column is used to indicate spe num ambulances | Active | |||
| SPE_NUM_PARAMEDICS | NUMBER | This column is used to indicate spe num paramedics | Active | |||
| SPE_NUM_DOCTORS | NUMBER | This column is used to indicate spe num doctors | Active | |||
| SPE_NUM_NURSES | NUMBER | This column is used to indicate spe num nurses | Active | |||
| SPE_NUM_EMERG_TECHS | NUMBER | This column is used to indicate spe num emerg techs | Active | |||
| SPE_FOOD_FLAG | VARCHAR2 | 1 | This column is used to indicate spe food flag | Active | ||
| SPE_FOOD_PREP_FLAG | VARCHAR2 | 1 | This column is used to indicate spe food prep flag | Active | ||
| SPE_FOOD_VENDORS | NUMBER | 6 | This column is used to indicate the number of food vendors. | Active | ||
| SPE_NUM_FOOD_VENDORS | NUMBER | This column is used to indicate spe num food vendors | Active | |||
| SPE_COOKING_REQ_FLAG | VARCHAR2 | 1 | This column is used to indicate spe cooking req flag | Active | ||
| SPE_COOKING_METHOD | VARCHAR2 | 10 | This column is used to indicate spe cooking method | Active | ||
| SPE_NUM_ALCOHOL_VENDORS | NUMBER | This column is used to indicate spe num alcohol vendors | Active | |||
| SPE_ALCOHOL_START_TIME | TIMESTAMP | This column is used to indicate spe alcohol start time | Active | |||
| SPE_ALCOHOL_END_TIME | TIMESTAMP | This column is used to indicate spe alcohol end time | Active | |||
| SPE_ALCOHOL_COMP_FLAG | VARCHAR2 | 1 | This column is used to indicate spe alcohol comp flag | Active | ||
| SPE_WINE_FLAG | VARCHAR2 | 1 | This column is used to indicate spe wine flag | Active | ||
| SPE_BEER_FLAG | VARCHAR2 | 1 | This column is used to indicate spe beer flag | Active | ||
| SPE_DISTILLED_SPIRITS_FLAG | VARCHAR2 | 1 | This column is used to indicate spe distilled spirits flag | Active | ||
| SPE_NUM_PORTABLE_RESTROOMS | NUMBER | This column is used to indicate spe num portable restrooms | Active | |||
| SPE_NUM_ADA_RESTROOMS | NUMBER | This column is used to indicate spe num ada restrooms | Active | |||
| SPE_NUM_HAND_SINKS | NUMBER | This column is used to indicate spe num hand sinks | Active | |||
| SPE_NUM_TENTS | NUMBER | This column is used to indicate spe num tents | Active | |||
| SPE_NUM_CHAIRS | NUMBER | This column is used to indicate spe num chairs | Active | |||
| SPE_SIZE_CHAIRS | NUMBER | This column is used to indicate spe size chairs | Active | |||
| SPE_NUM_CANOPIES | NUMBER | This column is used to indicate spe num canopies | Active | |||
| SPE_SIZE_CANOPIES | NUMBER | This column is used to indicate spe size canopies | Active | |||
| SPE_NUM_BLEACHERS | NUMBER | This column is used to indicate spe num bleachers | Active | |||
| SPE_NUM_TABLES | NUMBER | This column is used to indicate spe num tables | Active | |||
| SPE_OUTDOOR_EATING_FLAG | VARCHAR2 | 1 | This column is used to indicate spe outdoor eating flag | Active | ||
| SPE_NUM_BANNERS | NUMBER | This column is used to indicate spe num banners | Active | |||
| SPE_BANNERS_DESCR | VARCHAR2 | 100 | This column is used to indicate spe banners descr | Active | ||
| SPE_TEMP_POWER_FLAG | VARCHAR2 | 1 | This column is used to indicate spe temp power flag | Active | ||
| SPE_GENERATORS | NUMBER | 6 | This column is used to indicate the number of generators. | Active | ||
| SPE_ELEC_POWER_FLAG | VARCHAR2 | 1 | This column is used to indicate spe elec power flag | Active | ||
| SPE_TEMP_LIGHTING_FLAG | VARCHAR2 | 1 | This column is used to indicate spe temp lighting flag | Active | ||
| SPE_TEMP_LIGHTING_DESCR | VARCHAR2 | 100 | This column is used to indicate spe temp lighting descr | Active | ||
| SPE_NUM_STAGES | NUMBER | This column is used to indicate spe num stages | Active | |||
| SPE_MUSICAL_FLAG | VARCHAR2 | 1 | This column is used to indicate spe musical flag | Active | ||
| SPE_NUM_BANDS | NUMBER | This column is used to indicate spe num bands | Active | |||
| SPE_PUB_ADDR_FLAG | VARCHAR2 | 1 | This column is used to indicate spe pub addr flag | Active | ||
| SPE_SOUND_EQUIP_DESCR | VARCHAR2 | 100 | This column is used to indicate spe sound equip descr | Active | ||
| SPE_PA_SYS_END_TIME | TIMESTAMP | This column is used to indicate spe pa sys end time | Active | |||
| SPE_PA_SYS_START_TIME | TIMESTAMP | This column is used to indicate spe pa sys start time | Active | |||
| SPE_SOUND_CHK_FLAG | VARCHAR2 | 1 | This column is used to indicate spe sound chk flag | Active | ||
| SPE_USE_OF_PUBLIC_BLDG_FLAG | VARCHAR2 | 1 | This column is used to indicate spe use of public bldg flag | Active | ||
| SPE_NAME_OF_PUBLIC_BLDG | VARCHAR2 | 50 | This column is used to indicate spe name of public bldg | Active | ||
| SPE_USE_OF_PUBLIC_PARK_FLAG | VARCHAR2 | 1 | This column is used to indicate spe use of public park flag | Active | ||
| SPE_NAME_OF_PUBLIC_PARK | VARCHAR2 | 50 | This column is used to indicate spe name of public park | Active | ||
| SPE_USE_OF_PUBLIC_PLZ_FLAG | VARCHAR2 | 1 | This column is used to indicate spe use of public plz flag | Active | ||
| SPE_NAME_OF_PUBLIC_PLZ | VARCHAR2 | 50 | This column is used to indicate spe name of public plz | Active | ||
| SPE_USE_PUBLIC_ROW_FLAG | VARCHAR2 | 1 | This column is used to indicate spe use public row flag | Active | ||
| SPE_PUBLIC_ROW_DESCR | VARCHAR2 | 100 | This column is used to indicate spe public row descr | Active | ||
| SPE_GARBAGE_CLEANUP_PLAN | VARCHAR2 | 200 | This column is used to indicate spe garbage cleanup plan | Active | ||
| SPE_NUM_DUMPSTER_W_LIDS | NUMBER | This column is used to indicate spe num dumpster w lids | Active | |||
| SPE_SIZE_DUMPSTER_W_LIDS | NUMBER | This column is used to indicate spe size dumpster w lids | Active | |||
| SPE_NUM_GARBAGE_CONTAINERS | NUMBER | This column is used to indicate spe num garbage containers | Active | |||
| SPE_SIZE_GARBAGE_CONTAINERS | NUMBER | This column is used to indicate spe size garbage containers | Active | |||
| SPE_NUM_RECYCLE_CONTAINERS | NUMBER | This column is used to indicate spe num recycle containers | Active | |||
| SPE_SIZE_RECYCLE_CONTAINERS | NUMBER | This column is used to indicate spe size recycle containers | Active | |||
| SPE_DTL_ROAD_CLOSE_FLAG | VARCHAR2 | 1 | This column is used to indicate spe dtl road close flag | Active | ||
| SPE_DTL_ROAD_CLOSE_DESCR | VARCHAR2 | 100 | This column is used to indicate spe dtl road close descr | Active | ||
| SPE_TRAFFIC_PLAN_VERIFIED_FLAG | VARCHAR2 | 1 | This column is used to indicate spe traffic plan verified flag | Active | ||
| SPE_TRAFFIC_ROUTE_REQ_FLAG | VARCHAR2 | 1 | This column is used to indicate spe traffic route req flag | Active | ||
| SPE_TRAFFIC_EQUIP_DESCR | VARCHAR2 | 100 | This column is used to indicate spe traffic equip descr | Active | ||
| SPE_PARK_PROVIDED_FLAG | VARCHAR2 | 1 | This column is used to indicate spe park provided flag | Active | ||
| SPE_PARKING_PLAN_DESCR | VARCHAR2 | 100 | This column is used to indicate spe parking plan descr | Active | ||
| SPE_PARK_PLAN_VERIFIED_FLAG | VARCHAR2 | 1 | This column is used to indicate spe park plan verified flag | Active | ||
| SPE_NOTIFY_FLAG | VARCHAR2 | 1 | This column is used to indicate spe notify flag | Active | ||
| SPE_STREET_CLOSURE_FLAG | VARCHAR2 | 1 | This column is used to indicate spe street closure flag | Active | ||
| SPE_STR_CLOSE_START_DATETIME | TIMESTAMP | This column is used to indicate spe str close start datetime | Active | |||
| SPE_STR_CLOSE_END_DATETIME | TIMESTAMP | This column is used to indicate spe str close end datetime | Active | |||
| SPE_NUM_PARK_SPACES | NUMBER | This column is used to indicate spe num park spaces | Active | |||
| SPE_NUM_DISABLE_PARK_SPACES | NUMBER | This column is used to indicate spe num disable park spaces | Active | |||
| SPE_PARK_SHUTTLES | NUMBER | 6 | This column is used to indicate the number of parking shuttles. | Active | ||
| SPE_NUM_SHUTTLES | NUMBER | This column is used to indicate spe num shuttles | Active | |||
| 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 | |
| GEN_FLOOR_AREA_TOTAL | NUMBER | This column is used to indicate gen floor area total | Active | |||
| GEN_TOTAL_NUM_STORIES | NUMBER | This column is used to indicate gen total num stories | 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. | Active | ||
| AGENCY_ID | NUMBER | 8 | Yes | This column is used to indicate agency id | Active | |
| SGN_USAGE_TYPE | VARCHAR2 | 100 | This column is used to indicate if the sign is temporary or permanent. | Active | ||
| SGN_TEMPORARY_TYPE | VARCHAR2 | 100 | This column is used to indicate the temporary sign type. | Active | ||
| SGN_PERMANENT_TYPE | VARCHAR2 | 100 | This column is used to indicate the parmanent sign type. | Active | ||
| SGN_FACE_HEIGHT | NUMBER | 6 | This column is ued to indicate the sign face height. | Active | ||
| SGN_FACE_WIDTH | NUMBER | 6 | This column is used to indicate the sign face width. | Active | ||
| SGN_TOTAL_FACE_AREA | NUMBER | 6 | This column is used to indicate the total area of the sign face. | Active | ||
| SGN_ILLUMINATION_TYPE | VARCHAR2 | 100 | This column is used to indicate the type of illumination. | Active | ||
| SGN_TOTAL_HEIGHT | NUMBER | 6 | This column is used to indicate the overall height above grade of the top of the finished sign. | Active | ||
| WHR_NEW_HEATER | VARCHAR2 | 100 | This column is used to indicate water heater is new or is a replacement. | Active | ||
| WHR_NUMBER_NEW | NUMBER | 6 | This column is used to indicate the number of new water heaters. | Active | ||
| WHR_NUMBER_REPLACE | NUMBER | 6 | This column is used to indicate the number of replacement water heaters. | Active | ||
| WHR_HEATER_TYPE | VARCHAR2 | 100 | This column is used to indicate water heater type. | Active | ||
| WHR_TANK_CAPACITY | NUMBER | 6 | This column is used to indicate the capacity for tank water heaters. | Active | ||
| WHR_FUEL_TYPE | VARCHAR2 | 100 | This column is used to indicate the fuel type used by the water heater. | Active | ||
| WEIGHT_UOM | VARCHAR2 | 5 | This column is used to indicate the unit of measure for weight. | Active | ||
| VOLUME_UOM | VARCHAR2 | 5 | This column is used to indicate the unit of measure for volume. | Active | ||
| DISTANCE_UOM | VARCHAR2 | 5 | This column is used to indicate the unit of measure for distance. | Active | ||
| AREA_UOM | VARCHAR2 | 5 | This column is used to indicate the unit of measure for area. | Active | ||
| DURATION_UOM | VARCHAR2 | 5 | This column is used to indicate the unit of measure for duration. | Active | ||
| DIMENSION_UOM | VARCHAR2 | 5 | This column is used to indicate the unit of measure for dimension. | Active | ||
| LAND_UOM | VARCHAR2 | 5 | This column is used to indicate the unit of measure for land. | Active | ||
| HEIGHT_UOM | VARCHAR2 | 5 | This column is used to indicate the unit of measure for height | |||
| DWL_PROPOSED_DWELLING_UNITS | NUMBER | 6 | This column is used to indicate the additional dwelling units | |||
| DWL_PROPOSED_DWELLLING_AREA | NUMBER | This column is used to indicate the additional dwelling unit floor area | Obsolete | |||
| DWL_PROPOSED_DWELLING_AREA | NUMBER | This column is used to indicate the additional dwelling unit floor area | ||||
| DWL_CONCESSION_INCENTIVE_FLAG | VARCHAR2 | 1 | This column is used to indicate the request for concessions or incentives in addition to a density bonus | |||
| DWL_DENSITY_BONUS_FLAG | VARCHAR2 | 1 | This column is used to indicate the request for density bonus | |||
| DWL_DWELLING_CONTROL_RENT_FLAG | VARCHAR2 | 1 | This column is used to indicate the dwelling units on the property controlled rental unit | |||
| DWL_DWELLING_UNIT_AREA_UOM | VARCHAR2 | 5 | This column is used to indicate the unit of measure for floor area | |||
| DWL_ELIMINATE_DWELLING_FLAG | VARCHAR2 | 1 | This column is used to indicate the project involves the elimination or rehabilitation of any dwelling units | |||
| DWL_EXISTING_DWELLING_AREA | NUMBER | This column is used to indicate the existing dwelling unit floor area | ||||
| DWL_EXISTING_DWELLING_UNITS | NUMBER | 6 | This column is used to indicate the existing dwelling units | |||
| DWL_CHANGE_DWELLING_UNITS | NUMBER | 6 | This column is used to indicate the changes to the dwelling units | |||
| DWL_CHANGE_DWELLLING_AREA | NUMBER | This column is used to indicate the changes to the dwelling unit floor area | Obsolete | |||
| DWL_CHANGE_DWELLING_AREA | NUMBER | This column is used to indicate the changes to the dwelling unit floor area | ||||
| IMP_EXEMPT_HYDROMOD_FLAG | VARCHAR2 | 1 | This column is used to indicate the exempt from hydromodification requirements | |||
| IMP_EXEMPT_INFILTRATION_FLAG | VARCHAR2 | 1 | This column is used to indicate the exempt from infiltration feasibility | |||
| IMP_EXEMPT_RAIN_HARV_USE_FLAG | VARCHAR2 | 1 | This column is used to indicate the exempt from rainwater harvesting and use feasibility | |||
| IMP_EXISTING_IMPERVIOUS_AREA | NUMBER | This column is used to indicate the existing impervious surface area | ||||
| IMP_IMPERVIOUS_AREA_UOM | VARCHAR2 | 5 | This column is used to indicate the unit of measure for Impervious area | |||
| IMP_LOT_AREA | NUMBER | This column is used to indicate the property lot area | ||||
| IMP_PROPOSED_IMPERVIOUS_AREA | NUMBER | This column is used to indicate the proposed impervious surface area | ||||
| IMP_SURFICE_RATIO_PERCENTAGE | NUMBER | 3 | This column is used to indicate the impervious surface ratio % |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| PSC_LNP_FIELD_GROUPS | psc_lnp_record | LNP_RECORD_KEY |
Indexes
| Index | Uniqueness | Tablespace | Columns | Status |
|---|---|---|---|---|
| PSC_LNP_FIELD_GROUPS_PK | Unique | Default | LNP_RECORD_KEY | Active |
| PSC_LNP_FIELD_GROUPS_U1 | Unique | Default | LNP_FIELD_GROUP_PUID |