eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: HR.PER_PERIODS_OF_SERVICE

Object Details

Object Name:	PER_PERIODS_OF_SERVICE
Object Type:	TABLE
Owner:	HR
FND Design Data:	PER.PER_PERIODS_OF_SERVICE
Subobject Name:
Status:	VALID

PER_PERIODS_OF_SERVICE holds the period of service, or employment,
information for an employee. This includes the boundary dates for
each period of service. A person may have more than one period of
service, in sequence but they cannot overlap. For example, if the
employee is terminated and is later re-hired there will two periods of
service. Each period of service will have a hire date, DATE_START,
and if terminated a termination date, ACTUAL_TERMINATION_DATE. The
default length of service calculation is the difference between the
DATE_START of the current period of service and the current system
date.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PER_PERIODS_OF_SERVICE_PK

PERIOD_OF_SERVICE_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
PER_PERIODS_OF_SERVICE_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	PERIOD_OF_SERVICE_ID
SYS_IL0000043959C00078$$	LOB	UNIQUE	APPS_TS_TX_DATA
PER_PERIODS_OF_SERVICE_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BUSINESS_GROUP_ID
PER_PERIODS_OF_SERVICE_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TERMINATION_ACCEPTED_PERSON_ID
PER_PERIODS_OF_SERVICE_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PERSON_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
PER_PERIODS_OF_SERVICE		HR_ALL_ORGANIZATION_UNITS	PER_PERIODS_OF_SERVICE BUSINESS_GROUP_ID
PER_ALL_ASSIGNMENTS_F		PER_PERIODS_OF_SERVICE	PER_ALL_ASSIGNMENTS_F PERIOD_OF_SERVICE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PERIOD_OF_SERVICE_ID	NUMBER	(9)	Yes	System generated period of service primary key from PER_PERIODS_OF_SERVICE_S.
BUSINESS_GROUP_ID	NUMBER	(15)	Yes	Foreign key to HR_ORGANIZATION_UNITS.
TERMINATION_ACCEPTED_PERSON_ID	NUMBER	(10)		Foreign key to PER_PEOPLE. Person who accepted or authorized employee termination.
PERSON_ID	NUMBER	(10)	Yes	Foreign key to PER_PEOPLE.
DATE_START	DATE		Yes	Start date of the period of employment.
ACCEPTED_TERMINATION_DATE	DATE			Date when termination of employment was accepted.
ACTUAL_TERMINATION_DATE	DATE			Actual date of termination of employment.
FINAL_PROCESS_DATE	DATE			Final date for all payroll processing of this person.
LAST_STANDARD_PROCESS_DATE	DATE			Last date for including the person in any standard payroll processing.
LEAVING_REASON	VARCHAR2	(30)		Reason for termination of employment.
NOTIFIED_TERMINATION_DATE	DATE			Date when the termination of employment was noted.
PROJECTED_TERMINATION_DATE	DATE			Projected employment termination date, used for information only.
ADJUSTED_SVC_DATE	DATE			Previous date of hire.
REQUEST_ID	NUMBER	(15)		Standard Who Column.
PROGRAM_APPLICATION_ID	NUMBER	(15)		Standard Who column.
PROGRAM_ID	NUMBER	(15)		Standard Who Column.
PROGRAM_UPDATE_DATE	DATE			Standard Who column.
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.
OBJECT_VERSION_NUMBER	NUMBER	(9)		System-generated version of row. Increments by one with each update.
PRIOR_EMPLOYMENT_SSP_PAID_TO	DATE			Date SSP paid to in prior employment. (UK specific).
PRIOR_EMPLOYMENT_SSP_WEEKS	NUMBER			Number of weeks SSP paid for in prior employment. (UK specific).
PDS_INFORMATION_CATEGORY	VARCHAR2	(30)		Developer descriptive flexfield structure defining column.
PDS_INFORMATION1	VARCHAR2	(150)		Developer descriptive flexfield column.
PDS_INFORMATION2	VARCHAR2	(150)		Developer descriptive flexfield column.
PDS_INFORMATION3	VARCHAR2	(150)		Developer descriptive flexfield column.
PDS_INFORMATION4	VARCHAR2	(150)		Developer descriptive flexfield column.
PDS_INFORMATION5	VARCHAR2	(150)		Developer descriptive flexfield column.
PDS_INFORMATION6	VARCHAR2	(150)		Developer descriptive flexfield column.
PDS_INFORMATION7	VARCHAR2	(150)		Developer descriptive flexfield column.
PDS_INFORMATION8	VARCHAR2	(150)		Developer descriptive flexfield column.
PDS_INFORMATION9	VARCHAR2	(150)		Developer descriptive flexfield column.
PDS_INFORMATION10	VARCHAR2	(150)		Developer descriptive flexfield column.
PDS_INFORMATION11	VARCHAR2	(150)		Developer descriptive flexfield column.
PDS_INFORMATION12	VARCHAR2	(150)		Developer descriptive flexfield column.
PDS_INFORMATION13	VARCHAR2	(150)		Developer descriptive flexfield column.
PDS_INFORMATION14	VARCHAR2	(150)		Developer descriptive flexfield column.
PDS_INFORMATION15	VARCHAR2	(150)		Developer descriptive flexfield column.
PDS_INFORMATION16	VARCHAR2	(150)		Developer descriptive flexfield column.
PDS_INFORMATION17	VARCHAR2	(150)		Developer descriptive flexfield column.
PDS_INFORMATION18	VARCHAR2	(150)		Developer descriptive flexfield column.
PDS_INFORMATION19	VARCHAR2	(150)		Developer descriptive flexfield column.
PDS_INFORMATION20	VARCHAR2	(150)		Developer descriptive flexfield column.
PDS_INFORMATION21	VARCHAR2	(150)		Developer descriptive flexfield column.
PDS_INFORMATION22	VARCHAR2	(150)		Developer descriptive flexfield column.
PDS_INFORMATION23	VARCHAR2	(150)		Developer descriptive flexfield column.
PDS_INFORMATION24	VARCHAR2	(150)		Developer descriptive flexfield column.
PDS_INFORMATION25	VARCHAR2	(150)		Developer descriptive flexfield column.
PDS_INFORMATION26	VARCHAR2	(150)		Developer descriptive flexfield column.
PDS_INFORMATION27	VARCHAR2	(150)		Developer descriptive flexfield column.
PDS_INFORMATION28	VARCHAR2	(150)		Developer descriptive flexfield column.
PDS_INFORMATION29	VARCHAR2	(150)		Developer descriptive flexfield column.
PDS_INFORMATION30	VARCHAR2	(150)		Developer descriptive flexfield column.
COMMENTS	CLOB	(4000)		General remark.

