[Home] [Help] [Dependency Information]
Object Name: | PER_EMPDIR_IMAGES |
---|---|
Object Type: | TABLE |
Owner: | HR |
Subobject Name: | |
Status: | VALID |
This table is used for storing images of entity 'PER_PEOPLE_F'. Used for displaying images in Employee Directory function.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PER_EMPDIR_IMAGES_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | IMAGE_ID |
PER_EMPDIR_IMAGES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
ORIG_SYSTEM_ID
ORIG_SYSTEM |
SYS_IL0000331028C00006$$ | LOB | UNIQUE | APPS_TS_TX_DATA |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
IMAGE_ID | NUMBER | (15) | Yes | Image Id. |
ORIG_SYSTEM | VARCHAR2 | (30) | Yes | stores constant value PER |
ORIG_SYSTEM_ID | NUMBER | (15) | Yes | per_images.parent_id, indirectly stores person_id |
IMAGE_NAME | VARCHAR2 | (60) | per_images.parent_id | |
CONTENT_TYPE | VARCHAR2 | (30) | currently stores null value. | |
IMAGE | BLOB | (4000) | per_images.image | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | System-generated version of row. Increments by one with each update. | |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT IMAGE_ID
, ORIG_SYSTEM
, ORIG_SYSTEM_ID
, IMAGE_NAME
, CONTENT_TYPE
, IMAGE
, OBJECT_VERSION_NUMBER
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
FROM HR.PER_EMPDIR_IMAGES;
HR.PER_EMPDIR_IMAGES does not reference any database object
HR.PER_EMPDIR_IMAGES is referenced by following:
|
|
|