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

VIEW: APPS.HRBV_SALARY_SURVEY_LINES_V

Object Details
Object Name: HRBV_SALARY_SURVEY_LINES_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


Salary survey liness (from PER_SALARY_SURVEY_LINES table).


[View Source]

Columns
Name Datatype Length Mandatory Comments
SURVEY_JOB_NAME_CODE VARCHAR2 (30) Yes (Lookup code based on lookup type SURVEY_JOB_NAME).
SURVEY_JOB_NAME_CODE_M VARCHAR2 (4000)
(Lookup meaning based on lookup type SURVEY_JOB_NAME).
SURVEY_REGION_CODE VARCHAR2 (30)
(Lookup code based on lookup type SURVEY_REGION).
SURVEY_REGION_CODE_M VARCHAR2 (4000)
(Lookup meaning based on lookup type SURVEY_REGION).
SURVEY_SENIORITY_CODE VARCHAR2 (30)
(Lookup code based on lookup type SURVEY_SENIORITY).
SURVEY_SENIORITY_CODE_M VARCHAR2 (4000)
(Lookup meaning based on lookup type SURVEY_SENIORITY).
COMPANY_SIZE_CODE VARCHAR2 (30)
(Lookup code based on lookup type COMPANY_SIZE).
COMPANY_SIZE_CODE_M VARCHAR2 (4000)
(Lookup meaning based on lookup type COMPANY_SIZE).
INDUSTRY_CODE VARCHAR2 (30)
(Lookup code based on lookup type INDUSTRY).
INDUSTRY_CODE_M VARCHAR2 (4000)
(Lookup meaning based on lookup type INDUSTRY).
SURVEY_AGE_CODE VARCHAR2 (30)
(Lookup code based on lookup type SURVEY_AGE).
SURVEY_AGE_CODE_M VARCHAR2 (4000)
(Lookup meaning based on lookup type SURVEY_AGE).
START_DATE DATE
Yes Start date.
END_DATE DATE

End date.
DIFFERENTIAL NUMBER

Differential.
CURRENCY_CODE VARCHAR2 (15)
Currency code.
MINIMUM_PAY NUMBER

Minimum pay.
MEAN_PAY NUMBER

Mean pay.
MAXIMUM_PAY NUMBER

Maximum pay.
GRADUATE_PAY NUMBER

Graduate pay.
STARTING_PAY NUMBER

Starting pay.
PERCENTAGE_CHANGE NUMBER

Percentage change.
JOB_FIRST_QUARTILE NUMBER

Job first quartile.
JOB_MEDIAN_QUARTILE NUMBER

Job median quartile.
JOB_THIRD_QUARTILE NUMBER

Job third quartile.
JOB_FOURTH_QUARTILE NUMBER

Job fourth quartile.
MINIMUM_TOTAL_COMPENSATION NUMBER

Minimum total compensation.
MEAN_TOTAL_COMPENSATION NUMBER

Mean total compensation.
MAXIMUM_TOTAL_COMPENSATION NUMBER

Maximum total compensation.
COMPNSTN_FIRST_QUARTILE NUMBER

Compensation first quartile.
COMPNSTN_MEDIAN_QUARTILE NUMBER

Compensation median quartile.
COMPNSTN_THIRD_QUARTILE NUMBER

Compensation third quartile.
COMPNSTN_FOURTH_QUARTILE NUMBER

Compensation fourth quartile.
_DF:SSL CHAR (35)
SALARY_SURVEY_ID NUMBER (15) Yes Foreign key to PER_SALARY_SURVEYS.
SALARY_SURVEY_LINE_ID NUMBER (15) Yes Primary key for PER_SALARY_SURVEY_LINES.
LAST_UPDATE_DATE DATE

Standard who column
LAST_UPDATED_BY NUMBER (15)
Standard who column
CREATED_BY NUMBER (15)
Standard who column
CREATION_DATE DATE

Standard who column
Query Text

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


SELECT SURVEY_JOB_NAME_CODE
,      SURVEY_JOB_NAME_CODE_M
,      SURVEY_REGION_CODE
,      SURVEY_REGION_CODE_M
,      SURVEY_SENIORITY_CODE
,      SURVEY_SENIORITY_CODE_M
,      COMPANY_SIZE_CODE
,      COMPANY_SIZE_CODE_M
,      INDUSTRY_CODE
,      INDUSTRY_CODE_M
,      SURVEY_AGE_CODE
,      SURVEY_AGE_CODE_M
,      START_DATE
,      END_DATE
,      DIFFERENTIAL
,      CURRENCY_CODE
,      MINIMUM_PAY
,      MEAN_PAY
,      MAXIMUM_PAY
,      GRADUATE_PAY
,      STARTING_PAY
,      PERCENTAGE_CHANGE
,      JOB_FIRST_QUARTILE
,      JOB_MEDIAN_QUARTILE
,      JOB_THIRD_QUARTILE
,      JOB_FOURTH_QUARTILE
,      MINIMUM_TOTAL_COMPENSATION
,      MEAN_TOTAL_COMPENSATION
,      MAXIMUM_TOTAL_COMPENSATION
,      COMPNSTN_FIRST_QUARTILE
,      COMPNSTN_MEDIAN_QUARTILE
,      COMPNSTN_THIRD_QUARTILE
,      COMPNSTN_FOURTH_QUARTILE
,      _DF:SSL
,      SALARY_SURVEY_ID
,      SALARY_SURVEY_LINE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
FROM APPS.HRBV_SALARY_SURVEY_LINES_V;

Dependencies

[top of page]

APPS.HRBV_SALARY_SURVEY_LINES_V references the following:

SchemaAPPS
PL/SQL PackageHR_BIS - show dependent code
SynonymPER_SALARY_SURVEY_LINES

APPS.HRBV_SALARY_SURVEY_LINES_V is not referenced by any database object