[Home] [Help] [Dependency Information]
Object Name: | HR_COMMENTS |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | PER.HR_COMMENTS |
Subobject Name: | |
Status: | VALID |
HR_COMMENTS is a central repository for comments related to HRMS
objects.. Any comments which do not need to be DateTracked can be
held here to save space. An additional benefit of holding comments in
this way is that it facilitates the use of PLSQL stored procedures for
date-effective updates. .
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
HR_COMMENTS_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | COMMENT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COMMENT_ID | NUMBER | (15) | Yes | System-generated primary key column. |
SOURCE_TABLE_NAME | VARCHAR2 | (30) | Yes | Name of table that holds the related object for the comment. |
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. | ||
COMMENT_TEXT | LONG | (0) | Actual text of the comment. |
Cut, paste (and edit) the following text to query this object:
SELECT COMMENT_ID
, SOURCE_TABLE_NAME
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, COMMENT_TEXT
FROM HR.HR_COMMENTS;
HR.HR_COMMENTS does not reference any database object
HR.HR_COMMENTS is referenced by following:
|
|
|