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: IGW.IGW_PERSON_BIOSKETCH

Object Details

Object Name:	IGW_PERSON_BIOSKETCH
Object Type:	TABLE
Owner:	IGW
FND Design Data:	IGW.IGW_PERSON_BIOSKETCH
Subobject Name:
Status:	VALID

IGW_PERSON_BIOSKETCH stores information about a person's biosketch background.
Biosketch type is seeded with the values experience, honors, memberships, and publications. These values are used to categorize the information in the biosketch. ENABLE_FLAG determines whether a particular biosketch line is included in the person's biosketch or left out.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGW_PERSON_BIOSKETCH_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PERSON_BIOSKETCH_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_BIOSKETCH_ID	NUMBER	(10)	Yes	Person's biosketch identifier
PERSON_ID	NUMBER	(15)		Person identifier
BIOSKETCH_TYPE	VARCHAR2	(30)	Yes	Biosketch type. Values are taken from the lookups IGW_BIOSKETCH_TYPES.
LINE_SEQUENCE	NUMBER	(4)	Yes	Biosketch line sequence that is system-generated
LINE_DESCRIPTION	VARCHAR2	(500)	Yes	Biosketch line description
ENABLE_FLAG	VARCHAR2	(1)	Yes	Flag that determines whether the line is shown in the proposal. Possible values are Y and N.
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard Who column
PARTY_ID	NUMBER	(15)	Yes	Party identifier for person
RECORD_VERSION_NUMBER	NUMBER	(15)		Record version number for locking purposes.

Query Text

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


SELECT PERSON_BIOSKETCH_ID
,      PERSON_ID
,      BIOSKETCH_TYPE
,      LINE_SEQUENCE
,      LINE_DESCRIPTION
,      ENABLE_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      PARTY_ID
,      RECORD_VERSION_NUMBER
FROM IGW.IGW_PERSON_BIOSKETCH;

Dependencies

[top of page]

IGW.IGW_PERSON_BIOSKETCH does not reference any database object

IGW.IGW_PERSON_BIOSKETCH is referenced by following:

APPS: IGW_PERSON_BIOSKETCH