Search Results pqh_accommodations_f_pk

Overview

PQH_ACCOMMODATIONS_F is a datetracked ("_F" denoting the effective-dated table) transactional table owned by the HR schema and delivered as part of the Public Sector HR (PQH) product family in Oracle E-Business Suite 12.1.1 and 12.2.2. The table stores descriptive and operational information about accommodations—physical or residential units used by public sector agencies for housing, assignment, or facility administration—that are maintained as part of an agency's accommodation inventory. It is not part of Oracle Human Resources core (PER) datetracking, but follows the same effective-dating conventions, allowing multiple historical versions of each accommodation record to coexist.

Based strictly on the heuristic Data Vault classification mined from the FK structure provided in the ETRM metadata, this object is classified as standalone. In Data Vault modeling terms, this suggests the table behaves primarily as a reference or descriptive entity (nearest to a hub or a hub-plus-satellite combination) with no documented foreign key dependencies to other transactional children. Analysts should treat it as a master-level repository rather than a link table in any downstream dimensional model.

Key Information Stored

The table contains 99 documented physical columns. The most significant are:

ACCOMMODATION_ID – Surrogate primary key component; the unique identifier for an accommodation record.
EFFECTIVE_START_DATE / EFFECTIVE_END_DATE – DateTrack effective range columns; together with ACCOMMODATION_ID they form the composite primary key (PQH_ACCOMMODATIONS_F_PK) and are the documented unique business-key candidate.
BUSINESS_GROUP_ID – Associates the accommodation with a specific business group (enterprise context).
ACCOMMODATION_NAME, ACCOMMODATION_DESC, ACCOMMODATION_TYPE, STYLE – Core descriptive attributes defining what the accommodation is.
LOCATION_ID – Logical pointer to a location record, enabling address inheritance.
Address columns: ADDRESS_LINE_1/2/3, TOWN_OR_CITY, COUNTRY, POSTAL_CODE, REGION_1/2/3, plus TELEPHONE_NUMBER_1/2/3.
Capacity/utility: FLOOR_NUMBER, FLOOR_AREA, FLOOR_AREA_MEASURE_UNIT, MAIN_ROOMS, FAMILY_SIZE, SUITABILITY_DISABLED.
Financial: RENTAL_VALUE, RENTAL_VALUE_CURRENCY, and OWNER.
Descriptive flexfields: ATTRIBUTE_CATEGORY and ATTRIBUTE1–30.
Audit: CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER.

Common Use Cases and Queries

Typical reporting scenarios include accommodation inventory listing, capacity analysis, and rental valuation. A standard current-row query is:

Current inventory: SELECT ACCOMMODATION_ID, ACCOMMODATION_NAME, ACCOMMODATION_TYPE, RENTAL_VALUE FROM HR.PQH_ACCOMMODATIONS_F WHERE TRUNC(SYSDATE) BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
Historical versions of a unit: SELECT * FROM HR.PQH_ACCOMMODATIONS_F WHERE ACCOMMODATION_ID = :id ORDER BY EFFECTIVE_START_DATE;
Capacity summary by business group: aggregate MAIN_ROOMS and FAMILY_SIZE grouped by BUSINESS_GROUP_ID.
Accessibility reporting: filter on SUITABILITY_DISABLED = 'Y'.

Because the table is DateTracked, all queries must constrain on effective dates unless the intent is a full-history report.

Related Objects

PER_BUSINESS_GROUPS – join on BUSINESS_GROUP_ID for organization context.
HR_LOCATIONS_ALL / HR_LOCATIONS_ALL_F – logical reference via LOCATION_ID for address resolution.
FND_CURRENCIES – lookup for RENTAL_VALUE_CURRENCY.
FND_FLEX_VALUES / FND_FLEX_VALUE_SETS – validate ATTRIBUTE_CATEGORY and descriptive flexfield ATTRIBUTE1–30.
PER_ALL_PEOPLE_F – for locating CREATED_BY / LAST_UPDATED_BY user references.

Table: PQH_ACCOMMODATIONS_F 12.1.1
owner:HR, object_type:TABLE, fnd_design_data:PQH.PQH_ACCOMMODATIONS_F, object_name:PQH_ACCOMMODATIONS_F, status:VALID, product: PQH - Public Sector HR , description: Information Related to Accomodation , implementation_dba_data: HR.PQH_ACCOMMODATIONS_F ,
Table: PQH_ACCOMMODATIONS_F 12.2.2
owner:HR, object_type:TABLE, fnd_design_data:PQH.PQH_ACCOMMODATIONS_F, object_name:PQH_ACCOMMODATIONS_F, status:VALID, product: PQH - Public Sector HR , description: Information Related to Accomodation , implementation_dba_data: HR.PQH_ACCOMMODATIONS_F ,
INDEX: HR.PQH_ACCOMMODATIONS_F_PK 12.2.2
owner:HR, object_type:INDEX, object_name:PQH_ACCOMMODATIONS_F_PK, status:VALID,
INDEX: HR.PQH_ACCOMMODATIONS_F_PK 12.1.1
owner:HR, object_type:INDEX, object_name:PQH_ACCOMMODATIONS_F_PK, status:VALID,
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
TABLE: HR.PQH_ACCOMMODATIONS_F 12.2.2
owner:HR, object_type:TABLE, fnd_design_data:PQH.PQH_ACCOMMODATIONS_F, object_name:PQH_ACCOMMODATIONS_F, status:VALID,
TABLE: HR.PQH_ACCOMMODATIONS_F 12.1.1
owner:HR, object_type:TABLE, fnd_design_data:PQH.PQH_ACCOMMODATIONS_F, object_name:PQH_ACCOMMODATIONS_F, status:VALID,
PACKAGE BODY: APPS.PQH_ACC_SHD 12.1.1
PACKAGE BODY: APPS.PQH_ACC_SHD 12.2.2
12.1.1 DBA Data 12.1.1
APPS.PQH_ACC_SHD dependencies on PQH_ACCOMMODATIONS_F 12.1.1
APPS.PQH_ACC_SHD dependencies on FND_MESSAGE 12.1.1
APPS.PQH_ACC_SHD dependencies on FND_MESSAGE 12.2.2
APPS.PQH_ACC_SHD dependencies on PQH_ACCOMMODATIONS_F 12.2.2
12.2.2 DBA Data 12.2.2
eTRM - PQH Tables and Views 12.2.2
description: This is a Copy of PQH_WORKSHEET_PERIODS table populated by EFC (Euro as functinoal currency) process. ,
eTRM - PQH Tables and Views 12.1.1
description: This is a Copy of PQH_WORKSHEET_PERIODS table populated by EFC (Euro as functinoal currency) process. ,
eTRM - PQH Tables and Views 12.2.2
description: This is a Copy of PQH_WORKSHEET_PERIODS table populated by EFC (Euro as functinoal currency) process. ,
eTRM - PQH Tables and Views 12.1.1
description: This is a Copy of PQH_WORKSHEET_PERIODS table populated by EFC (Euro as functinoal currency) process. ,