Skip to content

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

TABLE: HR.PER_WPM_BATCH_ACTIONS

Object Details
Object Name: PER_WPM_BATCH_ACTIONS
Object Type: TABLE
Owner: HR
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PER_WPM_BATCH_ACTIONS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnWPM_BATCH_ACTION_ID
PER_WPM_BATCH_ACTIONS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPLAN_ID
PER_WPM_BATCH_ACTIONS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSTATUS
Columns
Name Datatype Length Mandatory Comments
WPM_BATCH_ACTION_ID NUMBER (15) Yes Sequence generated primary key
CONC_REQUEST_ID NUMBER (15) Yes Conc Request Id
CONC_PROGRAM_NAME VARCHAR2 (200) Yes Concurrent Program Name
PLAN_ID NUMBER (15)
Plan Id
APPRAISAL_PERIOD_ID NUMBER (15)
Appraisal Period Id
STATUS VARCHAR2 (30)
Status
START_DATE DATE

END_DATE DATE

End Date
INFORMATION_CATEGORY VARCHAR2 (30)
Information Category
INFORMATION1 VARCHAR2 (150)
Additional Information
INFORMATION2 VARCHAR2 (150)
Information2
INFORMATION3 VARCHAR2 (150)
Additional Information
INFORMATION4 VARCHAR2 (150)
Information2
INFORMATION5 VARCHAR2 (150)
Additional Information
INFORMATION6 VARCHAR2 (150)
Additional Information
INFORMATION7 VARCHAR2 (150)
Additional Information
INFORMATION8 VARCHAR2 (150)
Additional Information
INFORMATION9 VARCHAR2 (150)
Additional Information
INFORMATION10 VARCHAR2 (150)
Additional Information
INFORMATION11 VARCHAR2 (150)
Additional Information
INFORMATION12 VARCHAR2 (150)
Additional Information
INFORMATION13 VARCHAR2 (150)
Information2
INFORMATION14 VARCHAR2 (150)
Information2
INFORMATION15 VARCHAR2 (150)
Information2
INFORMATION16 VARCHAR2 (150)
Information2
INFORMATION17 VARCHAR2 (150)
Information2
INFORMATION18 VARCHAR2 (150)
Information2
INFORMATION19 VARCHAR2 (150)
Information2
INFORMATION20 VARCHAR2 (150)
Information2
LAST_UPDATE_DATE DATE

Standard WHO column
LAST_UPDATED_BY NUMBER (15)
Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
CREATED_BY NUMBER (15)
Standard WHO column
CREATION_DATE DATE

Standard WHO column
Query Text

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


SELECT WPM_BATCH_ACTION_ID
,      CONC_REQUEST_ID
,      CONC_PROGRAM_NAME
,      PLAN_ID
,      APPRAISAL_PERIOD_ID
,      STATUS
,      START_DATE
,      END_DATE
,      INFORMATION_CATEGORY
,      INFORMATION1
,      INFORMATION2
,      INFORMATION3
,      INFORMATION4
,      INFORMATION5
,      INFORMATION6
,      INFORMATION7
,      INFORMATION8
,      INFORMATION9
,      INFORMATION10
,      INFORMATION11
,      INFORMATION12
,      INFORMATION13
,      INFORMATION14
,      INFORMATION15
,      INFORMATION16
,      INFORMATION17
,      INFORMATION18
,      INFORMATION19
,      INFORMATION20
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM HR.PER_WPM_BATCH_ACTIONS;

Dependencies

[top of page]

HR.PER_WPM_BATCH_ACTIONS does not reference any database object

HR.PER_WPM_BATCH_ACTIONS is referenced by following:

SchemaHR
ViewPER_WPM_BATCH_ACTIONS#