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

TABLE: HR.HR_DM_COLUMN_DEFINITIONS

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


Table containing various Number Column Precision data. These Number Columns are populated using Sequences


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Primary Key: HR_DM_COLUMN_DEFINITIONS_PK
  1. ColumnCOLUMN_ID
Unique Key: HR_DM_COLUMN_DEFINITIONS_UK1
  1. ColumnCOLUMN_PRECISION
Indexes
Index Type Uniqueness Tablespace Column
HR_DM_COLUMN_DEFINITIONS_PK NORMAL UNIQUE TablespaceAPPS_TS_INTERFACE ColumnCOLUMN_ID
HR_DM_COLUMN_DEFINITIONS_UK1 NORMAL UNIQUE TablespaceAPPS_TS_INTERFACE ColumnCOLUMN_PRECISION
Foreign Keys
Table
Foreign Table Foreign Key Column
TableHR_DM_SEQUENCE_DEFINITIONS HR_DM_SEQUENCE_DEFINITIONS_FK1 HR_DM_COLUMN_DEFINITIONS HR_DM_SEQUENCE_DEFINITIONS COLUMN_ID
Columns
Name Datatype Length Mandatory Comments
COLUMN_ID NUMBER (15) Yes System-generated primary key column.
COLUMN_PRECISION NUMBER (15) Yes The precision or the total number of digits.
RANGE_SIZE NUMBER (30) Yes The next Range_Size for the particular column precision.
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.
Query Text

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


SELECT COLUMN_ID
,      COLUMN_PRECISION
,      RANGE_SIZE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM HR.HR_DM_COLUMN_DEFINITIONS;

Dependencies

[top of page]

HR.HR_DM_COLUMN_DEFINITIONS does not reference any database object

HR.HR_DM_COLUMN_DEFINITIONS is referenced by following:

SchemaHR
ViewHR_DM_COLUMN_DEFINITIONS#