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


TABLE: HR.PQH_WORKSHEET_DETAILS

Object Details
Object Name: PQH_WORKSHEET_DETAILS
Object Type: TABLE
Owner: HR
FND Design Data: TablePQH.PQH_WORKSHEET_DETAILS
Subobject Name:
Status: VALID


Work table of Hr entities for Budget information


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: PQH_WORKSHEET_DETAILS_PK
  1. ColumnWORKSHEET_DETAIL_ID
Unique Key: PQH_WORKSHEET_DETAILS_UK
  1. ColumnACTION_CD
  2. ColumnWORKSHEET_ID
  3. ColumnORGANIZATION_ID
  4. ColumnJOB_ID
  5. ColumnPOSITION_ID
  6. ColumnGRADE_ID
  7. ColumnPOSITION_TRANSACTION_ID
Indexes
Index Type Uniqueness Tablespace Column
PQH_WORKSHEET_DETAILS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnWORKSHEET_DETAIL_ID
PQH_WORKSHEET_DETAILS_UK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnACTION_CD
ColumnWORKSHEET_ID
ColumnORGANIZATION_ID
ColumnJOB_ID
ColumnPOSITION_ID
ColumnGRADE_ID
ColumnPOSITION_TRANSACTION_ID
PQH_WORKSHEET_DETAILS_FK1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPOSITION_ID
PQH_WORKSHEET_DETAILS_FK2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGANIZATION_ID
PQH_WORKSHEET_DETAILS_FK3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBUDGET_DETAIL_ID
PQH_WORKSHEET_DETAILS_FK4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPOSITION_TRANSACTION_ID
PQH_WORKSHEET_DETAILS_FK5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnJOB_ID
PQH_WORKSHEET_DETAILS_FK6 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnGRADE_ID
PQH_WORKSHEET_DETAILS_FK7 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnWORKSHEET_ID
PQH_WORKSHEET_DETAILS_FK8 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPARENT_WORKSHEET_DETAIL_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PQH_WORKSHEET_DETAILS PQH_WORKSHEET_DETAILS_FK2 TableHR_ALL_ORGANIZATION_UNITS PQH_WORKSHEET_DETAILS ORGANIZATION_ID
PQH_WORKSHEET_DETAILS PQH_WORKSHEET_DETAILS_FK6 TablePER_GRADES PQH_WORKSHEET_DETAILS GRADE_ID
PQH_WORKSHEET_DETAILS PQH_WORKSHEET_DETAILS_FK5 TablePER_JOBS PQH_WORKSHEET_DETAILS JOB_ID
PQH_WORKSHEET_DETAILS PQH_WORKSHEET_DETAILS_FK3 TablePQH_BUDGET_DETAILS PQH_WORKSHEET_DETAILS BUDGET_DETAIL_ID
PQH_WORKSHEET_DETAILS PQH_WORKSHEET_DETAILS_FK4 TablePQH_POSITION_TRANSACTIONS PQH_WORKSHEET_DETAILS POSITION_TRANSACTION_ID
PQH_WORKSHEET_DETAILS PQH_WORKSHEET_DETAILS_FK7 TablePQH_WORKSHEETS PQH_WORKSHEET_DETAILS WORKSHEET_ID
PQH_WORKSHEET_DETAILS PQH_WORKSHEET_DETAILS_FK8 TablePQH_WORKSHEET_DETAILS PQH_WORKSHEET_DETAILS PARENT_WORKSHEET_DETAIL_ID
TablePQH_WORKSHEET_DETAILS PQH_WORKSHEET_DETAILS_FK8 PQH_WORKSHEET_DETAILS PQH_WORKSHEET_DETAILS PARENT_WORKSHEET_DETAIL_ID
TablePQH_WORKSHEET_PERIODS PQH_WORKSHEET_PERIODS_FK1 PQH_WORKSHEET_DETAILS PQH_WORKSHEET_PERIODS WORKSHEET_DETAIL_ID
Columns
Name Datatype Length Mandatory Comments
WORKSHEET_DETAIL_ID NUMBER (15) Yes Primary Key
WORKSHEET_ID NUMBER (15) Yes Worksheet identifier
ORGANIZATION_ID NUMBER (15)
Organization identifier ( delegate / budgeted) (Hr entity)
JOB_ID NUMBER (15)
Budgeted Job identifier (Hr entity)
POSITION_ID NUMBER (15)
Budgeted Job identifier (Hr entity)
GRADE_ID NUMBER (15)
Budgeted Job identifier (Hr entity)
POSITION_TRANSACTION_ID NUMBER (15)
budgeted position transaction identifier
BUDGET_DETAIL_ID NUMBER (15)
Budget detail identifier (in correction / edit modes of worksheet)
PARENT_WORKSHEET_DETAIL_ID NUMBER (15)
Parent Worksheet detail identifier ( null in case of top node)
USER_ID NUMBER (15)
manager of the organization, part or the worksheet delegated to
ACTION_CD VARCHAR2 (30)
Action (Budgeted / delegated/ null)
DEFER_FLAG VARCHAR2 (10)
Notification to be sent right away or defered
BUDGET_UNIT1_PERCENT NUMBER (15)
Percentage allocated to Hr entity from parent worksheet detail
BUDGET_UNIT2_PERCENT NUMBER (15)
Percentage allocated to Hr entity from parent worksheet detail
BUDGET_UNIT3_PERCENT NUMBER (15)
Percentage allocated to Hr entity from parent worksheet detail
BUDGET_UNIT1_VALUE NUMBER

