1. Tables and Views for Sales and Fusion Service
  2. HZ_LOCATION_PROFILES

HZ_LOCATION_PROFILES

The HZ_LOCATION_PROFILES table stores information, including a history of any changes and address validations for a subset of attributes from the HZ_LOCATIONS table. The stored information includes address lines, the date that the address was last validated, and the effective start and end dates for the location record

Details

  • Schema: FUSION

  • Object owner: HZ

  • Object type: TABLE

  • Tablespace: APPS_TS_TX_DATA

Primary Key

Name Columns

HZ_LOCATION_PROFILES_PK

LOCATION_PROFILE_ID

Columns

Name Datatype Length Precision Not-null Comments Status
LOCATION_PROFILE_ID NUMBER 18 Yes Unique Identifier for a location profile. System Generated. Primary Key
LOCATION_ID NUMBER 18 Yes Foreign key to HZ_LOCATIONS Active
ACTUAL_CONTENT_SOURCE VARCHAR2 30 Actual Content Source. This could represent a third party content source, or a location services vendor Active
EFFECTIVE_START_DATE DATE Yes Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective. Active
EFFECTIVE_END_DATE DATE Yes Date Effective Entity: indicates the date at the end of the date range within which the row is effective. Active
VALIDATION_SST_FLAG VARCHAR2 1 Yes Flag to indicate if this record is denormalized into the HZ_LOCATIONS table as the single source of truth for validated address information Active
VALIDATION_STATUS_CODE VARCHAR2 30 Standardized status code describing the results of the validation.Lookup: HZ_ADDR_VAL_STATUS Active
DATE_VALIDATED DATE Date the address was last validated Active
ADDRESS1 VARCHAR2 240 First line of address Active
ADDRESS2 VARCHAR2 240 Second line of address Active
ADDRESS3 VARCHAR2 240 Third line of address Active
ADDRESS4 VARCHAR2 240 Fourth line of address Active
CITY VARCHAR2 60 City or town Active
POSTAL_CODE VARCHAR2 60 Postal Code
COUNTY VARCHAR2 60 County Active
COUNTRY VARCHAR2 2 Yes Country 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
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. Active
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
CONFLICT_ID NUMBER 18 Yes Disconnected Mobile: this value is used to guarantee the uniqueness of the row when duplicates are created in different databases (i.e. mobile databases or the server). Active
USER_LAST_UPDATE_DATE TIMESTAMP Disconnected Mobile: indicates the date and time of the last update of the row. This value is different from LAST_UPDATE_DATE if the update originally happened in a different database (i.e. a different mobile database or the server). Active
EFFECTIVE_SEQUENCE NUMBER 4 Yes Date Effective Entity: indicates the order of different changes made during a day. The lowest value represents the earliest change in the day. Active
EFFECTIVE_LATEST_CHANGE VARCHAR2 30 Yes Date Effective Entity: 'Y' indicates that this row represents the latest change in the day.
STATE VARCHAR2 60 State Active
PROVINCE VARCHAR2 60 Province
CPDRF_VER_SOR NUMBER 9 Cross Pillar Data Replication Framework (CPDRF) system column for tracking record version in System of Record (SOR) pillar when a record change is replicated to subscribing pillars by the replication flows.
CPDRF_VER_PILLAR NUMBER 9 Cross Pillar Data Replication Framework (CPDRF) system column for tracking record version when a record is changed by replication flows
CPDRF_LAST_UPD VARCHAR2 15 Cross Pillar Data Replication Framework (CPDRF) system column for tracking source pillar name when a record is changed by the replication flows.
BUILDING VARCHAR2 240 Specific building name or number at a given address
FLOOR_NUMBER VARCHAR2 40 Specific floor number at a given address or in a particular building when building number is provided
ADDR_ELEMENT_ATTRIBUTE1 VARCHAR2 150 Additional address element to support flexible address format
ADDR_ELEMENT_ATTRIBUTE2 VARCHAR2 150 Additional address element to support flexible address format
ADDR_ELEMENT_ATTRIBUTE3 VARCHAR2 150 Additional address element to support flexible address format
ADDR_ELEMENT_ATTRIBUTE4 VARCHAR2 150 Additional address element to support flexible address format
ADDR_ELEMENT_ATTRIBUTE5 VARCHAR2 150 Additional address element to support flexible address format
POSTAL_PLUS4_CODE VARCHAR2 20 Four digit extension to the United States Postal ZIP code

Foreign Keys

Table Foreign Table Foreign Key Column
HZ_LOCATION_PROFILES hz_locations LOCATION_ID

Indexes

Index Uniqueness Tablespace Columns
HZ_LOCATION_PROFILES_N1 Non Unique Default LOCATION_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, ACTUAL_CONTENT_SOURCE
HZ_LOCATION_PROFILES_N3 Non Unique Default LAST_UPDATE_DATE
HZ_LOCATION_PROFILES_N4 Non Unique Default REQUEST_ID
HZ_LOCATION_PROFILES_PK Unique Default LOCATION_PROFILE_ID