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_ATTRIBUTE_VALUES_I

Object Details

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

PSB_ATTRIBUTE_VALUES_I is the interface table for
PSB_ATTRIBUTE_VALUES. This table contains the list of valid values
available in Human Resource Management Systems for each of the
position attributes defined that are to have a value set in Public Sector Budgeting. Data to be
imported into PSB_ATTRIBUTE_VALUES is populated into this table using
the appropriate DATA_EXTRACT_ID.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PSB_ATTRIBUTE_VALUES_I_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	DATA_EXTRACT_ID
PSB_ATTRIBUTE_VALUES_I_N2	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	ATTRIBUTE_VALUE ATTRIBUTE_ID DATA_EXTRACT_ID
PSB_ATTRIBUTE_VALUES_I_U1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	ATTRIBUTE_VALUE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ATTRIBUTE_VALUE_ID	NUMBER	(20)	Yes	Attribute value unique identifier. The same unique identifier is transferred to PSB_ATTRIBUTE_VALUES.
ATTRIBUTE_ID	NUMBER	(20)	Yes	Position attribute unique identifier
ATTRIBUTE_VALUE	VARCHAR2	(240)		Value for the attribute that can be assigned to the position. If the value is a date the format should be YYYY/MM/DD.
VALUE_ID	VARCHAR2	(150)		The VALUE_ID associated with the ATTRIBUTE_VALUE obtained from the value set definition. Needs to hold a non-null value only in case of descriptive flexfield attributes.
DATA_EXTRACT_ID	NUMBER		Yes	Data extract unique identifier
DESCRIPTION	VARCHAR2	(240)		Description of the position attribute value
CREATED_BY	NUMBER		Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column

Query Text

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


SELECT ATTRIBUTE_VALUE_ID
,      ATTRIBUTE_ID
,      ATTRIBUTE_VALUE
,      VALUE_ID
,      DATA_EXTRACT_ID
,      DESCRIPTION
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM PSB.PSB_ATTRIBUTE_VALUES_I;

Dependencies

[top of page]

PSB.PSB_ATTRIBUTE_VALUES_I does not reference any database object

PSB.PSB_ATTRIBUTE_VALUES_I is referenced by following:

APPS: PSB_ATTRIBUTE_VALUES_I