Analytics Catalog/Data dictionary/CMP_SALARY
Explore the catalogReportsModulesEnterprise modelOTBI subject areasBICC PVOs
Oracle Fusion · Data dictionary

CMP_SALARY

CompensationUsed in 0 subject areas158 reporting columnsBICC incremental-ready

Compensation (CMP).

Likely primary key: SALARY_ID (inferred from Oracle naming conventions, verify against Tables & Views) · Incremental key: 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

ColumnKeyIn reportsDescription (inferred)
ACTION_ID●Identifier for the action.
ACTION_OCCURRENCE_ID●Identifier for the action occurrence.
ACTION_REASON_ID●Identifier for the action reason.
ADJUSTMENT_AMOUNT●Adjustment amount.
ADJUSTMENT_AMOUNT_SCALE●Adjustment amount scale.
ADJUSTMENT_PERCENT●Adjustment percentage.
ADJUSTMENT_PERCENT_SCALE●Adjustment percent scale.
AMOUNT_ROUNDING_CODE●Code identifying the amount rounding.
ANNUAL_FT_SALARY●Annual ft salary.
ANNUAL_ROUNDING_CODE●Code identifying the annual rounding.
ANNUAL_SALARY●Annual salary.
ASSIGNMENT_ID●Identifier for the assignment.
ASSIGNMENT_TYPE●Type of assignment.
ASSIG_GRADE_LADDER_ID●Identifier for the assig grade ladder.
ASSIG_GRADE_STEP_ID●Identifier for the assig grade step.
ASSIG_LOCATION_ID●Identifier for the assig location.
ATTRIBUTE1●Descriptive flexfield segment.
ATTRIBUTE10●Descriptive flexfield segment.
ATTRIBUTE11●Descriptive flexfield segment.
ATTRIBUTE12●Descriptive flexfield segment.
ATTRIBUTE13●Descriptive flexfield segment.
ATTRIBUTE14●Descriptive flexfield segment.
ATTRIBUTE15●Descriptive flexfield segment.
ATTRIBUTE16●Descriptive flexfield segment.
ATTRIBUTE17●Descriptive flexfield segment.
ATTRIBUTE18●Descriptive flexfield segment.
ATTRIBUTE19●Descriptive flexfield segment.
ATTRIBUTE2●Descriptive flexfield segment.
ATTRIBUTE20●Descriptive flexfield segment.
ATTRIBUTE21●Descriptive flexfield segment.
ATTRIBUTE22●Descriptive flexfield segment.
ATTRIBUTE23●Descriptive flexfield segment.
ATTRIBUTE24●Descriptive flexfield segment.
ATTRIBUTE25●Descriptive flexfield segment.
ATTRIBUTE26●Descriptive flexfield segment.
ATTRIBUTE27●Descriptive flexfield segment.
ATTRIBUTE28●Descriptive flexfield segment.
ATTRIBUTE29●Descriptive flexfield segment.
ATTRIBUTE3●Descriptive flexfield segment.
ATTRIBUTE30●Descriptive flexfield segment.
ATTRIBUTE4●Descriptive flexfield segment.
ATTRIBUTE5●Descriptive flexfield segment.
ATTRIBUTE6●Descriptive flexfield segment.
ATTRIBUTE7●Descriptive flexfield segment.
ATTRIBUTE8●Descriptive flexfield segment.
ATTRIBUTE9●Descriptive flexfield segment.
ATTRIBUTE_CATEGORY●Descriptive flexfield context (structure definition).
ATTRIBUTE_DATE1●Descriptive flexfield segment.
ATTRIBUTE_DATE10●Descriptive flexfield segment.
ATTRIBUTE_DATE11●Descriptive flexfield segment.
ATTRIBUTE_DATE12●Descriptive flexfield segment.
ATTRIBUTE_DATE13●Descriptive flexfield segment.
ATTRIBUTE_DATE14●Descriptive flexfield segment.
ATTRIBUTE_DATE15●Descriptive flexfield segment.
ATTRIBUTE_DATE2●Descriptive flexfield segment.
ATTRIBUTE_DATE3●Descriptive flexfield segment.
ATTRIBUTE_DATE4●Descriptive flexfield segment.
ATTRIBUTE_DATE5●Descriptive flexfield segment.
ATTRIBUTE_DATE6●Descriptive flexfield segment.
ATTRIBUTE_DATE7●Descriptive flexfield segment.
ATTRIBUTE_DATE8●Descriptive flexfield segment.
ATTRIBUTE_DATE9●Descriptive flexfield segment.
ATTRIBUTE_NUMBER1●Descriptive flexfield segment.
ATTRIBUTE_NUMBER10●Descriptive flexfield segment.
ATTRIBUTE_NUMBER11●Descriptive flexfield segment.
ATTRIBUTE_NUMBER12●Descriptive flexfield segment.
ATTRIBUTE_NUMBER13●Descriptive flexfield segment.
ATTRIBUTE_NUMBER14●Descriptive flexfield segment.
ATTRIBUTE_NUMBER15●Descriptive flexfield segment.
ATTRIBUTE_NUMBER16●Descriptive flexfield segment.
ATTRIBUTE_NUMBER17●Descriptive flexfield segment.
ATTRIBUTE_NUMBER18●Descriptive flexfield segment.
ATTRIBUTE_NUMBER19●Descriptive flexfield segment.
ATTRIBUTE_NUMBER2●Descriptive flexfield segment.
ATTRIBUTE_NUMBER20●Descriptive flexfield segment.
ATTRIBUTE_NUMBER3●Descriptive flexfield segment.
ATTRIBUTE_NUMBER4●Descriptive flexfield segment.
ATTRIBUTE_NUMBER5●Descriptive flexfield segment.
ATTRIBUTE_NUMBER6●Descriptive flexfield segment.
ATTRIBUTE_NUMBER7●Descriptive flexfield segment.
ATTRIBUTE_NUMBER8●Descriptive flexfield segment.
ATTRIBUTE_NUMBER9●Descriptive flexfield segment.
BUSINESS_GROUP_ID●Identifier for the business group.
BUSINESS_UNIT_ID●Identifier for the business unit.
COMPA_RATIO●Compa ratio.
COMPA_RATIO_SCALE●Compa ratio scale.
COMPONENT_USAGE●Component usage.
CREATED_BY●User who created the row.
CREATION_DATE●Date and time the row was created.
CURRENCY_CODE●Code identifying the currency.
DATE_FROM●Date from.
DATE_TO●Date to.
DISABLE_COMPA_RATIO●Disable compa ratio.
DISABLE_QUARTILE●Disable quartile.
DISABLE_QUINTILE●Disable quintile.
DISABLE_RANGE_POSITION●Disable range position.
ELEMENT_ENTRY_ID●Identifier for the element entry.
ELEMENT_TYPE_ID●Identifier for the element type.
ELEMENT_USAGE_LEVEL●Element usage level.
FORCED_RANKING●Forced ranking.
FTE_IMPACT●Fte impact.
FTE_VALUE●Fte value.
GEOGRAPHY_ID●Identifier for the geography.
GEOGRAPHY_TYPE_ID●Identifier for the geography type.
GRADE_ID●Identifier for the grade.
GRADE_RATE_MINIMUM_LIMIT●Grade rate minimum limit.
INPUT_VALUE_ID●Identifier for the input value.
JOB_ID●Identifier for the job.
LAST_UPDATED_BY●User who last updated the row.
LAST_UPDATE_DATEINCR●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.
MISC_COMMENT1●Misc comment1.
MISC_COMMENT2●Misc comment2.
MISC_COMMENT3●Misc comment3.
MISC_COMMENT4●Misc comment4.
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_FACTOR●Payroll factor.
PAYROLL_FREQUENCY_CODE●Code identifying the payroll frequency.
PERFORMANCE_RATING●Performance rating.
PERFORMANCE_REVIEW_ID●Identifier for the performance review.
PERSON_ID●Identifier for the person.
QUARTILE●Quartile.
QUINTILE●Quintile.
RANGE_ANALYTICS_FOR_EMP●Range analytics for emp.
RANGE_ANALYTICS_FOR_MGR●Range analytics for mgr.
RANGE_ERROR_WARNING●Range error warning.
RANGE_POSITION●Range position.
RANGE_POSITION_SCALE●Range position scale.
RANGE_ROUNDING_CODE●Code identifying the range rounding.
RATE_DEFAULT_AMOUNT●Rate default amount.
RATE_FACTOR●Rate factor.
RATE_ID●Identifier for the rate.
RATE_MAX_AMOUNT●Rate max amount.
RATE_MID_AMOUNT●Rate mid amount.
RATE_MIN_AMOUNT●Rate min amount.
REVIEW_DATE●Review date.
SALARY_AMOUNT●Salary amount.
SALARY_AMOUNT_SCALE●Salary amount scale.
SALARY_APPROVED●Salary approved.
SALARY_BASIS_CODE●Code identifying the salary basis.
SALARY_BASIS_ID●Identifier for the salary basis.
SALARY_BASIS_TYPE●Type of salary basis.
SALARY_FACTOR●Salary factor.
SALARY_IDPK?●Identifier for the salary.
SALARY_JUSTIFICATION●Salary justification.
SALARY_RANGE_SCALE●Salary range scale.
SALARY_REASON_CODE●Code identifying the salary reason.
SALARY_TRANSACTION_STATUS●Status of the salary transaction.
TOTAL_BASE_PAY●Total base pay.
TOTAL_COMPONENT_ADJ_AMT●Total component adj amount.
TOTAL_COMPONENT_ADJ_PERCENT●Total component adj percentage.
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?
We ship parameterized SQL, BICC config, and dbt models you own.
Talk to us
Problems that run through this table
What the extract does not carry · The export ceiling · The extraction pattern