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

TABLE: HR.PER_SALARY_SURVEYS

Object Details
Object Name: PER_SALARY_SURVEYS
Object Type: TABLE
Owner: HR
FND Design Data: TablePER.PER_SALARY_SURVEYS
Subobject Name:
Status: VALID


PER_SALARY_SURVEYS holds market salary survey information.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: PER_SALARY_SURVEYS_PK
  1. ColumnSALARY_SURVEY_ID
Unique Key: PER_SALARY_SURVEYS_UK1
  1. ColumnSURVEY_COMPANY_CODE
  2. ColumnSURVEY_NAME
Indexes
Index Type Uniqueness Tablespace Column
PER_SALARY_SURVEYS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSALARY_SURVEY_ID
PER_SALARY_SURVEYS_UK1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSURVEY_COMPANY_CODE
ColumnSURVEY_NAME
Foreign Keys
Table
Foreign Table Foreign Key Column
TablePER_SALARY_SURVEY_LINES PER_SALARY_SURVEY_LINES_FK1 PER_SALARY_SURVEYS PER_SALARY_SURVEY_LINES SALARY_SURVEY_ID
Columns
Name Datatype Length Mandatory Comments
OBJECT_VERSION_NUMBER NUMBER (9) Yes System-generated version of row. Increments by one with each update.
SALARY_SURVEY_ID NUMBER (15) Yes System-generated primary key.
SURVEY_NAME VARCHAR2 (255) Yes The name of the survey.
SURVEY_COMPANY_CODE VARCHAR2 (30) Yes Code for the name of the company that this survey applies to.
IDENTIFIER VARCHAR2 (2) Yes Two letter abbreviation used to restrict mapping of specified survey values to company values.
SURVEY_TYPE_CODE VARCHAR2 (30)
Code to indicate if the survey is based on Annual, Monthly, Hourly, or Period salary.
BASE_REGION VARCHAR2 (30)
An information flag to denote if there is a regional or national average.
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE16 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE17 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE18 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE19 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE20 VARCHAR2 (150)
Descriptive flexfield column.
LAST_UPDATE_DATE DATE

Standard Who column.
LAST_UPDATED_BY NUMBER (15)
Standard Who column.
LAST_UPDATE_LOGIN 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 OBJECT_VERSION_NUMBER
,      SALARY_SURVEY_ID
,      SURVEY_NAME
,      SURVEY_COMPANY_CODE
,      IDENTIFIER
,      SURVEY_TYPE_CODE
,      BASE_REGION
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM HR.PER_SALARY_SURVEYS;

Dependencies

[top of page]

HR.PER_SALARY_SURVEYS does not reference any database object

HR.PER_SALARY_SURVEYS is referenced by following:

SchemaHR
ViewPER_SALARY_SURVEYS#