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

TABLE: PSB.PSB_DEFAULTS

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


PSB_DEFAULTS stores information about position default rules. These
default rules are used to provide any missing information when
position data is extracted from Human Resource Management Systems. Any
time a new position is created, the default rules are used to supply
the default position assignments.
The default rules are assigned to position sets. Any position with
attributes that match the position set criteria inherits the
default rule.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PSB_DEFAULTS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnDEFAULT_RULE_ID
PSB_DEFAULTS_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnDATA_EXTRACT_ID
ColumnNAME
Columns
Name Datatype Length Mandatory Comments
DEFAULT_RULE_ID NUMBER (20) Yes Position default rule unique identifier
NAME VARCHAR2 (30) Yes Default rule name
GLOBAL_DEFAULT_FLAG VARCHAR2 (1)
Indicates if this is a global default rule
DATA_EXTRACT_ID NUMBER (15) Yes Data extract unique identifier. Defines only those elements which belong to this extract. Can be included in the default rule definition.
BUSINESS_GROUP_ID NUMBER (15) Yes Business group unique identifier
PRIORITY NUMBER

Processing priority for non-global default rules
ENTITY_ID NUMBER (15)
Unique identifier for the allocation rule which is created for FTE allocation
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
OVERWRITE VARCHAR2 (1)
The flag for default rules which distinguishes between overwrite and non overwrite power for default rules.
Query Text

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


SELECT DEFAULT_RULE_ID
,      NAME
,      GLOBAL_DEFAULT_FLAG
,      DATA_EXTRACT_ID
,      BUSINESS_GROUP_ID
,      PRIORITY
,      ENTITY_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      OVERWRITE
FROM PSB.PSB_DEFAULTS;

Dependencies

[top of page]

PSB.PSB_DEFAULTS does not reference any database object

PSB.PSB_DEFAULTS is referenced by following:

SchemaAPPS
SynonymPSB_DEFAULTS