Query Text

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


SELECT PERIOD_OF_SERVICE_ID
,      BUSINESS_GROUP_ID
,      TERMINATION_ACCEPTED_PERSON_ID
,      PERSON_ID
,      DATE_START
,      ACCEPTED_TERMINATION_DATE
,      ACTUAL_TERMINATION_DATE
,      FINAL_PROCESS_DATE
,      LAST_STANDARD_PROCESS_DATE
,      LEAVING_REASON
,      NOTIFIED_TERMINATION_DATE
,      PROJECTED_TERMINATION_DATE
,      ADJUSTED_SVC_DATE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      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
,      OBJECT_VERSION_NUMBER
,      PRIOR_EMPLOYMENT_SSP_PAID_TO
,      PRIOR_EMPLOYMENT_SSP_WEEKS
,      PDS_INFORMATION_CATEGORY
,      PDS_INFORMATION1
,      PDS_INFORMATION2
,      PDS_INFORMATION3
,      PDS_INFORMATION4
,      PDS_INFORMATION5
,      PDS_INFORMATION6
,      PDS_INFORMATION7
,      PDS_INFORMATION8
,      PDS_INFORMATION9
,      PDS_INFORMATION10
,      PDS_INFORMATION11
,      PDS_INFORMATION12
,      PDS_INFORMATION13
,      PDS_INFORMATION14
,      PDS_INFORMATION15
,      PDS_INFORMATION16
,      PDS_INFORMATION17
,      PDS_INFORMATION18
,      PDS_INFORMATION19
,      PDS_INFORMATION20
,      PDS_INFORMATION21
,      PDS_INFORMATION22
,      PDS_INFORMATION23
,      PDS_INFORMATION24
,      PDS_INFORMATION25
,      PDS_INFORMATION26
,      PDS_INFORMATION27
,      PDS_INFORMATION28
,      PDS_INFORMATION29
,      PDS_INFORMATION30
,      COMMENTS
FROM HR.PER_PERIODS_OF_SERVICE;

Dependencies

[top of page]

HR.PER_PERIODS_OF_SERVICE does not reference any database object

HR.PER_PERIODS_OF_SERVICE is referenced by following:

HR: PER_PERIODS_OF_SERVICE#