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_FTE

Object Details

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

PSB_POSITION_FTE stores the position control full-time equivalency information with the baseline values from budget revisions. This is an interface table for position control into which position full-time equivalency values 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_FTE_U1	NORMAL	UNIQUE	APPS_TS_SUMMARY	POSITION_FTE_LINE_ID
PSB_POSITION_FTE_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	POSITION_ID
PSB_POSITION_FTE_N2	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	BUDGET_REVISION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
POSITION_FTE_LINE_ID	NUMBER	(20)	Yes	Position full-time equivalency line unique identifier
POSITION_ID	NUMBER	(20)	Yes	Position unique identifier
START_DATE	DATE		Yes	Start date for which the position full-time equivalency values are maintained
END_DATE	DATE		Yes	End date for which the position full-time equivalency values are maintained
FTE	NUMBER		Yes	Position control full-time equivalency value for the position
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 position in source Human Resource Management System
HR_BUDGET_ID	NUMBER	(20)		Unique identifier for budget in source Human Resource Management System
TRANSFER_TO_PC_FLAG	VARCHAR2	(1)		Flag indicating whether record has been posted to position control or not

Query Text

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


SELECT POSITION_FTE_LINE_ID
,      POSITION_ID
,      START_DATE
,      END_DATE
,      FTE
,      BUDGET_REVISION_ID
,      BASE_LINE_VERSION
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      HR_POSITION_ID
,      HR_BUDGET_ID
,      TRANSFER_TO_PC_FLAG
FROM PSB.PSB_POSITION_FTE;

Dependencies

[top of page]

PSB.PSB_POSITION_FTE does not reference any database object

PSB.PSB_POSITION_FTE is referenced by following:

APPS: PSB_POSITION_FTE