Oracle Fusion · Data dictionary
CMP_PRE_SALARY_V
CompensationUsed in 0 subject areas38 reporting columns
Compensation (CMP), denormalized view.
Primary key: not yet catalogued for CMP_PRE_SALARY_V, reference Oracle Tables & Views guide.
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ANNUALIZATION_FACTOR | ● | Annualization factor. | |
| ANNUALIZED_FULLTIME_SALARY | ● | Annualized fulltime salary. | |
| ANNUALIZED_SALARY | ● | Annualized salary. | |
| ASSIGNMENT_ID | ● | Identifier for the assignment. | |
| BUSINESS_UNIT_ID | ● | Identifier for the business unit. | |
| COMPARATIO | ● | Comparatio. | |
| DATE_FROM | ● | Date from. | |
| DATE_TO | ● | Date to. | |
| ELEMENT_TYPE_ID | ● | Identifier for the element type. | |
| GEOGRAPHY_ID | ● | Identifier for the geography. | |
| GEOGRAPHY_TYPE_ID | ● | Identifier for the geography type. | |
| GRADE_RATE_MINIMUM_LIMIT | ● | Grade rate minimum limit. | |
| JOB_ID | ● | Identifier for the job. | |
| LAST_UPDATE_DATE | ● | Date and time the row was last updated (the incremental-extract key). | |
| MAXIMUM | ● | Maximum. | |
| MID_VALUE | ● | Mid value. | |
| MINIMUM | ● | Minimum. | |
| PAYROLL_ANNUAL_FACTOR | ● | Payroll annual factor. | |
| PAYROLL_FREQUENCY_CODE | ● | Code identifying the payroll frequency. | |
| PERCENTILE | ● | Percentile. | |
| PREV_AMT | ● | Prev amount. | |
| PREV_CURR_CODE | ● | Code identifying the prev currency. | |
| PREV_SALARY_BASIS | ● | Prev salary basis. | |
| QUARTILE | ● | Quartile. | |
| QUINTILE | ● | Quintile. | |
| RANGE_DIFF_FACTOR | ● | Range diff factor. | |
| RATE_FREQUENCY | ● | Rate frequency. | |
| RATE_ID | ● | Identifier for the rate. | |
| RATE_NAME | ● | Name of the rate. | |
| RATE_OBJECT_TYPE | ● | Type of rate object. | |
| RATE_TYPE | ● | Type of rate. | |
| RATE_VALUE | ● | Rate value. | |
| SALARY_AMOUNT | ● | Salary amount. | |
| SALARY_CHANGE_AMT | ● | Salary change amount. | |
| SALARY_CHANGE_PER | ● | Salary change per. | |
| SALARY_ID | ● | Identifier for the salary. | |
| 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_PRE_SALARY_V?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table