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_PROPOSALS_ALL

Object Details

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

IGW_PROPOSALS_ALL stores core information about proposals. Stored information includes proposal title, proposal start and end dates, applicant organization, applicant unit, and sponsor.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGW_PROPOSALS_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PROPOSAL_ID
IGW_PROPOSALS_ALL_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	PROPOSAL_NUMBER
SYS_IL0000099427C00082$$	LOB	UNIQUE	APPS_TS_TX_DATA
IGW_PROPOSALS_ALL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARENT_PROPOSAL_ID
IGW_PROPOSALS_ALL_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORIGINAL_PROPOSAL_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PROPOSAL_ID	NUMBER	(15)	Yes	Proposal identifier
PROPOSAL_NUMBER	VARCHAR2	(30)	Yes	Proposal number that uniquely identifies the proposal. Proposal number can be user-entered or system-generated as defined in the implementation options.
LEAD_ORGANIZATION_ID	NUMBER	(15)		Applicant unit identifier. It is a foreign key to HR_ALL_ORGANIZATION_UNITS.
ORG_ID	NUMBER	(15)		Operating unit identifier for multi-organization installations
PROPOSAL_STATUS	VARCHAR2	(1)		Status of the proposal. Possible values are P for In Progress, I for Approval In-Progress, A for Approved, and R for Rejected.
PROPOSAL_START_DATE	DATE		Yes	Proposal start date
PROPOSAL_END_DATE	DATE		Yes	Proposal end date
PROPOSAL_TITLE	VARCHAR2	(250)		Detailed title of the proposal
PROPOSAL_TYPE_CODE	VARCHAR2	(30)	Yes	Type of proposal. The code is taken from IGW_PROPOSAL_TYPES lookup.
AWARD_NUMBER	VARCHAR2	(15)		Sponsor-assigned number used to identify funded proposal
AWARD_AMOUNT	NUMBER	(15)		Amount awarded by the sponsor for the proposal
ORIGINAL_PROPOSAL_NUMBER	VARCHAR2	(30)		Proposal number of the original proposal. Relevant for a continuation or a renewal.
ORIGINAL_AWARD_NUMBER	VARCHAR2	(15)		Award number of the original proposal. Relevant for a continuation or a renewal.
ORIGINAL_PROPOSAL_START_DATE	DATE			Original start date of the proposal. Relevant for a continuation or a renewal.
ORIGINAL_PROPOSAL_END_DATE	DATE			Original end date of the proposal. Relevant for a continuation or a renewal.
ACTIVITY_TYPE_CODE	VARCHAR2	(30)	Yes	Type of activity. The code is taken from IGW_ACTIVITY_TYPES lookup.
SPONSOR_ID	NUMBER	(15)		Sponsor identifier
FUNDING_SPONSOR_UNIT	VARCHAR2	(45)		Unit of the sponsoring agency that evaluates and funds the proposal
ORIGINAL_SPONSOR_ID	NUMBER	(15)		Sponsor that ultimately funds the proposal
NOTICE_OF_OPPORTUNITY_CODE	VARCHAR2	(30)		Source of research opportunity information. The code is taken from IGW_OPPORTUNITY_NOTICE_TYPES lookup.
PROGRAM_NUMBER	VARCHAR2	(30)		Program number of the funding opportunity
PROGRAM_TITLE	VARCHAR2	(250)		Program title as mentioned in the notice of opportunity
PROGRAM_URL	VARCHAR2	(240)		URL of the RFA or RFP
SPONSOR_PROPOSAL_NUMBER	VARCHAR2	(30)		Proposal number as mentioned in the Sponsor's RFA or RFP
SPONSOR_ACTION_CODE	VARCHAR2	(30)		Action taken by the sponsor on the proposal. The code is taken from IGW_SPONSOR_ACTION_CODE lookup.
SPONSOR_ACTION_DATE	DATE			Date on which action has been taken by the sponsor
SUBMITTING_ORGANIZATION_ID	NUMBER	(15)		Identifier for the organization that submits the application to the sponsor
SIGNING_OFFICIAL_ID	NUMBER	(15)		Identifier of person who signs proposal on behalf of applicant organization
ADMIN_OFFICIAL_ID	NUMBER	(15)		Identifier of person who approves proposal on behalf of applicant unit
DEADLINE_DATE	DATE			Last date for proposal submission
DEADLINE_TYPE	VARCHAR2	(1)		Type of deadline for proposal submission. Possible values are P for Postmark and R for Receipt.
LETTER_OF_INTENT_DUE_DATE	DATE			Last date for submission of letter of intent
EDI_GENERATED_DATE	DATE			Date on which EDI is generated
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	Field for storing locking sequence number
SPONSOR_ACTION_COMMENTS	VARCHAR2	(3800)		Comments regarding action taken by the sponsor
NARRATIVE_TYPE_CODE	VARCHAR2	(30)		Type of narrative. The code is taken from IGW_NARRATIVE_TYPES lookup.
NARRATIVE_SUBMISSION_CODE	VARCHAR2	(30)		Narrative submission code. The code is taken from IGW_NARRATIVE_SUBMISS_TYPES lookup.
FUNDED_DIRECT_COST	NUMBER			Direct Cost Amount funded by the sponsor
FUNDED_INDIRECT_COST	NUMBER			Indirect Cost Amount funded by the sponsor
PROPOSAL_SHORT_TITLE	VARCHAR2	(150)		Short Title of Proposal
PROPOSAL_CATEGORY_CODE	VARCHAR2	(30)		Proposal Category Code.
PROGRAM_TYPE_CODE	VARCHAR2	(30)		Program Type Code.
PROPOSAL_MANAGER_ID	NUMBER	(15)		Party Identifier of Proposal Manager
PROGRAM_MANAGER_ID	NUMBER	(15)		Party Identifier of Program Manager
SPONSOR_APPLICATION_NUMBER	VARCHAR2	(50)		Sponsor Application Number
IGW_MODE	VARCHAR2	(30)		Grants Proposal Installation Mode
SUBMITTING_PARTY_ID	NUMBER	(15)		Party Identifier of Submitting Organization
APPLICANT_UNIT_NAME	VARCHAR2	(300)		Applicant Unit Name
PROPOSAL_PURPOSE_CODE	VARCHAR2	(30)		Proposal Purpose Code
SIGNING_OFFICIAL_PARTY_ID	NUMBER	(15)		Party Identifier of Signing Official
ADMIN_OFFICIAL_PARTY_ID	NUMBER	(15)		Party Identifier of Administrative Official
PROPOSAL_URL	VARCHAR2	(240)		URL related to the proposed work
ORIGINAL_PROPOSAL_ID	NUMBER	(15)		Proposal Identifier for continuation proposals
PARENT_PROPOSAL_ID	NUMBER	(15)		Proposal Identifier for related proposals
TOTAL_AMOUNT	NUMBER	(15)		Sum of Funded Indrect Cost and Funded Direct Cost
SECURITY_CLASSIFICATION_CODE	VARCHAR2	(30)		Security classifcation code of the Proposal
CROSS_CUT_TYPE_CODE	VARCHAR2	(30)		Proposal Cross Cut Type Code
PROGRAM_CATEGORY	VARCHAR2	(2000)		Program Category Name
PACKAGE_ID	NUMBER	(15)		Application Forms Package Identifier
GRANTOR_APPROVAL_STATUS	VARCHAR2	(30)		Grantor Approval Status
XML_CLOB	CLOB	(4000)		XML file generated for reporting
EXTERNAL_APPLICANT_UNIT_ID	NUMBER	(15)		External Grantee Applicant Unit Identifier

