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.HR_PATTERN_BITS

Object Details

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

In order to simplify the construction of complex repeating patterns,
such as work patterns or resource schedules, it is possible to define
arbitrary periods of time which may be referred to in the pattern
construction. For example, a time period may be created that is based
on 8 hours and called 'Standard shift'. The time period is always
based on a known period of real time (hours/days/weeks) and multiplied
by a figure to arrive at the duration of the period. The multiplier
figure may be any positive number, including fractions, so it is
possible to specify time periods at any level of granularity.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	20
PCT Used:

Primary Key: HR_PATTERN_BITS_PK

PATTERN_BIT_ID

Unique Key: HR_PAB_UK01

PATTERN_BIT_CODE

Indexes

Index	Type	Uniqueness	Tablespace	Column
HR_PATTERN_BITS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	PATTERN_BIT_ID
HR_PATTERN_BITS_UK1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PATTERN_BIT_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
PATTERN_BIT_ID	NUMBER		Yes	System-generated primary key column.
PATTERN_BIT_CODE	VARCHAR2	(30)	Yes	Unique name or code to identify the pattern bit.
BIT_MEANING	VARCHAR2	(2000)	Yes	Explanation of the pattern bit and its purpose.
TIME_UNIT_MULTIPLIER	NUMBER		Yes	The figure by which the base time unit must be multiplied to find the duration of the pattern bit.
BASE_TIME_UNIT	VARCHAR2	(30)	Yes	Real time unit (hours/days/weeks) from which the pattern bit duration is derived.
OBJECT_VERSION_NUMBER	NUMBER			System-generated version of row. Increments by one with each update.
CREATED_BY	NUMBER			Standard Who column.
CREATION_DATE	DATE			Standard Who column.
LAST_UPDATED_BY	NUMBER			Standard Who column.
LAST_UPDATE_DATE	DATE			Standard Who column.
LAST_UPDATE_LOGIN	NUMBER			Standard Who column.

Query Text

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


SELECT PATTERN_BIT_ID
,      PATTERN_BIT_CODE
,      BIT_MEANING
,      TIME_UNIT_MULTIPLIER
,      BASE_TIME_UNIT
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM HR.HR_PATTERN_BITS;

Dependencies

[top of page]

HR.HR_PATTERN_BITS does not reference any database object

HR.HR_PATTERN_BITS is referenced by following:

APPS: HR_PATTERN_BITS; HR_PATTERN_BITS_WHO
PUBLIC: HR_PATTERN_BITS