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

TABLE: HR.HR_DM_GROUPS

Object Details
Object Name: HR_DM_GROUPS
Object Type: TABLE
Owner: HR
FND Design Data: TablePER.HR_DM_GROUPS
Subobject Name:
Status: VALID


This table holds information about the groupings used in the data migration process.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Primary Key: HR_DM_GROUPS_PK
  1. ColumnGROUP_ID
Indexes
Index Type Uniqueness Tablespace Column
HR_DM_GROUPS_PK NORMAL UNIQUE TablespaceAPPS_TS_INTERFACE ColumnGROUP_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
TableHR_DM_APPLICATION_GROUPS HR_DM_APPLICATION_GROUPS_FK1 HR_DM_GROUPS HR_DM_APPLICATION_GROUPS GROUP_ID
TableHR_DM_TABLE_GROUPINGS HR_DM_TABLE_GROUPINGS_FK1 HR_DM_GROUPS HR_DM_TABLE_GROUPINGS GROUP_ID
Columns
Name Datatype Length Mandatory Comments
GROUP_ID NUMBER (15) Yes System-generated primary key column.
DESCRIPTION VARCHAR2 (240)
Free text description.
GROUP_TYPE VARCHAR2 (1) Yes The type of data contained within the group which indicates which type of loader is required or if an item is applicable to the clean up phase
LAST_UPDATE_DATE DATE

Standard Who column.
LAST_UPDATED_BY NUMBER (15)
Standard Who column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column.
CREATED_BY NUMBER (15)
Standard Who column.
CREATION_DATE DATE

Standard Who column.
SECURITY_GROUP_ID NUMBER (15)
Foreign Key to FND_SECURITY_GROUPS.
Query Text

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


SELECT GROUP_ID
,      DESCRIPTION
,      GROUP_TYPE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      SECURITY_GROUP_ID
FROM HR.HR_DM_GROUPS;

Dependencies

[top of page]

HR.HR_DM_GROUPS does not reference any database object

HR.HR_DM_GROUPS is referenced by following:

SchemaHR
ViewHR_DM_GROUPS#