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

Object Details

Object Name:	PQP_GAP_DAILY_ABSENCES
Object Type:	TABLE
Owner:	HR
FND Design Data:	PQP.PQP_GAP_DAILY_ABSENCES
Subobject Name:
Status:	VALID

This table is used to store daily absence details like absence date, work pattern and the level of entitlement for an absence plan.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PQP_GAP_DAILY_ABSENCES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GAP_ABSENCE_PLAN_ID ABSENCE_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
GAP_DAILY_ABSENCE_ID	NUMBER	(15)	Yes	Primary key
GAP_ABSENCE_PLAN_ID	NUMBER	(15)	Yes	Foreign key to PQP_GAP_ABSENCE_PLANS table.
ABSENCE_DATE	DATE		Yes	The date of a day or fraction of a day of an absence.
WORK_PATTERN_DAY_TYPE	VARCHAR2	(30)	Yes	Work Pattern Day Type WORKON or OFFWORK
LEVEL_OF_ENTITLEMENT	VARCHAR2	(30)	Yes	Level of entitlement is the entitlement band info
LEVEL_OF_PAY	VARCHAR2	(30)	Yes	Band info for paid days
DURATION	NUMBER	(11)	Yes	Duration for this day or a fraction of the day.
LAST_UPDATED_BY	NUMBER	(15)		Standard who column
LAST_UPDATE_DATE	DATE			Standard who column
CREATED_BY	NUMBER	(15)		Standard who column
CREATION_DATE	DATE			Standard who column
OBJECT_VERSION_NUMBER	NUMBER	(15)		Standard who column
DURATION_IN_HOURS	NUMBER	(11)		Duration for this day or fraction of the day expressed in hours.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
WORKING_DAYS_PER_WEEK	NUMBER	(6)		Average number of days per week that a person worked on this day of absence.
FTE	NUMBER	(25)		Full Time Equivalent of the assignment as of the absence date.

Query Text

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


SELECT GAP_DAILY_ABSENCE_ID
,      GAP_ABSENCE_PLAN_ID
,      ABSENCE_DATE
,      WORK_PATTERN_DAY_TYPE
,      LEVEL_OF_ENTITLEMENT
,      LEVEL_OF_PAY
,      DURATION
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      OBJECT_VERSION_NUMBER
,      DURATION_IN_HOURS
,      LAST_UPDATE_LOGIN
,      WORKING_DAYS_PER_WEEK
,      FTE
FROM HR.PQP_GAP_DAILY_ABSENCES;

Dependencies

[top of page]

HR.PQP_GAP_DAILY_ABSENCES does not reference any database object

HR.PQP_GAP_DAILY_ABSENCES is referenced by following:

HR: PQP_GAP_DAILY_ABSENCES#