DBA Data[Home] [Help] [Dependency Information]

TABLE: PSB.PSB_ELEMENT_POS_SET_GROUPS

Object Details
Object Name: PSB_ELEMENT_POS_SET_GROUPS
Object Type: TABLE
Owner: PSB
FND Design Data: TablePSB.PSB_ELEMENT_POS_SET_GROUPS
Subobject Name:
Status: VALID


PSB_ELEMENT_POS_SET_GROUPS stores the definition of the position set
groups. Position set groups are collections of one or more position
sets. Pay element distribution rules are defined for each position set
group.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PSB_ELEMENT_POS_SET_GROUPS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPOSITION_SET_GROUP_ID
PSB_ELEMENT_POS_SET_GROUPS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPAY_ELEMENT_ID
Columns
Name Datatype Length Mandatory Comments
POSITION_SET_GROUP_ID NUMBER (15) Yes Position set group unique identifier
NAME VARCHAR2 (100) Yes Name of the position set group
PAY_ELEMENT_ID NUMBER (15) Yes Pay element identifier
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 POSITION_SET_GROUP_ID
,      NAME
,      PAY_ELEMENT_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM PSB.PSB_ELEMENT_POS_SET_GROUPS;

Dependencies

[top of page]

PSB.PSB_ELEMENT_POS_SET_GROUPS does not reference any database object

PSB.PSB_ELEMENT_POS_SET_GROUPS is referenced by following:

SchemaAPPS
SynonymPSB_ELEMENT_POS_SET_GROUPS