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: PSB.PSB_BUDGET_GROUPS

Object Details

Object Name:	PSB_BUDGET_GROUPS
Object Type:	TABLE
Owner:	PSB
FND Design Data:	PSB.PSB_BUDGET_GROUPS
Subobject Name:
Status:	VALID

PSB_BUDGET_GROUPS stores the definition information for a budget
group. Budget group is the basic budget organization entity in Oracle
Public Sector Budgeting. Budget groups have a value of R for
BUDGET_GROUP_TYPE.
Budget groups have a hierarchical structure. The root level budget
group for any given hierarchy is identified as a ROOT_BUDGET_GROUP
flag. The information that is applicable to all the budget groups in
the hierarchy such as Set of Books, Stage Sets, Personnel Services
Account Sets, and Non-Personnel Services Account Sets is defined at
the root budget group only.
Every budget group except the root budget group has a parent.
Every budget group's list of accounts includes the accounts defined
for that budget group and all the accounts defined for the child
budget groups.
PSB_BUDGET_GROUPS also stores the definitions of review groups. Review
groups are external entities outside the budget group hierarchy
structure used for the Budget Approval process. Review groups have a
value of W for BUDGET_GROUP_TYPE. Review groups do not have a
hierarchical structure.
Both budget groups and review groups have one or more account sets
associated with them to identify the list of accounts that can be
accessed by the users assigned to this group.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PSB_BUDGET_GROUPS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	BUDGET_GROUP_ID
PSB_BUDGET_GROUPS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	NAME BUDGET_GROUP_TYPE
PSB_BUDGET_GROUPS_U3	NORMAL	UNIQUE	APPS_TS_TX_IDX	SHORT_NAME BUDGET_GROUP_TYPE
PSB_BUDGET_GROUPS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARENT_BUDGET_GROUP_ID
PSB_BUDGET_GROUPS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ROOT_BUDGET_GROUP_ID

Columns

Name	Datatype	Length	Mandatory	Comments
BUDGET_GROUP_ID	NUMBER	(20)	Yes	Budget group unique identifier
NAME	VARCHAR2	(80)	Yes	Budget group name
SHORT_NAME	VARCHAR2	(20)	Yes	Budget group short name. Used to identify the budget groups in all windows.
ROOT_BUDGET_GROUP	VARCHAR2	(1)		Flag indicates if this is a root budget group
PARENT_BUDGET_GROUP_ID	NUMBER	(20)		Unique identifier of the parent budget group for the current budget group
ROOT_BUDGET_GROUP_ID	NUMBER	(20)		Unique identifier of the root budget group for this budget group hierarchy
PS_ACCOUNT_POSITION_SET_ID	NUMBER	(15)		Unique identifier for the account set which is designated as the Personnel Services account set
NPS_ACCOUNT_POSITION_SET_ID	NUMBER	(15)		Unique identifier of the account set which is designated as the Non-Personnel Services account set
BUDGET_GROUP_CATEGORY_SET_ID	NUMBER	(15)		Unique identifier of budget group category set. Categories from this set are used to define review group rules.
EFFECTIVE_START_DATE	DATE		Yes	Effective start date for this budget group
EFFECTIVE_END_DATE	DATE			Effective end date for this budget group
FREEZE_HIERARCHY_FLAG	VARCHAR2	(1)		Flag indicates if this budget group hierarchy is frozen
DESCRIPTION	VARCHAR2	(240)		Description of the budget group
SET_OF_BOOKS_ID	NUMBER	(15)		General Ledger Set of Books identifier. All budgets for this budget group hierarchy will be posted to this Set of Books.
BUSINESS_GROUP_ID	NUMBER	(15)		Business group identifier. All position information for this budget group hierarchy is extracted from this business group.
NUM_PROPOSED_YEARS	NUMBER			Maximum number of years that estimates are calculated for this budget group
NARRATIVE_DESCRIPTION	VARCHAR2	(2000)		Extended description for this budget group
REQUEST_ID	NUMBER			Concurrent request identifier for the last freeze process
BUDGET_GROUP_TYPE	VARCHAR2	(1)		Type indicates if it is R for a regular budget group or W for a review group
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
SEGMENT1_TYPE	NUMBER	(15)		Account Flexfield segment used to store display order. For future use.
SEGMENT2_TYPE	NUMBER	(15)		Account Flexfield segment used to store display order. For future use.
SEGMENT3_TYPE	NUMBER	(15)		Account Flexfield segment used to store display order. For future use.
SEGMENT4_TYPE	NUMBER	(15)		Account Flexfield segment used to store display order. For future use.
SEGMENT5_TYPE	NUMBER	(15)		Account Flexfield segment used to store display order. For future use.
SEGMENT6_TYPE	NUMBER	(15)		Account Flexfield segment used to store display order. For future use.
SEGMENT7_TYPE	NUMBER	(15)		Account Flexfield segment used to store display order. For future use.
SEGMENT8_TYPE	NUMBER	(15)		Account Flexfield segment used to store display order. For future use.
SEGMENT9_TYPE	NUMBER	(15)		Account Flexfield segment used to store display order. For future use.
SEGMENT10_TYPE	NUMBER	(15)		Account Flexfield segment used to store display order. For future use.
SEGMENT11_TYPE	NUMBER	(15)		Account Flexfield segment used to store display order. For future use.
SEGMENT12_TYPE	NUMBER	(15)		Account Flexfield segment used to store display order. For future use.
SEGMENT13_TYPE	NUMBER	(15)		Account Flexfield segment used to store display order. For future use.
SEGMENT14_TYPE	NUMBER	(15)		Account Flexfield segment used to store display order. For future use.
SEGMENT15_TYPE	NUMBER	(15)		Account Flexfield segment used to store display order. For future use.
SEGMENT16_TYPE	NUMBER	(15)		Account Flexfield segment used to store display order. For future use.
SEGMENT17_TYPE	NUMBER	(15)		Account Flexfield segment used to store display order. For future use.
SEGMENT18_TYPE	NUMBER	(15)		Account Flexfield segment used to store display order. For future use.
SEGMENT19_TYPE	NUMBER	(15)		Account Flexfield segment used to store display order. For future use.
SEGMENT20_TYPE	NUMBER	(15)		Account Flexfield segment used to store display order. For future use.
SEGMENT21_TYPE	NUMBER	(15)		Account Flexfield segment used to store display order. For future use.
SEGMENT22_TYPE	NUMBER	(15)		Account Flexfield segment used to store display order. For future use.
SEGMENT23_TYPE	NUMBER	(15)		Account Flexfield segment used to store display order. For future use.
SEGMENT24_TYPE	NUMBER	(15)		Account Flexfield segment used to store display order. For future use.
SEGMENT25_TYPE	NUMBER	(15)		Account Flexfield segment used to store display order. For future use.
SEGMENT26_TYPE	NUMBER	(15)		Account Flexfield segment used to store display order. For future use.
SEGMENT27_TYPE	NUMBER	(15)		Account Flexfield segment used to store display order. For future use.
SEGMENT28_TYPE	NUMBER	(15)		Account Flexfield segment used to store display order. For future use.
SEGMENT29_TYPE	NUMBER	(15)		Account Flexfield segment used to store display order. For future use.
SEGMENT30_TYPE	NUMBER	(15)		Account Flexfield segment used to store display order. For future use.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield segment column
CONTEXT	VARCHAR2	(30)		Descriptive Flexfield context
ORGANIZATION_ID	NUMBER	(15)		HRMS organization identifier.

