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_TIME_PERIODS

Object Details

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

PER_TIME_PERIODS holds details of each defined time period for payroll
calendars and HR budget calendars. Payroll time periods are used as a
basis for regular payroll processing and are limited by predefined
legislative calendars. HR budget time periods are limited by user
defined calendar years. The start date and end date that define the
actual limits for each pay period are generated by the system, from
the user specification of the payroll processing frequency and the
predefined legislative calendar for tax processing and reporting.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PER_TIME_PERIODS_PK

TIME_PERIOD_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
PER_TIME_PERIODS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	TIME_PERIOD_ID
PER_TIME_PERIODS_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TIME_DEFINITION_ID
PER_TIME_PERIODS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PERIOD_SET_NAME
PER_TIME_PERIODS_N50	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYROLL_ID START_DATE END_DATE
PER_TIME_PERIODS_N51	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYROLL_ID REGULAR_PAYMENT_DATE

Foreign Keys

Table	Foreign Table	Foreign Key Column
PAY_PAYROLL_ACTIONS	PER_TIME_PERIODS	PAY_PAYROLL_ACTIONS TIME_PERIOD_ID
PER_BUDGET_VALUES	PER_TIME_PERIODS	PER_BUDGET_VALUES TIME_PERIOD_ID
PQH_BUDGET_PERIODS	PER_TIME_PERIODS	PQH_BUDGET_PERIODS START_TIME_PERIOD_ID
PQH_BUDGET_PERIODS	PER_TIME_PERIODS	PQH_BUDGET_PERIODS END_TIME_PERIOD_ID
PQH_WORKSHEET_PERIODS	PER_TIME_PERIODS	PQH_WORKSHEET_PERIODS END_TIME_PERIOD_ID
PQH_WORKSHEET_PERIODS	PER_TIME_PERIODS	PQH_WORKSHEET_PERIODS START_TIME_PERIOD_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TIME_PERIOD_ID	NUMBER	(15)	Yes	System-generated primary key column.
PAYROLL_ID	NUMBER	(9)		Foreign key to PAY_PAYROLLS.
END_DATE	DATE		Yes	End date for the period.
PERIOD_NAME	VARCHAR2	(70)	Yes	Period name. Unique within a payroll or budget calendar.
PERIOD_NUM	NUMBER	(15)	Yes	Sequence number of this time period in the year.
PERIOD_TYPE	VARCHAR2	(30)	Yes	Type of time period, for example, week, month, quarter, year.
START_DATE	DATE		Yes	Start date of the period.
CUT_OFF_DATE	DATE			Default cut-off date for the period.
DEFAULT_DD_DATE	DATE			Default direct deposit date for the period.
DESCRIPTION	VARCHAR2	(240)		Description.
PAY_ADVICE_DATE	DATE			Default pay advice date for the period.
PERIOD_SET_NAME	VARCHAR2	(30)		Foreign key to PAY_CALENDARS.
PERIOD_YEAR	NUMBER	(15)		Calendar year that includes the end date of the period. (Optional for payroll).
PROC_PERIOD_TYPE	VARCHAR2	(30)		Processing period type. For example, calendar month, year, quarter. Values are taken from PROC_PERIOD_TYPE domain.
QUARTER_NUM	NUMBER	(15)		Legislative quarter number that includes end date of the period. (Optional for payroll).
QUICKPAY_DISPLAY_NUMBER	NUMBER	(9)		Number of QuickPay runs processed in the period.
REGULAR_PAYMENT_DATE	DATE			Default payment date for the period, also the default for the payroll run.
RUN_DISPLAY_NUMBER	NUMBER	(9)		Number of payroll runs processed in the period.
STATUS	VARCHAR2	(30)		Status of period - O(pen) or (C)losed for payroll processing. See domain PROCESSING_PERIOD_STATUS.
YEAR_NUMBER	NUMBER	(15)		Number of the year in an HR budget calendar.
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.
REGULAR_DATE_EARNED	DATE			Default date earned for the regular run for the period.
PRD_INFORMATION_CATEGORY	VARCHAR2	(30)		Developer descriptive flexfield column.
PRD_INFORMATION1	VARCHAR2	(150)		Developer descriptive flexfield column.
PRD_INFORMATION2	VARCHAR2	(150)		Developer descriptive flexfield column.
PRD_INFORMATION3	VARCHAR2	(150)		Developer descriptive flexfield column.
PRD_INFORMATION4	VARCHAR2	(150)		Developer descriptive flexfield column.
PRD_INFORMATION5	VARCHAR2	(150)		Developer descriptive flexfield column.
PRD_INFORMATION6	VARCHAR2	(150)		Developer descriptive flexfield column.
PRD_INFORMATION7	VARCHAR2	(150)		Developer descriptive flexfield column.
PRD_INFORMATION8	VARCHAR2	(150)		Developer descriptive flexfield column.
PRD_INFORMATION9	VARCHAR2	(150)		Developer descriptive flexfield column.
PRD_INFORMATION10	VARCHAR2	(150)		Developer descriptive flexfield column.
PRD_INFORMATION11	VARCHAR2	(150)		Developer descriptive flexfield column.
PRD_INFORMATION12	VARCHAR2	(150)		Developer descriptive flexfield column.
PRD_INFORMATION13	VARCHAR2	(150)		Developer descriptive flexfield column.
PRD_INFORMATION14	VARCHAR2	(150)		Developer descriptive flexfield column.
PRD_INFORMATION15	VARCHAR2	(150)		Developer descriptive flexfield column.
PRD_INFORMATION16	VARCHAR2	(150)		Developer descriptive flexfield column.
PRD_INFORMATION17	VARCHAR2	(150)		Developer descriptive flexfield column.
PRD_INFORMATION18	VARCHAR2	(150)		Developer descriptive flexfield column.
PRD_INFORMATION19	VARCHAR2	(150)		Developer descriptive flexfield column.
PRD_INFORMATION20	VARCHAR2	(150)		Developer descriptive flexfield column.
PRD_INFORMATION21	VARCHAR2	(150)		Developer descriptive flexfield column.
PRD_INFORMATION22	VARCHAR2	(150)		Developer descriptive flexfield column.
PRD_INFORMATION23	VARCHAR2	(150)		Developer descriptive flexfield column.
PRD_INFORMATION24	VARCHAR2	(150)		Developer descriptive flexfield column.
PRD_INFORMATION25	VARCHAR2	(150)		Developer descriptive flexfield column.
PRD_INFORMATION26	VARCHAR2	(150)		Developer descriptive flexfield column.
PRD_INFORMATION27	VARCHAR2	(150)		Developer descriptive flexfield column.
PRD_INFORMATION28	VARCHAR2	(150)		Developer descriptive flexfield column.
PRD_INFORMATION29	VARCHAR2	(150)		Developer descriptive flexfield column.
PRD_INFORMATION30	VARCHAR2	(150)		Developer descriptive flexfield column.
TIME_DEFINITION_ID	NUMBER	(9)		Foreign Key to PAY_TIME_DEFINITIONS.
PAYSLIP_VIEW_DATE	DATE			Date after which user can view his payslip