Value allocated to Hr entity from parent worksheet detail
BUDGET_UNIT2_VALUE NUMBER

Value allocated to Hr entity from parent worksheet detail
BUDGET_UNIT3_VALUE NUMBER

Value allocated to Hr entity from parent worksheet detail
BUDGET_UNIT1_VALUE_TYPE_CD VARCHAR2 (30)
Unit type allocated (P -Percentage, V-Value)
BUDGET_UNIT2_VALUE_TYPE_CD VARCHAR2 (30)
Unit type allocated (P -Percentage, V-Value)
BUDGET_UNIT3_VALUE_TYPE_CD VARCHAR2 (30)
Unit type allocated (P -Percentage, V-Value)
BUDGET_UNIT1_AVAILABLE NUMBER

unused value of worksheet detail
BUDGET_UNIT2_AVAILABLE NUMBER

unused value of worksheet detail
BUDGET_UNIT3_AVAILABLE NUMBER

unused value of worksheet detail
OLD_UNIT1_VALUE NUMBER

Old values of worksheet details when changes are not propaged
OLD_UNIT2_VALUE NUMBER

Old values of worksheet details when changes are not propaged
OLD_UNIT3_VALUE NUMBER

Old values of worksheet details when changes are not propaged
PROPAGATION_METHOD VARCHAR2 (2)
Propagation Method used to propagate changes.
STATUS VARCHAR2 (10)
Status
OBJECT_VERSION_NUMBER NUMBER (9) Yes Object version number
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) Yes Standard Who Column
CREATION_DATE DATE
Yes Standard Who Column
Query Text

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


SELECT WORKSHEET_DETAIL_ID
,      WORKSHEET_ID
,      ORGANIZATION_ID
,      JOB_ID
,      POSITION_ID
,      GRADE_ID
,      POSITION_TRANSACTION_ID
,      BUDGET_DETAIL_ID
,      PARENT_WORKSHEET_DETAIL_ID
,      USER_ID
,      ACTION_CD
,      DEFER_FLAG
,      BUDGET_UNIT1_PERCENT
,      BUDGET_UNIT2_PERCENT
,      BUDGET_UNIT3_PERCENT
,      BUDGET_UNIT1_VALUE
,      BUDGET_UNIT2_VALUE
,      BUDGET_UNIT3_VALUE
,      BUDGET_UNIT1_VALUE_TYPE_CD
,      BUDGET_UNIT2_VALUE_TYPE_CD
,      BUDGET_UNIT3_VALUE_TYPE_CD
,      BUDGET_UNIT1_AVAILABLE
,      BUDGET_UNIT2_AVAILABLE
,      BUDGET_UNIT3_AVAILABLE
,      OLD_UNIT1_VALUE
,      OLD_UNIT2_VALUE
,      OLD_UNIT3_VALUE
,      PROPAGATION_METHOD
,      STATUS
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM HR.PQH_WORKSHEET_DETAILS;

Dependencies

[top of page]

HR.PQH_WORKSHEET_DETAILS does not reference any database object

HR.PQH_WORKSHEET_DETAILS is referenced by following:

SchemaHR
ViewPQH_WORKSHEET_DETAILS#