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_POSITIONS

Object Details

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

PSB_POSITIONS stores position definition information. This table
stores positions extracted from the Oracle Human Resource Management
Systems PER_POSITIONS table. Positions can be created or maintained in
this table within Public Sector Budgeting. Positions imported from
Human Resource Management Systems have a value for the
HR_POSITION_ID field. The POSITION_DEFINITION_ID is the foreign key
to the position number key flexfield segments stored in
the PSB_POSITION_DEFINITIONS table.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PSB_POSITIONS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	POSITION_ID
PSB_POSITIONS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DATA_EXTRACT_ID
PSB_POSITIONS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BUDGET_GROUP_ID
PSB_POSITIONS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	HR_POSITION_ID DATA_EXTRACT_ID
PSB_POSITIONS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	NAME DATA_EXTRACT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
POSITION_ID	NUMBER	(20)	Yes	Position unique identifier
DATA_EXTRACT_ID	NUMBER	(20)	Yes	Data extract unique identifier
POSITION_DEFINITION_ID	NUMBER	(20)		Position definition unique identifier
HR_POSITION_ID	NUMBER	(20)		Unique identifier for the position in source Human Resources Management system. Null value indicates new position created in Public Sector Budgeting.
HR_EMPLOYEE_ID	NUMBER	(20)		Unique employee identifier in source Human Resources Management system
BUSINESS_GROUP_ID	NUMBER	(20)	Yes	Business group unique identifier
BUDGET_GROUP_ID	NUMBER	(20)		Budget group identifier for the position
NAME	VARCHAR2	(240)		Position name is a concatenation of the position key flexfield segments
EFFECTIVE_START_DATE	DATE		Yes	Effective start date for the position
EFFECTIVE_END_DATE	DATE			Effective end date for the position
SET_OF_BOOKS_ID	NUMBER	(15)		General Ledger Sets of Books unique identifier
VACANT_POSITION_FLAG	VARCHAR2	(1)		Indicates if position is filled
ATTRIBUTE_CATEGORY	VARCHAR2	(150)		Descriptive Flexfield structure defining column
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE16	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE17	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE18	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE19	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE20	VARCHAR2	(150)		Descriptive Flexfield segment column
CONTEXT	VARCHAR2	(30)		Descriptive Flexfield context
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
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
AVAILABILITY_STATUS	VARCHAR2	(30)		Indicates the status of the position Active, Eliminated, Deleted, Frozen, Proposed.
TRANSACTION_ID	NUMBER	(15)		Indicates the position transaction identifier if the position is created from PSB for organizations enabled with position control.
TRANSACTION_STATUS	VARCHAR2	(30)		Indicates the status of the position control transaction initiated to create a new position from PSB for position control enabled organizations.
NEW_POSITION_FLAG	VARCHAR2	(1)		Indicates new position created for budgeting.
ORGANIZATION_ID	NUMBER	(15)		Organization to which the Position/Job belongs.

Query Text

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


SELECT POSITION_ID
,      DATA_EXTRACT_ID
,      POSITION_DEFINITION_ID
,      HR_POSITION_ID
,      HR_EMPLOYEE_ID
,      BUSINESS_GROUP_ID
,      BUDGET_GROUP_ID
,      NAME
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      SET_OF_BOOKS_ID
,      VACANT_POSITION_FLAG
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      CONTEXT
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      AVAILABILITY_STATUS
,      TRANSACTION_ID
,      TRANSACTION_STATUS
,      NEW_POSITION_FLAG
,      ORGANIZATION_ID
FROM PSB.PSB_POSITIONS;

Dependencies

[top of page]

PSB.PSB_POSITIONS does not reference any database object

PSB.PSB_POSITIONS is referenced by following:

APPS: PSB_POSITIONS