DBA Data[Home] [Help] [Dependency Information]

TABLE: HR.PER_CHANGE_PAY_ANALYTICS

Object Details
Object Name: PER_CHANGE_PAY_ANALYTICS
Object Type: TABLE
Owner: HR
Subobject Name:
Status: VALID


Change Pay Analytics


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
EFFECTIVE_START_DATE DATE

Effective start date.
EFFECTIVE_END_DATE DATE

Effective end date.
JOB_ID NUMBER (15)
Foreign key to PER_JOBS.
COUNTRY VARCHAR2 (60)
Country picked up from HR_LOCATIONS_ALL.
PAY_BASIS_ID NUMBER (9)
Foreign key to PER_PAY_BASES.
SUPERVISOR_ID NUMBER (15)
Foreign key to PER_PEOPLE.
TOTAL_HEADCOUNT NUMBER

Assignment budget value of an applicant.
MED_ANL_SLRY NUMBER

Median of Annual Salary.
ANL_SLRY_CURRENCY VARCHAR2 (15)
Currency identifier from PAY_GRADE_RULES_F.
COMPARATIO NUMBER

A statistic used to compare salary against a market value or mid point.Ratio of Salary to Grade Mid Value.
RANGE_POSITION NUMBER

Used to determine at a glance where a salary is in the range on the grade rate.Ratio of (Salary-Grade Min) to (Grade Max-Grade min).
QUARTILE NUMBER

The median point divides the Salary Range into two parts, whereas the quartile specifies one of four parts.
Query Text

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


SELECT EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      JOB_ID
,      COUNTRY
,      PAY_BASIS_ID
,      SUPERVISOR_ID
,      TOTAL_HEADCOUNT
,      MED_ANL_SLRY
,      ANL_SLRY_CURRENCY
,      COMPARATIO
,      RANGE_POSITION
,      QUARTILE
FROM HR.PER_CHANGE_PAY_ANALYTICS;

Dependencies

[top of page]

HR.PER_CHANGE_PAY_ANALYTICS does not reference any database object

HR.PER_CHANGE_PAY_ANALYTICS is referenced by following:

SchemaHR
ViewPER_CHANGE_PAY_ANALYTICS#