eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: HR.PER_IMAGES

Object Details

Object Name:	PER_IMAGES
Object Type:	TABLE
Owner:	HR
FND Design Data:	PER.PER_IMAGES
Subobject Name:
Status:	VALID

PER_IMAGES stores the images of any entity. It holds it by the entity
name and primary key of the entity.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PER_IMAGES_PK

IMAGE_ID

Unique Key: PER_IMAGES_UK2

TABLE_NAME
PARENT_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
PER_IMAGES_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	IMAGE_ID
PER_IMAGES_UK2	NORMAL	UNIQUE	APPS_TS_TX_IDX	TABLE_NAME PARENT_ID
SYS_IL0000043902C00004$$	LOB	UNIQUE	APPS_TS_TX_DATA

Columns

Name	Datatype	Length	Mandatory	Comments
IMAGE_ID	NUMBER	(15)	Yes	System generated unique identifier from PER_IMAGES_S.
PARENT_ID	NUMBER	(15)	Yes	Primary key of row for which image is held.
TABLE_NAME	VARCHAR2	(30)	Yes	Table holding row for which image is held.
IMAGE	BLOB	(4000)	Yes	The digitized image, held in TIFF, BMP, JFIF, PCX, PICT or other supported format.

Query Text

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


SELECT IMAGE_ID
,      PARENT_ID
,      TABLE_NAME
,      IMAGE
FROM HR.PER_IMAGES;

Dependencies

[top of page]

HR.PER_IMAGES does not reference any database object

HR.PER_IMAGES is referenced by following:

APPS: PER_IMAGES
PUBLIC: PER_IMAGES