DBA Data[Home] [Help] [Dependency Information]

TABLE: IGW.IGW_PROP_PERSON_SUPPORT

Object Details
Object Name: IGW_PROP_PERSON_SUPPORT
Object Type: TABLE
Owner: IGW
FND Design Data: TableIGW.IGW_PROP_PERSON_SUPPORT
Subobject Name:
Status: VALID


IGW_PROP_PERSON_SUPPORT stores information about other sources of support
available or pending for personnel on a proposal. It also stores information about sponsors, award or proposal amount, and the Proposal Manager for the support.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGW_PROP_PERSON_SUPPORT_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROP_PERSON_SUPPORT_ID
Columns
Name Datatype Length Mandatory Comments
PROP_PERSON_SUPPORT_ID NUMBER (15) Yes Proposal person other support identifier
PROPOSAL_ID NUMBER (15) Yes Proposal identifier
PERSON_ID NUMBER (15)
Person identifier
SUPPORT_TYPE VARCHAR2 (30) Yes Type of support for award or proposal. Possible values are P for Pending, A for Active, and L for awards completed in the last three years.
PROPOSAL_AWARD_ID NUMBER (15)
Proposal or award identifier
PROPOSAL_AWARD_NUMBER VARCHAR2 (30)
Proposal or award number
PROPOSAL_AWARD_TITLE VARCHAR2 (250)
Proposal or award title
PI_PERSON_ID NUMBER (15)
Principle investigator identifier for proposal or award under consideration
SPONSOR_ID NUMBER (15)
Sponsor identifier
PROJECT_LOCATION VARCHAR2 (100)
Performing site
START_DATE DATE

First effective date of award or proposal
END_DATE DATE

Last effective date of award or proposal
PERCENT_EFFORT NUMBER (5)
Percent effort by the person for the proposal or award
MAJOR_GOALS VARCHAR2 (250)
Major goals of the proposal
OVERLAP VARCHAR2 (250)
If other support proposal or award has any overlap with the proposal, then the nature of the overlap is reported here.
ANNUAL_DIRECT_COST NUMBER (15)
Direct cost for the proposal or award
TOTAL_COST NUMBER (15)
Total cost for the proposal or award
CALENDAR_START_DATE DATE

Calendar start date of work on the proposal or award by person
CALENDAR_END_DATE DATE

Calendar end date of work on the proposal or award by person
ACADEMIC_START_DATE DATE

Academic start date of work on the proposal or award by person
ACADEMIC_END_DATE DATE

Academic end date of work on the proposal or award by person
SUMMER_START_DATE DATE

Summer start date of work on the proposal or award by person
SUMMER_END_DATE DATE

Summer end date of work on the proposal or award by person
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
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield structure defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment
RECORD_VERSION_NUMBER NUMBER
Yes Locking sequence number
PARTY_ID NUMBER (15) Yes Party identifier for person
SEQUENCE_NUMBER NUMBER (5)
Other Support Sequence Number
PI_PARTY_ID NUMBER (15)
Party identifier for Prinicipal investigator
LOCATION_PARTY_ID NUMBER (15)
Party identifier for organization
PROPOSAL_SHORT_TITLE VARCHAR2 (150)
Proposal Short Title
COMMENTS VARCHAR2 (250)
Comments pertaining to this support.
AUTOMATIC_FLAG VARCHAR2 (1)
This indicates whether other support has been automatically generated by system or manually entered. Valid values are Y and N.
ROLE_CODE VARCHAR2 (30)
The role of the person in the support under consideration.
SPONSOR_APPLICATION_NUMBER VARCHAR2 (50)
Sponsor Application Number
PI_NAME VARCHAR2 (360)
Name of principle investigator for the support under consideration.
SPONSOR_NAME VARCHAR2 (360)
Name of sponsor for the support under consideration.
AWARD_NUMBER VARCHAR2 (15)
Award number for the support under consideration.
Query Text

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


SELECT PROP_PERSON_SUPPORT_ID
,      PROPOSAL_ID
,      PERSON_ID
,      SUPPORT_TYPE
,      PROPOSAL_AWARD_ID
,      PROPOSAL_AWARD_NUMBER
,      PROPOSAL_AWARD_TITLE
,      PI_PERSON_ID
,      SPONSOR_ID
,      PROJECT_LOCATION
,      START_DATE
,      END_DATE
,      PERCENT_EFFORT
,      MAJOR_GOALS
,      OVERLAP
,      ANNUAL_DIRECT_COST
,      TOTAL_COST
,      CALENDAR_START_DATE
,      CALENDAR_END_DATE
,      ACADEMIC_START_DATE
,      ACADEMIC_END_DATE
,      SUMMER_START_DATE
,      SUMMER_END_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      RECORD_VERSION_NUMBER
,      PARTY_ID
,      SEQUENCE_NUMBER
,      PI_PARTY_ID
,      LOCATION_PARTY_ID
,      PROPOSAL_SHORT_TITLE
,      COMMENTS
,      AUTOMATIC_FLAG
,      ROLE_CODE
,      SPONSOR_APPLICATION_NUMBER
,      PI_NAME
,      SPONSOR_NAME
,      AWARD_NUMBER
FROM IGW.IGW_PROP_PERSON_SUPPORT;

Dependencies

[top of page]

IGW.IGW_PROP_PERSON_SUPPORT does not reference any database object

IGW.IGW_PROP_PERSON_SUPPORT is referenced by following:

SchemaAPPS
SynonymIGW_PROP_PERSON_SUPPORT