Query Text

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


SELECT PROPOSAL_ID
,      PROPOSAL_NUMBER
,      LEAD_ORGANIZATION_ID
,      ORG_ID
,      PROPOSAL_STATUS
,      PROPOSAL_START_DATE
,      PROPOSAL_END_DATE
,      PROPOSAL_TITLE
,      PROPOSAL_TYPE_CODE
,      AWARD_NUMBER
,      AWARD_AMOUNT
,      ORIGINAL_PROPOSAL_NUMBER
,      ORIGINAL_AWARD_NUMBER
,      ORIGINAL_PROPOSAL_START_DATE
,      ORIGINAL_PROPOSAL_END_DATE
,      ACTIVITY_TYPE_CODE
,      SPONSOR_ID
,      FUNDING_SPONSOR_UNIT
,      ORIGINAL_SPONSOR_ID
,      NOTICE_OF_OPPORTUNITY_CODE
,      PROGRAM_NUMBER
,      PROGRAM_TITLE
,      PROGRAM_URL
,      SPONSOR_PROPOSAL_NUMBER
,      SPONSOR_ACTION_CODE
,      SPONSOR_ACTION_DATE
,      SUBMITTING_ORGANIZATION_ID
,      SIGNING_OFFICIAL_ID
,      ADMIN_OFFICIAL_ID
,      DEADLINE_DATE
,      DEADLINE_TYPE
,      LETTER_OF_INTENT_DUE_DATE
,      EDI_GENERATED_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
,      SPONSOR_ACTION_COMMENTS
,      NARRATIVE_TYPE_CODE
,      NARRATIVE_SUBMISSION_CODE
,      FUNDED_DIRECT_COST
,      FUNDED_INDIRECT_COST
,      PROPOSAL_SHORT_TITLE
,      PROPOSAL_CATEGORY_CODE
,      PROGRAM_TYPE_CODE
,      PROPOSAL_MANAGER_ID
,      PROGRAM_MANAGER_ID
,      SPONSOR_APPLICATION_NUMBER
,      IGW_MODE
,      SUBMITTING_PARTY_ID
,      APPLICANT_UNIT_NAME
,      PROPOSAL_PURPOSE_CODE
,      SIGNING_OFFICIAL_PARTY_ID
,      ADMIN_OFFICIAL_PARTY_ID
,      PROPOSAL_URL
,      ORIGINAL_PROPOSAL_ID
,      PARENT_PROPOSAL_ID
,      TOTAL_AMOUNT
,      SECURITY_CLASSIFICATION_CODE
,      CROSS_CUT_TYPE_CODE
,      PROGRAM_CATEGORY
,      PACKAGE_ID
,      GRANTOR_APPROVAL_STATUS
,      XML_CLOB
,      EXTERNAL_APPLICANT_UNIT_ID
FROM IGW.IGW_PROPOSALS_ALL;

Dependencies

[top of page]

IGW.IGW_PROPOSALS_ALL does not reference any database object

IGW.IGW_PROPOSALS_ALL is referenced by following:

APPS: IGW_PROPOSALS_ALL