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_CALENDAR_ENTRIES

Object Details

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

This table holds calendar entries specifying public holidays.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PER_CALENDAR_ENTRIES_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	CALENDAR_ENTRY_ID
PER_CALENDAR_ENTRIES_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	HIERARCHY_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CALENDAR_ENTRY_ID	NUMBER	(15)	Yes	Calendar Entry Primary Key
BUSINESS_GROUP_ID	NUMBER	(15)		Foreign Key to HR_ALL_ORGANIZATION_UNITS table
NAME	VARCHAR2	(80)	Yes	Name of the Calendar Entry
TYPE	VARCHAR2	(30)	Yes	Type of the Calendar Entry
START_DATE	DATE		Yes	Start Date of the Calendar Entry
START_HOUR	VARCHAR2	(30)		The hour the Calendar Entry starts
START_MIN	VARCHAR2	(30)		The minute the Calendar Entry starts
END_DATE	DATE		Yes	End Date of the Calendar Entry
END_HOUR	VARCHAR2	(30)		The hour the Calendar Entry ends
END_MIN	VARCHAR2	(30)		The minute the Calendar Entry ends
HIERARCHY_ID	NUMBER	(15)		Foreign Key to PER_GENERIC_HIERARCHY table
VALUE_SET_ID	NUMBER	(15)		Foreign Key to FND_FLEX_VALUE_SETS table
DESCRIPTION	VARCHAR2	(240)		Description
LAST_UPDATE_DATE	DATE			Last Update Date
LAST_UPDATED_BY	NUMBER	(15)		Last Updated BY
LAST_UPDATE_LOGIN	NUMBER	(15)		Last Update Login
CREATED_BY	NUMBER	(15)		Created By
CREATION_DATE	DATE			Creation Date
OBJECT_VERSION_NUMBER	NUMBER	(15)	Yes	Object Version Number
LEGISLATION_CODE	VARCHAR2	(30)		Legislation Code for seeded entry.
IDENTIFIER_KEY	VARCHAR2	(60)		Developer Id Key for seeded entry.
ORGANIZATION_STRUCTURE_ID	NUMBER	(15)		FK to PER_ORGANIZATION_STRUCTURES.
ORG_STRUCTURE_VERSION_ID	NUMBER	(15)		FK to PER_ORG_STRUCTURE_VERSIONS.

Query Text

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


SELECT CALENDAR_ENTRY_ID
,      BUSINESS_GROUP_ID
,      NAME
,      TYPE
,      START_DATE
,      START_HOUR
,      START_MIN
,      END_DATE
,      END_HOUR
,      END_MIN
,      HIERARCHY_ID
,      VALUE_SET_ID
,      DESCRIPTION
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      OBJECT_VERSION_NUMBER
,      LEGISLATION_CODE
,      IDENTIFIER_KEY
,      ORGANIZATION_STRUCTURE_ID
,      ORG_STRUCTURE_VERSION_ID
FROM HR.PER_CALENDAR_ENTRIES;

Dependencies

[top of page]

HR.PER_CALENDAR_ENTRIES does not reference any database object

HR.PER_CALENDAR_ENTRIES is referenced by following:

APPS: PER_CALENDAR_ENTRIES; PER_CALENDAR_ENTRIES_WHO
PUBLIC: PER_CALENDAR_ENTRIES