Query Text

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


SELECT TIME_PERIOD_ID
,      PAYROLL_ID
,      END_DATE
,      PERIOD_NAME
,      PERIOD_NUM
,      PERIOD_TYPE
,      START_DATE
,      CUT_OFF_DATE
,      DEFAULT_DD_DATE
,      DESCRIPTION
,      PAY_ADVICE_DATE
,      PERIOD_SET_NAME
,      PERIOD_YEAR
,      PROC_PERIOD_TYPE
,      QUARTER_NUM
,      QUICKPAY_DISPLAY_NUMBER
,      REGULAR_PAYMENT_DATE
,      RUN_DISPLAY_NUMBER
,      STATUS
,      YEAR_NUMBER
,      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
,      REGULAR_DATE_EARNED
,      PRD_INFORMATION_CATEGORY
,      PRD_INFORMATION1
,      PRD_INFORMATION2
,      PRD_INFORMATION3
,      PRD_INFORMATION4
,      PRD_INFORMATION5
,      PRD_INFORMATION6
,      PRD_INFORMATION7
,      PRD_INFORMATION8
,      PRD_INFORMATION9
,      PRD_INFORMATION10
,      PRD_INFORMATION11
,      PRD_INFORMATION12
,      PRD_INFORMATION13
,      PRD_INFORMATION14
,      PRD_INFORMATION15
,      PRD_INFORMATION16
,      PRD_INFORMATION17
,      PRD_INFORMATION18
,      PRD_INFORMATION19
,      PRD_INFORMATION20
,      PRD_INFORMATION21
,      PRD_INFORMATION22
,      PRD_INFORMATION23
,      PRD_INFORMATION24
,      PRD_INFORMATION25
,      PRD_INFORMATION26
,      PRD_INFORMATION27
,      PRD_INFORMATION28
,      PRD_INFORMATION29
,      PRD_INFORMATION30
,      TIME_DEFINITION_ID
,      PAYSLIP_VIEW_DATE
FROM HR.PER_TIME_PERIODS;

Dependencies

[top of page]

HR.PER_TIME_PERIODS does not reference any database object

HR.PER_TIME_PERIODS is referenced by following:

HR: PER_TIME_PERIODS#