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

TABLE: HR.HR_PATTERNS

Object Details
Object Name: HR_PATTERNS
Object Type: TABLE
Owner: HR
FND Design Data: TablePER.HR_PATTERNS
Subobject Name:
Status: VALID


A repeating pattern of time periods, for various uses. For example, a
shift pattern may be defined for a group of workers, or a timetable
for resource availability.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 20
PCT Used:
Primary Key: HR_PATTERNS_PK
  1. ColumnPATTERN_ID
Unique Key: HR_PAT_UK01
  1. ColumnPATTERN_NAME
Indexes
Index Type Uniqueness Tablespace Column
HR_PATTERNS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPATTERN_ID
HR_PATTERNS_UK1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPATTERN_NAME
Columns
Name Datatype Length Mandatory Comments
PATTERN_ID NUMBER
Yes System-generated primary key column.
PATTERN_NAME VARCHAR2 (80) Yes Unique name to identify a pattern.
PATTERN_START_WEEKDAY VARCHAR2 (30)
A day of the week on which the pattern must start.
PATTERN_START_TIME VARCHAR2 (5)
A time of day (format HH:MI) at which the pattern must start.
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_LOGIN NUMBER

Standard Who column.
LAST_UPDATE_DATE DATE

Standard Who column.
Query Text

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


SELECT PATTERN_ID
,      PATTERN_NAME
,      PATTERN_START_WEEKDAY
,      PATTERN_START_TIME
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
FROM HR.HR_PATTERNS;

Dependencies

[top of page]

HR.HR_PATTERNS does not reference any database object

HR.HR_PATTERNS is referenced by following:

SchemaAPPS
SynonymHR_PATTERNS
TriggerHR_PATTERNS_WHO
SchemaPUBLIC
SynonymHR_PATTERNS