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


TABLE: HR.PQP_SERVICE_HISTORY_PERIODS

Object Details
Object Name: PQP_SERVICE_HISTORY_PERIODS
Object Type: TABLE
Owner: HR
FND Design Data: TablePQP.PQP_SERVICE_HISTORY_PERIODS
Subobject Name:
Status: VALID


PQP_SERVICE_HISTORY_PERIODS is the table that holds information relating to any relevant periods of previous employment that a person may have had. Information held includes details on the employer, when the period of employment began and ended, and whether or not it was continuous.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: PQP_SERVICE_HISTORY_PERIODS_PK
  1. ColumnSERVICE_HISTORY_PERIOD_ID
Indexes
Index Type Uniqueness Tablespace Column
PQP_SERVICE_HISTORY_PERIODS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSERVICE_HISTORY_PERIOD_ID
Columns
Name Datatype Length Mandatory Comments
SERVICE_HISTORY_PERIOD_ID NUMBER (15) Yes System generated primary key
BUSINESS_GROUP_ID NUMBER (15) Yes Foreign key to HR_ORGANIZATION_UNITS
ASSIGNMENT_ID NUMBER (15) Yes Foreign key to PER_ASSIGNMENTS_F
START_DATE DATE

Start Date of period of employment history
END_DATE DATE

End date of period of employment history
EMPLOYER_NAME VARCHAR2 (80)
Name of employer
EMPLOYER_ADDRESS VARCHAR2 (240)
Address of employer
EMPLOYER_TYPE VARCHAR2 (80)
Type of employer
EMPLOYER_SUBTYPE VARCHAR2 (80)
Subtype of employer
PERIOD_YEARS NUMBER (15)
Total number of years employed
PERIOD_DAYS NUMBER (15)
Total number of days employed after years have been subtracted
DESCRIPTION VARCHAR2 (240)
Optional description
CONTINUOUS_SERVICE VARCHAR2 (240)
Indicates whether row should be considered as continuous service
ALL_ASSIGNMENTS VARCHAR2 (30)
Indicates whether row applies to all assignments
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
OBJECT_VERSION_NUMBER NUMBER (15) Yes System generated version of row. Increments by one with each update
SHP_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield column
SHP_ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield column
SHP_ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield column
SHP_ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield column
SHP_ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield column
SHP_ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield column
SHP_ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield column
SHP_ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield column
SHP_ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield column
SHP_ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield column
SHP_ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield column
SHP_ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield column
SHP_ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield column
SHP_ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield column
SHP_ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield column
SHP_ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield column
SHP_ATTRIBUTE16 VARCHAR2 (150)
Descriptive flexfield column
SHP_ATTRIBUTE17 VARCHAR2 (150)
Descriptive flexfield column
SHP_ATTRIBUTE18 VARCHAR2 (150)
Descriptive flexfield column
SHP_ATTRIBUTE19 VARCHAR2 (150)
Descriptive flexfield column
SHP_ATTRIBUTE20 VARCHAR2 (150)
Descriptive flexfield column
SHP_INFORMATION_CATEGORY VARCHAR2 (30)
Developer descriptive flexfield column
SHP_INFORMATION1 VARCHAR2 (150)
Developer descriptive flexfield column
SHP_INFORMATION2 VARCHAR2 (150)
Developer descriptive flexfield column
SHP_INFORMATION3 VARCHAR2 (150)
Developer descriptive flexfield column
SHP_INFORMATION4 VARCHAR2 (150)
Developer descriptive flexfield column
SHP_INFORMATION5 VARCHAR2 (150)
Developer descriptive flexfield column
SHP_INFORMATION6 VARCHAR2 (150)
Developer descriptive flexfield column
SHP_INFORMATION7 VARCHAR2 (150)
Developer descriptive flexfield column
SHP_INFORMATION8 VARCHAR2 (150)
Developer descriptive flexfield column
SHP_INFORMATION9 VARCHAR2 (150)
Developer descriptive flexfield column
SHP_INFORMATION10 VARCHAR2 (150)
Developer descriptive flexfield column
SHP_INFORMATION11 VARCHAR2 (150)
Developer descriptive flexfield column
SHP_INFORMATION12 VARCHAR2 (150)
Developer descriptive flexfield column
SHP_INFORMATION13 VARCHAR2 (150)
Developer descriptive flexfield column
SHP_INFORMATION14 VARCHAR2 (150)
Developer descriptive flexfield column
SHP_INFORMATION15 VARCHAR2 (150)
Developer descriptive flexfield column
SHP_INFORMATION16 VARCHAR2 (150)
Developer descriptive flexfield column
SHP_INFORMATION17 VARCHAR2 (150)
Developer descriptive flexfield column
SHP_INFORMATION18 VARCHAR2 (150)
Developer descriptive flexfield column
SHP_INFORMATION19 VARCHAR2 (150)
Developer descriptive flexfield column
SHP_INFORMATION20 VARCHAR2 (150)
Developer descriptive flexfield column
Query Text

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


