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_POSITION_COSTS

Object Details

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

PSB_POSITION_COSTS stores position costs by pay elements for position control with the baseline values from budget revisions. This is an interface table for Position Control into which position costs are populated before posting to any Position Control system.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PSB_POSITION_COSTS_U1	NORMAL	UNIQUE	APPS_TS_SUMMARY	POSITION_ELEMENT_LINE_ID
PSB_POSITION_COSTS_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	POSITION_ID
PSB_POSITION_COSTS_N2	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	BUDGET_REVISION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
POSITION_ELEMENT_LINE_ID	NUMBER	(20)	Yes	Position element cost unique identifier
POSITION_ID	NUMBER	(20)	Yes	Position unique identifier
PAY_ELEMENT_ID	NUMBER	(20)	Yes	Pay element unique identifier
START_DATE	DATE		Yes	Start date for which the element cost is maintained
END_DATE	DATE		Yes	End date for which the element cost is maintained
CURRENCY_CODE	VARCHAR2	(15)	Yes	Currency code
ELEMENT_COST	NUMBER		Yes	Cost of the Position Control element
BUDGET_REVISION_ID	NUMBER	(20)		Budget revision unique identifier
BASE_LINE_VERSION	VARCHAR2	(1)		Base line version is O (Original Values from Budget Preparation) or C (Current Values from Position Control)
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
HR_POSITION_ID	NUMBER	(20)		Unique identifier for the position in source Human Resource Management System
HR_BUDGET_SET_ID	NUMBER	(20)		Identifier for Budget Set in source Human Resource Management System to which the PSB element is mapped
HR_BUDGET_ID	NUMBER	(20)		Oracle HRMS Position Control Budget Identifier
TRANSFER_TO_PC_FLAG	VARCHAR2	(1)		Flag to indicate whether the record has been posted to position control or not.

Query Text

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


SELECT POSITION_ELEMENT_LINE_ID
,      POSITION_ID
,      PAY_ELEMENT_ID
,      START_DATE
,      END_DATE
,      CURRENCY_CODE
,      ELEMENT_COST
,      BUDGET_REVISION_ID
,      BASE_LINE_VERSION
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      HR_POSITION_ID
,      HR_BUDGET_SET_ID
,      HR_BUDGET_ID
,      TRANSFER_TO_PC_FLAG
FROM PSB.PSB_POSITION_COSTS;

Dependencies

[top of page]

PSB.PSB_POSITION_COSTS does not reference any database object

PSB.PSB_POSITION_COSTS is referenced by following:

APPS: PSB_POSITION_COSTS