Oracle Fusion · Data dictionary
CMP_SALARY_HISTORY_V
CompensationUsed in 0 subject areas71 reporting columnsBICC incremental-ready
Compensation (CMP), denormalized view.
Primary key: not yet catalogued for CMP_SALARY_HISTORY_V, reference Oracle Tables & Views guide. · Incremental key: LAST_UPDATE_DATE, SALARY_BASIS_LAST_UPDATE_DATE
Joins (inferred from key columns): ACTION_OCCURRENCE_ID → PER_ACTION_OCCURRENCES · ACTION_REASON_ID → PER_ACTION_REASONS_B · GEOGRAPHY_ID → HZ_GEOGRAPHIES · LEGAL_ENTITY_ID → XLE_ENTITY_PROFILES
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACTION_ID | ● | Identifier for the action. | |
| ACTION_OCCURRENCE_ID | ● | Identifier for the action occurrence. | |
| ACTION_REASON_ID | ● | Identifier for the action reason. | |
| AMOUNT_DECIMAL_PRECISION | ● | Amount decimal precision. | |
| AMOUNT_ROUNDING_CODE | ● | Code identifying the amount rounding. | |
| ANNUALIZED_FULLTIME_SALARY | ● | Annualized fulltime salary. | |
| ANNUALIZED_HOURS | ● | Annualized hours. | |
| ANNUALIZED_SALARY | ● | Annualized salary. | |
| ANNUAL_ROUNDING_CODE | ● | Code identifying the annual rounding. | |
| ASSIGNMENT_ID | ● | Identifier for the assignment. | |
| BUSINESS_GROUP_ID | ● | Identifier for the business group. | |
| BUSINESS_UNIT_ID | ● | Identifier for the business unit. | |
| CALCULATION_MODE | ● | Calculation mode. | |
| CODE | ● | Code. | |
| COMPONENT_USAGE | ● | Component usage. | |
| CREATED_BY | ● | User who created the row. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| DATE_FROM | ● | Date from. | |
| DATE_TO | ● | Date to. | |
| DESCRIPTION | ● | Description. | |
| ELEMENT_ENTRY_ID | ● | Identifier for the element entry. | |
| ELEMENT_TYPE_ID | ● | Identifier for the element type. | |
| FORCED_RANKING | ● | Forced ranking. | |
| GEOGRAPHY_ID | ● | Identifier for the geography. | |
| GEOGRAPHY_TYPE_ID | ● | Identifier for the geography type. | |
| GRADE_ANNUALIZATION_FACTOR | ● | Grade annualization factor. | |
| GRADE_RATE_ID | ● | Identifier for the grade rate. | |
| GRADE_RATE_MINIMUM_LIMIT | ● | Grade rate minimum limit. | |
| HISTORY_DATE | ● | History date. | |
| INPUT_VALUE_ID | ● | Identifier for the input value. | |
| INPUT_VALUE_LANGUAGE | ● | Input value language. | |
| INPUT_VALUE_NAME | ● | Name of the input value. | |
| JOB_ID | ● | Identifier for the job. | |
| LAST_UPDATED_BY | ● | User who last updated the row. | |
| LAST_UPDATE_DATE | INCR | ● | Date and time the row was last updated (the incremental-extract key). |
| LAST_UPDATE_LOGIN | ● | Session login of the user who last updated the row. | |
| LEGAL_ENTITY_ID | ● | Identifier of the legal entity. | |
| LEGISLATIVE_DATA_GROUP_ID | ● | Identifier for the legislative data group. | |
| MULTIPLE_COMPONENTS | ● | Multiple components. | |
| NEXT_PERF_REVIEW_DATE | ● | Next perf review date. | |
| NEXT_SAL_REVIEW_DATE | ● | Next sal review date. | |
| OBJECT_VERSION_NUMBER | ● | Optimistic-locking version number, incremented on each update. | |
| PAYROLL_ANNUAL_FACTOR | ● | Payroll annual factor. | |
| PAYROLL_FREQUENCY_CODE | ● | Code identifying the payroll frequency. | |
| PERFORMANCE_RATING | ● | Performance rating. | |
| PERFORMANCE_REVIEW_ID | ● | Identifier for the performance review. | |
| RANGE_ERROR_WARNING | ● | Range error warning. | |
| RANGE_ROUNDING_CODE | ● | Code identifying the range rounding. | |
| REVIEW_DATE | ● | Review date. | |
| SALARY_AMOUNT | ● | Salary amount. | |
| SALARY_ANNUALIZATION_FACTOR | ● | Salary annualization factor. | |
| SALARY_APPROVED | ● | Salary approved. | |
| SALARY_BASES_NAME | ● | Name of the salary bases. | |
| SALARY_BASIS_CODE | ● | Code identifying the salary basis. | |
| SALARY_BASIS_CREATED_BY | ● | Salary basis created by. | |
| SALARY_BASIS_CREATION_DATE | ● | Salary basis creation date. | |
| SALARY_BASIS_ID | ● | Identifier for the salary basis. | |
| SALARY_BASIS_LAST_UPDATED_BY | ● | Salary basis last updated by. | |
| SALARY_BASIS_LAST_UPDATE_DATE | INCR | ● | Salary basis last update date. |
| SALARY_BASIS_NAME | ● | Name of the salary basis. | |
| SALARY_BASIS_TYPE | ● | Type of salary basis. | |
| SALARY_ID | ● | Identifier for the salary. | |
| SALARY_REASON_CODE | ● | Code identifying the salary reason. | |
| SB_BUSINESS_GROUP_ID | ● | Identifier for the sb business group. | |
| SB_LANGUAGE | ● | Sb language. | |
| SB_SALARY_BASIS_ID | ● | Identifier for the sb salary basis. | |
| SB_SOUCE_LANG | ● | Sb souce lang. | |
| SOURCE_LANG | ● | Source lang. | |
| STATUS | ● | Status. | |
| WORK_AT_HOME | ● | Work at home. | |
| ZONE_GRADE_RATE_ID | ● | Identifier for the zone grade rate. |
Used by reports
No cataloged report reads from this table yet, it's part of the broader Fusion dictionary.
- ,
Subject areas
- ,
Need the extract + dbt staging for CMP_SALARY_HISTORY_V?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table