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

TABLE: HR.PQP_GAP_ABSENCE_PLANS

Object Details
Object Name: PQP_GAP_ABSENCE_PLANS
Object Type: TABLE
Owner: HR
FND Design Data: TablePQP.PQP_GAP_ABSENCE_PLANS
Subobject Name:
Status: VALID


This table is used to store the generic Absence Plans


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PQP_GAP_ABSENCE_PLANS_UK1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnABSENCE_ATTENDANCE_ID
ColumnPL_ID
PQP_GAP_ABSENCE_PLANS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnASSIGNMENT_ID
PQP_GAP_ABSENCE_PLANS_PK NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnGAP_ABSENCE_PLAN_ID
Columns
Name Datatype Length Mandatory Comments
GAP_ABSENCE_PLAN_ID NUMBER (15) Yes Absence plan Id
ASSIGNMENT_ID NUMBER (10) Yes Assignment Id
ABSENCE_ATTENDANCE_ID NUMBER (10) Yes Absence attendance id
PL_ID NUMBER (10) Yes Plan ID is a foreign key to BEN_PL_F table
LAST_GAP_DAILY_ABSENCE_DATE DATE

Last day of absence
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
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
Query Text

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


SELECT GAP_ABSENCE_PLAN_ID
,      ASSIGNMENT_ID
,      ABSENCE_ATTENDANCE_ID
,      PL_ID
,      LAST_GAP_DAILY_ABSENCE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_LOGIN
FROM HR.PQP_GAP_ABSENCE_PLANS;

Dependencies

[top of page]

HR.PQP_GAP_ABSENCE_PLANS does not reference any database object

HR.PQP_GAP_ABSENCE_PLANS is referenced by following:

SchemaAPPS
SynonymPQP_GAP_ABSENCE_PLANS
TriggerPQP_GAP_ABSENCE_PLANS_WHO
SchemaPUBLIC
SynonymPQP_GAP_ABSENCE_PLANS