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_EVENTS_ALL

Object Details

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

PSB_POSITION_EVENTS_ALL stores events for transaction position entries. An event is an entity that creates transaction data. All position entries need to be tagged with the events that created it. An event contains information regarding the timing and reason for creation of position entries.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PSB_POSITION_EVENTS_ALL_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	POSITION_EVENT_ID
PSB_POSITION_EVENTS_ALL_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	EVENT_TYPE SOURCE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
POSITION_EVENT_ID	NUMBER	(15)	Yes	Position Event unique identifier
EVENT_TYPE	VARCHAR2	(2)	Yes	Event type is BP (Budget Preparation) or BR (Budget Revision)
SOURCE_ID	NUMBER	(15)	Yes	Source position transaction identifier based on event type
ORG_ID	NUMBER	(15)		Organization identifier
TRANSFER_TO_INTERFACE	VARCHAR2	(1)	Yes	Indicates if position transaction entry has been posted to the position control interface tables
TRANSFER_TO_HRMS	VARCHAR2	(1)	Yes	Indicates if position transaction entry has been posted to the HRMS tables
INTERFACE_CREATED_BY	NUMBER	(15)		Standard Who column
INTERFACE_CREATION_DATE	DATE			Standard Who column
INTERFACE_LAST_UPDATE_DATE	DATE			Standard Who column
INTERFACE_LAST_UPDATED_BY	NUMBER	(15)		Standard Who column
INTERFACE_LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
HRMS_CREATED_BY	NUMBER	(15)		Standard Who column
HRMS_CREATION_DATE	DATE			Standard Who column
HRMS_LAST_UPDATE_DATE	DATE			Standard Who column
HRMS_LAST_UPDATED_BY	NUMBER	(15)		Standard Who column
HRMS_LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
HR_BUDGET_ID	NUMBER			Oracle HRMS Position Control budget identifier.
FROM_BUDGET_YEAR_ID	NUMBER			From budget year in PSB.
TO_BUDGET_YEAR_ID	NUMBER			To budget year in PSB.

Query Text

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


SELECT POSITION_EVENT_ID
,      EVENT_TYPE
,      SOURCE_ID
,      ORG_ID
,      TRANSFER_TO_INTERFACE
,      TRANSFER_TO_HRMS
,      INTERFACE_CREATED_BY
,      INTERFACE_CREATION_DATE
,      INTERFACE_LAST_UPDATE_DATE
,      INTERFACE_LAST_UPDATED_BY
,      INTERFACE_LAST_UPDATE_LOGIN
,      HRMS_CREATED_BY
,      HRMS_CREATION_DATE
,      HRMS_LAST_UPDATE_DATE
,      HRMS_LAST_UPDATED_BY
,      HRMS_LAST_UPDATE_LOGIN
,      HR_BUDGET_ID
,      FROM_BUDGET_YEAR_ID
,      TO_BUDGET_YEAR_ID
FROM PSB.PSB_POSITION_EVENTS_ALL;

Dependencies

[top of page]

PSB.PSB_POSITION_EVENTS_ALL does not reference any database object

PSB.PSB_POSITION_EVENTS_ALL is referenced by following:

APPS: PSB_POSITION_EVENTS_ALL