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_ATTRIBUTES

Object Details

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

PSB_ATTRIBUTES stores information about the position attributes that
are relevant in Oracle Public Sector Budgeting. This table contains
the meta data for each of the attributes.
If Oracle Human Resource Management Systems is used then the
attributes for a given position can be stored in different places like
Key Flexfield, Descriptive Flexfield, QuickCodes, or other tables
based on the configuration of Oracle Human Resource Management
Systems. This table is used to define where attribute information
can be retrieved from Oracle Human Resource Management Systems.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PSB_ATTRIBUTES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ATTRIBUTE_ID
PSB_ATTRIBUTES_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	NAME BUSINESS_GROUP_ID
PSB_ATTRIBUTES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BUSINESS_GROUP_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ATTRIBUTE_ID	NUMBER	(20)	Yes	Position attribute unique identifier
NAME	VARCHAR2	(30)		Position attribute name
BUSINESS_GROUP_ID	NUMBER	(20)	Yes	Business group identifier
DISPLAY_IN_WORKSHEET	VARCHAR2	(1)		Flag indicates if this attribute is displayed in the summary block of position worksheet
DISPLAY_SEQUENCE	NUMBER			Sequence order in the Position Worksheet window
DISPLAY_PROMPT	VARCHAR2	(30)		Prompt to be displayed for this position attribute
REQUIRED_FOR_IMPORT_FLAG	VARCHAR2	(1)		Flag indicates if a value must be assigned to this attribute before a position can be imported from Human Resource Management Systems
REQUIRED_FOR_POSITIONS_FLAG	VARCHAR2	(1)		Flag indicates if this attribute is required when defining a position
ALLOW_IN_POSITION_SET_FLAG	VARCHAR2	(1)		Allow in position set flag. Determines whether the attribute can be used in a position set or not. If not, modify worksheet module can use the attribute when changing position assignments.
VALUE_TABLE_FLAG	VARCHAR2	(1)		Flag indicates if there is a value set table for this attribute
APPLICATION_ID	NUMBER	(15)		Application to which the Key or Descriptive Flexfield belongs
DEFINITION_TYPE	VARCHAR2	(10)		Source for the column. Source is Key Flexfield, Descriptive Flexfield, Quick Codes, or Other.
DEFINITION_STRUCTURE	VARCHAR2	(30)		Key Flexfield name, Descriptive Flexfield name, or Quick Code type
DEFINITION_TABLE	VARCHAR2	(30)		Key or Descriptive Flexfield structure where the attribute is stored in Human Resource Management Systems
DEFINITION_COLUMN	VARCHAR2	(30)		Segment column with the flexfield structure where the attribute is stored in Human Resource Management Systems
ATTRIBUTE_TYPE_ID	NUMBER			Attribute type identifier. Attribute type provides information regarding how to extract information from Human Resource Management Systems.
DATA_TYPE	VARCHAR2	(1)		Data type of the attribute. Data type is C (CHAR), D (DATE), or N (NUMBER).
SYSTEM_ATTRIBUTE_TYPE	VARCHAR2	(30)		System name assigned to the attributes. This is assigned only for attributes created by Oracle development.
PROTECTED_FLAG	VARCHAR2	(1)		Flag indicates if the definitions can be modified by the users
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_ID
,      NAME
,      BUSINESS_GROUP_ID
,      DISPLAY_IN_WORKSHEET
,      DISPLAY_SEQUENCE
,      DISPLAY_PROMPT
,      REQUIRED_FOR_IMPORT_FLAG
,      REQUIRED_FOR_POSITIONS_FLAG
,      ALLOW_IN_POSITION_SET_FLAG
,      VALUE_TABLE_FLAG
,      APPLICATION_ID
,      DEFINITION_TYPE
,      DEFINITION_STRUCTURE
,      DEFINITION_TABLE
,      DEFINITION_COLUMN
,      ATTRIBUTE_TYPE_ID
,      DATA_TYPE
,      SYSTEM_ATTRIBUTE_TYPE
,      PROTECTED_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM PSB.PSB_ATTRIBUTES;

Dependencies

[top of page]

PSB.PSB_ATTRIBUTES does not reference any database object

PSB.PSB_ATTRIBUTES is referenced by following:

APPS: PSB_ATTRIBUTES