1. Tables and Views
  2. PSC_COM_BUS_LOCATION

PSC_COM_BUS_LOCATION

This table contains application specific details for business entity locations.

Details

  • Schema: FUSION

  • Object owner: PSC_CC

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

PSC_COM_BUS_LOCATION_PK

BUSINESS_LOCATION_KEY

Columns

Name Datatype Length Precision Not-null Comments
BUSINESS_LOCATION_KEY NUMBER 18 Yes System-generated Business Entity GUID
BUSINESS_LOCATION_ID VARCHAR2 50 Yes Unique alpha-numeric key
BUSINESS_LOCATION_PARTY_ID NUMBER 18 Business Location Party ID
AGENCY_ID NUMBER 8 Yes This column is used to indicate agency Id.
BUSINESS_ENTITY_KEY NUMBER 18 Yes This column is Foreign Key to Business Entity Table
BUSINESS_ENTITY_ID VARCHAR2 50 Yes Business Entity ID that this location belongs to
BUS_CATEGORY VARCHAR2 50 Business Category
BUS_SUB_CATEGORY VARCHAR2 50 Business sub category
BUS_STATE_TAX_ID VARCHAR2 20 State tax ID for this business location
CITY_TAX_ID VARCHAR2 20 City tax ID for this business location
TAX_CLASS VARCHAR2 30 Municipal tax class
OTHER_TAX_ID VARCHAR2 20 Other tax ID for this business location
ENABLED_FLAG VARCHAR2 1 Indicates if the business location is enabled
STATUS VARCHAR2 20 The current status of the business location
EMAIL_ADDRESS VARCHAR2 320 Email address of the business location
WEBSITE VARCHAR2 1000 Business Location Website
CTY_FOOD_SER_LIC_NUM VARCHAR2 30 The county food service license for the business
CTY_FOOD_SER_LIC_EXP DATE The county food service license expiration date
SELL_PER_NUM VARCHAR2 30 Business Sellers Permit Number
SELL_PER_NUM_EXP DATE Business Sellers Permit expiration date
ST_QUAL_PER_NUM VARCHAR2 30 State Equalization Board Number
RENTAL_UNIT_NUM NUMBER 18 The number of rental units for the business location
WITHIN_JURISDICTION_FLAG VARCHAR2 1 Indicates if the location is within the agency's jurisdiction
MOBILE_BUSINESS_FLAG VARCHAR2 1 Indicates if the business provides a mobile product or service
SAME_MAIL_ADDRESS_FLAG VARCHAR2 1 Indicates if the mailing address of the business is the same as its physical 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
ADDRESS_ID NUMBER 18 System generated sequence key for the parcel address
AREA_SIZE NUMBER 20 The location area size for the business
AREA_SIZE_UOM VARCHAR2 10 The location area size unit of measure
PRIM_PHONE_CONTACT_POINT_ID NUMBER 18 System generated key from the primary phone contact point.
ALT_PHONE_CONTACT_POINT_ID NUMBER 18 System generated key from the alternate phone contact point.
ECONTACT_FIRST_NAME1 VARCHAR2 150 The first name of the first emergency contact
ECONTACT_LAST_NAME1 VARCHAR2 150 The last name of the first emergency contact.
ECONTACT_AVAILABILITY1 VARCHAR2 1000 The availability of the first emergency contact.
E1_PHONE_CONTACT_POINT_ID NUMBER 18 System generated key from the first emergency phone contact point.
ECONTACT_EMAIL1 VARCHAR2 320 The email of the first emergency contact
ECONTACT_FIRST_NAME2 VARCHAR2 150 The first name of the second emergency contact.
ECONTACT_LAST_NAME2 VARCHAR2 150 The last name of the seconf emergency contact.
ECONTACT_AVAILABILITY2 VARCHAR2 1000 The availability of the second emergency contact.
E2_PHONE_CONTACT_POINT_ID NUMBER 18 System generated key from the second emergency phone contact point.
ECONTACT_EMAIL2 VARCHAR2 320 The email of the second emergency contact.
INACTIVE_REASON VARCHAR2 1000 The reason why the business location was changed to inactive
START_DATE DATE The start date of the business location.
END_DATE DATE The end date of the business location.
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.
MUNCIPALITY_ID VARCHAR2 20 Municipality in which the parcel address is located.
STREET_NAME VARCHAR2 240 Street Name 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.
ADDRESS_CODE VARCHAR2 32 Unique identifier for the parcel address.
CROSSROAD1 VARCHAR2 240 Cross road 1 that is part of parcel address.
CROSSROAD2 VARCHAR2 240 Cross road 2 that is part of parcel address.
SHAPE UDT Specifies coordinates of the location defined by the address. Special data type required to store.
LATITUDE NUMBER Geographical latitude location of the parcel address.
LONGITUDE NUMBER Geographical longitude location of the parcel address.
LANDMARK VARCHAR2 200 Landmark for the parcel address.
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_LOGIN VARCHAR2 32 Who column: indicates the session login associated to 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.
MIGRATED_DATA_FLAG VARCHAR2 3 Attribute identifying data migrated from legacy system.
DESCRIPTION VARCHAR2 2000 Short description for the company.
LINE_OF_BUSINESS VARCHAR2 240 Type of business activities performed at this site.
ORGANIZATION_NAME VARCHAR2 360 Name of a party of the Organization party type.
JGZZ_FISCAL_CODE VARCHAR2 20 Taxpayer identification number, often unique identifier of person or organization. Can be SSN or income taxpayer ID in US, fiscal code or NIF in Europe.
EFFECTIVE_START_DATE DATE Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective.
EFFECTIVE_END_DATE DATE Date Effective Entity: indicates the date at the end of the date range within which the row is effective.
EMPLOYEES_TOTAL NUMBER Total number of employees
ORG_PROFILES_STATUS VARCHAR2 1 Record status flag.
ADDRESS_LOC_ID NUMBER 18 Unique identifier for this location.
ADDRESS1 VARCHAR2 240 First line for address.
ADDRESS2 VARCHAR2 240 Second line for address.
ADDRESS3 VARCHAR2 240 Third line for address.
ADDRESS4 VARCHAR2 240 Fourth line for address.
FLOOR_NUMBER VARCHAR2 40 Specific floor number at a given address or in a particular building when building number is provided.
BUILDING VARCHAR2 240 Specific building name or number at a given address.
POSITION VARCHAR2 50 The primary direction such as North or East that is used to access the location.
PROVINCE VARCHAR2 60 Province
POSTAL_PLUS4_CODE VARCHAR2 20 Four digit extension to the United States Postal ZIP code.
COUNTRY VARCHAR2 2 Country code from the TERRITORY_CODE column in the FND_TERRITORY table.
STATE VARCHAR2 60 State
COUNTY VARCHAR2 60 County
CITY VARCHAR2 60 City
POSTAL_CODE VARCHAR2 60 Postal code
MAIL_ADDRS_LOC_ID NUMBER 18 Unique identifier for this mailing location.
MAIL_COUNTRY VARCHAR2 2 Country code from the TERRITORY_CODE column in the FND_TERRITORY table.
MAIL_ADDRESS1 VARCHAR2 240 First line for mailing address.
MAIL_ADDRESS2 VARCHAR2 240 Second line for mailing address.
MAIL_ADDRESS3 VARCHAR2 240 Third line for mailing address.
MAIL_ADDRESS4 VARCHAR2 240 Fourth line for mailing address.
MAIL_CITY VARCHAR2 60 Mailing city.
MAIL_STATE VARCHAR2 60 Mailing state.
MAIL_PROVINCE VARCHAR2 60 Mailing province.
MAIL_COUNTY VARCHAR2 60 Mailing county.
MAIL_POSTAL_CODE VARCHAR2 60 Mailing postal code.
MAIL_POSTAL_PLUS4_CODE VARCHAR2 20 Four digit extension to the United States mailing Postal ZIP code.
PRIMARY_PHONE_TYPE VARCHAR2 30 Indicates the Type of Primary Phone like Work, Home, Mobile etc.
PRIMARY_PHONE_COUNTRY_CODE VARCHAR2 10 International country code for a Primary telephone number. For example, 33 for France.
PRIMARY_PHONE_AREA_CODE VARCHAR2 20 The Primary Phone area code within a country code.
PRIMARY_PHONE_NUMBER VARCHAR2 40 A Primary telephone number formatted in the local format. The number should not include area code, country code, or extension.
PRIMARY_PHONE_EXTENSION VARCHAR2 20 Additional number addressed after initial connection to an internal telephone system for Primary telephone number.
PRIMARY_RAW_PHONE_NUMBER VARCHAR2 60 Unformatted Primary telephone number.
ALT_PHONE_TYPE VARCHAR2 30 Indicates the Type of alternate Phone like Work, Home, Mobile etc.
ALT_PHONE_COUNTRY_CODE VARCHAR2 10 International country code for an alternate telephone number. For example, 33 for France.
ALT_PHONE_AREA_CODE VARCHAR2 20 The alternate Phone area code within a country code.
ALT_PHONE_NUMBER VARCHAR2 40 An alternate telephone number formatted in the local format. The number should not include area code, country code, or extension.
ALT_PHONE_EXTENSION VARCHAR2 20 Additional number addressed after initial connection to an internal telephone system for alternate telephone number.
ALT_RAW_PHONE_NUMBER VARCHAR2 60 Unformatted alternate telephone number.
ECONTACT_PHONE_TYPE_ONE VARCHAR2 30 Indicates the Type of emergency contact one Phone like Work, Home, Mobile etc.
ECONTACT_PHONE_COUNTRY_ONE VARCHAR2 10 International country code for an emergency contact one telephone number. For example, 33 for France.
ECONTACT_PHONE_AREA_CODE_ONE VARCHAR2 20 The emergency contact one Phone area code within a country code.
ECONTACT_PHONE_NUMBER_ONE VARCHAR2 40 An emergency contact one telephone number formatted in the local format. The number should not include area code, country code, or extension.
ECONTACT_PHONE_EXTENSION_ONE VARCHAR2 20 Additional number addressed after initial connection to an internal telephone system for emergency contact one telephone number.
ECONTACT_RAW_PHONE_NUMBER_ONE VARCHAR2 60 Unformatted emergency contact one telephone number.
ECONTACT_PHONE_TYPE_TWO VARCHAR2 30 Indicates the Type of emergency contact two Phone like Work, Home, Mobile etc.
ECONTACT_PHONE_COUNTRY_TWO VARCHAR2 10 International country code for an emergency contact two telephone number. For example, 33 for France.
ECONTACT_PHONE_AREA_CODE_TWO VARCHAR2 20 The emergency contact two Phone area code within a country code.
ECONTACT_PHONE_NUMBER_TWO VARCHAR2 40 An emergency contact two telephone number formatted in the local format. The number should not include area code, country code, or extension.
ECONTACT_PHONE_EXTENSION_TWO VARCHAR2 20 Additional number addressed after initial connection to an internal telephone system for emergency contact two telephone number.
ECONTACT_RAW_PHONE_NUMBER_TWO VARCHAR2 60 Unformatted emergency contact two telephone number.
LOCATION_TYPE VARCHAR2 30 Identifies the type of location. For example, Commercial or Residential.

Foreign Keys

Table Foreign Table Foreign Key Column
psc_com_bus_attachment psc_com_bus_location BUSINESS_LOCATION_KEY

Indexes

Index Uniqueness Tablespace Columns
PSC_COM_BUS_LOCATION_PK Unique Default BUSINESS_LOCATION_KEY
PSC_COM_BUS_LOCATION_U1 Unique Default BUSINESS_LOCATION_ID