SELECT SERVICE_HISTORY_PERIOD_ID
,      BUSINESS_GROUP_ID
,      ASSIGNMENT_ID
,      START_DATE
,      END_DATE
,      EMPLOYER_NAME
,      EMPLOYER_ADDRESS
,      EMPLOYER_TYPE
,      EMPLOYER_SUBTYPE
,      PERIOD_YEARS
,      PERIOD_DAYS
,      DESCRIPTION
,      CONTINUOUS_SERVICE
,      ALL_ASSIGNMENTS
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      OBJECT_VERSION_NUMBER
,      SHP_ATTRIBUTE_CATEGORY
,      SHP_ATTRIBUTE1
,      SHP_ATTRIBUTE2
,      SHP_ATTRIBUTE3
,      SHP_ATTRIBUTE4
,      SHP_ATTRIBUTE5
,      SHP_ATTRIBUTE6
,      SHP_ATTRIBUTE7
,      SHP_ATTRIBUTE8
,      SHP_ATTRIBUTE9
,      SHP_ATTRIBUTE10
,      SHP_ATTRIBUTE11
,      SHP_ATTRIBUTE12
,      SHP_ATTRIBUTE13
,      SHP_ATTRIBUTE14
,      SHP_ATTRIBUTE15
,      SHP_ATTRIBUTE16
,      SHP_ATTRIBUTE17
,      SHP_ATTRIBUTE18
,      SHP_ATTRIBUTE19
,      SHP_ATTRIBUTE20
,      SHP_INFORMATION_CATEGORY
,      SHP_INFORMATION1
,      SHP_INFORMATION2
,      SHP_INFORMATION3
,      SHP_INFORMATION4
,      SHP_INFORMATION5
,      SHP_INFORMATION6
,      SHP_INFORMATION7
,      SHP_INFORMATION8
,      SHP_INFORMATION9
,      SHP_INFORMATION10
,      SHP_INFORMATION11
,      SHP_INFORMATION12
,      SHP_INFORMATION13
,      SHP_INFORMATION14
,      SHP_INFORMATION15
,      SHP_INFORMATION16
,      SHP_INFORMATION17
,      SHP_INFORMATION18
,      SHP_INFORMATION19
,      SHP_INFORMATION20
FROM HR.PQP_SERVICE_HISTORY_PERIODS;

Dependencies

[top of page]

HR.PQP_SERVICE_HISTORY_PERIODS does not reference any database object

HR.PQP_SERVICE_HISTORY_PERIODS is referenced by following:

SchemaAPPS
SynonymPQP_SERVICE_HISTORY_PERIODS
TriggerPQP_SERVICE_HISTORY_PERIOD_WHO
SchemaPUBLIC
SynonymPQP_SERVICE_HISTORY_PERIODS