[Home] [Help] [Dependency Information]

VIEW: APPS.HRI_MD_SAL_GRDRT_X_V

Object Details

View Type

A Business Intelligence System view

Derived Metric for Salary and Grade Rate, based on ' hri_mb_salary_v',' hri_mb_grade_rate_v'.

[View Source]

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

SELECT ROW_INDICATOR
,      ANNUALIZED_SALARY
,      GRDRT_CONVERTED_ANNUAL_SAL
,      SALARY
,      SALARY_ANNUALIZATION_FACTOR
,      ANNUALIZED_GRADE_MAX
,      ANNUALIZED_GRADE_MID
,      ANNUALIZED_GRADE_MIN
,      GRADE_SALARY_COMPARATIO
,      GRADE_MAX
,      GRADE_MID
,      GRADE_MIN
,      GRADE_ANNUALIZATION_FACTOR
,      ABOVE_MAX_INDICATOR
,      BELOW_MAX_INDICATOR
,      ABOVE_MID_INDICATOR
,      BELOW_MID_INDICATOR
,      ABOVE_MIN_INDICATOR
,      BELOW_MIN_INDICATOR
,      MIN_TO_MID_INDICATOR
,      MID_TO_MAX_INDICATOR
,      SALARY_TO_MIN_RATIO
,      SALARY_TO_MID_RATIO
,      SALARY_TO_MAX_RATIO
,      SALARY_TO_MIN_RATIO_PCT
,      SALARY_TO_MID_RATIO_PCT
,      SALARY_TO_MAX_RATIO_PCT
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      ASSIGNMENT_ID
,      PERSON_ID
,      BUSINESS_GROUP_ID
,      ORGANIZATION_ID
,      LOCATION_ID
,      JOB_ID
,      GRADE_ID
,      POSITION_ID
,      SUPERVISOR_PERSON_ID
,      PAY_PROPOSAL_ID
,      ASSIGNMENT_TYPE_CODE
,      CURRENCY_CODE
,      OUTPUT_CURRENCY_CODE
,      GRADE_CURRENCY_CODE
,      GRDRATE_OUTPUT_CURRENCY_CODE
,      GRADE_RULE_CURRENCY_CODE
,      PERFORMANCE_RATING_CODE
,      MULTIPLE_COMPONENT_FLAG_CODE
,      PROPOSAL_REASON_CODE
,      LAST_SALARY_FLAG_CODE
,      GRADE_RULE_ID
,      RATE_ID
,      LAST_CHANGE_DATE
,      ASG_LAST_UPDATE_DATE
,      PRO_LAST_UPDATE_DATE
,      GRL_LAST_UPDATE_DATE
FROM APPS.HRI_MD_SAL_GRDRT_X_V;

Dependencies

[top of page]

APPS

HRI_BPL_CURRENCY - show dependent code

HRI_MB_GRADE_RATE_V

HRI_MB_SALARY_V

HR_CURRENCY_PKG - show dependent code

HR_GENERAL - show dependent code

APPS

HRI_MD_SAL_GRDRT_HX_V