Search Results industry_code

Overview

The PER_SALARY_SURVEY_LINES table, owned by the HR schema and part of the PER (Human Resources) product family, stores the detail rows of market salary surveys captured in Oracle E-Business Suite Release 12.1.1 and 12.2.2. Where the parent table PER_SALARY_SURVEYS records the header-level identity of a survey source, each row in PER_SALARY_SURVEY_LINES represents a distinct market data point: a specific job, region, seniority level, company size, industry, and age band observed during a defined survey period. These lines are the granular inputs that compensation professionals use to benchmark internal salary structures against external market conditions.

Under the heuristic Data Vault classification mined from its foreign key structure, this table is satellite-leaning. In modeling terms, it behaves as a descriptive satellite attached to the PER_SALARY_SURVEYS hub, with a business key composed of the survey dimensions and effective dating rather than an intrinsic identity. The 84 documented columns are dominated by measure and attribute fields, which reinforces the satellite interpretation: the table describes a survey context over time rather than establishing an independent business entity.

Key Information Stored

The surrogate primary key is SALARY_SURVEY_LINE_ID, enforced by PER_SALARY_SURVEY_LINES_PK. A separate unique index, PER_SALARY_SURVEY_LINES_UK1, establishes the business-key candidate as the combination of START_DATE, INDUSTRY_CODE, COMPANY_SIZE_CODE, SURVEY_SENIORITY_CODE, SURVEY_REGION_CODE, SURVEY_JOB_NAME_CODE, and SURVEY_AGE_CODE. This composite key is significant because INDUSTRY_CODE is one of the search dimensions users most frequently query, and it is part of the row’s natural identity. Among the most operationally important columns are:

• SALARY_SURVEY_ID — foreign key to the owning survey header in PER_SALARY_SURVEYS.
• SURVEY_JOB_NAME_CODE, SURVEY_REGION_CODE, SURVEY_SENIORITY_CODE, COMPANY_SIZE_CODE, INDUSTRY_CODE, and SURVEY_AGE_CODE — the market segmentation dimensions that define the matching context.
• START_DATE and END_DATE — effective dating for the survey line.
• CURRENCY_CODE and DIFFERENTIAL — currency and geographic or market adjustment factors.
• MINIMUM_PAY, MEAN_PAY, MAXIMUM_PAY, GRADUATE_PAY, and STARTING_PAY — core salary statistics.
• Quartile and percentile fields such as JOB_FIRST_QUARTILE, JOB_MEDIAN_QUARTILE, FIFTIETH_PERCENTILE, and NINETIETH_PERCENTILE — distributional benchmarks.
• Total compensation and variable pay measures including MEAN_TOTAL_COMPENSATION, MEAN_BONUS, MEAN_VARIABLE_COMPENSATION, and MEAN_STOCK.
• Descriptive flexfield columns ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE30 for client-specific extensions.
• Standard audit columns CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, and OBJECT_VERSION_NUMBER.

Common Use Cases and Queries

Typical usage centers on market benchmarking reports that compare internal salary ranges to external survey results, filtered by industry and geography. A common pattern joins the line to its parent survey and filters on the industry and job name dimensions:

• Retrieving mean and median market pay for a given industry and job: SELECT l.survey_job_name_code, l.mean_pay, l.job_median_quartile FROM per_salary_survey_lines l JOIN per_salary_surveys s ON s.salary_survey_id = l.salary_survey_id WHERE l.industry_code = :industry AND l.start_date BETWEEN :from_date AND :to_date;
• Comparing quartile distributions across seniority levels for a region.
• Identifying survey lines mapped to internal grade or job structures through PER_SALARY_SURVEY_MAPPINGS.
• Currency-normalized compensation analysis using CURRENCY_CODE and DIFFERENTIAL.

Related Objects

The following objects are most significant in relation to this table, based on the documented foreign key relationships:

• PER_SALARY_SURVEYS — parent header table; joined via PER_SALARY_SURVEY_LINES.SALARY_SURVEY_ID = PER_SALARY_SURVEYS.SALARY_SURVEY_ID.
• PER_SALARY_SURVEY_MAPPINGS — maps survey lines to internal jobs or grades; references this table via PER_SALARY_SURVEY_MAPPINGS.SALARY_SURVEY_LINE_ID = PER_SALARY_SURVEY_LINES.SALARY_SURVEY_LINE_ID.