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_YEAR_TYPES

Object Details

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

PSB_BUDGET_YEAR_TYPES stores the definition of the year types used to
group years in a calendar. The SEQUENCE_NUMBER of the year type
identifies the order of the years in a calendar. So a year with a
lower SEQUENCE_NUMBER must be before a year with a higher
SEQUENCE_NUMBER. The number of year types limits the number of years
in a calendar. All budget year types must be assigned to one of the
three system year types which are PY for Prior Year, CY for Current
Year, and PP for Proposed Year. Historical balances are retrieved
from General Ledger for Prior Years. Current Year is the current
fiscal year, which has both historical information for the completed
periods and estimates for future periods. Budget estimates
are calculated for all Proposed Years.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PSB_BUDGET_YEAR_TYPES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	BUDGET_YEAR_TYPE_ID
PSB_BUDGET_YEAR_TYPES_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	SEQUENCE_NUMBER
PSB_BUDGET_YEAR_TYPES_U3	NORMAL	UNIQUE	APPS_TS_TX_IDX	NAME

Columns

Name	Datatype	Length	Mandatory	Comments
BUDGET_YEAR_TYPE_ID	NUMBER	(20)	Yes	Budget year type unique identifier
NAME	VARCHAR2	(30)		Year type name
DESCRIPTION	VARCHAR2	(80)		Year type description
YEAR_CATEGORY_TYPE	VARCHAR2	(30)	Yes	System-assigned category for year types. Valid values are PY (Prior Year), CY (Current Year), and PP (Proposed Year).
SEQUENCE_NUMBER	NUMBER		Yes	Sequence of the years in the budget calendar. The lower sequence denotes an earlier budget year in the budget calendar.
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column

Query Text

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


SELECT BUDGET_YEAR_TYPE_ID
,      NAME
,      DESCRIPTION
,      YEAR_CATEGORY_TYPE
,      SEQUENCE_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM PSB.PSB_BUDGET_YEAR_TYPES;

Dependencies

[top of page]

PSB.PSB_BUDGET_YEAR_TYPES does not reference any database object

PSB.PSB_BUDGET_YEAR_TYPES is referenced by following:

APPS: PSB_BUDGET_YEAR_TYPES