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

TABLE: HR.PQH_RANK_PROCESSES

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


Total Score and ranking information of a person for a given process (gsp, cwb etc)


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PQH_RANK_PROCESSES_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnRANK_PROCESS_ID
PQH_RANK_PROCESSES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnASSIGNMENT_ID
PQH_RANK_PROCESSES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBENEFIT_ACTION_ID
PQH_RANK_PROCESSES_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPGM_ID
ColumnPER_IN_LER_ID
Columns
Name Datatype Length Mandatory Comments
RANK_PROCESS_ID NUMBER (15) Yes Primary Key (sourced from PQH_RANK_PROCESSES_S sequence).
PGM_ID NUMBER (15)
Program Identifier (FK BEN_PGM_F).
PL_ID NUMBER (15)
Plan Identifier (FK BEN_PL_F).
OIPL_ID NUMBER (15)
Options in Plan identifier (FK BEN_OIPL_F).
PROCESS_CD VARCHAR2 (30)
Process Code (GSP, CWB etc).
PROCESS_DATE DATE
Yes Date on which the participation process was initiated.
BENEFIT_ACTION_ID NUMBER (15)
Benefit Action Identifier (FK BEN_BENEFIT_ACTIONS)
PERSON_ID NUMBER

Person Identifier (FK PER_ALL_PEOPLE_F).
ASSIGNMENT_ID NUMBER (15)
Assignment Identifier (FK PER_ALL_ASSIGNMENTS_F).
TOTAL_SCORE NUMBER (15)
Total score of the person for the process.
BUSINESS_GROUP_ID NUMBER (15)
Business Group Identifier.
REQUEST_ID NUMBER (15)
The Concurrent request identifier that created the record (References FND_CONCURRENT_REQUESTS).
CREATED_BY NUMBER (15) Yes Standard Who Column
CREATION_DATE DATE
Yes Standard Who Column.
LAST_UPDATED_BY NUMBER (15)
Standard Who Column.
LAST_UPDATE_DATE DATE

Standard Who Column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column.
OBJECT_VERSION_NUMBER NUMBER (9) Yes Object version Number.
PER_IN_LER_ID NUMBER (15)
To verify and pick records which are marked as started (FK BEN_PER_IN_LER)
Query Text

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


SELECT RANK_PROCESS_ID
,      PGM_ID
,      PL_ID
,      OIPL_ID
,      PROCESS_CD
,      PROCESS_DATE
,      BENEFIT_ACTION_ID
,      PERSON_ID
,      ASSIGNMENT_ID
,      TOTAL_SCORE
,      BUSINESS_GROUP_ID
,      REQUEST_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      PER_IN_LER_ID
FROM HR.PQH_RANK_PROCESSES;

Dependencies

[top of page]

HR.PQH_RANK_PROCESSES does not reference any database object

HR.PQH_RANK_PROCESSES is referenced by following:

SchemaHR
ViewPQH_RANK_PROCESSES#