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]

VIEW: APPS.PER_PERIODS_OF_PLACEMENT_V

Object Details

Object Name:	PER_PERIODS_OF_PLACEMENT_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PER.PER_PERIODS_OF_PLACEMENT_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PERIOD_OF_PLACEMENT_ID	NUMBER	(15)	Yes	period of placement identifier
OBJECT_VERSION_NUMBER	NUMBER	(15)	Yes	system generated version of row. Incremented with each update.
BUSINESS_GROUP_ID	NUMBER	(15)	Yes	Foreign key to hr_organization_units
PERSON_ID	NUMBER	(10)	Yes	Foreign key to per_all_people_f
DATE_START	DATE		Yes	Start date of period of placement
ACTUAL_TERMINATION_DATE	DATE			Actual date of termination of period of placement
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.
PROJECTED_TERMINATION_DATE	DATE			Projected date of termination of period of placement. For information.
TERMINATION_REASON	VARCHAR2	(30)		Reason for terminating placement
D_TERMINATION_REASON	VARCHAR2	(4000)		Termination description
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
ATTRIBUTE21	VARCHAR2	(150)		Descriptive flexfield column
ATTRIBUTE22	VARCHAR2	(150)		Descriptive flexfield column
ATTRIBUTE23	VARCHAR2	(150)		Descriptive flexfield column
ATTRIBUTE24	VARCHAR2	(150)		Descriptive flexfield column
ATTRIBUTE25	VARCHAR2	(150)		Descriptive flexfield column
ATTRIBUTE26	VARCHAR2	(150)		Descriptive flexfield column
ATTRIBUTE27	VARCHAR2	(150)		Descriptive flexfield column
ATTRIBUTE28	VARCHAR2	(150)		Descriptive flexfield column
ATTRIBUTE29	VARCHAR2	(150)		Descriptive flexfield column
ATTRIBUTE30	VARCHAR2	(150)		Descriptive flexfield column
INFORMATION_CATEGORY	VARCHAR2	(30)		Developer Descriptive flexfield structure defining column
INFORMATION1	VARCHAR2	(150)		Developer Descriptive flexfield column
INFORMATION2	VARCHAR2	(150)		Developer Descriptive flexfield column
INFORMATION3	VARCHAR2	(150)		Developer Descriptive flexfield column
INFORMATION4	VARCHAR2	(150)		Developer Descriptive flexfield column
INFORMATION5	VARCHAR2	(150)		Developer Descriptive flexfield column
INFORMATION6	VARCHAR2	(150)		Developer Descriptive flexfield column
INFORMATION7	VARCHAR2	(150)		Developer Descriptive flexfield column
INFORMATION8	VARCHAR2	(150)		Developer Descriptive flexfield column
INFORMATION9	VARCHAR2	(150)		Developer Descriptive flexfield column
INFORMATION10	VARCHAR2	(150)		Developer Descriptive flexfield column
INFORMATION11	VARCHAR2	(150)		Developer Descriptive flexfield column
INFORMATION12	VARCHAR2	(150)		Developer Descriptive flexfield column
INFORMATION13	VARCHAR2	(150)		Developer Descriptive flexfield column
INFORMATION14	VARCHAR2	(150)		Developer Descriptive flexfield column
INFORMATION15	VARCHAR2	(150)		Developer Descriptive flexfield column
INFORMATION16	VARCHAR2	(150)		Developer Descriptive flexfield column
INFORMATION17	VARCHAR2	(150)		Developer Descriptive flexfield column
INFORMATION18	VARCHAR2	(150)		Developer Descriptive flexfield column
INFORMATION19	VARCHAR2	(150)		Developer Descriptive flexfield column
INFORMATION20	VARCHAR2	(150)		Developer Descriptive flexfield column
INFORMATION21	VARCHAR2	(150)		Developer Descriptive flexfield column
INFORMATION22	VARCHAR2	(150)		Developer Descriptive flexfield column
INFORMATION23	VARCHAR2	(150)		Developer Descriptive flexfield column
INFORMATION24	VARCHAR2	(150)		Developer Descriptive flexfield column
INFORMATION25	VARCHAR2	(150)		Developer Descriptive flexfield column
INFORMATION26	VARCHAR2	(150)		Developer Descriptive flexfield column
INFORMATION27	VARCHAR2	(150)		Developer Descriptive flexfield column
INFORMATION28	VARCHAR2	(150)		Developer Descriptive flexfield column
INFORMATION29	VARCHAR2	(150)		Developer Descriptive flexfield column
INFORMATION30	VARCHAR2	(150)		Developer Descriptive flexfield column
CREATED_BY	NUMBER	(15)		AOL Who Columns
CREATION_DATE	DATE			AOL Who Columns
LAST_UPDATED_BY	NUMBER	(15)		AOL Who Columns
LAST_UPDATE_LOGIN	NUMBER	(15)		AOL Who Columns
LAST_UPDATE_DATE	DATE			AOL Who Columns

Query Text

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


SELECT PERIOD_OF_PLACEMENT_ID
,      OBJECT_VERSION_NUMBER
,      BUSINESS_GROUP_ID
,      PERSON_ID
,      DATE_START
,      ACTUAL_TERMINATION_DATE
,      FINAL_PROCESS_DATE
,      LAST_STANDARD_PROCESS_DATE
,      PROJECTED_TERMINATION_DATE
,      TERMINATION_REASON
,      D_TERMINATION_REASON
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      INFORMATION_CATEGORY
,      INFORMATION1
,      INFORMATION2
,      INFORMATION3
,      INFORMATION4
,      INFORMATION5
,      INFORMATION6
,      INFORMATION7
,      INFORMATION8
,      INFORMATION9
,      INFORMATION10
,      INFORMATION11
,      INFORMATION12
,      INFORMATION13
,      INFORMATION14
,      INFORMATION15
,      INFORMATION16
,      INFORMATION17
,      INFORMATION18
,      INFORMATION19
,      INFORMATION20
,      INFORMATION21
,      INFORMATION22
,      INFORMATION23
,      INFORMATION24
,      INFORMATION25
,      INFORMATION26
,      INFORMATION27
,      INFORMATION28
,      INFORMATION29
,      INFORMATION30
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
FROM APPS.PER_PERIODS_OF_PLACEMENT_V;

Dependencies

[top of page]

APPS.PER_PERIODS_OF_PLACEMENT_V references the following:

APPS: HR_GENERAL - show dependent code; PER_PERIODS_OF_PLACEMENT

APPS.PER_PERIODS_OF_PLACEMENT_V is not referenced by any database object