1. Tables and Views
  2. PSC_CE_PARCEL_ADDRESS

PSC_CE_PARCEL_ADDRESS

This table contains license and code enforcement transaction parcel addresses.

Details

  • Schema: FUSION

  • Object owner: PSC_CE

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

PSC_CE_PARCEL_ADDRESS_PK

ADDRESS_KEY

Columns

Name Datatype Length Precision Not-null Comments Status
ADDRESS_KEY NUMBER 18 Yes This column is used to indicate address key Active
TRANSACTION_TYPE VARCHAR2 30 This column is used to store the Transaction Type.
TRANSACTION_KEY NUMBER 18 Yes This column is used to indicate code enforcement transaction key Active
TRANSACTION_ID VARCHAR2 50 Yes This column is used to indicate code enforcement transaction id Active
PARCEL_KEY NUMBER 18 This column is used to indicate parcel key Active
PRIMARY_FLAG VARCHAR2 1 Yes This column is used to indicate primary flag Active
PRIMARY_TRANSADDR_FLAG VARCHAR2 1 Represents the primary address for the transaction.
PARCEL_ID NUMBER 18 This column is used to indicate parcel id Active
ADDRESS_ID NUMBER 18 Yes This column is used to indicate address id Active
COUNTRY VARCHAR2 60 This column indicates the country for the parcel. Active
STATE VARCHAR2 60 This column indicates the state for the parcel. Active
COUNTY VARCHAR2 60 This column indicates the county for the parcel. Active
MUNICIPALITY_ID VARCHAR2 20 This column is used to indicate municipality id Active
ADDRESS1 VARCHAR2 240 This column is used to indicate address1 Active
ADDRESS2 VARCHAR2 240 This column is used to indicate address2 Active
ADDRESS3 VARCHAR2 240 This column is used to indicate address3 Active
ADDRESS4 VARCHAR2 240 This column is used to indicate address4 Active
CITY VARCHAR2 60 This column indicates the city name for the parcel. Active
POSTAL_CODE VARCHAR2 60 This column indicates the postal code for the parcel. Active
STREET_NUMBER VARCHAR2 20 This column indicates the street number for the parcel. Active
STREET_DIRECTION VARCHAR2 10 This column is used to indicate street direction Active
PROVINCE VARCHAR2 60 State code from the STATE_CODE_ISO column in the COM_STATE table.
POSTAL_PLUS4_CODE VARCHAR2 20 Four digit extension to the United States Postal ZIP
STREET_NAME VARCHAR2 240 This column is used to indicate street name Active
STREET_TYPE VARCHAR2 20 This column is used to indicate street type Active
BUILDING_TYPE VARCHAR2 20 This column is used to indicate building type Active
FLOOR VARCHAR2 20 This column is used to indicate floor Active
UNIT_NUMBER VARCHAR2 30 This column is used to indicate unit number Active
STREET_NAME_CONCAT VARCHAR2 350 A concatenation of parts of an address that contains street information.
ADDRESS_FIELD1 VARCHAR2 20 This column is used to indicate address field1 Active
ADDRESS_FIELD2 VARCHAR2 20 This column is used to indicate address field2 Active
ADDRESS_FIELD3 VARCHAR2 20 This column is used to indicate address field3 Active
ADDRESS_TYPE VARCHAR2 20 This column is used to indicate address type Active
EMAIL_ID VARCHAR2 50 This column is used to indicate email id Active
HOME_PHONE_COUNTRY VARCHAR2 10 This column is used to indicate home phone country Active
HOME_PHONE_NUM VARCHAR2 40 This column is used to indicate home phone num Active
WORK_PHONE_COUNTRY VARCHAR2 10 This column is used to indicate work phone country Active
WORK_PHONE_NUM VARCHAR2 40 This column is used to indicate work phone num Active
CELL_PHONE_COUNTRY VARCHAR2 10 This column is used to indicate cell phone country Active
CELL_PHONE_NUM VARCHAR2 40 This column is used to indicate cell phone num Active
FAX_COUNTRY VARCHAR2 10 This column is used to indicate fax country Active
FAX_NUM VARCHAR2 40 This column is used to indicate fax num Active
LONGITUDE NUMBER This column is used to indicate longitude Active
LATITUDE NUMBER This column is used to indicate latitude Active
INPUT_SOURCE VARCHAR2 30 This column is used to indicate input source Active
STREET_SUFFIX VARCHAR2 20 This column describes street name that represents the street.
CROSSROAD1 VARCHAR2 240 This column describes cross road 1 that is part of parcel address.
CROSSROAD2 VARCHAR2 240 This column describes cross road 2 that is part of parcel address.
LANDMARK VARCHAR2 200 This column is to describe landmark that represents 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. Active
SRID NUMBER 10 This column is used to indicate srid 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
SHAPE UDT Specifies coordinates of the location defined by the address. Special data type required to store. Active
COORDINATE_X NUMBER This column is used to indicate coordinate x.
COORDINATE_Y NUMBER This column is used to indicate coordinate y.
ADDRESS_PUID VARCHAR2 480 Yes Indicates the PUID of the address transaction data
PARCEL_PUID VARCHAR2 480 Yes Indicates the PUID of the associated parcel transaction data
TRANSACTION_PUID VARCHAR2 480 Yes Indicates parent PUID of the transaction data
MIGRATED_DATA_FLAG VARCHAR2 3 Indicates migrated flag value

Indexes

Index Uniqueness Tablespace Columns Status
PSC_CE_PARCEL_ADDRESS_N1 Non Unique Default TRANSACTION_KEY
PSC_CE_PARCEL_ADDRESS_PK Unique Default ADDRESS_KEY Active
psc_ce_parcel_address_U1 Unique Default ADDRESS_PUID