[Home] [Help] [Dependency Information]
Object Name: | PER_ASSIGNMENT_BUDGET_VALUES_F |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | PER.PER_ASSIGNMENT_BUDGET_VALUES_F |
Subobject Name: | |
Status: | VALID |
PER_ASSIGNMENT_BUDGET_VALUES is the DateTracked table that holds information about the HR budget values for an assignment. Assignments may be budgeted using
headcount, FTE (full time equivalent), points or any other user
defined units. Oracle HRMS sums the budget values held in this table
for employee assignments when calculating actual headcount figures.
Although applicant assignment budget values are not used in the
calculation of headcount figures, it may be useful to hold them. For
example, when an applicant is hired into an assignment, previously
applied for, the assignment budget values that already exist are
automatically included in any future headcount calculations. If you
define a default value for a specific budget type at the level of the
business group, then each time a new assignment is created, the
default value is also created for the assignment.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PER_ASSIGNMENT_BUDGET_VALU_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
ASSIGNMENT_BUDGET_VALUE_ID
EFFECTIVE_START_DATE EFFECTIVE_END_DATE |
PER_ASSIGNMENT_BUDGET_VALU_UK2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
ASSIGNMENT_ID
EFFECTIVE_START_DATE EFFECTIVE_END_DATE UNIT |
Table | |
Foreign Table | Foreign Key Column | PER_ASSIGNMENT_BUDGET_VALUES_F | HR_ALL_ORGANIZATION_UNITS | PER_ASSIGNMENT_BUDGET_VALUES_F BUSINESS_GROUP_ID |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ASSIGNMENT_BUDGET_VALUE_ID | NUMBER | (15) | Yes | System-generated primary key column. |
EFFECTIVE_START_DATE | DATE | Yes | Date track effective date column | |
EFFECTIVE_END_DATE | DATE | Yes | Date track effective date column | |
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | Foreign key to HR_ORGANIZATION_UNITS. |
ASSIGNMENT_ID | NUMBER | (10) | Yes | Foreign key to PER_ASSIGNMENTS. |
UNIT | VARCHAR2 | (30) | Yes | Budget measurement units, for example, headcount, FTE, points. |
VALUE | NUMBER | (25) | Yes | Budget measurement value. |
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. | ||
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | internal used by APIs |
Cut, paste (and edit) the following text to query this object:
SELECT ASSIGNMENT_BUDGET_VALUE_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID
, ASSIGNMENT_ID
, UNIT
, VALUE
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, OBJECT_VERSION_NUMBER
FROM HR.PER_ASSIGNMENT_BUDGET_VALUES_F;
HR.PER_ASSIGNMENT_BUDGET_VALUES_F does not reference any database object
HR.PER_ASSIGNMENT_BUDGET_VALUES_F is referenced by following:
|
|
|