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


TABLE: HR.PER_WPM_PERSON_ACTIONS

Object Details
Object Name: PER_WPM_PERSON_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_PERSON_ACTIONS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnWPM_PERSON_ACTION_ID
PER_WPM_PERSON_ACTIONS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPERSON_ID
Columns
Name Datatype Length Mandatory Comments
WPM_PERSON_ACTION_ID NUMBER (15) Yes Sequence generated primary key
WPM_BATCH_ACTION_ID NUMBER (15) Yes Conc Request Id
PERSON_ID NUMBER (15) Yes Concurrent Program Name
ASSIGNMENT_ID NUMBER (15) Yes Plan Id
BUSINESS_GROUP_ID NUMBER (15) Yes Appraisal Period Id
PROCESSING_STATUS VARCHAR2 (30) Yes Status
ELIGIBILITY_STATUS VARCHAR2 (30)
MESSAGE_TYPE VARCHAR2 (30)
End Date
MESSAGE_NUMBER VARCHAR2 (80)
End Date
MESSAGE_TEXT VARCHAR2 (4000)
End Date
TRANSACTION_REF_TABLE VARCHAR2 (80)
End Date
TRANSACTION_REF_ID NUMBER (15)
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_PERSON_ACTION_ID
,      WPM_BATCH_ACTION_ID
,      PERSON_ID
,      ASSIGNMENT_ID
,      BUSINESS_GROUP_ID
,      PROCESSING_STATUS
,      ELIGIBILITY_STATUS
,      MESSAGE_TYPE
,      MESSAGE_NUMBER
,      MESSAGE_TEXT
,      TRANSACTION_REF_TABLE
,      TRANSACTION_REF_ID
,      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_PERSON_ACTIONS;

Dependencies

[top of page]

HR.PER_WPM_PERSON_ACTIONS does not reference any database object

HR.PER_WPM_PERSON_ACTIONS is referenced by following:

SchemaHR
ViewPER_WPM_PERSON_ACTIONS#