[Home] [Help] [Dependency Information]
Object Name: | PQH_BUDGETS |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | PQH.PQH_BUDGETS |
Subobject Name: | |
Status: | VALID |
Stores information on budgets
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PQH_BUDGETS_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | BUDGET_ID |
PQH_BUDGETS_UK | NORMAL | UNIQUE | APPS_TS_TX_IDX | BUDGET_NAME |
PQH_BUDGETS_FK1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PERIOD_SET_NAME |
PQH_BUDGETS_FK2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BUDGET_UNIT1_ID |
PQH_BUDGETS_FK3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BUDGET_UNIT2_ID |
PQH_BUDGETS_FK4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BUDGET_UNIT3_ID |
PQH_BUDGETS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BUDGETED_ENTITY_CD |
PQH_BUDGETS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | POSITION_CONTROL_FLAG |
PQH_BUDGETS_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BUDGET_START_DATE |
PQH_BUDGETS_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BUDGET_END_DATE |
Table | |
Foreign Table | Foreign Key Column | PQH_BUDGETS | PAY_CALENDARS | PQH_BUDGETS PERIOD_SET_NAME | PQH_BUDGETS | PER_SHARED_TYPES | PQH_BUDGETS BUDGET_UNIT3_ID | PQH_BUDGETS | PER_SHARED_TYPES | PQH_BUDGETS BUDGET_UNIT1_ID | PQH_BUDGETS | PER_SHARED_TYPES | PQH_BUDGETS BUDGET_UNIT2_ID | PQH_BUDGET_VERSIONS | PQH_BUDGETS | PQH_BUDGET_VERSIONS BUDGET_ID | PQH_WORKSHEETS | PQH_BUDGETS | PQH_WORKSHEETS BUDGET_ID |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BUDGET_ID | NUMBER | (15) | Yes | Primary Key |
BUSINESS_GROUP_ID | NUMBER | (15) | Business Group | |
START_ORGANIZATION_ID | NUMBER | (15) | Top organization of organization heirarchy tree, below which is to be budgeted | |
ORG_STRUCTURE_VERSION_ID | NUMBER | (15) | Organization Hierarchy version | |
BUDGETED_ENTITY_CD | VARCHAR2 | (30) | Primary Budgeting entity of the budget | |
BUDGET_STYLE_CD | VARCHAR2 | (30) | Yes | TOP-DOWN or BOTTOM-UP |
BUDGET_NAME | VARCHAR2 | (30) | Yes | Budget Name |
PERIOD_SET_NAME | VARCHAR2 | (30) | Yes | Budget Calendar Name |
GL_SET_OF_BOOKS_ID | NUMBER | (15) | GL Ledger mapping for transfer to GL | |
CURRENCY_CODE | VARCHAR2 | (240) | Currency | |
BUDGET_START_DATE | DATE | Yes | Start Date of budget | |
BUDGET_END_DATE | DATE | Yes | End Date of budget | |
BUDGET_UNIT1_ID | NUMBER | (15) | measurement unit | |
BUDGET_UNIT2_ID | NUMBER | (15) | measurement unit | |
BUDGET_UNIT3_ID | NUMBER | (15) | measurement unit | |
STATUS | VARCHAR2 | (10) | Budget is frozen or Open | |
TRANSFER_TO_GL_FLAG | VARCHAR2 | (30) | Transfer to GL or not | |
POSITION_CONTROL_FLAG | VARCHAR2 | (30) | Budget used for position control or not | |
BUDGET_UNIT1_AGGREGATE | VARCHAR2 | (30) | Accumulate, Average, Maximum; to compare period values against budget values | |
BUDGET_UNIT2_AGGREGATE | VARCHAR2 | (30) | Accumulate, Average, Maximum; to compare period values against budget values | |
BUDGET_UNIT3_AGGREGATE | VARCHAR2 | (30) | Accumulate, Average, Maximum; to compare period values against budget values | |
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 |
VALID_GRADE_REQD_FLAG | VARCHAR2 | (15) | Valid Grade Required Flag | |
TRANSFER_TO_GRANTS_FLAG | VARCHAR2 | (30) | Transfer to Grants Flag | |
PSB_BUDGET_FLAG | VARCHAR2 | (30) | Flag that identifies if this budget was transfered from PSB. Also this identifies if only GL commitment are to be processed. | |
GL_BUDGET_NAME | VARCHAR2 | (15) | Name of the GL budget to which this HR budget corresponds to. | |
DFLT_BUDGET_SET_ID | NUMBER | (15) | Default Budget Set Identifier |
Cut, paste (and edit) the following text to query this object:
SELECT BUDGET_ID
, BUSINESS_GROUP_ID
, START_ORGANIZATION_ID
, ORG_STRUCTURE_VERSION_ID
, BUDGETED_ENTITY_CD
, BUDGET_STYLE_CD
, BUDGET_NAME
, PERIOD_SET_NAME
, GL_SET_OF_BOOKS_ID
, CURRENCY_CODE
, BUDGET_START_DATE
, BUDGET_END_DATE
, BUDGET_UNIT1_ID
, BUDGET_UNIT2_ID
, BUDGET_UNIT3_ID
, STATUS
, TRANSFER_TO_GL_FLAG
, POSITION_CONTROL_FLAG
, BUDGET_UNIT1_AGGREGATE
, BUDGET_UNIT2_AGGREGATE
, BUDGET_UNIT3_AGGREGATE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, VALID_GRADE_REQD_FLAG
, TRANSFER_TO_GRANTS_FLAG
, PSB_BUDGET_FLAG
, GL_BUDGET_NAME
, DFLT_BUDGET_SET_ID
FROM HR.PQH_BUDGETS;
HR.PQH_BUDGETS does not reference any database object
HR.PQH_BUDGETS is referenced by following:
|
|
|