[Home] [Help]
[Dependency Information]
| Object Name: | IGW_PRPO_BIOSKETCH_DEGREES_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | IGW.IGW_PRPO_BIOSKETCH_DEGREES_V
|
| Subobject Name: | |
| Status: | VALID |
A Business Intelligence System view
IGW_PRPO_BIOSKETCH_DEGREES_V displays a person's educational background. This information includes date of graduation, degree type, and area of specialization. This view is used in generating a flat file for Electronic Data Interchange.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PROPOSAL_ID | NUMBER | (15) | Yes | |
| PERSON_ID | NUMBER | (15) | ||
| PARTY_ID | NUMBER | (15) | Yes | |
| DEGREE_CODE | VARCHAR2 | (30) | Yes | |
| DEGREE_TIME_PERIOD | DATE | Yes | ||
| DEGREE_DESCRIPTION | VARCHAR2 | (80) | Yes | |
| FIELD_OF_STUDY | VARCHAR2 | (80) | ||
| AREA_OF_SPECIALIZATION | VARCHAR2 | (80) | ||
| EDUCATIONAL_INSTITUTION | VARCHAR2 | (100) | ||
| BIO_DEGREE_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
| BIO_DEGREE_ATTRIBUTE1 | VARCHAR2 | (150) | ||
| BIO_DEGREE_ATTRIBUTE2 | VARCHAR2 | (150) | ||
| BIO_DEGREE_ATTRIBUTE3 | VARCHAR2 | (150) | ||
| BIO_DEGREE_ATTRIBUTE4 | VARCHAR2 | (150) | ||
| BIO_DEGREE_ATTRIBUTE5 | VARCHAR2 | (150) | ||
| BIO_DEGREE_ATTRIBUTE6 | VARCHAR2 | (150) | ||
| BIO_DEGREE_ATTRIBUTE7 | VARCHAR2 | (150) | ||
| BIO_DEGREE_ATTRIBUTE8 | VARCHAR2 | (150) | ||
| BIO_DEGREE_ATTRIBUTE9 | VARCHAR2 | (150) | ||
| BIO_DEGREE_ATTRIBUTE10 | VARCHAR2 | (150) | ||
| BIO_DEGREE_ATTRIBUTE11 | VARCHAR2 | (150) | ||
| BIO_DEGREE_ATTRIBUTE12 | VARCHAR2 | (150) | ||
| BIO_DEGREE_ATTRIBUTE13 | VARCHAR2 | (150) | ||
| BIO_DEGREE_ATTRIBUTE14 | VARCHAR2 | (150) | ||
| BIO_DEGREE_ATTRIBUTE15 | VARCHAR2 | (150) |
Cut, paste (and edit) the following text to query this object:
SELECT PROPOSAL_ID
, PERSON_ID
, PARTY_ID
, DEGREE_CODE
, DEGREE_TIME_PERIOD
, DEGREE_DESCRIPTION
, FIELD_OF_STUDY
, AREA_OF_SPECIALIZATION
, EDUCATIONAL_INSTITUTION
, BIO_DEGREE_ATTRIBUTE_CATEGORY
, BIO_DEGREE_ATTRIBUTE1
, BIO_DEGREE_ATTRIBUTE2
, BIO_DEGREE_ATTRIBUTE3
, BIO_DEGREE_ATTRIBUTE4
, BIO_DEGREE_ATTRIBUTE5
, BIO_DEGREE_ATTRIBUTE6
, BIO_DEGREE_ATTRIBUTE7
, BIO_DEGREE_ATTRIBUTE8
, BIO_DEGREE_ATTRIBUTE9
, BIO_DEGREE_ATTRIBUTE10
, BIO_DEGREE_ATTRIBUTE11
, BIO_DEGREE_ATTRIBUTE12
, BIO_DEGREE_ATTRIBUTE13
, BIO_DEGREE_ATTRIBUTE14
, BIO_DEGREE_ATTRIBUTE15
FROM APPS.IGW_PRPO_BIOSKETCH_DEGREES_V;
APPS
IGW_PERSON_DEGREES
IGW_PROP_PERSON_DEGREES
APPS.IGW_PRPO_BIOSKETCH_DEGREES_V is not referenced by any database object
|
|
|
|