Search Results rate_or_payscale_id

Overview

PSB.PSB_SALARY_I is the interface (staging) table used by Oracle E-Business Suite's Payroll and Salary administration functionality to import salary information in bulk. Records loaded into this table are validated and subsequently transferred into the normalized operational tables PSB_PAY_ELEMENTS, PSB_PAY_ELEMENT_OPTIONS, and PSB_PAY_ELEMENT_RATES. The table therefore functions as a transient intake buffer rather than a system of record; rows typically persist only for the duration of the import and validation cycle. The object resides in the APPS_TS_INTERFACE tablespace and is owned by the PSB schema, with FND Design Data registered as PSB.PSB_SALARY_I. Its documented status is VALID in both Oracle EBS 12.1.1 and 12.2.2.

The ETRM dependency metadata classifies this object heuristically as standalone. Under a Data Vault modeling interpretation this suggests it is best treated as a raw staging satellite or landing construct rather than a true business hub or link. The single documented foreign key, DATA_EXTRACT_ID referencing PSB_DATA_EXTRACTS, establishes the only explicit lineage relationship in the ETRM metadata; all other relationships are resolved through the salary import program logic rather than declarative constraints.

Key Information Stored

The table supports three distinct salary structures — Grade Rate, Grade Step, and Non-Grade — and the column population rules differ by structure. The most significant attributes are:

• SALARY_TYPE — Qualifies the salary element as RATE, STEP, or VALUE and determines which remaining columns are mandatory.
• RATE_OR_PAYSCALE_ID — The rate or pay scale identifier for salary elements of type RATE or STEP. This is the column the user searched for and is the leading column of the unique index.
• GRADE_ID — The grade unique identifier, required for Grade Rate and Grade Step structures.
• GRADE_STEP and SEQUENCE_NUMBER — Applicable to STEP salary elements; SEQUENCE_NUMBER governs the incremental ordering of the step within the pay scale and grade.
• MINIMUM_VALUE, MAXIMUM_VALUE, MID_VALUE, and ELEMENT_VALUE — Monetary values. For Grade Rate structures the range values plus ELEMENT_VALUE are required; for Non-Grade structures only ELEMENT_VALUE is required.
• DATA_EXTRACT_ID — The extract batch identifier that ties each row to its originating extract.
• EFFECTIVE_START_DATE and EFFECTIVE_END_DATE — Date-effective boundaries for the imported salary record.
• BUSINESS_GROUP_ID — The business group context for multi-organization installations.

The table has 22 documented columns. No surrogate single-column primary key is documented. The unique index PSB_SALARY_1_U1 spans (RATE_OR_PAYSCALE_ID, GRADE_ID, GRADE_STEP, SEQUENCE_NUMBER, DATA_EXTRACT_ID) and therefore represents the composite business-key candidate. A non-unique index, PSB_SALARY_1_N1, covers (GRADE_ID, DATA_EXTRACT_ID) to support grade-oriented lookups.

Common Use Cases and Queries

Typical usage revolves around loading extracts, validating them before transfer, reconciling failed rows, and auditing what was imported. A diagnostic query to inspect grade rate rows awaiting transfer:

• SELECT rate_or_payscale_id, grade_id, minimum_value, mid_value, maximum_value, element_value FROM psb.psb_salary_i WHERE salary_type = 'RATE' AND data_extract_id = :extract_id;
• SELECT i.grade_id, i.grade_step, i.sequence_number, e.extract_name FROM psb.psb_salary_i i, psb.psb_data_extracts e WHERE i.data_extract_id = e.data_extract_id AND i.salary_type = 'STEP' ORDER BY i.grade_id, i.sequence_number;
• SELECT rate_or_payscale_id, COUNT(*) FROM psb.psb_salary_i GROUP BY rate_or_payscale_id HAVING COUNT(*) > 1; — used to detect duplicate business keys before the unique index or transfer process rejects them.

Because the table is date-effective, reporting queries should filter on EFFECTIVE_START_DATE and EFFECTIVE_END_DATE to obtain the salary value in force for a given period.

Related Objects

The following objects participate in the salary import flow or reference this interface table:

• PSB_DATA_EXTRACTS — The only documented foreign key parent; joined on DATA_EXTRACT_ID.
• PSB_PAY_ELEMENTS — Target table receiving validated element definitions.
• PSB_PAY_ELEMENT_OPTIONS — Receives element option definitions derived from the interface rows.
• PSB_PAY_ELEMENT_RATES — Receives the rate values keyed by RATE_OR_PAYSCALE_ID and GRADE_ID.

Beyond these documented dependencies, salary interface loads are commonly driven by concurrent programs and extract definitions that read PSB_DATA_EXTRACTS and write into PSB_SALARY_I prior to the transfer step.