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


TABLE: HR.HR_TIPS

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


Help components used within SSHR. Used for displaying tips in mod pl/sql based modules. This is not currently used in R12.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Primary Key: HR_TIPS_PK
  1. ColumnTIP_ID
Unique Key: HR_TIPS_UK1
  1. ColumnSCREEN
  2. ColumnFIELD
  3. ColumnLANGUAGE_CODE
  4. ColumnBUSINESS_GROUP_ID
Indexes
Index Type Uniqueness Tablespace Column
HR_TIPS_UK1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnSCREEN
ColumnFIELD
ColumnLANGUAGE_CODE
ColumnBUSINESS_GROUP_ID
HR_TIPS_FK1 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnBUSINESS_GROUP_ID
HR_TIPS_PK NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnTIP_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
HR_TIPS HR_TIPS_FK1 TableHR_ALL_ORGANIZATION_UNITS HR_TIPS BUSINESS_GROUP_ID
Columns
Name Datatype Length Mandatory Comments
TIP_ID NUMBER (15) Yes System generated primary key from HR_TIPS_S.
FILENAME VARCHAR2 (8) Yes Name of the file that the tip was loaded from.
SCREEN VARCHAR2 (30) Yes Name of the screen that the tip is valid for.
FIELD VARCHAR2 (30) Yes Name of the field that this tip is for.
LANGUAGE_CODE VARCHAR2 (4) Yes Language code that the tip is valid for.
BUSINESS_GROUP_ID NUMBER (15)
Foreign key to HR_ORGANIZATION_UNITS.
ENABLED_FLAG VARCHAR2 (1) Yes Flag that indicates if this tip is enabled.
TEXT LONG (0)
Tip text.
Query Text

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


SELECT TIP_ID
,      FILENAME
,      SCREEN
,      FIELD
,      LANGUAGE_CODE
,      BUSINESS_GROUP_ID
,      ENABLED_FLAG
,      TEXT
FROM HR.HR_TIPS;

Dependencies

[top of page]

HR.HR_TIPS does not reference any database object

HR.HR_TIPS is referenced by following:

SchemaAPPS
SynonymHR_TIPS
SchemaPUBLIC
SynonymHR_TIPS