Oracle eBusiness Suite Technical Reference

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - IGW Tables and Views

TABLE - IGW.IGW_AWARDS
TABLE - IGW.IGW_AWARD_BUDGETS
TABLE - IGW.IGW_AWARD_BUDGET_HISTORY
TABLE - IGW.IGW_BUDGETS
TABLE - IGW.IGW_BUDGET_DETAILS
TABLE - IGW.IGW_BUDGET_DETAILS_CAL_AMTS
TABLE - IGW.IGW_BUDGET_PERIODS
TABLE - IGW.IGW_BUDGET_PERSONNEL_CAL_AMTS
TABLE - IGW.IGW_BUDGET_PERSONNEL_DETAILS
TABLE - IGW.IGW_BUDGET_PERSONS
TABLE - IGW.IGW_BUSINESS_RULES_ALL
TABLE - IGW.IGW_BUSINESS_RULE_LINES
TABLE - IGW.IGW_EXPENDITURE_CATEGORIES
TABLE - IGW.IGW_EXPENDITURE_TYPES
TABLE - IGW.IGW_EXP_TYPE_RATE_TYPES
TABLE - IGW.IGW_IMPLEMENTATIONS_ALL
TABLE - IGW.IGW_INSTALLMENTS
TABLE - IGW.IGW_INSTITUTE_RATES
TABLE - IGW.IGW_ORG_DETAILS
TABLE - IGW.IGW_ORG_MAPS_ALL
TABLE - IGW.IGW_ORG_MAP_DETAILS
TABLE - IGW.IGW_ORG_QUESTIONS
TABLE - IGW.IGW_ORG_TYPES
TABLE - IGW.IGW_PERSON_BIOSKETCH
TABLE - IGW.IGW_PERSON_DEGREES
TABLE - IGW.IGW_PROJECT_FUNDINGS
TABLE - IGW.IGW_PROPOSALS_ALL
TABLE - IGW.IGW_PROP_ABSTRACTS
TABLE - IGW.IGW_PROP_APPROVAL_RUNS
TABLE - IGW.IGW_PROP_CHECKLIST
TABLE - IGW.IGW_PROP_COMMENTS
TABLE - IGW.IGW_PROP_COMPONENT_STATUSES
TABLE - IGW.IGW_PROP_LOCATIONS
TABLE - IGW.IGW_PROP_MAPS
TABLE - IGW.IGW_PROP_MAP_STOPS
TABLE - IGW.IGW_PROP_NARRATIVES
TABLE - IGW.IGW_PROP_PERSONS
TABLE - IGW.IGW_PROP_PERSON_BIOSKETCH
TABLE - IGW.IGW_PROP_PERSON_DEGREES
TABLE - IGW.IGW_PROP_PERSON_QUESTIONS
TABLE - IGW.IGW_PROP_PERSON_SUPPORT
TABLE - IGW.IGW_PROP_PROGRAM_ADDRESSES
TABLE - IGW.IGW_PROP_QUESTIONS
TABLE - IGW.IGW_PROP_RATES
TABLE - IGW.IGW_PROP_SCIENCE_CODES
TABLE - IGW.IGW_PROP_SPECIAL_REVIEWS
TABLE - IGW.IGW_PROP_USERS
TABLE - IGW.IGW_PROP_USER_ROLES
TABLE - IGW.IGW_QUESTIONS
TABLE - IGW.IGW_QUESTIONS_TL
TABLE - IGW.IGW_RATE_CLASSES
TABLE - IGW.IGW_RATE_TYPES
TABLE - IGW.IGW_REPORT_BUDGET
TABLE - IGW.IGW_REPORT_BUDGET_BASE_RATE
TABLE - IGW.IGW_REPORT_BUDGET_SEED
TABLE - IGW.IGW_REPORT_BUDG_JUSTIFICATION
TABLE - IGW.IGW_REPORT_ITEMIZED_BUDGET
TABLE - IGW.IGW_REPORT_Q_EXPLANATION
TABLE - IGW.IGW_ROLES
TABLE - IGW.IGW_ROLES_TL
TABLE - IGW.IGW_ROLE_RIGHTS
TABLE - IGW.IGW_SCIENCE_CODES
TABLE - IGW.IGW_STUDY_TITLES
TABLE - IGW.IGW_SUBJECT_INFORMATION
VIEW - APPS.IGWBV_GRANT_KEYWORD
VIEW - APPS.IGWBV_GRANT_PROPOSAL
VIEW - APPS.IGWBV_GRANT_PROPOSAL_APPROVAL
VIEW - APPS.IGWBV_GRANT_PROPOSAL_BDGT_LINE
VIEW - APPS.IGWBV_GRANT_PROPOSAL_EXP_TYPE
VIEW - APPS.IGWBV_GRANT_PROPOSAL_KEYWORD
VIEW - APPS.IGWBV_GRANT_PROPOSAL_NARRATIVE
VIEW - APPS.IGWBV_GRANT_PROPOSAL_OVRD_RATE
VIEW - APPS.IGWBV_GRANT_PROPOSAL_PERS_ASGN
VIEW - APPS.IGWBV_GRANT_PROPOSAL_RATE
VIEW - APPS.IGWBV_GRANT_PROPOSAL_RATE_TYPE
VIEW - APPS.IGWBV_GRANT_PRPSL_BDGT_LIN_AMT
VIEW - APPS.IGWBV_GRANT_PRPSL_BDGT_PERSON
VIEW - APPS.IGWBV_GRANT_PRPSL_BDGT_VERSION
VIEW - APPS.IGWBV_GRANT_PRPSL_EXP_CATEGORY
VIEW - APPS.IGWBV_GRANT_PRPSL_RATE_CLASS
VIEW - APPS.IGWBV_GRANT_PRPSL_ROUTING_LIST
VIEW - APPS.IGWBV_GRANT_PRPSL_ROUTING_RULE
VIEW - APPS.IGWBV_GRANT_PRPSL_SUPPRT_TEXT
VIEW - APPS.IGWBV_GRNT_PERS_CERT_ANSWER
VIEW - APPS.IGWBV_GRNT_PRPSL_APRVL_LST_MBR
VIEW - APPS.IGWBV_GRNT_PRPSL_APRV_APVL_LST
VIEW - APPS.IGWBV_GRNT_PRPSL_BDGT_LIN_PERS
VIEW - APPS.IGWBV_GRNT_PRPSL_BDGT_PERS_AMT
VIEW - APPS.IGWBV_GRNT_PRPSL_BUDGT_PERIOD
VIEW - APPS.IGWBV_GRNT_PRPSL_CERT_ANSWER
VIEW - APPS.IGWBV_GRNT_PRPSL_CERT_QUESTION
VIEW - APPS.IGWBV_GRNT_PRPSL_COMMENT
VIEW - APPS.IGWBV_GRNT_PRPSL_EXP_RATE_ASGN
VIEW - APPS.IGWBV_GRNT_PRPSL_ORG_CERT_ANSW
VIEW - APPS.IGWBV_GRNT_PRPSL_PERS_BIOSKTCH
VIEW - APPS.IGWBV_GRNT_PRPSL_PERS_DEGREE
VIEW - APPS.IGWBV_GRNT_PRPSL_PERS_DEG_ASGN
VIEW - APPS.IGWBV_GRNT_PRPSL_PERS_OTHR_SUP
VIEW - APPS.IGWBV_GRNT_PRPSL_PERS_PRF_ASGN
VIEW - APPS.IGWBV_GRNT_PRPSL_ROUTG_LST_MBR
VIEW - APPS.IGWBV_GRNT_PRPSL_ROUT_RULE_LNE
VIEW - APPS.IGWBV_GRNT_PRPSL_SPCL_RVW
VIEW - APPS.IGWFV_GRANT_KEYWORD
VIEW - APPS.IGWFV_GRANT_PROPOSAL
VIEW - APPS.IGWFV_GRANT_PROPOSAL_APPROVAL
VIEW - APPS.IGWFV_GRANT_PROPOSAL_BDGT_LINE
VIEW - APPS.IGWFV_GRANT_PROPOSAL_EXP_TYPE
VIEW - APPS.IGWFV_GRANT_PROPOSAL_KEYWORD
VIEW - APPS.IGWFV_GRANT_PROPOSAL_NARRATIVE
VIEW - APPS.IGWFV_GRANT_PROPOSAL_OVRD_RATE
VIEW - APPS.IGWFV_GRANT_PROPOSAL_PERS_ASGN
VIEW - APPS.IGWFV_GRANT_PROPOSAL_RATE
VIEW - APPS.IGWFV_GRANT_PROPOSAL_RATE_TYPE
VIEW - APPS.IGWFV_GRANT_PRPSL_BDGT_LIN_AMT
VIEW - APPS.IGWFV_GRANT_PRPSL_BDGT_PERSON
VIEW - APPS.IGWFV_GRANT_PRPSL_BDGT_VERSION
VIEW - APPS.IGWFV_GRANT_PRPSL_EXP_CATEGORY
VIEW - APPS.IGWFV_GRANT_PRPSL_RATE_CLASS
VIEW - APPS.IGWFV_GRANT_PRPSL_ROUTING_LIST
VIEW - APPS.IGWFV_GRANT_PRPSL_ROUTING_RULE
VIEW - APPS.IGWFV_GRANT_PRPSL_SUPPRT_TEXT
VIEW - APPS.IGWFV_GRNT_PERS_CERT_ANSWER
VIEW - APPS.IGWFV_GRNT_PRPSL_APRVL_LST_MBR
VIEW - APPS.IGWFV_GRNT_PRPSL_APRV_APVL_LST
VIEW - APPS.IGWFV_GRNT_PRPSL_BDGT_LIN_PERS
VIEW - APPS.IGWFV_GRNT_PRPSL_BDGT_PERS_AMT
VIEW - APPS.IGWFV_GRNT_PRPSL_BUDGT_PERIOD
VIEW - APPS.IGWFV_GRNT_PRPSL_CERT_ANSWER
VIEW - APPS.IGWFV_GRNT_PRPSL_CERT_QUESTION
VIEW - APPS.IGWFV_GRNT_PRPSL_COMMENT
VIEW - APPS.IGWFV_GRNT_PRPSL_EXP_RATE_ASGN
VIEW - APPS.IGWFV_GRNT_PRPSL_ORG_CERT_ANSW
VIEW - APPS.IGWFV_GRNT_PRPSL_PERS_BIOSKTCH
VIEW - APPS.IGWFV_GRNT_PRPSL_PERS_DEGREE
VIEW - APPS.IGWFV_GRNT_PRPSL_PERS_DEG_ASGN
VIEW - APPS.IGWFV_GRNT_PRPSL_PERS_OTHR_SUP
VIEW - APPS.IGWFV_GRNT_PRPSL_PERS_PRF_ASGN
VIEW - APPS.IGWFV_GRNT_PRPSL_ROUTG_LST_MBR
VIEW - APPS.IGWFV_GRNT_PRPSL_ROUT_RULE_LNE
VIEW - APPS.IGWFV_GRNT_PRPSL_SPCL_RVW
VIEW - APPS.IGW_ADMIN_OFFICIAL_V
VIEW - APPS.IGW_APPLICANT_DEPT_V
VIEW - APPS.IGW_APPLICANT_ORG_V
VIEW - APPS.IGW_APR_ORGANIZATIONS_V
VIEW - APPS.IGW_AWARDS_V
VIEW - APPS.IGW_BIOSKETCH_TYPES_V
VIEW - APPS.IGW_BUDGETS_V
VIEW - APPS.IGW_BUDGET_CATEGORY_V
VIEW - APPS.IGW_BUDGET_COMPLETE_V
VIEW - APPS.IGW_BUDGET_COSTS_V
VIEW - APPS.IGW_BUDGET_DETAILS_AMTS_V
VIEW - APPS.IGW_BUDGET_DETAILS_V
VIEW - APPS.IGW_BUDGET_EXPENDITURES_V
VIEW - APPS.IGW_BUDGET_LINE_CATEGORY_V
VIEW - APPS.IGW_BUDGET_MATRIX_V
VIEW - APPS.IGW_BUDGET_PERIODS_V
VIEW - APPS.IGW_BUDGET_PERSONNEL_AMTS_V
VIEW - APPS.IGW_BUDGET_PERSONNEL_V
VIEW - APPS.IGW_BUDGET_PERSONS_V
VIEW - APPS.IGW_BUSINESS_RULES
VIEW - APPS.IGW_BUSINESS_RULES_V
VIEW - APPS.IGW_DETAIL_AMTS_SUM_V
VIEW - APPS.IGW_EXPENDITURE_CATEGORIES_V
VIEW - APPS.IGW_EXPENDITURE_TYPES_V
VIEW - APPS.IGW_EXPENDITURE_TYPE_SUM_V
VIEW - APPS.IGW_IDC_SCHEDULE_V
VIEW - APPS.IGW_IMPLEMENTATIONS
VIEW - APPS.IGW_INSTITUTE_RATES_V
VIEW - APPS.IGW_LABOR_FORMAT_V
VIEW - APPS.IGW_LOOKUPS_V
VIEW - APPS.IGW_NON_LABOR_FORMAT_V
VIEW - APPS.IGW_OH_EXPENDITURE_CAT_TYPES_V
VIEW - APPS.IGW_OH_TEMP_V
VIEW - APPS.IGW_ORGANIZATION_TYPES_V
VIEW - APPS.IGW_ORG_MAPS_V
VIEW - APPS.IGW_ORG_MAP_DETAILS_V
VIEW - APPS.IGW_ORG_QUESTIONS_V
VIEW - APPS.IGW_PERSONS_V
VIEW - APPS.IGW_PI_V
VIEW - APPS.IGW_PRINTABLE_PROPOSALS_V
VIEW - APPS.IGW_PROPOSALS
VIEW - APPS.IGW_PROPOSALS_V
VIEW - APPS.IGW_PROPOSAL_PERSONS_V
VIEW - APPS.IGW_PROP_COMMENTS_V
VIEW - APPS.IGW_PROP_LOCATIONS_V
VIEW - APPS.IGW_PROP_PERSONS_TCA_V
VIEW - APPS.IGW_PROP_PERSONS_V
VIEW - APPS.IGW_PROP_PERSON_BIOSKETCH_V
VIEW - APPS.IGW_PROP_PERSON_DEGREES_V
VIEW - APPS.IGW_PROP_PERSON_QUESTIONS_V
VIEW - APPS.IGW_PROP_QUESTIONS_V
VIEW - APPS.IGW_PROP_RATES_V
VIEW - APPS.IGW_PROP_SCIENCE_CODES_V
VIEW - APPS.IGW_PROP_SPECIAL_REVIEWS_V
VIEW - APPS.IGW_PROP_V
VIEW - APPS.IGW_PRPO_ABSTRACTS_V
VIEW - APPS.IGW_PRPO_BIOSKETCH_DEGREES_V
VIEW - APPS.IGW_PRPO_BIOSKETCH_V
VIEW - APPS.IGW_PRPO_CATEGORY_AMTS_V
VIEW - APPS.IGW_PRPO_HEADERS_V
VIEW - APPS.IGW_PRPO_ORG_TYPES_V
VIEW - APPS.IGW_PRPO_OTHER_SUPPORT_V
VIEW - APPS.IGW_PRPO_PERF_SITES_V
VIEW - APPS.IGW_PRPO_PERSON_DETAILS_V
VIEW - APPS.IGW_PRPO_PROP_PERSONS_V
VIEW - APPS.IGW_PRPO_ROLES_DETAILS_V
VIEW - APPS.IGW_PRPO_SPECIAL_REVIEWS_V
VIEW - APPS.IGW_PRPO_SUBJECT_INFO_V
VIEW - APPS.IGW_PRPO_YN_RESPONSES_V
VIEW - APPS.IGW_PRP_ORGANIZATIONS_V
VIEW - APPS.IGW_QUESTIONS_VL
VIEW - APPS.IGW_REPORT_BUDGET_PERSONNEL_V
VIEW - APPS.IGW_REPORT_BUDGET_SEED_V
VIEW - APPS.IGW_REPORT_BUDGET_V
VIEW - APPS.IGW_REPORT_SEED_HEADER_V
VIEW - APPS.IGW_ROLES_VL
VIEW - APPS.IGW_SIGNING_OFFICIAL_V
VIEW - APPS.IGW_SPECIAL_REVIEWS_V
VIEW - APPS.IGW_TRANSFERABLE_BUDGETS_V

Table: IGW_AWARDS

Description: Information about awards transferred to Grants Accounting
Primary Key: IGW_AWARDS_PK
  1. PROPOSAL_AWARD_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IGW_AWARDS.PROPOSAL_ID IGW_PROPOSALS_ALL
Foreign Keys to this table:
Foreign Key Column Foreign Table
IGW_INSTALLMENTS.PROPOSAL_AWARD_ID IGW_AWARDS
Comments

IGW_AWARDS stores data that can be transferred to Grants Accounting as awards. A funded proposal can be transferred as multiple awards and installments.

Indexes
Index Type Tablespace Column
IGW_AWARDS_U1 UNIQUE APPS_TS_TX_IDX PROPOSAL_AWARD_ID
IGW_AWARDS_N1 NONUNIQUE APPS_TS_TX_IDX PROPOSAL_ID
Columns
Name Datatype Length Mandatory Comments
PROPOSAL_AWARD_ID NUMBER (15) Y Award or installment identifier
PROPOSAL_ID NUMBER (15) Y Proposal identifier
AWARD_TEMPLATE_ID NUMBER (15)
Award template identifier
AWARD_ID NUMBER (15)
Award identifier
AWARD_NUMBER VARCHAR2 (15)
Award number
AWARD_SHORT_NAME VARCHAR2 (30)
Award short name
AWARD_FULL_NAME VARCHAR2 (240)
Award full name
FUNDING_SOURCE_ID NUMBER (15)
Funding source identifier
FUNDING_SOURCE_AWARD_NUMBER VARCHAR2 (30)
Funding source award number
START_DATE DATE

Active start date for installment
END_DATE DATE

Active end date for installment
CLOSE_DATE DATE

Close date for installment
AWARD_TYPE VARCHAR2 (30)
Award type. Possible values are Federal Grant, Private Grant, Purchase Orders, Service Agreement, State Grant, and Verbal Agreement.
AWARD_PURPOSE_CODE VARCHAR2 (30)
Code entered by user, which describes the purpose of an award. Examples include Research and Training.
AWARD_ORGANIZATION_ID NUMBER (15)
Award organization identifier
AWARD_STATUS_CODE VARCHAR2 (30)
Award status code. Possible values are Active, Closed, AT_RISK for At Risk, and ON_HOLD for On Hold.
AWARD_MANAGER_ID NUMBER (15)
Award Manager identifier
REVENUE_DISTRIBUTION_RULE VARCHAR2 (30)
Revenue distribution rule. This can be one of two types: event and cost.
BILLING_DISTRIBUTION_RULE VARCHAR2 (30)
Billing distribution rule. This can be one of two types: event and cost.
BILLING_TERM_ID NUMBER (15)
Award billing term
BILLING_CYCLE_ID NUMBER (15)
Billing cycle identifier
LABOR_INVOICE_FORMAT_ID NUMBER (15)
Labor invoice format identifier
NON_LABOR_INVOICE_FORMAT_ID NUMBER (15)
Non-labor invoice format identifier
ALLOWABLE_SCHEDULE_ID NUMBER (15)
Identifier for allowable schedule of the award
INDIRECT_SCHEDULE_ID NUMBER (15)
Identifier for indirect cost rate schedule of the award
AMOUNT_TYPE_CODE VARCHAR2 (30)
Amount type code for budgetary control. PTD indicates Period to Date, PJTD indicates Project to Date, and YTD indicates Year to Date.
BOUNDARY_CODE VARCHAR2 (30)
Boundary code for budgetary control. Y indicates Year, P indicates Period, and PJ indicates Project.
TRANSFERRED_FLAG VARCHAR2 (1)
This indicates whether an award has been transferred to Grants Accounting. Possible values are Y and N.
TRANSFER_AS VARCHAR2 (30)
This indicates whether the information has been transfered as a new award or as an installment of an existing award. Possible values are A for Award and I for Installment.
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield structure defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment column
RECORD_VERSION_NUMBER NUMBER (15) Y Field for storing locking sequence number
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
TEMPORARY_FLAG VARCHAR2 (1)
Flag to identify temporary records created during Award Transfer process

[top of page]

IGW.IGW_AWARDS does not reference any database object

IGW.IGW_AWARDS is referenced by following:

APPS
SYNONYM - IGW_AWARDS

[top of page]

Table: IGW_AWARD_BUDGETS

Description: Information about award budgets
Primary Key: IGW_AWARD_BUDGETS_PK
  1. AWARD_BUDGET_ID
Comments

IGW_AWARD_BUDGETS stores budget lines that can be transferred to Grants Accounting. These budget lines are created from the final budget version of the proposal.

Indexes
Index Type Tablespace Column
IGW_AWARD_BUDGETS_U1 UNIQUE APPS_TS_TX_IDX AWARD_BUDGET_ID
Columns
Name Datatype Length Mandatory Comments
AWARD_BUDGET_ID NUMBER (15) Y Award budget identifier
PROPOSAL_INSTALLMENT_ID NUMBER (15) Y Proposal installment identifier
BUDGET_PERIOD_ID NUMBER (4) Y Budget period identifier
EXPENDITURE_TYPE_CAT VARCHAR2 (240)
Expenditure type or category
EXPENDITURE_CATEGORY_FLAG VARCHAR2 (240)
Flag that describes whether expenditure category or expenditure type is used in the budget line
BUDGET_AMOUNT NUMBER

Direct or indirect cost for award budget line
INDIRECT_FLAG VARCHAR2 (1)
Indicates whether the budget amount column refers to direct or indirect cost. Possible values are Y or N. Y indicates that the budget amount column refers to indirect cost. N indicates that the budget amount column refers to direct cost.
PROJECT_ID NUMBER (15)
Project identifier
TASK_ID NUMBER (15)
Task identifier
PERIOD_NAME VARCHAR2 (30)
PA Period for budget line
START_DATE DATE

Start date for budget line
END_DATE DATE

End date for budget line
TRANSFERRED_FLAG VARCHAR2 (1) Y Indicates whether the budget has been transferred to Grants Accounting. Possible values are Y and N.
RECORD_VERSION_NUMBER NUMBER
Y Field for storing locking sequence number
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER
Y Standard Who column

[top of page]

IGW.IGW_AWARD_BUDGETS does not reference any database object

IGW.IGW_AWARD_BUDGETS is referenced by following:

APPS
SYNONYM - IGW_AWARD_BUDGETS

[top of page]

Table: IGW_AWARD_BUDGET_HISTORY

Description: Information about award budget history
Comments
Columns
Name Datatype Length Mandatory Comments
AWARD_ID NUMBER (15)
PROJECT_ID NUMBER (15)
PROPOSAL_ID NUMBER (15)
AMOUNT_TRANSFERRED NUMBER

LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER
Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER
Y
LAST_UPDATE_LOGIN NUMBER
Y

[top of page]

IGW.IGW_AWARD_BUDGET_HISTORY does not reference any database object

IGW.IGW_AWARD_BUDGET_HISTORY is referenced by following:

APPS
SYNONYM - IGW_AWARD_BUDGET_HISTORY

[top of page]

Table: IGW_BUDGETS

Description: Information about budget versions
Primary Key: IGW_BUDGETS_PK
  1. PROPOSAL_ID
  2. VERSION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IGW_BUDGETS.OH_RATE_CLASS_ID IGW_RATE_CLASSES
IGW_BUDGETS.PROPOSAL_ID IGW_PROPOSALS_ALL
Foreign Keys to this table:
Foreign Key Column Foreign Table
IGW_BUDGET_PERIODS.PROPOSAL_ID
IGW_BUDGET_PERIODS.VERSION_ID 		IGW_BUDGETS
IGW_BUDGET_PERSONS.PROPOSAL_ID
IGW_BUDGET_PERSONS.VERSION_ID 		IGW_BUDGETS
IGW_PROP_RATES.PROPOSAL_ID
IGW_PROP_RATES.VERSION_ID 		IGW_BUDGETS
Comments

IGW_BUDGETS stores the versions of proposal budgets. There can be multiple budget
versions for a single proposal, but only one final budget version with FINAL_VERSION_FLAG
selected.

Indexes
Index Type Tablespace Column
IGW_BUDGETS_U1 UNIQUE APPS_TS_TX_IDX PROPOSAL_ID
VERSION_ID
Columns
Name Datatype Length Mandatory Comments
PROPOSAL_ID NUMBER (15) Y Proposal identifier
VERSION_ID NUMBER (4) Y Budget version identifier
START_DATE DATE
Y Effective start date of a budget version
END_DATE DATE
Y Effective end date of a budget version
TOTAL_COST NUMBER (15)
Sum of total direct costs and total indirect costs
TOTAL_DIRECT_COST NUMBER (15)
Total direct cost for budget version
TOTAL_INDIRECT_COST NUMBER (15)
Total indirect cost for budget version
COST_SHARING_AMOUNT NUMBER (15)
Total cost sharing for budget version
UNDERRECOVERY_AMOUNT NUMBER (15)
Underrecovery amount for budget version
RESIDUAL_FUNDS NUMBER (15)
Residual fund for budget version
TOTAL_COST_LIMIT NUMBER (15)
Total cost limit for budget version
OH_RATE_CLASS_ID NUMBER (10) Y Overhead rate class identifier associated with budget version
COMMENTS VARCHAR2 (2000)
Comments for a budget version
FINAL_VERSION_FLAG VARCHAR2 (1)
Indicator for the final budget version
PROPOSAL_FORM_NUMBER VARCHAR2 (30) Y Proposal form number or EDI transaction set number. Examples are PHS 398 and 194TS.
BUDGET_TYPE_CODE VARCHAR2 (30)
No longer used
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Structure defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield
RECORD_VERSION_NUMBER NUMBER
Y Field for storing locking sequence number
APPLY_INFLATION_SETUP_RATES VARCHAR2 (1)
Flag that indicates whether setup rates for inflation need to be applied while budgeting. Possible values for the flag are Y and N.
APPLY_EB_SETUP_RATES VARCHAR2 (1)
Flag that indicates whether setup rates for Employee Benefits need to be applied while budgeting. Possible values for the flag are Y and N.
APPLY_OH_SETUP_RATES VARCHAR2 (1)
Flag that indicates whether setup rates for Overhead need to be applied while budgeting. Possible values for the flag are Y and N.
ENTER_BUDGET_AT_PERIOD_LEVEL VARCHAR2 (1)
Flag that indicates whether budgeting is done at Period level. Possible values for the flag are Y and N.

[top of page]

IGW.IGW_BUDGETS does not reference any database object

IGW.IGW_BUDGETS is referenced by following:

APPS
SYNONYM - IGW_BUDGETS

[top of page]

Table: IGW_BUDGET_DETAILS

Description: Details for a budget period
Primary Key: IGW_BUDGET_DETAILS_PK
  1. LINE_ITEM_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IGW_BUDGET_DETAILS.PROPOSAL_ID
IGW_BUDGET_DETAILS.VERSION_ID
IGW_BUDGET_DETAILS.BUDGET_PERIOD_ID 		IGW_BUDGET_PERIODS
IGW_BUDGET_DETAILS.EXPENDITURE_TYPE IGW_EXPENDITURE_TYPES
IGW_BUDGET_DETAILS.EXPENDITURE_TYPE IGW_EXPENDITURE_CATEGORIES
IGW_BUDGET_DETAILS.PROJECT_ID PA_PROJECTS_ALL
IGW_BUDGET_DETAILS.TASK_ID PA_TASKS
Foreign Keys to this table:
Foreign Key Column Foreign Table
IGW_BUDGET_PERSONNEL_DETAILS.LINE_ITEM_ID IGW_BUDGET_DETAILS
Comments

IGW_BUDGET_DETAILS stores budget line details for a budget period. A budget line may or may not involve personnel, depending on the expenditure type selected. A budget period can have multiple budget lines.

Indexes
Index Type Tablespace Column
IGW_BUDGET_DETAILS_U1 UNIQUE APPS_TS_TX_IDX LINE_ITEM_ID
Columns
Name Datatype Length Mandatory Comments
PROPOSAL_ID NUMBER (15) Y Proposal identifier
VERSION_ID NUMBER (4) Y Budget version identifier
BUDGET_PERIOD_ID NUMBER (4) Y Budget period identifier
LINE_ITEM_ID NUMBER (15) Y Budget line identifier
EXPENDITURE_TYPE VARCHAR2 (30) Y Expenditure category or expenditure type associated with budget line
BUDGET_CATEGORY_CODE VARCHAR2 (30) Y Unique code identifying sponsor budget category
EXPENDITURE_CATEGORY_FLAG VARCHAR2 (1) Y Flag that describes whether expenditure category or expenditure type is used in the budget line. If expenditure category is used in the budget line, the value of the flag is Y. The value of the flag is N if expenditure category is used.
LINE_ITEM_DESCRIPTION VARCHAR2 (250)
Description for a budget line
BASED_ON_LINE_ITEM NUMBER (15)
Identifier for the parent budget line from which the current budget line is generated
LINE_ITEM_COST NUMBER (15)
Line item cost or amount entered for a budget line
COST_SHARING_AMOUNT NUMBER (15)
Cost sharing amount for a budget line
UNDERRECOVERY_AMOUNT NUMBER (15)
Underrecovery amount for a budget line
APPLY_INFLATION_FLAG VARCHAR2 (1) Y Flag that indicates whether inflation is to be applied to later periods
LOCATION_CODE VARCHAR2 (30) Y Unique code defining the location for budget line. On Campus and Off Campus are examples of location.
PROJECT_ID NUMBER (15)
No longer used
TASK_ID NUMBER (15)
No longer used
AWARD_ID NUMBER (15)
No longer used
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
RECORD_VERSION_NUMBER NUMBER
Y Field for storing locking sequence number
BUDGET_JUSTIFICATION LONG (0)
Justification for a budget line

[top of page]

IGW.IGW_BUDGET_DETAILS does not reference any database object

IGW.IGW_BUDGET_DETAILS is referenced by following:

APPS
SYNONYM - IGW_BUDGET_DETAILS

[top of page]

Table: IGW_BUDGET_DETAILS_CAL_AMTS

Description: Overhead and employee benefit amounts for a budget line
Primary Key: IGW_BUDG_DETAIL_CAL_AMTS_PK
  1. LINE_ITEM_ID
  2. RATE_CLASS_ID
  3. RATE_TYPE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IGW_BUDGET_DETAILS_CAL_AMTS.PROPOSAL_ID
IGW_BUDGET_DETAILS_CAL_AMTS.VERSION_ID
IGW_BUDGET_DETAILS_CAL_AMTS.BUDGET_PERIOD_ID 		IGW_BUDGET_PERIODS
Comments

IGW_BUDGET_DETAILS_CAL_AMTS stores overhead amounts for a budget line. It also stores
employee benefits if a budget line involves personnel. Overhead may or may not be applied by selecting or deselecting APPLY_RATE_FLAG.

Indexes
Index Type Tablespace Column
IGW_BUDG_DETAIL_CAL_AMTS_U1 UNIQUE APPS_TS_TX_IDX LINE_ITEM_ID
RATE_CLASS_ID
RATE_TYPE_ID
Columns
Name Datatype Length Mandatory Comments
PROPOSAL_ID NUMBER (15) Y Proposal identifier
VERSION_ID NUMBER (4) Y Budget version identifier
BUDGET_PERIOD_ID NUMBER (4) Y Budget period identifier
LINE_ITEM_ID NUMBER (15) Y Budget line identifier
RATE_CLASS_ID NUMBER (10) Y Rate class identifier
RATE_TYPE_ID NUMBER (10) Y Rate type identifier
APPLY_RATE_FLAG VARCHAR2 (1)
Flag that indicates whether overhead or employee benefits rate is applied
CALCULATED_COST NUMBER (15)
Cost calculation based on rate class
CALCULATED_COST_SHARING NUMBER (15)
Cost sharing calculation based on rate class
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
RECORD_VERSION_NUMBER NUMBER
Y Field for storing locking sequence number

[top of page]

IGW.IGW_BUDGET_DETAILS_CAL_AMTS does not reference any database object

IGW.IGW_BUDGET_DETAILS_CAL_AMTS is referenced by following:

APPS
SYNONYM - IGW_BUDGET_DETAILS_CAL_AMTS

[top of page]

Table: IGW_BUDGET_PERIODS

Description: Information on budget periods for a budget version
Primary Key: IGW_BUDGET_PERIODS_PK
  1. PROPOSAL_ID
  2. VERSION_ID
  3. BUDGET_PERIOD_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IGW_BUDGET_PERIODS.PROPOSAL_ID
IGW_BUDGET_PERIODS.VERSION_ID 		IGW_BUDGETS
Foreign Keys to this table:
Foreign Key Column Foreign Table
IGW_BUDGET_DETAILS_CAL_AMTS.PROPOSAL_ID
IGW_BUDGET_DETAILS_CAL_AMTS.VERSION_ID
IGW_BUDGET_DETAILS_CAL_AMTS.BUDGET_PERIOD_ID 		IGW_BUDGET_PERIODS
IGW_BUDGET_DETAILS.PROPOSAL_ID
IGW_BUDGET_DETAILS.VERSION_ID
IGW_BUDGET_DETAILS.BUDGET_PERIOD_ID 		IGW_BUDGET_PERIODS
IGW_REPORT_BUDGET_BASE_RATE.PROPOSAL_ID
IGW_REPORT_BUDGET_BASE_RATE.VERSION_ID
IGW_REPORT_BUDGET_BASE_RATE.BUDGET_PERIOD_ID 		IGW_BUDGET_PERIODS
Comments

IGW_BUDGET_PERIODS stores the periods of a budget version. A budget version can have multiple periods within the budget version start and end date.

Indexes
Index Type Tablespace Column
IGW_BUDGET_PERIODS_U1 UNIQUE APPS_TS_TX_IDX PROPOSAL_ID
VERSION_ID
BUDGET_PERIOD_ID
Columns
Name Datatype Length Mandatory Comments
PROPOSAL_ID NUMBER (15) Y Proposal identifier
VERSION_ID NUMBER (4) Y Budget version identifier
BUDGET_PERIOD_ID NUMBER (4) Y Budget period identifier
START_DATE DATE
Y Start date of a budget period
END_DATE DATE
Y End date of a budget period
TOTAL_COST NUMBER (15)
Total cost for the entire period, which is the sum of total direct costs and total indirect costs
TOTAL_DIRECT_COST NUMBER (15)
Total direct cost for the period
TOTAL_INDIRECT_COST NUMBER (15)
Total indirect cost for the period
COST_SHARING_AMOUNT NUMBER (15)
Cost sharing amount for the period
UNDERRECOVERY_AMOUNT NUMBER (15)
Underrecovery amount for the budget period
TOTAL_COST_LIMIT NUMBER (15)
Total cost limit for the budget period
PROGRAM_INCOME NUMBER (15)
Program income received for the budget period
PROGRAM_INCOME_SOURCE VARCHAR2 (50)
Source of program income
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
RECORD_VERSION_NUMBER NUMBER
Y Field for storing locking sequence number

[top of page]

IGW.IGW_BUDGET_PERIODS does not reference any database object

IGW.IGW_BUDGET_PERIODS is referenced by following:

APPS
SYNONYM - IGW_BUDGET_PERIODS

[top of page]

Table: IGW_BUDGET_PERSONNEL_CAL_AMTS

Description: Overhead and employee benefit amounts for a budget line involving personnel
Primary Key: IGW_BUDG_PERS_CAL_AMTS_PK
  1. BUDGET_PERSONNEL_DETAIL_ID
  2. RATE_CLASS_ID
  3. RATE_TYPE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IGW_BUDGET_PERSONNEL_CAL_AMTS.BUDGET_PERSONNEL_DETAIL_ID IGW_BUDGET_PERSONNEL_DETAILS
Comments

IGW_BUDGET_PERSONNEL_CAL_AMTS stores overhead amounts and employee benefits for personnel attached to a budget line. Overhead and employee benefits may or may not be applied by selecting or deselecting APPLY_RATE_FLAG.

Indexes
Index Type Tablespace Column
IGW_BUDG_PERS_CAL_AMTS_U1 UNIQUE APPS_TS_TX_IDX BUDGET_PERSONNEL_DETAIL_ID
RATE_CLASS_ID
RATE_TYPE_ID
Columns
Name Datatype Length Mandatory Comments
BUDGET_PERSONNEL_DETAIL_ID NUMBER (15) Y Record identifier
RATE_CLASS_ID NUMBER (10) Y Rate class identifier
RATE_TYPE_ID NUMBER (10) Y Rate type identifier
APPLY_RATE_FLAG VARCHAR2 (1)
Flag that indicates whether overhead or employee benefits rate is applied
CALCULATED_COST NUMBER (15)
Cost calculation based on rate class
CALCULATED_COST_SHARING NUMBER (15)
Cost sharing calculation based on rate class
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
RECORD_VERSION_NUMBER NUMBER
Y Field for storing locking sequence number

[top of page]

IGW.IGW_BUDGET_PERSONNEL_CAL_AMTS does not reference any database object

IGW.IGW_BUDGET_PERSONNEL_CAL_AMTS is referenced by following:

APPS
SYNONYM - IGW_BUDGET_PERSONNEL_CAL_AMTS

[top of page]

Table: IGW_BUDGET_PERSONNEL_DETAILS

Description: Personnel detail attached to a budget line
Primary Key: IGW_BUDG_PERSL_DETAILS_PK
  1. BUDGET_PERSONNEL_DETAIL_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IGW_BUDGET_PERSONNEL_DETAILS.LINE_ITEM_ID IGW_BUDGET_DETAILS
IGW_BUDGET_PERSONNEL_DETAILS.PROPOSAL_ID
IGW_BUDGET_PERSONNEL_DETAILS.VERSION_ID
IGW_BUDGET_PERSONNEL_DETAILS.PERSON_ID
IGW_BUDGET_PERSONNEL_DETAILS.APPOINTMENT_TYPE_CODE 		IGW_BUDGET_PERSONS
Foreign Keys to this table:
Foreign Key Column Foreign Table
IGW_BUDGET_PERSONNEL_CAL_AMTS.BUDGET_PERSONNEL_DETAIL_ID IGW_BUDGET_PERSONNEL_DETAILS
Comments

IGW_BUDGET_PERSONNEL_DETAILS stores personnel details and related information, such as duration of work, percentage of effort charged, and percentage of effort worked for a budget line. A budget line can have multiple persons attached.

Indexes
Index Type Tablespace Column
IGW_BUDG_PERSL_DETAILS_U1 UNIQUE APPS_TS_TX_IDX BUDGET_PERSONNEL_DETAIL_ID
Columns
Name Datatype Length Mandatory Comments
BUDGET_PERSONNEL_DETAIL_ID NUMBER (15) Y Budget personnel detail identifier
PROPOSAL_ID NUMBER (15) Y Proposal identifier
VERSION_ID NUMBER (4) Y Budget version identifier
BUDGET_PERIOD_ID NUMBER (4) Y Budget period identifier
LINE_ITEM_ID NUMBER (15) Y Budget line identifier
PERSON_ID NUMBER (15)
Person identifier
START_DATE DATE
Y Start date from which a person in a budget line is effective
END_DATE DATE
Y End date through which a person in a budget line is effective
PERIOD_TYPE_CODE VARCHAR2 (30) Y Code that uniquely identifies period type. Period type can be Academic, Calendar, Summer, or Cycle.
APPOINTMENT_TYPE_CODE VARCHAR2 (30) Y Code that uniquely identifies appointment type
SALARY_REQUESTED NUMBER (15)
Calculated salary for the person based on start date, end date, and percent charged
PERCENT_CHARGED NUMBER (5)
Percentage charged for a person in the budget line
PERCENT_EFFORT NUMBER (5)
Percentage effort of a person in the budget line
COST_SHARING_PERCENT NUMBER (5)
Percentage of cost sharing for the budget person
COST_SHARING_AMOUNT NUMBER (15)
Cost sharing amount calculation based on percentage of cost sharing for the budget person
UNDERRECOVERY_AMOUNT NUMBER (15)
Underrecovery amount for the budget person
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
RECORD_VERSION_NUMBER NUMBER
Y Field for storing locking sequence number
PARTY_ID NUMBER (15) Y Party identifier for person

[top of page]

IGW.IGW_BUDGET_PERSONNEL_DETAILS does not reference any database object

IGW.IGW_BUDGET_PERSONNEL_DETAILS is referenced by following:

APPS
SYNONYM - IGW_BUDGET_PERSONNEL_DETAILS

[top of page]

Table: IGW_BUDGET_PERSONS

Description: Budgeting information about personnel
Primary Key: IGW_BUDGET_PERSONS_PK
  1. PROPOSAL_ID
  2. VERSION_ID
  3. PARTY_ID
  4. APPOINTMENT_TYPE_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
IGW_BUDGET_PERSONS.PROPOSAL_ID
IGW_BUDGET_PERSONS.VERSION_ID 		IGW_BUDGETS
IGW_BUDGET_PERSONS.PROPOSAL_ID
IGW_BUDGET_PERSONS.PERSON_ID 		IGW_PROP_PERSONS
Foreign Keys to this table:
Foreign Key Column Foreign Table
IGW_BUDGET_PERSONNEL_DETAILS.PROPOSAL_ID
IGW_BUDGET_PERSONNEL_DETAILS.VERSION_ID
IGW_BUDGET_PERSONNEL_DETAILS.PERSON_ID
IGW_BUDGET_PERSONNEL_DETAILS.APPOINTMENT_TYPE_CODE 		IGW_BUDGET_PERSONS
Comments

IGW_BUDGET_PERSONS stores budgeting information about personnel, along with information such as appointment type, base salary, and effective date. The same person can be stored multiple times with different appointment types.

Indexes
Index Type Tablespace Column
IGW_BUDGET_PERSONS_U1 UNIQUE APPS_TS_TX_IDX PROPOSAL_ID
VERSION_ID
PARTY_ID
APPOINTMENT_TYPE_CODE
Columns
Name Datatype Length Mandatory Comments
PROPOSAL_ID NUMBER (15) Y Proposal identifier
VERSION_ID NUMBER (4) Y Budget version identifier
PERSON_ID NUMBER (15)
Person identifier
APPOINTMENT_TYPE_CODE VARCHAR2 (30) Y Code that uniquely identifies appointment type
EFFECTIVE_DATE DATE
Y Effective start date from which the base salary associated with a person is valid
CALCULATION_BASE NUMBER (15) Y Base salary of a person
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
RECORD_VERSION_NUMBER NUMBER
Y Field for storing locking sequence number
PARTY_ID NUMBER (15) Y Party identifier for person

[top of page]

IGW.IGW_BUDGET_PERSONS does not reference any database object

IGW.IGW_BUDGET_PERSONS is referenced by following:

APPS
SYNONYM - IGW_BUDGET_PERSONS

[top of page]

Table: IGW_BUSINESS_RULES_ALL

Description: Business rule information
Primary Key: IGW_BUSINESS_RULES_PK
  1. RULE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IGW_BUSINESS_RULES_ALL.ORGANIZATION_ID HR_ALL_ORGANIZATION_UNITS
IGW_BUSINESS_RULES_ALL.MAP_ID IGW_ORG_MAPS_ALL
Foreign Keys to this table:
Foreign Key Column Foreign Table
IGW_BUSINESS_RULE_LINES.RULE_ID IGW_BUSINESS_RULES_ALL
Comments

IGW_BUSINESS_RULES_ALL stores business rules for organizations.
The three kinds of business rules are validation, notification, and routing. This table contains
information about which routing maps to use for the routing and notificaton business rules.

Indexes
Index Type Tablespace Column
IGW_BUSINESS_RULES_U1 UNIQUE APPS_TS_TX_IDX RULE_ID
Columns
Name Datatype Length Mandatory Comments
RULE_ID NUMBER (10) Y Rule identifier
RULE_SEQUENCE_NUMBER NUMBER (4)
Rule sequence number
ORGANIZATION_ID NUMBER (15) Y Organization identifier
ORG_ID NUMBER (15)
Operating unit identifier for multiple organizations
RULE_NAME VARCHAR2 (50) Y Rule name
RULE_TYPE VARCHAR2 (1) Y Type of rule. N means Notification, R means Routing, and V means Validation.
MAP_ID NUMBER (10)
Map identifier
VALID_FLAG VARCHAR2 (1)
Flag that determines if proposal is valid or invalid if validation business rule evaluates to True. Possible values are V for Valid and I for Invalid.
START_DATE_ACTIVE DATE
Y First effective date of a rule
END_DATE_ACTIVE DATE

Last effective date of a rule
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column

[top of page]

IGW.IGW_BUSINESS_RULES_ALL does not reference any database object

IGW.IGW_BUSINESS_RULES_ALL is referenced by following:

APPS
SYNONYM - IGW_BUSINESS_RULES_ALL

[top of page]

Table: IGW_BUSINESS_RULE_LINES

Description: Business rule expressions
Primary Key: IGW_BUS_RULE_LINES_PK
  1. RULE_ID
  2. EXPRESSION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IGW_BUSINESS_RULE_LINES.RULE_ID IGW_BUSINESS_RULES_ALL
Comments

IGW_BUSINESS_RULE_LINES stores business rule expressions. A comprehensive business rule may consist of several expressions joined together by logical AND or OR operators.

Indexes
Index Type Tablespace Column
IGW_BUS_RULE_LINES_U1 UNIQUE APPS_TS_TX_IDX RULE_ID
EXPRESSION_ID
Columns
Name Datatype Length Mandatory Comments
RULE_ID NUMBER (15) Y Rule identifier
EXPRESSION_ID NUMBER (10) Y Rule expression identifier
EXPRESSION_SEQUENCE_NUMBER NUMBER (4) Y Expression sequence number
EXPRESSION_TYPE VARCHAR2 (1) Y Type of rule expression. Possible values are Q for Question, C for Column, and F for Function
LBRACKETS VARCHAR2 (10)
Field for entering left brackets of an expression. A valid left bracket is a left parenthesis.
LVALUE VARCHAR2 (50) Y Left hand side of expression. Values are taken from lookup IGW_RULE_COLUMNS when EXPRESSION_TYPE is C for Columns and from lookup IGW_RULE_FUNCTIONS when EXPRESSION_TYPE is F for Functions.
OPERATOR VARCHAR2 (2) Y Operator. Possible values are Equals and Not Equal to if EXPRESSION_TYPE is F and Equals, Not Equal to, Less Than, Less Than or Equal to, Greater Than, Greater Than or Equal to if EXPRESSION_TYPE is C.
RVALUE VARCHAR2 (200) Y Right hand side of expression
RVALUE_ID VARCHAR2 (30)
For expression of type Q for question or C for column. RVALUE_ID will be the same as Rvalue. For expression of type F for function, RVALUE_ID will have an identifier of Rvalue.
RBRACKETS VARCHAR2 (10)
Field for entering right brackets of expression. A valid right bracket is a right parenthesis.
LOGICAL_OPERATOR VARCHAR2 (3)
Logical operator joining two expressions. Possible values are AND and OR.
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column

[top of page]

IGW.IGW_BUSINESS_RULE_LINES does not reference any database object

IGW.IGW_BUSINESS_RULE_LINES is referenced by following:

APPS
SYNONYM - IGW_BUSINESS_RULE_LINES

[top of page]

Table: IGW_EXPENDITURE_CATEGORIES

Description: Expenditure categories used for budgeting purposes
Primary Key: IGW_EXPENDITURE_CATEGORIES_PK
  1. EXPENDITURE_CATEGORY
Foreign Keys to this table:
Foreign Key Column Foreign Table
IGW_BUDGET_DETAILS.EXPENDITURE_TYPE IGW_EXPENDITURE_CATEGORIES
IGW_EXPENDITURE_TYPES.EXPENDITURE_CATEGORY IGW_EXPENDITURE_CATEGORIES
Comments

IGW_EXPENDITURE_CATEGORIES stores the expenditure categories used for budgeting purposes.
Each expenditure category is associated with a budget category. PERSONNEL_ATTACHED_FLAG can be used to determine whether there will be personnel attached to an expenditure
category while preparing a budget.

Indexes
Index Type Tablespace Column
IGW_EXPENDITURE_CATEGORIES_U1 UNIQUE APPS_TS_TX_IDX EXPENDITURE_CATEGORY
Columns
Name Datatype Length Mandatory Comments
EXPENDITURE_CATEGORY VARCHAR2 (30) Y Expenditure category
DESCRIPTION VARCHAR2 (250)
Expenditure category description
BUDGET_CATEGORY_CODE VARCHAR2 (30) Y Indicates sponsor budget category. Values are taken from the lookups IGW_BUDGET_CATEGORY.
PERSONNEL_ATTACHED_FLAG VARCHAR2 (1) Y Flag indicates if personnel are attached to the expenditure category
START_DATE_ACTIVE DATE

First effective date for expenditure category
END_DATE_ACTIVE DATE

Last effective date for expenditure category
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column

[top of page]

IGW.IGW_EXPENDITURE_CATEGORIES does not reference any database object

IGW.IGW_EXPENDITURE_CATEGORIES is referenced by following:

APPS
SYNONYM - IGW_EXPENDITURE_CATEGORIES

[top of page]

Table: IGW_EXPENDITURE_TYPES

Description: Expenditure types used for budgeting purposes
Primary Key: IGW_EXPENDITURE_TYPES_PK
  1. EXPENDITURE_TYPE
Foreign Keys from this table:
Foreign Key Column Foreign Table
IGW_EXPENDITURE_TYPES.EXPENDITURE_CATEGORY IGW_EXPENDITURE_CATEGORIES
Foreign Keys to this table:
Foreign Key Column Foreign Table
IGW_BUDGET_DETAILS.EXPENDITURE_TYPE IGW_EXPENDITURE_TYPES
Comments

IGW_EXPENDITURE_TYPES stores expenditure types that are used for budgeting purposes.
It also contains information about the expenditure categories to which the expenditure type
belongs.

Indexes
Index Type Tablespace Column
IGW_EXPENDITURE_TYPES_U1 UNIQUE APPS_TS_TX_IDX EXPENDITURE_TYPE
Columns
Name Datatype Length Mandatory Comments
EXPENDITURE_CATEGORY VARCHAR2 (30) Y Expenditure category
EXPENDITURE_TYPE VARCHAR2 (30) Y Expenditure type
DESCRIPTION VARCHAR2 (250)
Expenditure type description
START_DATE_ACTIVE DATE
Y First effective date for the expenditure type
END_DATE_ACTIVE DATE

Last effective date for the expenditure type
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column

[top of page]

IGW.IGW_EXPENDITURE_TYPES does not reference any database object

IGW.IGW_EXPENDITURE_TYPES is referenced by following:

APPS
SYNONYM - IGW_EXPENDITURE_TYPES

[top of page]

Table: IGW_EXP_TYPE_RATE_TYPES

Description: Information about expenditure categories associated with a particular rate class and rate type
Primary Key: IGW_EXP_RATE_TYPES_PK
  1. EXPENDITURE_CATEGORY
  2. RATE_CLASS_ID
  3. RATE_TYPE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IGW_EXP_TYPE_RATE_TYPES.RATE_CLASS_ID
IGW_EXP_TYPE_RATE_TYPES.RATE_TYPE_ID 		IGW_RATE_TYPES
Comments

IGW_EXP_TYPE_RATE_TYPES stores information about expenditure categories associated with a particular rate class and rate type. An expenditure category can be assigned to only one rate type within a rate class.

Indexes
Index Type Tablespace Column
IGW_EXP_RATE_TYPES_U1 UNIQUE APPS_TS_TX_IDX EXPENDITURE_CATEGORY
RATE_CLASS_ID
RATE_TYPE_ID
Columns
Name Datatype Length Mandatory Comments
EXPENDITURE_CATEGORY VARCHAR2 (30) Y Expenditure category
RATE_CLASS_ID NUMBER (10) Y Rate class identifier
RATE_TYPE_ID NUMBER (10) Y Rate type identifier
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column

[top of page]

IGW.IGW_EXP_TYPE_RATE_TYPES does not reference any database object

IGW.IGW_EXP_TYPE_RATE_TYPES is referenced by following:

APPS
SYNONYM - IGW_EXP_TYPE_RATE_TYPES

[top of page]

Table: IGW_IMPLEMENTATIONS_ALL

Description: System implementation parameters
Primary Key: IGW_IMPLEMENTATIONS_ALL
  1. ORG_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IGW_IMPLEMENTATIONS_ALL.APR_ORG_STRUCTURE_ID PER_ORGANIZATION_STRUCTURES
IGW_IMPLEMENTATIONS_ALL.UNM_EXPENDITURE_CATEGORY_TYPE PA_EXPENDITURE_CATEGORIES
IGW_IMPLEMENTATIONS_ALL.UNM_EXPENDITURE_CATEGORY_TYPE PA_EXPENDITURE_TYPES
IGW_IMPLEMENTATIONS_ALL.APR_ORG_STRUCTURE_VERSION_ID PER_ORG_STRUCTURE_VERSIONS
IGW_IMPLEMENTATIONS_ALL.PRP_ORG_STRUCTURE_ID PER_ORGANIZATION_STRUCTURES
IGW_IMPLEMENTATIONS_ALL.PRP_ORG_STRUCTURE_VERSION_ID PER_ORG_STRUCTURE_VERSIONS
IGW_IMPLEMENTATIONS_ALL.BUSINESS_GROUP_ID HR_ALL_ORGANIZATION_UNITS
IGW_IMPLEMENTATIONS_ALL.OH_EXPENDITURE_CATEGORY_TYPE PA_EXPENDITURE_CATEGORIES
IGW_IMPLEMENTATIONS_ALL.OH_EXPENDITURE_CATEGORY_TYPE PA_EXPENDITURE_TYPES
Comments

IGW_IMPLEMENTATIONS_ALL stores the implementation parameters for Oracle Grants Proposal. The proposal numbering method, proposal owning organization, and proposal approval organization hierarchies are specified in this table. If users have a multi-organization installation, one row is defined for each operating unit.

Indexes
Index Type Tablespace Column
IGW_IMPLEMENTATIONS_ALL_U1 UNIQUE APPS_TS_TX_IDX ORG_ID
Columns
Name Datatype Length Mandatory Comments
PROPOSAL_NUMBERING_METHOD VARCHAR2 (1)
Proposal numbering method. M means Manual and A means Automatic.
MANUAL_PROPOSAL_NUMB_METHOD VARCHAR2 (1)
Manual proposal numbering method. A means Alphanumeric and N means Numeric.
NEXT_AUTOMATIC_PROPOSAL_NUMBER NUMBER (15)
Next proposal number that is automatically generated if the proposal numbering method is set to automatic
OH_EXPENDITURE_CATEGORY_TYPE VARCHAR2 (30)
This column has been obsoleted. It is no longer used.
OH_EXPENDITURE_FLAG VARCHAR2 (1)
This column has been obsoleted. It is no longer used.
UNM_EXPENDITURE_CATEGORY_TYPE VARCHAR2 (30)
This column has been obsoleted. It is no longer used.
UNM_EXPENDITURE_FLAG VARCHAR2 (1)
This column has been obsoleted. It is no longer used.
PRP_ORG_STRUCTURE_ID NUMBER (15)
Proposal owning organization hierarchy identifier
PRP_ORG_STRUCTURE_VERSION_ID NUMBER (15)
Proposal owning organization hierarchy version identifier
PRP_ORG_STRUCTURE_START_ID NUMBER (15)
Start organization identifier of proposal owning organization hierarchy
APR_ORG_STRUCTURE_ID NUMBER (15) Y Proposal approval organization hierarchy identifier
APR_ORG_STRUCTURE_VERSION_ID NUMBER (15) Y Proposal approval organization hierarchy version identifier
APR_ORG_STRUCTURE_START_ID NUMBER (15) Y Start organization identifier of proposal approval organization hierarchy
BUSINESS_GROUP_ID NUMBER (15) Y Business group identifier
ORG_ID NUMBER (15)
Operating unit identifier for multi-organization installations
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column

[top of page]

IGW.IGW_IMPLEMENTATIONS_ALL does not reference any database object

IGW.IGW_IMPLEMENTATIONS_ALL is referenced by following:

APPS
SYNONYM - IGW_IMPLEMENTATIONS_ALL

[top of page]

Table: IGW_INSTALLMENTS

Description: Award Installments transferred to Grants Accounting
Primary Key: IGW_INSTALLMENTS_PK
  1. PROPOSAL_INSTALLMENT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IGW_INSTALLMENTS.PROPOSAL_AWARD_ID IGW_AWARDS
Foreign Keys to this table:
Foreign Key Column Foreign Table
IGW_PROJECT_FUNDINGS.PROPOSAL_INSTALLMENT_ID IGW_INSTALLMENTS
Comments

IGW_INSTALLMENTS stores data that can be transferred to Grants Accounting as installments. A funded proposal can be transferred as multiple awards and installments.

Indexes
Index Type Tablespace Column
IGW_INSTALLMENTS_U1 UNIQUE APPS_TS_TX_IDX PROPOSAL_INSTALLMENT_ID
IGW_INSTALLMENTS_N1 NONUNIQUE APPS_TS_TX_IDX PROPOSAL_AWARD_ID
Columns
Name Datatype Length Mandatory Comments
PROPOSAL_INSTALLMENT_ID NUMBER (15) Y Proposal installment identifier
RECORD_VERSION_NUMBER NUMBER (15) Y Field for storing locking sequence number
PROPOSAL_AWARD_ID NUMBER (15) Y Proposal award identifier
INSTALLMENT_ID NUMBER (15)
Award installment identifier
INSTALLMENT_NUMBER VARCHAR2 (15)
Award installment number
INSTALLMENT_TYPE_CODE VARCHAR2 (30)
Installment type. Possible values are Award, Amendment, or Supplement.
ISSUE_DATE DATE

Installment issue date
CLOSE_DATE DATE

Installment close date
START_DATE DATE

First effective date of installment
END_DATE DATE

Last effective date of installment
DIRECT_COST NUMBER

Direct cost of installment
INDIRECT_COST NUMBER

Indirect cost of installment
BILLABLE_FLAG VARCHAR2 (1)
Indicates whether the amount on the installment is available for billing. Valid values are Y or N.
DESCRIPTION VARCHAR2 (250)
Installment description
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column

[top of page]

IGW.IGW_INSTALLMENTS does not reference any database object

IGW.IGW_INSTALLMENTS is referenced by following:

APPS
SYNONYM - IGW_INSTALLMENTS

[top of page]

Table: IGW_INSTITUTE_RATES

Description: Rate information about a particular activity type, location, fiscal year, rate class, and rate type
Primary Key: IGW_INSTITUTE_RATES_PK
  1. RATE_CLASS_ID
  2. RATE_TYPE_ID
  3. ACTIVITY_TYPE_CODE
  4. FISCAL_YEAR
  5. LOCATION_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
IGW_INSTITUTE_RATES.RATE_CLASS_ID
IGW_INSTITUTE_RATES.RATE_TYPE_ID 		IGW_RATE_TYPES
Comments

IGW_INSTITUTE_RATES stores rate information about a particular activity type, location, fiscal year, rate class, and rate type. These rates are used in budget calculations.

Indexes
Index Type Tablespace Column
IGW_INSTITUTE_RATES_U1 UNIQUE APPS_TS_TX_IDX RATE_CLASS_ID
RATE_TYPE_ID
ACTIVITY_TYPE_CODE
FISCAL_YEAR
LOCATION_CODE
Columns
Name Datatype Length Mandatory Comments
RATE_CLASS_ID NUMBER (10) Y Rate class identifier
RATE_TYPE_ID NUMBER (10) Y Rate type identifier
ACTIVITY_TYPE_CODE VARCHAR2 (30) Y Activity type. Values are taken from the lookups IGW_ACTIVITY_TYPES.
FISCAL_YEAR NUMBER (4) Y No Longer Used
LOCATION_CODE VARCHAR2 (30) Y Indicates the location for which the rates are valid. Values are taken from the lookups IGW_LOCATION.
START_DATE DATE
Y First effective start date for the associated rate
RATE NUMBER (5) Y Rate associated with a particular rate class, rate type, activity type, location, and fiscal year for budgeting purposes
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column

[top of page]

IGW.IGW_INSTITUTE_RATES does not reference any database object

IGW.IGW_INSTITUTE_RATES is referenced by following:

APPS
SYNONYM - IGW_INSTITUTE_RATES

[top of page]

Table: IGW_ORG_DETAILS

Description: Organization details
Primary Key: IGW_ORG_DETAILS_PK
  1. ORGANIZATION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IGW_ORG_DETAILS.ORGANIZATION_ID HR_ALL_ORGANIZATION_UNITS
Comments

IGW_ORG_DETAILS stores details for the applicant organization and the applicant unit.
Detail examples include Signing Official, Administrative Official, Entity Identification Number, Taxpayer's Identification Number, and DUNS number.

Indexes
Index Type Tablespace Column
IGW_ORG_DETAILS_U1 UNIQUE APPS_TS_TX_IDX ORGANIZATION_ID
Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER (15) Y Organization identifier
AGREEMENT_DATE DATE

Division of Health and Human Services agreement date
NEGOTIATING_AGREEMENT_WITH VARCHAR2 (50)
Regional office with which Division of Health and Human Services agreement is being negotiated.
RATE_ESTABLISHED_WITH VARCHAR2 (50)
Regional office with which rate has been established, in case no Division of Health and Human Services agreement has been established
RATE_ESTABLISHED_DATE DATE

Date when rate was established
ADMIN_OFFICIAL_ID NUMBER (15)
Administrative official identifier
SIGNING_OFFICIAL_ID NUMBER (15)
Signing official identifier
ORG_IPF_CODE VARCHAR2 (20)
Organization's Institutional Profile Code
CONGRESS_DISTRICT VARCHAR2 (50)
Congressional district
EIN VARCHAR2 (20)
Employer Identification Number
TIN VARCHAR2 (20)
Taxpayer Identification Number
DUNS_NUMBER VARCHAR2 (20)
Data Universal Numbering System number
DUNS4_NUMBER VARCHAR2 (20)
Data Universal Numbering System + 4 number
DODAAC_NUMBER VARCHAR2 (20)
Department of Defense Activity Address Code number
CAGE_NUMBER VARCHAR2 (20)
Commercial And Government Entity number
HUMAN_EXEMPTION_NUMBER VARCHAR2 (20)
Human exemption number
HUMAN_ASSURANCE_NUMBER VARCHAR2 (20)
Human assurance number
ANIMAL_ASSURANCE_NUMBER VARCHAR2 (20)
Animal assurance number
NSF_INSTITUTIONAL_CODE VARCHAR2 (20)
National Science Foundation institutional code
NIH_SUBDIVISION_CODE VARCHAR2 (30)
Major subdivision code
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield 1 structure defining column
ATTRIBUTE_CATEGORY2 VARCHAR2 (30)
Descriptive Flexfield 2 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

[top of page]

IGW.IGW_ORG_DETAILS does not reference any database object

IGW.IGW_ORG_DETAILS is referenced by following:

APPS
SYNONYM - IGW_ORG_DETAILS

[top of page]

Table: IGW_ORG_MAPS_ALL

Description: Maps used for notification or routing the proposal for approval
Primary Key: IGW_ORG_MAPS_ALL_PK
  1. MAP_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IGW_ORG_MAPS_ALL.ORGANIZATION_ID HR_ALL_ORGANIZATION_UNITS
Foreign Keys to this table:
Foreign Key Column Foreign Table
IGW_BUSINESS_RULES_ALL.MAP_ID IGW_ORG_MAPS_ALL
IGW_ORG_MAP_DETAILS.MAP_ID IGW_ORG_MAPS_ALL
Comments

IGW_ORG_MAPS_ALL stores proposal routing and notification maps for an organization. A map is a sequence of stops. Each stop has at least one primary approver and can have one or more alternate approvers.

Indexes
Index Type Tablespace Column
IGW_ORG_MAPS_ALL_U1 UNIQUE APPS_TS_TX_IDX MAP_ID
IGW_ORG_MAPS_ALL_U2 UNIQUE APPS_TS_TX_IDX DESCRIPTION
Columns
Name Datatype Length Mandatory Comments
MAP_ID NUMBER (10) Y Map identifier
ORGANIZATION_ID NUMBER (15) Y Organization identifier. Identifies the organization for which the map is created.
DESCRIPTION VARCHAR2 (30) Y Map name
ORG_ID NUMBER (15)
Operating unit identifier for multiple organizations
START_DATE_ACTIVE DATE
Y First effective date of a map
END_DATE_ACTIVE DATE

Last effective date of a map
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column

[top of page]

IGW.IGW_ORG_MAPS_ALL does not reference any database object

IGW.IGW_ORG_MAPS_ALL is referenced by following:

APPS
SYNONYM - IGW_ORG_MAPS_ALL

[top of page]

Table: IGW_ORG_MAP_DETAILS

Description: Details about personnel who approve or receive notifications
Primary Key: IGW_ORG_MAP_DETAILS_PK
  1. MAP_ID
  2. STOP_ID
  3. USER_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
IGW_ORG_MAP_DETAILS.MAP_ID IGW_ORG_MAPS_ALL
IGW_ORG_MAP_DETAILS.USER_NAME FND_USER
Comments

IGW_ORG_MAPS_DETAILS stores personnel information for all approval map stops. Each map has at least one stop having a primary approver. For notification maps, all persons in the map are notified collectively.

Indexes
Index Type Tablespace Column
IGW_ORG_MAP_DETAILS_U1 UNIQUE APPS_TS_TX_IDX MAP_ID
STOP_ID
USER_NAME
Columns
Name Datatype Length Mandatory Comments
MAP_ID NUMBER (10) Y Map identifier
STOP_ID NUMBER (4) Y Stop identifier
USER_NAME VARCHAR2 (100) Y Application user name of the approver or the person to whom notification is sent
APPROVER_TYPE VARCHAR2 (1)
Type of approver in the map. P means Primary and A means Alternate.
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column

[top of page]

IGW.IGW_ORG_MAP_DETAILS does not reference any database object

IGW.IGW_ORG_MAP_DETAILS is referenced by following:

APPS
SYNONYM - IGW_ORG_MAP_DETAILS

[top of page]

Table: IGW_ORG_QUESTIONS

Description: Answers to questions pertaining to an organization
Primary Key: IGW_ORG_YNQ_PK
  1. ORGANIZATION_ID
  2. QUESTION_NUMBER
Foreign Keys from this table:
Foreign Key Column Foreign Table
IGW_ORG_QUESTIONS.ORGANIZATION_ID HR_ALL_ORGANIZATION_UNITS
IGW_ORG_QUESTIONS.QUESTION_NUMBER IGW_QUESTIONS
Foreign Keys to this table:
Foreign Key Column Foreign Table
IGW_REPORT_Q_EXPLANATION.ORGANIZATION_ID
IGW_REPORT_Q_EXPLANATION.QUESTION_NUMBER 		IGW_ORG_QUESTIONS
Comments

IGW_ORG_QUESTIONS stores answers to questions about an organization. It also
includes an explanation and a review date for answers.

Indexes
Index Type Tablespace Column
IGW_ORG_YNQ_U1 UNIQUE APPS_TS_TX_IDX ORGANIZATION_ID
QUESTION_NUMBER
Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER (15) Y Organization identifier
QUESTION_NUMBER VARCHAR2 (5) Y Question number
ANSWER VARCHAR2 (1)
Answer to the question. Possible values are 1 for Yes, 2 for No, and 3 for Not Applicable.
EXPLANATION VARCHAR2 (800)
Explanation for answer
REVIEW_DATE DATE

Date answer was reviewed
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column

[top of page]

IGW.IGW_ORG_QUESTIONS does not reference any database object

IGW.IGW_ORG_QUESTIONS is referenced by following:

APPS
SYNONYM - IGW_ORG_QUESTIONS

[top of page]

Table: IGW_ORG_TYPES

Description: Information about organization types
Primary Key: IGW_ORG_TYPE_PK
  1. ORGANIZATION_ID
  2. ORGANIZATION_TYPE_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
IGW_ORG_TYPES.ORGANIZATION_ID HR_ALL_ORGANIZATION_UNITS
Comments

IGW_ORG_TYPES stores the organization's type. Examples of organization types include minority-owned businesses, nonprofit organizations, and Federal facilities.

Indexes
Index Type Tablespace Column
IGW_ORG_TYPES_U1 UNIQUE APPS_TS_TX_IDX ORGANIZATION_ID
ORGANIZATION_TYPE_CODE
Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER (15) Y Organization identifier
ORGANIZATION_TYPE_CODE VARCHAR2 (30) Y Indicates organization type. Values are taken from the lookups IGW_ORGANIZATION_TYPES.
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column

[top of page]

IGW.IGW_ORG_TYPES does not reference any database object

IGW.IGW_ORG_TYPES is referenced by following:

APPS
SYNONYM - IGW_ORG_TYPES

[top of page]

Table: IGW_PERSON_BIOSKETCH

Description: Information about a person's biosketch
Primary Key: IGW_PERSON_BIOSKETCH_PK
  1. PERSON_BIOSKETCH_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
IGW_PROP_PERSON_BIOSKETCH.PERSON_BIOSKETCH_ID IGW_PERSON_BIOSKETCH
Comments

IGW_PERSON_BIOSKETCH stores information about a person's biosketch background.
Biosketch type is seeded with the values experience, honors, memberships, and publications. These values are used to categorize the information in the biosketch. ENABLE_FLAG determines whether a particular biosketch line is included in the person's biosketch or left out.

Indexes
Index Type Tablespace Column
IGW_PERSON_BIOSKETCH_U1 UNIQUE APPS_TS_TX_IDX PERSON_BIOSKETCH_ID
Columns
Name Datatype Length Mandatory Comments
PERSON_BIOSKETCH_ID NUMBER (10) Y Person's biosketch identifier
PERSON_ID NUMBER (15)
Person identifier
BIOSKETCH_TYPE VARCHAR2 (30) Y Biosketch type. Values are taken from the lookups IGW_BIOSKETCH_TYPES.
LINE_SEQUENCE NUMBER (4) Y Biosketch line sequence that is system-generated
LINE_DESCRIPTION VARCHAR2 (500) Y Biosketch line description
ENABLE_FLAG VARCHAR2 (1) Y Flag that determines whether the line is shown in the proposal. Possible values are Y and N.
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
PARTY_ID NUMBER (15) Y Party identifier for person
RECORD_VERSION_NUMBER NUMBER (15)
Record version number for locking purposes.

[top of page]

IGW.IGW_PERSON_BIOSKETCH does not reference any database object

IGW.IGW_PERSON_BIOSKETCH is referenced by following:

APPS
SYNONYM - IGW_PERSON_BIOSKETCH

[top of page]

Table: IGW_PERSON_DEGREES

Description: Information about a person's education
Primary Key: IGW_PERSON_DEGREES_PK
  1. PERSON_DEGREE_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
IGW_PROP_PERSON_DEGREES.PERSON_DEGREE_ID IGW_PERSON_DEGREES
Comments

IGW_PERSON_DEGREES stores information about a person's education. Information includes school name, date of graduation, degree type, and area of specialization.

Indexes
Index Type Tablespace Column
IGW_PERSON_DEGREES UNIQUE APPS_TS_TX_IDX PERSON_DEGREE_ID
Columns
Name Datatype Length Mandatory Comments
PERSON_DEGREE_ID NUMBER (10) Y Person's degree identifier
PERSON_ID NUMBER (15)
Person identifier
DEGREE_TYPE_CODE VARCHAR2 (30) Y Degree type. Values are taken from the lookups IGW_DEGREE_TYPES.
GRADUATION_DATE DATE
Y Date of graduation for degree under consideration
DEGREE VARCHAR2 (80) Y Degree name
DEGREE_SEQUENCE NUMBER (3) Y Degree sequence
FIELD_OF_STUDY VARCHAR2 (80)
Field of study for the degree under consideration
SPECIALIZATION VARCHAR2 (80)
Specialization for degree under consideration
SCHOOL_NAME VARCHAR2 (100)
School from which degree was obtained
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y 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
PARTY_ID NUMBER (15) Y Party identifier for person
RECORD_VERSION_NUMBER NUMBER (15)
Record version number for locking purposes.

[top of page]

IGW.IGW_PERSON_DEGREES does not reference any database object

IGW.IGW_PERSON_DEGREES is referenced by following:

APPS
SYNONYM - IGW_PERSON_DEGREES

[top of page]

Table: IGW_PROJECT_FUNDINGS

Description: Information about awards project funding
Primary Key: IGW_PROJECT_FUNDINGS_PK
  1. PROPOSAL_FUNDING_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IGW_PROJECT_FUNDINGS.PROPOSAL_INSTALLMENT_ID IGW_INSTALLMENTS
Comments

IGW_PROJECT_FUNDINGS stores funding information of awards or installments defined in IGW_INSTALLMENTS. A project can be funded at the top task or at the project level.

Indexes
Index Type Tablespace Column
IGW_PROJECT_FUNDINGS_U1 UNIQUE APPS_TS_TX_IDX PROPOSAL_FUNDING_ID
IGW_PROJECT_FUNDINGS_N1 NONUNIQUE APPS_TS_TX_IDX PROPOSAL_INSTALLMENT_ID
Columns
Name Datatype Length Mandatory Comments
PROPOSAL_FUNDING_ID NUMBER (15) Y Proposal funding identifier
PROPOSAL_INSTALLMENT_ID NUMBER (15) Y Proposal installment identifier
PROJECT_ID NUMBER (15)
Proposal identifier
TASK_ID NUMBER (15)
Task identifier
FUNDING_AMOUNT NUMBER

Amount that is funded for a project, task, and award combination
RECORD_VERSION_NUMBER NUMBER (15) Y Field for storing locking sequence number
DATE_ALLOCATED DATE

Date at which funding is allocated
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column

[top of page]

IGW.IGW_PROJECT_FUNDINGS does not reference any database object

IGW.IGW_PROJECT_FUNDINGS is referenced by following:

APPS
SYNONYM - IGW_PROJECT_FUNDINGS

[top of page]

Table: IGW_PROPOSALS_ALL

Description: Core information about proposals
Primary Key: IGW_PROPOSALS_PK
  1. PROPOSAL_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IGW_PROPOSALS_ALL.LEAD_ORGANIZATION_ID HR_ALL_ORGANIZATION_UNITS
IGW_PROPOSALS_ALL.SUBMITTING_ORGANIZATION_ID HR_ALL_ORGANIZATION_UNITS
Foreign Keys to this table:
Foreign Key Column Foreign Table
IGW_AWARDS.PROPOSAL_ID IGW_PROPOSALS_ALL
IGW_BUDGETS.PROPOSAL_ID IGW_PROPOSALS_ALL
IGW_PROP_ABSTRACTS.PROPOSAL_ID IGW_PROPOSALS_ALL
IGW_PROP_APPROVAL_RUNS.PROPOSAL_ID IGW_PROPOSALS_ALL
IGW_PROP_CHECKLIST.PROPOSAL_ID IGW_PROPOSALS_ALL
IGW_PROP_COMMENTS.PROPOSAL_ID IGW_PROPOSALS_ALL
IGW_PROP_COMMENTS.PROPOSAL_ID IGW_PROPOSALS_ALL
IGW_PROP_COMPONENT_STATUSES.PROPOSAL_ID IGW_PROPOSALS_ALL
IGW_PROP_LOCATIONS.PROPOSAL_ID IGW_PROPOSALS_ALL
IGW_PROP_NARRATIVES.PROPOSAL_ID IGW_PROPOSALS_ALL
IGW_PROP_PERSONS.PROPOSAL_ID IGW_PROPOSALS_ALL
IGW_PROP_PROGRAM_ADDRESSES.PROPOSAL_ID IGW_PROPOSALS_ALL
IGW_PROP_QUESTIONS.PROPOSAL_ID IGW_PROPOSALS_ALL
IGW_PROP_SCIENCE_CODES.PROPOSAL_ID IGW_PROPOSALS_ALL
IGW_PROP_SPECIAL_REVIEWS.PROPOSAL_ID IGW_PROPOSALS_ALL
IGW_PROP_USERS.PROPOSAL_ID IGW_PROPOSALS_ALL
IGW_STUDY_TITLES.PROPOSAL_ID IGW_PROPOSALS_ALL
Comments

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

Indexes
Index Type Tablespace Column
IGW_PROPOSALS_ALL_U1 UNIQUE APPS_TS_TX_IDX PROPOSAL_ID
IGW_PROPOSALS_ALL_U2 UNIQUE APPS_TS_TX_IDX PROPOSAL_NUMBER
SYS_IL0000099427C00082$$ UNIQUE APPS_TS_TX_DATA
IGW_PROPOSALS_ALL_N1 NONUNIQUE APPS_TS_TX_IDX PARENT_PROPOSAL_ID
IGW_PROPOSALS_ALL_N2 NONUNIQUE APPS_TS_TX_IDX ORIGINAL_PROPOSAL_ID
Columns
Name Datatype Length Mandatory Comments
PROPOSAL_ID NUMBER (15) Y Proposal identifier
PROPOSAL_NUMBER VARCHAR2 (30) Y 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
Y Proposal start date
PROPOSAL_END_DATE DATE
Y Proposal end date
PROPOSAL_TITLE VARCHAR2 (250)
Detailed title of the proposal
PROPOSAL_TYPE_CODE VARCHAR2 (30) Y 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) Y 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
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y 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
Y 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

[top of page]

IGW.IGW_PROPOSALS_ALL does not reference any database object

IGW.IGW_PROPOSALS_ALL is referenced by following:

APPS
SYNONYM - IGW_PROPOSALS_ALL

[top of page]

Table: IGW_PROP_ABSTRACTS

Description: Paragraph and resource information
Primary Key: IGW_PROP_ABSTRACTS_PK
  1. PROPOSAL_ID
  2. ABSTRACT_TYPE_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
IGW_PROP_ABSTRACTS.PROPOSAL_ID IGW_PROPOSALS_ALL
Comments

IGW_PROP_ABSTRACTS stores paragraph and resource information included in the proposal.

Indexes
Index Type Tablespace Column
IGW_PROP_ABSTRACTS_U1 UNIQUE APPS_TS_TX_IDX PROPOSAL_ID
ABSTRACT_TYPE_CODE
SYS_IL0000099435C00028$$ UNIQUE APPS_TS_TX_DATA
Columns
Name Datatype Length Mandatory Comments
PROPOSAL_ID NUMBER (15) Y Proposal identifier
ABSTRACT_TYPE VARCHAR2 (30) Y Lookup type that distinguishes paragraph and resource types. Possible values are IGW_ABSTRACT_TYPES and IGW_RESOURCE_TYPES.
ABSTRACT_TYPE_CODE VARCHAR2 (30) Y Paragraph or Resource types. The code is taken from IGW_ABSTRACT_TYPES or IGW_RESOURCE_TYPES lookups.
ABSTRACT VARCHAR2 (4000)
Paragraph or resource details
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER (15)
Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y 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 (15) Y Locking sequence number
PARAGRAPH_TITLE VARCHAR2 (150)
Short title for paragraph
ABSTRACT_CLOB CLOB (4000)
Paragraph or resource details. This field allows largs amounts of data to be stored.

[top of page]

IGW.IGW_PROP_ABSTRACTS does not reference any database object

IGW.IGW_PROP_ABSTRACTS is referenced by following:

APPS
SYNONYM - IGW_PROP_ABSTRACTS

[top of page]

Table: IGW_PROP_APPROVAL_RUNS

Description: History of proposal approval process
Primary Key: IGW_PROP_APPROVAL_RUNS_PK
  1. RUN_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IGW_PROP_APPROVAL_RUNS.PROPOSAL_ID IGW_PROPOSALS_ALL
Foreign Keys to this table:
Foreign Key Column Foreign Table
IGW_PROP_MAPS.RUN_ID IGW_PROP_APPROVAL_RUNS
Comments

IGW_PROP_APPROVAL_RUNS stores the history of every proposal approval process invoked for approving a proposal. This table contains the status of the proposal approval process, which can have the values of In-Progress, Approved, Rejected, or Error.

Indexes
Index Type Tablespace Column
IGW_PROP_APPROVAL_RUNS_U1 UNIQUE APPS_TS_TX_IDX RUN_ID
IGW_PROP_APPROVAL_RUNS_U2 UNIQUE APPS_TS_TX_IDX PROPOSAL_ID
RUN_NUMBER
Columns
Name Datatype Length Mandatory Comments
RUN_ID NUMBER (15) Y Run identifier
PROPOSAL_ID NUMBER (15) Y Proposal identifier
RUN_NUMBER NUMBER (4) Y Run or invocation sequence number of the proposal approval process. It starts with 1 for each proposal and is incremented by 1 for each invocation of the proposal approval process.
STATUS_CODE VARCHAR2 (30) Y Status of the proposal approval. Possible values are I for Approval in Progress, A for Approved, R for Rejected, or E for Error.
STATUS_DATE DATE

Date corresponding to the status

[top of page]

IGW.IGW_PROP_APPROVAL_RUNS does not reference any database object

IGW.IGW_PROP_APPROVAL_RUNS is referenced by following:

APPS
SYNONYM - IGW_PROP_APPROVAL_RUNS

[top of page]

Table: IGW_PROP_CHECKLIST

Description: Status of proposal component
Primary Key: IGW_PROP_CHECKLIST_PK
  1. PROPOSAL_ID
  2. DOCUMENT_TYPE_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
IGW_PROP_CHECKLIST.PROPOSAL_ID IGW_PROPOSALS_ALL
Comments

IGW_PROP_CHECKLIST stores statuses of proposal components. A proposal is comprised of budgets, narratives, and other components.

Indexes
Index Type Tablespace Column
IGW_PROP_CHECKLIST_U1 UNIQUE APPS_TS_TX_IDX PROPOSAL_ID
DOCUMENT_TYPE_CODE
Columns
Name Datatype Length Mandatory Comments
PROPOSAL_ID NUMBER (15) Y Proposal identifier
DOCUMENT_TYPE_CODE VARCHAR2 (30) Y Proposal component. The code is taken from IGW_SS_PROP_DOC_TYPES lookup.
CHECKLIST_ORDER NUMBER (2)
Order in which component records are displayed
COMPLETE VARCHAR2 (1)
Flag to indicate whether or not proposal component has been completed. Possible values are Y or N.
NOT_APPLICABLE VARCHAR2 (1)
Flag to indicate whether or not component is applicable to this proposal. Possible values are Y or N.
LAST_UPDATE_DATE DATE

Standard Who column
RECORD_VERSION_NUMBER NUMBER
Y Locking sequence number
LAST_UPDATED_BY NUMBER (15)
Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
DUE_DATE DATE

Identifies when the document is due
DATE_SUBMITTED DATE

identifies the submission date
COMMENTS VARCHAR2 (2000)
stores the comments
STATUS VARCHAR2 (30)
status of the document
DATE_RECEIVED DATE

The date the proposal is received
REVIEWED_BY NUMBER

Reviewed By
REVIEW_DATE DATE

Review Date
COMPLETED_DATE DATE

Completion Date of the Checklist

[top of page]

IGW.IGW_PROP_CHECKLIST does not reference any database object

IGW.IGW_PROP_CHECKLIST is referenced by following:

APPS
SYNONYM - IGW_PROP_CHECKLIST

[top of page]

Table: IGW_PROP_COMMENTS

Description: Proposal comments
Primary Key: IGW_PROP_COMMENTS_PK
  1. PROPOSAL_ID
  2. COMMENT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IGW_PROP_COMMENTS.PROPOSAL_ID IGW_PROPOSALS_ALL
IGW_PROP_COMMENTS.PROPOSAL_ID IGW_PROPOSALS_ALL
Comments

IGW_PROP_COMMENTS stores comments made by users on proposals.

Indexes
Index Type Tablespace Column
IGW_PROP_COMMENTS_U1 UNIQUE APPS_TS_TX_IDX PROPOSAL_ID
COMMENT_ID
Columns
Name Datatype Length Mandatory Comments
PROPOSAL_ID NUMBER (15) Y Proposal identifier
COMMENT_ID NUMBER (10) Y Comment identifier
COMMENTS VARCHAR2 (4000)
Comments about the proposal
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who Column
RECORD_VERSION_NUMBER NUMBER (15) Y Locking sequence number
SPONSOR_ACTION_DATE DATE

Date on which action has been taken by the sponsor
SPONSOR_ACTION_CODE VARCHAR2 (30)
Action taken by sponsor on the proposal. The code is taken from IGW_SPONSOR_ACTION_CODE lookup.
PARENT_ID NUMBER (15)
Immediate Parent Identifier
ORIGINAL_PARENT_ID NUMBER (15)
Original Parent Identifier
COMMENT_TITLE VARCHAR2 (250)
Comment Title

[top of page]

IGW.IGW_PROP_COMMENTS does not reference any database object

IGW.IGW_PROP_COMMENTS is referenced by following:

APPS
SYNONYM - IGW_PROP_COMMENTS

[top of page]

Table: IGW_PROP_COMPONENT_STATUSES

Description: Statuses of Proposal Components
Primary Key: IGW_PROP_COMPONENT_STATUS_PK
  1. PROPOSAL_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IGW_PROP_COMPONENT_STATUSES.PROPOSAL_ID IGW_PROPOSALS_ALL
Comments
Indexes
Index Type Tablespace Column
IGW_PROP_COMPONENT_STATUS_U1 UNIQUE APPS_TS_ARCHIVE PROPOSAL_ID
Columns
Name Datatype Length Mandatory Comments
PROPOSAL_ID NUMBER (15) Y
BUDGET_STATUS VARCHAR2 (1)
NARRATIVE_STATUS VARCHAR2 (1)
NARRATIVE_TYPE_CODE VARCHAR2 (30)
NARRATIVE_SUBMISSION_CODE VARCHAR2 (30)
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15) Y

[top of page]

IGW.IGW_PROP_COMPONENT_STATUSES does not reference any database object

IGW.IGW_PROP_COMPONENT_STATUSES is referenced by following:

APPS
SYNONYM - IGW_PROP_COMPONENT_STATUSES

[top of page]

Table: IGW_PROP_LOCATIONS

Description: Sites where proposal activity is conducted
Primary Key: IGW_PROP_LOCATIONS_PK
  1. PROPOSAL_ID
  2. PERFORMING_ORGANIZATION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IGW_PROP_LOCATIONS.PROPOSAL_ID IGW_PROPOSALS_ALL
IGW_PROP_LOCATIONS.PERFORMING_ORGANIZATION_ID HR_ALL_ORGANIZATION_UNITS
Comments

IGW_PROP_LOCATIONS stores information about the performing sites and locations where the proposal activity will be conducted. Several performing sites can exist for a given proposal.

Indexes
Index Type Tablespace Column
IGW_PROP_LOCATIONS_U1 UNIQUE APPS_TS_TX_IDX PROP_LOCATION_ID
Columns
Name Datatype Length Mandatory Comments
PROPOSAL_ID NUMBER (15) Y Proposal identifier
PERFORMING_ORGANIZATION_ID NUMBER (15)
Locations or sites where the proposal activity will be carried out
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
RECORD_VERSION_NUMBER NUMBER
Y Field for storing locking sequence number
PROP_LOCATION_ID NUMBER (15) Y Proposal location identifier
PARTY_ID NUMBER (15)
Party identifier for organization
LOCATION_TYPE_CODE VARCHAR2 (30)
Identifier for location type.
CONGRESSIONAL_DISTRICT VARCHAR2 (150)
Congressional District where work is performed.
ADDITIONAL_INFORMATION VARCHAR2 (2000)
Additional Information for work site.
LONGITUDE VARCHAR2 (50)
Longitude co-ordinate where work would be performed.
RAILWAY_OWNER VARCHAR2 (150)
Name of the Railway Owner
LATITUDE VARCHAR2 (50)
Latitude co-ordinate where work would be performed.
MILEAGE_MARKER_BEGIN VARCHAR2 (50)
Mileage marker begin
MILEAGE_MARKER_END VARCHAR2 (50)
End co-ordinate of mileage
GEOGRAPHIC_LOCATION VARCHAR2 (250)
Geographic Location

[top of page]

IGW.IGW_PROP_LOCATIONS does not reference any database object

IGW.IGW_PROP_LOCATIONS is referenced by following:

APPS
SYNONYM - IGW_PROP_LOCATIONS

[top of page]

Table: IGW_PROP_MAPS

Description: Details about maps used for notification or routing a specific proposal for approval
Primary Key: IGW_PROP_MAPS_PK
  1. PROP_MAP_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IGW_PROP_MAPS.RUN_ID IGW_PROP_APPROVAL_RUNS
Foreign Keys to this table:
Foreign Key Column Foreign Table
IGW_PROP_MAP_STOPS.PROP_MAP_ID IGW_PROP_MAPS
Comments

IGW_PROP_MAPS stores details of maps used for a specific proposal. The map details are stored for each approval run for a proposal. The name of the map (DESCRIPTION) is copied from the IGW_ORG_MAP_ALL table when the proposal is submitted for approval.

Indexes
Index Type Tablespace Column
IGW_PROP_MAPS_U1 UNIQUE APPS_TS_TX_IDX PROP_MAP_ID
Columns
Name Datatype Length Mandatory Comments
PROP_MAP_ID NUMBER (15) Y Identifier for each map in a proposal approval run
PROPOSAL_ID NUMBER (15) Y Proposal identifier
DESCRIPTION VARCHAR2 (200) Y Name of map
MAP_TYPE VARCHAR2 (1) Y Type of map. R means Routing and N means Notification.
MAP_SEQUENCE_NUMBER NUMBER (4) Y Number that indicates the order in which the map is invoked for proposal approval
RUN_ID NUMBER (15) Y Run identifier
APPROVAL_STATUS VARCHAR2 (1)
Approval status of the map. A means Approved, R means Rejected, S means Submitted, and W means Waiting for approval.
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column

[top of page]

IGW.IGW_PROP_MAPS does not reference any database object

IGW.IGW_PROP_MAPS is referenced by following:

APPS
SYNONYM - IGW_PROP_MAPS

[top of page]

Table: IGW_PROP_MAP_STOPS

Description: Details about personnel who approve or receive notifications for a particular proposal
Primary Key: IGW_PROP_MAP_STOPS_PK
  1. PROP_MAP_ID
  2. STOP_ID
  3. USER_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
IGW_PROP_MAP_STOPS.PROP_MAP_ID IGW_PROP_MAPS
Comments

IGW_PROP_MAP_STOPS stores personnel information for each map in the IGW_PROP_MAPS table during proposal approval. It includes information such as submission date, approval date, and approval status.

Indexes
Index Type Tablespace Column
IGW_PROP_MAP_STOPS_U1 UNIQUE APPS_TS_TX_IDX PROP_MAP_ID
STOP_ID
USER_NAME
Columns
Name Datatype Length Mandatory Comments
PROP_MAP_ID NUMBER (15) Y Identifier for each map in a proposal approval run
STOP_ID NUMBER (4) Y Stop identifier
USER_NAME VARCHAR2 (100) Y Application user name of the approver or the person to whom notification is sent
WF_ROLE_NAME VARCHAR2 (100)
Workflow role name. Submit for approval process assigns a role to each stop in a map used by the process. The role is named IGW-X-Y-Z where X is the run identifier, Y is the map identifier, and Z is the stop identifier for routing maps and IGW-X-0-0 where X is the run identifier for notification maps.
WF_DISPLAY_ROLE_NAME VARCHAR2 (200) Y Display name for WF_ROLE_NAME field
APPROVER_TYPE VARCHAR2 (1)
Type of approver in the map. P means Primary and A means Alternate.
APPROVAL_STATUS VARCHAR2 (1)
Approval status for the user. A means Approved, R means Rejected, W means Waiting for approval, and S means Submitted.
SUBMISSION_DATE DATE

Date user was notified or the proposal was submitted for approval
APPROVAL_DATE DATE

Date when proposal is approved or rejected
COMMENTS VARCHAR2 (2000)
Comments entered by user in the Note field while approving or rejecting the proposal
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column

[top of page]

IGW.IGW_PROP_MAP_STOPS does not reference any database object

IGW.IGW_PROP_MAP_STOPS is referenced by following:

APPS
SYNONYM - IGW_PROP_MAP_STOPS

[top of page]

Table: IGW_PROP_NARRATIVES

Description: Information about proposal narratives
Primary Key: IGW_NARRATIVE_PK
  1. PROPOSAL_ID
  2. MODULE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IGW_PROP_NARRATIVES.PROPOSAL_ID IGW_PROPOSALS_ALL
Comments

IGW_PROP_NARRATIVES stores information about proposal narratives. It includes information such as module title, module status, name, address, and e-mail of the person responsible for the specific module. A narrative can be in one of several allowable formats and can be attached to a specific module.

Indexes
Index Type Tablespace Column
IGW_NARRATIVE_U1 UNIQUE APPS_TS_TX_IDX PROPOSAL_ID
MODULE_ID
SYS_IL0000099447C00018$$ UNIQUE APPS_TS_TX_DATA
Columns
Name Datatype Length Mandatory Comments
PROPOSAL_ID NUMBER (15) Y Proposal identifier
MODULE_ID NUMBER (10) Y Module identifier
MODULE_TITLE VARCHAR2 (250) Y Title of module
MODULE_STATUS VARCHAR2 (1) Y Status of module. Possible values are C for Complete and I for Incomplete.
CONTACT_NAME VARCHAR2 (30)
Contact person for the module
PHONE_NUMBER VARCHAR2 (30)
Phone number of contact person for the module
EMAIL_ADDRESS VARCHAR2 (60)
E-mail of contact person for the module
COMMENTS VARCHAR2 (250)
Comments about module
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
RECORD_VERSION_NUMBER NUMBER
Y Locking sequence number
CONTACT_ID NUMBER (15)
Contact Identifier
ABSTRACT_TYPE VARCHAR2 (30)
Abstract Type
ABSTRACT_TYPE_CODE VARCHAR2 (30)
Abstract Type Code
COMMENTS_CLOB CLOB (4000)
Narrative Text

[top of page]

IGW.IGW_PROP_NARRATIVES does not reference any database object

IGW.IGW_PROP_NARRATIVES is referenced by following:

APPS
SYNONYM - IGW_PROP_NARRATIVES

[top of page]

Table: IGW_PROP_PERSONS

Description: Personnel included in the proposal
Primary Key: IGW_PROP_PERSONS_PK
  1. PROPOSAL_ID
  2. PERSON_PARTY_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IGW_PROP_PERSONS.PROPOSAL_ID IGW_PROPOSALS_ALL
IGW_PROP_PERSONS.PERSON_ORGANIZATION_ID HR_ALL_ORGANIZATION_UNITS
Foreign Keys to this table:
Foreign Key Column Foreign Table
IGW_BUDGET_PERSONS.PROPOSAL_ID
IGW_BUDGET_PERSONS.PERSON_ID 		IGW_PROP_PERSONS
IGW_PROP_PERSON_SUPPORT.PROPOSAL_ID
IGW_PROP_PERSON_SUPPORT.PERSON_ID 		IGW_PROP_PERSONS
Comments

IGW_PROP_PERSONS stores information about personnel included on the proposal. The role of personnel on the proposal and their estimated effort is specified. PI_FLAG identifies the Proposal Manager and KEY_PERSON_FLAG identifies key personnel on the proposal.

Indexes
Index Type Tablespace Column
IGW_PROP_PERSONS_U1 UNIQUE APPS_TS_TX_IDX PROPOSAL_ID
PERSON_PARTY_ID
Columns
Name Datatype Length Mandatory Comments
PROPOSAL_ID NUMBER (15) Y Proposal identifier
PERSON_ID NUMBER (15)
Person identifier
PERSON_SEQUENCE NUMBER (3)
Order in which personnel records are displayed
PROPOSAL_ROLE_CODE VARCHAR2 (30) Y Role of person on the proposal. Code is taken from IGW_PROPOSAL_ROLE_TYPES lookup.
PI_FLAG VARCHAR2 (1)
Proposal Manager indicator. Possible values are Y or N.
KEY_PERSON_FLAG VARCHAR2 (1)
Flag indicates whether the person has a key responsibility in the proposal. Possible values are Y or N.
PERCENT_EFFORT NUMBER (5)
Percentage effort the person is putting on the proposal
PERSON_ORGANIZATION_ID NUMBER (15)
Organization with which the person is associated
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
RECORD_VERSION_NUMBER NUMBER (15) Y Locking sequence number
PERSON_PARTY_ID NUMBER (15) Y Party identifier for person
ORG_PARTY_ID NUMBER (15)
Party identifier for organization
PERSON_ORGANIZATION_NAME VARCHAR2 (240)
Name of organization that person is associated with.
ADDITIONAL_INFO VARCHAR2 (250)
Any additional information about person.
PROP_PERSON_ID NUMBER (15)
Identifier for Proposal Person

[top of page]

IGW.IGW_PROP_PERSONS does not reference any database object

IGW.IGW_PROP_PERSONS is referenced by following:

APPS
SYNONYM - IGW_PROP_PERSONS

[top of page]

Table: IGW_PROP_PERSON_BIOSKETCH

Description: Information about a person's proposal biosketch
Primary Key: IGW_PROP_PERSON_BIOSKETCH_PK
  1. PROPOSAL_ID
  2. PERSON_BIOSKETCH_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IGW_PROP_PERSON_BIOSKETCH.PERSON_BIOSKETCH_ID IGW_PERSON_BIOSKETCH
Comments

IGW_PROP_PERSON_BIOSKETCH stores information about a person's biosketch for a proposal. This information is printed in the proposal. SHOW_FLAG determines whether the line is printed in the proposal to be submitted or left out. The default line sequence that appears can be changed by the user.

Indexes
Index Type Tablespace Column
IGW_PROP_PERSON_BIOSKETCH_U1 UNIQUE APPS_TS_TX_IDX PROPOSAL_ID
PERSON_BIOSKETCH_ID
Columns
Name Datatype Length Mandatory Comments
PROPOSAL_ID NUMBER (15) Y Proposal identifier
PERSON_BIOSKETCH_ID NUMBER (10) Y Person biosketch line identifier
SHOW_FLAG VARCHAR2 (1) Y Flag determines whether to print this line of biosketch in the proposal. Possible values are Y and N.
LINE_SEQUENCE NUMBER (4) Y Biosketch line sequence for the proposal
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
RECORD_VERSION_NUMBER NUMBER
Y Locking sequence number

[top of page]

IGW.IGW_PROP_PERSON_BIOSKETCH does not reference any database object

IGW.IGW_PROP_PERSON_BIOSKETCH is referenced by following:

APPS
SYNONYM - IGW_PROP_PERSON_BIOSKETCH

[top of page]

Table: IGW_PROP_PERSON_DEGREES

Description: Information about a person's degrees
Primary Key: IGW_PROP_PERSON_DEGREES_PK
  1. PROPOSAL_ID
  2. PERSON_DEGREE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IGW_PROP_PERSON_DEGREES.PERSON_DEGREE_ID IGW_PERSON_DEGREES
Comments

IGW_PROP_PERSON_DEGREES stores information about a person's degrees for a proposal. SHOW_FLAG determines whether the line is printed in the proposal or left out.

Indexes
Index Type Tablespace Column
IGW_PROP_PERSON_DEGREES_U1 UNIQUE APPS_TS_TX_IDX PROPOSAL_ID
PERSON_DEGREE_ID
Columns
Name Datatype Length Mandatory Comments
PROPOSAL_ID NUMBER (15) Y Proposal identifier
PERSON_DEGREE_ID NUMBER (10) Y Person degree identifier
SHOW_FLAG VARCHAR2 (1) Y Flag determines whether to print this degree in the proposal. Possible values are Y and N.
DEGREE_SEQUENCE NUMBER (2) Y Sequence in which the degrees appear on screen and in the proposal
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
RECORD_VERSION_NUMBER NUMBER
Y Locking sequence number

[top of page]

IGW.IGW_PROP_PERSON_DEGREES does not reference any database object

IGW.IGW_PROP_PERSON_DEGREES is referenced by following:

APPS
SYNONYM - IGW_PROP_PERSON_DEGREES

[top of page]

Table: IGW_PROP_PERSON_QUESTIONS

Description: Answers to questions about an individual
Primary Key: IGW_PROP_PERSON_YNQ_PK
  1. PROPOSAL_ID
  2. PARTY_ID
  3. QUESTION_NUMBER
Foreign Keys from this table:
Foreign Key Column Foreign Table
IGW_PROP_PERSON_QUESTIONS.QUESTION_NUMBER IGW_QUESTIONS
Comments

IGW_PROP_PERSON_QUESTIONS stores answers to questions about an individual.
It also includes an explanation and review date for answers.

Indexes
Index Type Tablespace Column
IGW_PROP_PERSON_YNQ_U1 UNIQUE APPS_TS_TX_IDX PROPOSAL_ID
PARTY_ID
QUESTION_NUMBER
Columns
Name Datatype Length Mandatory Comments
PROPOSAL_ID NUMBER (15) Y Proposal identifier
PERSON_ID NUMBER (15)
Person identifier
QUESTION_NUMBER VARCHAR2 (5) Y Question number
ANSWER VARCHAR2 (1)
Answer to question. Possible values are 1 for Yes, 2 for No, and 3 for Not Applicable.
EXPLANATION VARCHAR2 (800)
Explanation for answer
REVIEW_DATE DATE

Review date for answer
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
RECORD_VERSION_NUMBER NUMBER
Y Locking sequence number
PARTY_ID NUMBER (15) Y Party identifier for person
PROP_PERSON_QUESTION_ID NUMBER (15)
Record identifier. Primary Key.

[top of page]

IGW.IGW_PROP_PERSON_QUESTIONS does not reference any database object

IGW.IGW_PROP_PERSON_QUESTIONS is referenced by following:

APPS
SYNONYM - IGW_PROP_PERSON_QUESTIONS

[top of page]

Table: IGW_PROP_PERSON_SUPPORT

Description: Information about other sources of support available or pending for personnel on a proposal
Primary Key: IGW_PROP_PERSON_SUPPORT_PK
  1. PROP_PERSON_SUPPORT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IGW_PROP_PERSON_SUPPORT.PROPOSAL_ID
IGW_PROP_PERSON_SUPPORT.PERSON_ID 		IGW_PROP_PERSONS
Comments

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.

Indexes
Index Type Tablespace Column
IGW_PROP_PERSON_SUPPORT_U1 UNIQUE APPS_TS_TX_IDX PROP_PERSON_SUPPORT_ID
Columns
Name Datatype Length Mandatory Comments
PROP_PERSON_SUPPORT_ID NUMBER (15) Y Proposal person other support identifier
PROPOSAL_ID NUMBER (15) Y Proposal identifier
PERSON_ID NUMBER (15)
Person identifier
SUPPORT_TYPE VARCHAR2 (30) Y 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
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y 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
Y Locking sequence number
PARTY_ID NUMBER (15) Y 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.

[top of page]

IGW.IGW_PROP_PERSON_SUPPORT does not reference any database object

IGW.IGW_PROP_PERSON_SUPPORT is referenced by following:

APPS
SYNONYM - IGW_PROP_PERSON_SUPPORT

[top of page]

Table: IGW_PROP_PROGRAM_ADDRESSES

Description: Mailing information for the proposal
Primary Key: IGW_PROP_PGM_ADDRESSES_PK
  1. PROPOSAL_ID
  2. ADDRESS_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IGW_PROP_PROGRAM_ADDRESSES.PROPOSAL_ID IGW_PROPOSALS_ALL
Comments

IGW_PROP_PROGRAM_ADDRESSES stores mailing addresses for the proposal. The number of proposal copies to be submitted and other mailing details are also stored.

Indexes
Index Type Tablespace Column
IGW_PROP_PGM_ADDRESSES_U1 UNIQUE APPS_TS_TX_IDX PROPOSAL_ID
ADDRESS_ID
IGW_PROP_PGM_ADDRESSES_N1 NONUNIQUE APPS_TS_TX_IDX PROP_GRANTOR_ID
Columns
Name Datatype Length Mandatory Comments
PROPOSAL_ID NUMBER

Proposal identifier
ADDRESS_ID NUMBER (15) Y Mailing address identifier.This gets populated only during the Internal Grantee mode. In the External Grantee mode this column will value of -1.
NUMBER_OF_COPIES NUMBER (3)
Number of proposal copies to be submitted to the mailing address
MAIL_DESCRIPTION VARCHAR2 (1000)
Mailing instructions or description
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
RECORD_VERSION_NUMBER NUMBER
Y Field for storing locking sequence number
PROP_PGM_ADDRESS_ID NUMBER (15)
Unique Identifier
PROP_GRANTOR_ID NUMBER (15)
Unique Identifier of the Grantor for a given proposal
PHONE_ID NUMBER

Phone identifier
CONTACT_ID NUMBER

Contact Identifier
ADDRESS VARCHAR2 (4000)
Address of the Grantor in the External Grantee mode
CONTACT_NAME VARCHAR2 (2000)
Name of the contact of the Grantor in the External Grantee mode
PHONE_NUMBER VARCHAR2 (2000)
Phone Number of the Grantor in the External Grantee mode

[top of page]

IGW.IGW_PROP_PROGRAM_ADDRESSES does not reference any database object

IGW.IGW_PROP_PROGRAM_ADDRESSES is referenced by following:

APPS
SYNONYM - IGW_PROP_PROGRAM_ADDRESSES

[top of page]

Table: IGW_PROP_QUESTIONS

Description: Answers to questions about a proposal
Primary Key: IGW_PROP_QUESTIONS_PK
  1. PROPOSAL_ID
  2. QUESTION_NUMBER
Foreign Keys from this table:
Foreign Key Column Foreign Table
IGW_PROP_QUESTIONS.PROPOSAL_ID IGW_PROPOSALS_ALL
IGW_PROP_QUESTIONS.QUESTION_NUMBER IGW_QUESTIONS
Comments

IGW_PROP_QUESTIONS stores answers to questions about a proposal. It also
includes an explanation and review date for answers.

Indexes
Index Type Tablespace Column
IGW_PROP_QUESTIONS_U1 UNIQUE APPS_TS_TX_IDX PROPOSAL_ID
QUESTION_NUMBER
Columns
Name Datatype Length Mandatory Comments
PROPOSAL_ID NUMBER (15) Y Proposal identifier
QUESTION_NUMBER VARCHAR2 (5) Y Question number
ANSWER VARCHAR2 (1)
Answer to question. Possible values are 1 for Yes, 2 for No, and 3 for Not Applicable.
EXPLANATION VARCHAR2 (800)
Explanation for the answer
REVIEW_DATE DATE

Date answer was reviewed
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
RECORD_VERSION_NUMBER NUMBER (15) Y Locking sequence number
PROP_QUESTION_ID NUMBER (15)
Unique identifier for proposal question.

[top of page]

IGW.IGW_PROP_QUESTIONS does not reference any database object

IGW.IGW_PROP_QUESTIONS is referenced by following:

APPS
SYNONYM - IGW_PROP_QUESTIONS

[top of page]

Table: IGW_PROP_RATES

Description: Information about overriding rates for a budget version
Primary Key: IGW_PROP_RATES_PK
  1. PROPOSAL_ID
  2. VERSION_ID
  3. RATE_CLASS_ID
  4. RATE_TYPE_ID
  5. FISCAL_YEAR
  6. LOCATION_CODE
  7. ACTIVITY_TYPE_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
IGW_PROP_RATES.PROPOSAL_ID
IGW_PROP_RATES.VERSION_ID 		IGW_BUDGETS
IGW_PROP_RATES.RATE_CLASS_ID
IGW_PROP_RATES.RATE_TYPE_ID 		IGW_RATE_TYPES
Comments

IGW_PROP_RATES stores rates that override the ones defined in setup. These rates are specific for a budget version. For overhead, employee benefits, or inflation calculations, rates defined in this table are applied instead of those defined in setup.

Indexes
Index Type Tablespace Column
IGW_PROP_RATES_U1 UNIQUE APPS_TS_TX_IDX PROPOSAL_ID
VERSION_ID
RATE_CLASS_ID
RATE_TYPE_ID
FISCAL_YEAR
LOCATION_CODE
ACTIVITY_TYPE_CODE
Columns
Name Datatype Length Mandatory Comments
PROPOSAL_ID NUMBER (15) Y Proposal identifier
VERSION_ID NUMBER (4) Y Identifier for a budget version
RATE_CLASS_ID NUMBER (10) Y Rate class identifier
RATE_TYPE_ID NUMBER (10) Y Rate type identifier
FISCAL_YEAR VARCHAR2 (4) Y Fiscal year
LOCATION_CODE VARCHAR2 (30) Y Indicates the location. Values are taken from the lookups IGW_LOCATION.
ACTIVITY_TYPE_CODE VARCHAR2 (30) Y Activity type. Values are taken from the lookups IGW_ACTIVITY_TYPES.
START_DATE DATE
Y First effective start date for the overriding rate
APPLICABLE_RATE NUMBER (5) Y Overriding rate associated with a particular rate class, rate type, activity type, location, and fiscal year for budgeting purposes
INSTITUTE_RATE NUMBER (5)
Setup rate associated with a particular rate class, rate type, activity type, location, and fiscal year for budgeting purposes
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
RECORD_VERSION_NUMBER NUMBER
Y Field for storing locking sequence number

[top of page]

IGW.IGW_PROP_RATES does not reference any database object

IGW.IGW_PROP_RATES is referenced by following:

APPS
SYNONYM - IGW_PROP_RATES

[top of page]

Table: IGW_PROP_SCIENCE_CODES

Description: Keywords used in preparing a proposal
Primary Key: IGW_PROP_SCIENCE_CODES_PK
  1. PROPOSAL_ID
  2. SCIENCE_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
IGW_PROP_SCIENCE_CODES.PROPOSAL_ID IGW_PROPOSALS_ALL
IGW_PROP_SCIENCE_CODES.SCIENCE_CODE IGW_SCIENCE_CODES
Comments

IGW_PROP_SCIENCE_CODES stores keywords used in preparing the proposal. Keywords must be predefined in the IGW_SCIENCE_CODES table.

Indexes
Index Type Tablespace Column
IGW_PROP_SCIENCE_CODES_U1 UNIQUE APPS_TS_TX_IDX PROPOSAL_ID
SCIENCE_CODE
Columns
Name Datatype Length Mandatory Comments
PROPOSAL_ID NUMBER (15) Y Proposal identifier
SCIENCE_CODE VARCHAR2 (15) Y Keywords used in preparing the proposal
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
RECORD_VERSION_NUMBER NUMBER (15) Y Locking sequence number
PROP_SCIENCE_CODE_ID NUMBER (15)
Unique Identifier
PROP_PROGRAM_ID NUMBER

Unique Program Identifier. This will be populated only for the Program Keywords. The value for the Proposal Keywords is -1
KEYWORD_OBJECT VARCHAR2 (30)
Denotes the origin og the Keyword.

[top of page]

IGW.IGW_PROP_SCIENCE_CODES does not reference any database object

IGW.IGW_PROP_SCIENCE_CODES is referenced by following:

APPS
SYNONYM - IGW_PROP_SCIENCE_CODES

[top of page]

Table: IGW_PROP_SPECIAL_REVIEWS

Description: Special reviews conducted for a proposal
Primary Key: IGW_PROP_SPECIAL_REVIEW_PK
  1. PROPOSAL_ID
  2. SPECIAL_REVIEW_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
IGW_PROP_SPECIAL_REVIEWS.PROPOSAL_ID IGW_PROPOSALS_ALL
Comments

IGW_PROP_SPECIAL_REVIEWS stores information regarding full or expedited special reviews conducted for the proposal. A special review can relate to human subjects or vertebrate animals. For an approved special review, the protocol number must be entered.

Indexes
Index Type Tablespace Column
IGW_PROP_SPECIAL_REVIEW_U1 UNIQUE APPS_TS_TX_IDX TITLE
SPECIAL_REVIEW_CODE
PROPOSAL_ID
Columns
Name Datatype Length Mandatory Comments
PROPOSAL_ID NUMBER (15) Y Proposal identifier
SPECIAL_REVIEW_CODE VARCHAR2 (30) Y Special reviews carried out on the proposal. Code is taken from IGW_SPECIAL_REVIEWS lookup.
SPECIAL_REVIEW_TYPE VARCHAR2 (1)
Type of special review. Code is taken from IGW_SPECIAL_REVIEW_TYPES lookup.
APPROVAL_TYPE_CODE VARCHAR2 (30)
Special review approval type. Code is taken from IGW_REVIEW_APPROVAL_TYPES lookup.
PROTOCOL_NUMBER VARCHAR2 (50)
Protocol number for approved special reviews
APPLICATION_DATE DATE

Date on which special review was submitted
APPROVAL_DATE DATE

Date on which special review was approved
COMMENTS VARCHAR2 (4000)
Special review comments
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
RECORD_VERSION_NUMBER NUMBER
Y Locking sequence number
TITLE VARCHAR2 (250)
Protocol Title
SUBJECT_ENROLLMENT_CODE VARCHAR2 (30)
Subject Enrollment for a protocol.
EXEMPTION_NUMBER VARCHAR2 (50)
Exemption Number for Protocol
PROP_SPECIAL_REVIEW_ID NUMBER (15)
Unique identifier for proposal special review.

[top of page]

IGW.IGW_PROP_SPECIAL_REVIEWS does not reference any database object

IGW.IGW_PROP_SPECIAL_REVIEWS is referenced by following:

APPS
SYNONYM - IGW_PROP_SPECIAL_REVIEWS

[top of page]

Table: IGW_PROP_USERS

Description: Information about users who have proposal access
Primary Key: IGW_PROP_USERS_PK
  1. PROPOSAL_ID
  2. USER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IGW_PROP_USERS.PROPOSAL_ID IGW_PROPOSALS_ALL
IGW_PROP_USERS.USER_ID FND_USER
Foreign Keys to this table:
Foreign Key Column Foreign Table
IGW_PROP_USER_ROLES.PROPOSAL_ID
IGW_PROP_USER_ROLES.USER_ID 		IGW_PROP_USERS
Comments

IGW_PROP_USERS stores information about users who have access to a proposal.
The columns START_DATE_ACTIVE and END_DATE_ACTIVE determine whether the user is currently active.

Indexes
Index Type Tablespace Column
IGW_PROP_USERS_U1 UNIQUE APPS_TS_TX_IDX PROPOSAL_ID
USER_ID
Columns
Name Datatype Length Mandatory Comments
PROPOSAL_ID NUMBER (15) Y Proposal identifier
USER_ID NUMBER (15) Y User identifier for users of the proposal
START_DATE_ACTIVE DATE
Y Effective start date for users of the proposal
END_DATE_ACTIVE DATE

Effective end date for users of the proposal
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
RECORD_VERSION_NUMBER NUMBER
Y Locking sequence number

[top of page]

IGW.IGW_PROP_USERS does not reference any database object

IGW.IGW_PROP_USERS is referenced by following:

APPS
SYNONYM - IGW_PROP_USERS

[top of page]

Table: IGW_PROP_USER_ROLES

Description: Information about the roles assigned to users for proposal access
Primary Key: IGW_PROP_USER_ROLES_PK
  1. PROPOSAL_ID
  2. USER_ID
  3. ROLE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IGW_PROP_USER_ROLES.PROPOSAL_ID
IGW_PROP_USER_ROLES.USER_ID 		IGW_PROP_USERS
IGW_PROP_USER_ROLES.ROLE_ID IGW_ROLES
Comments

IGW_PROP_USER_ROLES stores roles assigned to the user for accessing the proposal. These roles are used for security purposes and determine the level of access given to a user.

Indexes
Index Type Tablespace Column
IGW_PROP_USER_ROLES_U1 UNIQUE APPS_TS_TX_IDX PROPOSAL_ID
USER_ID
ROLE_ID
Columns
Name Datatype Length Mandatory Comments
PROPOSAL_ID NUMBER (15) Y Proposal identifier
USER_ID NUMBER (15) Y User identifier
ROLE_ID NUMBER (10) Y Role identifier
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
RECORD_VERSION_NUMBER NUMBER
Y Locking sequence number

[top of page]

IGW.IGW_PROP_USER_ROLES does not reference any database object

IGW.IGW_PROP_USER_ROLES is referenced by following:

APPS
SYNONYM - IGW_PROP_USER_ROLES

[top of page]

Table: IGW_QUESTIONS

Description: Questions about individuals, proposals, and organizations
Primary Key: IGW_QUESTIONS_PK
  1. QUESTION_NUMBER
Foreign Keys to this table:
Foreign Key Column Foreign Table
IGW_ORG_QUESTIONS.QUESTION_NUMBER IGW_QUESTIONS
IGW_PROP_PERSON_QUESTIONS.QUESTION_NUMBER IGW_QUESTIONS
IGW_PROP_QUESTIONS.QUESTION_NUMBER IGW_QUESTIONS
IGW_QUESTIONS_TL.QUESTION_NUMBER IGW_QUESTIONS
Comments

IGW_QUESTIONS stores information about all questions pertaining to individuals, proposals, and organizations. It also contains information about which questions need an explanation and
review date to accompany the answer. For example, if the EXPLANATION_FOR_YES_FLAG is Y
and the answer to the question is Yes, the user must provide an explanation for the
answer.

Indexes
Index Type Tablespace Column
IGW_QUESTIONS_U1 UNIQUE APPS_TS_SEED QUESTION_NUMBER
Columns
Name Datatype Length Mandatory Comments
QUESTION_NUMBER VARCHAR2 (5) Y Question number
APPLIES_TO VARCHAR2 (1) Y Identifies to whom the question applies. Possible choices are I for Individual, P for Proposal, and O for Organization.
EXPLANATION_FOR_YES_FLAG VARCHAR2 (1) Y Flag determines whether an explanation is required if the answer to the question is Yes. Possible values are Y or N.
EXPLANATION_FOR_NO_FLAG VARCHAR2 (1) Y Flag determines whether an explanation is required if the answer to the question is No. Possible values are Y or N.
DATE_FOR_YES_FLAG VARCHAR2 (1) Y Flag determines whether a date is required if the answer to the question is Yes. Possible values are Y or N.
DATE_FOR_NO_FLAG VARCHAR2 (1) Y Flag determines whether a date is required if the answer to the question is No. Possible values are Y or N.
START_DATE_ACTIVE DATE
Y First effective date for the question
END_DATE_ACTIVE DATE

Last effective date for the question
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column

[top of page]

IGW.IGW_QUESTIONS does not reference any database object

IGW.IGW_QUESTIONS is referenced by following:

APPS
SYNONYM - IGW_QUESTIONS

[top of page]

Table: IGW_QUESTIONS_TL

Description: Multiple language support-related information for the main table IGW_QUESTIONS
Primary Key: IGW_QUESTIONS_TL_PK
  1. QUESTION_NUMBER
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
IGW_QUESTIONS_TL.QUESTION_NUMBER IGW_QUESTIONS
Comments

IGW_QUESTIONS_TL stores multiple language support-related information for the main table IGW_QUESTIONS.

Indexes
Index Type Tablespace Column
IGW_QUESTIONS_TL_U1 UNIQUE APPS_TS_SEED LANGUAGE
QUESTION_NUMBER
Columns
Name Datatype Length Mandatory Comments
QUESTION_NUMBER VARCHAR2 (5) Y Question number
DESCRIPTION VARCHAR2 (500) Y Question description
EXPLANATION VARCHAR2 (1000)
Explanation pertaining to the question
POLICY VARCHAR2 (1000)
Policy pertaining to the question
REGULATION VARCHAR2 (1000)
Regulation pertaining to the question
LANGUAGE VARCHAR2 (4) Y Language
SOURCE_LANG VARCHAR2 (4) Y Source language
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column

[top of page]

IGW.IGW_QUESTIONS_TL does not reference any database object

IGW.IGW_QUESTIONS_TL is referenced by following:

APPS
SYNONYM - IGW_QUESTIONS_TL

[top of page]

Table: IGW_RATE_CLASSES

Description: Information about rate classes
Primary Key: IGW_RATE_CLASSES_PK
  1. RATE_CLASS_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
IGW_BUDGETS.OH_RATE_CLASS_ID IGW_RATE_CLASSES
IGW_RATE_TYPES.RATE_CLASS_ID IGW_RATE_CLASSES
Comments

IGW_RATE_CLASSES stores information about rate classes. Rate classes include Inflation, Employee Benefits, and Overhead. Overhead is categorized into Modified Total Direct Cost, Salaries and Wages, and Other.

Indexes
Index Type Tablespace Column
IGW_RATE_CLASSES_U1 UNIQUE APPS_TS_TX_IDX RATE_CLASS_ID
Columns
Name Datatype Length Mandatory Comments
RATE_CLASS_ID NUMBER (10) Y Rate class identifier
DESCRIPTION VARCHAR2 (250) Y Rate class description
RATE_CLASS_TYPE VARCHAR2 (1) Y Rate class type. Possible values are O for Overhead, I for Inflation, and E for Employee benefits.
OVERHEAD_TYPE VARCHAR2 (6)
Overhead type. Possible values are Modified Total Direct Cost, Salaries and Wages, and Other.
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column

[top of page]

IGW.IGW_RATE_CLASSES does not reference any database object

IGW.IGW_RATE_CLASSES is referenced by following:

APPS
SYNONYM - IGW_RATE_CLASSES

[top of page]

Table: IGW_RATE_TYPES

Description: Information about rate types associated with a rate class
Primary Key: IGW_RATE_TYPES_PK
  1. RATE_CLASS_ID
  2. RATE_TYPE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IGW_RATE_TYPES.RATE_CLASS_ID IGW_RATE_CLASSES
Foreign Keys to this table:
Foreign Key Column Foreign Table
IGW_EXP_TYPE_RATE_TYPES.RATE_CLASS_ID
IGW_EXP_TYPE_RATE_TYPES.RATE_TYPE_ID 		IGW_RATE_TYPES
IGW_INSTITUTE_RATES.RATE_CLASS_ID
IGW_INSTITUTE_RATES.RATE_TYPE_ID 		IGW_RATE_TYPES
IGW_PROP_RATES.RATE_CLASS_ID
IGW_PROP_RATES.RATE_TYPE_ID 		IGW_RATE_TYPES
Comments

IGW_RATE_TYPES stores information about the rate types associated with a rate class.
This information is used for budgeting purposes.

Indexes
Index Type Tablespace Column
IGW_RATE_TYPES_U1 UNIQUE APPS_TS_TX_IDX RATE_CLASS_ID
RATE_TYPE_ID
Columns
Name Datatype Length Mandatory Comments
RATE_CLASS_ID NUMBER (10) Y Rate class identifier
RATE_TYPE_ID NUMBER (10) Y Rate type identifier
DESCRIPTION VARCHAR2 (250) Y Rate type description
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column

[top of page]

IGW.IGW_RATE_TYPES does not reference any database object

IGW.IGW_RATE_TYPES is referenced by following:

APPS
SYNONYM - IGW_RATE_TYPES

[top of page]

Table: IGW_REPORT_BUDGET

Description: Information on direct costs for proposal budget periods
Primary Key: IGW_REPORT_BUDGET_PK
  1. BUDGET_PERIOD_ID
  2. PROPOSAL_FORM_NUMBER
  3. VERSION_ID
  4. PROPOSAL_ID
  5. PROPOSAL_BUDGET_CATEGORY_CODE
Comments

IGW_REPORT_BUDGET stores direct costs for all budget periods in the proposal. The data is grouped into budget categories and their period totals.
This is a processing table used in printing proposals.

Indexes
Index Type Tablespace Column
IGW_REPORT_BUDGET_U1 UNIQUE APPS_TS_TX_IDX PROPOSAL_ID
VERSION_ID
BUDGET_PERIOD_ID
PROPOSAL_BUDGET_CATEGORY_CODE
PROPOSAL_FORM_NUMBER
Columns
Name Datatype Length Mandatory Comments
PROPOSAL_ID NUMBER (15) Y Proposal identifier
VERSION_ID NUMBER (4) Y Budget version identifier
BUDGET_PERIOD_ID NUMBER (4) Y Budget period identifier
PROPOSAL_BUDGET_CATEGORY VARCHAR2 (80)
Sponsor budget category for the proposal
PROPOSAL_BUDGET_CATEGORY_CODE VARCHAR2 (30) Y Unique code that identifies sponsor budget category
PERIOD_TOTAL_DIRECT_COST NUMBER (17)
Period total direct cost
EB_TOTAL VARCHAR2 (17)
Employee benefits amount
PROPOSAL_FORM_NUMBER VARCHAR2 (30) Y Proposal form number or EDI transaction set number. Examples are PHS 398 and 194TS.
RECENTLY_UPDATED_FLAG VARCHAR2 (1)
Flag for internal processing of data. Default value is N.

[top of page]

IGW.IGW_REPORT_BUDGET does not reference any database object

IGW.IGW_REPORT_BUDGET is referenced by following:

APPS
SYNONYM - IGW_REPORT_BUDGET

[top of page]

Table: IGW_REPORT_BUDGET_BASE_RATE

Description: Information on base amounts or direct costs for proposal budget periods
Primary Key: IGW_REPORT_BUDG_BASE_RATE_PK
  1. BUDGET_PERIOD_ID
  2. PROPOSAL_ID
  3. VERSION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IGW_REPORT_BUDGET_BASE_RATE.PROPOSAL_ID
IGW_REPORT_BUDGET_BASE_RATE.VERSION_ID
IGW_REPORT_BUDGET_BASE_RATE.BUDGET_PERIOD_ID 		IGW_BUDGET_PERIODS
Comments

IGW_REPORT_BUDGET_BASE_RATE stores base amounts or direct costs for all budget periods in the proposal.
This is a processing table used in printing proposals.

Indexes
Index Type Tablespace Column
IGW_REPORT_BUDG_BASE_RATE_U1 UNIQUE APPS_TS_TX_IDX PROPOSAL_ID
VERSION_ID
BUDGET_PERIOD_ID
Columns
Name Datatype Length Mandatory Comments
PROPOSAL_ID NUMBER (15) Y Proposal identifier
VERSION_ID NUMBER (15) Y Budget version identifier
BUDGET_PERIOD_ID NUMBER (15) Y Budget period identifier
BASE_AMOUNT NUMBER

Base amount for buget period on which indirect cost is applied
RATE_APPLIED NUMBER

Overhead rate that is applied on the base amount
TOTAL_INDIRECT_COST NUMBER (17)
Total indirect cost calculation based on base amount and applicable rate
START_DATE DATE

Start date of budget period
END_DATE DATE

End date of budget period
FISCAL_YEAR NUMBER (4)
Fiscal year on which the base rate is calculated
PROPOSAL_FORM_NUMBER VARCHAR2 (30)
Proposal form number or EDI transaction set number. Examples are PHS 398 and 194TS.

[top of page]

IGW.IGW_REPORT_BUDGET_BASE_RATE does not reference any database object

IGW.IGW_REPORT_BUDGET_BASE_RATE is referenced by following:

APPS
SYNONYM - IGW_REPORT_BUDGET_BASE_RATE

[top of page]

Table: IGW_REPORT_BUDGET_SEED

Description: Information on sponsor budget hierarchy seed data
Primary Key: IGW_REPORT_BUDGET_SEED
  1. PROPOSAL_FORM_NUMBER
  2. BUDGET_CATEGORY_CODE
  3. PROPOSAL_BUDGET_CATEGORY
  4. PROPOSAL_BUDGET_CATEGORY_CODE
Comments

IGW_REPORT_BUDGET_SEED stores seed data for reporting purposes. The seed data stores the sponsor budget hierarchy as required by the sponsor. The 194 Transaction Set sponsor budget hierarchy is seeded in this table.
This is a processing table used in printing proposals.

Indexes
Index Type Tablespace Column
IGW_REPORT_BUDGET_SEED_U1 UNIQUE APPS_TS_SEED PROPOSAL_FORM_NUMBER
PROPOSAL_BUDGET_CATEGORY
PROPOSAL_BUDGET_CATEGORY_CODE
BUDGET_CATEGORY_CODE
Columns
Name Datatype Length Mandatory Comments
PROPOSAL_FORM_NUMBER VARCHAR2 (30) Y Proposal form number or EDI transaction set number. Examples are PHS 398 and194TS.
PROPOSAL_BUDGET_CATEGORY VARCHAR2 (80) Y Sponsor budget category
PROPOSAL_BUDGET_CATEGORY_CODE VARCHAR2 (30) Y Unique code that identifies the parent sponsor budget category
BUDGET_CATEGORY_CODE VARCHAR2 (30) Y Unique code that identifies child sponsor budget category
DETAILS_REQUIRED_FLAG VARCHAR2 (1) Y Flag that indicates whether details are required for that particular PROPOSAL_BUDGET_CATEGORY. If this flag is Y, IGW_REPORT_ITEMIZED_BUDGET is populated with details.
FRINGE_FLAG VARCHAR2 (1) Y Flag that indicates whether the current record is reported as fringe benefits.The flag is set to Y if the data is reported as fringe benefits.
SEED_DATA_FLAG VARCHAR2 (1) Y Flag that indicates whether the current record is seed data. If it is seed data, the value of the flag is Y.

[top of page]

IGW.IGW_REPORT_BUDGET_SEED does not reference any database object

IGW.IGW_REPORT_BUDGET_SEED is referenced by following:

APPS
SYNONYM - IGW_REPORT_BUDGET_SEED

[top of page]

Table: IGW_REPORT_BUDG_JUSTIFICATION

Description: Information on budget justification grouped for a sponsor budget category
Comments

IGW_REPORT_BUDG_JUSTIFICATION stores budget justification grouped for a sponsor budget category.
This is a processing table used in printing proposals.

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_ID NUMBER (15) Y Proposal identifier
VERSION_ID NUMBER (15) Y Budget version identifier
PROPOSAL_BUDGET_CATEGORY VARCHAR2 (80) Y Sponsor budget category
PROPOSAL_FORM_NUMBER VARCHAR2 (30) Y Proposal form number or EDI transaction set number. Examples are PHS 398 and 194TS.
JUSTIFICATION LONG (0)
Grouped justification for a sponsor budget category

[top of page]

IGW.IGW_REPORT_BUDG_JUSTIFICATION does not reference any database object

IGW.IGW_REPORT_BUDG_JUSTIFICATION is referenced by following:

APPS
SYNONYM - IGW_REPORT_BUDG_JUSTIFICATION

[top of page]

Table: IGW_REPORT_ITEMIZED_BUDGET

Description: Information on combined expenditure category or expenditure type descriptions for a sponsor budget category
Comments

IGW_REPORT_ITEMIZED_BUDGET stores combined expenditure category or expenditure type descriptions for a sponsor budget category.
This is a processing table used in printing proposals.

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_ID NUMBER (15) Y Proposal identifier
VERSION_ID NUMBER (15) Y Budget version identifier
BUDGET_PERIOD_ID NUMBER (15) Y Budget period identifier
PROPOSAL_BUDGET_CATEGORY VARCHAR2 (80) Y Sponsor budget category
PROPOSAL_FORM_NUMBER VARCHAR2 (30)
Proposal form number or EDI transaction set number. Examples are PHS 398 and 194TS.
EXPENDITURE_DESCRIPTION LONG (0)
Grouped expenditure category or expenditure type description for a sponsor budget category

[top of page]

IGW.IGW_REPORT_ITEMIZED_BUDGET does not reference any database object

IGW.IGW_REPORT_ITEMIZED_BUDGET is referenced by following:

APPS
SYNONYM - IGW_REPORT_ITEMIZED_BUDGET

[top of page]

Table: IGW_REPORT_Q_EXPLANATION

Description: Explanations to questions
Primary Key: IGW_REPORT_Q_EXPLANATION_PK
  1. QUESTION_NUMBER
  2. ORGANIZATION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IGW_REPORT_Q_EXPLANATION.ORGANIZATION_ID
IGW_REPORT_Q_EXPLANATION.QUESTION_NUMBER 		IGW_ORG_QUESTIONS
Comments

IGW_REPORT_Q_EXPLANATION stores explanations for questions.
This is a processing table used in printing proposals.

Indexes
Index Type Tablespace Column
IGW_REPORT_Q_EXPLANATION_U1 UNIQUE APPS_TS_TX_IDX ORGANIZATION_ID
QUESTION_NUMBER
Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER (15) Y Organization identifier
QUESTION_NUMBER VARCHAR2 (4) Y Question number
EXPLANATION VARCHAR2 (2000)
Explanation to a question
PROPOSAL_FORM_NUMBER VARCHAR2 (30)
Proposal form number or EDI transaction set number. Examples are PHS 398 and 194TS.

[top of page]

IGW.IGW_REPORT_Q_EXPLANATION does not reference any database object

IGW.IGW_REPORT_Q_EXPLANATION is referenced by following:

APPS
SYNONYM - IGW_REPORT_Q_EXPLANATION

[top of page]

Table: IGW_ROLES

Description: Information about user roles
Primary Key: IGW_ROLES_PK
  1. ROLE_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
IGW_PROP_USER_ROLES.ROLE_ID IGW_ROLES
IGW_ROLES_TL.ROLE_ID IGW_ROLES
IGW_ROLE_RIGHTS.ROLE_ID IGW_ROLES
Comments

IGW_ROLES stores information about proposal roles. It also includes the start date and end date
for a role, which determines which roles are active at any particular time.

Indexes
Index Type Tablespace Column
IGW_ROLES_U1 UNIQUE APPS_TS_SEED ROLE_ID
Columns
Name Datatype Length Mandatory Comments
ROLE_ID NUMBER (10) Y Role identifier
START_DATE_ACTIVE DATE
Y First effective date of role
END_DATE_ACTIVE DATE

Last effective date of role
SEEDED_FLAG VARCHAR2 (1)
Flag that determines if the role has been seeded or use-defined. Possible values are Y and NULL.
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column

[top of page]

IGW.IGW_ROLES does not reference any database object

IGW.IGW_ROLES is referenced by following:

APPS
SYNONYM - IGW_ROLES

[top of page]

Table: IGW_ROLES_TL

Description: Multiple language support-related information for the main table IGW_ROLES
Primary Key: IGW_ROLES_TL_PK
  1. ROLE_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
IGW_ROLES_TL.ROLE_ID IGW_ROLES
Comments

IGW_ROLES_TL stores multiple language support-related information for the main table IGW_ROLES.

Indexes
Index Type Tablespace Column
IGW_ROLES_TL_U1 UNIQUE APPS_TS_SEED ROLE_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
ROLE_ID NUMBER (10) Y Role identifier
LANGUAGE VARCHAR2 (4) Y Language
SOURCE_LANG VARCHAR2 (4) Y Source language
ROLE_NAME VARCHAR2 (50) Y Role name
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column

[top of page]

IGW.IGW_ROLES_TL does not reference any database object

IGW.IGW_ROLES_TL is referenced by following:

APPS
SYNONYM - IGW_ROLES_TL

[top of page]

Table: IGW_ROLE_RIGHTS

Description: Information about rights associated with a role
Primary Key: IGW_ROLE_RIGHTS_PK
  1. ROLE_ID
  2. RIGHT_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
IGW_ROLE_RIGHTS.ROLE_ID IGW_ROLES
Comments

IGW_ROLE_RIGHTS stores rights associated with a role. The rights control access to the proposal.

Indexes
Index Type Tablespace Column
IGW_ROLE_RIGHTS_U1 UNIQUE APPS_TS_SEED ROLE_ID
RIGHT_CODE
Columns
Name Datatype Length Mandatory Comments
ROLE_ID NUMBER (10) Y Role identifier
RIGHT_CODE VARCHAR2 (30) Y Right code. Values are taken from the lookups IGW_RIGHTS.
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column

[top of page]

IGW.IGW_ROLE_RIGHTS does not reference any database object

IGW.IGW_ROLE_RIGHTS is referenced by following:

APPS
SYNONYM - IGW_ROLE_RIGHTS

[top of page]

Table: IGW_SCIENCE_CODES

Description: Keywords used in preparing proposals
Primary Key: IGW_SCIENCE_CODES_PK
  1. SCIENCE_CODE
Foreign Keys to this table:
Foreign Key Column Foreign Table
IGW_PROP_SCIENCE_CODES.SCIENCE_CODE IGW_SCIENCE_CODES
Comments

IGW_SCIENCE_CODES stores keywords and descriptions used in preparing proposals.

Indexes
Index Type Tablespace Column
IGW_SCIENCE_CODES_U1 UNIQUE APPS_TS_TX_IDX SCIENCE_CODE
Columns
Name Datatype Length Mandatory Comments
SCIENCE_CODE VARCHAR2 (15) Y Keywords used in the application
DESCRIPTION VARCHAR2 (250) Y Description for the keywords
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
RECORD_VERSION_NUMBER NUMBER
Y Locking sequence number

[top of page]

IGW.IGW_SCIENCE_CODES does not reference any database object

IGW.IGW_SCIENCE_CODES is referenced by following:

APPS
SYNONYM - IGW_SCIENCE_CODES

[top of page]

Table: IGW_STUDY_TITLES

Description: Information on proposal titles
Primary Key: IGW_STUDY_TITLES_PK
  1. STUDY_TITLE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
IGW_STUDY_TITLES.PROPOSAL_ID IGW_PROPOSALS_ALL
Foreign Keys to this table:
Foreign Key Column Foreign Table
IGW_SUBJECT_INFORMATION.STUDY_TITLE_ID IGW_STUDY_TITLES
Comments

IGW_STUDY_TITLES stores titles of studies conducted on subjects. A proposal can have multiple study titles.

Indexes
Index Type Tablespace Column
IGW_STUDY_TITLES_U1 UNIQUE APPS_TS_TX_IDX STUDY_TITLE_ID
Columns
Name Datatype Length Mandatory Comments
STUDY_TITLE_ID NUMBER (15) Y Study title identifier
STUDY_TITLE VARCHAR2 (240)
Title of study conducted on a particular subject
PROPOSAL_ID NUMBER (15) Y Proposal identifier
RECORD_VERSION_NUMBER NUMBER
Y Locking sequence number
ENROLLMENT_STATUS VARCHAR2 (30) Y Unique code that identifies whether the study involves targeted or included human subjects.Possible values are T - Targeted, I - Included
PROTOCOL_NUMBER VARCHAR2 (8)
Protocol Number

[top of page]

IGW.IGW_STUDY_TITLES does not reference any database object

IGW.IGW_STUDY_TITLES is referenced by following:

APPS
SYNONYM - IGW_STUDY_TITLES

[top of page]

Table: IGW_SUBJECT_INFORMATION

Description: Information on proposal subjects
Primary Key: IGW_SUBJECT_INFORMATION_PK
  1. SUBJECT_RACE_CODE
  2. SUBJECT_ETHNICITY_CODE
  3. STUDY_TITLE_ID
  4. SUBJECT_TYPE_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
IGW_SUBJECT_INFORMATION.STUDY_TITLE_ID IGW_STUDY_TITLES
Comments

IGW_SUBJECT_INFORMATION stores information about subjects on which studies are conducted. Information such as type of subject and number of subjects are stored in this table.

Indexes
Index Type Tablespace Column
IGW_SUBJECT_INFORMATION_U1 UNIQUE APPS_TS_TX_IDX STUDY_TITLE_ID
SUBJECT_RACE_CODE
SUBJECT_ETHNICITY_CODE
SUBJECT_TYPE_CODE
Columns
Name Datatype Length Mandatory Comments
STUDY_TITLE_ID NUMBER (15) Y Study title identifier
SUBJECT_TYPE_CODE VARCHAR2 (30) Y Unique code that identifies the type of subject
SUBJECT_RACE_CODE VARCHAR2 (30) Y Unique code that identifies the race of subject
NO_OF_SUBJECTS NUMBER (15)
Number of subjects
RECORD_VERSION_NUMBER NUMBER
Y Locking sequence number
SUBJECT_ETHNICITY_CODE VARCHAR2 (30) Y Unique code that identifies the ethnicity of subject
CREATED_BY NUMBER (15)
Standard Who column
CREATION_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER (15)
Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
SUBJECT_INFORMATION_ID NUMBER (15)
Identifier for subject information

[top of page]

IGW.IGW_SUBJECT_INFORMATION does not reference any database object

IGW.IGW_SUBJECT_INFORMATION is referenced by following:

APPS
SYNONYM - IGW_SUBJECT_INFORMATION

[top of page]

View: IGWBV_GRANT_KEYWORD

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
SCIENCE_CODE VARCHAR2 (15) Y
CODE_DESCRIPTION VARCHAR2 (250) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWBV_GRANT_KEYWORD references the following:

APPS
SYNONYM - IGW_SCIENCE_CODES

APPS.IGWBV_GRANT_KEYWORD is not referenced by any database object

[top of page]

View: IGWBV_GRANT_PROPOSAL

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_NUMBER VARCHAR2 (30) Y
LEAD_ORGANIZATION_ID NUMBER (15)
ORG_ID NUMBER (15)
_LA:PROPOSAL_STATUS CHAR (61)
PROPOSAL_START_DATE DATE
Y
PROPOSAL_END_DATE DATE
Y
PROPOSAL_TITLE VARCHAR2 (250)
PROPOSAL_TYPE VARCHAR2 (80) Y
AWARD_NUMBER VARCHAR2 (15)
AWARD_AMOUNT NUMBER (15)
ORIGINAL_PROPOSAL_NUMBER VARCHAR2 (30)
ORIGINAL_AWARD_NUMBER VARCHAR2 (15)
ORIGINAL_PROPOSAL_START_DATE DATE

ORIGINAL_PROPOSAL_END_DATE DATE

ACTIVITY_TYPE VARCHAR2 (80) Y
SPONSOR_ID NUMBER (15)
SPONSOR_PROPOSAL_NUMBER VARCHAR2 (30)
NOTICE_OF_OPPORTUNITY VARCHAR2 (80)
PROGRAM_NUMBER VARCHAR2 (30)
PROGRAM_TITLE VARCHAR2 (250)
SPONSOR_ACTION VARCHAR2 (80)
SPONSOR_ACTION_DATE DATE

SUBMITTING_ORGANIZATION_ID NUMBER (15)
DEADLINE_DATE DATE

DEADLINE_TYPE VARCHAR2 (1)
NARRATIVE_SUBMISSION VARCHAR2 (80)
ORIGINAL_SPONSOR_ID NUMBER (15)
LETTER_OF_INTENT_DUE_DATE DATE

PROGRAM_URL VARCHAR2 (240)
FUNDING_SPONSOR_UNIT VARCHAR2 (45)
EDI_GENERATED_DATE DATE

_DF CHAR (34)
NARRATIVE_STATUS VARCHAR2 (4000)
NARRATIVE_TYPE_CODE VARCHAR2 (30)
PROPOSAL_ID NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWBV_GRANT_PROPOSAL references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - IGW_LOOKUPS_V
PACKAGE - IGW_PROP
SYNONYM - IGW_PROPOSALS_ALL

APPS.IGWBV_GRANT_PROPOSAL is not referenced by any database object

[top of page]

View: IGWBV_GRANT_PROPOSAL_APPROVAL

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_NUMBER VARCHAR2 (30) Y
RUN_NUMBER NUMBER (4) Y
APPROVAL_RUN_ID NUMBER (15) Y
PROPOSAL_ID NUMBER (15) Y
STATUS_CODE VARCHAR2 (30) Y
STATUS_DATE DATE

[top of page]

APPS.IGWBV_GRANT_PROPOSAL_APPROVAL references the following:

APPS
SYNONYM - IGW_PROPOSALS_ALL
SYNONYM - IGW_PROP_APPROVAL_RUNS

APPS.IGWBV_GRANT_PROPOSAL_APPROVAL is not referenced by any database object

[top of page]

View: IGWBV_GRANT_PROPOSAL_BDGT_LINE

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_NUMBER VARCHAR2 (30) Y
BUDGET_VERSION_ID NUMBER (4) Y
EXPENDITURE_TYPE VARCHAR2 (30) Y
LINE_ITEM_DESCRIPTION VARCHAR2 (250)
SOURCE_LINE_ITEM NUMBER (15)
LINE_ITEM_COST NUMBER (15)
COST_SHARING_AMOUNT NUMBER (15)
UNDERRECOVERY_AMOUNT NUMBER (15)
APPLY_INFLATION_FLAG VARCHAR2 (1) Y
BUDGET_JUSTIFICATION LONG (0)
LOCATION VARCHAR2 (80) Y
EXPENDITURE_CATEGORY_FLAG VARCHAR2 (1) Y
BUDGET_CATEGORY VARCHAR2 (80)
PROPOSAL_ID NUMBER (15) Y
BUDGET_PERIOD_ID NUMBER (4) Y
LINE_ITEM_ID NUMBER (15) Y
PROJECT_ID NUMBER (15)
TASK_ID NUMBER (15)
AWARD_ID NUMBER (15)
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWBV_GRANT_PROPOSAL_BDGT_LINE references the following:

APPS
PACKAGE - FND_GLOBAL
SYNONYM - IGW_BUDGET_DETAILS
VIEW - IGW_LOOKUPS_V
SYNONYM - IGW_PROPOSALS_ALL

APPS.IGWBV_GRANT_PROPOSAL_BDGT_LINE is not referenced by any database object

[top of page]

View: IGWBV_GRANT_PROPOSAL_EXP_TYPE

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
EXPENDITURE_CATEGORY VARCHAR2 (30) Y
EXPENDITURE_TYPE VARCHAR2 (30) Y
EXP_TYPE_DESCRIPTION VARCHAR2 (250)
START_DATE_ACTIVE DATE
Y
END_DATE_ACTIVE DATE

LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWBV_GRANT_PROPOSAL_EXP_TYPE references the following:

APPS
SYNONYM - IGW_EXPENDITURE_TYPES

APPS.IGWBV_GRANT_PROPOSAL_EXP_TYPE is not referenced by any database object

[top of page]

View: IGWBV_GRANT_PROPOSAL_KEYWORD

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
PROPOSALNUMBER VARCHAR2 (30) Y
PROPOSAL_ID NUMBER (15) Y
SCIENCE_CODE VARCHAR2 (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWBV_GRANT_PROPOSAL_KEYWORD references the following:

APPS
SYNONYM - IGW_PROPOSALS_ALL
SYNONYM - IGW_PROP_SCIENCE_CODES

APPS.IGWBV_GRANT_PROPOSAL_KEYWORD is not referenced by any database object

[top of page]

View: IGWBV_GRANT_PROPOSAL_NARRATIVE

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_NUMBER VARCHAR2 (30) Y
MODULE_TITLE VARCHAR2 (250) Y
MODULE_STATUS VARCHAR2 (1) Y
CONTACT_NAME VARCHAR2 (30)
PHONE_NUMBER VARCHAR2 (30)
EMAIL_ADDRESS VARCHAR2 (60)
COMMENTS VARCHAR2 (250)
PROPOSAL_ID NUMBER (15) Y
MODULE_ID NUMBER (10) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWBV_GRANT_PROPOSAL_NARRATIVE references the following:

APPS
SYNONYM - IGW_PROPOSALS_ALL
SYNONYM - IGW_PROP_NARRATIVES

APPS.IGWBV_GRANT_PROPOSAL_NARRATIVE is not referenced by any database object

[top of page]

View: IGWBV_GRANT_PROPOSAL_OVRD_RATE

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_NUMBER VARCHAR2 (30) Y
BUDGET_VERSION_ID NUMBER (4) Y
FISCAL_YEAR VARCHAR2 (4) Y
LOCATION VARCHAR2 (80) Y
ACTIVITY_TYPE VARCHAR2 (80) Y
START_DATE DATE
Y
APPLICABLE_RATE NUMBER (5) Y
INSTITUTE_RATE NUMBER (5)
PROPOSAL_ID NUMBER (15) Y
RATE_CLASS_ID NUMBER (10) Y
RATE_TYPE_ID NUMBER (10) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWBV_GRANT_PROPOSAL_OVRD_RATE references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - IGW_LOOKUPS_V
SYNONYM - IGW_PROPOSALS_ALL
SYNONYM - IGW_PROP_RATES

APPS.IGWBV_GRANT_PROPOSAL_OVRD_RATE is not referenced by any database object

[top of page]

View: IGWBV_GRANT_PROPOSAL_PERS_ASGN

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_NUMBER VARCHAR2 (30) Y
PERSON_SEQUENCE NUMBER (3)
PROPOSAL_ROLE VARCHAR2 (80) Y
KEY_PERSON_FLAG VARCHAR2 (1)
EFFORT_PERCENT NUMBER (5)
PI_FLAG VARCHAR2 (1)
PROPOSAL_ID NUMBER (15) Y
PERSON_ID NUMBER (15)
PERSON_ORGANIZATION_ID NUMBER (15)
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWBV_GRANT_PROPOSAL_PERS_ASGN references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - IGW_LOOKUPS_V
SYNONYM - IGW_PROPOSALS_ALL
SYNONYM - IGW_PROP_PERSONS

APPS.IGWBV_GRANT_PROPOSAL_PERS_ASGN is not referenced by any database object

[top of page]

View: IGWBV_GRANT_PROPOSAL_RATE

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
ACTIVITY_TYPE VARCHAR2 (80) Y
FISCAL_YEAR NUMBER (4) Y
LOCATION VARCHAR2 (80) Y
START_DATE DATE
Y
RATE NUMBER (5) Y
RATE_CLASS_ID NUMBER (10) Y
RATE_TYPE_ID NUMBER (10) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWBV_GRANT_PROPOSAL_RATE references the following:

APPS
PACKAGE - FND_GLOBAL
SYNONYM - IGW_INSTITUTE_RATES
VIEW - IGW_LOOKUPS_V

APPS.IGWBV_GRANT_PROPOSAL_RATE is not referenced by any database object

[top of page]

View: IGWBV_GRANT_PROPOSAL_RATE_TYPE

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
RATE_TYPE_DESCRIPTION VARCHAR2 (250) Y
RATE_CLASS_ID NUMBER (10) Y
RATE_TYPE_ID NUMBER (10) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWBV_GRANT_PROPOSAL_RATE_TYPE references the following:

APPS
SYNONYM - IGW_RATE_TYPES

APPS.IGWBV_GRANT_PROPOSAL_RATE_TYPE is not referenced by any database object

[top of page]

View: IGWBV_GRANT_PRPSL_BDGT_LIN_AMT

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_NUMBER VARCHAR2 (30) Y
BUDGET_VERSION_ID NUMBER (4) Y
APPLY_RATE_FLAG VARCHAR2 (1)
CALCULATED_COST NUMBER (15)
CALCULATED_COST_SHARING NUMBER (15)
PROPOSAL_ID NUMBER (15) Y
BUDGET_PERIOD_ID NUMBER (4) Y
LINE_ITEM_ID NUMBER (15) Y
RATE_CLASS_ID NUMBER (10) Y
RATE_TYPE_ID NUMBER (10) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWBV_GRANT_PRPSL_BDGT_LIN_AMT references the following:

APPS
SYNONYM - IGW_BUDGET_DETAILS_CAL_AMTS
SYNONYM - IGW_PROPOSALS_ALL

APPS.IGWBV_GRANT_PRPSL_BDGT_LIN_AMT is not referenced by any database object

[top of page]

View: IGWBV_GRANT_PRPSL_BDGT_PERSON

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_NUMBER VARCHAR2 (30) Y
BUDGET_VERSION_ID NUMBER (4) Y
_LA:APPOINTMENT_TYPE CHAR (77)
EFFECTIVE_DATE DATE
Y
CALCULATION_BASE NUMBER (15) Y
PROPOSAL_ID NUMBER (15) Y
PERSON_ID NUMBER (15)
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWBV_GRANT_PRPSL_BDGT_PERSON references the following:

APPS
SYNONYM - IGW_BUDGET_PERSONS
SYNONYM - IGW_PROPOSALS_ALL

APPS.IGWBV_GRANT_PRPSL_BDGT_PERSON is not referenced by any database object

[top of page]

View: IGWBV_GRANT_PRPSL_BDGT_VERSION

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_NUMBER VARCHAR2 (30) Y
BUDGET_VERSION_ID NUMBER (4) Y
START_DATE DATE
Y
END_DATE DATE
Y
TOTAL_COST NUMBER (15)
TOTAL_DIRECT_COST NUMBER (15)
TOTAL_INDIRECT_COST NUMBER (15)
COST_SHARING_AMOUNT NUMBER (15)
UNDERRECOVERY_AMOUNT NUMBER (15)
RESIDUAL_FUNDS_AMOUNT NUMBER (15)
TOTAL_COST_LIMIT NUMBER (15)
COMMENTS VARCHAR2 (2000)
FINAL_VERSION_FLAG VARCHAR2 (1)
_LA:BUDGET_TYPE CHAR (67)
PROPOSAL_FORM_NUMBER VARCHAR2 (30) Y
_DF CHAR (37)
PROPOSAL_ID NUMBER (15) Y
OH_RATE_CLASS_ID NUMBER (10) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWBV_GRANT_PRPSL_BDGT_VERSION references the following:

APPS
SYNONYM - IGW_BUDGETS
SYNONYM - IGW_PROPOSALS_ALL

APPS.IGWBV_GRANT_PRPSL_BDGT_VERSION is not referenced by any database object

[top of page]

View: IGWBV_GRANT_PRPSL_EXP_CATEGORY

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
EXPENDITURE_CATEGORY VARCHAR2 (30) Y
EXP_CATEGORY_DESCRIPTION VARCHAR2 (250)
BUDGET_CATEGORY VARCHAR2 (80) Y
PERSONNEL_ATTACHED_FLAG VARCHAR2 (1) Y
START_DATE_ACTIVE DATE

END_DATE_ACTIVE DATE

LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWBV_GRANT_PRPSL_EXP_CATEGORY references the following:

APPS
PACKAGE - FND_GLOBAL
SYNONYM - IGW_EXPENDITURE_CATEGORIES
VIEW - IGW_LOOKUPS_V

APPS.IGWBV_GRANT_PRPSL_EXP_CATEGORY is not referenced by any database object

[top of page]

View: IGWBV_GRANT_PRPSL_RATE_CLASS

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
RATE_CLASS_DESCRIPTION VARCHAR2 (250) Y
RATE_CLASS_TYPE VARCHAR2 (1) Y
OVERHEAD_TYPE VARCHAR2 (6)
RATE_CLASS_ID NUMBER (10) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWBV_GRANT_PRPSL_RATE_CLASS references the following:

APPS
SYNONYM - IGW_RATE_CLASSES

APPS.IGWBV_GRANT_PRPSL_RATE_CLASS is not referenced by any database object

[top of page]

View: IGWBV_GRANT_PRPSL_ROUTING_LIST

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
MAP_DESCRIPTION VARCHAR2 (30) Y
START_DATE_ACTIVE DATE
Y
END_DATE_ACTIVE DATE

MAP_ID NUMBER (10) Y
ORGANIZATION_ID NUMBER (15) Y
ORG_ID NUMBER (15)
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWBV_GRANT_PRPSL_ROUTING_LIST references the following:

APPS
SYNONYM - IGW_ORG_MAPS_ALL

APPS.IGWBV_GRANT_PRPSL_ROUTING_LIST is not referenced by any database object

[top of page]

View: IGWBV_GRANT_PRPSL_ROUTING_RULE

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
RULE_NAME VARCHAR2 (50) Y
RULE_SEQUENCE_NUMBER NUMBER (4)
RULE_TYPE VARCHAR2 (1) Y
VALID_FLAG VARCHAR2 (1)
START_DATE_ACTIVE DATE
Y
END_DATE_ACTIVE DATE

RULE_ID NUMBER (10) Y
ORGANIZATION_ID NUMBER (15) Y
ORG_ID NUMBER (15)
MAP_ID NUMBER (10)
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWBV_GRANT_PRPSL_ROUTING_RULE references the following:

APPS
SYNONYM - IGW_BUSINESS_RULES_ALL

APPS.IGWBV_GRANT_PRPSL_ROUTING_RULE is not referenced by any database object

[top of page]

View: IGWBV_GRANT_PRPSL_SUPPRT_TEXT

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_NUMBER VARCHAR2 (30) Y
PROPOSAL_ID NUMBER (15) Y
ABSTRACT_CODE VARCHAR2 (30) Y
ABSTRACT_TYPE VARCHAR2 (80) Y
ABSTRACT VARCHAR2 (4000)
ABSTRACT_CATEGORY VARCHAR2 (30) Y
_DF CHAR (39)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWBV_GRANT_PRPSL_SUPPRT_TEXT references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - IGW_LOOKUPS_V
SYNONYM - IGW_PROPOSALS_ALL
SYNONYM - IGW_PROP_ABSTRACTS

APPS.IGWBV_GRANT_PRPSL_SUPPRT_TEXT is not referenced by any database object

[top of page]

View: IGWBV_GRNT_PERS_CERT_ANSWER

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_NUMBER VARCHAR2 (30) Y
QUESTION_NUMBER VARCHAR2 (5) Y
QUESTION VARCHAR2 (500) Y
ANSWER VARCHAR2 (1)
REVIEW_DATE DATE

PERSON_ID NUMBER (15)
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
EXPLANATION VARCHAR2 (800)

[top of page]

APPS.IGWBV_GRNT_PERS_CERT_ANSWER references the following:

APPS
SYNONYM - IGW_PROPOSALS_ALL
SYNONYM - IGW_PROP_PERSON_QUESTIONS
SYNONYM - IGW_QUESTIONS
SYNONYM - IGW_QUESTIONS_TL

APPS.IGWBV_GRNT_PERS_CERT_ANSWER is not referenced by any database object

[top of page]

View: IGWBV_GRNT_PRPSL_APRVL_LST_MBR

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
USER_NAME VARCHAR2 (100) Y
WF_ROLE_NAME VARCHAR2 (100)
WF_DISPLAY_ROLE_NAME VARCHAR2 (200) Y
APPROVER_TYPE VARCHAR2 (1)
APPROVAL_STATUS VARCHAR2 (1)
SUBMISSION_DATE DATE

APPROVAL_DATE DATE

COMMENTS VARCHAR2 (2000)
PROP_MAP_ID NUMBER (15) Y
APPROVAL_STOP_ID NUMBER (4) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWBV_GRNT_PRPSL_APRVL_LST_MBR references the following:

APPS
SYNONYM - IGW_PROP_MAP_STOPS

APPS.IGWBV_GRNT_PRPSL_APRVL_LST_MBR is not referenced by any database object

[top of page]

View: IGWBV_GRNT_PRPSL_APRV_APVL_LST

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_NUMBER VARCHAR2 (30) Y
MAP_DESCRIPTION VARCHAR2 (200) Y
MAP_TYPE VARCHAR2 (1) Y
MAP_SEQUENCE_NUMBER NUMBER (4) Y
APPROVAL_STATUS VARCHAR2 (1)
RUN_ID NUMBER (15) Y
PROPOSAL_ID NUMBER (15) Y
PROP_MAP_ID NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWBV_GRNT_PRPSL_APRV_APVL_LST references the following:

APPS
SYNONYM - IGW_PROPOSALS_ALL
SYNONYM - IGW_PROP_MAPS

APPS.IGWBV_GRNT_PRPSL_APRV_APVL_LST is not referenced by any database object

[top of page]

View: IGWBV_GRNT_PRPSL_BDGT_LIN_PERS

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_NUMBER VARCHAR2 (30) Y
BUDGET_VERSION_ID NUMBER (4) Y
START_DATE DATE
Y
END_DATE DATE
Y
BUDGET_PERSON_PERIOD_TYPE VARCHAR2 (30) Y
_LA:APPOINTMENT_TYPE CHAR (68)
SALARY_REQUESTED NUMBER (15)
CHARGED_AOMOUNT_PERCENT NUMBER (5)
EFFORT_PERCENT NUMBER (5)
COST_SHARING_PERCENT NUMBER (5)
COST_SHARING_AMOUNT NUMBER (15)
UNDERRECOVERY_AMOUNT NUMBER (15)
BUDGET_PERSONNEL_DETAIL_ID NUMBER (15) Y
PROPOSAL_ID NUMBER (15) Y
BUDGET_PERIOD_ID NUMBER (4) Y
LINE_ITEM_ID NUMBER (15) Y
PERSON_ID NUMBER (15)
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWBV_GRNT_PRPSL_BDGT_LIN_PERS references the following:

APPS
PACKAGE - FND_GLOBAL
SYNONYM - IGW_BUDGET_PERSONNEL_DETAILS
VIEW - IGW_LOOKUPS_V
SYNONYM - IGW_PROPOSALS_ALL

APPS.IGWBV_GRNT_PRPSL_BDGT_LIN_PERS is not referenced by any database object

[top of page]

View: IGWBV_GRNT_PRPSL_BDGT_PERS_AMT

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
APPLY_RATE_FLAG VARCHAR2 (1)
CALCULATED_COST NUMBER (15)
CALCULATED_COST_SHARING NUMBER (15)
BUDGET_PERSONNEL_DETAIL_ID NUMBER (15) Y
RATE_CLASS_ID NUMBER (10) Y
RATE_TYPE_ID NUMBER (10) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWBV_GRNT_PRPSL_BDGT_PERS_AMT references the following:

APPS
SYNONYM - IGW_BUDGET_PERSONNEL_CAL_AMTS

APPS.IGWBV_GRNT_PRPSL_BDGT_PERS_AMT is not referenced by any database object

[top of page]

View: IGWBV_GRNT_PRPSL_BUDGT_PERIOD

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_NUMBER VARCHAR2 (30) Y
START_DATE DATE
Y
END_DATE DATE
Y
TOTAL_COST NUMBER (15)
TOTAL_DIRECT_COST NUMBER (15)
TOTAL_INDIRECT_COST NUMBER (15)
COST_SHARING_AMOUNT NUMBER (15)
UNDERRECOVERY_AMOUNT NUMBER (15)
TOTAL_COST_LIMIT NUMBER (15)
PROGRAM_INCOME NUMBER (15)
PROGRAM_INCOME_SOURCE VARCHAR2 (50)
PROPOSAL_ID NUMBER (15) Y
VERSION_ID NUMBER (4) Y
BUDGET_PERIOD_ID NUMBER (4) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWBV_GRNT_PRPSL_BUDGT_PERIOD references the following:

APPS
SYNONYM - IGW_BUDGET_PERIODS
SYNONYM - IGW_PROPOSALS_ALL

APPS.IGWBV_GRNT_PRPSL_BUDGT_PERIOD is not referenced by any database object

[top of page]

View: IGWBV_GRNT_PRPSL_CERT_ANSWER

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_NUMBER VARCHAR2 (30) Y
QUESTION_NUMBER VARCHAR2 (5) Y
QUESTION VARCHAR2 (500) Y
ANSWER VARCHAR2 (1)
EXPLANATION VARCHAR2 (800)
REVIEW_DATE DATE

PROPOSAL_ID NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWBV_GRNT_PRPSL_CERT_ANSWER references the following:

APPS
SYNONYM - IGW_PROPOSALS_ALL
SYNONYM - IGW_PROP_QUESTIONS
SYNONYM - IGW_QUESTIONS_TL

APPS.IGWBV_GRNT_PRPSL_CERT_ANSWER is not referenced by any database object

[top of page]

View: IGWBV_GRNT_PRPSL_CERT_QUESTION

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
QUESTION_NUMBER VARCHAR2 (5) Y
QUESTION VARCHAR2 (500) Y
EXPLANATION VARCHAR2 (1000)
POLICY VARCHAR2 (1000)
REGULATION VARCHAR2 (1000)
APPLIES_TO VARCHAR2 (1) Y
EXPLANATION_FOR_YES_FLAG VARCHAR2 (1) Y
EXPLANATION_FOR_NO_FLAG VARCHAR2 (1) Y
DATE_FOR_YES_FLAG VARCHAR2 (1) Y
DATE_FOR_NO_FLAG VARCHAR2 (1) Y
START_DATE_ACTIVE DATE
Y
END_DATE_ACTIVE DATE

LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWBV_GRNT_PRPSL_CERT_QUESTION references the following:

APPS
SYNONYM - IGW_QUESTIONS
SYNONYM - IGW_QUESTIONS_TL

APPS.IGWBV_GRNT_PRPSL_CERT_QUESTION is not referenced by any database object

[top of page]

View: IGWBV_GRNT_PRPSL_COMMENT

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_NUMBER VARCHAR2 (30) Y
COMMENTS VARCHAR2 (4000)
PROPOSAL_ID NUMBER (15) Y
COMMENT_ID NUMBER (10) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWBV_GRNT_PRPSL_COMMENT references the following:

APPS
SYNONYM - IGW_PROPOSALS_ALL
SYNONYM - IGW_PROP_COMMENTS

APPS.IGWBV_GRNT_PRPSL_COMMENT is not referenced by any database object

[top of page]

View: IGWBV_GRNT_PRPSL_EXP_RATE_ASGN

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
RATE_CLASS_ID NUMBER (10) Y
RATE_TYPE_ID NUMBER (10) Y
EXPENDITURE_CATEGORY VARCHAR2 (30) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWBV_GRNT_PRPSL_EXP_RATE_ASGN references the following:

APPS
SYNONYM - IGW_EXP_TYPE_RATE_TYPES

APPS.IGWBV_GRNT_PRPSL_EXP_RATE_ASGN is not referenced by any database object

[top of page]

View: IGWBV_GRNT_PRPSL_ORG_CERT_ANSW

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
QUESTION_NUMBER VARCHAR2 (5) Y
QUESTION VARCHAR2 (500) Y
ANSWER VARCHAR2 (1)
EXPLANATION VARCHAR2 (800)
REVIEW_DATE DATE

ORGANIZATION_ID NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWBV_GRNT_PRPSL_ORG_CERT_ANSW references the following:

APPS
SYNONYM - IGW_ORG_QUESTIONS
SYNONYM - IGW_QUESTIONS_TL

APPS.IGWBV_GRNT_PRPSL_ORG_CERT_ANSW is not referenced by any database object

[top of page]

View: IGWBV_GRNT_PRPSL_PERS_BIOSKTCH

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
BIOSKETCH_TYPE VARCHAR2 (80) Y
BIOSKETCH_LINE_SEQUENCE NUMBER (4) Y
BIOSKETCH_LINE VARCHAR2 (500) Y
ENABLE_FLAG VARCHAR2 (1) Y
PERSON_BIOSKETCH_ID NUMBER (10) Y
PERSON_ID NUMBER (15)
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWBV_GRNT_PRPSL_PERS_BIOSKTCH references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - IGW_LOOKUPS_V
SYNONYM - IGW_PERSON_BIOSKETCH

APPS.IGWBV_GRNT_PRPSL_PERS_BIOSKTCH is not referenced by any database object

[top of page]

View: IGWBV_GRNT_PRPSL_PERS_DEGREE

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
DEGREE_TYPE VARCHAR2 (30) Y
GRADUATION_DATE DATE
Y
DEGREE VARCHAR2 (80) Y
DEGREE_OBTAINED_SEQUENCE NUMBER (3) Y
FIELD_OF_STUDY VARCHAR2 (80)
SPECIALIZATION VARCHAR2 (80)
SCHOOL_NAME VARCHAR2 (100)
PERSON_DEGREE_ID NUMBER (10) Y
PERSON_ID NUMBER (15)
_DF CHAR (39)
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWBV_GRNT_PRPSL_PERS_DEGREE references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - IGW_LOOKUPS_V
SYNONYM - IGW_PERSON_DEGREES

APPS.IGWBV_GRNT_PRPSL_PERS_DEGREE is not referenced by any database object

[top of page]

View: IGWBV_GRNT_PRPSL_PERS_DEG_ASGN

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_NUMBER VARCHAR2 (30) Y
SHOW_FLAG VARCHAR2 (1) Y
DEGREE_OBTAINED_SEQUENCE NUMBER (2) Y
PROPOSAL_ID NUMBER (15) Y
PERSON_DEGREE_ID NUMBER (10) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWBV_GRNT_PRPSL_PERS_DEG_ASGN references the following:

APPS
SYNONYM - IGW_PROPOSALS_ALL
SYNONYM - IGW_PROP_PERSON_DEGREES

APPS.IGWBV_GRNT_PRPSL_PERS_DEG_ASGN is not referenced by any database object

[top of page]

View: IGWBV_GRNT_PRPSL_PERS_OTHR_SUP

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_NUMBER VARCHAR2 (30) Y
_LA:SUPPORT_TYPE CHAR (60)
PROPOSAL_AWARD_NUMBER VARCHAR2 (30)
PROPOSAL_AWARD_TITLE VARCHAR2 (250)
START_DATE DATE

END_DATE DATE

PERCENT_EFFORT NUMBER (5)
ANNUAL_DIRECT_COST NUMBER (15)
TOTAL_COST NUMBER (15)
PROJECT_LOCATION VARCHAR2 (100)
CALENDAR_START_DATE DATE

CALENDAR_END_DATE DATE

ACADEMIC_START_DATE DATE

ACADEMIC_END_DATE DATE

SUMMER_START_DATE DATE

SUMMER_END_DATE DATE

MAJOR_GOALS VARCHAR2 (250)
OVERLAP VARCHAR2 (250)
_DF CHAR (40)
PROP_PERSON_SUPPORT_ID NUMBER (15) Y
PROPOSAL_ID NUMBER (15) Y
PERSON_ID NUMBER (15)
PI_PERSON_ID NUMBER (15)
SPONSOR_ID NUMBER (15)
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWBV_GRNT_PRPSL_PERS_OTHR_SUP references the following:

APPS
SYNONYM - IGW_PROPOSALS_ALL
SYNONYM - IGW_PROP_PERSON_SUPPORT

APPS.IGWBV_GRNT_PRPSL_PERS_OTHR_SUP is not referenced by any database object

[top of page]

View: IGWBV_GRNT_PRPSL_PERS_PRF_ASGN

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_NUMBER VARCHAR2 (30) Y
SHOW_FLAG VARCHAR2 (1) Y
LINE_SEQUENCE NUMBER (4) Y
PROPOSAL_ID NUMBER (15) Y
PERSON_BIOSKETCH_ID NUMBER (10) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWBV_GRNT_PRPSL_PERS_PRF_ASGN references the following:

APPS
SYNONYM - IGW_PROPOSALS_ALL
SYNONYM - IGW_PROP_PERSON_BIOSKETCH

APPS.IGWBV_GRNT_PRPSL_PERS_PRF_ASGN is not referenced by any database object

[top of page]

View: IGWBV_GRNT_PRPSL_ROUTG_LST_MBR

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
USER_NAME VARCHAR2 (100) Y
APPROVER_TYPE VARCHAR2 (1)
MAP_ID NUMBER (10) Y
STOP_ID NUMBER (4) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWBV_GRNT_PRPSL_ROUTG_LST_MBR references the following:

APPS
SYNONYM - IGW_ORG_MAP_DETAILS

APPS.IGWBV_GRNT_PRPSL_ROUTG_LST_MBR is not referenced by any database object

[top of page]

View: IGWBV_GRNT_PRPSL_ROUT_RULE_LNE

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
EXPRESSION_SEQUENCE_NUMBER NUMBER (4) Y
EXPRESSION_TYPE VARCHAR2 (1) Y
LEFT_BRACKETS VARCHAR2 (10)
LEFT_VALUE VARCHAR2 (50) Y
ARITHMATIC_OPERATOR VARCHAR2 (2) Y
RIGHT_VALUE VARCHAR2 (200) Y
RIGHT_VALUE_ID VARCHAR2 (30)
RIGHT_BRACKETS VARCHAR2 (10)
LOGICAL_OPERATOR VARCHAR2 (3)
RULE_ID NUMBER (15) Y
EXPRESSION_ID NUMBER (10) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWBV_GRNT_PRPSL_ROUT_RULE_LNE references the following:

APPS
SYNONYM - IGW_BUSINESS_RULE_LINES

APPS.IGWBV_GRNT_PRPSL_ROUT_RULE_LNE is not referenced by any database object

[top of page]

View: IGWBV_GRNT_PRPSL_SPCL_RVW

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_NUMBER VARCHAR2 (30) Y
SPECIAL_REVIEW_SUBJECT VARCHAR2 (80) Y
SPECIAL_REVIEW_COVERAGE VARCHAR2 (80)
_LA:REVIEW_APPROVAL_STATUS CHAR (73)
PROTOCOL_NUMBER VARCHAR2 (50)
APPLICATION_DATE DATE

APPROVAL_DATE DATE

COMMENTS VARCHAR2 (4000)
PROPOSAL_ID NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWBV_GRNT_PRPSL_SPCL_RVW references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - IGW_LOOKUPS_V
SYNONYM - IGW_PROPOSALS_ALL
SYNONYM - IGW_PROP_SPECIAL_REVIEWS

APPS.IGWBV_GRNT_PRPSL_SPCL_RVW is not referenced by any database object

[top of page]

View: IGWFV_GRANT_KEYWORD

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
SCIENCE_CODE VARCHAR2 (15) Y
CODE_DESCRIPTION VARCHAR2 (250) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWFV_GRANT_KEYWORD references the following:

APPS
SYNONYM - IGW_SCIENCE_CODES

APPS.IGWFV_GRANT_KEYWORD is not referenced by any database object

[top of page]

View: IGWFV_GRANT_PROPOSAL

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_NUMBER VARCHAR2 (30) Y
LEAD_ORGANIZATION_NAME VARCHAR2 (240) Y
_LA:PROPOSAL_STATUS CHAR (61)
PROPOSAL_START_DATE DATE
Y
PROPOSAL_END_DATE DATE
Y
PROPOSAL_TITLE VARCHAR2 (250)
PROPOSAL_TYPE VARCHAR2 (80) Y
AWARD_NUMBER VARCHAR2 (15)
AWARD_AMOUNT NUMBER (15)
ORIGINAL_PROPOSAL_NUMBER VARCHAR2 (30)
ORIGINAL_AWARD_NUMBER VARCHAR2 (15)
ORIGINAL_PROPOSAL_START_DATE DATE

ORIGINAL_PROPOSAL_END_DATE DATE

ACTIVITY_TYPE VARCHAR2 (80) Y
SPONSOR_NAME VARCHAR2 (50)
SPONSOR_PROPOSAL_NUMBER VARCHAR2 (30)
NOTICE_OF_OPPORTUNITY VARCHAR2 (80)
PROGRAM_NUMBER VARCHAR2 (30)
PROGRAM_TITLE VARCHAR2 (250)
SPONSOR_ACTION VARCHAR2 (80)
SPONSOR_ACTION_DATE DATE

SUBMITTING_ORGANIZATION_NAME VARCHAR2 (240) Y
DEADLINE_DATE DATE

DEADLINE_TYPE VARCHAR2 (1)
NARRATIVE_SUBMISSION VARCHAR2 (80)
ORIGINAL_SPONSOR_NAME VARCHAR2 (50)
LETTER_OF_INTENT_DUE_DATE DATE

PROGRAM_URL VARCHAR2 (240)
FUNDING_SPONSOR_UNIT VARCHAR2 (45)
EDI_GENERATED_DATE DATE

_DF CHAR (34)
NARRATIVE_STATUS VARCHAR2 (4000)
NARRATIVE_TYPE_CODE VARCHAR2 (30)
PROPOSAL_ID NUMBER (15) Y
LEAD_ORGANIZATION_ID NUMBER (15)
SUBMITTING_ORGANIZATION_ID NUMBER (15)
ORG_ID NUMBER (15)
SPONSOR_ID NUMBER (15)
ORIGINAL_SPONSOR_ID NUMBER (15)
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWFV_GRANT_PROPOSAL references the following:

APPS
PACKAGE - FND_GLOBAL
SYNONYM - HR_ALL_ORGANIZATION_UNITS
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_PARTIES
VIEW - IGW_LOOKUPS_V
PACKAGE - IGW_PROP
SYNONYM - IGW_PROPOSALS_ALL

APPS.IGWFV_GRANT_PROPOSAL is not referenced by any database object

[top of page]

View: IGWFV_GRANT_PROPOSAL_APPROVAL

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_NUMBER VARCHAR2 (30) Y
RUN_NUMBER NUMBER (4) Y
APPROVAL_RUN_ID NUMBER (15) Y
PROPOSAL_ID NUMBER (15) Y
STATUS_CODE VARCHAR2 (30) Y
STATUS_DATE DATE

[top of page]

APPS.IGWFV_GRANT_PROPOSAL_APPROVAL references the following:

APPS
SYNONYM - IGW_PROPOSALS_ALL
SYNONYM - IGW_PROP_APPROVAL_RUNS

APPS.IGWFV_GRANT_PROPOSAL_APPROVAL is not referenced by any database object

[top of page]

View: IGWFV_GRANT_PROPOSAL_BDGT_LINE

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_NUMBER VARCHAR2 (30) Y
BUDGET_VERSION_ID NUMBER (4) Y
AWARD_NUMBER VARCHAR2 (15)
PROJECT_NAME VARCHAR2 (30)
TASK_NUMBER VARCHAR2 (25)
BUDGET_PERIOD_START_DATE DATE
Y
BUDGET_PERIOD_END_DATE DATE
Y
EXPENDITURE_CATEGORY VARCHAR2 (30)
EXPENDITURE_TYPE VARCHAR2 (30)
LINE_ITEM_DESCRIPTION VARCHAR2 (250)
SOURCE_LINE_ITEM NUMBER (15)
LINE_ITEM_COST NUMBER (15)
COST_SHARING_AMOUNT NUMBER (15)
UNDERRECOVERY_AMOUNT NUMBER (15)
APPLY_INFLATION_FLAG VARCHAR2 (1) Y
BUDGET_JUSTIFICATION LONG (0)
LOCATION VARCHAR2 (80) Y
BUDGET_CATEGORY VARCHAR2 (80)
PROPOSAL_ID NUMBER (15) Y
BUDGET_PERIOD_ID NUMBER (4) Y
LINE_ITEM_ID NUMBER (15) Y
PROJECT_ID NUMBER (15)
TASK_ID NUMBER (15)
AWARD_ID NUMBER (15)
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWFV_GRANT_PROPOSAL_BDGT_LINE references the following:

APPS
PACKAGE - FND_GLOBAL
SYNONYM - GMS_AWARDS_ALL
SYNONYM - IGW_BUDGET_DETAILS
SYNONYM - IGW_BUDGET_PERIODS
VIEW - IGW_LOOKUPS_V
SYNONYM - IGW_PROPOSALS_ALL
SYNONYM - PA_PROJECTS_ALL
SYNONYM - PA_TASKS

APPS.IGWFV_GRANT_PROPOSAL_BDGT_LINE is not referenced by any database object

[top of page]

View: IGWFV_GRANT_PROPOSAL_EXP_TYPE

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
EXPENDITURE_CATEGORY VARCHAR2 (30) Y
EXP_CATEGORY_DESCRIPTION VARCHAR2 (250)
EXPENDITURE_TYPE VARCHAR2 (30) Y
EXP_TYPE_DESCRIPTION VARCHAR2 (250)
START_DATE_ACTIVE DATE
Y
END_DATE_ACTIVE DATE

LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWFV_GRANT_PROPOSAL_EXP_TYPE references the following:

APPS
SYNONYM - IGW_EXPENDITURE_CATEGORIES
SYNONYM - IGW_EXPENDITURE_TYPES

APPS.IGWFV_GRANT_PROPOSAL_EXP_TYPE is not referenced by any database object

[top of page]

View: IGWFV_GRANT_PROPOSAL_KEYWORD

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
PROPOSALNUMBER VARCHAR2 (30) Y
PROPOSAL_ID NUMBER (15) Y
SCIENCE_CODE VARCHAR2 (15) Y
DESCRIPTION VARCHAR2 (250) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWFV_GRANT_PROPOSAL_KEYWORD references the following:

APPS
SYNONYM - IGW_PROPOSALS_ALL
SYNONYM - IGW_PROP_SCIENCE_CODES
SYNONYM - IGW_SCIENCE_CODES

APPS.IGWFV_GRANT_PROPOSAL_KEYWORD is not referenced by any database object

[top of page]

View: IGWFV_GRANT_PROPOSAL_NARRATIVE

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_NUMBER VARCHAR2 (30) Y
MODULE_TITLE VARCHAR2 (250) Y
MODULE_STATUS VARCHAR2 (1) Y
CONTACT_NAME VARCHAR2 (30)
PHONE_NUMBER VARCHAR2 (30)
EMAIL_ADDRESS VARCHAR2 (60)
COMMENTS VARCHAR2 (250)
PROPOSAL_ID NUMBER (15) Y
MODULE_ID NUMBER (10) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWFV_GRANT_PROPOSAL_NARRATIVE references the following:

APPS
SYNONYM - IGW_PROPOSALS_ALL
SYNONYM - IGW_PROP_NARRATIVES

APPS.IGWFV_GRANT_PROPOSAL_NARRATIVE is not referenced by any database object

[top of page]

View: IGWFV_GRANT_PROPOSAL_OVRD_RATE

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_NUMBER VARCHAR2 (30) Y
BUDGET_VERSION_ID NUMBER (4) Y
RATE_CLASS_DESCRIPTION VARCHAR2 (250) Y
RATE_TYPE_DESCRIPTION VARCHAR2 (250) Y
FISCAL_YEAR VARCHAR2 (4) Y
LOCATION VARCHAR2 (80) Y
ACTIVITY_TYPE VARCHAR2 (80) Y
START_DATE DATE
Y
APPLICABLE_RATE NUMBER (5) Y
INSTITUTE_RATE NUMBER (5)
PROPOSAL_ID NUMBER (15) Y
RATE_CLASS_ID NUMBER (10) Y
RATE_TYPE_ID NUMBER (10) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWFV_GRANT_PROPOSAL_OVRD_RATE references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - IGW_LOOKUPS_V
SYNONYM - IGW_PROPOSALS_ALL
SYNONYM - IGW_PROP_RATES
SYNONYM - IGW_RATE_CLASSES
SYNONYM - IGW_RATE_TYPES

APPS.IGWFV_GRANT_PROPOSAL_OVRD_RATE is not referenced by any database object

[top of page]

View: IGWFV_GRANT_PROPOSAL_PERS_ASGN

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_NUMBER VARCHAR2 (30) Y
PERSON_SEQUENCE NUMBER (3)
PROPOSAL_ROLE VARCHAR2 (80) Y
KEY_PERSON_FLAG VARCHAR2 (1)
PERCENT_EFFORT NUMBER (5)
PI_FLAG VARCHAR2 (1)
PERSON_FULL_NAME VARCHAR2 (240)
PERSON_ORG_NAME VARCHAR2 (240) Y
PROPOSAL_ID NUMBER (15) Y
PERSON_ID NUMBER (15)
PERSON_ORGANIZATION_ID NUMBER (15)
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWFV_GRANT_PROPOSAL_PERS_ASGN references the following:

APPS
PACKAGE - FND_GLOBAL
SYNONYM - HR_ALL_ORGANIZATION_UNITS
VIEW - IGW_LOOKUPS_V
SYNONYM - IGW_PROPOSALS_ALL
SYNONYM - IGW_PROP_PERSONS
SYNONYM - PER_ALL_PEOPLE_F

APPS.IGWFV_GRANT_PROPOSAL_PERS_ASGN is not referenced by any database object

[top of page]

View: IGWFV_GRANT_PROPOSAL_RATE

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
RATE_CLASS_DESCRIPTION VARCHAR2 (250) Y
RATE_TYPE_DESCRIPTION VARCHAR2 (250) Y
ACTIVITY_TYPE VARCHAR2 (80) Y
FISCAL_YEAR NUMBER (4) Y
LOCATION VARCHAR2 (80) Y
START_DATE DATE
Y
RATE NUMBER (5) Y
RATE_CLASS_ID NUMBER (10) Y
RATE_TYPE_ID NUMBER (10) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWFV_GRANT_PROPOSAL_RATE references the following:

APPS
PACKAGE - FND_GLOBAL
SYNONYM - IGW_INSTITUTE_RATES
VIEW - IGW_LOOKUPS_V
SYNONYM - IGW_RATE_CLASSES
SYNONYM - IGW_RATE_TYPES

APPS.IGWFV_GRANT_PROPOSAL_RATE is not referenced by any database object

[top of page]

View: IGWFV_GRANT_PROPOSAL_RATE_TYPE

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
RATE_CLASS_DESCRIPTION VARCHAR2 (250) Y
RATE_TYPE_DESCRIPTION VARCHAR2 (250) Y
RATE_CLASS_ID NUMBER (10) Y
RATE_TYPE_ID NUMBER (10) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWFV_GRANT_PROPOSAL_RATE_TYPE references the following:

APPS
SYNONYM - IGW_RATE_CLASSES
SYNONYM - IGW_RATE_TYPES

APPS.IGWFV_GRANT_PROPOSAL_RATE_TYPE is not referenced by any database object

[top of page]

View: IGWFV_GRANT_PRPSL_BDGT_LIN_AMT

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_NUMBER VARCHAR2 (30) Y
BUDGET_VERSION_ID NUMBER (4) Y
RATE_CLASS_DESCRIPTION VARCHAR2 (250) Y
RATE_TYPE_DESCRIPTION VARCHAR2 (250) Y
APPLY_RATE_FLAG VARCHAR2 (1)
CALCULATED_COST NUMBER (15)
CALCULATED_COST_SHARING NUMBER (15)
PROPOSAL_ID NUMBER (15) Y
BUDGET_PERIOD_ID NUMBER (4) Y
LINE_ITEM_ID NUMBER (15) Y
RATE_CLASS_ID NUMBER (10) Y
RATE_TYPE_ID NUMBER (10) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWFV_GRANT_PRPSL_BDGT_LIN_AMT references the following:

APPS
SYNONYM - IGW_BUDGET_DETAILS_CAL_AMTS
SYNONYM - IGW_PROPOSALS_ALL
SYNONYM - IGW_RATE_CLASSES
SYNONYM - IGW_RATE_TYPES

APPS.IGWFV_GRANT_PRPSL_BDGT_LIN_AMT is not referenced by any database object

[top of page]

View: IGWFV_GRANT_PRPSL_BDGT_PERSON

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_NUMBER VARCHAR2 (30) Y
BUDGET_VERSION_ID NUMBER (4) Y
_LA:APPOINTMENT_TYPE CHAR (77)
EFFECTIVE_DATE DATE
Y
CALCULATION_BASE NUMBER (15) Y
PERSON_FULL_NAME VARCHAR2 (240)
PROPOSAL_ID NUMBER (15) Y
PERSON_ID NUMBER (15)
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWFV_GRANT_PRPSL_BDGT_PERSON references the following:

APPS
SYNONYM - IGW_BUDGET_PERSONS
SYNONYM - IGW_PROPOSALS_ALL
SYNONYM - PER_ALL_PEOPLE_F

APPS.IGWFV_GRANT_PRPSL_BDGT_PERSON is not referenced by any database object

[top of page]

View: IGWFV_GRANT_PRPSL_BDGT_VERSION

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_NUMBER VARCHAR2 (30) Y
BUDGET_VERSION_ID NUMBER (4) Y
START_DATE DATE
Y
END_DATE DATE
Y
TOTAL_COST NUMBER (15)
TOTAL_DIRECT_COST NUMBER (15)
TOTAL_INDIRECT_COST NUMBER (15)
COST_SHARING_AMOUNT NUMBER (15)
UNDERRECOVERY_AMOUNT NUMBER (15)
RESIDUAL_FUNDS_AMOUNT NUMBER (15)
TOTAL_COST_LIMIT NUMBER (15)
COMMENTS VARCHAR2 (2000)
FINAL_VERSION_FLAG VARCHAR2 (1)
_LA:BUDGET_TYPE CHAR (67)
PROPOSAL_FORM_NUMBER VARCHAR2 (30) Y
RATE_CLASS_DESCRIPTION VARCHAR2 (250) Y
_DF CHAR (37)
PROPOSAL_ID NUMBER (15) Y
OH_RATE_CLASS_ID NUMBER (10) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWFV_GRANT_PRPSL_BDGT_VERSION references the following:

APPS
SYNONYM - IGW_BUDGETS
SYNONYM - IGW_PROPOSALS_ALL
SYNONYM - IGW_RATE_CLASSES

APPS.IGWFV_GRANT_PRPSL_BDGT_VERSION is not referenced by any database object

[top of page]

View: IGWFV_GRANT_PRPSL_EXP_CATEGORY

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
EXPENDITURE_CATEGORY VARCHAR2 (30) Y
EXP_CATEGORY_DESCRIPTION VARCHAR2 (250)
BUDGET_CATEGORY VARCHAR2 (30) Y
PERSONNEL_ATTACHED_FLAG VARCHAR2 (1) Y
START_DATE_ACTIVE DATE

END_DATE_ACTIVE DATE

LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWFV_GRANT_PRPSL_EXP_CATEGORY references the following:

APPS
PACKAGE - FND_GLOBAL
SYNONYM - IGW_EXPENDITURE_CATEGORIES
VIEW - IGW_LOOKUPS_V

APPS.IGWFV_GRANT_PRPSL_EXP_CATEGORY is not referenced by any database object

[top of page]

View: IGWFV_GRANT_PRPSL_RATE_CLASS

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
RATE_CLASS_DESCRIPTION VARCHAR2 (250) Y
RATE_CLASS_TYPE VARCHAR2 (1) Y
OVERHEAD_TYPE VARCHAR2 (6)
RATE_CLASS_ID NUMBER (10) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWFV_GRANT_PRPSL_RATE_CLASS references the following:

APPS
SYNONYM - IGW_RATE_CLASSES

APPS.IGWFV_GRANT_PRPSL_RATE_CLASS is not referenced by any database object

[top of page]

View: IGWFV_GRANT_PRPSL_ROUTING_LIST

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
MAP_DESCRIPTION VARCHAR2 (30) Y
ORGANIZATION_NAME VARCHAR2 (240) Y
START_DATE_ACTIVE DATE
Y
END_DATE_ACTIVE DATE

MAP_ID NUMBER (10) Y
ORGANIZATION_ID NUMBER (15) Y
ORG_ID NUMBER (15)
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWFV_GRANT_PRPSL_ROUTING_LIST references the following:

APPS
SYNONYM - HR_ALL_ORGANIZATION_UNITS
SYNONYM - IGW_ORG_MAPS_ALL

APPS.IGWFV_GRANT_PRPSL_ROUTING_LIST is not referenced by any database object

[top of page]

View: IGWFV_GRANT_PRPSL_ROUTING_RULE

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
RULE_NAME VARCHAR2 (50) Y
RULE_SEQUENCE_NUMBER NUMBER (4)
RULE_TYPE VARCHAR2 (1) Y
VALID_FLAG VARCHAR2 (1)
START_DATE_ACTIVE DATE
Y
END_DATE_ACTIVE DATE

RULE_ID NUMBER (10) Y
ORGANIZATION_ID NUMBER (15) Y
ORGANIZATION_NAME VARCHAR2 (240) Y
ORG_ID NUMBER (15)
MAP_ID NUMBER (10)
MAP_DESCRIPTION VARCHAR2 (30) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWFV_GRANT_PRPSL_ROUTING_RULE references the following:

APPS
SYNONYM - HR_ALL_ORGANIZATION_UNITS
SYNONYM - IGW_BUSINESS_RULES_ALL
SYNONYM - IGW_ORG_MAPS_ALL

APPS.IGWFV_GRANT_PRPSL_ROUTING_RULE is not referenced by any database object

[top of page]

View: IGWFV_GRANT_PRPSL_SUPPRT_TEXT

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_NUMBER VARCHAR2 (30) Y
PROPOSAL_ID NUMBER (15) Y
ABSTRACT_CODE VARCHAR2 (30) Y
ABSTRACT_TYPE VARCHAR2 (80) Y
ABSTRACT VARCHAR2 (4000)
ABSTRACT_CATEGORY VARCHAR2 (30) Y
_DF CHAR (39)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWFV_GRANT_PRPSL_SUPPRT_TEXT references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - IGW_LOOKUPS_V
SYNONYM - IGW_PROPOSALS_ALL
SYNONYM - IGW_PROP_ABSTRACTS

APPS.IGWFV_GRANT_PRPSL_SUPPRT_TEXT is not referenced by any database object

[top of page]

View: IGWFV_GRNT_PERS_CERT_ANSWER

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_NUMBER VARCHAR2 (30) Y
QUESTION_NUMBER VARCHAR2 (5) Y
QUESTION VARCHAR2 (500) Y
ANSWER VARCHAR2 (1)
REVIEW_DATE DATE

PERSON_ID NUMBER (15)
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
EXPLANATION VARCHAR2 (800)

[top of page]

APPS.IGWFV_GRNT_PERS_CERT_ANSWER references the following:

APPS
SYNONYM - IGW_PROPOSALS_ALL
SYNONYM - IGW_PROP_PERSON_QUESTIONS
SYNONYM - IGW_QUESTIONS
SYNONYM - IGW_QUESTIONS_TL

APPS.IGWFV_GRNT_PERS_CERT_ANSWER is not referenced by any database object

[top of page]

View: IGWFV_GRNT_PRPSL_APRVL_LST_MBR

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_NUMBER VARCHAR2 (30) Y
USER_NAME VARCHAR2 (100) Y
WF_ROLE_NAME VARCHAR2 (100)
WF_DISPLAY_ROLE_NAME VARCHAR2 (200) Y
APPROVER_TYPE VARCHAR2 (1)
APPROVAL_STATUS VARCHAR2 (1)
SUBMISSION_DATE DATE

APPROVAL_DATE DATE

COMMENTS VARCHAR2 (2000)
PROPOSAL_ID NUMBER (15) Y
RUN_ID NUMBER (15) Y
PROP_MAP_ID NUMBER (15) Y
APPROVAL_STOP_ID NUMBER (4) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWFV_GRNT_PRPSL_APRVL_LST_MBR references the following:

APPS
SYNONYM - IGW_PROPOSALS_ALL
SYNONYM - IGW_PROP_MAPS
SYNONYM - IGW_PROP_MAP_STOPS

APPS.IGWFV_GRNT_PRPSL_APRVL_LST_MBR is not referenced by any database object

[top of page]

View: IGWFV_GRNT_PRPSL_APRV_APVL_LST

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_NUMBER VARCHAR2 (30) Y
MAP_DESCRIPTION VARCHAR2 (200) Y
MAP_TYPE VARCHAR2 (1) Y
MAP_SEQUENCE_NUMBER NUMBER (4) Y
APPROVAL_STATUS VARCHAR2 (1)
RUN_ID NUMBER (15) Y
PROPOSAL_ID NUMBER (15) Y
PROP_MAP_ID NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWFV_GRNT_PRPSL_APRV_APVL_LST references the following:

APPS
SYNONYM - IGW_PROPOSALS_ALL
SYNONYM - IGW_PROP_MAPS

APPS.IGWFV_GRNT_PRPSL_APRV_APVL_LST is not referenced by any database object

[top of page]

View: IGWFV_GRNT_PRPSL_BDGT_LIN_PERS

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_NUMBER VARCHAR2 (30) Y
PERSON_FULL_NAME VARCHAR2 (240)
START_DATE DATE
Y
END_DATE DATE
Y
BUDGET_PERSON_PERIOD_TYPE VARCHAR2 (30) Y
_LA:APPOINTMENT_TYPE CHAR (68)
SALARY_REQUESTED NUMBER (15)
AMOUNT_CHARGED_PERCENT NUMBER (5)
EFFORT_PERCENT NUMBER (5)
COST_SHARING_PERCENT NUMBER (5)
COST_SHARING_AMOUNT NUMBER (15)
UNDERRECOVERY_AMOUNT NUMBER (15)
BUDGET_PERSONNEL_DETAIL_ID NUMBER (15) Y
PROPOSAL_ID NUMBER (15) Y
VERSION_ID NUMBER (4) Y
BUDGET_PERIOD_ID NUMBER (4) Y
LINE_ITEM_ID NUMBER (15) Y
PERSON_ID NUMBER (15)
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWFV_GRNT_PRPSL_BDGT_LIN_PERS references the following:

APPS
PACKAGE - FND_GLOBAL
SYNONYM - IGW_BUDGET_PERSONNEL_DETAILS
VIEW - IGW_LOOKUPS_V
SYNONYM - IGW_PROPOSALS_ALL
SYNONYM - PER_ALL_PEOPLE_F

APPS.IGWFV_GRNT_PRPSL_BDGT_LIN_PERS is not referenced by any database object

[top of page]

View: IGWFV_GRNT_PRPSL_BDGT_PERS_AMT

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_NUMBER VARCHAR2 (30) Y
BUDGET_VERSION_ID NUMBER (4) Y
PERSON_FULL_NAME VARCHAR2 (240)
RATE_CLASS_DESCRIPTION VARCHAR2 (250) Y
RATE_TYPE_DESCRIPTION VARCHAR2 (250) Y
APPLY_RATE_FLAG VARCHAR2 (1)
CALCULATED_COST NUMBER (15)
CALCULATED_COST_SHARING NUMBER (15)
PROPOSAL_ID NUMBER (15) Y
BUDGET_PERIOD_ID NUMBER (4) Y
BUDGET_LINE_ITEM_ID NUMBER (15) Y
PERSON_ID NUMBER (15)
BUDGET_PERSONNEL_DETAIL_ID NUMBER (15) Y
RATE_CLASS_ID NUMBER (10) Y
RATE_TYPE_ID NUMBER (10) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWFV_GRNT_PRPSL_BDGT_PERS_AMT references the following:

APPS
SYNONYM - IGW_BUDGET_PERSONNEL_CAL_AMTS
SYNONYM - IGW_BUDGET_PERSONNEL_DETAILS
SYNONYM - IGW_PROPOSALS_ALL
SYNONYM - IGW_RATE_CLASSES
SYNONYM - IGW_RATE_TYPES
SYNONYM - PER_ALL_PEOPLE_F

APPS.IGWFV_GRNT_PRPSL_BDGT_PERS_AMT is not referenced by any database object

[top of page]

View: IGWFV_GRNT_PRPSL_BUDGT_PERIOD

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_NUMBER VARCHAR2 (30) Y
START_DATE DATE
Y
END_DATE DATE
Y
TOTAL_COST NUMBER (15)
TOTAL_DIRECT_COST NUMBER (15)
TOTAL_INDIRECT_COST NUMBER (15)
COST_SHARING_AMOUNT NUMBER (15)
UNDERRECOVERY_AMOUNT NUMBER (15)
TOTAL_COST_LIMIT NUMBER (15)
PROGRAM_INCOME NUMBER (15)
PROGRAM_INCOME_SOURCE VARCHAR2 (50)
PROPOSAL_ID NUMBER (15) Y
VERSION_ID NUMBER (4) Y
BUDGET_PERIOD_ID NUMBER (4) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWFV_GRNT_PRPSL_BUDGT_PERIOD references the following:

APPS
SYNONYM - IGW_BUDGET_PERIODS
SYNONYM - IGW_PROPOSALS_ALL

APPS.IGWFV_GRNT_PRPSL_BUDGT_PERIOD is not referenced by any database object

[top of page]

View: IGWFV_GRNT_PRPSL_CERT_ANSWER

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_NUMBER VARCHAR2 (30) Y
QUESTION_NUMBER VARCHAR2 (5) Y
QUESTION VARCHAR2 (500) Y
ANSWER VARCHAR2 (1)
EXPLANATION VARCHAR2 (800)
REVIEW_DATE DATE

PROPOSAL_ID NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWFV_GRNT_PRPSL_CERT_ANSWER references the following:

APPS
SYNONYM - IGW_PROPOSALS_ALL
SYNONYM - IGW_PROP_QUESTIONS
SYNONYM - IGW_QUESTIONS_TL

APPS.IGWFV_GRNT_PRPSL_CERT_ANSWER is not referenced by any database object

[top of page]

View: IGWFV_GRNT_PRPSL_CERT_QUESTION

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
QUESTION_NUMBER VARCHAR2 (5) Y
QUESTION VARCHAR2 (500) Y
EXPLANATION VARCHAR2 (1000)
POLICY VARCHAR2 (1000)
REGULATION VARCHAR2 (1000)
APPLIES_TO VARCHAR2 (1) Y
EXPLANATION_FOR_YES_FLAG VARCHAR2 (1) Y
EXPLANATION_FOR_NO_FLAG VARCHAR2 (1) Y
DATE_FOR_YES_FLAG VARCHAR2 (1) Y
DATE_FOR_NO_FLAG VARCHAR2 (1) Y
START_DATE_ACTIVE DATE
Y
END_DATE_ACTIVE DATE

LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWFV_GRNT_PRPSL_CERT_QUESTION references the following:

APPS
SYNONYM - IGW_QUESTIONS
SYNONYM - IGW_QUESTIONS_TL

APPS.IGWFV_GRNT_PRPSL_CERT_QUESTION is not referenced by any database object

[top of page]

View: IGWFV_GRNT_PRPSL_COMMENT

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_NUMBER VARCHAR2 (30) Y
COMMENTS VARCHAR2 (4000)
PROPOSAL_ID NUMBER (15) Y
COMMENT_ID NUMBER (10) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWFV_GRNT_PRPSL_COMMENT references the following:

APPS
SYNONYM - IGW_PROPOSALS_ALL
SYNONYM - IGW_PROP_COMMENTS

APPS.IGWFV_GRNT_PRPSL_COMMENT is not referenced by any database object

[top of page]

View: IGWFV_GRNT_PRPSL_EXP_RATE_ASGN

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
RATE_CLASS_DESCRIPTION VARCHAR2 (250) Y
RATE_TYPE_DESCRIPTION VARCHAR2 (250) Y
EXP_CATEGORY_DESCRIPTION VARCHAR2 (250)
RATE_CLASS_ID NUMBER (10) Y
RATE_TYPE_ID NUMBER (10) Y
EXPENDITURE_CATEGORY VARCHAR2 (30) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWFV_GRNT_PRPSL_EXP_RATE_ASGN references the following:

APPS
SYNONYM - IGW_EXPENDITURE_CATEGORIES
SYNONYM - IGW_EXP_TYPE_RATE_TYPES
SYNONYM - IGW_RATE_CLASSES
SYNONYM - IGW_RATE_TYPES

APPS.IGWFV_GRNT_PRPSL_EXP_RATE_ASGN is not referenced by any database object

[top of page]

View: IGWFV_GRNT_PRPSL_ORG_CERT_ANSW

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_NAME VARCHAR2 (240) Y
QUESTION_NUMBER VARCHAR2 (5) Y
QUESTION VARCHAR2 (500) Y
ANSWER VARCHAR2 (1)
EXPLANATION VARCHAR2 (800)
REVIEW_DATE DATE

ORGANIZATION_ID NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWFV_GRNT_PRPSL_ORG_CERT_ANSW references the following:

APPS
SYNONYM - HR_ALL_ORGANIZATION_UNITS
SYNONYM - IGW_ORG_QUESTIONS
SYNONYM - IGW_QUESTIONS_TL

APPS.IGWFV_GRNT_PRPSL_ORG_CERT_ANSW is not referenced by any database object

[top of page]

View: IGWFV_GRNT_PRPSL_PERS_BIOSKTCH

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
PERSON_FULL_NAME VARCHAR2 (240)
BIOSKETCH_TYPE VARCHAR2 (80) Y
BIOSKETCH_LINE_SEQUENCE NUMBER (4) Y
BIOSKETCH_LINE VARCHAR2 (500) Y
ENABLE_FLAG VARCHAR2 (1) Y
PERSON_BIOSKETCH_ID NUMBER (10) Y
PERSON_ID NUMBER (15)
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWFV_GRNT_PRPSL_PERS_BIOSKTCH references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - IGW_LOOKUPS_V
SYNONYM - IGW_PERSON_BIOSKETCH
SYNONYM - PER_ALL_PEOPLE_F

APPS.IGWFV_GRNT_PRPSL_PERS_BIOSKTCH is not referenced by any database object

[top of page]

View: IGWFV_GRNT_PRPSL_PERS_DEGREE

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
PERSON_FULL_NAME VARCHAR2 (240)
DEGREE_TYPE VARCHAR2 (30) Y
GRADUATION_DATE DATE
Y
DEGREE VARCHAR2 (80) Y
DEGREE_OBTAINED_SEQUENCE NUMBER (3) Y
FIELD_OF_STUDY VARCHAR2 (80)
SPECIALIZATION VARCHAR2 (80)
SCHOOL_NAME VARCHAR2 (100)
PERSON_DEGREE_ID NUMBER (10) Y
PERSON_ID NUMBER (15)
_DF CHAR (39)
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWFV_GRNT_PRPSL_PERS_DEGREE references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - IGW_LOOKUPS_V
SYNONYM - IGW_PERSON_DEGREES
SYNONYM - PER_ALL_PEOPLE_F

APPS.IGWFV_GRNT_PRPSL_PERS_DEGREE is not referenced by any database object

[top of page]

View: IGWFV_GRNT_PRPSL_PERS_DEG_ASGN

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_NUMBER VARCHAR2 (30) Y
PERSON_NAME VARCHAR2 (240)
DEGREE_TYPE VARCHAR2 (80) Y
GRADUATION_DATE DATE
Y
DEGREE VARCHAR2 (80) Y
FIELD_OF_STUDY VARCHAR2 (80)
SPECIALIZATION VARCHAR2 (80)
SCHOOL_NAME VARCHAR2 (100)
SHOW_FLAG VARCHAR2 (1) Y
DEGREE_OBTAINED_SEQUENCE NUMBER (2) Y
PROPOSAL_ID NUMBER (15) Y
PERSON_DEGREE_ID NUMBER (10) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWFV_GRNT_PRPSL_PERS_DEG_ASGN references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - IGW_LOOKUPS_V
SYNONYM - IGW_PERSON_DEGREES
SYNONYM - IGW_PROPOSALS_ALL
SYNONYM - IGW_PROP_PERSON_DEGREES
SYNONYM - PER_ALL_PEOPLE_F

APPS.IGWFV_GRNT_PRPSL_PERS_DEG_ASGN is not referenced by any database object

[top of page]

View: IGWFV_GRNT_PRPSL_PERS_OTHR_SUP

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
PROP_PERSON_SUPPORT_ID NUMBER (15) Y
PROPOSAL_NUMBER VARCHAR2 (30) Y
PERSON_FULL_NAME VARCHAR2 (240)
OTHER_SUPPORT_PI_FULL_NAME VARCHAR2 (240)
SPONSOR_NAME VARCHAR2 (50)
_LA:SUPPORT_TYPE CHAR (60)
PROPOSAL_AWARD_NUMBER VARCHAR2 (30)
PROPOSAL_AWARD_TITLE VARCHAR2 (250)
START_DATE DATE

END_DATE DATE

PERCENT_EFFORT NUMBER (5)
ANNUAL_DIRECT_COST NUMBER (15)
TOTAL_COST NUMBER (15)
PROJECT_LOCATION VARCHAR2 (100)
CALENDAR_START_DATE DATE

CALENDAR_END_DATE DATE

ACADEMIC_START_DATE DATE

ACADEMIC_END_DATE DATE

SUMMER_START_DATE DATE

SUMMER_END_DATE DATE

MAJOR_GOALS VARCHAR2 (250)
OVERLAP VARCHAR2 (250)
_DF CHAR (40)
PROPOSAL_ID NUMBER (15) Y
PERSON_ID NUMBER (15)
PI_PERSON_ID NUMBER (15)
SPONSOR_ID NUMBER (15)
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWFV_GRNT_PRPSL_PERS_OTHR_SUP references the following:

APPS
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_PARTIES
SYNONYM - IGW_PROPOSALS_ALL
SYNONYM - IGW_PROP_PERSON_SUPPORT
SYNONYM - PER_ALL_PEOPLE_F

APPS.IGWFV_GRNT_PRPSL_PERS_OTHR_SUP is not referenced by any database object

[top of page]

View: IGWFV_GRNT_PRPSL_PERS_PRF_ASGN

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_NUMBER VARCHAR2 (30) Y
PERSON_NAME VARCHAR2 (240)
BIOSKETCH_TYPE VARCHAR2 (80) Y
BIOSKETCH_LINE VARCHAR2 (500) Y
ENABLE_FLAG VARCHAR2 (1) Y
SHOW_FLAG VARCHAR2 (1) Y
LINE_SEQUENCE NUMBER (4) Y
PROPOSAL_ID NUMBER (15) Y
PERSON_BIOSKETCH_ID NUMBER (10) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWFV_GRNT_PRPSL_PERS_PRF_ASGN references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - IGW_LOOKUPS_V
SYNONYM - IGW_PERSON_BIOSKETCH
SYNONYM - IGW_PROPOSALS_ALL
SYNONYM - IGW_PROP_PERSON_BIOSKETCH
SYNONYM - PER_ALL_PEOPLE_F

APPS.IGWFV_GRNT_PRPSL_PERS_PRF_ASGN is not referenced by any database object

[top of page]

View: IGWFV_GRNT_PRPSL_ROUTG_LST_MBR

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
MAP_DESCRIPTION VARCHAR2 (30) Y
ORGANIZATION_NAME VARCHAR2 (240) Y
USER_NAME VARCHAR2 (100) Y
APPROVER_TYPE VARCHAR2 (1)
MAP_ID NUMBER (10) Y
STOP_ID NUMBER (4) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWFV_GRNT_PRPSL_ROUTG_LST_MBR references the following:

APPS
SYNONYM - HR_ALL_ORGANIZATION_UNITS
SYNONYM - IGW_ORG_MAPS_ALL
SYNONYM - IGW_ORG_MAP_DETAILS

APPS.IGWFV_GRNT_PRPSL_ROUTG_LST_MBR is not referenced by any database object

[top of page]

View: IGWFV_GRNT_PRPSL_ROUT_RULE_LNE

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
RULE_NAME VARCHAR2 (50) Y
EXPRESSION_SEQUENCE_NUMBER NUMBER (4) Y
EXPRESSION_TYPE VARCHAR2 (1) Y
LEFT_BRACKETS VARCHAR2 (10)
LEFT_VALUE VARCHAR2 (50) Y
ARITHMATIC_OPERATOR VARCHAR2 (2) Y
RIGHT_VALUE VARCHAR2 (200) Y
RGHT_VALUE_ID VARCHAR2 (30)
RIGHT_BRACKETS VARCHAR2 (10)
LOGICAL_OPERATOR VARCHAR2 (3)
RULE_ID NUMBER (15) Y
EXPRESSION_ID NUMBER (10) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWFV_GRNT_PRPSL_ROUT_RULE_LNE references the following:

APPS
SYNONYM - IGW_BUSINESS_RULES_ALL
SYNONYM - IGW_BUSINESS_RULE_LINES

APPS.IGWFV_GRNT_PRPSL_ROUT_RULE_LNE is not referenced by any database object

[top of page]

View: IGWFV_GRNT_PRPSL_SPCL_RVW

Comments
View Type

A Business Intelligence System view

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_NUMBER VARCHAR2 (30) Y
SPECIAL_REVIEW_SUBJECT VARCHAR2 (80) Y
SPECIAL_REVIEW_COVERAGE VARCHAR2 (80)
_LA:REVIEW_APPROVAL_STATUS CHAR (73)
PROTOCOL_NUMBER VARCHAR2 (50)
APPLICATION_DATE DATE

APPROVAL_DATE DATE

COMMENTS VARCHAR2 (4000)
PROPOSAL_ID NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y

[top of page]

APPS.IGWFV_GRNT_PRPSL_SPCL_RVW references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - IGW_LOOKUPS_V
SYNONYM - IGW_PROPOSALS_ALL
SYNONYM - IGW_PROP_SPECIAL_REVIEWS

APPS.IGWFV_GRNT_PRPSL_SPCL_RVW is not referenced by any database object

[top of page]

View: IGW_ADMIN_OFFICIAL_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

IGW_ADMIN_OFFICIAL_V displays the details of the Administrative Official responsible for the proposal. Details include name, address, and organization of the Administrative Official.

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_ID NUMBER (15) Y Proposal identifier
PROPOSAL_NUMBER VARCHAR2 (30) Y Proposal number
LEAD_UNIT_ORG_ID NUMBER (15)
Applicant unit identifier. It is a Foreign Key to HR_ALL_ORGANIZATION_UNITS.
PERSON_ID NUMBER (10) Y Person identifier
FULL_NAME VARCHAR2 (240)
Full name
LAST_NAME VARCHAR2 (150) Y Last name
FIRST_NAME VARCHAR2 (150)
First name
MIDDLE_NAME VARCHAR2 (60)
Middle name
TITLE VARCHAR2 (30)
Title such as Mr., Ms., or Dr.
PREFIX VARCHAR2 (30)
Prefix
SUFFIX VARCHAR2 (30)
Suffix after the surname, such as Sr., Jr., or III
LAST_FIRST_MIDDLE_NAME VARCHAR2 (363)
Last name, first name, and middle name of Administrative Offical. Names are separated by commas.
FIRST_MIDDLE_LAST_NAME VARCHAR2 (393)
First name, middle name, and last name. Names are separated by commas.
JOB_NAME VARCHAR2 (4000)
Job name
ADDRESS_LINE1 VARCHAR2 (240)
First address line
ADDRESS_LINE2 VARCHAR2 (240)
Second address line
ADDRESS_LINE3 VARCHAR2 (240)
Third address line
POSTAL_CODE VARCHAR2 (30)
Postal code
REGION_1 VARCHAR2 (120)
Primary region in which address is located
REGION_2 VARCHAR2 (120)
Subregion of region 1 in which address is located
REGION_3 VARCHAR2 (120)
Subregion of region 2 in which address is located
TOWN_OR_CITY VARCHAR2 (30)
Town or city
COUNTRY VARCHAR2 (60)
Country
WORK_PHONE VARCHAR2 (4000)
Work phone
WORK_FAX VARCHAR2 (4000)
Work fax
EMAIL_ADDRESS VARCHAR2 (240)
E-mail address

[top of page]

APPS.IGW_ADMIN_OFFICIAL_V references the following:

APPS
PACKAGE - HR_GENERAL
VIEW - HR_LOCATIONS
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
SYNONYM - IGW_PROPOSALS_ALL
PACKAGE - IGW_REPORT_PROCESSING
VIEW - PER_ASSIGNMENTS_X
VIEW - PER_PEOPLE_X
APPS.IGW_ADMIN_OFFICIAL_V is referenced by following:

APPS
VIEW - IGW_PRPO_HEADERS_V

[top of page]

View: IGW_APPLICANT_DEPT_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

IGW_APPLICANT_DEPT_V displays the name and major subdivision of the applicant unit. Applicant units belong to the applicant organization.

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_ID NUMBER (15) Y Proposal identifier
ORGANIZATION_ID NUMBER (15)
Applicant unit identifier
ORGANIZATION_NAME VARCHAR2 (240) Y Applicant organization
MAJOR_SUBDIVISION_CODE VARCHAR2 (30)
Major subdivision identifier
MAJOR_SUBDIVISION_NAME VARCHAR2 (80)
School, college, or other major subdivision, such as medical, dental, engineering, graduate, nursing, or public health

[top of page]

APPS.IGW_APPLICANT_DEPT_V references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS
SYNONYM - HR_ALL_ORGANIZATION_UNITS
SYNONYM - IGW_ORG_DETAILS
SYNONYM - IGW_PROPOSALS_ALL

APPS.IGW_APPLICANT_DEPT_V is not referenced by any database object

[top of page]

View: IGW_APPLICANT_ORG_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

IGW_APPLICANT_ORG_V displays details of the organization that is submitting the proposal. Organization details include Signing Official government identifier, Administrative Official government identifier, assurance compliance numbers, and DUNS number.

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_ID NUMBER (15) Y Proposal identifier
PROPOSAL_NUMBER VARCHAR2 (30) Y Proposal number
ORGANIZATION_ID NUMBER (15)
Organization identifier
ADMIN_OFFICIAL_GOVT_ID VARCHAR2 (4000)
Administrative Official person identifier. It is Foreign Key to the PER_ALL_PEOPLE_F table.
SIGNING_OFFICIAL_GOVT_ID VARCHAR2 (4000)
Signing Official person identifier. It is Foreign Key to the PER_ALL_PEOPLE_F table.
AGREEMENT_DATE DATE

Date of agreement with sponsor regarding indirect costs
NEGOTIATING_AGREEMENT_WITH VARCHAR2 (50)
Name of agency with whom agreement is negotiated
RATE_ESTABLISHED_WITH VARCHAR2 (50)
Agency within the sponsor's organization with which rate agreement is established
RATE_ESTABLISHED_DATE DATE

Date of rate establishment
ORG_IPF_CODE VARCHAR2 (20)
Organization's Institutional Profile Code
CONGRESS_DISTRICT VARCHAR2 (50)
Congressional district
EIN VARCHAR2 (20)
Employer Identification Number
TIN VARCHAR2 (20)
Taxpayer Identification Number
DUNS_NUMBER VARCHAR2 (20)
Data Universal Numbering System number
DUNS4_NUMBER VARCHAR2 (20)
Data Universal Numbering System +4 number
DODAAC_NUMBER VARCHAR2 (20)
Department of Defense Activity Address Code number
CAGE_NUMBER VARCHAR2 (20)
Commercial and Government Entity Number
HUMAN_EXEMPTION_NUMBER VARCHAR2 (20)
Human subjects exemption number
HUMAN_ASSURANCE_NUMBER VARCHAR2 (20)
Human subjects assurance number
ANIMAL_ASSURANCE_NUMBER VARCHAR2 (20)
Animal subjects assurance number
NSF_INSTITUTIONAL_CODE VARCHAR2 (20)
National Science Foundation institutional code
ORGANIZATION_NAME VARCHAR2 (240)
Organization's name
ADDRESS_LINE_1 VARCHAR2 (240)
First address line
ADDRESS_LINE_2 VARCHAR2 (240)
Second address line
ADDRESS_LINE_3 VARCHAR2 (240)
Third address line
POSTAL_CODE VARCHAR2 (30)
Postal code
REGION_1 VARCHAR2 (120)
Primary region in which address is located
REGION_2 VARCHAR2 (120)
Subregion of Region 1 in which address is located
REGION_3 VARCHAR2 (120)
Subregion of Region 2 in which address is located
PHONE_NUMBER VARCHAR2 (60)
Phone number
FAX_NUMBER VARCHAR2 (60)
Fax number
TOWN_OR_CITY VARCHAR2 (30)
Town or city
COUNTRY VARCHAR2 (60)
Country

[top of page]

APPS.IGW_APPLICANT_ORG_V references the following:

APPS
SYNONYM - HR_ALL_ORGANIZATION_UNITS
PACKAGE - HR_GENERAL
VIEW - HR_LOCATIONS
PACKAGE - IGW_EXTENSION_PKG
SYNONYM - IGW_ORG_DETAILS
SYNONYM - IGW_PROPOSALS_ALL
APPS.IGW_APPLICANT_ORG_V is referenced by following:

APPS
VIEW - IGW_PRPO_HEADERS_V

[top of page]

View: IGW_APR_ORGANIZATIONS_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER (15) Y
NAME VARCHAR2 (240) Y
BUSINESS_GROUP_ID NUMBER (15) Y

[top of page]

APPS.IGW_APR_ORGANIZATIONS_V references the following:

APPS
PACKAGE - HR_GENERAL
VIEW - HR_ORGANIZATION_UNITS
PACKAGE - HR_SECURITY
VIEW - IGW_IMPLEMENTATIONS
SYNONYM - PER_ORG_STRUCTURE_ELEMENTS

APPS.IGW_APR_ORGANIZATIONS_V is not referenced by any database object

[top of page]

View: IGW_AWARDS_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
AWARD_ID NUMBER (15) Y Award identifier
AWARD_NUMBER VARCHAR2 (15) Y Award number
FUNDING_SOURCE_AWARD_NUMBER VARCHAR2 (30)
STATUS VARCHAR2 (30)
Award status. Possible values are ACTIVE and CLOSED
AWARD_FULL_NAME VARCHAR2 (240)
Award title
FUNDING_SOURCE_ID NUMBER (15)
Funding source identifier
FUNDING_SOURCE_NAME VARCHAR2 (50)
START_DATE_ACTIVE DATE

First effective date of award
END_DATE_ACTIVE DATE

Last effective date of award
CLOSE_DATE DATE

LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
PROPOSAL_ID NUMBER (15)
Proposal identifier corresponding to the award
MAJOR_GOALS VARCHAR2 (4000)

[top of page]

APPS.IGW_AWARDS_V references the following:

APPS
SYNONYM - GMS_AWARDS
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_PARTIES
PACKAGE - IGW_VIEW_PARAMETERS
APPS.IGW_AWARDS_V is referenced by following:

APPS
PACKAGE BODY - IGW_PROP_PERSON_SUPPORT_PVT

[top of page]

View: IGW_BIOSKETCH_TYPES_V

Comments
Columns
Name Datatype Length Mandatory Comments
BIOSKETCH_TYPE VARCHAR2 (30) Y
BIOSKETCH_TYPE_NAME VARCHAR2 (80) Y

[top of page]

APPS.IGW_BIOSKETCH_TYPES_V references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS

APPS.IGW_BIOSKETCH_TYPES_V is not referenced by any database object

[top of page]

View: IGW_BUDGETS_V

Comments
Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
PROPOSAL_ID NUMBER (15) Y
VERSION_ID NUMBER (4) Y
START_DATE DATE
Y
END_DATE DATE
Y
TOTAL_COST NUMBER (15)
TOTAL_DIRECT_COST NUMBER (15)
TOTAL_INDIRECT_COST NUMBER (15)
COST_SHARING_AMOUNT NUMBER (15)
UNDERRECOVERY_AMOUNT NUMBER (15)
RESIDUAL_FUNDS NUMBER (15)
TOTAL_COST_LIMIT NUMBER (15)
OH_RATE_CLASS_ID NUMBER (10) Y
PROPOSAL_FORM_NUMBER VARCHAR2 (30) Y
OH_RATE_CLASS VARCHAR2 (250) Y
COMMENTS VARCHAR2 (2000)
FINAL_VERSION_FLAG VARCHAR2 (1)
BUDGET_TYPE_CODE VARCHAR2 (30)
BUDGET_TYPE VARCHAR2 (80) Y
RECORD_VERSION_NUMBER NUMBER
Y
ENTER_BUDGET_AT_PERIOD_LEVEL VARCHAR2 (1)
APPLY_INFLATION_SETUP_RATES VARCHAR2 (1)
APPLY_EB_SETUP_RATES VARCHAR2 (1)
APPLY_OH_SETUP_RATES VARCHAR2 (1)
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15) Y
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
DESCRIPTION VARCHAR2 (250) Y
ALLOW_CREATE VARCHAR2 (4000)
ALLOW_MODIFY VARCHAR2 (4000)

[top of page]

APPS.IGW_BUDGETS_V references the following:

APPS
PACKAGE - FND_GLOBAL
SYNONYM - IGW_BUDGETS
VIEW - IGW_LOOKUPS_V
SYNONYM - IGW_RATE_CLASSES
PACKAGE - IGW_SECURITY

APPS.IGW_BUDGETS_V is not referenced by any database object

[top of page]

View: IGW_BUDGET_CATEGORY_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_ID NUMBER (15) Y
VERSION_ID NUMBER (4) Y
BUDGET_PERIOD_ID NUMBER (4) Y
LINE_ITEM_ID NUMBER (15) Y
EXPENDITURE_TYPE VARCHAR2 (30) Y
EXPENDITURE_CATEGORY_FLAG VARCHAR2 (1) Y
BUDGET_CATEGORY_CODE VARCHAR2 (30) Y
BUDGET_CATEGORY VARCHAR2 (80) Y
BASE_AMT NUMBER

OH_APPLIED_FLAG VARCHAR2 (1)
OH_COST NUMBER

EB_COST NUMBER

[top of page]

APPS.IGW_BUDGET_CATEGORY_V references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - IGW_BUDGET_COMPLETE_V
PACKAGE - IGW_BUDGET_INTEGRATION
VIEW - IGW_LOOKUPS_V
APPS.IGW_BUDGET_CATEGORY_V is referenced by following:

APPS
PACKAGE BODY - IGW_REPORT_PROCESSING

[top of page]

View: IGW_BUDGET_COMPLETE_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_ID NUMBER (15) Y
VERSION_ID NUMBER (4) Y
BUDGET_PERIOD_ID NUMBER (4) Y
LINE_ITEM_ID NUMBER (15) Y
LINE_ITEM_COST NUMBER

EXPENDITURE_TYPE VARCHAR2 (30) Y
BUDGET_CATEGORY_CODE VARCHAR2 (30) Y
EXPENDITURE_CATEGORY_FLAG VARCHAR2 (1) Y
BASED_ON_LINE_ITEM NUMBER (15)
PROJECT_ID NUMBER (15)
AWARD_ID NUMBER (15)
TASK_ID NUMBER (15)
OH_COST NUMBER

EB_COST NUMBER

[top of page]

APPS.IGW_BUDGET_COMPLETE_V references the following:

APPS
SYNONYM - IGW_BUDGET_DETAILS
PACKAGE - IGW_BUDGET_INTEGRATION
APPS.IGW_BUDGET_COMPLETE_V is referenced by following:

APPS
VIEW - IGW_BUDGET_CATEGORY_V

[top of page]

View: IGW_BUDGET_COSTS_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

IGW_BUDGET_COSTS_V displays total cost, direct cost, and the proposed period for the proposal.

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_ID NUMBER (15) Y Proposal identifier
VERSION_ID NUMBER (4) Y Final budget version identifier
PROPOSAL_START_DATE DATE
Y Proposal start date
PROPOSAL_END_DATE DATE
Y Proposal end date
DURATION_MONTHS NUMBER

Proposed project duration in months
TOTAL_COST NUMBER (15)
Proposed total cost
TOTAL_DIRECT_COST NUMBER (15)
Proposed total direct cost
TOTAL_INDIRECT_COST NUMBER (15)
Proposed total indirect cost
INITIAL_TOTAL_COST NUMBER (15)
Proposed initial budget period total cost
INITIAL_DIRECT_COST NUMBER (15)
Proposed initial budget period direct cost
INITIAL_INDIRECT_COST NUMBER (15)
Proposed initial budget period indirect cost

[top of page]

APPS.IGW_BUDGET_COSTS_V references the following:

APPS
SYNONYM - IGW_BUDGETS
SYNONYM - IGW_BUDGET_PERIODS
SYNONYM - IGW_PROPOSALS_ALL

APPS.IGW_BUDGET_COSTS_V is not referenced by any database object

[top of page]

View: IGW_BUDGET_DETAILS_AMTS_V

Comments
Columns
Name Datatype Length Mandatory Comments
PROPOSAL_ID NUMBER (15) Y
VERSION_ID NUMBER (4) Y
BUDGET_PERIOD_ID NUMBER (4) Y
LINE_ITEM_ID NUMBER (15) Y
RATE_CLASS_ID NUMBER (10) Y
RATE_TYPE_ID NUMBER (10) Y
APPLY_RATE_FLAG VARCHAR2 (1)
CALCULATED_COST NUMBER (15)
CALCULATED_COST_SHARING NUMBER (15)
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15) Y

[top of page]

APPS.IGW_BUDGET_DETAILS_AMTS_V references the following:

APPS
SYNONYM - IGW_BUDGET_DETAILS_CAL_AMTS

APPS.IGW_BUDGET_DETAILS_AMTS_V is not referenced by any database object

[top of page]

View: IGW_BUDGET_DETAILS_V

Comments
Columns
Name Datatype Length Mandatory Comments
PROPOSAL_ID NUMBER (15) Y
VERSION_ID NUMBER (4) Y
BUDGET_PERIOD_ID NUMBER (4) Y
LINE_ITEM_ID NUMBER (15) Y
EXPENDITURE_TYPE VARCHAR2 (30) Y
BUDGET_CATEGORY_CODE VARCHAR2 (30) Y
EXPENDITURE_CATEGORY_FLAG VARCHAR2 (1) Y
LINE_ITEM_DESCRIPTION VARCHAR2 (250)
BASED_ON_LINE_ITEM NUMBER (15)
LINE_ITEM_COST NUMBER (15)
COST_SHARING_AMOUNT NUMBER (15)
UNDERRECOVERY_AMOUNT NUMBER (15)
APPLY_INFLATION_FLAG VARCHAR2 (1) Y
BUDGET_JUSTIFICATION LONG (0)
LOCATION_CODE VARCHAR2 (30) Y
PROJECT_ID NUMBER (15)
TASK_ID NUMBER (15)
AWARD_ID NUMBER (15)
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15) Y

[top of page]

APPS.IGW_BUDGET_DETAILS_V references the following:

APPS
SYNONYM - IGW_BUDGET_DETAILS

APPS.IGW_BUDGET_DETAILS_V is not referenced by any database object

[top of page]

View: IGW_BUDGET_EXPENDITURES_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
BUDGET_EXPENDITURE VARCHAR2 (30)
DESCRIPTION VARCHAR2 (4000)
BUDGET_CATEGORY_CODE VARCHAR2 (30)
EXPENDITURE_CATEGORY VARCHAR2 (30)
PARENT_CATEGORY VARCHAR2 (30)
PERSONNEL_ATTACHED_FLAG VARCHAR2 (1)
EXPENDITURE_CATEGORY_FLAG CHAR (1)
START_DATE_ACTIVE DATE

END_DATE_ACTIVE DATE

[top of page]

APPS.IGW_BUDGET_EXPENDITURES_V references the following:

APPS
VIEW - IGW_EXPENDITURE_CATEGORIES_V
VIEW - IGW_EXPENDITURE_TYPES_V
PACKAGE - IGW_EXP_CATEGORIES_V_PKG
PACKAGE - IGW_SECURITY
APPS.IGW_BUDGET_EXPENDITURES_V is referenced by following:

APPS
VIEW - IGW_BUDGET_LINE_CATEGORY_V
PACKAGE BODY - IGW_BUDGET_OPERATIONS
PACKAGE BODY - IGW_GENERATE_PERIODS
PACKAGE BODY - IGW_OVERHEAD_CAL

[top of page]

View: IGW_BUDGET_LINE_CATEGORY_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_ID NUMBER (15) Y
VERSION_ID NUMBER (4) Y
BUDGET_PERIOD_ID NUMBER (4) Y
LINE_ITEM_ID NUMBER (15) Y
LINE_ITEM_COST NUMBER (15)
EXPENDITURE_TYPE VARCHAR2 (30) Y
LINE_ITEM_DESCRIPTION VARCHAR2 (250)
BUDGET_CATEGORY_CODE VARCHAR2 (30) Y
BUDGET_CATEGORY VARCHAR2 (80) Y
BUDGET_JUSTIFICATION LONG (0)

[top of page]

APPS.IGW_BUDGET_LINE_CATEGORY_V references the following:

APPS
PACKAGE - FND_GLOBAL
SYNONYM - IGW_BUDGET_DETAILS
VIEW - IGW_BUDGET_EXPENDITURES_V
PACKAGE - IGW_EXP_CATEGORIES_V_PKG
VIEW - IGW_LOOKUPS_V
PACKAGE - IGW_SECURITY
APPS.IGW_BUDGET_LINE_CATEGORY_V is referenced by following:

APPS
PACKAGE BODY - IGW_REPORT_PROCESSING

[top of page]

View: IGW_BUDGET_MATRIX_V

Comments
Columns
Name Datatype Length Mandatory Comments
EXPENDITURE_TYPE VARCHAR2 (250)
RATE_CLASS_ID NUMBER

P1_AMT NUMBER

P2_AMT NUMBER

P3_AMT NUMBER

P4_AMT NUMBER

[top of page]

APPS.IGW_BUDGET_MATRIX_V references the following:

APPS
SYNONYM - IGW_BUDGET_DETAILS
PACKAGE - IGW_BUDGET_OPERATIONS
VIEW - IGW_DETAIL_AMTS_SUM_V
VIEW - IGW_EXPENDITURE_TYPE_SUM_V
VIEW - IGW_OH_TEMP_V

APPS.IGW_BUDGET_MATRIX_V is not referenced by any database object

[top of page]

View: IGW_BUDGET_PERIODS_V

Comments
Columns
Name Datatype Length Mandatory Comments
PROPOSAL_ID NUMBER (15) Y
VERSION_ID NUMBER (4) Y
BUDGET_PERIOD_ID NUMBER (4) Y
START_DATE DATE
Y
END_DATE DATE
Y
TOTAL_COST NUMBER (15)
TOTAL_DIRECT_COST NUMBER (15)
TOTAL_INDIRECT_COST NUMBER (15)
COST_SHARING_AMOUNT NUMBER (15)
UNDERRECOVERY_AMOUNT NUMBER (15)
TOTAL_COST_LIMIT NUMBER (15)
PROGRAM_INCOME NUMBER (15)
PROGRAM_INCOME_SOURCE VARCHAR2 (50)
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15) Y

[top of page]

APPS.IGW_BUDGET_PERIODS_V references the following:

APPS
SYNONYM - IGW_BUDGET_PERIODS

APPS.IGW_BUDGET_PERIODS_V is not referenced by any database object

[top of page]

View: IGW_BUDGET_PERSONNEL_AMTS_V

Comments
Columns
Name Datatype Length Mandatory Comments
BUDGET_PERSONNEL_DETAIL_ID NUMBER (15) Y
RATE_CLASS_ID NUMBER (10) Y
RATE_TYPE_ID NUMBER (10) Y
APPLY_RATE_FLAG VARCHAR2 (1)
CALCULATED_COST NUMBER (15)
CALCULATED_COST_SHARING NUMBER (15)
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15) Y

[top of page]

APPS.IGW_BUDGET_PERSONNEL_AMTS_V references the following:

APPS
SYNONYM - IGW_BUDGET_PERSONNEL_CAL_AMTS

APPS.IGW_BUDGET_PERSONNEL_AMTS_V is not referenced by any database object

[top of page]

View: IGW_BUDGET_PERSONNEL_V

Comments
Columns
Name Datatype Length Mandatory Comments
BUDGET_PERSONNEL_DETAIL_ID NUMBER (15) Y
PROPOSAL_ID NUMBER (15) Y
VERSION_ID NUMBER (4) Y
BUDGET_PERIOD_ID NUMBER (4) Y
LINE_ITEM_ID NUMBER (15) Y
PERSON_ID NUMBER (15)
START_DATE DATE
Y
END_DATE DATE
Y
PERIOD_TYPE_CODE VARCHAR2 (30) Y
APPOINTMENT_TYPE_CODE VARCHAR2 (30) Y
SALARY_REQUESTED NUMBER (15)
PERCENT_CHARGED NUMBER (5)
PERCENT_EFFORT NUMBER (5)
COST_SHARING_PERCENT NUMBER (5)
COST_SHARING_AMOUNT NUMBER (15)
UNDERRECOVERY_AMOUNT NUMBER (15)
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15) Y

[top of page]

APPS.IGW_BUDGET_PERSONNEL_V references the following:

APPS
SYNONYM - IGW_BUDGET_PERSONNEL_DETAILS

APPS.IGW_BUDGET_PERSONNEL_V is not referenced by any database object

[top of page]

View: IGW_BUDGET_PERSONS_V

Comments
Columns
Name Datatype Length Mandatory Comments
PROPOSAL_ID NUMBER (15) Y
VERSION_ID NUMBER (4) Y
PERSON_ID NUMBER (15)
APPOINTMENT_TYPE_CODE VARCHAR2 (30) Y
EFFECTIVE_DATE DATE
Y
CALCULATION_BASE NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15) Y

[top of page]

APPS.IGW_BUDGET_PERSONS_V references the following:

APPS
SYNONYM - IGW_BUDGET_PERSONS

APPS.IGW_BUDGET_PERSONS_V is not referenced by any database object

[top of page]

View: IGW_BUSINESS_RULES

Comments
View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.

IGW_BUSINESS_RULES is a view which shows information about the business rules pertaining to all organizations belonging to the particular operating unit.

Columns
Name Datatype Length Mandatory Comments
RULE_ID NUMBER (10) Y Rule identifier
RULE_SEQUENCE_NUMBER NUMBER (4)
Rule sequence number
ORGANIZATION_ID NUMBER (15) Y Organization identifier
ORG_ID NUMBER (15)
Operating unit identifier for multiple organizations.
RULE_NAME VARCHAR2 (50) Y Rule name
RULE_TYPE VARCHAR2 (1) Y Rule type. Possible values are R (Routing), V (Validation) and N (Notification).
MAP_ID NUMBER (10)
Routing / Notification map identifier
VALID_FLAG VARCHAR2 (1)
Flag that determines whether satisfying the rule makes the proposal V (Valid) or I (Invalid)
START_DATE_ACTIVE DATE
Y First effective date of rule
END_DATE_ACTIVE DATE

Last effective date of rule
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column

[top of page]

APPS.IGW_BUSINESS_RULES references the following:

APPS
SYNONYM - IGW_BUSINESS_RULES_ALL
APPS.IGW_BUSINESS_RULES is referenced by following:

APPS
VIEW - IGW_BUSINESS_RULES_V

[top of page]

View: IGW_BUSINESS_RULES_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
ORGANIZATION VARCHAR2 (240) Y
RULE_ID NUMBER (10) Y
RULE_SEQUENCE_NUMBER NUMBER (4)
ORGANIZATION_ID NUMBER (15) Y
ORG_ID NUMBER (15)
RULE_NAME VARCHAR2 (50) Y
RULE_TYPE VARCHAR2 (1) Y
MAP_ID NUMBER (10)
VALID_FLAG VARCHAR2 (1)
START_DATE_ACTIVE DATE
Y
END_DATE_ACTIVE DATE

LAST_UPDATE_DATE DATE
Y
CREATION_DATE DATE
Y
MAP VARCHAR2 (30)
LAST_UPDATED_BY NUMBER (15) Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15) Y

[top of page]

APPS.IGW_BUSINESS_RULES_V references the following:

APPS
SYNONYM - HR_ALL_ORGANIZATION_UNITS
VIEW - IGW_BUSINESS_RULES
SYNONYM - IGW_ORG_MAPS_ALL

APPS.IGW_BUSINESS_RULES_V is not referenced by any database object

[top of page]

View: IGW_DETAIL_AMTS_SUM_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
EXPENDITURE_TYPE VARCHAR2 (250)
P1_AMT NUMBER

P2_AMT NUMBER

P3_AMT NUMBER

P4_AMT NUMBER

RATE_CLASS_ID NUMBER (10)

[top of page]

APPS.IGW_DETAIL_AMTS_SUM_V references the following:

APPS
PACKAGE - IGW_BUDGET_OPERATIONS
VIEW - IGW_OH_TEMP_V
APPS.IGW_DETAIL_AMTS_SUM_V is referenced by following:

APPS
VIEW - IGW_BUDGET_MATRIX_V

[top of page]

View: IGW_EXPENDITURE_CATEGORIES_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
EXPENDITURE_CATEGORY VARCHAR2 (30) Y
DESCRIPTION VARCHAR2 (4000)
BUDGET_CATEGORY_CODE VARCHAR2 (30) Y
PERSONNEL_ATTACHED_FLAG VARCHAR2 (1) Y
START_DATE_ACTIVE DATE

END_DATE_ACTIVE DATE

LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15) Y

[top of page]

APPS.IGW_EXPENDITURE_CATEGORIES_V references the following:

APPS
SYNONYM - IGW_EXPENDITURE_CATEGORIES
PACKAGE - IGW_EXP_CATEGORIES_V_PKG
PACKAGE - IGW_SECURITY
APPS.IGW_EXPENDITURE_CATEGORIES_V is referenced by following:

APPS
VIEW - IGW_BUDGET_EXPENDITURES_V
PACKAGE BODY - IGW_GENERATE_PERIODS

[top of page]

View: IGW_EXPENDITURE_TYPES_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
EXPENDITURE_CATEGORY VARCHAR2 (30)
EXPENDITURE_TYPE VARCHAR2 (30)
DESCRIPTION VARCHAR2 (250)
START_DATE_ACTIVE DATE

END_DATE_ACTIVE DATE

LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
CREATION_DATE DATE

CREATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)

[top of page]

APPS.IGW_EXPENDITURE_TYPES_V references the following:

APPS
SYNONYM - IGW_EXPENDITURE_CATEGORIES
SYNONYM - IGW_EXPENDITURE_TYPES
PACKAGE - IGW_SECURITY
SYNONYM - PA_EXPENDITURE_TYPES
APPS.IGW_EXPENDITURE_TYPES_V is referenced by following:

APPS
VIEW - IGW_BUDGET_EXPENDITURES_V
PACKAGE BODY - IGW_BUDGET_OPERATIONS
PACKAGE BODY - IGW_GENERATE_PERIODS

[top of page]

View: IGW_EXPENDITURE_TYPE_SUM_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
EXPENDITURE_TYPE VARCHAR2 (30)
P1_AMT NUMBER

P2_AMT NUMBER

P3_AMT NUMBER

P4_AMT NUMBER

RATE_CLASS_ID NUMBER

[top of page]

APPS.IGW_EXPENDITURE_TYPE_SUM_V references the following:

APPS
SYNONYM - IGW_BUDGET_DETAILS
PACKAGE - IGW_BUDGET_OPERATIONS
APPS.IGW_EXPENDITURE_TYPE_SUM_V is referenced by following:

APPS
VIEW - IGW_BUDGET_MATRIX_V

[top of page]

View: IGW_IDC_SCHEDULE_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
IND_RATE_SCH_NAME VARCHAR2 (30) Y
IND_RATE_SCH_ID NUMBER (15) Y

[top of page]

APPS.IGW_IDC_SCHEDULE_V references the following:

APPS
PACKAGE - FND_PROFILE
VIEW - PA_IND_RATE_SCHEDULES
PACKAGE - PA_UTILS

APPS.IGW_IDC_SCHEDULE_V is not referenced by any database object

[top of page]

View: IGW_IMPLEMENTATIONS

Comments
View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_NUMBERING_METHOD VARCHAR2 (1)
MANUAL_PROPOSAL_NUMB_METHOD VARCHAR2 (1)
NEXT_AUTOMATIC_PROPOSAL_NUMBER NUMBER (15)
OH_EXPENDITURE_FLAG VARCHAR2 (1)
OH_EXPENDITURE_CATEGORY_TYPE VARCHAR2 (30)
UNM_EXPENDITURE_FLAG VARCHAR2 (1)
UNM_EXPENDITURE_CATEGORY_TYPE VARCHAR2 (30)
PRP_ORG_STRUCTURE_ID NUMBER (15)
PRP_ORG_STRUCTURE_VERSION_ID NUMBER (15)
PRP_ORG_STRUCTURE_START_ID NUMBER (15)
APR_ORG_STRUCTURE_ID NUMBER (15) Y
APR_ORG_STRUCTURE_VERSION_ID NUMBER (15) Y
APR_ORG_STRUCTURE_START_ID NUMBER (15) Y
BUSINESS_GROUP_ID NUMBER (15) Y
ORG_ID NUMBER (15)
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15) Y

[top of page]

APPS.IGW_IMPLEMENTATIONS references the following:

APPS
SYNONYM - IGW_IMPLEMENTATIONS_ALL
APPS.IGW_IMPLEMENTATIONS is referenced by following:

APPS
VIEW - IGW_APR_ORGANIZATIONS_V
VIEW - IGW_PERSONS_V
PACKAGE BODY - IGW_PROP
PACKAGE BODY - IGW_PROPOSAL_APPROVAL
PACKAGE BODY - IGW_PROP_APPROVALS_PVT
VIEW - IGW_PRP_ORGANIZATIONS_V
PACKAGE BODY - IGW_UTILS

[top of page]

View: IGW_INSTITUTE_RATES_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
RATE_CLASS_ID NUMBER (10) Y
RATE_TYPE_ID NUMBER (10) Y
ACTIVITY_TYPE_CODE VARCHAR2 (30) Y
ACTIVITY_TYPE VARCHAR2 (80) Y
FISCAL_YEAR NUMBER (4) Y
LOCATION_CODE VARCHAR2 (30) Y
LOCATION VARCHAR2 (80) Y
START_DATE DATE
Y
RATE NUMBER (5) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15) Y

[top of page]

APPS.IGW_INSTITUTE_RATES_V references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS
SYNONYM - IGW_INSTITUTE_RATES

APPS.IGW_INSTITUTE_RATES_V is not referenced by any database object

[top of page]

View: IGW_LABOR_FORMAT_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
NAME VARCHAR2 (30) Y
INVOICE_FORMAT_ID NUMBER (15) Y

[top of page]

APPS.IGW_LABOR_FORMAT_V references the following:

APPS
SYNONYM - PA_INVOICE_FORMATS
SYNONYM - PA_INVOICE_GROUPS

APPS.IGW_LABOR_FORMAT_V is not referenced by any database object

[top of page]

View: IGW_LOOKUPS_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
LOOKUP_TYPE VARCHAR2 (30) Y
LOOKUP_CODE VARCHAR2 (30) Y
MEANING VARCHAR2 (80) Y
DESCRIPTION VARCHAR2 (240)

[top of page]

APPS.IGW_LOOKUPS_V references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS
APPS.IGW_LOOKUPS_V is referenced by following:

APPS
VIEW - IGWBV_GRANT_PROPOSAL
VIEW - IGWBV_GRANT_PROPOSAL_BDGT_LINE
VIEW - IGWBV_GRANT_PROPOSAL_OVRD_RATE
VIEW - IGWBV_GRANT_PROPOSAL_PERS_ASGN
VIEW - IGWBV_GRANT_PROPOSAL_RATE
VIEW - IGWBV_GRANT_PRPSL_EXP_CATEGORY
VIEW - IGWBV_GRANT_PRPSL_SUPPRT_TEXT
VIEW - IGWBV_GRNT_PRPSL_BDGT_LIN_PERS
VIEW - IGWBV_GRNT_PRPSL_PERS_BIOSKTCH
VIEW - IGWBV_GRNT_PRPSL_PERS_DEGREE
VIEW - IGWBV_GRNT_PRPSL_SPCL_RVW
VIEW - IGWFV_GRANT_PROPOSAL
VIEW - IGWFV_GRANT_PROPOSAL_BDGT_LINE
VIEW - IGWFV_GRANT_PROPOSAL_OVRD_RATE
VIEW - IGWFV_GRANT_PROPOSAL_PERS_ASGN
VIEW - IGWFV_GRANT_PROPOSAL_RATE
VIEW - IGWFV_GRANT_PRPSL_EXP_CATEGORY
VIEW - IGWFV_GRANT_PRPSL_SUPPRT_TEXT
VIEW - IGWFV_GRNT_PRPSL_BDGT_LIN_PERS
VIEW - IGWFV_GRNT_PRPSL_PERS_BIOSKTCH
VIEW - IGWFV_GRNT_PRPSL_PERS_DEGREE
VIEW - IGWFV_GRNT_PRPSL_PERS_DEG_ASGN
VIEW - IGWFV_GRNT_PRPSL_PERS_PRF_ASGN
VIEW - IGWFV_GRNT_PRPSL_SPCL_RVW
VIEW - IGW_BUDGETS_V
VIEW - IGW_BUDGET_CATEGORY_V
VIEW - IGW_BUDGET_LINE_CATEGORY_V
VIEW - IGW_PRPO_ABSTRACTS_V
VIEW - IGW_PRPO_BIOSKETCH_V
VIEW - IGW_PRPO_HEADERS_V
VIEW - IGW_PRPO_ORG_TYPES_V
VIEW - IGW_PRPO_OTHER_SUPPORT_V
VIEW - IGW_PRPO_SPECIAL_REVIEWS_V
VIEW - IGW_REPORT_BUDGET_SEED_V
PACKAGE BODY - IGW_REPORT_PROCESSING

[top of page]

View: IGW_NON_LABOR_FORMAT_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
NAME VARCHAR2 (30) Y
INVOICE_FORMAT_ID NUMBER (15) Y

[top of page]

APPS.IGW_NON_LABOR_FORMAT_V references the following:

APPS
SYNONYM - PA_INVOICE_FORMATS
SYNONYM - PA_INVOICE_GROUPS

APPS.IGW_NON_LABOR_FORMAT_V is not referenced by any database object

[top of page]

View: IGW_OH_EXPENDITURE_CAT_TYPES_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
EXPENDITURE_CATEGORY_TYPE VARCHAR2 (30)
DESCRIPTION VARCHAR2 (250)
EXPENDITURE_CATEGORY VARCHAR2 (30)
EXPENDITURE_CAT_TYPE_FLAG CHAR (1)

[top of page]

APPS.IGW_OH_EXPENDITURE_CAT_TYPES_V references the following:

APPS
SYNONYM - PA_EXPENDITURE_CATEGORIES
SYNONYM - PA_EXPENDITURE_TYPES

APPS.IGW_OH_EXPENDITURE_CAT_TYPES_V is not referenced by any database object

[top of page]

View: IGW_OH_TEMP_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_ID NUMBER (15) Y
VERSION_ID NUMBER (4) Y
BUDGET_PERIOD_ID NUMBER (4) Y
CALCULATED_COST NUMBER

RATE_CLASS_ID NUMBER (10) Y
DESCRIPTION VARCHAR2 (250) Y

[top of page]

APPS.IGW_OH_TEMP_V references the following:

APPS
SYNONYM - IGW_BUDGET_DETAILS_CAL_AMTS
SYNONYM - IGW_RATE_CLASSES
SYNONYM - IGW_RATE_TYPES
APPS.IGW_OH_TEMP_V is referenced by following:

APPS
VIEW - IGW_BUDGET_MATRIX_V
VIEW - IGW_DETAIL_AMTS_SUM_V

[top of page]

View: IGW_ORGANIZATION_TYPES_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

IGW_ORGANIZATION_TYPES_V displays the applicant organization's type. This view has eight columns for eight types of organizations. The eight types of organizations are General, Small Business, Minority-owned business, Women-owned business, Federal, State, Local, and Nonprofit. A value of X for a field means True and NULL means False.

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_ID NUMBER (15) Y Proposal identifier
PROPOSAL_NUMBER VARCHAR2 (30) Y Proposal number
ORGANIZATION_ID NUMBER (15)
Organization identifier
GENERAL VARCHAR2 (4000)
General business
SMALL_BUSINESS VARCHAR2 (4000)
Small business
MINORITY_BUSINESS VARCHAR2 (4000)
Minority-owned business
WOMEN_BUSINESS VARCHAR2 (4000)
Women-owned business
DISADVANTAGED VARCHAR2 (4000)
Small Disadvantaged
FEDERAL VARCHAR2 (4000)
Federal organization
STATE VARCHAR2 (4000)
State organization
LOCAL VARCHAR2 (4000)
Local organization
NON_PROFIT VARCHAR2 (4000)
Nonprofit organization

[top of page]

APPS.IGW_ORGANIZATION_TYPES_V references the following:

APPS
SYNONYM - IGW_PROPOSALS_ALL
PACKAGE - IGW_REPORT_PROCESSING

APPS.IGW_ORGANIZATION_TYPES_V is not referenced by any database object

[top of page]

View: IGW_ORG_MAPS_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
MAP_ID NUMBER (10) Y
ORGANIZATION_ID NUMBER (15) Y
ORGANIZATION_NAME VARCHAR2 (240) Y
MAP_NAME VARCHAR2 (30) Y
ORG_ID NUMBER (15)
START_DATE_ACTIVE DATE
Y
END_DATE_ACTIVE DATE

LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15) Y

[top of page]

APPS.IGW_ORG_MAPS_V references the following:

APPS
PACKAGE - HR_GENERAL
VIEW - HR_ORGANIZATION_UNITS
PACKAGE - HR_SECURITY
SYNONYM - IGW_ORG_MAPS_ALL

APPS.IGW_ORG_MAPS_V is not referenced by any database object

[top of page]

View: IGW_ORG_MAP_DETAILS_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
MAP_ID NUMBER (10) Y
STOP_ID NUMBER (4) Y
PERSON_NAME VARCHAR2 (240)
USER_NAME VARCHAR2 (100) Y
APPROVER_TYPE VARCHAR2 (1)
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15) Y

[top of page]

APPS.IGW_ORG_MAP_DETAILS_V references the following:

APPS
SYNONYM - FND_USER
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
SYNONYM - IGW_ORG_MAP_DETAILS
VIEW - PER_PEOPLE_X

APPS.IGW_ORG_MAP_DETAILS_V is not referenced by any database object

[top of page]

View: IGW_ORG_QUESTIONS_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
ORGANIZATION_ID NUMBER (15) Y
QUESTION_NUMBER VARCHAR2 (5) Y
DESCRIPTION VARCHAR2 (500) Y
EXPLANATION_FOR_YES_FLAG VARCHAR2 (1) Y
EXPLANATION_FOR_NO_FLAG VARCHAR2 (1) Y
DATE_FOR_YES_FLAG VARCHAR2 (1) Y
DATE_FOR_NO_FLAG VARCHAR2 (1) Y
ANSWER VARCHAR2 (1)
EXPLANATION VARCHAR2 (800)
REVIEW_DATE DATE

LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15) Y

[top of page]

APPS.IGW_ORG_QUESTIONS_V references the following:

APPS
SYNONYM - IGW_ORG_QUESTIONS
SYNONYM - IGW_QUESTIONS
SYNONYM - IGW_QUESTIONS_TL

APPS.IGW_ORG_QUESTIONS_V is not referenced by any database object

[top of page]

View: IGW_PERSONS_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
PERSON_ID NUMBER (10) Y
FULL_NAME VARCHAR2 (240)
EMPLOYEE_NUMBER VARCHAR2 (30)
LAST_NAME VARCHAR2 (150) Y
FIRST_NAME VARCHAR2 (150)
MIDDLE_NAMES VARCHAR2 (60)
EFFECTIVE_START_DATE DATE
Y
EFFECTIVE_END_DATE DATE
Y
BUSINESS_GROUP_ID NUMBER (15) Y
ACTIVE VARCHAR2 (30)

[top of page]

APPS.IGW_PERSONS_V references the following:

APPS
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
VIEW - IGW_IMPLEMENTATIONS
VIEW - PER_PEOPLE_F

APPS.IGW_PERSONS_V is not referenced by any database object

[top of page]

View: IGW_PI_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

IGW_PI_V displays details of the Proposal Manager. Details include name, address, gender, degrees, date of birth, social security number, and job name.

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_ID NUMBER (15) Y Proposal identifier
PROPOSAL_NUMBER VARCHAR2 (30) Y Proposal number
ORGANIZATION_ID NUMBER (15)
Organization identifier
PROPOSAL_TYPE_CODE VARCHAR2 (30) Y Proposal type code
ORIGINAL_PROPOSAL_NUMBER VARCHAR2 (30)
Original proposal number
AWARD_NUMBER VARCHAR2 (15)
Award number
PERSON_ID NUMBER (10) Y Person identifier
FULL_NAME VARCHAR2 (240)
Full name
LAST_NAME VARCHAR2 (150) Y Last name
FIRST_NAME VARCHAR2 (150)
First name
MIDDLE_NAMES VARCHAR2 (60)
Middle name
TITLE VARCHAR2 (30)
Title, such as Mr., Mrs., or Dr.
SUFFIX VARCHAR2 (30)
Suffix after the last name, such as Sr., or Jr.
LAST_FIRST_MIDDLE_NAME VARCHAR2 (363)
Last name, first name, and middle name of the Adminstrative Offical. Names are separated with commas.
FIRST_MIDDLE_LAST_NAME VARCHAR2 (393)
First name, middle name, and last name. Names are separated with commas.
DATE_OF_BIRTH DATE

Date of birth
NATIONAL_IDENTIFIER VARCHAR2 (30)
Social security number
SEX VARCHAR2 (30)
Gender
ETHNIC_GROUP VARCHAR2 (80)
Ethnic group
JOB_NAME VARCHAR2 (4000)
Job name
DEGREES VARCHAR2 (4000)
Degrees. Only the first three degrees are displayed.
ADDRESS_LINE1 VARCHAR2 (240)
First address line
ADDRESS_LINE2 VARCHAR2 (240)
Second address line
ADDRESS_LINE3 VARCHAR2 (240)
Third address line
POSTAL_CODE VARCHAR2 (30)
Postal code
REGION_1 VARCHAR2 (120)
Primary region in which address is located
REGION_2 VARCHAR2 (120)
Subregion of Region 1 in which address is located
REGION_3 VARCHAR2 (120)
Subregion of Region 2 in which address is located
TOWN_OR_CITY VARCHAR2 (30)
Town or city
WORK_PHONE VARCHAR2 (4000)
Work phone
WORK_FAX VARCHAR2 (4000)
Work fax
EMAIL_ADDRESS VARCHAR2 (240)
E-mail address

[top of page]

APPS.IGW_PI_V references the following:

APPS
PACKAGE - FND_GLOBAL
PACKAGE - HR_API
PACKAGE - HR_GENERAL
VIEW - HR_LOCATIONS
VIEW - HR_LOOKUPS
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
SYNONYM - IGW_PROPOSALS_ALL
SYNONYM - IGW_PROP_PERSONS
PACKAGE - IGW_REPORT_PROCESSING
VIEW - PER_ASSIGNMENTS_X
VIEW - PER_PEOPLE_X

APPS.IGW_PI_V is not referenced by any database object

[top of page]

View: IGW_PRINTABLE_PROPOSALS_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_ID NUMBER (15) Y
PROPOSAL_NUMBER VARCHAR2 (30) Y

[top of page]

APPS.IGW_PRINTABLE_PROPOSALS_V references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - IGW_PROPOSALS
PACKAGE - IGW_SECURITY

APPS.IGW_PRINTABLE_PROPOSALS_V is not referenced by any database object

[top of page]

View: IGW_PROPOSALS

Comments
View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_ID NUMBER (15) Y
PROPOSAL_NUMBER VARCHAR2 (30) Y
LEAD_ORGANIZATION_ID NUMBER (15)
ORG_ID NUMBER (15)
PROPOSAL_STATUS VARCHAR2 (1)
PROPOSAL_START_DATE DATE
Y
PROPOSAL_END_DATE DATE
Y
PROPOSAL_TITLE VARCHAR2 (250)
PROPOSAL_TYPE_CODE VARCHAR2 (30) Y
ORIGINAL_PROPOSAL_NUMBER VARCHAR2 (30)
ORIGINAL_AWARD_NUMBER VARCHAR2 (15)
ORIGINAL_PROPOSAL_START_DATE DATE

ORIGINAL_PROPOSAL_END_DATE DATE

ACTIVITY_TYPE_CODE VARCHAR2 (30) Y
SPONSOR_ID NUMBER (15)
FUNDING_SPONSOR_UNIT VARCHAR2 (45)
SPONSOR_PROPOSAL_NUMBER VARCHAR2 (30)
NOTICE_OF_OPPORTUNITY_CODE VARCHAR2 (30)
PROGRAM_NUMBER VARCHAR2 (30)
PROGRAM_TITLE VARCHAR2 (250)
PROGRAM_URL VARCHAR2 (240)
SUBMITTING_ORGANIZATION_ID NUMBER (15)
DEADLINE_DATE DATE

DEADLINE_TYPE VARCHAR2 (1)
EDI_GENERATED_DATE DATE

SPONSOR_ACTION_CODE VARCHAR2 (30)
SPONSOR_ACTION_DATE DATE

AWARD_NUMBER VARCHAR2 (15)
AWARD_AMOUNT NUMBER (15)
NARRATIVE_TYPE_CODE VARCHAR2 (30)
NARRATIVE_SUBMISSION_CODE VARCHAR2 (30)
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15) Y
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)

[top of page]

APPS.IGW_PROPOSALS references the following:

APPS
SYNONYM - IGW_PROPOSALS_ALL
APPS.IGW_PROPOSALS is referenced by following:

APPS
PACKAGE BODY - IGW_AWARD_PARTICULARS_PKG
PACKAGE BODY - IGW_EDI_PROCESSING
VIEW - IGW_PRINTABLE_PROPOSALS_V
VIEW - IGW_PROP_V
VIEW - IGW_PRPO_HEADERS_V
VIEW - IGW_PRPO_ORG_TYPES_V
VIEW - IGW_PRPO_YN_RESPONSES_V
VIEW - IGW_TRANSFERABLE_BUDGETS_V
PACKAGE BODY - IGW_VIEW_PARAMETERS

[top of page]

View: IGW_PROPOSALS_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_ID NUMBER (15) Y Proposal identifier
PROPOSAL_NUMBER VARCHAR2 (30) Y Proposal number that uniquely identifies the proposal. Proposal number can be user-entered or system-generated as defined in the implementation options.
PROPOSAL_SHORT_TITLE VARCHAR2 (150)
Short Title of Proposal
PROPOSAL_TITLE VARCHAR2 (250)
Detailed title of the proposal
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_STATUS_DESC VARCHAR2 (80) Y Proposal Status Description
SPONSOR_ID NUMBER (15)
Grantor Identifier
SPONSOR_NAME VARCHAR2 (360)
Grantor Name in Internal Grantee mode
SUBMITTING_PARTY_ID NUMBER (15)
Submitting Party Identifier
APPLICANT VARCHAR2 (360)
Name of Applicant organization
PROPOSAL_MANAGER_ID NUMBER (15)
Proposal Manager Identifier
PROPOSAL_MANAGER_NAME VARCHAR2 (360) Y Proposal Manager Name
PROGRAM_NUMBER VARCHAR2 (30)
Program Number
PROGRAM_TITLE VARCHAR2 (250)
Program Title
PROGRAM_MANAGER_ID NUMBER (15)
Program Manager Identifier
PROGRAM_MANAGER_NAME VARCHAR2 (360)
Program Manager Name
TOTAL_DIRECT_COST NUMBER (15)
Total Direct Cost
TOTAL_COST NUMBER (15)
Total Cost
PROPOSAL_START_DATE DATE
Y Proposal Start Date
PROPOSAL_END_DATE DATE
Y Proposal End Date
SPONSOR_APPLICATION_NUMBER VARCHAR2 (50)
Sponsor Application Number
AWARD_NUMBER VARCHAR2 (15)
Award Number
CREATION_DATE DATE
Y Proposal Creation Date
DETAIL_VIEW CHAR (1)
Detail View Flag
SELECT_FLAG CHAR (1)
Select Flag
SUBMIT_SWITCHER CHAR (14)
Submit Switcher
RECORD_VERSION_NUMBER NUMBER
Y Record Version Number
UPPER_PROPOSAL_NUMBER VARCHAR2 (30)
Uppercase value of Proposal Number
UPPER_PROPOSAL_SHORT_TITLE VARCHAR2 (150)
Uppercase value of Proposal Short Title
UPPER_PROPOSAL_TITLE VARCHAR2 (250)
Uppercase value of Proposal Title
PROPOSAL_TYPE_CODE VARCHAR2 (30) Y Proposal Type Code
ACTIVITY_TYPE_CODE VARCHAR2 (30) Y Activity Type Code
SPONSOR_ACTION_CODE VARCHAR2 (30)
Sponsor Action Code
DEADLINE_DATE DATE

Deadline Date
FUNDING_SPONSOR_UNIT VARCHAR2 (45)
Funding Sponsor Unit
APPLICANT_UNIT_NAME VARCHAR2 (300)
Applicant Unit Name
LAST_UPDATE_DATE DATE
Y Standard Who column
DELETE_SWITCHER CHAR (14)
Delete Switcher
CURRENCY_CODE VARCHAR2 (4000)
Currency Code
PROP_OAHP VARCHAR2 (28)
Application Menu Name
SIGNING_OFFICIAL_PARTY_ID NUMBER (15)
Party Identifier for Signing Official
ADMIN_OFFICIAL_PARTY_ID NUMBER (15)
Party identifier for Administrative Official
TOTAL_INDIRECT_COST NUMBER (15)
Total Indirect Cost
GRANTOR VARCHAR2 (360)
Grantor Name in External Grantee mode
LEAD_ORGANIZATION_ID NUMBER (15)
Applicant Unit Identifier
ALLOW_QUERY CHAR (1)
Flag to identify if query is allowed on this proposal for given user
IGW_MODE VARCHAR2 (30)
Installation Mode value for proposal
PROFILE_IGW_MODE VARCHAR2 (10)
Installation Mode value from profile

[top of page]

APPS.IGW_PROPOSALS_V references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS
PACKAGE - FND_PROFILE
SYNONYM - HZ_PARTIES
SYNONYM - IGW_BUDGETS
SYNONYM - IGW_PROPOSALS_ALL
SYNONYM - IGW_PROP_GRANTORS

APPS.IGW_PROPOSALS_V is not referenced by any database object

[top of page]

View: IGW_PROPOSAL_PERSONS_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

IGW_PROPOSAL_PERSONS_V displays details of the personnel involved on the proposal.

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_ID NUMBER (15)
Proposal identifier
PROPOSAL_NUMBER VARCHAR2 (30)
Proposal number
PERSON_ID VARCHAR2 (60)
Person identifier
PERSON_PARTY_ID NUMBER (15)
Person party identifier
PROPOSAL_ROLE_CODE VARCHAR2 (30)
Role of person on proposal
FIRST_NAME VARCHAR2 (150)
Person's first name
MIDDLE_NAMES VARCHAR2 (60)
Person's middle names
LAST_NAME VARCHAR2 (150)
Person's last name
FULL_NAME VARCHAR2 (450)
Person's full name
TITLE VARCHAR2 (30)
Person's title
SUFFIX VARCHAR2 (30)
Suffix used by the person
LAST_FIRST_MIDDLE_NAME VARCHAR2 (364)
Person's name in last, first, and middle format
FIRST_MIDDLE_LAST_NAME VARCHAR2 (393)
Person's name in first, middle, and last format
ORGANIZATION_NAME CHAR (14)
Applicant organization
ROLE_NAME VARCHAR2 (13)
Role of person on the proposal
DEGREES VARCHAR2 (14)
Degrees earned by the person
JOB_NAME VARCHAR2 (9)
Person's job title
BIRTH_DATE DATE

Person's date of birth
SSN VARCHAR2 (30)
Person's social security number
PI_FLAG VARCHAR2 (1)
Proposal Manager indicator. Possible values are Y or N.
KEY_PERSON_FLAG VARCHAR2 (1)
Flag indicates whether the person has a key responsibility in the proposal. Possible values are Y or N.
PERCENT_EFFORT NUMBER

Percentage of time that person devotes to the proposal
SEX VARCHAR2 (30)
Sex
EMAIL_ADDRESS VARCHAR2 (2000)
Email Address
WORK_PHONE VARCHAR2 (50)
Work Phone
WORK_FAX CHAR (4)
Work Fax Number
ADDRESS_LINE_1 VARCHAR2 (240)
First Address Line
ADDRESS_LINE_2 VARCHAR2 (240)
Second Address Line
ADDRESS_LINE_3 VARCHAR2 (240)
Third Address Line
TOWN_OR_CITY VARCHAR2 (60)
Town or City
STATE VARCHAR2 (120)
State
POSTAL_CODE VARCHAR2 (60)
Postal Code

[top of page]

APPS.IGW_PROPOSAL_PERSONS_V references the following:

APPS
PACKAGE - HR_GENERAL
VIEW - HR_LOCATIONS
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
SYNONYM - HZ_PARTIES
SYNONYM - HZ_PERSON_PROFILES
SYNONYM - IGW_PROPOSALS_ALL
SYNONYM - IGW_PROP_PERSONS
VIEW - PER_ASSIGNMENTS_X
VIEW - PER_PEOPLE_X

APPS.IGW_PROPOSAL_PERSONS_V is not referenced by any database object

[top of page]

View: IGW_PROP_COMMENTS_V

Comments
Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
PROPOSAL_ID NUMBER (15) Y
PROPOSAL_NUMBER VARCHAR2 (30) Y
PROPOSAL_TITLE VARCHAR2 (250)
COMMENT_ID NUMBER (10) Y
COMMENTS VARCHAR2 (4000)
FULL_NAME VARCHAR2 (240)
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15) Y
USER_NAME VARCHAR2 (100) Y

[top of page]

APPS.IGW_PROP_COMMENTS_V references the following:

APPS
SYNONYM - FND_USER
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
SYNONYM - IGW_PROPOSALS_ALL
SYNONYM - IGW_PROP_COMMENTS
VIEW - PER_PEOPLE_X

APPS.IGW_PROP_COMMENTS_V is not referenced by any database object

[top of page]

View: IGW_PROP_LOCATIONS_V

Comments
Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
PROPOSAL_ID NUMBER (15) Y
PERFORMING_ORGANIZATION_ID NUMBER (15)
PERFORMING_ORG_NAME VARCHAR2 (240) Y
PERFORMING_ORG_ADDRESS VARCHAR2 (905)
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15) Y

[top of page]

APPS.IGW_PROP_LOCATIONS_V references the following:

APPS
PACKAGE - HR_GENERAL
VIEW - HR_LOCATIONS
VIEW - HR_ORGANIZATION_UNITS
PACKAGE - HR_SECURITY
SYNONYM - IGW_PROP_LOCATIONS

APPS.IGW_PROP_LOCATIONS_V is not referenced by any database object

[top of page]

View: IGW_PROP_PERSONS_TCA_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_PERSON_PARTY_ID VARCHAR2 (80)
PROPOSAL_ID NUMBER (15) Y
PERSON_ID NUMBER (15)
PERSON_PARTY_ID NUMBER (15) Y
ORG_PARTY_ID NUMBER (15)

[top of page]

APPS.IGW_PROP_PERSONS_TCA_V references the following:

APPS
SYNONYM - IGW_PROP_PERSONS
APPS.IGW_PROP_PERSONS_TCA_V is referenced by following:

APPS
PACKAGE BODY - HZ_PURGE_GEN
PACKAGE BODY - IGW_PARTY_MERGE_PUB

[top of page]

View: IGW_PROP_PERSONS_V

Comments
Columns
Name Datatype Length Mandatory Comments
ROW_ID VARCHAR2 (18)
RECORD_VERSION_NUMBER NUMBER (15) Y
PROPOSAL_ID NUMBER (15) Y
PERSON_ID NUMBER (15)
FULL_NAME VARCHAR2 (240)
PERSON_SEQUENCE NUMBER (3)
PROPOSAL_ROLE_CODE VARCHAR2 (30) Y
PROPOSAL_ROLE_DESC VARCHAR2 (80) Y
PI_FLAG VARCHAR2 (1)
KEY_PERSON_FLAG VARCHAR2 (1)
PERCENT_EFFORT NUMBER (5)
PERSON_ORGANIZATION_ID NUMBER (15)
PERSON_UNIT_NAME VARCHAR2 (240)
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15) Y

[top of page]

APPS.IGW_PROP_PERSONS_V references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS
PACKAGE - HR_GENERAL
VIEW - HR_ORGANIZATION_UNITS
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
SYNONYM - IGW_PROP_PERSONS
VIEW - PER_PEOPLE_X

APPS.IGW_PROP_PERSONS_V is not referenced by any database object

[top of page]

View: IGW_PROP_PERSON_BIOSKETCH_V

Comments
Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
PROPOSAL_ID NUMBER (15) Y
PERSON_BIOSKETCH_ID NUMBER (10) Y
SHOW_FLAG VARCHAR2 (1) Y
PROP_LINE_SEQUENCE NUMBER (4) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15) Y
PERSON_ID NUMBER (15)
BIOSKETCH_TYPE VARCHAR2 (30) Y
PERSON_LINE_SEQUENCE NUMBER (4) Y
LINE_DESCRIPTION VARCHAR2 (500) Y
ENABLE_FLAG VARCHAR2 (1) Y

[top of page]

APPS.IGW_PROP_PERSON_BIOSKETCH_V references the following:

APPS
SYNONYM - IGW_PERSON_BIOSKETCH
SYNONYM - IGW_PROP_PERSON_BIOSKETCH

APPS.IGW_PROP_PERSON_BIOSKETCH_V is not referenced by any database object

[top of page]

View: IGW_PROP_PERSON_DEGREES_V

Comments
Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
PROPOSAL_ID NUMBER (15) Y
PERSON_DEGREE_ID NUMBER (10) Y
SHOW_FLAG VARCHAR2 (1) Y
PROP_DEGREE_SEQUENCE NUMBER (2) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15) Y
PERSON_ID NUMBER (15)
DEGREE_TYPE_CODE VARCHAR2 (30) Y
GRADUATION_DATE DATE
Y
DEGREE VARCHAR2 (80) Y
PERSON_DEGREE_SEQUENCE NUMBER (3) Y
FIELD_OF_STUDY VARCHAR2 (80)
SPECIALIZATION VARCHAR2 (80)
SCHOOL_NAME VARCHAR2 (100)

[top of page]

APPS.IGW_PROP_PERSON_DEGREES_V references the following:

APPS
SYNONYM - IGW_PERSON_DEGREES
SYNONYM - IGW_PROP_PERSON_DEGREES

APPS.IGW_PROP_PERSON_DEGREES_V is not referenced by any database object

[top of page]

View: IGW_PROP_PERSON_QUESTIONS_V

Comments
Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
PROPOSAL_ID NUMBER (15) Y
PERSON_ID NUMBER (15)
QUESTION_NUMBER VARCHAR2 (5) Y
DESCRIPTION VARCHAR2 (500) Y
EXPLANATION_FOR_YES_FLAG VARCHAR2 (1) Y
EXPLANATION_FOR_NO_FLAG VARCHAR2 (1) Y
DATE_FOR_YES_FLAG VARCHAR2 (1) Y
DATE_FOR_NO_FLAG VARCHAR2 (1) Y
ANSWER VARCHAR2 (1)
EXPLANATION VARCHAR2 (800)
REVIEW_DATE DATE

LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15) Y

[top of page]

APPS.IGW_PROP_PERSON_QUESTIONS_V references the following:

APPS
SYNONYM - IGW_PROP_PERSON_QUESTIONS
SYNONYM - IGW_QUESTIONS
SYNONYM - IGW_QUESTIONS_TL

APPS.IGW_PROP_PERSON_QUESTIONS_V is not referenced by any database object

[top of page]

View: IGW_PROP_QUESTIONS_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
PROPOSAL_ID NUMBER (15) Y
QUESTION_NUMBER VARCHAR2 (5) Y
DESCRIPTION VARCHAR2 (500) Y
EXPLANATION_FOR_YES_FLAG VARCHAR2 (1) Y
EXPLANATION_FOR_NO_FLAG VARCHAR2 (1) Y
DATE_FOR_YES_FLAG VARCHAR2 (1) Y
DATE_FOR_NO_FLAG VARCHAR2 (1) Y
ANSWER VARCHAR2 (1)
EXPLANATION VARCHAR2 (800)
REVIEW_DATE DATE

LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15) Y

[top of page]

APPS.IGW_PROP_QUESTIONS_V references the following:

APPS
SYNONYM - IGW_PROP_QUESTIONS
SYNONYM - IGW_QUESTIONS
SYNONYM - IGW_QUESTIONS_TL

APPS.IGW_PROP_QUESTIONS_V is not referenced by any database object

[top of page]

View: IGW_PROP_RATES_V

Comments
Columns
Name Datatype Length Mandatory Comments
PROPOSAL_ID NUMBER (15) Y
VERSION_ID NUMBER (4) Y
RATE_CLASS_ID NUMBER (10) Y
RATE_TYPE_ID NUMBER (10) Y
FISCAL_YEAR VARCHAR2 (4) Y
LOCATION_CODE VARCHAR2 (30) Y
ACTIVITY_TYPE_CODE VARCHAR2 (30) Y
START_DATE DATE
Y
APPLICABLE_RATE NUMBER (5) Y
INSTITUTE_RATE NUMBER (5)
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15) Y

[top of page]

APPS.IGW_PROP_RATES_V references the following:

APPS
SYNONYM - IGW_PROP_RATES

APPS.IGW_PROP_RATES_V is not referenced by any database object

[top of page]

View: IGW_PROP_SCIENCE_CODES_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID VARCHAR2 (18)
RECORD_VERSION_NUMBER NUMBER (15) Y
PROPOSAL_ID NUMBER (15) Y
SCIENCE_CODE VARCHAR2 (15) Y
DESCRIPTION VARCHAR2 (250) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15) Y

[top of page]

APPS.IGW_PROP_SCIENCE_CODES_V references the following:

APPS
SYNONYM - IGW_PROP_SCIENCE_CODES
SYNONYM - IGW_SCIENCE_CODES

APPS.IGW_PROP_SCIENCE_CODES_V is not referenced by any database object

[top of page]

View: IGW_PROP_SPECIAL_REVIEWS_V

Comments
Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
PROPOSAL_ID NUMBER (15) Y
SPECIAL_REVIEW_CODE VARCHAR2 (30) Y
SPECIAL_REVIEW_DESC VARCHAR2 (80) Y
SPECIAL_REVIEW_TYPE VARCHAR2 (1)
SPECIAL_REVIEW_TYPE_DESC VARCHAR2 (80)
APPROVAL_TYPE_CODE VARCHAR2 (30)
APPROVAL_TYPE_DESC VARCHAR2 (80)
PROTOCOL_NUMBER VARCHAR2 (50)
APPLICATION_DATE DATE

APPROVAL_DATE DATE

COMMENTS VARCHAR2 (4000)
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15) Y

[top of page]

APPS.IGW_PROP_SPECIAL_REVIEWS_V references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS
SYNONYM - IGW_PROP_SPECIAL_REVIEWS

APPS.IGW_PROP_SPECIAL_REVIEWS_V is not referenced by any database object

[top of page]

View: IGW_PROP_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_ID NUMBER (15) Y
PROPOSAL_NUMBER VARCHAR2 (30) Y
PROPOSAL_TYPE_CODE VARCHAR2 (30) Y
PI_ID NUMBER (15)
PI_NAME VARCHAR2 (240)
SPONSOR_ID NUMBER (15)
SPONSOR_NAME VARCHAR2 (50)
PROJECT_LOCATION_ID NUMBER

PROJECT_LOCATION_NAME VARCHAR2 (4000)
MAJOR_GOALS VARCHAR2 (4000)
PROPOSAL_START_DATE DATE
Y
PROPOSAL_END_DATE DATE
Y
ANNUAL_DIRECT_COST NUMBER

TOTAL_COST NUMBER

PROPOSAL_TITLE VARCHAR2 (250)
SPONSOR_ACTION_CODE VARCHAR2 (30)
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15) Y

[top of page]

APPS.IGW_PROP_V references the following:

APPS
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_PARTIES
VIEW - IGW_PROPOSALS
PACKAGE - IGW_PROP_COSTS
SYNONYM - IGW_PROP_PERSONS
PACKAGE - IGW_VIEW_PARAMETERS
VIEW - PER_PEOPLE_X
APPS.IGW_PROP_V is referenced by following:

APPS
PACKAGE BODY - IGW_PROP_PERSON_SUPPORT_PVT

[top of page]

View: IGW_PRPO_ABSTRACTS_V

Comments
View Type

A Business Intelligence System view

IGW_PRPO_ABSTRACTS_V displays proposal paragraphs like abstract and progress report. Each paragraph is formatted into ten fields each of 400 characters. This view is used in generating a flat file for Electronic Data Interchange.

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_ID NUMBER (15) Y
ABSTRACT_CODE VARCHAR2 (30) Y
ABSTRACT_TYPE VARCHAR2 (80) Y
ABSTRACT_TEXT1 VARCHAR2 (400)
ABSTRACT_TEXT2 VARCHAR2 (400)
ABSTRACT_TEXT3 VARCHAR2 (400)
ABSTRACT_TEXT4 VARCHAR2 (400)
ABSTRACT_TEXT5 VARCHAR2 (400)
ABSTRACT_TEXT6 VARCHAR2 (400)
ABSTRACT_TEXT7 VARCHAR2 (400)
ABSTRACT_TEXT8 VARCHAR2 (400)
ABSTRACT_TEXT9 VARCHAR2 (400)
ABSTRACT_TEXT10 VARCHAR2 (400)

[top of page]

APPS.IGW_PRPO_ABSTRACTS_V references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - IGW_LOOKUPS_V
SYNONYM - IGW_PROP_ABSTRACTS

APPS.IGW_PRPO_ABSTRACTS_V is not referenced by any database object

[top of page]

View: IGW_PRPO_BIOSKETCH_DEGREES_V

Comments
View Type

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.

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_ID NUMBER (15) Y
PERSON_ID NUMBER (15)
PARTY_ID NUMBER (15) Y
DEGREE_CODE VARCHAR2 (30) Y
DEGREE_TIME_PERIOD DATE
Y
DEGREE_DESCRIPTION VARCHAR2 (80) Y
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)

[top of page]

APPS.IGW_PRPO_BIOSKETCH_DEGREES_V references the following:

APPS
SYNONYM - IGW_PERSON_DEGREES
SYNONYM - IGW_PROP_PERSON_DEGREES

APPS.IGW_PRPO_BIOSKETCH_DEGREES_V is not referenced by any database object

[top of page]

View: IGW_PRPO_BIOSKETCH_V

Comments
View Type

A Business Intelligence System view

IGW_PRPO_BIOSKETCH_V displays a person's biosketch information. This view is used in generating a flat file for Electronic Data Interchange.

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_ID NUMBER (15)
PERSON_ID NUMBER (15)
PARTY_ID NUMBER (15)
BIOSKETCH_TYPE_CODE VARCHAR2 (30)
BIOSKETCH_TYPE VARCHAR2 (80)
BIOSKETCH_DESCRIPTION VARCHAR2 (500)
KEY_PERSON_FLAG VARCHAR2 (1)

[top of page]

APPS.IGW_PRPO_BIOSKETCH_V references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - IGW_LOOKUPS_V
SYNONYM - IGW_PERSON_BIOSKETCH
SYNONYM - IGW_PROP_PERSONS
SYNONYM - IGW_PROP_PERSON_BIOSKETCH

APPS.IGW_PRPO_BIOSKETCH_V is not referenced by any database object

[top of page]

View: IGW_PRPO_CATEGORY_AMTS_V

Comments
View Type

A Business Intelligence System view

IGW_PRPO_CATEGORY_AMTS_V displays summary information about budget lines grouped by sponsor budget hierarchy. This view is used in generating a flat file for Electronic Data Interchange.

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_ID NUMBER (15)
BUDGET_PERIOD_ID NUMBER (4)
PERIOD_TYPE CHAR (2)
START_DATE DATE

PROPOSAL_BUDGET_CATEGORY_CODE VARCHAR2 (30)
PROPOSAL_BUDGET_CATEGORY VARCHAR2 (80)
DESCRIPTION VARCHAR2 (250)
PERIOD_TOTAL_DIRECT_COST NUMBER

PERIOD_MONTHS NUMBER

PERCENT_DOLLAR_FLAG VARCHAR2 (2)
EB_TOTAL VARCHAR2 (17)

[top of page]

APPS.IGW_PRPO_CATEGORY_AMTS_V references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS
SYNONYM - IGW_BUDGETS
SYNONYM - IGW_BUDGET_DETAILS
SYNONYM - IGW_BUDGET_PERIODS
SYNONYM - IGW_REPORT_BUDGET
SYNONYM - IGW_REPORT_BUDGET_SEED

APPS.IGW_PRPO_CATEGORY_AMTS_V is not referenced by any database object

[top of page]

View: IGW_PRPO_HEADERS_V

Comments
View Type

A Business Intelligence System view

IGW_PRPO_HEADERS_V displays proposal core information that includes details about the Administrative Official, the Signing Official, special reviews, the applicant organization, the sponsor, and the budget summary. This view is used in generating a flat file for Electronic Data Interchange.

Columns
Name Datatype Length Mandatory Comments
COMMUNICATION_METHOD CHAR (3)
TEST_INDICATOR VARCHAR2 (1) Y
TP_DOCUMENT_ID CHAR (4)
TP_DOCUMENT_TYPE VARCHAR2 (30) Y
TP_DOCUMENT_CODE CHAR (4)
TP_TRANSLATOR_CODE VARCHAR2 (30)
TP_LOCATION_CODE VARCHAR2 (40)
TP_DESCRIPTION VARCHAR2 (240)
TP_REFERENCE_EXT1 VARCHAR2 (240)
TP_REFERENCE_EXT2 VARCHAR2 (240)
TRANSACTION_DATE DATE

TPH_ATTRIBUTE_CATEGORY VARCHAR2 (150)
TPH_ATTRIBUTE1 VARCHAR2 (150)
TPH_ATTRIBUTE2 VARCHAR2 (150)
TPH_ATTRIBUTE3 VARCHAR2 (150)
TPH_ATTRIBUTE4 VARCHAR2 (150)
TPH_ATTRIBUTE5 VARCHAR2 (150)
TPH_ATTRIBUTE6 VARCHAR2 (150)
TPH_ATTRIBUTE7 VARCHAR2 (150)
TPH_ATTRIBUTE8 VARCHAR2 (150)
TPH_ATTRIBUTE9 VARCHAR2 (150)
TPH_ATTRIBUTE10 VARCHAR2 (150)
TPH_ATTRIBUTE11 VARCHAR2 (150)
TPH_ATTRIBUTE12 VARCHAR2 (150)
TPH_ATTRIBUTE13 VARCHAR2 (150)
TPH_ATTRIBUTE14 VARCHAR2 (150)
TPH_ATTRIBUTE15 VARCHAR2 (150)
TPD_ATTRIBUTE_CATEGORY VARCHAR2 (150)
TPD_ATTRIBUTE1 VARCHAR2 (150)
TPD_ATTRIBUTE2 VARCHAR2 (150)
TPD_ATTRIBUTE3 VARCHAR2 (150)
TPD_ATTRIBUTE4 VARCHAR2 (150)
TPD_ATTRIBUTE5 VARCHAR2 (150)
DOCUMENT_STANDARD VARCHAR2 (30)
PROPOSAL_ID NUMBER (15) Y
PROPOSAL_NUMBER VARCHAR2 (30) Y
DATE_APPROVED VARCHAR2 (8)
TIME_APPROVED VARCHAR2 (6)
PROPOSAL_TITLE VARCHAR2 (250)
RFA_PA_NUMBER VARCHAR2 (30)
PROGRAM_TITLE VARCHAR2 (250)
NOTICE_OF_OPPORTUNITY_CODE VARCHAR2 (30)
PROPOSAL_TYPE VARCHAR2 (80) Y
ORIGINAL_PROPOSAL_NUMBER VARCHAR2 (30)
NARRATIVE_SUBMISSION_CODE VARCHAR2 (30)
NARRATIVE_TYPE_CODE VARCHAR2 (30)
AWARD_NUMBER VARCHAR2 (15)
SO_LAST_NAME VARCHAR2 (150)
SO_FIRST_NAME VARCHAR2 (150)
SO_MIDDLE_NAME VARCHAR2 (60)
SO_PREFIX VARCHAR2 (30)
SO_SUFFIX VARCHAR2 (30)
SIGNING_OFFICIAL_GOVT_ID VARCHAR2 (4000)
SO_ADDRESS_LINE1 VARCHAR2 (240)
SO_ADDRESS_LINE2 VARCHAR2 (240)
SO_TOWN_OR_CITY VARCHAR2 (30)
SO_STATE VARCHAR2 (120)
SO_POSTAL_CODE VARCHAR2 (30)
SO_COUNTRY VARCHAR2 (60)
SO_COUNTY VARCHAR2 (120)
SO_TITLE VARCHAR2 (30)
SO_WORK_PHONE VARCHAR2 (4000)
SO_WORK_FAX VARCHAR2 (4000)
SO_EMAIL_ADDRESS VARCHAR2 (240)
AO_LAST_NAME VARCHAR2 (150)
AO_FIRST_NAME VARCHAR2 (150)
AO_MIDDLE_NAME VARCHAR2 (60)
AO_PREFIX VARCHAR2 (30)
AO_SUFFIX VARCHAR2 (30)
ADMIN_OFFICIAL_GOVT_ID VARCHAR2 (4000)
AO_ADDRESS_LINE1 VARCHAR2 (240)
AO_ADDRESS_LINE2 VARCHAR2 (240)
AO_TOWN_OR_CITY VARCHAR2 (30)
AO_STATE VARCHAR2 (120)
AO_POSTAL_CODE VARCHAR2 (30)
AO_COUNTRY VARCHAR2 (60)
AO_COUNTY VARCHAR2 (120)
AO_TITLE VARCHAR2 (30)
AO_WORK_PHONE VARCHAR2 (4000)
AO_WORK_FAX VARCHAR2 (4000)
AO_EMAIL_ADDRESS VARCHAR2 (240)
ORGANIZATION_NAME VARCHAR2 (240)
ORG_ADDRESS_LINE1 VARCHAR2 (240)
ORG_ADDRESS_LINE2 VARCHAR2 (240)
ORG_ADDRESS_LINE3 VARCHAR2 (240)
ORG_TOWN_OR_CITY VARCHAR2 (30)
ORG_STATE VARCHAR2 (120)
ORG_POSTAL_CODE VARCHAR2 (30)
ORG_COUNTRY VARCHAR2 (60)
ORG_COUNTY VARCHAR2 (120)
ORG_CONGRESS_DISTRICT VARCHAR2 (50)
ORG_DUNS_NUMBER VARCHAR2 (20)
ORG_DUNS4_NUMBER VARCHAR2 (20)
ORG_DODAAC_NUMBER VARCHAR2 (20)
ORG_CAGE_NUMBER VARCHAR2 (20)
ORG_TIN VARCHAR2 (20)
ORG_EIN VARCHAR2 (20)
ORG_IPF_CODE VARCHAR2 (20)
SPONSOR_NAME VARCHAR2 (50)
SPONSOR_ADDRESS1 VARCHAR2 (240) Y
SPONSOR_ADDRESS2 VARCHAR2 (240)
SPONSOR_CITY VARCHAR2 (60)
SPONSOR_STATE VARCHAR2 (60)
SPONSOR_POSTAL_CODE VARCHAR2 (60)
SPONSOR_COUNTRY VARCHAR2 (60) Y
SPONSOR_COUNTY VARCHAR2 (60)
SPONSOR_DIVISION_NAME VARCHAR2 (45)
SPONSOR_DUNS_NUMBER VARCHAR2 (30)
PROPOSAL_START_DATE DATE
Y
PROPOSAL_END_DATE DATE
Y
PROPOSAL_DURATION NUMBER

TOTAL_COST NUMBER (15)
TOTAL_DIRECT_COST NUMBER (15)
TOTAL_INDIRECT_COST NUMBER (15)
INDIRECT_COST_RATE NUMBER

BASE_COST NUMBER

DHHS_AGREEMENT_FLAG VARCHAR2 (1)
DHHS_AGREEMENT_DATE DATE

DHHS_AGREEMENT_WITH VARCHAR2 (50)
RATE_ESTABLISHED_WITH VARCHAR2 (50)
RATE_ESTABLISHED_DATE DATE

HUMAN_EXEMPTION_NUMBER VARCHAR2 (20)
HUMAN_ASSURANCE_NUMBER VARCHAR2 (20)
ANIMAL_ASSURANCE_NUMBER VARCHAR2 (20)
BUDGET_START_DATE DATE

BUDGET_END_DATE DATE

BUDGET_DURATION NUMBER

PROPOSAL_ATTRIBUTE_CATEGORY VARCHAR2 (30)
PROPOSAL_ATTRIBUTE1 VARCHAR2 (150)
PROPOSAL_ATTRIBUTE2 VARCHAR2 (150)
PROPOSAL_ATTRIBUTE3 VARCHAR2 (150)
PROPOSAL_ATTRIBUTE4 VARCHAR2 (150)
PROPOSAL_ATTRIBUTE5 VARCHAR2 (150)
PROPOSAL_ATTRIBUTE6 VARCHAR2 (150)
PROPOSAL_ATTRIBUTE7 VARCHAR2 (150)
PROPOSAL_ATTRIBUTE8 VARCHAR2 (150)
PROPOSAL_ATTRIBUTE9 VARCHAR2 (150)
PROPOSAL_ATTRIBUTE10 VARCHAR2 (150)
PROPOSAL_ATTRIBUTE11 VARCHAR2 (150)
PROPOSAL_ATTRIBUTE12 VARCHAR2 (150)
PROPOSAL_ATTRIBUTE13 VARCHAR2 (150)
PROPOSAL_ATTRIBUTE14 VARCHAR2 (150)
PROPOSAL_ATTRIBUTE15 VARCHAR2 (150)
ORG_DETAILS_ATTRIBUTE_CATEGORY VARCHAR2 (30)
ORG_DETAILS_ATTRIBUTE1 VARCHAR2 (150)
ORG_DETAILS_ATTRIBUTE2 VARCHAR2 (150)
ORG_DETAILS_ATTRIBUTE3 VARCHAR2 (150)
ORG_DETAILS_ATTRIBUTE4 VARCHAR2 (150)
ORG_DETAILS_ATTRIBUTE5 VARCHAR2 (150)
ORG_DETAILS_ATTRIBUTE6 VARCHAR2 (150)
ORG_DETAILS_ATTRIBUTE7 VARCHAR2 (150)
ORG_DETAILS_ATTRIBUTE8 VARCHAR2 (150)
ORG_DETAILS_ATTRIBUTE9 VARCHAR2 (150)
ORG_DETAILS_ATTRIBUTE10 VARCHAR2 (150)
ORG_DETAILS_ATTRIBUTE11 VARCHAR2 (150)
ORG_DETAILS_ATTRIBUTE12 VARCHAR2 (150)
ORG_DETAILS_ATTRIBUTE13 VARCHAR2 (150)
ORG_DETAILS_ATTRIBUTE14 VARCHAR2 (150)
ORG_DETAILS_ATTRIBUTE15 VARCHAR2 (150)

[top of page]

APPS.IGW_PRPO_HEADERS_V references the following:

APPS
SYNONYM - ECE_TP_DETAILS
SYNONYM - ECE_TP_HEADERS
PACKAGE - FND_GLOBAL
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_CUST_ACCT_SITES_ALL
SYNONYM - HZ_LOCATIONS
SYNONYM - HZ_LOC_ASSIGNMENTS
SYNONYM - HZ_PARTIES
SYNONYM - HZ_PARTY_SITES
VIEW - IGW_ADMIN_OFFICIAL_V
VIEW - IGW_APPLICANT_ORG_V
SYNONYM - IGW_BUDGETS
PACKAGE - IGW_EXTENSION_PKG
VIEW - IGW_LOOKUPS_V
SYNONYM - IGW_ORG_DETAILS
VIEW - IGW_PROPOSALS
SYNONYM - IGW_PROP_APPROVAL_RUNS
SYNONYM - IGW_REPORT_BUDGET_BASE_RATE
PACKAGE - IGW_REPORT_PROCESSING
VIEW - IGW_SIGNING_OFFICIAL_V

APPS.IGW_PRPO_HEADERS_V is not referenced by any database object

[top of page]

View: IGW_PRPO_ORG_TYPES_V

Comments
View Type

A Business Intelligence System view

IGW_PRPO_ORG_TYPES_V displays the applicant organization's type. This view is used in generating a flat file for Electronic Data Interchange.

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_ID NUMBER (15) Y
ORGANIZATION_ID NUMBER (15) Y
ORG_TYPE_CODE VARCHAR2 (30) Y
ORG_TYPE VARCHAR2 (80) Y

[top of page]

APPS.IGW_PRPO_ORG_TYPES_V references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - IGW_LOOKUPS_V
SYNONYM - IGW_ORG_TYPES
VIEW - IGW_PROPOSALS

APPS.IGW_PRPO_ORG_TYPES_V is not referenced by any database object

[top of page]

View: IGW_PRPO_OTHER_SUPPORT_V

Comments
View Type

A Business Intelligence System view

IGW_PRPO_OTHER_SUPPORT_V displays details of other sources of support which are pending or available for personnel on the proposal. This view is used in generating a flat file for Electronic Data Interchange.

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_ID NUMBER (15) Y
PERSON_ID NUMBER (15)
PARTY_ID NUMBER (15) Y
SUPPORT_STATUS VARCHAR2 (80)
AWARD_NUMBER VARCHAR2 (30)
AWARD_TITLE VARCHAR2 (250)
ANNUAL_DIRECT_COST NUMBER (15)
TOTAL_COST NUMBER (15)
PERCENT_EFFORT NUMBER (5)
SPONSOR_NAME VARCHAR2 (50)
MAJOR_GOALS VARCHAR2 (250)
PM_LAST_NAME VARCHAR2 (150)
PM_FIRST_NAME VARCHAR2 (150)
PM_MIDDLE_NAME VARCHAR2 (60)
PROJECT_LOCATION VARCHAR2 (100)
START_DATE DATE

END_DATE DATE

OVERLAP VARCHAR2 (250)
OTH_SUPPORT_ATTRIBUTE_CATEGORY VARCHAR2 (30)
OTH_SUPPORT_ATTRIBUTE1 VARCHAR2 (150)
OTH_SUPPORT_ATTRIBUTE2 VARCHAR2 (150)
OTH_SUPPORT_ATTRIBUTE3 VARCHAR2 (150)
OTH_SUPPORT_ATTRIBUTE4 VARCHAR2 (150)
OTH_SUPPORT_ATTRIBUTE5 VARCHAR2 (150)
OTH_SUPPORT_ATTRIBUTE6 VARCHAR2 (150)
OTH_SUPPORT_ATTRIBUTE7 VARCHAR2 (150)
OTH_SUPPORT_ATTRIBUTE8 VARCHAR2 (150)
OTH_SUPPORT_ATTRIBUTE9 VARCHAR2 (150)
OTH_SUPPORT_ATTRIBUTE10 VARCHAR2 (150)
OTH_SUPPORT_ATTRIBUTE11 VARCHAR2 (150)
OTH_SUPPORT_ATTRIBUTE12 VARCHAR2 (150)
OTH_SUPPORT_ATTRIBUTE13 VARCHAR2 (150)
OTH_SUPPORT_ATTRIBUTE14 VARCHAR2 (150)
OTH_SUPPORT_ATTRIBUTE15 VARCHAR2 (150)

[top of page]

APPS.IGW_PRPO_OTHER_SUPPORT_V references the following:

APPS
PACKAGE - FND_GLOBAL
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_PARTIES
VIEW - IGW_LOOKUPS_V
SYNONYM - IGW_PROP_PERSON_SUPPORT
VIEW - PER_PEOPLE_X

APPS.IGW_PRPO_OTHER_SUPPORT_V is not referenced by any database object

[top of page]

View: IGW_PRPO_PERF_SITES_V

Comments
View Type

A Business Intelligence System view

IGW_PRPO_PERF_SITES_V displays performing sites where the proposal activity will be conducted. This view is used in generating a flat file for Electronic Data Interchange.

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_ID NUMBER (15)
PERFORMING_ORGANIZATION_ID NUMBER (15)
PARTY_ID NUMBER (15)
PERFORMING_ORGANIZATION_NAME VARCHAR2 (360)
ADDRESS_LINE1 VARCHAR2 (240)
ADDRESS_LINE2 VARCHAR2 (240)
ADDRESS_LINE3 VARCHAR2 (240)
TOWN_OR_CITY VARCHAR2 (60)
COUNTY VARCHAR2 (120)
STATE VARCHAR2 (120)
POSTAL_CODE VARCHAR2 (60)
COUNTRY VARCHAR2 (60)
DUNS_NUMBER VARCHAR2 (40)
DUNS4_NUMBER VARCHAR2 (20)
DODAAC_NUMBER VARCHAR2 (20)
CAGE_NUMBER VARCHAR2 (20)

[top of page]

APPS.IGW_PRPO_PERF_SITES_V references the following:

APPS
PACKAGE - HR_GENERAL
VIEW - HR_LOCATIONS
VIEW - HR_ORGANIZATION_UNITS
PACKAGE - HR_SECURITY
SYNONYM - HZ_PARTIES
SYNONYM - IGW_ORG_DETAILS
SYNONYM - IGW_PROP_LOCATIONS

APPS.IGW_PRPO_PERF_SITES_V is not referenced by any database object

[top of page]

View: IGW_PRPO_PERSON_DETAILS_V

Comments
View Type

A Business Intelligence System view

IGW_PRPO_PERSON_DETAILS_V displays personnel details, such as salary, fringe benefits, appointment type, and proposal roles of personnel included in budget lines. This view is used in generating a flat file for Electronic Data Interchange.

Columns
Name Datatype Length Mandatory Comments
BUDGET_PERIOD_ID NUMBER

LAST_NAME CHAR (9)
FIRST_NAME CHAR (10)
MIDDLE_NAMES CHAR (12)
PROPOSAL_ROLE_CODE CHAR (18)
PROPOSAL_ROLE CHAR (13)
PERIOD_TYPE_CODE CHAR (16)
PERIOD_TYPE CHAR (8)
BUDGET_CATEGORY_CODE CHAR (20)
BUDGET_CATEGORY CHAR (15)
PERIOD_BEGINNING_DATE DATE

PERIOD_END_DATE DATE

APPOINTMENT_TYPE CHAR (21)
PERSON_MONTHS NUMBER

PERCENT_DOLLAR_FLAG CHAR (2)
BASE_SALARY NUMBER

PERCENT_EFFORT NUMBER

FRINGE_BENEFITS NUMBER

FRINGE_PERCENTAGE NUMBER

LINE_ITEM_ID NUMBER

SALARY_REQUESTED NUMBER

PROPOSAL_ID NUMBER

PERSON_ID NUMBER

PARTY_ID NUMBER

[top of page]

APPS.IGW_PRPO_PERSON_DETAILS_V references the following:

PUBLIC
SYNONYM - DUAL
- DUAL

APPS.IGW_PRPO_PERSON_DETAILS_V is not referenced by any database object

[top of page]

View: IGW_PRPO_PROP_PERSONS_V

Comments
View Type

A Business Intelligence System view

IGW_PRPO_PROP_PERSONS_V displays biographical information of personnel that includes name, social security number, gender, and date of birth. This view is used in generating a flat file for Electronic Data Interchange.

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_ID NUMBER (15)
PERSON_ID NUMBER (15)
PARTY_ID NUMBER (15)
FIRST_NAME VARCHAR2 (150)
MIDDLE_NAME VARCHAR2 (60)
LAST_NAME VARCHAR2 (150)
FULL_NAME VARCHAR2 (360)
TITLE VARCHAR2 (60)
PREFIX VARCHAR2 (30)
SUFFIX VARCHAR2 (30)
PROPOSAL_ROLE VARCHAR2 (4000)
JOB_NAME VARCHAR2 (4000)
SEX VARCHAR2 (30)
DATE_OF_BIRTH DATE

SSN VARCHAR2 (30)
CITIZENSHIP VARCHAR2 (80)
RACE VARCHAR2 (80)
KEY_PERSON_FLAG VARCHAR2 (1)
PERSON_EDI_CODE VARCHAR2 (2)
PERSON_SEQUENCE NUMBER (3)
PERCENT_EFFORT NUMBER (5)
ADDRESS_LINE1 VARCHAR2 (240)
ADDRESS_LINE2 VARCHAR2 (240)
ADDRESS_LINE3 VARCHAR2 (240)
POSTAL_CODE VARCHAR2 (60)
COUNTY VARCHAR2 (120)
STATE VARCHAR2 (120)
TOWN_OR_CITY VARCHAR2 (60)
COUNTRY VARCHAR2 (60)
WORK_PHONE VARCHAR2 (4000)
WORK_FAX VARCHAR2 (4000)
EMAIL_ADDRESS VARCHAR2 (2000)
PERSON_GOVT_ID VARCHAR2 (4000)

[top of page]

APPS.IGW_PRPO_PROP_PERSONS_V references the following:

APPS
SYNONYM - FND_LOOKUP_VALUES
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
SYNONYM - HZ_PARTIES
SYNONYM - HZ_PERSON_PROFILES
PACKAGE - IGW_EXTENSION_PKG
SYNONYM - IGW_PROP_PERSONS
PACKAGE - IGW_REPORT_PROCESSING
SYNONYM - PER_ADDRESSES
VIEW - PER_PEOPLE_X

APPS.IGW_PRPO_PROP_PERSONS_V is not referenced by any database object

[top of page]

View: IGW_PRPO_ROLES_DETAILS_V

Comments
View Type

A Business Intelligence System view

IGW_PRPO_ROLES_DETAILS_V displays summary information about personnel, such as person months and salary, grouped by proposal role. This view is used in generating a flat file for Electronic Data Interchange.

Columns
Name Datatype Length Mandatory Comments
NO_OF_PERSONS NUMBER

PROPOSAL_ROLE_CODE CHAR (18)
PROPOSAL_ROLE CHAR (13)
BASE_SALARY NUMBER

BUDGET_CATEGORY_CODE CHAR (20)
PERIOD_BEGINNING_DATE DATE

PERIOD_END_DATE DATE

PERSON_MONTHS NUMBER

SALARY_REQUESTED NUMBER

PROPOSAL_ID NUMBER

BUDGET_PERIOD_ID NUMBER

[top of page]

APPS.IGW_PRPO_ROLES_DETAILS_V references the following:

PUBLIC
SYNONYM - DUAL
- DUAL

APPS.IGW_PRPO_ROLES_DETAILS_V is not referenced by any database object

[top of page]

View: IGW_PRPO_SPECIAL_REVIEWS_V

Comments
View Type

A Business Intelligence System view

IGW_PRPO_SPECIAL_REVIEWS_V displays details of special reviews conducted for the proposal. This view is used in generating a flat file for Electronic Data Interchange.

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_ID NUMBER (15) Y
REVIEW_SUBJECT VARCHAR2 (80)
REVIEW_COVERAGE VARCHAR2 (80)
APPROVAL_STATUS VARCHAR2 (80)
APPROVAL_DATE DATE

PROTOCOL_NUMBER VARCHAR2 (50)
APPLICATION_DATE DATE

[top of page]

APPS.IGW_PRPO_SPECIAL_REVIEWS_V references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - IGW_LOOKUPS_V
SYNONYM - IGW_PROP_SPECIAL_REVIEWS

APPS.IGW_PRPO_SPECIAL_REVIEWS_V is not referenced by any database object

[top of page]

View: IGW_PRPO_SUBJECT_INFO_V

Comments
View Type

A Business Intelligence System view

IGW_PRPO_SUBJECT_INFO_V displays details about human subjects involved in the proposal. This view is used in generating a flat file for Electronic Data Interchange.

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_ID NUMBER (15) Y
STUDY_TITLE VARCHAR2 (240)
AMERICAN_INDIAN_FEMALES NUMBER

ASIAN_FEMALES NUMBER

BLACK_FEMALES NUMBER

HISPANIC_FEMALES NUMBER

WHITE_FEMALES NUMBER

OTHER_FEMALES NUMBER

AMERICAN_INDIAN_MALES NUMBER

ASIAN_MALES NUMBER

BLACK_MALES NUMBER

HISPANIC_MALES NUMBER

WHITE_MALES NUMBER

OTHER_MALES NUMBER

[top of page]

APPS.IGW_PRPO_SUBJECT_INFO_V references the following:

APPS
PACKAGE - IGW_REPORT_PROCESSING
SYNONYM - IGW_STUDY_TITLES

APPS.IGW_PRPO_SUBJECT_INFO_V is not referenced by any database object

[top of page]

View: IGW_PRPO_YN_RESPONSES_V

Comments
View Type

A Business Intelligence System view

IGW_PRPO_YN_RESPONSES_V displays answers to questions about individuals, the proposal, and the organization. This view is used in generating a flat file for Electronic Data Interchange.

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_ID NUMBER (15)
ORGANIZATION_ID NUMBER

PERSON_ID NUMBER

PERSON_PARTY_ID NUMBER

QUESTION_APPLIES_TO CHAR (1)
QUESTION_NUMBER VARCHAR2 (5)
RESPONSE VARCHAR2 (1)
EXPLANATION VARCHAR2 (800)
REVIEW_DATE DATE

[top of page]

APPS.IGW_PRPO_YN_RESPONSES_V references the following:

APPS
SYNONYM - IGW_ORG_QUESTIONS
VIEW - IGW_PROPOSALS
SYNONYM - IGW_PROP_PERSON_QUESTIONS
SYNONYM - IGW_PROP_QUESTIONS

APPS.IGW_PRPO_YN_RESPONSES_V is not referenced by any database object

[top of page]

View: IGW_PRP_ORGANIZATIONS_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER (15)
NAME VARCHAR2 (240)
BUSINESS_GROUP_ID NUMBER (15)

[top of page]

APPS.IGW_PRP_ORGANIZATIONS_V references the following:

APPS
PACKAGE - HR_GENERAL
VIEW - HR_ORGANIZATION_UNITS
PACKAGE - HR_SECURITY
VIEW - IGW_IMPLEMENTATIONS
PACKAGE - IGW_SECURITY
PACKAGE - MO_GLOBAL
VIEW - PA_ORGANIZATIONS_LOV_V
SYNONYM - PER_ORG_STRUCTURE_ELEMENTS

APPS.IGW_PRP_ORGANIZATIONS_V is not referenced by any database object

[top of page]

View: IGW_QUESTIONS_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
QUESTION_NUMBER VARCHAR2 (5) Y
APPLIES_TO VARCHAR2 (1) Y
EXPLANATION_FOR_YES_FLAG VARCHAR2 (1) Y
EXPLANATION_FOR_NO_FLAG VARCHAR2 (1) Y
DATE_FOR_YES_FLAG VARCHAR2 (1) Y
DATE_FOR_NO_FLAG VARCHAR2 (1) Y
START_DATE_ACTIVE DATE
Y
END_DATE_ACTIVE DATE

EXPLANATION VARCHAR2 (1000)
POLICY VARCHAR2 (1000)
REGULATION VARCHAR2 (1000)
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15) Y
DESCRIPTION VARCHAR2 (500) Y

[top of page]

APPS.IGW_QUESTIONS_VL references the following:

APPS
SYNONYM - IGW_QUESTIONS
SYNONYM - IGW_QUESTIONS_TL

APPS.IGW_QUESTIONS_VL is not referenced by any database object

[top of page]

View: IGW_REPORT_BUDGET_PERSONNEL_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
FULL_NAME VARCHAR2 (50)
PROPOSAL_ROLE_CODE VARCHAR2 (30) Y
KEY_PERSON_FLAG VARCHAR2 (1)
ROLE VARCHAR2 (4000)
APPOINTMENT_TYPE VARCHAR2 (30) Y
PERCENT_EFFORT NUMBER (5)
BASE_SALARY NUMBER (15) Y
LINE_ITEM_ID NUMBER (15) Y
BUDGET_PERSONNEL_DETAIL_ID NUMBER (15) Y
MONTHS_WORKED NUMBER

SALARY_REQUESTED NUMBER

FRINGE_BENEFITS NUMBER

TOTAL NUMBER

PROPOSAL_ID NUMBER (15) Y
VERSION_ID NUMBER (4) Y
PERSON_ID NUMBER (15)
PARTY_ID NUMBER (15) Y
PI_FLAG VARCHAR2 (1)
PERSON_SEQUENCE NUMBER (3)

[top of page]

APPS.IGW_REPORT_BUDGET_PERSONNEL_V references the following:

APPS
SYNONYM - HZ_PARTIES
SYNONYM - IGW_BUDGETS
PACKAGE - IGW_BUDGET_INTEGRATION
SYNONYM - IGW_BUDGET_PERSONNEL_DETAILS
SYNONYM - IGW_BUDGET_PERSONS
SYNONYM - IGW_PROP_PERSONS
PACKAGE - IGW_REPORT_PROCESSING

APPS.IGW_REPORT_BUDGET_PERSONNEL_V is not referenced by any database object

[top of page]

View: IGW_REPORT_BUDGET_SEED_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_BUDGET_CATEGORY VARCHAR2 (80) Y
PROPOSAL_BUDGET_CATEGORY_CODE VARCHAR2 (30) Y
PROPOSAL_FORM_NUMBER VARCHAR2 (30) Y

[top of page]

APPS.IGW_REPORT_BUDGET_SEED_V references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - IGW_LOOKUPS_V
SYNONYM - IGW_REPORT_BUDGET_SEED

APPS.IGW_REPORT_BUDGET_SEED_V is not referenced by any database object

[top of page]

View: IGW_REPORT_BUDGET_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_BUDGET_CATEGORY_CODE VARCHAR2 (30) Y
PROPOSAL_BUDGET_CATEGORY VARCHAR2 (80)
PERIOD1_TOTAL NUMBER

PERIOD2_TOTAL NUMBER

PERIOD3_TOTAL NUMBER

PERIOD4_TOTAL NUMBER

PERIOD5_TOTAL NUMBER

[top of page]

APPS.IGW_REPORT_BUDGET_V references the following:

APPS
SYNONYM - IGW_REPORT_BUDGET
PACKAGE - IGW_REPORT_PROCESSING

APPS.IGW_REPORT_BUDGET_V is not referenced by any database object

[top of page]

View: IGW_REPORT_SEED_HEADER_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_FORM_NUMBER VARCHAR2 (30) Y
SEED_DATA_FLAG VARCHAR2 (1) Y

[top of page]

APPS.IGW_REPORT_SEED_HEADER_V references the following:

APPS
SYNONYM - IGW_REPORT_BUDGET_SEED
APPS.IGW_REPORT_SEED_HEADER_V is referenced by following:

APPS
PACKAGE BODY - IGW_BUDGETS_PVT

[top of page]

View: IGW_ROLES_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

10SC Only

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
SEEDED_FLAG VARCHAR2 (1)
ROLE_ID NUMBER (10) Y
START_DATE_ACTIVE DATE
Y
END_DATE_ACTIVE DATE

LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15) Y
ROLE_NAME VARCHAR2 (50) Y

[top of page]

APPS.IGW_ROLES_VL references the following:

APPS
SYNONYM - IGW_ROLES
SYNONYM - IGW_ROLES_TL

APPS.IGW_ROLES_VL is not referenced by any database object

[top of page]

View: IGW_SIGNING_OFFICIAL_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

IGW_SIGNING_OFFICIAL_V displays the details of the proposal's Signing Official. Details include name, address, and organization of the Signing Official.

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_ID NUMBER (15) Y Proposal identifier
PROPOSAL_NUMBER VARCHAR2 (30) Y Proposal number
ORGANIZATION_ID NUMBER (15)
Organization identifier
PERSON_ID NUMBER (10) Y Person's identifier
FULL_NAME VARCHAR2 (240)
Full name
LAST_NAME VARCHAR2 (150) Y Last name
FIRST_NAME VARCHAR2 (150)
First name
MIDDLE_NAME VARCHAR2 (60)
Middle name
TITLE VARCHAR2 (30)
Title, such as Mr., Ms., or Dr.
PREFIX VARCHAR2 (30)
Prefix
SUFFIX VARCHAR2 (30)
Suffix after surname, such as Sr., Jr., or III
LAST_FIRST_MIDDLE_NAME VARCHAR2 (363)
Last name, first name, and middle name of Signing Offical. Names are separated by commas.
FIRST_MIDDLE_LAST_NAME VARCHAR2 (393)
First name, middle name, and last name. Names are separated by commas.
JOB_NAME VARCHAR2 (4000)
Job name
ADDRESS_LINE1 VARCHAR2 (240)
First address line
ADDRESS_LINE2 VARCHAR2 (240)
Second address line
ADDRESS_LINE3 VARCHAR2 (240)
Third address line
POSTAL_CODE VARCHAR2 (30)
Postal code
REGION_1 VARCHAR2 (120)
Primary region in which address is located
REGION_2 VARCHAR2 (120)
Subregion of Region 1 in which address is located
REGION_3 VARCHAR2 (120)
Subregion of Region 2 in which address is located
TOWN_OR_CITY VARCHAR2 (30)
Town or city
COUNTRY VARCHAR2 (60)
Country
WORK_PHONE VARCHAR2 (4000)
Work phone
WORK_FAX VARCHAR2 (4000)
Work fax
EMAIL_ADDRESS VARCHAR2 (240)
E-mail address

[top of page]

APPS.IGW_SIGNING_OFFICIAL_V references the following:

APPS
PACKAGE - HR_GENERAL
VIEW - HR_LOCATIONS
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
SYNONYM - IGW_PROPOSALS_ALL
PACKAGE - IGW_REPORT_PROCESSING
VIEW - PER_ASSIGNMENTS_X
VIEW - PER_PEOPLE_X
APPS.IGW_SIGNING_OFFICIAL_V is referenced by following:

APPS
VIEW - IGW_PRPO_HEADERS_V

[top of page]

View: IGW_SPECIAL_REVIEWS_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

IGW_SPECIAL_REVIEWS_V displays details about special reviews of human subjects and animal subjects conducted for the proposal. A value of X for a field indicates True and NULL indicates False.

Columns
Name Datatype Length Mandatory Comments
PROPOSAL_ID NUMBER (15) Y Proposal identifier
PROPOSAL_NUMBER VARCHAR2 (30) Y Proposal number
HUMAN_SUBJECTS_YES VARCHAR2 (1)
Proposal has human subjects. X indicates Yes and Null indicates No.
HUMAN_SUBJECTS_NO VARCHAR2 (1)
Proposal does not have human subjects. X indicates Yes and Null indicates No.
HUMAN_REVIEW_PENDING VARCHAR2 (1)
Human subjects review pending
HUMAN_REVIEW_APPROVED VARCHAR2 (1)
Human subjects review approved
HUMAN_REVIEW_REJECTED VARCHAR2 (1)
Human subjects review rejected
HUMAN_REVIEW_FULL VARCHAR2 (1)
Human subjects review full
HUMAN_REVIEW_EXPEDITED VARCHAR2 (1)
Human subjects review expedited
HUMAN_APPROVAL_DATE DATE

Human subjects review approval date
ANIMAL_SUBJECTS_YES VARCHAR2 (1)
Proposal has animal subjects. X indicates Yes and Null indicates No.
ANIMAL_SUBJECTS_NO VARCHAR2 (1)
Proposal does not have animal subjects. X indicates Yes and Null indicates No.
ANIMAL_REVIEW_PENDING VARCHAR2 (1)
Animal subjects review pending
ANIMAL_REVIEW_APPROVED VARCHAR2 (1)
Animal subjects review approved
ANIMAL_REVIEW_REJECTED VARCHAR2 (1)
Animal subjects review rejected
ANIMAL_REVIEW_FULL VARCHAR2 (1)
Animal subjects review full
ANIMAL_REVIEW_EXPEDITED VARCHAR2 (1)
Animal subjects review expedited
ANIMAL_APPROVAL_DATE DATE

Animal subjects review approval date

[top of page]

APPS.IGW_SPECIAL_REVIEWS_V references the following:

APPS
SYNONYM - IGW_PROPOSALS_ALL
SYNONYM - IGW_PROP_SPECIAL_REVIEWS

APPS.IGW_SPECIAL_REVIEWS_V is not referenced by any database object

[top of page]

View: IGW_TRANSFERABLE_BUDGETS_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
VERSION_ID NUMBER (4) Y
PROPOSAL_ID NUMBER (15) Y

[top of page]

APPS.IGW_TRANSFERABLE_BUDGETS_V references the following:

APPS
SYNONYM - IGW_BUDGETS
VIEW - IGW_PROPOSALS

APPS.IGW_TRANSFERABLE_BUDGETS_V is not referenced by any database object

[top of page]
Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract