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

TABLE: HR.PER_ENT_SECURITY_GROUPS

Object Details
Object Name: PER_ENT_SECURITY_GROUPS
Object Type: TABLE
Owner: HR
Subobject Name:
Status: VALID


This table stores information about organizations that are classified as enterprise.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PER_ENT_SECURITY_GROUPS_UK1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSECURITY_GROUP_ID
PER_ENT_SECURITY_GROUPS_UK2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGANIZATION_ID
PER_ENT_SECURITY_GROUPS_UK3 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnBUSINESS_GROUP_ID
ColumnENTERPRISE_LABEL
PER_ENT_SECURITY_GROUPS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnENTERPRISE_ID
Columns
Name Datatype Length Mandatory Comments
ENTERPRISE_ID NUMBER (15) Yes Enterprise Indentifier. This column is foreign Key to PER_ENTERPRISES.
ENTERPRISE_LABEL VARCHAR2 (4000) Yes Enterprise label.
BUSINESS_GROUP_ID NUMBER (15) Yes Business group id of the organization. Foreign key to HR_ALL_ORGANIZATION_UNITS.
SECURITY_GROUP_ID NUMBER (15) Yes Security group id of the security group corresponding to the organization. Foreign key to FND_SECURITY_GROUPS.
ORGANIZATION_ID NUMBER (15) Yes Organization id of the organization. Foreign key to HR_ALL_ORGANIZATION_UINITS.
ENABLED_FLAG VARCHAR2 (1) Yes Identifies whether the organization is an active enterprise.
Query Text

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


SELECT ENTERPRISE_ID
,      ENTERPRISE_LABEL
,      BUSINESS_GROUP_ID
,      SECURITY_GROUP_ID
,      ORGANIZATION_ID
,      ENABLED_FLAG
FROM HR.PER_ENT_SECURITY_GROUPS;

Dependencies

[top of page]

HR.PER_ENT_SECURITY_GROUPS does not reference any database object

HR.PER_ENT_SECURITY_GROUPS is referenced by following:

SchemaHR
ViewPER_ENT_SECURITY_GROUPS#