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


TABLE: HR.PER_BUDGET_ELEMENTS

Object Details
Object Name: PER_BUDGET_ELEMENTS
Object Type: TABLE
Owner: HR
FND Design Data: TablePER.PER_BUDGET_ELEMENTS
Subobject Name:
Status: VALID


PER_BUDGET_ELEMENTS holds the combinations of organization, grade,
job, and position that are used to define specific budget values in
PER_BUDGET_VALUES. These elements and values are held for a specific
budget version defined in PER_BUDGET_VERSIONS.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: PER_BUDGET_ELEMENTS_PK
  1. ColumnBUDGET_ELEMENT_ID
Indexes
Index Type Uniqueness Tablespace Column
PER_BUDGET_ELEMENTS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnBUDGET_ELEMENT_ID
PER_BUDGET_ELEMENTS_FK1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBUSINESS_GROUP_ID
PER_BUDGET_ELEMENTS_FK2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnGRADE_ID
PER_BUDGET_ELEMENTS_FK3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnJOB_ID
PER_BUDGET_ELEMENTS_FK4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPOSITION_ID
PER_BUDGET_ELEMENTS_FK5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGANIZATION_ID
PER_BUDGET_ELEMENTS_FK6 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBUDGET_VERSION_ID
PER_BUDGET_ELEMENTS_FK7 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRAINING_PLAN_ID
PER_BUDGET_ELEMENTS_FK8 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRAINING_PLAN_MEMBER_ID
PER_BUDGET_ELEMENTS_FK9 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnEVENT_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PER_BUDGET_ELEMENTS PER_BUDGET_ELEMENTS_FK1 TableHR_ALL_ORGANIZATION_UNITS PER_BUDGET_ELEMENTS BUSINESS_GROUP_ID
PER_BUDGET_ELEMENTS PER_BUDGET_ELEMENTS_FK5 TableHR_ALL_ORGANIZATION_UNITS PER_BUDGET_ELEMENTS ORGANIZATION_ID
PER_BUDGET_ELEMENTS PER_BUDGET_ELEMENTS_FK6 TablePER_BUDGET_VERSIONS PER_BUDGET_ELEMENTS BUDGET_VERSION_ID
PER_BUDGET_ELEMENTS PER_BUDGET_ELEMENTS_FK2 TablePER_GRADES PER_BUDGET_ELEMENTS GRADE_ID
PER_BUDGET_ELEMENTS PER_BUDGET_ELEMENTS_FK3 TablePER_JOBS PER_BUDGET_ELEMENTS JOB_ID
TablePER_BUDGET_VALUES PER_BUDGET_VALUES_FK2 PER_BUDGET_ELEMENTS PER_BUDGET_VALUES BUDGET_ELEMENT_ID
Columns
Name Datatype Length Mandatory Comments
BUDGET_ELEMENT_ID NUMBER (15) Yes System-generated primary key column.
BUSINESS_GROUP_ID NUMBER (15) Yes Foreign key to HR_ORGANIZATION_UNITS.
GRADE_ID NUMBER (15)
Foreign key to PER_GRADES.
JOB_ID NUMBER (15)
Foreign key to PER_JOBS.
POSITION_ID NUMBER (15)
Foreign key to PER_ALL_POSITIONS.
ORGANIZATION_ID NUMBER (15)
Foreign key to HR_ORGANIZATION_UNITS.
BUDGET_VERSION_ID NUMBER (15) Yes Foreign key to PER_BUDGET_VERSIONS.
REQUEST_ID NUMBER (15)
Standard Who column.
PROGRAM_APPLICATION_ID NUMBER (15)
Standard Who column.
PROGRAM_ID NUMBER (15)
Standard Who column.
PROGRAM_UPDATE_DATE DATE

Standard Who column.
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.
TRAINING_PLAN_ID NUMBER (9)
The training plan this budget relates to.
TRAINING_PLAN_MEMBER_ID NUMBER (9)
The training plan member this budget relates to.
EVENT_ID NUMBER (9)
The Event this budget relates to.
Query Text

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


SELECT BUDGET_ELEMENT_ID
,      BUSINESS_GROUP_ID
,      GRADE_ID
,      JOB_ID
,      POSITION_ID
,      ORGANIZATION_ID
,      BUDGET_VERSION_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      TRAINING_PLAN_ID
,      TRAINING_PLAN_MEMBER_ID
,      EVENT_ID
FROM HR.PER_BUDGET_ELEMENTS;

Dependencies

[top of page]

HR.PER_BUDGET_ELEMENTS does not reference any database object

HR.PER_BUDGET_ELEMENTS is referenced by following:

SchemaAPPS
SynonymPER_BUDGET_ELEMENTS
TriggerPER_BUDGET_ELEMENTS_WHO
SchemaPUBLIC
SynonymPER_BUDGET_ELEMENTS