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

Object Details

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

PSB_ATTRIBUTE_VALUES stores a list of valid values for any given
position attribute. Not all attributes have a value set. Only those
attributes that are defined to have a value set have values in this
table.
If multiple data sets are maintained in Oracle Public Sector
Budgeting, a separate value set is maintained for an attribute for
each data set.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PSB_ATTRIBUTE_VALUES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ATTRIBUTE_VALUE_ID
PSB_ATTRIBUTE_VALUES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DATA_EXTRACT_ID
PSB_ATTRIBUTE_VALUES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ATTRIBUTE_VALUE ATTRIBUTE_ID DATA_EXTRACT_ID
PSB_ATTRIBUTE_VALUES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ATTRIBUTE_ID DATA_EXTRACT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ATTRIBUTE_VALUE_ID	NUMBER	(20)	Yes	Attribute value unique identifier
ATTRIBUTE_ID	NUMBER	(20)	Yes	Position attribute unique identifier
ATTRIBUTE_VALUE	VARCHAR2	(240)		Value for the attribute that can be assigned to the position
DESCRIPTION	VARCHAR2	(80)		Description of the position attribute value
HR_VALUE_ID	VARCHAR2	(150)		VALUE_ID associated with the ATTRIBUTE_VALUE obtained from the value set definition
DATA_EXTRACT_ID	NUMBER	(15)	Yes	Data extract unique identifier
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
ATTRIBUTE21	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE22	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE23	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE24	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE25	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE26	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE27	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE28	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE29	VARCHAR2	(150)		Descriptive Flexfield segment column
ATTRIBUTE30	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
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column

Query Text

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


SELECT ATTRIBUTE_VALUE_ID
,      ATTRIBUTE_ID
,      ATTRIBUTE_VALUE
,      DESCRIPTION
,      HR_VALUE_ID
,      DATA_EXTRACT_ID
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      CONTEXT
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM PSB.PSB_ATTRIBUTE_VALUES;

Dependencies

[top of page]

PSB.PSB_ATTRIBUTE_VALUES does not reference any database object

PSB.PSB_ATTRIBUTE_VALUES is referenced by following:

APPS: PSB_ATTRIBUTE_VALUES