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_WS_USER_PROFILES

Object Details

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

PSB_WS_USER_PROFILES stores profile information for a user to
view a worksheet. There are three types of profiles:
1) Profile Type Q identifies general options such as sort order of
accounting flexfields, summary template and stage. There is only one
row of this type per worksheet and user identifier combination.
2) Profile Type S identifies the list of service packages to view in a
given worksheet.
3) Profile Type Y identifies the list of years and balance types to
view in a given worksheet.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PSB_WS_USER_PROFILES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	WORKSHEET_ID USER_ID

Columns

Name	Datatype	Length	Comments
WORKSHEET_ID	NUMBER	(15)	Unique identifier for worksheet for which this profile is created
USER_ID	NUMBER	(15)	Unique identifier for the user for whom this profile is created
PROFILE_TYPE	VARCHAR2	(1)	Profile type is Q (Query), S (Service Package), or Y (Year).
SERVICE_PACKAGE_ID	NUMBER	(15)	Unique identifier of service package to be included from the worksheet
STAGE_SET_ID	NUMBER		Unique identifier for the worksheet stage set
STAGE_SEQ	NUMBER		Stage sequence for which the worksheet values must be retrieved
TEMPLATE_ID	NUMBER	(15)	General Ledger summary template identifier for summary account balances
YEAR_FLAG	VARCHAR2	(1)	Indicates if user profile is set for all years or for selected years
SERVICE_PACKAGE_FLAG	VARCHAR2	(1)	Indicates category of service packages to be displayed in the worksheet. Valid Values are A (all service packages) or S (selected service packages).
ACCOUNT_FLAG	VARCHAR2	(1)	Indicates type of account to be displayed. Valid values are R (Revenue), E (Expense), or A (All).
CURRENCY_FLAG	VARCHAR2	(1)	Indicates the type of currency to be displayed in the worksheet. Valid calues are C (Functional Currency) or S (Statistical Currency).
BUDGET_PERIOD_ID	NUMBER	(15)	Unique identifier for the budget year for which the balances must be retrieved
ACTUAL_FLAG	VARCHAR2	(1)	Indicates if actual balance must be retrieved
BUDGET_FLAG	VARCHAR2	(1)	Indicates if budget balances must be retrieved
ESTIMATE_FLAG	VARCHAR2	(1)	Indicates if estimate balances must be retrieved
ENCUMBRANCE_FLAG	VARCHAR2	(1)	Indicates if encumbrance balances must be retrieved
FTE_FLAG	VARCHAR2	(1)	Indicates if full-time equivalency values must be retrieved
START_YEAR_FLAG	VARCHAR2	(1)	Indicates if this year must be displayed as the first column in the worksheet screen by default
ORDER_BY_COLUMN1	VARCHAR2	(30)	Accounting Flexfield order by column
ORDER_BY_COLUMN2	VARCHAR2	(30)	Accounting Flexfield order by column
ORDER_BY_COLUMN3	VARCHAR2	(30)	Accounting Flexfield order by column
ORDER_BY_COLUMN4	VARCHAR2	(30)	Accounting Flexfield order by column
ORDER_BY_COLUMN5	VARCHAR2	(30)	Accounting Flexfield order by column
ORDER_BY_COLUMN_NAME1	VARCHAR2	(30)	Accounting Flexfield order by user column name
ORDER_BY_COLUMN_NAME2	VARCHAR2	(30)	Accounting Flexfield order by user column name
ORDER_BY_COLUMN_NAME3	VARCHAR2	(30)	Accounting Flexfield order by user column name
ORDER_BY_COLUMN_NAME4	VARCHAR2	(30)	Accounting Flexfield order by user column name
ORDER_BY_COLUMN_NAME5	VARCHAR2	(30)	Accounting Flexfield order by user column name
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

Query Text

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


SELECT WORKSHEET_ID
,      USER_ID
,      PROFILE_TYPE
,      SERVICE_PACKAGE_ID
,      STAGE_SET_ID
,      STAGE_SEQ
,      TEMPLATE_ID
,      YEAR_FLAG
,      SERVICE_PACKAGE_FLAG
,      ACCOUNT_FLAG
,      CURRENCY_FLAG
,      BUDGET_PERIOD_ID
,      ACTUAL_FLAG
,      BUDGET_FLAG
,      ESTIMATE_FLAG
,      ENCUMBRANCE_FLAG
,      FTE_FLAG
,      START_YEAR_FLAG
,      ORDER_BY_COLUMN1
,      ORDER_BY_COLUMN2
,      ORDER_BY_COLUMN3
,      ORDER_BY_COLUMN4
,      ORDER_BY_COLUMN5
,      ORDER_BY_COLUMN_NAME1
,      ORDER_BY_COLUMN_NAME2
,      ORDER_BY_COLUMN_NAME3
,      ORDER_BY_COLUMN_NAME4
,      ORDER_BY_COLUMN_NAME5
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM PSB.PSB_WS_USER_PROFILES;

Dependencies

[top of page]

PSB.PSB_WS_USER_PROFILES does not reference any database object

PSB.PSB_WS_USER_PROFILES is referenced by following:

APPS: PSB_WS_USER_PROFILES