Query Text

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


SELECT BUDGET_GROUP_ID
,      NAME
,      SHORT_NAME
,      ROOT_BUDGET_GROUP
,      PARENT_BUDGET_GROUP_ID
,      ROOT_BUDGET_GROUP_ID
,      PS_ACCOUNT_POSITION_SET_ID
,      NPS_ACCOUNT_POSITION_SET_ID
,      BUDGET_GROUP_CATEGORY_SET_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      FREEZE_HIERARCHY_FLAG
,      DESCRIPTION
,      SET_OF_BOOKS_ID
,      BUSINESS_GROUP_ID
,      NUM_PROPOSED_YEARS
,      NARRATIVE_DESCRIPTION
,      REQUEST_ID
,      BUDGET_GROUP_TYPE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      SEGMENT1_TYPE
,      SEGMENT2_TYPE
,      SEGMENT3_TYPE
,      SEGMENT4_TYPE
,      SEGMENT5_TYPE
,      SEGMENT6_TYPE
,      SEGMENT7_TYPE
,      SEGMENT8_TYPE
,      SEGMENT9_TYPE
,      SEGMENT10_TYPE
,      SEGMENT11_TYPE
,      SEGMENT12_TYPE
,      SEGMENT13_TYPE
,      SEGMENT14_TYPE
,      SEGMENT15_TYPE
,      SEGMENT16_TYPE
,      SEGMENT17_TYPE
,      SEGMENT18_TYPE
,      SEGMENT19_TYPE
,      SEGMENT20_TYPE
,      SEGMENT21_TYPE
,      SEGMENT22_TYPE
,      SEGMENT23_TYPE
,      SEGMENT24_TYPE
,      SEGMENT25_TYPE
,      SEGMENT26_TYPE
,      SEGMENT27_TYPE
,      SEGMENT28_TYPE
,      SEGMENT29_TYPE
,      SEGMENT30_TYPE
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      CONTEXT
,      ORGANIZATION_ID
FROM PSB.PSB_BUDGET_GROUPS;

Dependencies

[top of page]

PSB.PSB_BUDGET_GROUPS does not reference any database object

PSB.PSB_BUDGET_GROUPS is referenced by following:

APPS: PSB_BUDGET_GROUPS