1. Tables and Views
  2. PSC_LNP_BUS_LOCATION

PSC_LNP_BUS_LOCATION

This table contains application specific details for business entity owners.

Details

  • Schema: FUSION

  • Object owner: PSC_PER

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

PSC_LNP_BUS_LOCATION_PK

LNP_BUSINESS_LOCATION_KEY

Columns

Name Datatype Length Precision Not-null Comments
LNP_BUSINESS_LOCATION_KEY NUMBER 18 Yes Unique identifier for the transaction business location.
LNP_BUSINESS_LOCATION_PUID VARCHAR2 480 Yes Unique identifier of the BL Location transaction record in the legacy system.
LNP_RECORD_KEY NUMBER 18 Yes Unique identifier for the transaction.
LNP_RECORD_ID VARCHAR2 50 Yes Meaningful identifier for the transaction.
RECORD_NUMBER VARCHAR2 64 Indicates parent PUID.
BUSINESS_LOCATION_KEY NUMBER 18 Unique identifier for business location.
BUSINESS_LOCATION_ID VARCHAR2 50 Meaningful identifier for business location.
BUSINESS_LOCATION_PARTY_ID NUMBER 18 Unique identifier for business location's TCA party.
BUSINESS_ENTITY_KEY NUMBER 18 Unique identifier for the business entity.
BUSINESS_ENTITY_ID VARCHAR2 50 Meaningful identifier for the business entity.
BUS_DESCRIPTION VARCHAR2 200 This column indicates the description of the business.
BUS_CATEGORY VARCHAR2 50 This column indicates the category of the business.
BUS_SUB_CATEGORY VARCHAR2 50 This column indicates the sub category of the business.
BUS_DBA_BUSINESS_NAME VARCHAR2 100 The doing business as name for the business.
BUS_STATE_TAX_ID VARCHAR2 20 This column indicates the business's state tax identifier.
CITY_TAX_ID VARCHAR2 20 This column indicates business's city tax identifier.
EMPLOYER_ID_NUMBER VARCHAR2 20 The business's employer tax identifier.
OTHER_TAX_ID VARCHAR2 20 Identifier for the business's other tax.
ST_QUAL_PER_NUM VARCHAR2 30 The state equalization board number for business.
WEBSITE VARCHAR2 1000 The business's primary website address.
START_DATE DATE The start date of the business location.
END_DATE DATE The end date of the business location.
TAX_CLASS VARCHAR2 30 The municipal tax class for the business.
TAX_CLASS_NAME VARCHAR2 50 The municipal tax class name for the business.
WITHIN_JURISDICTION_FLAG VARCHAR2 1 Indicates if the location is within the agency?s jurisdiction.
MOBILE_BUS_FLAG VARCHAR2 1 Indicates if the business provides a mobile product or service.
PHYSICAL_BUS_LOCATION_FLAG VARCHAR2 1 Indicates if the location has a physical business address.
ADDRESS_ID NUMBER 18 System generated sequence key for the parcel address.
PARCEL_ID NUMBER 18 System generated key from the parcel parent.
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.
LOCATION_ADDRESS_ID NUMBER 18 The reference key to the TCA location table.
ADDRESS1 VARCHAR2 240 Address Line 1 that is part of the parcel address.
ADDRESS2 VARCHAR2 240 Address Line 2 that is part of the parcel address.
ADDRESS3 VARCHAR2 240 Address Line 3 that is part of the parcel address.
ADDRESS4 VARCHAR2 240 Address Line 4 that is part of the parcel address.
ADDRESS_TYPE VARCHAR2 20 Attribute used for address point validation. Possible values might be main address, virtual address, shipping gate address, or others.
BUILDING_TYPE VARCHAR2 20 Building Type used for parcel address searches.
COORDINATE_X NUMBER Geographic x coordinate of the parcel address location.
COORDINATE_Y NUMBER Geographic y coordinate of the parcel address location.
FLOOR VARCHAR2 20 Floor number used for parcel address searches.
LATITUDE NUMBER Geographical latitude location of the parcel address.
LONGITUDE NUMBER Geographical longitude location of the parcel address.
MUNICIPALITY_ID VARCHAR2 20 Municipality in which the parcel address is located.
STREET_NUMBER VARCHAR2 20 Street number used for parcel address searches.
STREET_NAME VARCHAR2 240 Street Name used for parcel address searches.
STREET_DIRECTION VARCHAR2 10 Street Direction used for parcel address searches.
STREET_TYPE VARCHAR2 20 Street Type used for parcel address searches.
STREET_SUFFIX VARCHAR2 20 Street name that describes the street.
UNIT_NUMBER VARCHAR2 30 Apartment unit number used for parcel address searches.
PROVINCE VARCHAR2 60 Location information about the province in which the parcel address is located.
POSTAL_PLUS4_CODE VARCHAR2 10 For US addresses, the full postal code is often quoted as a 5 digit number, followed by a 4 digit number. This column represents the second number having 4 digits.
ADDRESS_CODE VARCHAR2 32 Unique identifier for the parcel address.
COUNTRY VARCHAR2 3 Country that is part of the parcel address.
CITY VARCHAR2 60 City that is part of the parcel address.
POSTAL_CODE VARCHAR2 60 Postal Code that is part of the parcel address.
STATE VARCHAR2 60 State that is part of the parcel address.
COUNTY VARCHAR2 60 County in which the parcel address is located.
CROSSROAD1 VARCHAR2 240 Cross road 1 that is part of parcel address.
CROSSROAD2 VARCHAR2 240 Cross road 2 that is part of parcel address.
LANDMARK VARCHAR2 200 Landmark for the parcel address.
MAILING_ADDRESS_ID NUMBER 18 The reference key to the TCA location table.
MAILING_COUNTRY VARCHAR2 3 The country portion of the location's address.
MAILING_ADDRESS1 VARCHAR2 240 The address1 portion of the location's address.
MAILING_ADDRESS2 VARCHAR2 240 The address2 portion of the location?s address.
MAILING_ADDRESS3 VARCHAR2 240 The address3 portion of the location?s address.
MAILING_ADDRESS4 VARCHAR2 240 The address4 portion of the location's address.
MAILING_CITY VARCHAR2 60 The city portion of the location's address.
MAILING_STATE VARCHAR2 60 The state portion of the location's address.
MAILING_PROVINCE VARCHAR2 60 The province portion of the location's address.
MAILING_COUNTY VARCHAR2 60 The county portion of the location's address.
MAILING_POSTAL_CODE VARCHAR2 60 The postal code portion of the location's address.
MAILING_POSTAL_PLUS4_CODE VARCHAR2 10 The postal4 code portion of the location's address.
PRIMARY_PHONE_TYPE VARCHAR2 30 The type of phone for the location.
PRIMARY_PHONE_COUNTRY_CODE VARCHAR2 10 The international country code for a telephone number.
PRIMARY_PHONE_AREA_CODE VARCHAR2 10 The phone area code within a country.
PRIMARY_PHONE_NUMBER VARCHAR2 40 The phone number of the location.
PRIMARY_PHONE_EXTENSION VARCHAR2 20 The additional extension number after initial connection to an internal telephone system.
PRIMARY_RAW_PHONE_NUMBER VARCHAR2 60 This column indicates location's full phone number.
ALT_PHONE_TYPE VARCHAR2 30 The type of phone for the location alternate phone.
ALT_PHONE_COUNTRY_CODE VARCHAR2 10 The international country code for a telephone number.
ALT_PHONE_AREA_CODE VARCHAR2 10 This column indicates phone area code within a country.
ALT_PHONE_NUMBER VARCHAR2 40 This column indicates phone number of the location.
ALT_PHONE_EXTENSION VARCHAR2 20 The additional extension number after initial connection to an internal telephone system.
ALT_RAW_PHONE_NUMBER VARCHAR2 60 This column indicates location's full phone number.
EMAIL_ADDRESS VARCHAR2 320 This column indicates the location Email Address
ECONTACT_FIRST_NAME1 VARCHAR2 150 The first name of the emergency contact.
ECONTACT_LAST_NAME1 VARCHAR2 150 The last name of the emergency contact.
ECONTACT_PHONE_TYPE1 VARCHAR2 30 The phone type of the emergency contact.
ECONTACT_PHONE_COUNTRY1 VARCHAR2 10 The international country code for a telephone number.
ECONTACT_PHONE_AREA_CODE1 VARCHAR2 10 The phone area code within a country.
ECONTRACT_PHONE_NUMBER1 VARCHAR2 40 The phone number of the emergency contact.
ECONTRACT_PHONE_EXTENSION1 VARCHAR2 20 The additional extension number after initial connection to an internal telephone system.
ECONTRACT_RAW_PHONE_NUMBER1 VARCHAR2 60 The full phone number of the emergency contact.
ECONTACT_EMAIL1 VARCHAR2 320 The email of the emergency contact.
ECONTRACT_AVAILABLITY1 VARCHAR2 1000 The availability of the emergency contact.
ECONTACT_FIRST_NAME2 VARCHAR2 150 The first name of the emergency contact2.
ECONTACT_LAST_NAME2 VARCHAR2 150 The last name of the emergency contact2.
ECONTACT_PHONE_TYPE2 VARCHAR2 30 The phone type of the emergency contact2.
ECONTACT_PHONE_COUNTRY2 VARCHAR2 10 The international country code for a telephone number.
ECONTACT_PHONE_AREA_CODE2 VARCHAR2 10 The phone area code within a country.
ECONTRACT_PHONE_NUMBER2 VARCHAR2 40 The phone number of the emergency contact.
ECONTRACT_PHONE_EXTENSION2 VARCHAR2 20 The additional extension number after initial connection to an internal telephone system.
ECONTRACT_RAW_PHONE_NUMBER2 VARCHAR2 60 The full phone number of the emergency contact.
ECONTACT_EMAIL2 VARCHAR2 320 The email of the emergency contact.
ECONTRACT_AVAILABLITY2 VARCHAR2 1000 The availability of the emergency contact.
STATUS VARCHAR2 10 The current status of the business location.
INACTIVE_REASON VARCHAR2 1000 The reason why the business location was changed to inactive.
ENABLED_FLAG VARCHAR2 1 Indicates if the business location is enabled.
SAME_MAIL_ADDRESS_FLAG VARCHAR2 1 Indicates that the mailing address is the same as the primary address.
SUBJECT_ID VARCHAR2 30 Attribute used to identify where the data should be displayed.
EMPLOYEES_TOTAL NUMBER 18 The number of employees for the business location.
AGENCY_ID NUMBER 8 Yes This column is identifier of the agency.
MIGRATED_DATA_FLAG VARCHAR2 3 Indicates if the transaction is migrated data.
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.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
LOCATION_TYPE VARCHAR2 30 Identifies the type of location. For example, Commercial or Residential.

Foreign Keys

Table Foreign Table Foreign Key Column
PSC_LNP_BUS_LOCATION psc_lnp_record LNP_RECORD_KEY

Indexes

Index Uniqueness Tablespace Columns
PSC_LNP_BUS_LOCATION_N1 Non Unique Default LNP_RECORD_KEY
PSC_LNP_BUS_LOCATION_U1 Unique Default LNP_BUSINESS_LOCATION_KEY
PSC_LNP_BUS_LOCATION_U2 Unique Default LNP_BUSINESS_LOCATION_PUID