[Home] [Help] [Dependency Information]
Object Name: | HRI_MD_SALARY_CMPNT_H_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Derived Metric for Salary Components which make up a Salary Change. Based on 'hri_md_salary_cmpnt_v'.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ANNUALIZED_CMPNT_CHANGE | NUMBER | |||
ANNUALIZED_TOTAL_CHANGE | NUMBER | |||
CMPNT_CHANGE | NUMBER | |||
TOTAL_CHANGE | NUMBER | |||
CMPNT_OF_TTL_CHANGE_PRCNT | NUMBER | |||
CMPNT_OF_PREV_SAL_PRCNT | NUMBER | |||
ANNUALIZED_SALARY | NUMBER | |||
PREV_ANNUALIZED_SALARY | NUMBER | |||
SALARY | NUMBER | |||
SALARY_CHANGE | NUMBER | |||
ANNUALIZATION_FACTOR | NUMBER | |||
DAYS_FROM_LAST_CHANGE | NUMBER | |||
EVENT_DATE | DATE | |||
PREV_EVENT_DATE | DATE | |||
ASSIGNMENT_ID | NUMBER | (10) | Yes | |
PERSON_ID | NUMBER | (10) | Yes | |
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | |
ORGANIZATION_ID | NUMBER | (15) | Yes | |
LOCATION_ID | NUMBER | |||
JOB_ID | NUMBER | |||
GRADE_ID | NUMBER | |||
POSITION_ID | NUMBER | |||
SUPERVISOR_PERSON_ID | NUMBER | |||
PAY_PROPOSAL_ID | NUMBER | |||
CURRENCY_CODE | VARCHAR2 | (15) | ||
OUTPUT_CURRENCY_CODE | VARCHAR2 | (15) | ||
PERF_RATING_CODE | VARCHAR2 | (30) | ||
MULTIPLE_CMPNT_FLAG_CODE | VARCHAR2 | (30) | ||
SALARY_CHANGE_REASON_CODE | VARCHAR2 | (30) | ||
SALARY_CMPNT_REASON_CODE | VARCHAR2 | (30) | ||
LAST_SALARY_FLAG_CODE | VARCHAR2 | (1) | ||
LAST_CHANGE_DATE | DATE | |||
ASG_LAST_UPDATE_DATE | DATE | |||
PRO_LAST_UPDATE_DATE | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT ANNUALIZED_CMPNT_CHANGE
, ANNUALIZED_TOTAL_CHANGE
, CMPNT_CHANGE
, TOTAL_CHANGE
, CMPNT_OF_TTL_CHANGE_PRCNT
, CMPNT_OF_PREV_SAL_PRCNT
, ANNUALIZED_SALARY
, PREV_ANNUALIZED_SALARY
, SALARY
, SALARY_CHANGE
, ANNUALIZATION_FACTOR
, DAYS_FROM_LAST_CHANGE
, EVENT_DATE
, PREV_EVENT_DATE
, ASSIGNMENT_ID
, PERSON_ID
, BUSINESS_GROUP_ID
, ORGANIZATION_ID
, LOCATION_ID
, JOB_ID
, GRADE_ID
, POSITION_ID
, SUPERVISOR_PERSON_ID
, PAY_PROPOSAL_ID
, CURRENCY_CODE
, OUTPUT_CURRENCY_CODE
, PERF_RATING_CODE
, MULTIPLE_CMPNT_FLAG_CODE
, SALARY_CHANGE_REASON_CODE
, SALARY_CMPNT_REASON_CODE
, LAST_SALARY_FLAG_CODE
, LAST_CHANGE_DATE
, ASG_LAST_UPDATE_DATE
, PRO_LAST_UPDATE_DATE
FROM APPS.HRI_MD_SALARY_CMPNT_H_V;
APPS.HRI_MD_SALARY_CMPNT_H_V is not referenced by any database object
|
|
|