eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: HR.PQH_BUDGETS

Object Details

Object Name:	PQH_BUDGETS
Object Type:	TABLE
Owner:	HR
FND Design Data:	PQH.PQH_BUDGETS
Subobject Name:
Status:	VALID

Stores information on budgets

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PQH_BUDGETS_PK

BUDGET_ID

Unique Key: PQH_BUDGETS_UK

BUDGET_NAME

Indexes

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

Foreign Keys

Table	Foreign Table	Foreign Key Column
PQH_BUDGETS	PAY_CALENDARS	PQH_BUDGETS PERIOD_SET_NAME
PQH_BUDGET_VERSIONS	PQH_BUDGETS	PQH_BUDGET_VERSIONS BUDGET_ID
PQH_WORKSHEETS	PQH_BUDGETS	PQH_WORKSHEETS BUDGET_ID

Columns

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

Query Text

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;

Dependencies

[top of page]

HR.PQH_BUDGETS does not reference any database object

HR.PQH_BUDGETS is referenced by following:

HR: PQH_BUDGETS#