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

CMP_CWB_PERSON_INFO_V

CompensationUsed in 0 subject areas170 reporting columnsBICC incremental-ready

Compensation (CMP), denormalized view.

Primary key: not yet catalogued for CMP_CWB_PERSON_INFO_V, reference Oracle Tables & Views guide. · Incremental key: LAST_UPDATE_DATE
Joins (inferred from key columns): ACTION_REASON_ID → PER_ACTION_REASONS_B · LEGAL_ENTITY_ID → XLE_ENTITY_PROFILES · ORGANIZATION_ID → INV_ORGANIZATION_DEFINITIONS_V

Columns

ColumnKeyIn reportsDescription (inferred)
ACCESS_CODE●Code identifying the access.
ACTION_REASON_ID●Identifier for the action reason.
ADJUSTED_CHANGE_AMOUNT●Adjusted change amount.
ADJUSTED_SALARY_CURRENT●Adjusted salary current.
ADJUSTED_SALARY_NEW●Adjusted salary new.
ADJUSTED_SVC_DATE●Adjusted svc date.
ADJUSTMENT_FACTOR●Adjustment factor.
APPROVAL_CODE●Code identifying the approval.
APPROVAL_DATE●Approval date.
ASSIGNMENT_ASSIGNMENT_ID●Identifier for the assignment assignment.
ASSIGNMENT_CHANGE_DATE●Assignment change date.
ASSIGNMENT_ID●Identifier for the assignment.
ASSIGNMENT_NAME●Name of the assignment.
ASSIGNMENT_POSTED_DATE●Assignment posted date.
ASSIGNMENT_POSTING_DATE●Assignment posting date.
ASSIGNMENT_STATUS_TYPE_ID●Identifier for the assignment status type.
BASE_SALARY●Base salary.
BASE_SALARY_CHANGE_DATE●Base salary change date.
BASE_SALARY_CHANGE_VAL●Base salary change val.
BASE_SALARY_CURRENCY●Base salary currency.
BASE_SALARY_FREQUENCY●Base salary frequency.
BUSINESS_GROUP_ID●Identifier for the business group.
BUSINESS_UNIT_ID●Identifier for the business unit.
CUSTOM_SEGMENT1●Custom segment1.
CUSTOM_SEGMENT10●Custom segment10.
CUSTOM_SEGMENT11●Custom segment11.
CUSTOM_SEGMENT12●Custom segment12.
CUSTOM_SEGMENT13●Custom segment13.
CUSTOM_SEGMENT14●Custom segment14.
CUSTOM_SEGMENT15●Custom segment15.
CUSTOM_SEGMENT16●Custom segment16.
CUSTOM_SEGMENT17●Custom segment17.
CUSTOM_SEGMENT18●Custom segment18.
CUSTOM_SEGMENT19●Custom segment19.
CUSTOM_SEGMENT2●Custom segment2.
CUSTOM_SEGMENT20●Custom segment20.
CUSTOM_SEGMENT21●Custom segment21.
CUSTOM_SEGMENT22●Custom segment22.
CUSTOM_SEGMENT23●Custom segment23.
CUSTOM_SEGMENT24●Custom segment24.
CUSTOM_SEGMENT25●Custom segment25.
CUSTOM_SEGMENT26●Custom segment26.
CUSTOM_SEGMENT27●Custom segment27.
CUSTOM_SEGMENT28●Custom segment28.
CUSTOM_SEGMENT29●Custom segment29.
CUSTOM_SEGMENT3●Custom segment3.
CUSTOM_SEGMENT30●Custom segment30.
CUSTOM_SEGMENT31●Custom segment31.
CUSTOM_SEGMENT32●Custom segment32.
CUSTOM_SEGMENT33●Custom segment33.
CUSTOM_SEGMENT34●Custom segment34.
CUSTOM_SEGMENT35●Custom segment35.
CUSTOM_SEGMENT36●Custom segment36.
CUSTOM_SEGMENT37●Custom segment37.
CUSTOM_SEGMENT38●Custom segment38.
CUSTOM_SEGMENT39●Custom segment39.
CUSTOM_SEGMENT4●Custom segment4.
CUSTOM_SEGMENT40●Custom segment40.
CUSTOM_SEGMENT41●Custom segment41.
CUSTOM_SEGMENT42●Custom segment42.
CUSTOM_SEGMENT43●Custom segment43.
CUSTOM_SEGMENT44●Custom segment44.
CUSTOM_SEGMENT45●Custom segment45.
CUSTOM_SEGMENT46●Custom segment46.
CUSTOM_SEGMENT47●Custom segment47.
CUSTOM_SEGMENT48●Custom segment48.
CUSTOM_SEGMENT49●Custom segment49.
CUSTOM_SEGMENT5●Custom segment5.
CUSTOM_SEGMENT50●Custom segment50.
CUSTOM_SEGMENT6●Custom segment6.
CUSTOM_SEGMENT7●Custom segment7.
CUSTOM_SEGMENT8●Custom segment8.
CUSTOM_SEGMENT9●Custom segment9.
DATE_OF_BIRTH●Date of birth.
DISABILITY_STATUS●Status of the disability.
DO_NOT_POST_FLAG●Indicator (Y/N) for the do not post.
DUE_DATE●Due date.
EFFECTIVE_DATE●Effective date.
EMAIL_ADDRESS●Email address.
EMPLOYMENT_CATEGORY●Employment category.
EMP_STATUS_CODE●Code identifying the emp status.
ETHNICITY●Ethnicity.
FREQUENCY●Frequency.
FTE_ANNUALIZATION_FACTOR●Fte annualization factor.
FTE_ANNUAL_CHANGE_AMT●Fte annual change amount.
FTE_ANNUAL_SALARY_CURRENT●Fte annual salary current.
FTE_ANNUAL_SALARY_NEW●Fte annual salary new.
FTE_FACTOR●Fte factor.
GRADE_ANNUALIZATION_FACTOR●Grade annualization factor.
GRADE_ATTRIBUTE1●Grade attribute1.
GRADE_ATTRIBUTE2●Grade attribute2.
GRADE_ATTRIBUTE3●Grade attribute3.
GRADE_CHANGE_DATE●Grade change date.
GRADE_COMPARATIO●Grade comparatio.
GRADE_DECILE●Grade decile.
GRADE_ID●Identifier for the grade.
GRADE_MAX_VAL●Grade max val.
GRADE_MID_POINT●Grade mid point.
GRADE_MIN_VAL●Grade min val.
GRADE_PCT_IN_RANGE●Grade percent in range.
GRADE_QUARTILE●Grade quartile.
GRADE_QUINTILE●Grade quintile.
GRADE_RATE_ID●Identifier for the grade rate.
JOB_ATTRIBUTE1●Job attribute1.
JOB_ATTRIBUTE2●Job attribute2.
JOB_ATTRIBUTE3●Job attribute3.
JOB_ATTRIBUTE4●Job attribute4.
JOB_ATTRIBUTE5●Job attribute5.
JOB_ATTRIBUTE6●Job attribute6.
JOB_CHANGE_DATE●Job change date.
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).
LEGAL_ENTITY_ID●Identifier of the legal entity.
LEGISLATION_CODE●Code identifying the legislation.
LOCATION_ID●Identifier for the location.
MGR_OVERRIDE_DATE●Mgr override date.
MGR_OVERRIDE_PERSON_ID●Identifier for the mgr override person.
MGR_STATUS_CODE●Code identifying the mgr status.
NATIONALITY●Nationality.
NEW_BASE_SALARY●New base salary.
NEW_GRADE_COMPARATIO●New grade comparatio.
NEW_GRADE_DECILE●New grade decile.
NEW_GRADE_PCT_IN_RANGE●New grade percent in range.
NEW_GRADE_QUARTILE●New grade quartile.
NEW_GRADE_QUINTILE●New grade quintile.
NON_DISCRIMINATION_CODE●Code identifying the non discrimination.
NORMAL_HOURS●Normal hours.
ORGANIZATION_ID●Identifier for the organization.
ORIGINAL_START_DATE●Original start date.
PAYROLL_ID●Identifier for the payroll.
PAY_ANNUALIZATION_FACTOR●Pay annualization factor.
PERFORMANCE_DATE●Performance date.
PERFORMANCE_RATING●Performance rating.
PERFORMANCE_RATING_DATE●Performance rating date.
PERFORMANCE_RATING_TYPE●Type of performance rating.
PERIOD_COMP_TYPE●Type of period comp.
PERIOD_ID●Identifier for the period.
PERSON_EVENT_ID●Identifier for the person event.
PERSON_ID●Identifier for the person.
PLACEHOLDER_FLAG●Indicator (Y/N) for the placeholder.
PLAN_ID●Identifier for the plan.
PLAN_PERIOD_ID●Identifier for the plan period.
POSITION_CHANGE_DATE●Position change date.
POSITION_ID●Identifier for the position.
PRIOR_SALARY●Prior salary.
PRIOR_SALARY_CHG_PCT●Prior salary chg percent.
RELIGION●Religion.
RISK_OF_LOSS●Risk of loss.
RVW_MGR_PERSON_ID●Identifier for the rvw mgr person.
SALARY_BASIS_ID●Identifier for the salary basis.
SEC_MGR_PERSON_ID●Identifier for the sec mgr person.
SEX●Sex.
START_DATE●Start date.
SUBMIT_DATE●Submit date.
SUPERVISOR_ID●Identifier for the supervisor.
USER_PREFERRED_EXCHANGE_RATE●User preferred exchange rate.
VETERAN_STATUS●Status of the veteran.
WORKER_NUMBER●Worker number.
WORKER_POTENTIAL●Worker potential.
WORKING_HOURS●Working hours.
WORK_TELEPHONE●Work telephone.
WS_MGR_ASSIGNMENT_ID●Identifier for the ws mgr assignment.
WS_MGR_PERSON_EVENT_ID●Identifier for the ws mgr person event.
WS_MGR_PERSON_ID●Identifier for the ws mgr person.
XCHG_RATE●Xchg rate.
YEARS_EMPLOYED●Years employed.
YEARS_IN_GRADE●Years in grade.
YEARS_IN_JOB●Years in job.
YEARS_IN_POSITION●Years in position.

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_CWB_PERSON_INFO_V?
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