[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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 |
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;
IGW.IGW_PROPOSALS_ALL does not reference any database object
IGW.IGW_PROPOSALS_ALL is referenced by following:
|
|
|