[Home] [Help] [Dependency Information]
Object Name: | IGS_PE_PERSON_IMAGE |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_PE_PERSON_IMAGE |
Subobject Name: | |
Status: | VALID |
IGS_PE_PERSON_IMAGE contains a person's image.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_PE_PERSON_IMAGE_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PERSON_ID
IMAGE_DT |
SYS_IL0000197812C00009$$ | LOB | UNIQUE | APPS_TS_TX_DATA |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
PERSON_ID | NUMBER | (15) | Yes | A unique student information system identification number, typically incorporating a check digit, used to identify a particular person.. |
IMAGE_DT | DATE | Yes | This field is the date on which the image was captured. | |
PERSON_IMAGE | LONG RAW | (0) | No Longer Used | |
PERSON_IMAGE_LOB | BLOB | (4000) | Content of the Image, which is a binary LOB | |
IMAGE_CONTENT_TYPE | VARCHAR2 | (256) | Content type as specified during the uploading process. This string is an unparsed entity-header for the entity "Content-Type", and specifies the content type, and any additional parameters (such as character set) that describe the stored contents. This will remain NULL if the file is uploaded from Forms. | |
IMAGE_FILE_NAME | VARCHAR2 | (256) | Name for the file as provided during the uploading process |
Cut, paste (and edit) the following text to query this object:
SELECT CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, PERSON_ID
, IMAGE_DT
, PERSON_IMAGE
, PERSON_IMAGE_LOB
, IMAGE_CONTENT_TYPE
, IMAGE_FILE_NAME
FROM IGS.IGS_PE_PERSON_IMAGE;
IGS.IGS_PE_PERSON_IMAGE does not reference any database object
IGS.IGS_PE_PERSON_IMAGE is referenced by following:
|
|
|