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

TABLE: PSB.PSB_PAY_ELEMENT_OPTIONS

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


PSB_PAY_ELEMENT_OPTIONS stores information about the different options
for a given pay element. Pay elements can have a single value or a
table of values. If the pay element is defined to have a table of
values, then options are defined in this table. If the pay element is a
salary element, then grades or grade steps are defined here.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PSB_PAY_ELEMENT_OPTIONS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPAY_ELEMENT_OPTION_ID
PSB_PAY_ELEMENT_OPTIONS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPAY_ELEMENT_ID
Columns
Name Datatype Length Mandatory Comments
PAY_ELEMENT_OPTION_ID NUMBER (20) Yes Pay element option unique identifier
PAY_ELEMENT_ID NUMBER (20) Yes Pay element identifier
NAME VARCHAR2 (80)
Element option name
GRADE_STEP NUMBER

Grade step for salary element
SEQUENCE_NUMBER NUMBER

Sequence number for the salary element step
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 PAY_ELEMENT_OPTION_ID
,      PAY_ELEMENT_ID
,      NAME
,      GRADE_STEP
,      SEQUENCE_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM PSB.PSB_PAY_ELEMENT_OPTIONS;

Dependencies

[top of page]

PSB.PSB_PAY_ELEMENT_OPTIONS does not reference any database object

PSB.PSB_PAY_ELEMENT_OPTIONS is referenced by following:

SchemaAPPS
SynonymPSB_PAY_ELEMENT_OPTIONS