[Home] [Help]
View: IGWBV_GRNT_PRPSL_PERS_BIOSKTCH
| Product: | IGW - Grants Proposal (Obsolete) |
| Description: | |
| Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT LKUP1.MEANING
, BIOSKETCH.LINE_SEQUENCE
, BIOSKETCH.LINE_DESCRIPTION
, BIOSKETCH.ENABLE_FLAG
, BIOSKETCH.PERSON_BIOSKETCH_ID
, BIOSKETCH.PERSON_ID
, BIOSKETCH.LAST_UPDATE_DATE
, BIOSKETCH.LAST_UPDATED_BY
, BIOSKETCH.CREATION_DATE
, BIOSKETCH.CREATED_BY
FROM IGW_PERSON_BIOSKETCH BIOSKETCH
, IGW_LOOKUPS_V LKUP1
WHERE LKUP1.LOOKUP_CODE = BIOSKETCH.BIOSKETCH_TYPE
AND LKUP1.LOOKUP_TYPE = 'IGW_BIOSKETCH_TYPES' WITH READ ONLY
Columns
| Name |
| BIOSKETCH_TYPE |
| BIOSKETCH_LINE_SEQUENCE |
| BIOSKETCH_LINE |
| ENABLE_FLAG |
| PERSON_BIOSKETCH_ID |
| PERSON_ID |
| LAST_UPDATE_DATE |
| LAST_UPDATED_BY |
| CREATION_DATE |
| CREATED_BY |