Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

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 - GMS Tables and Views

TABLE - GMS.GMS_269_HISTORY
TABLE - GMS.GMS_270_HISTORY
TABLE - GMS.GMS_272_HISTORY
TABLE - GMS.GMS_ALLOWABILITY_SCHEDULES
TABLE - GMS.GMS_ALLOWABLE_EXPENDITURES
TABLE - GMS.GMS_AWARDS_ALL
TABLE - GMS.GMS_AWARDS_CONTACTS
TABLE - GMS.GMS_AWARDS_TERMS_CONDITIONS
TABLE - GMS.GMS_AWARD_DISTRIBUTIONS
TABLE - GMS.GMS_AWARD_EXP_TYPE_ACT_COST
TABLE - GMS.GMS_BALANCES
TABLE - GMS.GMS_BC_PACKETS
TABLE - GMS.GMS_BC_PACKETS_BVID
TABLE - GMS.GMS_BC_PACKETS_SUMMARY
TABLE - GMS.GMS_BC_PACKET_ARRIVAL_ORDER
TABLE - GMS.GMS_BILLING_CANCELLATIONS
TABLE - GMS.GMS_BILLING_FORMS
TABLE - GMS.GMS_BUDGETARY_CONTROLS
TABLE - GMS.GMS_BUDGET_LINES
TABLE - GMS.GMS_BUDGET_VERSIONS
TABLE - GMS.GMS_BURDEN_ADJUSTMENTS_LOG
TABLE - GMS.GMS_BURDEN_COMPONENTS
TABLE - GMS.GMS_CONCURRENCY_CONTROL
TABLE - GMS.GMS_DEFAULT_REPORTS
TABLE - GMS.GMS_DISTRIBUTIONS
TABLE - GMS.GMS_DISTRIBUTION_DETAILS
TABLE - GMS.GMS_ENCUMBRANCES_ALL
TABLE - GMS.GMS_ENCUMBRANCE_GROUPS_ALL
TABLE - GMS.GMS_ENCUMBRANCE_ITEMS_ALL
TABLE - GMS.GMS_EVENT_ATTRIBUTE
TABLE - GMS.GMS_EVENT_INTERSECT
TABLE - GMS.GMS_FP_DISTRIBUTIONS
TABLE - GMS.GMS_FUNDING_PATTERNS_ALL
TABLE - GMS.GMS_IMPLEMENTATIONS_ALL
TABLE - GMS.GMS_IND_COST_CODES
TABLE - GMS.GMS_INSTALLMENTS
TABLE - GMS.GMS_NOTIFICATIONS
TABLE - GMS.GMS_OVERRIDE_SCHEDULES
TABLE - GMS.GMS_PERSONNEL
TABLE - GMS.GMS_PROJECT_FUNDINGS
TABLE - GMS.GMS_PROJECT_TYPES_ALL
TABLE - GMS.GMS_REFERENCE_NUMBERS
TABLE - GMS.GMS_REPORTS
TABLE - GMS.GMS_REPORT_TEMPLATES
TABLE - GMS.GMS_RESOURCE_ASSIGNMENTS
TABLE - GMS.GMS_SUMMARY_PROJECT_FUNDINGS
TABLE - GMS.GMS_TC_CATEGORIES
TABLE - GMS.GMS_TERMS_CONDITIONS
TABLE - GMS.GMS_TRANSACTION_INTERFACE_ALL
TABLE - GMS.GMS_UNIQUE_IDENTIFIER_CONTROL
TABLE - GMS.GMS_WF_PROCESSES
VIEW - APPS.GMS_1034_REPORT_V
VIEW - APPS.GMS_ACT_PROJECTS_BASIC_V
VIEW - APPS.GMS_AWARDS_BASIC_V
VIEW - APPS.GMS_AWARDS_SRS_V
VIEW - APPS.GMS_AWARDS_V
VIEW - APPS.GMS_AWARD_BAL_V
VIEW - APPS.GMS_AWARD_PROJECTS_V
VIEW - APPS.GMS_AWARD_STATUS_V
VIEW - APPS.GMS_AWD_V
VIEW - APPS.GMS_BILL_AWARD_PROJECTS_V
VIEW - APPS.GMS_BUDGETARY_CONTROL_AWARD_V
VIEW - APPS.GMS_BUDGETARY_CONTROL_PROJ_V
VIEW - APPS.GMS_BUDGETARY_CONTROL_TASK_V
VIEW - APPS.GMS_BUDGET_CHANGE_REASON_V
VIEW - APPS.GMS_BUDGET_LINES_V
VIEW - APPS.GMS_BUDGET_MATRIX_V
VIEW - APPS.GMS_BUDGET_VERSIONS_BASELND_V
VIEW - APPS.GMS_BUDGET_VERSIONS_DRAFT_V
VIEW - APPS.GMS_BUDG_CONTROL_RES_GRP_V
VIEW - APPS.GMS_CDL_BURDEN_DETAIL_V
VIEW - APPS.GMS_COMMITMENTS_OVERRIDE_V
VIEW - APPS.GMS_COMMITMENT_BURDEN_V
VIEW - APPS.GMS_COMMITMENT_ENCUMBERED_V
VIEW - APPS.GMS_COMMITMENT_TXNS_V
VIEW - APPS.GMS_CONTACTS_V
VIEW - APPS.GMS_DEFAULT_REPORTS_V
VIEW - APPS.GMS_DRAFT_INVOICES_V
VIEW - APPS.GMS_DRAFT_INV_LINE_DETAILS_V
VIEW - APPS.GMS_DRAFT_REVENUES_V
VIEW - APPS.GMS_DTRANGE_BAL_V
VIEW - APPS.GMS_EMPLOYEES
VIEW - APPS.GMS_ENCUMBRANCES_V
VIEW - APPS.GMS_ENCUMBRANCE_GROUPS_V
VIEW - APPS.GMS_ENCUMBRANCE_ITEMS_V
VIEW - APPS.GMS_ENC_PSI_V
VIEW - APPS.GMS_EVENTS_V
VIEW - APPS.GMS_EXPEND_ITEMS_ADJUST_V
VIEW - APPS.GMS_FP_DISTRIBUTIONS_V
VIEW - APPS.GMS_FUNDING_AWARDS_V
VIEW - APPS.GMS_FUNDING_PATTERNS_V
VIEW - APPS.GMS_FUNDSCTL_RES_V
VIEW - APPS.GMS_FUNDSCTL_V
VIEW - APPS.GMS_INSTALLMENTS_V
VIEW - APPS.GMS_IP_AWARD_LOV_V
VIEW - APPS.GMS_KEY_MEMBER_ROLE_V
VIEW - APPS.GMS_LOC_CONTACTS_V
VIEW - APPS.GMS_LOOKUPS
VIEW - APPS.GMS_NONE_BAL_V
VIEW - APPS.GMS_NOTIFICATIONS_V
VIEW - APPS.GMS_OPERATING_UNITS_V
VIEW - APPS.GMS_OVERRIDE_SCHEDULES_V
VIEW - APPS.GMS_PERSONNEL_V
VIEW - APPS.GMS_PHONE_CONTACTS_V
VIEW - APPS.GMS_PQH_AWARDS_V
VIEW - APPS.GMS_PQH_EXP_TYPES_V
VIEW - APPS.GMS_PQH_PROJECTS_V
VIEW - APPS.GMS_PROJECTS_BASIC_V
VIEW - APPS.GMS_PROJECTS_BURDEN_V
VIEW - APPS.GMS_PROJECTS_EXPEND_V
VIEW - APPS.GMS_PROJECTS_V
VIEW - APPS.GMS_PROJECT_FUNDINGS_V
VIEW - APPS.GMS_PROJECT_TYPES
VIEW - APPS.GMS_REFERENCE_NUMBERS_V
VIEW - APPS.GMS_REPORTS_V
VIEW - APPS.GMS_REPORT_TEMPLATES_V
VIEW - APPS.GMS_RESG_BAL_V
VIEW - APPS.GMS_RESG_BC_V
VIEW - APPS.GMS_RESG_V
VIEW - APPS.GMS_RES_V
VIEW - APPS.GMS_SSA_AWARDS_V
VIEW - APPS.GMS_SSA_AWARD_EXPTYPE_V
VIEW - APPS.GMS_STATUS_ACCUM_PROJECT_V
VIEW - APPS.GMS_STATUS_ACCUM_PROJ_BASE_V
VIEW - APPS.GMS_STATUS_ACCUM_TASK_BASE_V
VIEW - APPS.GMS_STATUS_ACTUALS_BASE1_V
VIEW - APPS.GMS_STATUS_ACTUALS_BASE2_V
VIEW - APPS.GMS_STATUS_ACTUALS_V
VIEW - APPS.GMS_STATUS_AWARD_ACCUM_BASE_V
VIEW - APPS.GMS_STATUS_AWARD_ACCUM_TASK_V
VIEW - APPS.GMS_STATUS_AWARD_ACCUM_V
VIEW - APPS.GMS_STATUS_COMMITMENTS_V
VIEW - APPS.GMS_STATUS_PROJ_GENERIC_V
VIEW - APPS.GMS_STATUS_RESOURCES_BASE_V
VIEW - APPS.GMS_STATUS_RESOURCES_V
VIEW - APPS.GMS_SUM_PRJ_FUNDINGS_V
VIEW - APPS.GMS_TASK_BAL_V
VIEW - APPS.GMS_TASK_BUDGETS2_V
VIEW - APPS.GMS_TASK_BUDGETS_V
VIEW - APPS.GMS_TASK_V
VIEW - APPS.GMS_TERMS_CONDITIONS_V
VIEW - APPS.GMS_XLA_AWARD_REF_V

Table: GMS_269_HISTORY

Description: Financial status report for an award
Primary Key: GMS_269_HISTORY_PK
  1. AWARD_ID
  2. VERSION
  3. STATUS_CODE
Comments

GMS_269_HISTORY stores the history of SF 269, which is a financial status report for a federal award. Each record is identified by an award identifier, version, and status code. Each record is a financial status report for an award for a reporting period.

Indexes
Index Type Tablespace Column
GMS_269_HISTORY_U1 NONUNIQUE APPS_TS_TX_IDX AWARD_ID
VERSION
Columns
Name Datatype Length Mandatory Comments
AWARD_ID NUMBER (15) Y Award identification number. Identifies award for which this report is generated.
VERSION NUMBER (15) Y Report version number. This is a system-generated running sequence number, which has a one-to-one relationship with the reporting period.
STATUS_CODE VARCHAR2 (1) Y Approval status of the report. D indicates Draft and F indicates Approved.
REPORT_CODE VARCHAR2 (10)
Report code. For future use.
REPORT_STATUS VARCHAR2 (1)
Report status indicates if the report is a final report or not. F indicates Final report and D indicates that it is not a final report.
CREATION_DATE DATE

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

Standard Who column
LAST_UPDATED_BY NUMBER (15)
Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
END_DATE DATE

End date of report. Not currently used.
DOCUMENT_NUMBER VARCHAR2 (30)
Identification number for the report document. Default value is the award number. Users can modify it to conform to their requirements.
ACCOUNTING_BASIS VARCHAR2 (1)
Accounting basis used for the report. Valid values are A for Accrual and C for Cash.
FUNDING_START_DATE DATE

Starting date of funding. Start date of the first installment of the award.
FUNDING_END_DATE DATE

End date of funding. End date installment is later than all the other installments of the award.
REPORT_PERIOD_START_DATE DATE

Start date of period for which this report is prepared
REPORT_PERIOD_END_DATE DATE

End date of period for which this report is prepared. Reporting periods cannot overlap.
TOTAL_OUTLAY NUMBER (22)
Total expenditure for this reporting period
CUM_TOTAL_OUTLAY NUMBER (22)
Cumulative expenditure from start of funding up to reporting period. Sum of the total outlay of this period and cumulative total outlay of previous period.
REFUND_REBATE NUMBER (22)
Receipts which are treated as reduction of expenditure, not as income, and excluded from total outlay during reporting period
CUM_REFUND_REBATE NUMBER (22)
Cumulative value of refund or rebate from start of funding up to reporting period
PROGRAM_INCOME NUMBER (22)
Program income amount used in accordance with deduction alternative
CUM_PROGRAM_INCOME NUMBER (22)
Cumulative value of program income from start of funding up to the reporting period
CONTRIBUTION NUMBER (22)
Contributions received from third parties during reporting period
CUM_CONTRIBUTION NUMBER (22)
Cumulative value of contributions from start of the funding up to reporting period
OTHER_FED_AWARD NUMBER (22)
Other federal awards authorized to be used to match reporting award
CUM_OTHER_FED_AWARD NUMBER (22)
Cumulative value of other federal awards from start of the funding up to reporting period
PROG_INCOME_MATCH NUMBER (22)
Program income used in accordance with the matching or cost sharing alternative
CUM_PROG_INCOME_MATCH NUMBER (22)
Cumulative value of program income match
OTHER_REC_OUTLAY NUMBER (22)
Other recipient share of net outlays
CUM_OTHER_REC_OUTLAY NUMBER (22)
Cumulative value of other recipient share of outlays from beginning of the award until reporting period
TOTAL_REC_OUTLAY NUMBER (22)
Total recipient share of net outlays. Sum of third party contribution, federal award authorized to match this award, program income used in accordance with matching criteria, and other recipient outlays.
CUM_TOTAL_REC_OUTLAY NUMBER (22)
Cumulative value of total recipient share of net outlays from beginning of the award until reporting period
CUM_UNLIQUID_OBLIGATION NUMBER (22)
Cumulative value of unliquidated obligations, including unliquidated obligations to subgrantees and contractors from beginning of the award until reporting period
CUM_RECIPIENT_OBLIGATION NUMBER (22)
Cumulative value of recipients' share of unliquidated obligations from beginning of the award until reporting period
CUM_PERIOD_FEDERAL_FUND NUMBER (22)
Cumulative value of the federal fund during reporting period. Sum of installment amounts eligible during this period.
CUM_PROGRAM_INCOME_ADDITION NUMBER (22)
Disbursed program income using the addition alternative
CUM_PROGRAM_INCOME_UNUSED NUMBER (22)
Undisbursed program income
RATE_TYPE VARCHAR2 (30)
Rate type used for overhead costs. Valid values are Predetermined, Provisional, Final, and Fixed.
INDIRECT_COST_RATE NUMBER (22)
Indirect cost rate used for calculating overhead costs
ALLOWED_COST_BASE NUMBER (22)
Cost base used as the base for calculating overhead cost
FEDERAL_IDC_SHARE NUMBER (22)
Federal share of overhead or indirect cost
REMARKS VARCHAR2 (2000)
Remarks or special notes for this report

[top of page]

GMS.GMS_269_HISTORY does not reference any database object

GMS.GMS_269_HISTORY is referenced by following:

GMS
VIEW - GMS_269_HISTORY#

[top of page]

Table: GMS_270_HISTORY

Description: Financial status report for an award
Comments

GMS_270_HISTORY stores the history of SF 270, which is a financial status report for a federal award.

Indexes
Index Type Tablespace Column
GMS_270_HISTORY_U1 UNIQUE APPS_TS_TX_IDX AWARD_ID
VERSION
STATUS_CODE
Columns
Name Datatype Length Mandatory Comments
AWARD_ID NUMBER (15) Y Award identification number. Identifies award for which this report is generated.
VERSION NUMBER (15) Y Version number of report. System-generated running sequence number, which has a one-to-one relationship with the reporting period.
STATUS_CODE VARCHAR2 (1) Y Report approval status. D indicates Draft and F indicates Final.
RUN_DATE DATE

Date report run
DOCUMENT_NUMBER VARCHAR2 (30)
Identification number for report document. The default value is the award number. Users can modify to conform to their requirements.
ACCOUNTING_BASIS VARCHAR2 (1) Y Accounting basis used for report. Valid values include A for Accrual and C for Cash.
PAYMENT_TYPE VARCHAR2 (1) Y Payment types include advance or reimbursement.
PAYMENT_SCHEDULE VARCHAR2 (1) Y Payment schedules are final or partial.
REPORT_START_DATE DATE

Start date of period for which report is prepared
REPORT_END_DATE DATE

End date of period for which report is prepared. Reporting periods cannot overlap.
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
TOT_PRG_OUTLAY NUMBER (22)
Total expenditures for reporting period
CUM_PRG_INCOME NUMBER (22)
Program income received to date. User-defined field.
NET_CASH_OUTLAY NUMBER (22)
User-defined field. Total estimated amount of cash outlays that are to be made during period covered by the advance.
NON_FED_SHARE NUMBER (22)
Nonfederal share of the sum of net cash outlays and net program outlays
PAYEE_ADDRESS_ID NUMBER

Payee address identifier
REMARKS VARCHAR2 (2000)
Remarks or special notes for this report
PAYEE_ADDRESS VARCHAR2 (1000)
Payee Address, to which checks need to be sent.
PAYEE_NAME VARCHAR2 (240)
Name of Payee

[top of page]

GMS.GMS_270_HISTORY does not reference any database object

GMS.GMS_270_HISTORY is referenced by following:

GMS
VIEW - GMS_270_HISTORY#

[top of page]

Table: GMS_272_HISTORY

Description: Federal cash transaction report
Primary Key: GMS_272_HISTORY_PK
  1. AWARD_ID
  2. VERSION
  3. STATUS_CODE
Comments

GMS_272_HISTORY stores the history of SF 272, which is a federal cash transaction report.

Indexes
Index Type Tablespace Column
GMS_272_HISTORY_UK1 UNIQUE APPS_TS_TX_IDX AWARD_ID
VERSION
STATUS_CODE
Columns
Name Datatype Length Mandatory Comments
AWARD_ID NUMBER (15) Y Award identification number. Identifies the award for which this report is generated.
VERSION NUMBER (15) Y Report version number. System-generated running sequence number, that has a one-to-one relationship with reporting period.
STATUS_CODE VARCHAR2 (1) Y Report approval status. D indicates Draft and F indicates Approved.
CREATION_DATE DATE

Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER (15)
Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
DOCUMENT_NUMBER VARCHAR2 (30)
Identification number for report document. Default value is the award number. Users can modify to conform to their requirements.
RUN_DATE DATE

Date report run
REPORT_START_DATE DATE

Report start date
REPORT_END_DATE DATE

Report end date
LETTER_OF_CREDIT VARCHAR2 (15)
Letter of credit number
LAST_PAYMENT_VOUCHER_NUMBER NUMBER

Last payment voucher number
PAYMENT_VOUCHER_CREDIT NUMBER (15)
Payment vouchers credited to account
TREASURY_CHECK NUMBER

Treasury checks received, whether or not deposited
CASH_IN_HAND_BEGIN NUMBER (22)
Cash in hand at beginning of reporting period
LETTER_OF_CREDIT_WITHDRAWLS NUMBER (22)
Letter of credit withdrawals
TREASURY_CHECK_PAYMENTS NUMBER (15)
Treasury check payments
TOTAL_RECEIPTS NUMBER (22)
Total receipts. Sum of letter of credit withdrawals and Treasury check payments.
TOTAL_CASH_AVAIABLE NUMBER (22)
Total cash available. Sum of cash in hand at beginning of reporting period and total receipts.
GROSS_DISBURSEMENTS NUMBER (22)
Gross disbursements
FEDERAL_SHARE_INCOME NUMBER (22)
Federal share of program income
NET_DISBURSEMENTS NUMBER (22)
Net disbursements. Gross disbursements, federal share of program income.
ADJUSTMENTS_PRIOR_PERIODS NUMBER (22)
Adjustments of prior periods
CASH_IN_HAND_END NUMBER (22)
Cash in hand at end of period
DAYS NUMBER

Number of days
INTEREST_INCOME NUMBER (22)
Interest income
ADV_TO_SUBGRANTEES NUMBER (22)
Advances to subgrantees or subcontractors
REMARKS VARCHAR2 (2000)
Remarks
CREATED_BY NUMBER (15)
Standard Who column

[top of page]

GMS.GMS_272_HISTORY does not reference any database object

GMS.GMS_272_HISTORY is referenced by following:

GMS
VIEW - GMS_272_HISTORY#

[top of page]

Table: GMS_ALLOWABILITY_SCHEDULES

Description: Cost allowability schedules
Comments

GMS_ALLOWABILITY_SCHEDULES holds cost allowability schedule information. An allowability schedule, when attached to an award, dictates what expenditure types are allowable for an award and what the limits for indirect cost are on each of the allowable expenditure types.

Indexes
Index Type Tablespace Column
GMS_ALLOWABILITY_SCHEDULES_U1 UNIQUE APPS_TS_SEED ALLOWABILITY_SCHEDULE_ID
GMS_ALLOWABILITY_SCHEDULES_U2 UNIQUE APPS_TS_SEED ALLOW_SCH_NAME
Columns
Name Datatype Length Mandatory Comments
ALLOWABILITY_SCHEDULE_ID NUMBER (15) Y Allowability schedule unique identifier
ALLOW_SCH_NAME VARCHAR2 (30) Y Allowability schedule name
DESCRIPTION VARCHAR2 (240)
Allowability schedule description
START_DATE_ACTIVE DATE
Y Allowability schedule start date
END_DATE_ACTIVE DATE

Allowability schedule end 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

[top of page]

GMS.GMS_ALLOWABILITY_SCHEDULES does not reference any database object

GMS.GMS_ALLOWABILITY_SCHEDULES is referenced by following:

GMS
VIEW - GMS_ALLOWABILITY_SCHEDULES#

[top of page]

Table: GMS_ALLOWABLE_EXPENDITURES

Description: Allowable expenditures of cost allowability schedule
Primary Key: GMS_ALLOWABLE_EXPENDITURES_PK
  1. ALLOWABILITY_SCHEDULE_ID
  2. EXPENDITURE_TYPE
Comments

GMS_ALLOWABLE_EXPENDITURES stores information about what expenditure types are allowed for a particular schedule and what the burden limits are for those expenditure types.

Indexes
Index Type Tablespace Column
GMS_ALLOWABLE_EXPENDITURES_U1 UNIQUE APPS_TS_SEED ALLOWABILITY_SCHEDULE_ID
EXPENDITURE_TYPE
Columns
Name Datatype Length Mandatory Comments
ALLOWABILITY_SCHEDULE_ID NUMBER (15) Y Foreign key from GMS_ALLOWABILITY_SCHEDULES. The schedule identifier for which allowable expenditure types are to be defined.
EXPENDITURE_TYPE VARCHAR2 (30) Y Allowable expenditure type for this schedule. Foreign key from PA_EXPENDITURE_TYPES.
BURDEN_COST_LIMIT NUMBER (22)
Amount of raw cost of that expenditure type, up to which burden cost can be charged
BURDEN_COST_LIMIT_PCT NUMBER (22)
Percentage of raw cost of that expenditure type, up to which burden cost can be calculated. Not currently 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
MTDC_EXEMPT_FLAG VARCHAR2 (1)
Indicates whether expenditure type is exempted from Modified Total Direct Cost, MTDC, or not. Y indicates Exempted and N indicates Not Exempted.

[top of page]

GMS.GMS_ALLOWABLE_EXPENDITURES does not reference any database object

GMS.GMS_ALLOWABLE_EXPENDITURES is referenced by following:

GMS
VIEW - GMS_ALLOWABLE_EXPENDITURES#

[top of page]

Table: GMS_AWARDS_ALL

Description: Information about awards
Foreign Keys from this table:
Foreign Key Column Foreign Table
GMS_AWARDS_ALL.IDC_SCHEDULE_ID PA_IND_RATE_SCHEDULES_ALL_BG
GMS_AWARDS_ALL.AWARD_PROJECT_ID PA_PROJECTS_ALL
Comments

GMS_AWARDS_ALL stores the higest level of information about grants received from a funding agency for execution of projects, including the rules for billing and revenue generation, and terms and conditions associated with the award. Users can maintain the indirect cost rates, cost allowability, billing and revenue generation rules, and workflow controls for various notifications.
This table also maintains award template information.

Indexes
Index Type Tablespace Column
GMS_AWARDS_U1 UNIQUE APPS_TS_TX_IDX AWARD_ID
GMS_AWARDS_U2 UNIQUE APPS_TS_TX_IDX AWARD_NUMBER
GMS_AWARDS_U3 NONUNIQUE APPS_TS_TX_IDX AWARD_PROJECT_ID
Columns
Name Datatype Length Mandatory Comments
AWARD_ID NUMBER (15) Y Unique identifier for an award. Primary key.
AWARD_NUMBER VARCHAR2 (15) Y Number input by user to identify the award
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
AWARD_SHORT_NAME VARCHAR2 (30) Y Award short name
AWARD_FULL_NAME VARCHAR2 (240)
Award full name
FUNDING_SOURCE_ID NUMBER (15)
Identifier for funding source that originates the award
START_DATE_ACTIVE DATE

First effective date of award
END_DATE_ACTIVE DATE

Last effective date of award
CLOSE_DATE DATE

Close date of award
FUNDING_SOURCE_AWARD_NUMBER VARCHAR2 (30)
Award number from funding source
AWARD_PURPOSE_CODE VARCHAR2 (30)
Award code which describes the purpose of an award
STATUS VARCHAR2 (30)
Award status
ALLOWABLE_SCHEDULE_ID NUMBER (15)
Identifier for allowable schedule of the award
IDC_SCHEDULE_ID NUMBER (15)
Identifier for indirect cost rate schedule of the award
REVENUE_DISTRIBUTION_RULE VARCHAR2 (30)
Revenue distribution rule for the award. Values are Cost or Event.
BILLING_FREQUENCY VARCHAR2 (30)
Award billing frequency
BILLING_DISTRIBUTION_RULE VARCHAR2 (30)
Billing distribution rule for the award. Values are Cost or Event.
BILLING_FORMAT VARCHAR2 (30)
Printing option for the invoice generated. Possible values are: NO_PRINT ( No Print), PRINT_INVOICE ( Print Invoice), EDI ( Electronic Data Interface), LOC ( Letter of Credit Drawdown) , AGENCY ( Agency Specific form)
BILLING_TERM NUMBER (15)
Award billing term
AWARD_PROJECT_ID NUMBER (15)
Award project identifier
AGREEMENT_ID NUMBER (15)
Identifier of agreement that binds to the award
AWARD_TEMPLATE_FLAG VARCHAR2 (10)
Indicates if record is an award template or an award. Immediate indicates an award template and Deferred indicates an award.
PREAWARD_DATE DATE

Pre-award date
AWARD_MANAGER_ID NUMBER (15)
No longer used
REQUEST_ID NUMBER (15)
Standard Who column
PROGRAM_APPLICATION_ID NUMBER (15)
Standard Who column
PROGRAM_ID NUMBER (15)
Standard Who column
PROGRAM_UPDATE_DATE DATE

Standard Who column
AGENCY_SPECIFIC_FORM VARCHAR2 (60)
Agency specified form name for billing format
BILL_TO_CUSTOMER_ID NUMBER (15)
Identifier of the bill-to-customer that is used in billing format
TRANSACTION_NUMBER VARCHAR2 (60)
Used in billing format
AMOUNT_TYPE VARCHAR2 (4)
Amount type for budgetary control. PTD indicates Period to Date, PJTD indicates Project to Date, and YTD indicates Year to Date.
BOUNDARY_CODE VARCHAR2 (2)
Boundary code for budgetary control. Y indicates Year, P indicates Period, and PJ indicates Project.
FUND_CONTROL_LEVEL_AWARD VARCHAR2 (30)
B indicates Absolute, D indicates Advisory, and N indicates None.
FUND_CONTROL_LEVEL_TASK VARCHAR2 (30)
B indicates Absolute, D indicates Advisory, and N indicates None.
FUND_CONTROL_LEVEL_RES_GRP VARCHAR2 (30)
B indicates Absolute, D indicates Advisory, and N indicates None.
FUND_CONTROL_LEVEL_RES VARCHAR2 (30)
B indicates Absolute, D indicates Advisory, and N indicates None.
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
TEMPLATE_START_DATE_ACTIVE DATE

Start date from which template is active
TEMPLATE_END_DATE_ACTIVE DATE

End date to which template is active
TYPE VARCHAR2 (30)
Award type
ORG_ID NUMBER (15)
Operating unit identifier for multiple organization
COST_IND_SCH_FIXED_DATE DATE

Fixed date for indirect cost rate schedule
LABOR_INVOICE_FORMAT_ID NUMBER (15)
Labor invoice format identifier
NON_LABOR_INVOICE_FORMAT_ID NUMBER (15)
Non-labor invoice format identifier
BILL_TO_ADDRESS_ID NUMBER (15)
Billing address identifier for customer
SHIP_TO_ADDRESS_ID NUMBER (15)
Shipping address identifier for customer
LOC_BILL_TO_ADDRESS_ID NUMBER (15)
Billing address identifier for letter of credit customer
LOC_SHIP_TO_ADDRESS_ID NUMBER

Shipping address identifier for letter of credit customer
AWARD_ORGANIZATION_ID NUMBER (15)
Award organization identifier
HARD_LIMIT_FLAG VARCHAR2 (1) Y Flag indicating whether revenue for projects funded by this award can exceed the allocated funding amount
BILLING_OFFSET NUMBER (15)
Number of days that elapse between the award start date and the date of the award's first invoice
BILLING_CYCLE_ID NUMBER (15)
Descriptive name of the billing cycle
BUDGET_WF_ENABLED_FLAG VARCHAR2 (1)
Flag indicates whether workflow is enabled for budget baselining, reports notification, and installment activation for an award.
PROPOSAL_ID NUMBER (15)
Grants Proposal identifier from which an award is created. This column links a proposal in Oracle Grants Proposal to an award in Oracle Grants Accounting.
ATTRIBUTE16 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE17 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE18 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE19 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE20 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE21 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE22 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE23 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE24 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE25 VARCHAR2 (150)
Descriptive Flexfield segment column
INVOICE_LIMIT_FLAG VARCHAR2 (1) Y Flag indicates whether invoice for projects funded by this award can exceed the allocated funding amount

[top of page]

GMS.GMS_AWARDS_ALL does not reference any database object

GMS.GMS_AWARDS_ALL is referenced by following:

GMS
VIEW - GMS_AWARDS_ALL#
- GMS_AWARDS_ALL#

[top of page]

Table: GMS_AWARDS_CONTACTS

Description: Contacts of award
Comments

GMS_AWARDS_CONTACTS stores information about the contacts of an award.

Indexes
Index Type Tablespace Column
GMS_AWARDS_CONTACTS_U1 UNIQUE APPS_TS_TX_IDX AWARD_ID
CONTACT_ID
CUSTOMER_ID
USAGE_CODE
Columns
Name Datatype Length Mandatory Comments
AWARD_ID NUMBER (15) Y Award identifier
CONTACT_ID NUMBER (15) Y Contact identifier
CUSTOMER_ID NUMBER (15)
Unique identifier of customer that issued this award
PRIMARY_FLAG VARCHAR2 (1)
Indicates whether contact is primary or not
USAGE_CODE VARCHAR2 (30)
Contact usage 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]

GMS.GMS_AWARDS_CONTACTS does not reference any database object

GMS.GMS_AWARDS_CONTACTS is referenced by following:

GMS
VIEW - GMS_AWARDS_CONTACTS#

[top of page]

Table: GMS_AWARDS_TERMS_CONDITIONS

Description: Terms and conditions of award
Comments

GMS_AWARDS_TERMS_CONDITIONS stores information about terms and conditions associated with an award.

Indexes
Index Type Tablespace Column
GMS_AWARDS_TERMS_CONDITIONS_U1 UNIQUE APPS_TS_TX_IDX AWARD_ID
CATEGORY_ID
TERM_ID
Columns
Name Datatype Length Mandatory Comments
AWARD_ID NUMBER (15) Y Award identifier
CATEGORY_ID NUMBER (15) Y Category identifier
TERM_ID NUMBER (15) Y Term 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
OPERAND VARCHAR2 (30)
Operand can be less than, greater than, equal to, not equal to, or N/A
VALUE NUMBER (15)
Value for corresponding terms and conditions

[top of page]

GMS.GMS_AWARDS_TERMS_CONDITIONS does not reference any database object

GMS.GMS_AWARDS_TERMS_CONDITIONS is referenced by following:

GMS
VIEW - GMS_AWARDS_TERMS_CONDITIONS#

[top of page]

Table: GMS_AWARD_DISTRIBUTIONS

Description: Distribution lines for requisitions, purchase orders, invoices, encumbrances, and Project expenditures charged to awards
Foreign Keys from this table:
Foreign Key Column Foreign Table
GMS_AWARD_DISTRIBUTIONS.DISTRIBUTION_ID PO_REQ_DISTRIBUTIONS_ALL
GMS_AWARD_DISTRIBUTIONS.PO_DISTRIBUTION_ID PO_DISTRIBUTIONS_ALL
Comments

GMS_AWARD_DISTRIBUTIONS stores distribution lines for requisitions, purchase orders, invoices, encumbrances, and Project expenditure items charged to awards.

Indexes
Index Type Tablespace Column
GMS_AWARD_DISTRIBUTIONS_U1 UNIQUE APPS_TS_TX_IDX AWARD_SET_ID
ADL_LINE_NUM
GMS_AWARD_DISTRIBUTIONS_N1 NONUNIQUE APPS_TS_TX_IDX EXPENDITURE_ITEM_ID
ADL_LINE_NUM
DOCUMENT_TYPE
ADL_STATUS
GMS_AWARD_DISTRIBUTIONS_N2 NONUNIQUE APPS_TS_TX_IDX INVOICE_ID
INVOICE_DISTRIBUTION_ID
DISTRIBUTION_LINE_NUMBER
GMS_AWARD_DISTRIBUTIONS_N3 NONUNIQUE APPS_TS_TX_IDX DISTRIBUTION_ID
GMS_AWARD_DISTRIBUTIONS_N4 NONUNIQUE APPS_TS_TX_IDX PO_DISTRIBUTION_ID
GMS_AWARD_DISTRIBUTIONS_N5 NONUNIQUE APPS_TS_TX_IDX INVOICE_DISTRIBUTION_ID
GMS_AWARD_DISTRIBUTIONS_N6 NONUNIQUE APPS_TS_TX_IDX AWARD_ID
PROJECT_ID
DOCUMENT_TYPE
GMS_AWARD_DISTRIBUTIONS_N7 NONUNIQUE APPS_TS_TX_IDX AWARD_ID
DOCUMENT_TYPE
REVENUE_DISTRIBUTED_FLAG
FC_STATUS
BILLABLE_FLAG
GMS_AWARD_DISTRIBUTIONS_N8 NONUNIQUE APPS_TS_TX_IDX AWARD_ID
DOCUMENT_TYPE
FC_STATUS
BILLED_FLAG
BILLABLE_FLAG
COST_DISTRIBUTED_FLAG
ADL_STATUS
GMS_AWARD_DISTRIBUTIONS_N9 NONUNIQUE APPS_TS_TX_IDX IND_COMPILED_SET_ID
Columns
Name Datatype Length Mandatory Comments
AWARD_SET_ID NUMBER (15) Y System generated number for a distribution set
ADL_LINE_NUM NUMBER (15) Y Sequence number of a distribution within a distribution set
FUNDING_PATTERN_ID NUMBER (15)
Identifier of funding pattern used for generating the distribution set
DISTRIBUTION_VALUE NUMBER (3)
Distribution value is the percentage of the funding distribution.
RAW_COST NUMBER (22)
Raw cost of the source transaction
DOCUMENT_TYPE VARCHAR2 (3) Y Source document type of transactions
PROJECT_ID NUMBER (15)
Project identifier for the distribution
TASK_ID NUMBER (15)
Task identifier for the distribution
AWARD_ID NUMBER (15) Y Award identifier of the award to which the distribution is assigned
EXPENDITURE_ITEM_ID NUMBER (15)
Expenditure item identifier or encumbrance item identifier of the source transaction
CDL_LINE_NUM NUMBER (15)
Sequential number that identifies the cost distribution line for an expenditure item
IND_COMPILED_SET_ID NUMBER (15)
Identifier of the compiled set that is used to calculate the burden cost
GL_DATE DATE

End date of General Ledger accounting period to which cost is posted
REQUEST_ID NUMBER (15)
Standard Who column
LINE_NUM_REVERSED NUMBER (15)
Distribution line number; reversed by this distribution line
RESOURCE_LIST_MEMBER_ID NUMBER (15)
Resource list member identifier to which the distribution is mapped to for fundschecking purpose
OUTPUT_VAT_TAX_ID NUMBER

OUTPUT_TAX_EXEMPT_FLAG VARCHAR2 (1)
Indicates whether the distribution is exempt from tax
OUTPUT_TAX_EXEMPT_REASON_CODE VARCHAR2 (30)
Tax exemption reason code
OUTPUT_TAX_EXEMPT_NUMBER VARCHAR2 (80)
Tax exemption number
ADL_STATUS VARCHAR2 (3)
Status of the distribution. A is for Active; I is for Invalid.
FC_STATUS VARCHAR2 (1)
Flag indicating the fundscheck status of the distribution. A is for Approved; R is for Rejected; and P is for Pending.
LINE_TYPE VARCHAR2 (1)
Indicates the distribution; represents raw cost or burden cost line. R is for R and B is for Burden.
CAPITALIZED_FLAG VARCHAR2 (1)
Indicates whether distribution has been capitalized
CAPITALIZABLE_FLAG VARCHAR2 (1)
Indicates capitalizable status of this distribution
REVERSED_FLAG VARCHAR2 (1)
Reversed item identifier
REVENUE_DISTRIBUTED_FLAG VARCHAR2 (1)
Indicates revenue distributed status
BILLED_FLAG VARCHAR2 (1)
Indicates billed status
BILL_HOLD_FLAG VARCHAR2 (1)
For future use only
DISTRIBUTION_ID NUMBER (15)
Requisition distribution unique identifier
PO_DISTRIBUTION_ID NUMBER (15)
Purchasing distribution unique identifier
INVOICE_DISTRIBUTION_ID NUMBER (15)
Invoice identifier
PARENT_AWARD_SET_ID NUMBER (15)
Parent distribution set identifier used for tracking reversed distributions
INVOICE_ID NUMBER (15)
Invoice identifier for the distribution
PARENT_ADL_LINE_NUM NUMBER (15)
Parent distribution line number used for tracking reversed distributions
DISTRIBUTION_LINE_NUMBER NUMBER (15)
Invoice distribution line number for this record
BURDENABLE_RAW_COST NUMBER

Part of the raw cost used for calculating burden cost
COST_DISTRIBUTED_FLAG VARCHAR2 (1)
Indicates whether the item has been cost distributed. N indicates the item is marked for cost distribution. When the item is cost distributed, the flag is set to Y.
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
BUD_TASK_ID NUMBER (15)
Budgeted task identifier of the distribution
BILLABLE_FLAG VARCHAR2 (1)
Billable flag. Used by Revenue or Invoice generation. Status of this flag mapped to corresponding cost distribution line.
ACCUMULATED_FLAG VARCHAR2 (1)
Flag indicating whether the distribution has been posted in balances
OUTPUT_TAX_CLASSIFICATION_CODE VARCHAR2 (30)
Tax code used for Invoicing.
PAYMENT_STATUS_FLAG VARCHAR2 (1)
Flag that indicates if the Paid invoice Distribution in Cash Based Accounting has been fully relieved

[top of page]

GMS.GMS_AWARD_DISTRIBUTIONS does not reference any database object

GMS.GMS_AWARD_DISTRIBUTIONS is referenced by following:

GMS
VIEW - GMS_AWARD_DISTRIBUTIONS#

[top of page]

Table: GMS_AWARD_EXP_TYPE_ACT_COST

Description: Actual expense incurred for an award by expenditure type
Primary Key: GMS_AWARD_EXP_TYPE_ACT_COST_PK
  1. AWARD_ID
  2. EXPENDITURE_TYPE
Foreign Keys from this table:
Foreign Key Column Foreign Table
GMS_AWARD_EXP_TYPE_ACT_COST.EXPENDITURE_TYPE PA_EXPENDITURE_TYPES
Comments

GMS_AWARD_EXP_TYPE_ACT_COST stores the cumulative raw expenditure amount for an award and expenditure type. This table is used for applying limits on burdening by award and expenditure type.

Indexes
Index Type Tablespace Column
GMS_AWARD_EXP_TYPE_ACT_COST_N1 NONUNIQUE APPS_TS_TX_IDX AWARD_ID
EXPENDITURE_TYPE
Columns
Name Datatype Length Mandatory Comments
AWARD_ID NUMBER (15) Y Award identifier for which current actual expenditure amount is maintained
EXPENDITURE_TYPE VARCHAR2 (30) Y Expenditure type for which current actual expenditure amount is maintained
REQ_RAW_COST NUMBER
Y REQ cumulative expenditure amount for an award and expenditure type up to current date
PO_RAW_COST NUMBER

PO cumulative expenditure amount for an award and expenditure type up to current date
ENC_RAW_COST NUMBER

ENC cumulative expenditure amount for an award and expenditure type up to current date
AP_RAW_COST NUMBER

AP cumulative expenditure amount for an award and expenditure type up to current date
EXP_RAW_COST NUMBER

EXP cumulative expenditure amount for an award and expenditure type up to current date
REQ_BURDENABLE_COST NUMBER

REQ cumulative burdenable amount for an award and expenditure type up to current date
PO_BURDENABLE_COST NUMBER

PO cumulative burdenable amount for an award and expenditure type up to current date
ENC_BURDENABLE_COST NUMBER

ENC cumulative burdenable amount for an award and expenditure type up to current date
AP_BURDENABLE_COST NUMBER

AP cumulative burdenable amount for an award and expenditure type up to current date
EXP_BURDENABLE_COST NUMBER

EXP cumulative burdenable amount for an award and expenditure type up to current date
CREATED_BY NUMBER (15) Y Standard Who column
CREATED_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column

[top of page]

GMS.GMS_AWARD_EXP_TYPE_ACT_COST does not reference any database object

GMS.GMS_AWARD_EXP_TYPE_ACT_COST is referenced by following:

GMS
VIEW - GMS_AWARD_EXP_TYPE_ACT_COST#

[top of page]

Table: GMS_BALANCES

Description: Balance of budgets, actual costs, and encumbrance costs
Foreign Keys from this table:
Foreign Key Column Foreign Table
GMS_BALANCES.PROJECT_ID PA_PROJECTS_ALL
GMS_BALANCES.TASK_ID PA_TASKS
GMS_BALANCES.RESOURCE_LIST_MEMBER_ID PA_RESOURCE_LIST_MEMBERS
GMS_BALANCES.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS_11I
GMS_BALANCES.BUDGET_VERSION_ID PA_BUDGET_VERSIONS
GMS_BALANCES.PARENT_MEMBER_ID PA_RESOURCE_LIST_MEMBERS
Comments

GMS_BALANCES stores actual, budget, and encumbrance balance per project, task, award, period, budget version, and resource. Budget lines are created during the budget baseline process. Actual, encumbrance, and revenue records are created by the update actual and encumbrance balance process.

Indexes
Index Type Tablespace Column
GMS_BALANCES_U1 UNIQUE APPS_TS_TX_IDX PROJECT_ID
AWARD_ID
TASK_ID
SET_OF_BOOKS_ID
BUDGET_VERSION_ID
RESOURCE_LIST_MEMBER_ID
BALANCE_TYPE
START_DATE
END_DATE
GMS_BALANCES_N1 NONUNIQUE APPS_TS_TX_IDX BUDGET_VERSION_ID
TASK_ID
RESOURCE_LIST_MEMBER_ID
Columns
Name Datatype Length Mandatory Comments
PROJECT_ID NUMBER (15) Y Project defining column
TASK_ID NUMBER (15) Y Task defining column
AWARD_ID NUMBER (15) Y Award defining column
RESOURCE_LIST_MEMBER_ID NUMBER (15) Y Resource list member defining column
SET_OF_BOOKS_ID NUMBER (15) Y Accounting books defining column
BUDGET_VERSION_ID NUMBER (15) Y Budget version
START_DATE DATE
Y Accounting period start date
END_DATE DATE
Y Accounting period end date
BALANCE_TYPE VARCHAR2 (3) Y Balance type indicates the balance is for any of the following categories. BGT (budget), REQ (Requisition), PO (Purchase Order), AP (Supplier invoice), EXP (expenditure) ENC (encumbrance), REV (Revenue).
TOP_TASK_ID NUMBER (15)
Top task identifier for task level balances
PARENT_MEMBER_ID NUMBER (15)
Parent member defining column
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
PERIOD_NAME VARCHAR2 (15)
Accounting period name
ACTUAL_PERIOD_TO_DATE NUMBER

Actuals period to date
REVENUE_PERIOD_TO_DATE NUMBER

Revenue period to date
BUDGET_PERIOD_TO_DATE NUMBER

Budget period to date
ENCUMB_PERIOD_TO_DATE NUMBER

Encumbrances period to date

[top of page]

GMS.GMS_BALANCES does not reference any database object

GMS.GMS_BALANCES is referenced by following:

GMS
VIEW - GMS_BALANCES#

[top of page]

Table: GMS_BC_PACKETS

Description: Budgetary control packets for funds checking
Foreign Keys from this table:
Foreign Key Column Foreign Table
GMS_BC_PACKETS.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS_11I
GMS_BC_PACKETS.EXPENDITURE_TYPE PA_EXPENDITURE_TYPES
GMS_BC_PACKETS.PROJECT_ID PA_PROJECTS_ALL
GMS_BC_PACKETS.TASK_ID PA_TASKS
GMS_BC_PACKETS.TOP_TASK_ID PA_TASKS
Comments

GMS_BC_PACKETS is Oracle Grants Accounting's main table for the budgetary control feature. This table stores the budgetary control packets that need to be approved before creating journal entries. A budgetary control packet contains information about a set of transactions to be approved before entering it into the system. The funds check program evaluates these packets and updates the RESULT_CODE column in GMS_BC_PACKETS with a lookup code signifying the result of the funds check. Once a packet passes its funds check and the balances are updated in GMS_BALANCES, the packet is removed from GMS_BC_PACKETS.

Indexes
Index Type Tablespace Column
GMS_BC_PACKETS_U1 UNIQUE APPS_TS_TX_IDX BC_PACKET_ID
GMS_BC_PACKETS_N1 NONUNIQUE APPS_TS_TX_IDX PACKET_ID
PROJECT_ID
AWARD_ID
TASK_ID
GMS_BC_PACKETS_N10 NONUNIQUE APPS_TS_TX_IDX PACKET_ID
ADJUSTED_DOCUMENT_HEADER_ID
GMS_BC_PACKETS_N11 NONUNIQUE APPS_TS_TX_IDX DOCUMENT_TYPE
DOCUMENT_HEADER_ID
GMS_BC_PACKETS_N12 NONUNIQUE APPS_TS_TX_IDX STATUS_CODE
GMS_BC_PACKETS_N13 NONUNIQUE APPS_TS_TX_IDX SOURCE_EVENT_ID
GMS_BC_PACKETS_N2 NONUNIQUE APPS_TS_TX_IDX BUDGET_VERSION_ID
PACKET_ID
STATUS_CODE
GMS_BC_PACKETS_N3 NONUNIQUE APPS_TS_TX_IDX PARENT_BC_PACKET_ID
GMS_BC_PACKETS_N4 NONUNIQUE APPS_TS_TX_IDX PACKET_ID
DOCUMENT_HEADER_ID
DOCUMENT_DISTRIBUTION_ID
DOCUMENT_TYPE
GMS_BC_PACKETS_N5 NONUNIQUE APPS_TS_TX_IDX PACKET_ID
STATUS_CODE
EFFECT_ON_FUNDS_CODE
GMS_BC_PACKETS_N6 NONUNIQUE APPS_TS_TX_IDX PACKET_ID
BUD_TASK_ID
GMS_BC_PACKETS_N7 NONUNIQUE APPS_TS_TX_IDX PROJECT_ID
TASK_ID
GMS_BC_PACKETS_N8 NONUNIQUE APPS_TS_TX_IDX AWARD_ID
EXPENDITURE_TYPE
STATUS_CODE
BURDEN_CALCULATION_SEQ
GMS_BC_PACKETS_N9 NONUNIQUE APPS_TS_TX_IDX REQUEST_ID
Columns
Name Datatype Length Mandatory Comments
PACKET_ID NUMBER (15) Y Budgetary control packet defining column
PROJECT_ID NUMBER (15) Y Project defining column
AWARD_ID NUMBER (15) Y Award defining column
TASK_ID NUMBER (15) Y Task defining column
EXPENDITURE_TYPE VARCHAR2 (30) Y Expenditure type defining column
EXPENDITURE_ITEM_DATE DATE
Y Expenditure item date for the expenditure
ACTUAL_FLAG VARCHAR2 (1) Y Balance type. Valid values are A indicates Actual, B indicates Budget, or E indicates Encumbrance.
STATUS_CODE VARCHAR2 (1) Y Funds check or reservation status
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
SET_OF_BOOKS_ID NUMBER (15) Y Accounting books defining column
JE_CATEGORY_NAME VARCHAR2 (30) Y Journal entry category name
JE_SOURCE_NAME VARCHAR2 (30) Y Journal entry source name
TRANSFERED_FLAG VARCHAR2 (1) Y Not currently used
DOCUMENT_TYPE VARCHAR2 (3) Y Document type defining column. Possible values are REQ, PO, Payables, or Project Accounting.
EXPENDITURE_ORGANIZATION_ID NUMBER (15)
Organization-incurred expenditure
PERIOD_NAME VARCHAR2 (15)
Accounting period
PERIOD_YEAR NUMBER (15)
Accounting period year
PERIOD_NUM NUMBER (15)
Accounting period number
DOCUMENT_HEADER_ID NUMBER (15)
Document header defining column
DOCUMENT_DISTRIBUTION_ID NUMBER (15)
Document distribution defining column
TOP_TASK_ID NUMBER (15)
Top task defining column
PARENT_RESOURCE_ID NUMBER (15)
Parent task defining column
BUDGET_VERSION_ID NUMBER (15)
Budget version
RESOURCE_LIST_MEMBER_ID NUMBER (15)
Resource list member defining column
ACCOUNT_TYPE VARCHAR2 (1)
Oracle Public Sector General Ledger account type
ENTERED_DR NUMBER

Transaction debit amount in entered currency
ENTERED_CR NUMBER

Transaction credit amount in entered currency
TOLERANCE_AMOUNT NUMBER

Allowable amount to exceed funding budget
TOLERANCE_PERCENTAGE NUMBER

Percentage of funding budget that can be increased
OVERRIDE_AMOUNT NUMBER

Maximum transaction amount that can be used to override a funds check
EFFECT_ON_FUNDS_CODE VARCHAR2 (1)
Increasing or decreasing effect of a transaction on funds available
RESULT_CODE VARCHAR2 (3)
Result of funds check or reservation
GL_BC_PACKETS_ROWID VARCHAR2 (30)
GL_BC_PACKETS row identifier defining column
AWARD_BUDGET_POSTED NUMBER

Award budget posted
AWARD_BUDGET_APPROVED NUMBER

Award budget approved
AWARD_BUDGET_PENDING NUMBER

Award budget pending
AWARD_ENC_POSTED NUMBER

Award encumbrance posted
AWARD_ENC_APPROVED NUMBER

Award encumbrance approved
AWARD_ENC_PENDING NUMBER

Award encumbrance pending
AWARD_ACTUAL_POSTED NUMBER

Award actuals posted
AWARD_ACTUAL_APPROVED NUMBER

Award actuals approved
AWARD_ACTUAL_PENDING NUMBER

Award actuals pending
AWARD_RESULT_CODE VARCHAR2 (3)
Result code of funds check at award level
TASK_BUDGET_POSTED NUMBER

Task budget posted
TASK_BUDGET_APPROVED NUMBER

Task budget approved
TASK_BUDGET_PENDING NUMBER

Task budget pending
TASK_ENC_POSTED NUMBER

Task encumbrances posted
TASK_ENC_APPROVED NUMBER

Task encumbrances approved
TASK_ENC_PENDING NUMBER

Task encumbrances pending
TASK_ACTUAL_POSTED NUMBER

Task actuals posted
TASK_ACTUAL_APPROVED NUMBER

Task actuals approved
TASK_ACTUAL_PENDING NUMBER

Task actuals pending
TASK_RESULT_CODE VARCHAR2 (3)
Result code of funds check at task level
RES_GRP_BUDGET_POSTED NUMBER

Resource group budget posted
RES_GRP_BUDGET_APPROVED NUMBER

Resource group budget approved
RES_GRP_BUDGET_PENDING NUMBER

Resource group budget pending
RES_GRP_ENC_POSTED NUMBER

Resource group encumbrances posted
RES_GRP_ENC_APPROVED NUMBER

Resource group encumbrances approved
RES_GRP_ENC_PENDING NUMBER

Resource group encumbrances pending
RES_GRP_ACTUAL_POSTED NUMBER

Resource group actuals posted
RES_GRP_ACTUAL_APPROVED NUMBER

Resource group actuals approved
RES_GRP_ACTUAL_PENDING NUMBER

Resource group actuals pending
RES_GRP_RESULT_CODE VARCHAR2 (3)
Result code of funds checker at resource group level
RES_BUDGET_POSTED NUMBER

Resource budget posted
RES_BUDGET_APPROVED NUMBER

Resource budget approved
RES_BUDGET_PENDING NUMBER

Resource budget pending
RES_ENC_POSTED NUMBER

Resource encumbrances posted
RES_ENC_APPROVED NUMBER

Resource encumbrances approved
RES_ENC_PENDING NUMBER

Resource encumbrances pending
RES_ACTUAL_POSTED NUMBER

Resource actuals posted
RES_ACTUAL_APPROVED NUMBER

Resource actuals approved
RES_ACTUAL_PENDING NUMBER

Resource actuals pending
RES_RESULT_CODE VARCHAR2 (3)
Result code of funds check at resource level
STATUS_FLAG VARCHAR2 (2)
Not currently used
RES_BUDGET_BAL NUMBER

Resource level budget balance after funds check
RES_GRP_BUDGET_BAL NUMBER

Resource group level budget balance after funds check
TASK_BUDGET_BAL NUMBER

Task level budget balance after funds check
TOP_TASK_BUDGET_BAL NUMBER

Top task level budget balance after funds check
AWARD_BUDGET_BAL NUMBER

Award level budget balance after funds check
GL_ROW_NUMBER NUMBER

GL_BC_PACKETS row sequence number
BC_PACKET_ID NUMBER

Bugetary control records unique identifier
PARENT_BC_PACKET_ID NUMBER

Raw budgetary control record, which the burdened budgetary control record is associated with
BURDENABLE_RAW_COST NUMBER

Amount of raw cost that is burdenable. Portion of raw cost that does not exceed maximum indirect base.
BUD_RESOURCE_LIST_MEMBER_ID NUMBER (15)
Resource list member identifier for the record
BUD_TASK_ID NUMBER (15)
Budgeted task identifier for the record
FUNDING_PATTERN_ID NUMBER (15)
Funding pattern identifier for the record
FUNDING_SEQUENCE NUMBER (15)
Sequence number within the funding pattern for the record
FP_STATUS VARCHAR2 (1)
Status of the funding pattern
R_FUNDS_CONTROL_LEVEL_CODE VARCHAR2 (1)
Funds control level code at resource level
RG_FUNDS_CONTROL_LEVEL_CODE VARCHAR2 (1)
Funds control level code at resource group level
T_FUNDS_CONTROL_LEVEL_CODE VARCHAR2 (1)
Funds control level code at task level
TT_FUNDS_CONTROL_LEVEL_CODE VARCHAR2 (1)
Funds control level code at top task level
A_FUNDS_CONTROL_LEVEL_CODE VARCHAR2 (1)
Funds control level code at award level
TOP_TASK_BUDGET_POSTED NUMBER

Posted budget balance at top task
TOP_TASK_BUDGET_APPROVED NUMBER

Budget balance at top task after approved transactions are posted
TOP_TASK_BUDGET_PENDING NUMBER

budget balance at top task after pending transactions
TOP_TASK_ENC_POSTED NUMBER

Encumbrance amount already posted at top task level
TOP_TASK_ENC_APPROVED NUMBER

Encumbrance amount approved but not posted at top task level
TOP_TASK_ENC_PENDING NUMBER

Encumbrance amount pending for approval at top task level
TOP_TASK_ACTUAL_POSTED NUMBER

Actual transaction amount already posted at top task level
TOP_TASK_ACTUAL_APPROVED NUMBER

Actual transaction amount already approved but not posted at top task level
TOP_TASK_ACTUAL_PENDING NUMBER

Actual transaction amount pending approval at top task level
TOP_TASK_RESULT_CODE VARCHAR2 (3)
Funds check result code at top task level
REQUEST_ID NUMBER (15)
Standard Who column
BALANCE_POSTED_FLAG VARCHAR2 (1)
Flag indicating the transaction updated in Grants Accounting balance
BURDEN_POSTED_FLAG VARCHAR2 (1)
Flag indicating the burden posted to balances and summary tables
BURDENED_COST NUMBER (22)
Burdened Cost
FUNDS_CHECK_SEQ NUMBER (15)
Funds check sequence
AMOUNT_TYPE VARCHAR2 (4)
Amount Type of Award
BOUNDARY_CODE VARCHAR2 (2)
Boundary code of Award
BUDGET_PERIOD_START_DATE DATE

Budget Period start date based on Amount type, boudary code & time phased code
BUDGET_PERIOD_END_DATE DATE

Budget Period end date based on Amount type, boundary code & time phased code
CATEGORIZATION_CODE VARCHAR2 (30)
Categorization code of budget Entry Method of project
PARENT_TASK_ID NUMBER (15)
Parent Task id of Task
RESOURCE_LIST_ID NUMBER (15)
Resource List id of Transaction
TIME_PHASED_TYPE_CODE VARCHAR2 (1)
Time phase type code of budget Entry Method
BUDGETED_AT_RESOURCE_LEVEL VARCHAR2 (1)
Whether budgeted at Resource or Resource Group Level
FC_ERROR_MESSAGE VARCHAR2 (2000)
Error Message
IND_COMPILED_SET_ID NUMBER (15)
Indirect Compiled set Id
PERSON_ID NUMBER (9)
Person Id
JOB_ID NUMBER (15)
Job Id
VENDOR_ID NUMBER (15)
Vendor Id
EXPENDITURE_CATEGORY VARCHAR2 (30)
Expenditure Category
REVENUE_CATEGORY VARCHAR2 (30)
Revenue Category
ADJUSTED_DOCUMENT_HEADER_ID NUMBER (15)
The identifier of the transaction adjusted by this transaction.
AWARD_SET_ID NUMBER (15)
System generated number for a distribution set
TRANSACTION_SOURCE VARCHAR2 (30)
Implementation-defined classification of a transaction loaded into PA from an external system
BURDEN_ADJUSTMENT_FLAG VARCHAR2 (1)
Indicate this record is a burden adjustment.
BURDEN_ADJ_BC_PACKET_ID NUMBER

bc_packet_id of the original record for which this burden adjustment has been created to maximize burden
BURDEN_CALCULATION_SEQ NUMBER

Indicates the sequence in which record were picked for burden calculation.
TXN_INTERFACE_ID NUMBER (15)
System-generated number that identifies all the transactions processed by a given transaction import process request
SESSION_ID NUMBER (38)
Identifier of the user session
SERIAL_ID NUMBER (38)
Identifier of the serial number of the session
SOURCE_EVENT_ID NUMBER (15)
Identifier of the source event

[top of page]

GMS.GMS_BC_PACKETS does not reference any database object

GMS.GMS_BC_PACKETS is referenced by following:

GMS
VIEW - GMS_BC_PACKETS#

[top of page]

Table: GMS_BC_PACKETS_BVID

Description: This is a temporary summary table used in the funds check process to store distinct budget versions present in current packets. After the funds check process ends, records are deleted from this table.
Comments

This is a temporary summary table used in the funds check process to store distinct budget versions present in current packets. After the funds check process ends, records are deleted from this table.

Indexes
Index Type Tablespace Column
GMS_BC_PACKETS_BVID_U1 UNIQUE APPS_TS_NOLOGGING PACKET_ID
BUDGET_VERSION_ID
Columns
Name Datatype Length Mandatory Comments
PACKET_ID NUMBER (15) Y Packet Id
BUDGET_VERSION_ID NUMBER (15) Y Budget Version Id
CREATION_DATE DATE

Creation date

[top of page]

GMS.GMS_BC_PACKETS_BVID does not reference any database object

GMS.GMS_BC_PACKETS_BVID is referenced by following:

GMS
VIEW - GMS_BC_PACKETS_BVID#

[top of page]

Table: GMS_BC_PACKETS_SUMMARY

Description: This is a temporary summary table used in the funds check process to store actual and encumbrance amounts for current and previous packets. After the funds check process ends, records are deleted from this table.
Comments

This is a temporary summary table used in the funds check process to store actual and encumbrance amounts for current and previous packets. After the funds check process ends, records are deleted from this table.

Indexes
Index Type Tablespace Column
GMS_BC_PACKETS_SUMMARY_N1 NONUNIQUE APPS_TS_NOLOGGING PACKET_ID
BUDGET_VERSION_ID
BUD_TASK_ID
RESOURCE_LIST_MEMBER_ID
BUDGET_PERIOD_START_DATE
BUDGET_PERIOD_END_DATE
GMS_BC_PACKETS_SUMMARY_N2 NONUNIQUE APPS_TS_NOLOGGING PACKET_ID
BUDGET_VERSION_ID
BUD_TASK_ID
PARENT_RESOURCE_ID
BUDGET_PERIOD_START_DATE
BUDGET_PERIOD_END_DATE
GMS_BC_PACKETS_SUMMARY_N3 NONUNIQUE APPS_TS_NOLOGGING PACKET_ID
BUDGET_VERSION_ID
BUD_TASK_ID
BUDGET_PERIOD_START_DATE
BUDGET_PERIOD_END_DATE
GMS_BC_PACKETS_SUMMARY_N4 NONUNIQUE APPS_TS_NOLOGGING PACKET_ID
BUDGET_VERSION_ID
TOP_TASK_ID
BUDGET_PERIOD_START_DATE
BUDGET_PERIOD_END_DATE
GMS_BC_PACKETS_SUMMARY_N5 NONUNIQUE APPS_TS_NOLOGGING PACKET_ID
BUDGET_VERSION_ID
BUDGET_PERIOD_START_DATE
BUDGET_PERIOD_END_DATE
Columns
Name Datatype Length Mandatory Comments
PACKET_ID NUMBER (15) Y Packet Id
BUDGET_VERSION_ID NUMBER (15) Y Budget Version id
BUD_TASK_ID NUMBER (15)
Budgeted Task Id
TOP_TASK_ID NUMBER

Top task id
BUD_RESOURCE_LIST_MEMBER_ID NUMBER (15)
Budgeted resource List member Id
PARENT_RESOURCE_ID NUMBER

Parent Resource Id
BUDGET_PERIOD_START_DATE DATE

Budget Period Start Date
BUDGET_PERIOD_END_DATE DATE

Budget Period End Date
CREATION_DATE DATE

Creation Date
ACTUAL_APPROVED NUMBER

Actual approved
ACTUAL_PENDING NUMBER

Actual Pending
ENC_APPROVED NUMBER

Encumbrance approved
ENC_PENDING NUMBER

Encumbrance Pending
RESOURCE_LIST_MEMBER_ID NUMBER (15)
Resource List Member Id

[top of page]

GMS.GMS_BC_PACKETS_SUMMARY does not reference any database object

GMS.GMS_BC_PACKETS_SUMMARY is referenced by following:

GMS
VIEW - GMS_BC_PACKETS_SUMMARY#

[top of page]

Table: GMS_BC_PACKET_ARRIVAL_ORDER

Description: This table stores the execution order for the packets. This table is populated during the funds check process, and the records are deleted once the GMS: Update actual and encumbrance balance process is run.
Comments

GMS_BC_PACKET_ARRIVAL_ORDER stores the sequence in which the packets arrived for funds checking. While funds checking a packet, the funds check process uses the information in this table to calculate the available budget balances.

Indexes
Index Type Tablespace Column
GMS_BC_PACKET_ARRIVAL_ORDER_U1 UNIQUE APPS_TS_TX_IDX ARRIVAL_SEQ
PACKET_ID
GMS_BC_PACKET_ARRIVAL_ORDER_U2 UNIQUE APPS_TS_TX_IDX PACKET_ID
ARRIVAL_SEQ
Columns
Name Datatype Length Mandatory Comments
ARRIVAL_SEQ NUMBER (15) Y System-generated sequence in which a packet arrived for funds checking.
PACKET_ID NUMBER (15) Y Unique identifier for a packet for funds checking
LAST_UPDATE_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER (15) Y Standard who column

[top of page]

GMS.GMS_BC_PACKET_ARRIVAL_ORDER does not reference any database object

GMS.GMS_BC_PACKET_ARRIVAL_ORDER is referenced by following:

GMS
VIEW - GMS_BC_PACKET_ARRIVAL_ORDER#

[top of page]

Table: GMS_BILLING_CANCELLATIONS

Description: Journal of deleted billing event distributions for deleted, cancelled revenue, or invoices
Comments

GMS_BILLING_CANCELLATIONS store cancelled or deleted revenue and billing amounts. Used for maintaining invoice or revenue amounts in Award Status Inquiry.

Indexes
Index Type Tablespace Column
GMS_BILLING_CANCELLATIONS_N1 NONUNIQUE APPS_TS_TX_IDX EXPENDITURE_ITEM_ID
ADL_LINE_NUM
ACTUAL_PROJECT_ID
ACTUAL_TASK_ID
AWARD_PROJECT_ID
GMS_BILLING_CANCELLATIONS_N2 NONUNIQUE APPS_TS_TX_IDX AWARD_PROJECT_ID
ACTUAL_PROJECT_ID
ACTUAL_TASK_ID
Columns
Name Datatype Length Mandatory Comments
AWARD_PROJECT_ID NUMBER (15) Y Internal identifier of the project maintained for an award
EVENT_NUM NUMBER (15) Y Event number of the deleted or cancelled billing event
EXPENDITURE_ITEM_ID NUMBER (15)
Expenditure item identifier of the cancelled or deleted billing event distribution
ADL_LINE_NUM NUMBER (15)
Award distribution line number of the expenditure item in the cancelled or deleted billing or revenue distribution.
BILL_AMOUNT NUMBER (22)
Revenue or invoice amount of the event distribution
CALLING_PROCESS VARCHAR2 (15)
Process name describes whether the record is an invoice or revenue distribution
BURDEN_EXP_TYPE VARCHAR2 (30)
Expenditure type mapped to the indirect cost code
BURDEN_COST_CODE VARCHAR2 (30)
Indirect cost code
CREATION_DATE DATE

Date of creation of the revenue or invoice
ACTUAL_PROJECT_ID NUMBER (15)
Internal identifier of the sponsored project to which the event was assigned.
ACTUAL_TASK_ID NUMBER (15)
Internal identifier of the task to which the cancelled billing event is assigned
EXPENDITURE_ORG_ID NUMBER (15)
Expenditure organization
DELETION_DATE DATE

Date on which the revenue or invoice was deleted
RESOURCE_LIST_MEMBER_ID NUMBER (15)
Resource list member identifier to which the billing event distribution is mapped to

[top of page]

GMS.GMS_BILLING_CANCELLATIONS does not reference any database object

GMS.GMS_BILLING_CANCELLATIONS is referenced by following:

GMS
VIEW - GMS_BILLING_CANCELLATIONS#

[top of page]

Table: GMS_BILLING_FORMS

Description: Implementation-defined billing forms
Comments

GMS_BILLING_FORMS stores information about the billing forms.

Indexes
Index Type Tablespace Column
GMS_BILLING_FORMS_U1 UNIQUE APPS_TS_SEED FORM_ID
GMS_BILLING_FORMS_U2 UNIQUE APPS_TS_SEED FORM_NAME
Columns
Name Datatype Length Mandatory Comments
FORM_ID NUMBER (15) Y Agency specific form identifier
FORM_NAME VARCHAR2 (60) Y User-friendly name for agency specific form
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
START_DATE_ACTIVE DATE
Y First effective date of billing form
END_DATE_ACTIVE DATE

Last effective date of billing form
DESCRIPTION VARCHAR2 (250)
Billing form description
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

[top of page]

GMS.GMS_BILLING_FORMS does not reference any database object

GMS.GMS_BILLING_FORMS is referenced by following:

GMS
VIEW - GMS_BILLING_FORMS#

[top of page]

Table: GMS_BUDGETARY_CONTROLS

Description: Budgetary control level for awards, tasks, resource groups, and resources
Primary Key: GMS_BUDGETARY_CONTROLS_PK
  1. BUDGETARY_CONTROLS_ID
Comments

GMS_BUDGETARY_CONTROLS stores budgetary control levels for an award project. Budgetary control levels are Absolute, Advisory, or None.

Indexes
Index Type Tablespace Column
GMS_BUDGETARY_CONTROLS_U1 UNIQUE APPS_TS_TX_IDX BUDGETARY_CONTROLS_ID
GMS_BUDGETARY_CONTROLS_U2 UNIQUE APPS_TS_TX_IDX PROJECT_ID
AWARD_ID
TASK_ID
RESOURCE_LIST_MEMBER_ID
Columns
Name Datatype Length Mandatory Comments
BUDGETARY_CONTROLS_ID NUMBER (15) Y Budgetary control defining column
PROJECT_ID NUMBER (15) Y Project defining column
FUNDS_CONTROL_LEVEL_CODE VARCHAR2 (1) Y Funds control level codes for funds checking. D indicates Advisory, B indicates Absolute, and N indicates None.
AWARD_ID NUMBER (15) Y Award defining column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
TOP_TASK_ID NUMBER (15)
Not currently used
TASK_ID NUMBER (15)
Task defining column
PARENT_MEMBER_ID NUMBER (15)
Parent member defining column
RESOURCE_LIST_MEMBER_ID NUMBER (15)
Resource list defining column

[top of page]

GMS.GMS_BUDGETARY_CONTROLS does not reference any database object

GMS.GMS_BUDGETARY_CONTROLS is referenced by following:

GMS
VIEW - GMS_BUDGETARY_CONTROLS#

[top of page]

Table: GMS_BUDGET_LINES

Description: Detail lines of project and task budgets
Primary Key: GMS_BUDGET_LINES_PK
  1. RESOURCE_ASSIGNMENT_ID
  2. START_DATE
Foreign Keys from this table:
Foreign Key Column Foreign Table
GMS_BUDGET_LINES.RESOURCE_ASSIGNMENT_ID GMS_RESOURCE_ASSIGNMENTS
Comments

GMS_ BUDGET_LINES stores the detail information of a project or task budget, including the resource, time period, and budget amounts entered. The time period may be a Projects period, General Ledger period, or any user-defined period.

Indexes
Index Type Tablespace Column
GMS_BUDGET_LINES_U1 UNIQUE APPS_TS_TX_IDX RESOURCE_ASSIGNMENT_ID
START_DATE
GMS_BUDGET_LINES_N1 NONUNIQUE APPS_TS_TX_IDX START_DATE
END_DATE
Columns
Name Datatype Length Mandatory Comments
RESOURCE_ASSIGNMENT_ID NUMBER (15) Y Identifier of the resource assignment of the budget line
START_DATE DATE
Y Start date of the budget line
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
END_DATE DATE
Y End date of the budget line
PERIOD_NAME VARCHAR2 (30)
Period of the budget line
QUANTITY NUMBER

Quantity of the budget line
RAW_COST NUMBER

Raw cost of the budget line
BURDENED_COST NUMBER

Burdened cost of the budget line
REVENUE NUMBER

Revenue of the budget line
CHANGE_REASON_CODE VARCHAR2 (30)
Reason to create the budget line
DESCRIPTION VARCHAR2 (255)
Description of the budget line
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield context field
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
RAW_COST_SOURCE VARCHAR2 (2)
Not currently used
BURDENED_COST_SOURCE VARCHAR2 (2)
Not currently used
QUANTITY_SOURCE VARCHAR2 (2)
Not currently used
REVENUE_SOURCE VARCHAR2 (2)
Not currently used
PM_PRODUCT_CODE VARCHAR2 (30)
Identifier of the external project management system from which the budget was imported
PM_BUDGET_LINE_REFERENCE VARCHAR2 (25)
Identifier of the budget in the external project management system from which the budget was imported

[top of page]

GMS.GMS_BUDGET_LINES does not reference any database object

GMS.GMS_BUDGET_LINES is referenced by following:

GMS
VIEW - GMS_BUDGET_LINES#

[top of page]

Table: GMS_BUDGET_VERSIONS

Description: Versions of award budgets
Primary Key: GMS_BUDGET_VERSIONS_PK
  1. BUDGET_VERSION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GMS_BUDGET_VERSIONS.RESOURCE_LIST_ID PA_RESOURCE_LISTS_ALL_BG
GMS_BUDGET_VERSIONS.BUDGET_ENTRY_METHOD_CODE PA_BUDGET_ENTRY_METHODS
GMS_BUDGET_VERSIONS.BUDGET_TYPE_CODE PA_BUDGET_TYPES
GMS_BUDGET_VERSIONS.PROJECT_ID PA_PROJECTS_ALL
Foreign Keys to this table:
Foreign Key Column Foreign Table
GMS_RESOURCE_ASSIGNMENTS.BUDGET_VERSION_ID GMS_BUDGET_VERSIONS
Comments

GMS_BUDGET_VERSIONS stores the versions of award budgets. There are three categories of budget versions: Draft, Baselined, and Original. For an award and budget type, there is only one draft budget.
There can be many baselined budgets for an award and budget type. One baselined budget version is identified as the current budget and one is identified as the original budget.

Indexes
Index Type Tablespace Column
GMS_BUDGET_VERSIONS_U1 UNIQUE APPS_TS_TX_IDX BUDGET_VERSION_ID
GMS_BUDGET_VERSIONS_U2 UNIQUE APPS_TS_TX_IDX PROJECT_ID
AWARD_ID
BUDGET_TYPE_CODE
BUDGET_STATUS_CODE
VERSION_NUMBER
GMS_BUDGET_VERSIONS_N1 NONUNIQUE APPS_TS_TX_IDX CURRENT_FLAG
PROJECT_ID
BUDGET_TYPE_CODE
RESOURCE_ACCUMULATED_FLAG
GMS_BUDGET_VERSIONS_N2 NONUNIQUE APPS_TS_TX_IDX CURRENT_ORIGINAL_FLAG
PROJECT_ID
BUDGET_TYPE_CODE
RESOURCE_ACCUMULATED_FLAG
GMS_BUDGET_VERSIONS_N3 NONUNIQUE APPS_TS_TX_IDX ADW_NOTIFY_FLAG
PROJECT_ID
CURRENT_FLAG
GMS_BUDGET_VERSIONS_N4 NONUNIQUE APPS_TS_TX_IDX AWARD_ID
Columns
Name Datatype Length Mandatory Comments
BUDGET_VERSION_ID NUMBER (15) Y System-generated number that uniquely identifies the budget version
PROJECT_ID NUMBER (15) Y Identifier of the project for which the budget is entered
AWARD_ID NUMBER (15) Y Identifier of the award for which the budget is entered
BUDGET_TYPE_CODE VARCHAR2 (30) Y Type of budget
VERSION_NUMBER NUMBER (15) Y Version number of the budget. For a draft budget, the version number is always 1, for a baselined budget this number is increased sequentially
BUDGET_STATUS_CODE VARCHAR2 (30) Y Status of a budget.
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
CURRENT_FLAG VARCHAR2 (1) Y Flag that indicates whether the budget version is the current baselined budget
ORIGINAL_FLAG VARCHAR2 (1) Y Flag that indicates whether the budget version was an original budget at any time
CURRENT_ORIGINAL_FLAG VARCHAR2 (1) Y Flag that indicates whether the budget version is the current original budget
RESOURCE_ACCUMULATED_FLAG VARCHAR2 (1) Y Flag that indicates whether the budget version is summarized by resource accumulation in the project summary amount
RESOURCE_LIST_ID NUMBER (15) Y Identifier of the resource list used by the budget version
VERSION_NAME VARCHAR2 (60)
Name of the budget version
BUDGET_ENTRY_METHOD_CODE VARCHAR2 (30)
Method used to enter the budget version
BASELINED_BY_PERSON_ID NUMBER (15)
Identifier of the person who baselined the budget
BASELINED_DATE DATE

Baselined date of the budget version
CHANGE_REASON_CODE VARCHAR2 (30)
Reason to create this budget version
LABOR_QUANTITY NUMBER

Number of labor hours budgeted for the project. This is a denormalized column which sums the quantities for all labor resources budgeted.
LABOR_UNIT_OF_MEASURE VARCHAR2 (30)
Unit of measure of labor hours for the project. This is always set to Hours.
RAW_COST NUMBER

Raw cost budget of the project. This is a denormalized column.
BURDENED_COST NUMBER

Burdened cost budget of the project. This is a denormalized column.
REVENUE NUMBER

Revenue budget of the project. This is a denormalized column.
DESCRIPTION VARCHAR2 (255)
Description of the budget version
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield segment
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
FIRST_BUDGET_PERIOD VARCHAR2 (30)
First period for which to display amounts in budget matrix window
PM_PRODUCT_CODE VARCHAR2 (30)
Identifier of the external project management system from which the budget was imported
PM_BUDGET_REFERENCE VARCHAR2 (25)
Identifier of the budget in the external project management system from which the budget was imported
WF_STATUS_CODE VARCHAR2 (30)
Column stores the workflow status code for Budget Approval workflows
ADW_NOTIFY_FLAG VARCHAR2 (1)
Flag used for Project Analysis Collection Pack
PRC_GENERATED_FLAG VARCHAR2 (1)
For future use
FC_REQUIRED_FLAG VARCHAR2 (1)
Flag used to indicate if funds checking is required or not for this budget
CONC_REQUEST_ID NUMBER (15)
Concurrent request identifier for the submit or baseline process

[top of page]

GMS.GMS_BUDGET_VERSIONS does not reference any database object

GMS.GMS_BUDGET_VERSIONS is referenced by following:

GMS
VIEW - GMS_BUDGET_VERSIONS#

[top of page]

Table: GMS_BURDEN_ADJUSTMENTS_LOG

Description: Journal of burdenable raw cost adjustments
Comments

GMS_BURDEN_ADJUSTMENTS_LOG maintains the journal of burdenable raw cost adjustments done across expenditure items, invoice distribution, manual encumbrances, purchase order distribution, and purchase requisition distribution in order to maximize the burdenable raw cost by award and expenditure type.

Indexes
Index Type Tablespace Column
GMS_ADJ_PK_U1 UNIQUE APPS_TS_TX_IDX ADJUSTMENT_ID
LINE_NUM
GMS_DOC_KEY_IND_N1 NONUNIQUE APPS_TS_TX_IDX DOCUMENT_HEADER_ID
DOCUMENT_DISTRIBUTION_ID
DOCUMENT_TYPE
GMS_PACKET_IND_N2 NONUNIQUE APPS_TS_TX_IDX PACKET_ID
BC_PACKET_ID
Columns
Name Datatype Length Mandatory Comments
ADJUSTMENT_ID NUMBER (15) Y Unique identifier for set of adjustments
LINE_NUM NUMBER (15) Y Sequence of adjustments in a given set
DOCUMENT_HEADER_ID NUMBER (15) Y Internal identifier of the transaction adjusted
DOCUMENT_DISTRIBUTION_ID NUMBER (15) Y Distribution identifier of the source transaction
DOCUMENT_TYPE VARCHAR2 (3) Y Document type of the transaction adjusted
AMOUNT NUMBER (22) Y Raw cost of the adjusting transaction
ADJ_BURDENABLE_AMOUNT NUMBER (22) Y Burdenable amount of adjusting transaction
SOURCE_FLAG VARCHAR2 (1) Y Indicates the source of adjustments. Default value is Y.
AWARD_SET_ID NUMBER (15) Y Reference number for the award distribution
ADL_LINE_NUM NUMBER (15) Y Sequence number of the award distribution within a distribution set
AWARD_ID NUMBER
Y Internal identifier of award
EXPENDITURE_TYPE VARCHAR2 (30) Y Expenditure type of the adjustment transaction
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
POSTED_FLAG VARCHAR2 (1) Y Indicates status of posting adjustment transaction in balances
PACKET_ID NUMBER (15)
GMS_bc_packets Packet id reference.
BC_PACKET_ID NUMBER (15)
GMS_bc_packets bc_packet id reference.

[top of page]

GMS.GMS_BURDEN_ADJUSTMENTS_LOG does not reference any database object

GMS.GMS_BURDEN_ADJUSTMENTS_LOG is referenced by following:

GMS
VIEW - GMS_BURDEN_ADJUSTMENTS_LOG#

[top of page]

Table: GMS_BURDEN_COMPONENTS

Description: Burden components of billing events
Foreign Keys from this table:
Foreign Key Column Foreign Table
GMS_BURDEN_COMPONENTS.EXPENDITURE_ITEM_ID PA_EXPENDITURE_ITEMS_ALL
Comments

GMS_BURDEN_COMPONENTS stores the burden amounts by component for each raw expenditure item picked up during the revenue or billing process.

Indexes
Index Type Tablespace Column
GMS_BURDEN_COMPONENTS_U1 UNIQUE APPS_TS_TX_IDX AWARD_PROJECT_ID
BURDEN_COST_CODE
EVENT_TYPE
EXPENDITURE_ITEM_ID
ADL_LINE_NUM
REQUEST_ID
GMS_BURDEN_COMPONENTS_N1 NONUNIQUE APPS_TS_TX_IDX EXPENDITURE_ITEM_ID
EVENT_TYPE
BURDEN_COST_CODE
GMS_BURDEN_COMPONENTS_N10 NONUNIQUE APPS_TS_TX_IDX REVENUE_ACCUMULATED
EVENT_TYPE
GMS_BURDEN_COMPONENTS_N2 NONUNIQUE APPS_TS_TX_IDX AWARD_PROJECT_ID
REQUEST_ID
EVENT_TYPE
GMS_BURDEN_COMPONENTS_N3 NONUNIQUE APPS_TS_TX_IDX AWARD_PROJECT_ID
EVENT_NUM
EVENT_TYPE
EXPENDITURE_ITEM_ID
BURDEN_COST_CODE
GMS_BURDEN_COMPONENTS_N4 NONUNIQUE APPS_TS_TX_IDX REVENUE_ACCUMULATED
Columns
Name Datatype Length Mandatory Comments
ACTUAL_PROJECT_ID NUMBER (15)
Unique identifier of project against which raw transaction was recorded
ACTUAL_TASK_ID NUMBER (15)
Unique identifier of task against which raw transaction was recorded
AMOUNT NUMBER (22)
Burden amount
AWARD_PROJECT_ID NUMBER (15) Y Unique identifier of award project
BURDEN_COST_CODE VARCHAR2 (30)
Burden or indirect cost code
BURDEN_EXP_TYPE VARCHAR2 (30)
Expenditure type mapped to burden cost code
CREATED_BY NUMBER

Standard Who column
CREATION_DATE DATE

Standard Who column
EVENT_NUM NUMBER (15)
Unique identifier of expenditure item processed for billing or revenue
EVENT_TYPE VARCHAR2 (30)
Event type of the event being created. Revenue indicates revenue generation events, and Invoice indicates billing events.
EXPENDITURE_ITEM_ID NUMBER (15) Y Unique identifier of expenditure item processed for billing or revenue
EXPENDITURE_ORG_ID NUMBER (15)
Unique identifier of organization to which raw transaction was charged
ADL_LINE_NUM NUMBER (15) Y Award distribution line number
LAST_UPDATED_BY NUMBER (15)
Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
REQUEST_ID NUMBER (15) Y Unique identifier of expenditure item processed for billing or revenue
REVENUE_ACCUMULATED VARCHAR2 (1)
Flag indicates the revenue accumulation status for Award Status Inquiry
RESOURCE_LIST_MEMBER_ID NUMBER (15)
Resource list member identifier to which the burden component is mapped to

[top of page]

GMS.GMS_BURDEN_COMPONENTS does not reference any database object

GMS.GMS_BURDEN_COMPONENTS is referenced by following:

GMS
VIEW - GMS_BURDEN_COMPONENTS#

[top of page]

Table: GMS_CONCURRENCY_CONTROL

Description: Control table for concurrency control of transactions in Grants Accounting concurrent processes
Comments

GMS_CONCURRENCY_CONTROL stores the concurrency control information used by the
Grants Accounting processes.

Indexes
Index Type Tablespace Column
GMS_PROCESS_PK_U1 UNIQUE APPS_TS_TX_IDX PROCESS_NAME
PROCESS_KEY
REQUEST_ID
Columns
Name Datatype Length Mandatory Comments
PROCESS_NAME VARCHAR2 (8) Y Process in progress and have pre seeded data for process like funds control
PROCESS_KEY NUMBER (15) Y Process key is a unique identifier value with in the process may be required to control across multiple commit points.
REQUEST_ID NUMBER (22)
Concurrent process request identifier.
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER (15)
Standard Who column
CREATED_BY NUMBER (15)
Standard Who column
CREATION_DATE DATE

Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column

[top of page]

GMS.GMS_CONCURRENCY_CONTROL does not reference any database object

GMS.GMS_CONCURRENCY_CONTROL is referenced by following:

GMS
VIEW - GMS_CONCURRENCY_CONTROL#

[top of page]

Table: GMS_DEFAULT_REPORTS

Description: Default reports of award
Primary Key: GMS_DEFAULT_REPORTS_PK
  1. DEFAULT_REPORT_ID
Comments

GMS_DEFAULT_REPORTS stores information about the reports associated with an award. This table holds report frequency and report due dates, which are used to compute the reports due in the installment level.

Indexes
Index Type Tablespace Column
GMS_DEFAULT_REPORTS_U1 UNIQUE APPS_TS_TX_IDX DEFAULT_REPORT_ID
GMS_DEFAULT_REPORTS_U2 UNIQUE APPS_TS_TX_IDX AWARD_ID
REPORT_TEMPLATE_ID
SITE_USE_ID
Columns
Name Datatype Length Mandatory Comments
DEFAULT_REPORT_ID NUMBER (15) Y Default report identifier. Used as blueprint to derive report for each installment.
REPORT_TEMPLATE_ID NUMBER (15) Y Report template identifier
AWARD_ID NUMBER (15) Y Award 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
FREQUENCY VARCHAR2 (30) Y Default report delivery frequency
DUE_WITHIN_DAYS NUMBER (15) Y Date offset before report is due
SITE_USE_ID NUMBER (15)
Identifier where report to be delivered
COPY_NUMBER NUMBER (15) Y Number of copies to be delivered
REQUEST_ID NUMBER (15)
Standard Who column
PROGRAM_APPLICATION_ID NUMBER (15)
Standard Who column
PROGRAM_ID NUMBER (15)
Standard Who column
PROGRAM_UPDATE_DATE DATE

Standard Who column
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

[top of page]

GMS.GMS_DEFAULT_REPORTS does not reference any database object

GMS.GMS_DEFAULT_REPORTS is referenced by following:

GMS
VIEW - GMS_DEFAULT_REPORTS#

[top of page]

Table: GMS_DISTRIBUTIONS

Description: Header information
Comments

GMS_DISTRIBUTIONS stores records for award distribution. Transactions populated with default award defined in Grants implementation setup are stored here. These records were applied with valid funding patterns to determine the actual award distribution.

Indexes
Index Type Tablespace Column
GMS_DISTRIBUTIONS_U1 UNIQUE APPS_TS_INTERFACE DOCUMENT_DISTRIBUTION_ID
DOCUMENT_HEADER_ID
DOCUMENT_TYPE
Columns
Name Datatype Length Mandatory Comments
DOCUMENT_HEADER_ID NUMBER
Y Sequence generated number uniquely identifies the funding header id.
DOCUMENT_DISTRIBUTION_ID NUMBER (15) Y Header information for the distribution lines
DOCUMENT_TYPE VARCHAR2 (4) Y Information from where the document originated
GL_DATE DATE
Y GL date for which the expenditure is entered
PROJECT_ID NUMBER (15) Y Project Information
TASK_ID NUMBER (15) Y Task information for the project and award
EXPENDITURE_TYPE VARCHAR2 (30) Y Expenditure Type information
EXPENDITURE_ORGANIZATION_ID NUMBER (15) Y Information about the expenditure organization
EXPENDITURE_ITEM_DATE DATE
Y Expenditure item date
QUANTITY NUMBER

Quantity of the transaction (UOM)
UNIT_PRICE NUMBER

Price for the unit of measure
AMOUNT NUMBER
Y Qunatity * Unit price
DIST_STATUS VARCHAR2 (5)
Information whether any distribtuions line failed
CREATION_DATE DATE
Y Creation date
BURDENED_COST NUMBER

Burdened Cost
DENOM_BURDENED_COST NUMBER

Burdened cost in Transaction currency
DENOM_RAW_COST NUMBER

Raw Cost in transaction currency
ACCT_RAW_COST NUMBER

Raw Cost in Functional currency
ACCT_BURDENED_COST NUMBER

Burdened Cost in functional currency
RECEIPT_CURRENCY_AMOUNT NUMBER

Receipt currency amount of the transaction

[top of page]

GMS.GMS_DISTRIBUTIONS does not reference any database object

GMS.GMS_DISTRIBUTIONS is referenced by following:

GMS
VIEW - GMS_DISTRIBUTIONS#

[top of page]

Table: GMS_DISTRIBUTION_DETAILS

Description: Details of distribution lines
Comments

GMS_DISTRIBUTION_DETAILS stores records for actual award distribution and needs to be applied to the transaction record populated with the default award defined in Grants implementation setup. This table stores the detail records for GMS_DISTRIBUTIONS.

Indexes
Index Type Tablespace Column
GMS_DISTRIBUTION_DETAILS_N1 NONUNIQUE APPS_TS_INTERFACE DOCUMENT_DISTRIBUTION_ID
DOCUMENT_HEADER_ID
DOCUMENT_TYPE
GMS_DISTRIBUTION_DETAILS_U1 NONUNIQUE APPS_TS_INTERFACE DISTRIBUTION_NUMBER
DOCUMENT_DISTRIBUTION_ID
DOCUMENT_HEADER_ID
DOCUMENT_TYPE
FUNDING_PATTERN_ID
Columns
Name Datatype Length Mandatory Comments
DOCUMENT_HEADER_ID NUMBER (15) Y Sequence generated number uniquely identifies the funding header id.
DOCUMENT_DISTRIBUTION_ID NUMBER
Y Detail Line information for the distribution lines
DOCUMENT_TYPE VARCHAR2 (3) Y Information from where the document originated
FUNDING_PATTERN_ID NUMBER (15) Y Identifying the funding pattern
DISTRIBUTION_NUMBER NUMBER (15) Y Distribution line number
AWARD_ID NUMBER (15) Y Award information
PROJECT_ID NUMBER (15) Y Project Information
TASK_ID NUMBER (15) Y Task information for the project and award
EXPENDITURE_TYPE VARCHAR2 (30) Y Expenditure Type information
EXPENDITURE_ORGANIZATION_ID NUMBER (15) Y Information about expenditure organization
EXPENDITURE_ITEM_DATE DATE
Y Expenditure Item Date
GL_DATE DATE
Y GL Date
QUANTITY_DISTRIBUTED NUMBER

Quantity of the items
AMOUNT_DISTRIBUTED NUMBER
Y Amount of the items
FC_STATUS VARCHAR2 (1) Y Funds check status from GMS fund checker
LINE_STATUS VARCHAR2 (30)
Status of the distribution line
REMARKS VARCHAR2 (240)
Description of the failure
CREATION_DATE DATE
Y Standard Who Column
BURDENED_COST NUMBER

Burdened Cost
DENOM_BURDENED_COST NUMBER

Burdened cost in Transaction currency
DENOM_RAW_COST NUMBER

Raw Cost in Transaction currency
ACCT_RAW_COST NUMBER

Raw Cost in functional currency
ACCT_BURDENED_COST NUMBER

Burdened cost in functional currency
RECEIPT_CURRENCY_AMOUNT NUMBER

Receipt currency amount of the transaction

[top of page]

GMS.GMS_DISTRIBUTION_DETAILS does not reference any database object

GMS.GMS_DISTRIBUTION_DETAILS is referenced by following:

GMS
VIEW - GMS_DISTRIBUTION_DETAILS#

[top of page]

Table: GMS_ENCUMBRANCES_ALL

Description: Groups of encumbrance items incurred by employees or organizations in an encumbrance batch
Primary Key: GMS_ENCUMBRANCE_GROUPS_PK
  1. ENCUMBRANCE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GMS_ENCUMBRANCES_ALL.VENDOR_ID PO_VENDORS
Comments

GMS_ENCUMBRANCES_ALL stores the group of encumbrance items incurred by employees or organizations in an encumbrance batch. Encumbrance transactions can be manual encumbrances of encumbrances interfaced from Oracle Labor Distribution.

Indexes
Index Type Tablespace Column
GMS_ENCUMBRANCE_U1 UNIQUE APPS_TS_TX_IDX ENCUMBRANCE_ID
GMS_ENCUMBRANCES_ALL_N2 NONUNIQUE APPS_TS_TX_IDX INCURRED_BY_ORGANIZATION_ID
GMS_ENCUMBRANCE_N1 NONUNIQUE APPS_TS_TX_IDX ENCUMBRANCE_GROUP
Columns
Name Datatype Length Mandatory Comments
ENCUMBRANCE_ID NUMBER (15) Y System-generated number that uniquely identifies the encumbrance
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
ENCUMBRANCE_STATUS_CODE VARCHAR2 (30) Y Status of the encumbrance as it is entered and approved
ENCUMBRANCE_ENDING_DATE DATE
Y Last day of the encumbrance week period. All encumbrance items for the encumbrance must be on or before this encumbrance ending date. All timecard items must be within this encumbrance ending date period.
ENCUMBRANCE_CLASS_CODE VARCHAR2 (2) Y Classification of the encumbrance, indicating the type of items grouped into it
INCURRED_BY_PERSON_ID NUMBER (9)
Identifier of the employee who incurred the charges. This column is always populated for labor and expense report charges and is not populated for supplier invoices. For usages, specifying employees who incurred the charges is optional.
INCURRED_BY_ORGANIZATION_ID NUMBER (15)
Identifier of the organization that incurred the charges. Column is populated for all charges except supplier invoices, where the organization is held at the expenditure item level, as each invoice distribution may have different organizations.
ENCUMBRANCE_GROUP VARCHAR2 (240)
Encumbrance group to which encumbrance belongs. This is only applicable for pre-approved encumbrances. This column is blank for online encumbrances.
CONTROL_TOTAL_AMOUNT NUMBER (22)
User-entered control total of the encumbrance items for the encumbrance
ENTERED_BY_PERSON_ID NUMBER (9)
Identifier of the person who entered the encumbrance. This value is not populated for supplier invoice encumbrances.
DESCRIPTION VARCHAR2 (250)
Comment of the online encumbrances
INITIAL_SUBMISSION_DATE DATE

Date on which the online encumbrance was initially submitted
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
REQUEST_ID NUMBER (15)
Standard Who column
PROGRAM_ID NUMBER (15)
Standard Who column
PROGRAM_APPLICATION_ID NUMBER (15)
Standard Who column
PROGRAM_UPDATE_DATE DATE

Standard Who column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield context field
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
PTE_REFERENCE NUMBER (15)
Encumbrance identifier of the GMS_ENCUMBRANCES table in the local database for Oracle Personal Time and Expense
ORG_ID NUMBER (15)
Operating unit identifier for multi-organization installations
DENOM_CURRENCY_CODE VARCHAR2 (15)
Transaction currency of the transaction
ACCT_CURRENCY_CODE VARCHAR2 (15)
Functional currency of the transaction
ACCT_RATE_DATE DATE

Functional currency conversion rate date
ACCT_RATE_TYPE VARCHAR2 (30)
Functional currency conversion rate type
ACCT_EXCHANGE_RATE NUMBER

Functional currency conversion exchange rate
ORIG_ENC_TXN_REFERENCE1 VARCHAR2 (60)
Encumbrance identifier in external system or system reference. For Supplier invoices created in Oracle Payables, this holds the value of AP_INVOICESINVOICE_ID.
ORIG_ENC_TXN_REFERENCE2 VARCHAR2 (60)
Additional column provided to group imported transactions into encumbrances
ORIG_ENC_TXN_REFERENCE3 VARCHAR2 (60)
Additional column provided to group imported transactions into encumbrances
ORIG_USER_ENC_TXN_REFERENCE VARCHAR2 (60)
User reference for the encumbrance that may be populated for items imported into Projects via Transaction Import For Supplier Invoices. This holds the value of AP_INVOICESINVOICE_NUM. For timecards created via Oracle Self Service Time, this holds the value.
VENDOR_ID NUMBER

Supplier identifier
OVERRIDING_APPROVER_PERSON_ID NUMBER

For Oracle Self Service Time use only. The Overriding Approver to whom this timecard was sent for approval.
WF_STATUS_CODE VARCHAR2 (30)
This column stores the workflow status code for self service timecards.
TRANSFER_STATUS_CODE VARCHAR2 (1)
Status of the timecard as the timecard is transferred from Self Service Time to Oracle Projects
USER_BATCH_NAME VARCHAR2 (50)
Batch name for timecards entered through Self Service Time. Used to group timecards into batches through Transaction Import.

[top of page]

GMS.GMS_ENCUMBRANCES_ALL does not reference any database object

GMS.GMS_ENCUMBRANCES_ALL is referenced by following:

GMS
VIEW - GMS_ENCUMBRANCES_ALL#

[top of page]

Table: GMS_ENCUMBRANCE_GROUPS_ALL

Description: Groups of pre-approved encumbrances
Primary Key: GMS_ENCUBMBRACE_GROUPS_PK
  1. ENCUMBRANCE_GROUP
Foreign Keys from this table:
Foreign Key Column Foreign Table
GMS_ENCUMBRANCE_GROUPS_ALL.SYSTEM_LINKAGE_FUNCTION PA_SYSTEM_LINKAGES
Comments

GMS_ENCUMBRANCE_GROUPS_ALL stores pre-approved encumbrance batches. Encumbrance batches can be for manual encumbrances or encumbrances interfaced from Oracle Labor Distribution.

Indexes
Index Type Tablespace Column
GMS_ENCUBMBRACE_GROUPS_U1 UNIQUE APPS_TS_TX_IDX ENCUMBRANCE_GROUP
GMS_ENCUMBRANCE_GROUPS_N1 NONUNIQUE APPS_TS_TX_IDX REQUEST_ID
Columns
Name Datatype Length Mandatory Comments
ENCUMBRANCE_GROUP VARCHAR2 (240) Y User-defined name that uniquely identifies the encumbrance group
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
ENCUMBRANCE_GROUP_STATUS_CODE VARCHAR2 (30) Y Status of the encumbrance group as it is entered, approved, and released for costing
ENCUMBRANCE_ENDING_DATE DATE
Y Last day of the encumbrance week period
SYSTEM_LINKAGE_FUNCTION VARCHAR2 (30) Y Classification of the encumbrance group that indicates what type of charges are entered for the group. All encumbrance items entered for the group have an encumbrance type defined with the same system linkage as the group system linkage.
CONTROL_COUNT VARCHAR2 (20)
User-entered control count of the encumbrance for the encumbrance group
CONTROL_TOTAL_AMOUNT NUMBER (22)
User-entered control total of the encumbrances for the encumbrance group
DESCRIPTION VARCHAR2 (250)
Description of the encumbrance group. Upon entry of the encumbrance group, the description is defaulted to the type of encumbrances entered. Timecards, Expense Reports, and Usages.
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
REQUEST_ID NUMBER (15)
Standard Who column
PROGRAM_ID NUMBER (15)
Standard Who column
PROGRAM_APPLICATION_ID NUMBER (15)
Standard Who column
PROGRAM_UPDATE_DATE DATE

Standard Who column
TRANSACTION_SOURCE VARCHAR2 (30)
Transaction source of the imported expenditures loaded by the Transaction Import process
ORG_ID NUMBER (15)
Operating unit identifier for multi-organization installations

[top of page]

GMS.GMS_ENCUMBRANCE_GROUPS_ALL does not reference any database object

GMS.GMS_ENCUMBRANCE_GROUPS_ALL is referenced by following:

GMS
VIEW - GMS_ENCUMBRANCE_GROUPS_ALL#

[top of page]

Table: GMS_ENCUMBRANCE_ITEMS_ALL

Description: Manual encumbrance charged to sponsored projects
Primary Key: GMS_ENCUMBRANCE_ITEMS_ALL_PK
  1. ENCUMBRANCE_ITEM_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GMS_ENCUMBRANCE_ITEMS_ALL.PEL_EXPENDITURE_ITEM_ID PA_EXPENDITURE_ITEMS_ALL
GMS_ENCUMBRANCE_ITEMS_ALL.PET_PROJECT_ID
GMS_ENCUMBRANCE_ITEMS_ALL.PET_EVENT_NUM 		PA_EVENTS
Comments

GMS_ENCUMBRANCE_ITEMS_ALL stores the manual encumbrance transactions for a sponsored project by task, award, encumbrance type, and organization. Encumbrances are similar to expenditures except that encumbrances are allowed in currency only and cannot be billed or generate revenue.
Encumbrances can be manual (pre-approved) or interfaced from Oracle Labor Distribution.

Indexes
Index Type Tablespace Column
GMS_ENCUMBRANCE_ITEMS_ALL_U1 UNIQUE APPS_TS_TX_IDX ENCUMBRANCE_ITEM_ID
GMS_ENCUMBRANCE_ITEMS_ALL_N1 NONUNIQUE APPS_TS_TX_IDX ENCUMBRANCE_ID
GMS_ENCUMBRANCE_ITEMS_ALL_N2 NONUNIQUE APPS_TS_TX_IDX TASK_ID
GMS_ENCUMBRANCE_ITEMS_ALL_N3 NONUNIQUE APPS_TS_TX_IDX PROJECT_ID
GMS_ENCUMBRANCE_ITEMS_ALL_N4 NONUNIQUE APPS_TS_TX_IDX ORIG_TRANSACTION_REFERENCE
GMS_ENCUMBRANCE_ITEMS_ALL_N5 NONUNIQUE APPS_TS_TX_IDX ENCUMBRANCE_ITEM_DATE
GMS_ENCUMBRANCE_ITEMS_ALL_N6 NONUNIQUE APPS_TS_TX_IDX ENC_DISTRIBUTED_FLAG
GMS_ENCUMBRANCE_ITEMS_ALL_N7 NONUNIQUE APPS_TS_TX_IDX IND_COMPILED_SET_ID
Columns
Name Datatype Length Mandatory Comments
ENCUMBRANCE_ITEM_ID NUMBER (15) Y System-generated number that uniquely identifies the encumbrance item
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
ENCUMBRANCE_ID NUMBER (15) Y Identifier of the encumbrance to which the encumbrance item belongs
TASK_ID NUMBER (15) Y Identifier of the task to which the encumbrance item is charged
ENCUMBRANCE_ITEM_DATE DATE
Y Date on which the work occurred
ENCUMBRANCE_TYPE VARCHAR2 (30) Y Encumbrance type that classifies the type of work performed
ENC_DISTRIBUTED_FLAG VARCHAR2 (1) Y Encumbrance type that classifies the type of work performed
OVERRIDE_TO_ORGANIZATION_ID NUMBER (15)
Identifier of the organization that the cost and revenue for this item are charged to by a cost distribution override entered for the project. For supplier invoices, the encumbrance organization entered in Oracle Payables.
ADJUSTED_ENCUMBRANCE_ITEM_ID NUMBER (15)
Identifier of the encumbrance item adjusted by this encumbrance item. Adjustment items are entered by users with negative amounts to fully reverse an item, or are system created to reverse a transferred item.
NET_ZERO_ADJUSTMENT_FLAG VARCHAR2 (1)
Flag that indicates whether the item is fully reversed or the item is one of the adjusting items that fully reverse another item. Generate Draft Invoice uses the flag to exclude fully reversed, uninvoiced items from a customer invoice.
TRANSFERRED_FROM_ENC_ITEM_ID NUMBER (15)
Identifier of the encumbrance item from which this encumbrance item originated. This encumbrance item is the new item that is system created when an item is transferred and is charged to the new project/task.
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
REQUEST_ID NUMBER (15)
Standard Who column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield context field
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield context field
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield context field
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield context field
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield context field
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield context field
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield context field
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield context field
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield context field
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield context field
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield context field
ORIG_TRANSACTION_REFERENCE VARCHAR2 (30)
Only populated for encumbrance items created from transactions imported into Projects from an external system. The TRANSACTION_SOURCE and ORIG_TRANSACTION_REFERENCE columns together identify the encumbrance item created after import.
TRANSACTION_SOURCE VARCHAR2 (30)
Only populated for encumbrance items created from transactions imported into Projects from an external system. Used by Project's encumbrance item adjustment modules and costing programs to ensure the proper processing on imported items.
PROJECT_ID NUMBER (15)
The project_id of the event that the encumbrance item is FIFO marked by
SOURCE_ENCUMBRANCE_ITEM_ID NUMBER (15)
Only populated for related items created in Project's Labor Extensions. This number is the identifier of the source encumbrance item to which this item is related.
JOB_ID NUMBER (15)
Identifier of the job of an employee as of the encumbrance item date. Required for all items incurred by an employee. This may be used in the mapping of the transaction to a resource for project summary amounts.
ORG_ID NUMBER (15)
Operating unit identifier for multi-organization installations
SYSTEM_LINKAGE_FUNCTION VARCHAR2 (3) Y System linkage that classifies the encumbrance type in order to drive system processing for the items classified by the encumbrance type
DENOM_CURRENCY_CODE VARCHAR2 (15)
Transaction currency code of the transaction
ACCT_CURRENCY_CODE VARCHAR2 (15)
Account currency code of the transaction
ACCT_RATE_DATE DATE

Functional rate date for the transaction
ACCT_RATE_TYPE VARCHAR2 (30)
Functional rate type for the transaction
ACCT_EXCHANGE_RATE NUMBER

Functional exchange rate for the transaction
ACCT_EXCHANGE_ROUNDING_LIMIT NUMBER

Rounding limit for imported transaction
PROJECT_CURRENCY_CODE VARCHAR2 (15)
Project currency code of transaction
PROJECT_RATE_DATE DATE

Project rate date for transaction
PROJECT_RATE_TYPE VARCHAR2 (30)
Project rate type for transaction
PROJECT_EXCHANGE_RATE NUMBER

Project exchange rate for transaction
DENOM_TP_CURRENCY_CODE VARCHAR2 (15)
Transaction currency code of the transfer price
DENOM_TRANSFER_PRICE NUMBER

Transfer price in the transaction currency
PROJACCT_TRANSFER_PRICE NUMBER

Transfer price in functional currency of the provider operating unit
AMOUNT NUMBER (22)
Amount of the particular encumbrance item
ENCUMBRANCE_COMMENT VARCHAR2 (240)
Comments for encumbrance item
IND_COMPILED_SET_ID NUMBER (15)
Ind Compiled set identifier for encumbrance
PA_DATE DATE

Projects period end date for the encumbrance item
GL_DATE DATE

General Ledger period end date for the encumbrance item
LINE_NUM NUMBER

Reference line number stored in GMS_AWARD_DISTRIBUTIONS table for encumbrance item
BURDEN_SUM_DEST_RUN_ID NUMBER (15)
Burden summarization run identifier. Identifier identifies all the encumbrance items created by burden component summarization. This is used to identify all the cost distribution lines summarized together to create an encumbrance item.
BURDEN_SUM_SOURCE_RUN_ID NUMBER (4)
Identifies group of Encumbrance Distribution Lines that were summarized to create summarized burden components encumbrance items (EI). The same run_id is populated in the EI table to identify all EI created during a run.
DENOM_RAW_AMOUNT NUMBER

For future use
INCURRED_BY_PERSON_ID NUMBER (9)
Not currently used
PERSON_ID NUMBER (9)
Not currently used
ACCT_RAW_COST NUMBER

Raw cost of the encumbrance item in accounting currency
ADJUSTMENT_TYPE VARCHAR2 (150)
Adjustment Type Code

[top of page]

GMS.GMS_ENCUMBRANCE_ITEMS_ALL does not reference any database object

GMS.GMS_ENCUMBRANCE_ITEMS_ALL is referenced by following:

GMS
VIEW - GMS_ENCUMBRANCE_ITEMS_ALL#

[top of page]

Table: GMS_EVENT_ATTRIBUTE

Description: Additional information on billing events for mapping billing event information maintained in PA_EVENTS table
Foreign Keys from this table:
Foreign Key Column Foreign Table
GMS_EVENT_ATTRIBUTE.PROJECT_ID
GMS_EVENT_ATTRIBUTE.EVENT_NUM 		PA_EVENTS
Comments

GMS_EVENT_ATTRIBUTE stores additional information on billing events for mapping billing event information maintained in the PA_EVENTS table. It maintains a one-to-one relation for manual events entered for billing for awards.

Indexes
Index Type Tablespace Column
GMS_EVENT_ATTRIBUTE_N1 NONUNIQUE APPS_TS_TX_IDX ACTUAL_PROJECT_ID
ACTUAL_TASK_ID
INSTALLMENT_ID
GMS_EVENT_ATTRIBUTE_N2 NONUNIQUE APPS_TS_TX_IDX PROJECT_ID
EVENT_NUM
INSTALLMENT_ID
Columns
Name Datatype Length Mandatory Comments
PROJECT_ID NUMBER (15) Y Stores award project identifier
EVENT_NUM NUMBER (15)
Stores event number
INSTALLMENT_ID NUMBER (15) Y Stores installment identifier against which event is charged
ACTUAL_PROJECT_ID NUMBER (15)
Stores Project identifier to which related expenditures are charged
ACTUAL_TASK_ID NUMBER (15)
Stores task identifier to which related expenditures are charged
BURDEN_COST_CODE VARCHAR2 (30)
Stores burden cost code of the related expenditure item
EXPENDITURE_ORG_ID NUMBER (15)
Expenditure Organization identifier for the related expenditure item
BILL_AMOUNT NUMBER (22)
Invoice amount on the event
REVENUE_AMOUNT NUMBER (22)
Revenue amount on the event
WRITE_OFF_AMOUNT NUMBER (22)
Amount written off the event, for invoices
CREATED_BY NUMBER

Standard Who column
CREATED_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER

Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
REVENUE_ACCUMULATED VARCHAR2 (1)
Flag indicating the revenue accumulated status in GMS_BALANCES
RESOURCE_LIST_MEMBER_ID NUMBER (15)
Resource list member identifier to which the billing event is mapped to
REQUEST_ID NUMBER (15)
Concurrent process identifier which created the event
EXPENDITURE_TYPE VARCHAR2 (30)
Expenditure type
EVENT_CALLING_PROCESS VARCHAR2 (30)
Calling process. Invoice or Revenue.

[top of page]

GMS.GMS_EVENT_ATTRIBUTE does not reference any database object

GMS.GMS_EVENT_ATTRIBUTE is referenced by following:

GMS
VIEW - GMS_EVENT_ATTRIBUTE#

[top of page]

Table: GMS_EVENT_INTERSECT

Description: Relationship between expenditure items and events
Foreign Keys from this table:
Foreign Key Column Foreign Table
GMS_EVENT_INTERSECT.AWARD_PROJECT_ID
GMS_EVENT_INTERSECT.EVENT_NUM 		PA_EVENTS
GMS_EVENT_INTERSECT.EXPENDITURE_ITEM_ID PA_EXPENDITURE_ITEMS_ALL
Comments

GMS_EVENT_INTERSECT holds information about the expenditure items that are processed for billing and revenue accrual under the cost distribution rule.

Indexes
Index Type Tablespace Column
GMS_EVENT_INTERSECT_U1 UNIQUE APPS_TS_TX_IDX EXPENDITURE_ITEM_ID
EVENT_NUM
REQUEST_ID
EVENT_TYPE
AWARD_PROJECT_ID
ADL_LINE_NUM
GMS_EVENT_INTERSECT_N1 NONUNIQUE APPS_TS_TX_IDX AWARD_PROJECT_ID
REQUEST_ID
GMS_EVENT_INTERSECT_N10 NONUNIQUE APPS_TS_TX_IDX REVENUE_ACCUMULATED
EVENT_TYPE
GMS_EVENT_INTERSECT_N2 NONUNIQUE APPS_TS_TX_IDX AWARD_PROJECT_ID
EVENT_NUM
EXPENDITURE_ITEM_ID
EVENT_TYPE
GMS_EVENT_INTERSECT_N3 NONUNIQUE APPS_TS_TX_IDX REVENUE_ACCUMULATED
Columns
Name Datatype Length Mandatory Comments
EXPENDITURE_ITEM_ID NUMBER (15) Y Unique identifier of expenditure item processed for billing or revenue
EVENT_NUM NUMBER (15)
Event number of automatic event for the award project created as a result of expenditure item being processed
AMOUNT NUMBER (22) Y Amount of expenditure item that is billed
REQUEST_ID NUMBER
Y Request identifier of the concurrent process that is processing expenditure item for billing or revenue. This, along with the project identifier, is used to update the event number and standard Who columns in the table.
EVENT_TYPE VARCHAR2 (15)
Event type of the event created. Revenue indicates revenue generation events and Invoice indicates billing events.
AWARD_PROJECT_ID NUMBER (15) Y Award project unique identifier associated with the award for which billing or revenue is run
ADL_LINE_NUM NUMBER (15) Y Award Distribution line number
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER

Standard Who column
CREATION_DATE DATE

Standard Who column
CREATED_BY NUMBER

Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
REVENUE_ACCUMULATED VARCHAR2 (1)
Flag indicating revenue accumulation status in balances

[top of page]

GMS.GMS_EVENT_INTERSECT does not reference any database object

GMS.GMS_EVENT_INTERSECT is referenced by following:

GMS
VIEW - GMS_EVENT_INTERSECT#

[top of page]

Table: GMS_FP_DISTRIBUTIONS

Description: Stores the funding pattern distribution details for a defined funding pattern
Primary Key: GMS_FP_DIST_PK
  1. FUNDING_PATTERN_ID
  2. AWARD_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GMS_FP_DISTRIBUTIONS.FUNDING_PATTERN_ID GMS_FUNDING_PATTERNS_ALL
Comments

GMS_FP_DISTRIBUTIONS stores the funding pattern distribution details for each funding pattern. The distribution can be maintained as percentages across different awards for a sponsored project. The information will be used for automatically charging one transaction to different awards.

Indexes
Index Type Tablespace Column
GMS_FP_DISTRIBUTIONS_U1 UNIQUE APPS_TS_TX_IDX FUNDING_PATTERN_ID
AWARD_ID
Columns
Name Datatype Length Mandatory Comments
FUNDING_PATTERN_ID NUMBER (15) Y System generated identifier for a funding pattern
DISTRIBUTION_NUMBER NUMBER (15)
Sequence number of the distribution in a funding pattern
AWARD_ID NUMBER (15) Y Award identifier of the funding pattern distribution
DISTRIBUTION_VALUE NUMBER (7) Y Percentage value of the distribution in the funding pattern
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]

GMS.GMS_FP_DISTRIBUTIONS does not reference any database object

GMS.GMS_FP_DISTRIBUTIONS is referenced by following:

GMS
VIEW - GMS_FP_DISTRIBUTIONS#

[top of page]

Table: GMS_FUNDING_PATTERNS_ALL

Description: Rule definition for charging transactions of a sponsored project to funding awards
Primary Key: GMS_FUNDING_PATTERN_PK
  1. FUNDING_PATTERN_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
GMS_FP_DISTRIBUTIONS.FUNDING_PATTERN_ID GMS_FUNDING_PATTERNS_ALL
Comments

GMS_FUNDIN_PATTERNS_AL stores the rule definition for charging transactions of a sponsored project to funding awards. Multiple funding pattern definitions can exist for a sponsored project.

Indexes
Index Type Tablespace Column
GMS_FUNDING_PATTERNS_ALL_U1 UNIQUE APPS_TS_TX_IDX FUNDING_PATTERN_ID
GMS_FUNDING_PATTERNS_ALL_N1 NONUNIQUE APPS_TS_TX_IDX PROJECT_ID
TASK_ID
Columns
Name Datatype Length Mandatory Comments
FUNDING_PATTERN_ID NUMBER (15) Y System-generated identifier for a funding pattern
ORG_ID NUMBER (15)
Multi-organization operating unit identifier to which the funding pattern belongs to
FUNDING_SEQUENCE NUMBER (15) Y Sequence number for each entry in a funding pattern
FUNDING_NAME VARCHAR2 (30) Y User-defined name for funding pattern
RETROACTIVE_FLAG VARCHAR2 (1) Y Flag indicating whether the pattern is used for retroactive adjustments
PROJECT_ID NUMBER (15) Y Project identifier for which the funding pattern is defined
TASK_ID NUMBER (15)
Task identifier for which the funding pattern is defined
STATUS VARCHAR2 (6) Y Status indicating if the funding pattern is active or not
FUNDS_STATUS VARCHAR2 (1)
Status indicates the funds availability for a funding pattern
START_DATE DATE
Y Start date for the funding pattern is active
END_DATE DATE

Start date for the funding pattern is active
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]

GMS.GMS_FUNDING_PATTERNS_ALL does not reference any database object

GMS.GMS_FUNDING_PATTERNS_ALL is referenced by following:

GMS
VIEW - GMS_FUNDING_PATTERNS_ALL#

[top of page]

Table: GMS_IMPLEMENTATIONS_ALL

Description: Implementation options for award numbering method setup
Comments

GMS_IMPLEMENTATIONS_ALL stores the user-defined award numbering method, the manual award numbering type, and the next available sequence-generated award number for setting up award implementation options.

Indexes
Index Type Tablespace Column
GMS_IMPLEMENTATIONS_U1 UNIQUE APPS_TS_SEED ORG_ID
Columns
Name Datatype Length Mandatory Comments
USER_DEFINED_AWARD_NUM_CODE VARCHAR2 (25) Y Identifier that stores whether the award numbering is manual or automatic
MANUAL_AWARD_NUM_TYPE VARCHAR2 (25)
Identifier that stores whether the manual award numbering type is numeric or alphanumeric
NEXT_AUTOMATIC_AWARD_NUMBER NUMBER (15)
Next available automatic award number from designated sequence
AWARD_DISTRIBUTION_OPTION VARCHAR2 (1) Y Indicates implementation-specific distribution option for transactions . Transactions can be distributed to one award or many awards.
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
ENABLED VARCHAR2 (1) Y Flag used for enabling and disabling Grants Accounting extensions on all the modules for which Grants is integrated
ORG_ID NUMBER (15)
Operating unit identifier for a multiple organization
DEFAULT_DIST_AWARD_NUMBER VARCHAR2 (15)
Default distribution award number given by the user at the time of implementation
DEFAULT_DIST_AWARD_ID NUMBER (15)
Default distribution award id defaulted by the system

[top of page]

GMS.GMS_IMPLEMENTATIONS_ALL does not reference any database object

GMS.GMS_IMPLEMENTATIONS_ALL is referenced by following:

GMS
VIEW - GMS_IMPLEMENTATIONS_ALL#

[top of page]

Table: GMS_IND_COST_CODES

Description: Additional information related to indirect cost codes maintained in PA_IND_COST_CODES
Primary Key: GMS_IND_COST_CODES_U1
  1. IND_COST_CODE
Comments

GMS_IND_COST_CODES stores the additional information for each indirect cost code maintained in the PA_IND_COST_CODES table. There is a one-to-one relationship between PA_IND_COST_CODES and GMS_IND_COST_CODES.

Indexes
Index Type Tablespace Column
GMS_IND_COST_CODE_U1 UNIQUE APPS_TS_SEED IND_COST_CODE
Columns
Name Datatype Length Mandatory Comments
IND_COST_CODE VARCHAR2 (30) Y Indirect cost code
REPORT_DIRECT_FLAG VARCHAR2 (1)
Indicates if the indirect cost should be reported as direct costing the 1034 or 1035 reports

[top of page]

GMS.GMS_IND_COST_CODES does not reference any database object

GMS.GMS_IND_COST_CODES is referenced by following:

GMS
VIEW - GMS_IND_COST_CODES#

[top of page]

Table: GMS_INSTALLMENTS

Description: Information about installments
Comments

GMS_INSTALLMENTS stores information about the installments, supplements, or amendments for a particular award, depending on the Type field of the GMS_INSTALLMENTS. A supplement is an extension of an installment, while an amendment is purely for documentation purposes and has no funding capability.

Indexes
Index Type Tablespace Column
GMS_INSTALLMENTS_U1 UNIQUE APPS_TS_TX_IDX INSTALLMENT_ID
GMS_INSTALLMENTS_U2 UNIQUE APPS_TS_TX_IDX AWARD_ID
INSTALLMENT_NUM
Columns
Name Datatype Length Mandatory Comments
INSTALLMENT_ID NUMBER (15) Y Installment identifier
INSTALLMENT_NUM VARCHAR2 (15)
Installment number given by user
LAST_UPDATE_DATE DATE

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

Standard Who column
CREATED_BY NUMBER (15)
Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
AWARD_ID NUMBER (15)
Identifier for the award this installment belongs to
START_DATE_ACTIVE DATE

First effective date of installment
END_DATE_ACTIVE DATE

Last effective date of installment
CLOSE_DATE DATE

Close date of installment
DIRECT_COST NUMBER

Direct cost of installment
INDIRECT_COST NUMBER

Indirect cost of installment
ACTIVE_FLAG VARCHAR2 (10)
Active status flag of installment. Immediate indicates Active and Deferred indicates Inactive.
TYPE VARCHAR2 (30)
Installment type. Possible values can be Award, Amendment, or Supplement.
ISSUE_DATE DATE

Installment issue date
DESCRIPTION VARCHAR2 (250)
Description
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
BILLABLE_FLAG VARCHAR2 (1)
Billable flag
PROPOSAL_ID NUMBER (15)
Proposal Identifier

[top of page]

GMS.GMS_INSTALLMENTS does not reference any database object

GMS.GMS_INSTALLMENTS is referenced by following:

GMS
VIEW - GMS_INSTALLMENTS#

[top of page]

Table: GMS_NOTIFICATIONS

Description: Record of notifications sent to users about award events
Foreign Keys from this table:
Foreign Key Column Foreign Table
GMS_NOTIFICATIONS.USER_ID FND_USER
Comments

GMS_NOTIFICATIONS stores USER_IDS receiving notifications associated with different event types.

Indexes
Index Type Tablespace Column
GMS_NOTIFICATIONS_U1 UNIQUE APPS_TS_TX_IDX AWARD_ID
EVENT_TYPE
USER_ID
Columns
Name Datatype Length Mandatory Comments
AWARD_ID NUMBER (15) Y Award identifier
EVENT_TYPE VARCHAR2 (30) Y Award event type, for which notifcation is sent
USER_ID NUMBER (15) Y User identfier

[top of page]

GMS.GMS_NOTIFICATIONS does not reference any database object

GMS.GMS_NOTIFICATIONS is referenced by following:

GMS
VIEW - GMS_NOTIFICATIONS#

[top of page]

Table: GMS_OVERRIDE_SCHEDULES

Description: Information about Indirect Cost Rate Override Schedules defined on an award
Primary Key: GMS_OVERRIDE_SCHEDULES_PK
  1. AWARD_ID
  2. PROJECT_ID
Primary Key: GMS_OVERRIDE_SCHEDULES_UK
  1. AWARD_ID
  2. PROJECT_ID
  3. TASK_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GMS_OVERRIDE_SCHEDULES.PROJECT_ID PA_PROJECTS_ALL
GMS_OVERRIDE_SCHEDULES.TASK_ID PA_TASKS
GMS_OVERRIDE_SCHEDULES.IDC_SCHEDULE_ID PA_IND_RATE_SCHEDULES_ALL_BG
Comments

GMS_OVERRIDE_SCHEDULES stores information about Indirect Cost Rate Override schedules defined on an award.

Indexes
Index Type Tablespace Column
GMS_OVERRIDE_SCHEDULES_U2 UNIQUE APPS_TS_TX_IDX AWARD_ID
PROJECT_ID
TASK_ID
Columns
Name Datatype Length Mandatory Comments
AWARD_ID NUMBER (15) Y Unique identifier for an award. Primary key.
PROJECT_ID NUMBER (15) Y Number that uniquely identifies the project.. Primary Key.
TASK_ID NUMBER (15)
Number that uniquely identifies the Task. primary key.
IDC_SCHEDULE_ID NUMBER (15) Y Identifier for indirect cost rate schedule of the award
COST_IND_SCH_FIXED_DATE DATE

Fixed date for indirect cost rate schedule
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]

GMS.GMS_OVERRIDE_SCHEDULES does not reference any database object

GMS.GMS_OVERRIDE_SCHEDULES is referenced by following:

GMS
VIEW - GMS_OVERRIDE_SCHEDULES#

[top of page]

Table: GMS_PERSONNEL

Description: Personnel of award
Comments

GMS_PERSONNEL stores information about the personnel involved in a particular award.

Indexes
Index Type Tablespace Column
GMS_PERSONNEL_U1 UNIQUE APPS_TS_TX_IDX AWARD_ID
PERSON_ID
AWARD_ROLE
START_DATE_ACTIVE
Columns
Name Datatype Length Mandatory Comments
AWARD_ID NUMBER (15) Y Award identifier
PERSON_ID NUMBER (15) Y Person identifier
AWARD_ROLE VARCHAR2 (30) Y Award role for the 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
START_DATE_ACTIVE DATE

First effective date of the person
END_DATE_ACTIVE DATE

Last effective date of the person
PERSONNEL_ID NUMBER (15) Y Personnel unique identifier
REQUIRED_FLAG VARCHAR2 (2)
Required flag

[top of page]

GMS.GMS_PERSONNEL does not reference any database object

GMS.GMS_PERSONNEL is referenced by following:

GMS
VIEW - GMS_PERSONNEL#

[top of page]

Table: GMS_PROJECT_FUNDINGS

Description: Incremental amounts of allocated funds from installments to project and tasks
Comments

GMS_PROJECT_FUNDINGS stores the installment-funded projects and funding amounts.

Indexes
Index Type Tablespace Column
GMS_PROJECT_FUNDINGS_U1 UNIQUE APPS_TS_TX_IDX GMS_PROJECT_FUNDING_ID
GMS_PROJECT_FUNDINGS_N1 NONUNIQUE APPS_TS_TX_IDX INSTALLMENT_ID
Columns
Name Datatype Length Mandatory Comments
GMS_PROJECT_FUNDING_ID NUMBER
Y Project funding identifier for Oracle Grants Accounting
PROJECT_FUNDING_ID NUMBER

Project funding identifier for Oracle Projects
PROJECT_ID NUMBER
Y Project identifier
TASK_ID NUMBER

Task identifier
INSTALLMENT_ID NUMBER
Y Installment identifier
FUNDING_AMOUNT NUMBER
Y Funding amount
DATE_ALLOCATED DATE
Y Date on which funding allocated
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]

GMS.GMS_PROJECT_FUNDINGS does not reference any database object

GMS.GMS_PROJECT_FUNDINGS is referenced by following:

GMS
VIEW - GMS_PROJECT_FUNDINGS#

[top of page]

Table: GMS_PROJECT_TYPES_ALL

Description: Additional information on project types maintained in PA_PROJECT_TYPES
Comments

GMS_PROJECT_TYPES stores additional information on project types maintained in PA_PROJECT_TYPES. There is a one-to-one relation between PA_PROJECT_TYPES and GMS_PROJECT_TYPES.

Indexes
Index Type Tablespace Column
GMS_PROJECT_TYPES_ALL_U1 UNIQUE APPS_TS_SEED PROJECT_TYPE
Columns
Name Datatype Length Mandatory Comments
PROJECT_TYPE VARCHAR2 (20) Y Project type
SPONSORED_FLAG VARCHAR2 (1) Y Indicates if the project type is sponsored

[top of page]

GMS.GMS_PROJECT_TYPES_ALL does not reference any database object

GMS.GMS_PROJECT_TYPES_ALL is referenced by following:

GMS
VIEW - GMS_PROJECT_TYPES_ALL#

[top of page]

Table: GMS_REFERENCE_NUMBERS

Description: Reference numbers of award
Primary Key: GMS_REFERENCE_NUMBERS_PK
  1. AWARD_ID
  2. TYPE
  3. VALUE
Comments

GMS_REFERENCE_NUMBERS stores the references associated with a particular award. The user can define and describe as many references as needed.

Indexes
Index Type Tablespace Column
GMS_REFERENCE_NUMBERS_U1 UNIQUE APPS_TS_TX_IDX AWARD_ID
TYPE
VALUE
Columns
Name Datatype Length Mandatory Comments
AWARD_ID NUMBER (15) Y Award identifier
TYPE VARCHAR2 (30) Y Reference 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
VALUE VARCHAR2 (30) Y Value of the reference
REQUIRED_FLAG VARCHAR2 (2)
Required flag

[top of page]

GMS.GMS_REFERENCE_NUMBERS does not reference any database object

GMS.GMS_REFERENCE_NUMBERS is referenced by following:

GMS
VIEW - GMS_REFERENCE_NUMBERS#

[top of page]

Table: GMS_REPORTS

Description: Reports of installment
Comments

GMS_REPORTS stores the installment level reports. The reports can be monthly, quarterly, annually, end of installment, or end of award.

Indexes
Index Type Tablespace Column
GMS_REPORTS_U1 UNIQUE APPS_TS_TX_IDX REPORT_ID
GMS_REPORTS_U2 NONUNIQUE APPS_TS_TX_IDX INSTALLMENT_ID
REPORT_TEMPLATE_ID
REPORT_ID
Columns
Name Datatype Length Mandatory Comments
REPORT_ID NUMBER (15)
Report identifier
INSTALLMENT_ID NUMBER (15) Y Installment identifier
REPORT_TEMPLATE_ID NUMBER (15) Y Report template 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
SITE_USE_ID NUMBER (15)
Site code where report is to be delivered
COPY_NUMBER NUMBER (15) Y Number of report copies to be sent out
FILED_BY NUMBER (15)
Report filer name
DUE_DATE DATE

Report due date
DATE_FILED DATE

Date report filed
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

[top of page]

GMS.GMS_REPORTS does not reference any database object

GMS.GMS_REPORTS is referenced by following:

GMS
VIEW - GMS_REPORTS#

[top of page]

Table: GMS_REPORT_TEMPLATES

Description: Implementation-defined report templates
Comments

GMS_REPORT_TEMPLATES stores the implementation-defined report templates. Report types can be agency specific, electronic data interchange, or other types defined by the user.

Indexes
Index Type Tablespace Column
GMS_REPORT_TEMPLATES_U1 UNIQUE APPS_TS_SEED REPORT_TEMPLATE_ID
GMS_REPORT_TEMPLATES_U2 UNIQUE APPS_TS_SEED REPORT_NAME
Columns
Name Datatype Length Mandatory Comments
REPORT_TEMPLATE_ID NUMBER (15) Y Report template identifier
LAST_UPDATE_DATE DATE
Y Standard Who column
REPORT_NAME VARCHAR2 (60) Y Report template name
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
TYPE VARCHAR2 (30) Y Report type
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
START_DATE_ACTIVE DATE

First effective date
END_DATE_ACTIVE DATE

Last effective date
TRANSACTION_NUMBER NUMBER (15)
Report transaction number
AGENCY_SPECIFIC_FORM VARCHAR2 (60)
Agency specific form name of the report
DESCRIPTION VARCHAR2 (250)
Description
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

[top of page]

GMS.GMS_REPORT_TEMPLATES does not reference any database object

GMS.GMS_REPORT_TEMPLATES is referenced by following:

GMS
VIEW - GMS_REPORT_TEMPLATES#

[top of page]

Table: GMS_RESOURCE_ASSIGNMENTS

Description: Resource assignments for a budget version at a branch of project's work breakdown
Primary Key: GMS_RESOURCE_ASSIGNMENTS_PK
  1. RESOURCE_ASSIGNMENT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
GMS_RESOURCE_ASSIGNMENTS.BUDGET_VERSION_ID GMS_BUDGET_VERSIONS
GMS_RESOURCE_ASSIGNMENTS.PROJECT_ID PA_PROJECTS_ALL
GMS_RESOURCE_ASSIGNMENTS.TASK_ID PA_TASKS
GMS_RESOURCE_ASSIGNMENTS.RESOURCE_LIST_MEMBER_ID PA_RESOURCE_LIST_MEMBERS
Foreign Keys to this table:
Foreign Key Column Foreign Table
GMS_BUDGET_LINES.RESOURCE_ASSIGNMENT_ID GMS_RESOURCE_ASSIGNMENTS
Comments

GMS_RESOURCE_ASSIGNMENTS stores the resource assignments for a budget version at a branch of a project's work breakdown structure. A user can enter a budget at project, top task, or lowest task levels.

Indexes
Index Type Tablespace Column
GMS_RESOURCE_ASSIGNMENTS_U1 UNIQUE APPS_TS_TX_IDX RESOURCE_ASSIGNMENT_ID
GMS_RESOURCE_ASSIGNMENTS_U2 UNIQUE APPS_TS_TX_IDX BUDGET_VERSION_ID
PROJECT_ID
TASK_ID
RESOURCE_LIST_MEMBER_ID
GMS_RESOURCE_ASSIGNMENTS_N2 NONUNIQUE APPS_TS_TX_IDX TASK_ID
Columns
Name Datatype Length Mandatory Comments
RESOURCE_ASSIGNMENT_ID NUMBER (15) Y System-generated number that uniquely identifies the resource assignment
BUDGET_VERSION_ID NUMBER (15) Y Identifier of the budget version that the resource is assigned to
PROJECT_ID NUMBER (15) Y Identifier of the project that the resource is assigned to
TASK_ID NUMBER (15) Y Identifier of the task that the resource is assigned to. This is set to 0 if the budget is entered at the project level.
RESOURCE_LIST_MEMBER_ID NUMBER (15) Y Identifier of the resource list member within the resource list that is assigned to the budget
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
UNIT_OF_MEASURE VARCHAR2 (30)
Unit of measure of the resource. This is a denormalized column.
TRACK_AS_LABOR_FLAG VARCHAR2 (1)
Flag that indicates if the resource is a labor item. This is a denormalized column.

[top of page]

GMS.GMS_RESOURCE_ASSIGNMENTS does not reference any database object

GMS.GMS_RESOURCE_ASSIGNMENTS is referenced by following:

GMS
VIEW - GMS_RESOURCE_ASSIGNMENTS#

[top of page]

Table: GMS_SUMMARY_PROJECT_FUNDINGS

Description: Summary funding amounts allocated from installment to project and tasks
Comments

GMS_SUMMARY_PROJECT_FUNDINGS stores the summarized funding amount information of the funded projects.

Indexes
Index Type Tablespace Column
GMS_SUMMARY_PROJECT_FUNDING_U1 UNIQUE APPS_TS_TX_IDX PROJECT_ID
TASK_ID
INSTALLMENT_ID
GMS_SUMMARY_PROJECT_FUNDING_N1 NONUNIQUE APPS_TS_TX_IDX INSTALLMENT_ID
PROJECT_ID
TASK_ID
Columns
Name Datatype Length Mandatory Comments
INSTALLMENT_ID NUMBER
Y Installment identifier
PROJECT_ID NUMBER
Y Project identifier
TASK_ID NUMBER

Task identifier
TOTAL_FUNDING_AMOUNT NUMBER
Y Total funding amount for a project and task
TOTAL_BILLED_AMOUNT NUMBER

Total billed amount for a project and task
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
REQUEST_ID NUMBER

Standard Who column
TOTAL_REVENUE_AMOUNT NUMBER (22)
Total revenue amount for a project and task

[top of page]

GMS.GMS_SUMMARY_PROJECT_FUNDINGS does not reference any database object

GMS.GMS_SUMMARY_PROJECT_FUNDINGS is referenced by following:

GMS
VIEW - GMS_SUMMARY_PROJECT_FUNDINGS#

[top of page]

Table: GMS_TC_CATEGORIES

Description: Implementation-defined terms and conditions categories
Comments

GMS_TC_CATEGORIES stores the implementation-defined terms and condition categories of an award.

Indexes
Index Type Tablespace Column
GMS_TC_CATEGORIES_U1 UNIQUE APPS_TS_SEED CATEGORY_ID
GMS_TC_CATEGORIES_U2 UNIQUE APPS_TS_SEED NAME
Columns
Name Datatype Length Mandatory Comments
CATEGORY_ID NUMBER (15) Y Category identifier
NAME VARCHAR2 (30) Y Category 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]

GMS.GMS_TC_CATEGORIES does not reference any database object

GMS.GMS_TC_CATEGORIES is referenced by following:

GMS
VIEW - GMS_TC_CATEGORIES#

[top of page]

Table: GMS_TERMS_CONDITIONS

Description: Implementation-defined terms and conditions
Comments

GMS_TERMS_CONDITIONS stores the terms and conditions used by the award. The user defines both the categories and the terms and conditions as determined by the award.

Indexes
Index Type Tablespace Column
GMS_TERMS_CONDITIONS_U2 UNIQUE APPS_TS_SEED CATEGORY_ID
NAME
GMS_TERMS_CONDITIONS_U3 UNIQUE APPS_TS_SEED NAME
TERM_ID
GMS_TERMS_CONDITIONS_U1 NONUNIQUE APPS_TS_SEED TERM_ID
Columns
Name Datatype Length Mandatory Comments
TERM_ID NUMBER (15) Y Term identifier
CATEGORY_ID NUMBER (15)
Category identifier
NAME VARCHAR2 (30) Y Terms and conditions 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
DESCRIPTION VARCHAR2 (240)
Description
START_DATE_ACTIVE DATE

First effective date of terms and conditions
END_DATE_ACTIVE DATE

Last effective date of terms and conditions

[top of page]

GMS.GMS_TERMS_CONDITIONS does not reference any database object

GMS.GMS_TERMS_CONDITIONS is referenced by following:

GMS
VIEW - GMS_TERMS_CONDITIONS#

[top of page]

Table: GMS_TRANSACTION_INTERFACE_ALL

Description: Extension to PA_TRANSACTION_INTERFACE_ALL to maintain additional information
Primary Key: TXN_INTERFACE_ID_UK
  1. TXN_INTERFACE_ID
Comments

GMS_TRANSACTION_INTERFACE_ALL stores additional information on transactions to be interfaced to Grants Accounting for each transaction created in the PA_TRANSACTION_INTERFACE_ALL table.

Indexes
Index Type Tablespace Column
GMS_TXN_XFACE_U1 UNIQUE APPS_TS_INTERFACE TXN_INTERFACE_ID
GMS_TXN_XFACE_N1 NONUNIQUE APPS_TS_INTERFACE BATCH_NAME
TRANSACTION_SOURCE
TRANSACTION_STATUS_CODE
GMS_TXN_XFACE_N2 NONUNIQUE APPS_TS_INTERFACE ORIG_TRANSACTION_REFERENCE
Columns
Name Datatype Length Mandatory Comments
TXN_INTERFACE_ID NUMBER (15) Y System-generated unique identifier for a transaction to be interfaced. This is same as the TXN_INTERFACE_ID in PA_TRANSACTION_INTERFACE_ALL.
BATCH_NAME VARCHAR2 (50)
The column is obsolete
TRANSACTION_SOURCE VARCHAR2 (30)
The column is obsolete
EXPENDITURE_ENDING_DATE DATE

The column is obsolete
EXPENDITURE_ITEM_DATE DATE

The column is obsolete
PROJECT_NUMBER VARCHAR2 (25)
The column is obsolete
TASK_NUMBER VARCHAR2 (25)
The column is obsolete
AWARD_ID NUMBER (15)
The column is obsolete
EXPENDITURE_TYPE VARCHAR2 (30)
The column is obsolete
TRANSACTION_STATUS_CODE VARCHAR2 (2)
The column is obsolete
ORIG_TRANSACTION_REFERENCE VARCHAR2 (30)
The column is obsolete
ORG_ID NUMBER (15)
The column is obsolete
SYSTEM_LINKAGE VARCHAR2 (30)
The column is obsolete
USER_TRANSACTION_SOURCE VARCHAR2 (80)
The column is obsolete
TRANSACTION_TYPE VARCHAR2 (1)
Transaction type. E indicates Encumbrance, and A indicates Actuals.
BURDENABLE_RAW_COST NUMBER (22)
Amount of raw cost eligible for burdening
FUNDING_PATTERN_ID NUMBER (15)
Funding pattern identifier for the award distribution
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
AWARD_NUMBER VARCHAR2 (15)
Number identifying the award to which the transaction is charged
ORIGINAL_ENCUMBRANCE_ITEM_ID NUMBER (15)
Number identifying the Original Encumbrance Item which will be adjusted

[top of page]

GMS.GMS_TRANSACTION_INTERFACE_ALL does not reference any database object

GMS.GMS_TRANSACTION_INTERFACE_ALL is referenced by following:

GMS
VIEW - GMS_TRANSACTION_INTERFACE_ALL#

[top of page]

Table: GMS_UNIQUE_IDENTIFIER_CONTROL

Description: Next award number for automatic award numbering
Primary Key: GMS_UNIQUE_IDENTIFIER_CONT_PK
  1. TABLE_NAME
Comments

GMS_UNIQUE_IDENTIFIER_CONTROL stores the next automatic award number applied when using automatic award numbering. This value is used across all operating units in a multi-organization implementation that uses automatic award numbering.

Indexes
Index Type Tablespace Column
GMS_UNIQUE_INDENTIFIER_CONT_U1 NONUNIQUE APPS_TS_SEED TABLE_NAME
Columns
Name Datatype Length Mandatory Comments
TABLE_NAME VARCHAR2 (32) Y Table name for which next identifier was defined
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE

Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
NEXT_UNIQUE_IDENTIFIER NUMBER

Next identifier. Used to generate unique identifier for a table given in table name column.

[top of page]

GMS.GMS_UNIQUE_IDENTIFIER_CONTROL does not reference any database object

GMS.GMS_UNIQUE_IDENTIFIER_CONTROL is referenced by following:

GMS
VIEW - GMS_UNIQUE_IDENTIFIER_CONTROL#

[top of page]

Table: GMS_WF_PROCESSES

Description: Versions of award and budget workflows. There can be many workflows for an award or budget.
Comments

GMS_WF_PROCESSES stores versions of award and budget workflows. There can be many workflows for an award or budget. Typically, the ENTITY_KEY2 column is used to differentiate between draft budget and baselined budget workflows. For draft budget workflows, the ENTITY_KEY1 is the DRAFT BUDGET_VERSION_IDENTIFIER, and the ENTITY_KEY2 column is zero. For baseline budget workflows, the ENTITY_KEY1 is the DRAFT BUDGET_VERSION_IDENTIFIER, and the ENTITY_KEY2 column is the baselined BUDGETt_VERSION_IDENTIFIER.

Indexes
Index Type Tablespace Column
GMS_WF_PROCESSES_U1 UNIQUE APPS_TS_TX_IDX WF_TYPE_CODE
ITEM_TYPE
ITEM_KEY
ENTITY_KEY1
ENTITY_KEY2
Columns
Name Datatype Length Mandatory Comments
WF_TYPE_CODE VARCHAR2 (30) Y Code indicates the workflow type
ITEM_TYPE VARCHAR2 (30) Y Workflow item type
ITEM_KEY VARCHAR2 (240) Y Workflow item key
ENTITY_KEY1 VARCHAR2 (80) Y Primary key of the entity for which the workflow is initiated
ENTITY_KEY2 VARCHAR2 (80) Y Supplemental column for storing the primary key of the entity for which the workflow is initiated
DESCRIPTION VARCHAR2 (255)
Workflow description
LAST_UPDATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column

[top of page]

GMS.GMS_WF_PROCESSES does not reference any database object

GMS.GMS_WF_PROCESSES is referenced by following:

GMS
VIEW - GMS_WF_PROCESSES#

[top of page]

View: GMS_1034_REPORT_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
CATEGORY_AMOUNT NUMBER

EXPENDITURE_TYPE VARCHAR2 (30)
EXPENDITURE_ITEM_ID NUMBER (15)
EXPENDITURE_CATEGORY VARCHAR2 (30)
DESCRIPTION VARCHAR2 (250)
PROJECT_ID NUMBER (15)
REPORT_DIRECT_FLAG VARCHAR2 (1)
INVOICE_NUM NUMBER (15)

[top of page]

APPS.GMS_1034_REPORT_V references the following:

APPS
SYNONYM - GMS_IND_COST_CODES
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
SYNONYM - PA_EXPENDITURE_CATEGORIES
SYNONYM - PA_EXPENDITURE_TYPES
SYNONYM - PA_IND_COST_CODES
PACKAGE - PA_SECURITY
PACKAGE - PA_UTILS4
- GMS_DRAFT_INV_LINE_DETAILS_V

APPS.GMS_1034_REPORT_V is not referenced by any database object

[top of page]

View: GMS_ACT_PROJECTS_BASIC_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
PROJECT_ID NUMBER (15) Y Unique identifier for the project
PROJECT_NUMBER VARCHAR2 (25) Y Unique project number for the project, which could be user-defined or system-generated
PROJECT_NAME VARCHAR2 (30) Y Unique name for the project
PROJECT_TYPE_CLASS_CODE VARCHAR2 (30)
Classification code for the project type to which the project belongs
TEMPLATE_FLAG VARCHAR2 (1)
Flag indicating whether it is a project or a project template
PM_PROJECT_REFERENCE VARCHAR2 (25)
Reference number for the project, which is potentially populated by a third party's project number for that project
PROJECT_NUMBER_SORT_ORDER VARCHAR2 (25) Y Unique project number for the project
PROJECT_TYPE VARCHAR2 (20) Y Project type for the project
ORG_ID NUMBER (15)

[top of page]

APPS.GMS_ACT_PROJECTS_BASIC_V references the following:

APPS
PACKAGE - PA_SECURITY
- PA_PROJECTS_ALL
- PA_PROJECT_TYPES

APPS.GMS_ACT_PROJECTS_BASIC_V is not referenced by any database object

[top of page]

View: GMS_AWARDS_BASIC_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
AWARD_ID NUMBER (15) Y Unique identifier for the award
AWARD_NUMBER VARCHAR2 (15) Y A user-defined or system-generated unique number for the award
AWARD_SHORT_NAME VARCHAR2 (30) Y User-defined short name for the award
PROJECT_ID NUMBER
Y Project identifier of the project that the award is funding
TASK_ID NUMBER (15) Y Task identifier within the project that the award is funding if the funding is at the task level
PROJECT_NUMBER VARCHAR2 (25) Y Project number of the project that is funded by the award
ORG_ID NUMBER (15)

[top of page]

APPS.GMS_AWARDS_BASIC_V references the following:

APPS
SYNONYM - GMS_AWARDS
SYNONYM - GMS_BUDGET_VERSIONS
SYNONYM - GMS_INSTALLMENTS
SYNONYM - GMS_SUMMARY_PROJECT_FUNDINGS
SYNONYM - PA_TASKS
- PA_PROJECTS_ALL
APPS.GMS_AWARDS_BASIC_V is referenced by following:

APPS
VIEW - GMS_PQH_AWARDS_V

[top of page]

View: GMS_AWARDS_SRS_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
AWARD_ID NUMBER (15) Y
AWARD_NUMBER VARCHAR2 (15) Y
AWARD_SHORT_NAME VARCHAR2 (30) Y
AWARD_PROJECT_ID NUMBER (15)
AWARD_TEMPLATE_FLAG VARCHAR2 (10)
STATUS VARCHAR2 (30)
ORG_ID NUMBER (15)

[top of page]

APPS.GMS_AWARDS_SRS_V references the following:

APPS
SYNONYM - GMS_AWARDS

APPS.GMS_AWARDS_SRS_V is not referenced by any database object

[top of page]

View: GMS_AWARDS_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
AWARD_ID NUMBER (15) Y
AWARD_NUMBER VARCHAR2 (15) Y
AWARD_TEMPLATE_FLAG VARCHAR2 (10)
AWARD_PROJECT_ID NUMBER (15)
AGREEMENT_ID NUMBER (15)
FUNDING_SOURCE_ID NUMBER (15)
FUNDING_SOURCE_SHORT_NAME VARCHAR2 (360)
AWARD_SHORT_NAME VARCHAR2 (30) Y
FUNDING_SOURCE_AWARD_NUMBER VARCHAR2 (30)
AWARD_FULL_NAME VARCHAR2 (240)
START_DATE_ACTIVE DATE

END_DATE_ACTIVE DATE

CLOSE_DATE DATE

PREAWARD_DATE DATE

AWARD_TYPE VARCHAR2 (30)
AWARD_PURPOSE_CODE VARCHAR2 (30)
AWARD_PURPOSE VARCHAR2 (80)
STATUS VARCHAR2 (30)
STATUS_DIS VARCHAR2 (80)
ALLOWABLE_SCHEDULE_ID NUMBER (15)
ALLOWABLE_SCHEDULE_NAME VARCHAR2 (30)
IDC_SCHEDULE_ID NUMBER (15)
IDC_SCHEDULE_NAME VARCHAR2 (30)
REVENUE_DISTRIBUTION_RULE VARCHAR2 (30)
BILLING_FREQUENCY VARCHAR2 (30)
BILLING_CYCLE_ID NUMBER (15)
BILLING_OFFSET NUMBER (15)
BILLING_FREQUENCY_DIS VARCHAR2 (80)
BILLING_DISTRIBUTION_RULE VARCHAR2 (30)
BILLING_TERM NUMBER (15)
BILLING_TERM_DIS VARCHAR2 (15)
BILLING_FORMAT VARCHAR2 (30)
LABOR_INVOICE_FORMAT_ID NUMBER (15)
LABOR_INVOICE_FORMAT_DIS VARCHAR2 (30)
NON_LABOR_INVOICE_FORMAT_ID NUMBER (15)
NON_LABOR_INVOICE_FORMAT_DIS VARCHAR2 (30)
TRANSACTION_NUMBER VARCHAR2 (60)
BILL_TO_CUSTOMER_ID NUMBER (15)
BILL_TO_CUSTOMER_DIS VARCHAR2 (360)
AGENCY_SPECIFIC_FORM VARCHAR2 (60)
AGREEMENT_NUM VARCHAR2 (50)
HARD_LIMIT_FLAG VARCHAR2 (1) Y
FUND_CONTROL_LEVEL_AWARD VARCHAR2 (30)
FUND_CONTROL_LEVEL_AWARD_DIS VARCHAR2 (80)
FUND_CONTROL_LEVEL_TASK VARCHAR2 (30)
FUND_CONTROL_LEVEL_TASK_DIS VARCHAR2 (80)
FUND_CONTROL_LEVEL_RES_GRP VARCHAR2 (30)
FUND_CONTROL_LEVEL_RES_GRP_DIS VARCHAR2 (80)
FUND_CONTROL_LEVEL_RES VARCHAR2 (30)
FUND_CONTROL_LEVEL_RES_DIS VARCHAR2 (80)
AMOUNT_TYPE VARCHAR2 (4)
AMOUNT_TYPE_DIS VARCHAR2 (80)
BOUNDARY_CODE VARCHAR2 (2)
BOUNDARY_CODE_DIS VARCHAR2 (80)
AWARD_ORGANIZATION_ID NUMBER (15)
ORG_DIS VARCHAR2 (240)
TOTAL_REVENUE_AMOUNT NUMBER (22)
TOTAL_BILLED_AMOUNT NUMBER (22)
IDC_SCHEDULE_FIXED_DATE DATE

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)
ATTRIBUTE16 VARCHAR2 (150)
ATTRIBUTE17 VARCHAR2 (150)
ATTRIBUTE18 VARCHAR2 (150)
ATTRIBUTE19 VARCHAR2 (150)
ATTRIBUTE20 VARCHAR2 (150)
ATTRIBUTE21 VARCHAR2 (150)
ATTRIBUTE22 VARCHAR2 (150)
ATTRIBUTE23 VARCHAR2 (150)
ATTRIBUTE24 VARCHAR2 (150)
ATTRIBUTE25 VARCHAR2 (150)
TEMPLATE_START_DATE_ACTIVE DATE

TEMPLATE_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
ROW_ID ROWID (10)
UPDATE_ALLOWED VARCHAR2 (1)
BILL_TO_ADDRESS_ID NUMBER (15)
SHIP_TO_ADDRESS_ID NUMBER (15)
LOC_BILL_TO_ADDRESS_ID NUMBER (15)
LOC_SHIP_TO_ADDRESS_ID NUMBER

BUDGET_WF_ENABLED_FLAG VARCHAR2 (1)
PROPOSAL_ID NUMBER (15)
INVOICE_LIMIT_FLAG VARCHAR2 (1) Y
ORG_ID NUMBER (15)
OPERATING_UNIT VARCHAR2 (240) Y

[top of page]

APPS.GMS_AWARDS_V references the following:

APPS
PACKAGE - FND_PROFILE
SYNONYM - GMS_ALLOWABILITY_SCHEDULES
SYNONYM - GMS_AWARDS
PACKAGE - GMS_SECURITY
SYNONYM - HR_ALL_ORGANIZATION_UNITS
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_PARTIES
SYNONYM - PA_INVOICE_FORMATS
SYNONYM - PA_SUMMARY_PROJECT_FUNDINGS
PACKAGE - PA_UTILS
SYNONYM - RA_TERMS
SYS
TABLE - DUAL
- PA_AGREEMENTS_ALL
- PA_IND_RATE_SCHEDULES
- GMS_LOOKUPS
- GMS_OPERATING_UNITS_V
- MO_GLOBAL

APPS.GMS_AWARDS_V is not referenced by any database object

[top of page]

View: GMS_AWARD_BAL_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
PROJECT_ID NUMBER (15)

AWARD_ID NUMBER (15)

TASK_ID NUMBER


RESOURCE_LIST_MEMBER_ID NUMBER (15)

BUDGET_VERSION_ID NUMBER (15)

PARENT_MEMBER_ID NUMBER (15)

START_DATE DATE


END_DATE DATE


BUDGET NUMBER


ACTUALS NUMBER


ENCUMBRANCES NUMBER


TOP_TASK_ID NUMBER

[top of page]

APPS.GMS_AWARD_BAL_V references the following:

APPS
SYNONYM - GL_PERIOD_STATUSES
SYNONYM - GMS_BALANCES
SYNONYM - GMS_BC_PACKETS
SYNONYM - GMS_BUDGET_VERSIONS
SYNONYM - PA_BUDGET_ENTRY_METHODS
SYNONYM - PA_TASKS
- PA_PROJECTS_ALL
- GMS_AWARDS
- GMS_NONE_BAL_V
- PA_PERIODS
- GMS_DTRANGE_BAL_V
APPS.GMS_AWARD_BAL_V is referenced by following:

APPS
VIEW - GMS_AWD_V
VIEW - GMS_RES_V

[top of page]

View: GMS_AWARD_PROJECTS_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
AWARD_ID NUMBER (15) Y
AWARD_NUMBER VARCHAR2 (15) Y
AWARD_SHORT_NAME VARCHAR2 (30) Y
AWARD_PROJECT_ID NUMBER (15)
AGREEMENT_ID NUMBER (15)
SEGMENT1 VARCHAR2 (25) Y
NAME VARCHAR2 (30) Y
ORG_ID NUMBER (15)

[top of page]

APPS.GMS_AWARD_PROJECTS_V references the following:

- GMS_AWARDS
- PA_PROJECTS_ALL

APPS.GMS_AWARD_PROJECTS_V is not referenced by any database object

[top of page]

View: GMS_AWARD_STATUS_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
AWARD_STATUS VARCHAR2 (80) Y

[top of page]

APPS.GMS_AWARD_STATUS_V references the following:

- GMS_LOOKUPS

APPS.GMS_AWARD_STATUS_V is not referenced by any database object

[top of page]

View: GMS_AWD_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
AWARD_ID NUMBER (15)

AWARD_NUMBER VARCHAR2 (30) Y
BUDGET_VERSION_ID NUMBER (15)

START_DATE DATE


END_DATE DATE


BUDGET NUMBER


ACTUALS NUMBER


ENCUMBRANCES NUMBER


[top of page]

APPS.GMS_AWD_V references the following:

APPS
VIEW - GMS_AWARD_BAL_V
- GMS_AWARDS

APPS.GMS_AWD_V is not referenced by any database object

[top of page]

View: GMS_BILL_AWARD_PROJECTS_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
PROJECT_ID NUMBER (15) Y
PROJECT_NAME VARCHAR2 (30) Y
PROJECT_NUMBER VARCHAR2 (25) Y
AWARD_NUMBER VARCHAR2 (15) Y
AWARD_SHORT_NAME VARCHAR2 (30) Y
ORG_ID NUMBER (15)

[top of page]

APPS.GMS_BILL_AWARD_PROJECTS_V references the following:

APPS
SYNONYM - GMS_AWARDS
PACKAGE - PA_SECURITY
- PA_PROJECTS_ALL

APPS.GMS_BILL_AWARD_PROJECTS_V is not referenced by any database object

[top of page]

View: GMS_BUDGETARY_CONTROL_AWARD_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)
PROJECT_ID NUMBER (15) Y
AWARD_ID NUMBER (15) Y
AWARD_SHORT_NAME VARCHAR2 (30) Y
AWARD_NUMBER VARCHAR2 (15) Y
FUNDS_CONTROL_LEVEL_CODE VARCHAR2 (1) Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15) Y
ENTRY_LEVEL_CODE VARCHAR2 (30) Y
CATEGORIZATION_CODE VARCHAR2 (30) Y
BUDGETARY_CONTROLS_ID NUMBER (15) Y
RESOURCE_LIST_ID NUMBER (15) Y
RESOURCE_LIST_NAME VARCHAR2 (240) Y
BUDGET_ENTRY_METHOD_CODE VARCHAR2 (30)
ORG_ID NUMBER (15)

[top of page]

APPS.GMS_BUDGETARY_CONTROL_AWARD_V references the following:

APPS
PACKAGE - FND_PROFILE
SYNONYM - GMS_BUDGETARY_CONTROLS
SYNONYM - GMS_BUDGET_VERSIONS
SYNONYM - PA_BUDGET_ENTRY_METHODS
PACKAGE - PA_CROSS_BUSINESS_GRP
- PA_RESOURCE_LISTS
- GMS_AWARDS

APPS.GMS_BUDGETARY_CONTROL_AWARD_V is not referenced by any database object

[top of page]

View: GMS_BUDGETARY_CONTROL_PROJ_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
PROJECT_ID NUMBER (15) Y
PROJECT_NUMBER VARCHAR2 (25) Y
NAME VARCHAR2 (30) Y
RESOURCE_LIST_NAME VARCHAR2 (240) Y
RESOURCE_LIST_ID NUMBER (15) Y
GROUP_RESOURCE_TYPE_ID NUMBER

ENTRY_LEVEL_CODE VARCHAR2 (30) Y
ORG_ID NUMBER (15) Y

[top of page]

APPS.GMS_BUDGETARY_CONTROL_PROJ_V references the following:

APPS
PACKAGE - FND_PROFILE
SYNONYM - GMS_BUDGET_VERSIONS
SYNONYM - PA_BUDGET_ENTRY_METHODS
PACKAGE - PA_CROSS_BUSINESS_GRP
- PA_PROJECTS_ALL
- PA_IMPLEMENTATIONS
- PA_RESOURCE_LISTS

APPS.GMS_BUDGETARY_CONTROL_PROJ_V is not referenced by any database object

[top of page]

View: GMS_BUDGETARY_CONTROL_TASK_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)
TASK_NUMBER VARCHAR2 (25) Y
TASK_NAME VARCHAR2 (20) Y
PROJECT_ID NUMBER (15) Y
TASK_ID NUMBER (15)
BUDGETARY_CONTROLS_ID NUMBER (15) Y
AWARD_ID NUMBER (15) Y
FUNDS_CONTROL_LEVEL_CODE VARCHAR2 (1) Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15) Y
RESOURCE_LIST_MEMBER_ID NUMBER (15)

[top of page]

APPS.GMS_BUDGETARY_CONTROL_TASK_V references the following:

APPS
SYNONYM - GMS_BUDGETARY_CONTROLS
SYNONYM - PA_TASKS

APPS.GMS_BUDGETARY_CONTROL_TASK_V is not referenced by any database object

[top of page]

View: GMS_BUDGET_CHANGE_REASON_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
CODE VARCHAR2 (30) Y
NAME VARCHAR2 (80) Y

[top of page]

APPS.GMS_BUDGET_CHANGE_REASON_V references the following:

- PA_LOOKUPS

APPS.GMS_BUDGET_CHANGE_REASON_V is not referenced by any database object

[top of page]

View: GMS_BUDGET_LINES_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)
RESOURCE_ASSIGNMENT_ID NUMBER (15) Y
BUDGET_VERSION_ID NUMBER (15) Y
PROJECT_ID NUMBER (15) Y
TASK_ID NUMBER (15) Y
RESOURCE_LIST_MEMBER_ID NUMBER (15) Y
RESOURCE_LIST_ID NUMBER (15) Y
RESOURCE_ID NUMBER (15) Y
RESOURCE_NAME VARCHAR2 (80)
DESCRIPTION VARCHAR2 (255)
START_DATE DATE
Y
END_DATE DATE
Y
PERIOD_NAME VARCHAR2 (30)
QUANTITY NUMBER

UNIT_OF_MEASURE VARCHAR2 (30)
UNIT_OF_MEASURE_M VARCHAR2 (80)
TRACK_AS_LABOR_FLAG VARCHAR2 (1)
RAW_COST NUMBER

BURDENED_COST NUMBER

REVENUE NUMBER

CHANGE_REASON_CODE VARCHAR2 (30)
CHANGE_REASON_M VARCHAR2 (80)
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
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield context field
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
RAW_COST_SOURCE VARCHAR2 (2)
BURDENED_COST_SOURCE VARCHAR2 (2)
QUANTITY_SOURCE VARCHAR2 (2)
REVENUE_SOURCE VARCHAR2 (2)
PM_PRODUCT_CODE VARCHAR2 (30)
PM_BUDGET_LINE_REFERENCE VARCHAR2 (25)

[top of page]

APPS.GMS_BUDGET_LINES_V references the following:

APPS
SYNONYM - GMS_BUDGET_LINES
SYNONYM - GMS_RESOURCE_ASSIGNMENTS
SYNONYM - PA_RESOURCE_LIST_MEMBERS
- PA_LOOKUPS

APPS.GMS_BUDGET_LINES_V is not referenced by any database object

[top of page]

View: GMS_BUDGET_MATRIX_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
BUDGET_VERSION_ID NUMBER (15)

TASK_ID NUMBER (15)

P1_AMT NUMBER


P2_AMT NUMBER


P3_AMT NUMBER


P4_AMT NUMBER


RESOURCE_ASSIGNMENT_ID NUMBER (15)

RESOURCE_LIST_MEMBER_ID NUMBER (15)

RESOURCE_LIST_ID NUMBER (15)

RESOURCE_ID NUMBER (15)

RESOURCE_NAME VARCHAR2 (80)

UNIT_OF_MEASURE VARCHAR2 (30)

TRACK_AS_LABOR_FLAG VARCHAR2 (1)

AMT_TYPE VARCHAR2 (30)

AMT_TYPE_DESC VARCHAR2 (80)

SEQ_NO NUMBER


DF_LONG_P1_1 VARCHAR2 (1530)

DF_LONG_P1_2 VARCHAR2 (1329)

DF_LONG_P2_1 VARCHAR2 (1530)

DF_LONG_P2_2 VARCHAR2 (1329)

DF_LONG_P3_1 VARCHAR2 (1530)

DF_LONG_P3_2 VARCHAR2 (1329)

DF_LONG_P4_1 VARCHAR2 (1530)

DF_LONG_P4_2 VARCHAR2 (1329)

ATTRIBUTE_CATEGORY VARCHAR2 (0)

ATTRIBUTE1 VARCHAR2 (0)

ATTRIBUTE2 VARCHAR2 (0)

ATTRIBUTE3 VARCHAR2 (0)

ATTRIBUTE4 VARCHAR2 (0)

ATTRIBUTE5 VARCHAR2 (0)

ATTRIBUTE6 VARCHAR2 (0)

ATTRIBUTE7 VARCHAR2 (0)

ATTRIBUTE8 VARCHAR2 (0)

ATTRIBUTE9 VARCHAR2 (0)

ATTRIBUTE10 VARCHAR2 (0)

ATTRIBUTE11 VARCHAR2 (0)

ATTRIBUTE12 VARCHAR2 (0)

ATTRIBUTE13 VARCHAR2 (0)

ATTRIBUTE14 VARCHAR2 (0)

ATTRIBUTE15 VARCHAR2 (0)

CHANGE_REASON_M VARCHAR2 (0)

DESCRIPTION VARCHAR2 (0)

LAST_UPDATE_DATE DATE


LAST_UPDATED_BY NUMBER


CREATION_DATE DATE


CREATED_BY NUMBER


LAST_UPDATE_LOGIN NUMBER


LAST_UPDATE_DATE_P1 DATE


LAST_UPDATED_BY_P1 NUMBER


CREATION_DATE_P1 DATE


CREATED_BY_P1 NUMBER


LAST_UPDATE_LOGIN_P1 NUMBER


LAST_UPDATE_DATE_P2 DATE


LAST_UPDATED_BY_P2 NUMBER


CREATION_DATE_P2 DATE


CREATED_BY_P2 NUMBER


LAST_UPDATE_LOGIN_P2 NUMBER


LAST_UPDATE_DATE_P3 DATE


LAST_UPDATED_BY_P3 NUMBER


CREATION_DATE_P3 DATE


CREATED_BY_P3 NUMBER


LAST_UPDATE_LOGIN_P3 NUMBER


LAST_UPDATE_DATE_P4 DATE


LAST_UPDATED_BY_P4 NUMBER


CREATION_DATE_P4 DATE


CREATED_BY_P4 NUMBER


LAST_UPDATE_LOGIN_P4 NUMBER


[top of page]

APPS.GMS_BUDGET_MATRIX_V references the following:

APPS
SYNONYM - FND_LOOKUP_VALUES
SYNONYM - GMS_BUDGET_LINES
PACKAGE - GMS_BUDGET_MATRIX
SYNONYM - GMS_RESOURCE_ASSIGNMENTS
SYNONYM - PA_RESOURCE_LIST_MEMBERS

APPS.GMS_BUDGET_MATRIX_V is not referenced by any database object

[top of page]

View: GMS_BUDGET_VERSIONS_BASELND_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)
BUDGET_VERSION_ID NUMBER (15) Y
PROJECT_ID NUMBER (15) Y
AWARD_ID NUMBER (15) Y
BUDGET_TYPE_CODE VARCHAR2 (30) Y
VERSION_NUMBER NUMBER (15) Y
BUDGET_STATUS_CODE VARCHAR2 (30) Y
VERSION_NAME VARCHAR2 (60)
DESCRIPTION VARCHAR2 (255)
CURRENT_FLAG VARCHAR2 (1) Y
ORIGINAL_FLAG VARCHAR2 (1) Y
CURRENT_ORIGINAL_FLAG VARCHAR2 (1) Y
RESOURCE_ACCUMULATED_FLAG VARCHAR2 (1) Y
RESOURCE_LIST_ID NUMBER (15) Y
RESOURCE_LIST_NAME VARCHAR2 (240) Y
BASELINED_BY_PERSON_ID NUMBER (15)
BASELINED_BY_PERSON_NAME VARCHAR2 (240)
BASELINED_DATE DATE

CHANGE_REASON_CODE VARCHAR2 (30)
CHANGE_REASON_M VARCHAR2 (80)
LABOR_QUANTITY NUMBER

LABOR_UNIT_OF_MEASURE VARCHAR2 (30)
LABOR_UNIT_OF_MEASURE_M VARCHAR2 (80)
RAW_COST NUMBER

BURDENED_COST NUMBER

REVENUE NUMBER

BUDGET_ENTRY_METHOD_CODE VARCHAR2 (30)
BUDGET_ENTRY_METHOD VARCHAR2 (30)
ENTRY_LEVEL_CODE VARCHAR2 (30)
CATEGORIZATION_CODE VARCHAR2 (30)
COST_QUANTITY_FLAG VARCHAR2 (1)
RAW_COST_FLAG VARCHAR2 (1)
BURDENED_COST_FLAG VARCHAR2 (1)
REV_QUANTITY_FLAG VARCHAR2 (1)
REVENUE_FLAG VARCHAR2 (1)
TIME_PHASED_TYPE_CODE VARCHAR2 (30)
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
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield context field
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
FIRST_BUDGET_PERIOD VARCHAR2 (30)
PM_PRODUCT_CODE VARCHAR2 (30)
PM_BUDGET_REFERENCE VARCHAR2 (25)

[top of page]

APPS.GMS_BUDGET_VERSIONS_BASELND_V references the following:

APPS
PACKAGE - FND_PROFILE
SYNONYM - GMS_BUDGET_VERSIONS
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
SYNONYM - PA_BUDGET_ENTRY_METHODS
PACKAGE - PA_CROSS_BUSINESS_GRP
- PA_LOOKUPS
- PA_RESOURCE_LISTS
- PER_PEOPLE_F

APPS.GMS_BUDGET_VERSIONS_BASELND_V is not referenced by any database object

[top of page]

View: GMS_BUDGET_VERSIONS_DRAFT_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)

BUDGET_VERSION_ID NUMBER (15) Y
PROJECT_ID NUMBER (15) Y
AWARD_ID NUMBER (15) Y
BUDGET_TYPE_CODE VARCHAR2 (30) Y
VERSION_NUMBER NUMBER (15) Y
BUDGET_STATUS_CODE VARCHAR2 (30) Y
BUDGET_STATUS_M VARCHAR2 (80) Y
VERSION_NAME VARCHAR2 (60)

DESCRIPTION VARCHAR2 (255)

CURRENT_FLAG VARCHAR2 (1) Y
ORIGINAL_FLAG VARCHAR2 (1) Y
CURRENT_ORIGINAL_FLAG VARCHAR2 (1) Y
RESOURCE_ACCUMULATED_FLAG VARCHAR2 (1) Y
RESOURCE_LIST_ID NUMBER (15) Y
RESOURCE_LIST_NAME VARCHAR2 (240) Y
CHANGE_REASON_CODE VARCHAR2 (30)

CHANGE_REASON_M VARCHAR2 (80)

BUDGET_ENTRY_METHOD_CODE VARCHAR2 (30)

BUDGET_ENTRY_METHOD VARCHAR2 (30)

LABOR_QUANTITY NUMBER


LABOR_UNIT_OF_MEASURE VARCHAR2 (30)

LABOR_UNIT_OF_MEASURE_M VARCHAR2 (80)

RAW_COST NUMBER


BURDENED_COST NUMBER


REVENUE NUMBER


ENTRY_LEVEL_CODE VARCHAR2 (30)

CATEGORIZATION_CODE VARCHAR2 (30)

COST_QUANTITY_FLAG VARCHAR2 (1)

RAW_COST_FLAG VARCHAR2 (1)

BURDENED_COST_FLAG VARCHAR2 (1)

REV_QUANTITY_FLAG VARCHAR2 (1)

REVENUE_FLAG VARCHAR2 (1)

TIME_PHASED_TYPE_CODE VARCHAR2 (30)

BASELINED_BY_PERSON_ID NUMBER (15)

BASELINED_DATE DATE


CUR_BASE_LABOR_QUANTITY NUMBER


CUR_BASE_LABOR_UOM VARCHAR2 (30)

CUR_BASE_LABOR_UOM_M VARCHAR2 (80)

CUR_BASE_RAW_COST NUMBER


CUR_BASE_BURDENED_COST NUMBER


CUR_BASE_REVENUE NUMBER


CUR_BASE_DATE DATE


LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER
Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER
Y
LAST_UPDATE_LOGIN NUMBER
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)

FIRST_BUDGET_PERIOD VARCHAR2 (30)

PM_PRODUCT_CODE VARCHAR2 (30)

PM_BUDGET_REFERENCE VARCHAR2 (25)

WF_STATUS_CODE VARCHAR2 (30)
UPDATE_ALLOWED VARCHAR2 (1)

CONC_REQUEST_ID NUMBER (15)

[top of page]

APPS.GMS_BUDGET_VERSIONS_DRAFT_V references the following:

APPS
PACKAGE - FND_PROFILE
SYNONYM - GMS_BUDGET_VERSIONS
PACKAGE - GMS_SECURITY
SYNONYM - PA_BUDGET_ENTRY_METHODS
SYNONYM - PA_BUDGET_TYPES
PACKAGE - PA_CROSS_BUSINESS_GRP
SYS
TABLE - DUAL
- PA_RESOURCE_LISTS
- PA_LOOKUPS

APPS.GMS_BUDGET_VERSIONS_DRAFT_V is not referenced by any database object

[top of page]

View: GMS_BUDG_CONTROL_RES_GRP_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)
PROJECT_ID NUMBER (15) Y
TASK_ID NUMBER (15)
AWARD_ID NUMBER (15) Y
BUDGETARY_CONTROLS_ID NUMBER (15) Y
FUNDS_CONTROL_LEVEL_CODE VARCHAR2 (1) Y
RESOURCE_LIST_ID NUMBER (15) Y
RESOURCE_LIST_MEMBER_ID NUMBER (15)
ALIAS VARCHAR2 (80)
RESOURCE_ID NUMBER (15) Y
RESOURCE_NAME VARCHAR2 (240)
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15) Y
PARENT_MEMBER_ID NUMBER (15)

[top of page]

APPS.GMS_BUDG_CONTROL_RES_GRP_V references the following:

APPS
PACKAGE - FND_PROFILE
SYNONYM - GMS_BUDGETARY_CONTROLS
PACKAGE - PA_CROSS_BUSINESS_GRP
SYNONYM - PA_RESOURCES
SYNONYM - PA_RESOURCE_LIST_MEMBERS
- PA_RESOURCE_LISTS

APPS.GMS_BUDG_CONTROL_RES_GRP_V is not referenced by any database object

[top of page]

View: GMS_CDL_BURDEN_DETAIL_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
PROJECT_ID NUMBER (15)
TASK_ID NUMBER (15)
SEGMENT1 VARCHAR2 (25) Y
ORGANIZATION_ID NUMBER (15) Y
PA_DATE DATE

AWARD_ID NUMBER (15) Y
AWARD_SET_ID NUMBER (15) Y
ADL_STATUS VARCHAR2 (3)
IND_COST_CODE VARCHAR2 (30) Y
EI_EXPENDITURE_TYPE VARCHAR2 (30) Y
ICC_EXPENDITURE_TYPE VARCHAR2 (30)
COST_BASE VARCHAR2 (30) Y
COMPILED_MULTIPLIER NUMBER (22) Y
IND_RATE_SCH_ID NUMBER (15) Y
IND_RATE_SCH_REVISION_ID NUMBER (15) Y
EXPENDITURE_ITEM_ID NUMBER (15) Y
ADL_LINE_NUM NUMBER (15) Y
LINE_NUM NUMBER (15) Y
EXPENDITURE_ITEM_DATE DATE
Y
RAW_COST NUMBER (22)
BURDEN_COST NUMBER

BURDEN_SUM_SOURCE_RUN_ID NUMBER (15)
BURDEN_SUM_REJECTION_CODE VARCHAR2 (30)
ORG_ID NUMBER (15)
GL_DATE DATE

SYSTEM_LINKAGE_FUNCTION VARCHAR2 (3) Y
LINE_TYPE VARCHAR2 (1) Y
CREATION_DATE DATE
Y

[top of page]

APPS.GMS_CDL_BURDEN_DETAIL_V references the following:

APPS
SYNONYM - GMS_AWARD_DISTRIBUTIONS
PACKAGE - GMS_BURDEN_COSTING
SYNONYM - PA_COMPILED_MULTIPLIERS
SYNONYM - PA_COST_BASES
SYNONYM - PA_COST_BASE_EXP_TYPES
SYNONYM - PA_IND_COMPILED_SETS
SYNONYM - PA_IND_COST_CODES
SYNONYM - PA_IND_RATE_SCHEDULES_ALL_BG
SYNONYM - PA_IND_RATE_SCH_REVISIONS
SYNONYM - PA_TRANSACTION_SOURCES
- PA_PROJECT_TYPES
- PA_PROJECTS_ALL
- PA_EXPENDITURES_ALL
- PA_EXPENDITURE_ITEMS_ALL
- PA_COST_DISTRIBUTION_LINES_ALL

APPS.GMS_CDL_BURDEN_DETAIL_V is not referenced by any database object

[top of page]

View: GMS_COMMITMENTS_OVERRIDE_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
PROJECT_ID NUMBER

TASK_ID NUMBER

TRANSACTION_SOURCE VARCHAR2 (17)
LINE_TYPE VARCHAR2 (1)
CMT_NUMBER VARCHAR2 (50)
CMT_DISTRIBUTION_ID NUMBER

CMT_HEADER_ID NUMBER

DESCRIPTION VARCHAR2 (240)
EXPENDITURE_ITEM_DATE DATE

PA_PERIOD VARCHAR2 (4000)
GL_PERIOD VARCHAR2 (4000)
CMT_LINE_NUMBER NUMBER

CMT_CREATION_DATE DATE

CMT_APPROVED_DATE DATE

CMT_REQUESTOR_NAME VARCHAR2 (240)
CMT_BUYER_NAME VARCHAR2 (240)
CMT_APPROVED_FLAG VARCHAR2 (1)
CMT_PROMISED_DATE DATE

CMT_NEED_BY_DATE DATE

ORGANIZATION_ID NUMBER

VENDOR_ID NUMBER

VENDOR_NAME VARCHAR2 (240)
EXPENDITURE_TYPE VARCHAR2 (30)
EXPENDITURE_CATEGORY VARCHAR2 (30)
REVENUE_CATEGORY VARCHAR2 (30)
SYSTEM_LINKAGE_FUNCTION VARCHAR2 (2)
UNIT_OF_MEASURE VARCHAR2 (25)
UNIT_PRICE NUMBER

CMT_IND_COMPILED_SET_ID NUMBER

ACCT_RAW_COST NUMBER

ACCT_BURDENED_COST NUMBER

BURDENABLE_RAW_COST NUMBER

TOT_CMT_QUANTITY NUMBER

QUANTITY_ORDERED NUMBER

AMOUNT_ORDERED NUMBER

ORIGINAL_QUANTITY_ORDERED NUMBER

ORIGINAL_AMOUNT_ORDERED NUMBER

QUANTITY_CANCELLED NUMBER

AMOUNT_CANCELLED NUMBER

QUANTITY_DELIVERED NUMBER

QUANTITY_INVOICED NUMBER

AMOUNT_INVOICED NUMBER

QUANTITY_OUTSTANDING_DELIVERY NUMBER

AMOUNT_OUTSTANDING_DELIVERY NUMBER

QUANTITY_OUTSTANDING_INVOICE NUMBER

AMOUNT_OUTSTANDING_INVOICE NUMBER

QUANTITY_OVERBILLED NUMBER

AMOUNT_OVERBILLED NUMBER

ORIGINAL_TXN_REFERENCE1 VARCHAR2 (0)
ORIGINAL_TXN_REFERENCE2 VARCHAR2 (0)
ORIGINAL_TXN_REFERENCE3 VARCHAR2 (0)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER

CREATION_DATE DATE

CREATED_BY NUMBER

LAST_UPDATE_LOGIN NUMBER

REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

DENOM_CURRENCY_CODE VARCHAR2 (15)
DENOM_RAW_COST NUMBER

DENOM_BURDENED_COST NUMBER

ACCT_CURRENCY_CODE VARCHAR2 (15)
ACCT_RATE_DATE DATE

ACCT_RATE_TYPE VARCHAR2 (30)
ACCT_EXCHANGE_RATE NUMBER

RECEIPT_CURRENCY_CODE VARCHAR2 (15)
RECEIPT_CURRENCY_AMOUNT NUMBER

RECEIPT_EXCHANGE_RATE NUMBER

[top of page]

APPS.GMS_COMMITMENTS_OVERRIDE_V references the following:

APPS
SYNONYM - CST_PROJMFG_CMT_VIEW
PACKAGE - FND_PROFILE
PACKAGE - GMS_COST_PLUS_EXTN
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
PACKAGE - PA_ACCUM_UTILS
PACKAGE - PA_BURDEN_CMTS
PACKAGE - PA_CMT_UTILS
PACKAGE - PA_CURRENCY
PACKAGE - PA_FUNDS_CONTROL_UTILS
PACKAGE - PA_MULTI_CURRENCY
PACKAGE - PA_PJC_CWK_UTILS
VIEW - PA_PROJ_PO_DISTRIBUTIONS
VIEW - PA_PROJ_REQ_DISTRIBUTIONS
PACKAGE - PA_TASK_UTILS
PACKAGE - PA_UTILS4
SYNONYM - PJM_PO_COMMITMENTS_V
SYNONYM - PJM_REQ_COMMITMENTS_V
- PA_PROJ_AP_INV_DISTRIBUTIONS
- AP_INVOICES_PKG
APPS.GMS_COMMITMENTS_OVERRIDE_V is referenced by following:

APPS
VIEW - GMS_COMMITMENT_TXNS_V

[top of page]

View: GMS_COMMITMENT_BURDEN_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
DOCUMENT_TYPE VARCHAR2 (3)
TRANSACTION_SOURCE VARCHAR2 (80)
CMT_NUMBER VARCHAR2 (50)
DESCRIPTION VARCHAR2 (240)
PROJECT_ID NUMBER

TASK_ID NUMBER

AWARD_ID NUMBER (15)
EXPENDITURE_TYPE VARCHAR2 (30)
EXPENDITURE_ITEM_DATE DATE

ORGANIZATION_ID NUMBER

VENDOR_NAME VARCHAR2 (240)
UNIT_OF_MEASURE VARCHAR2 (25)
UNIT_PRICE NUMBER

PA_PERIOD VARCHAR2 (20)
TOT_CMT_QUANTITY NUMBER

quantity for the burden is 0
ACCT_RAW_COST NUMBER

ACCT_BURDENED_COST NUMBER

GL_DATE DATE

[top of page]

APPS.GMS_COMMITMENT_BURDEN_V references the following:

APPS
PACKAGE - GMS_BUDGET_BALANCE
VIEW - GMS_COMMITMENT_ENCUMBERED_V
PACKAGE - PA_CMT_UTILS
SYNONYM - PA_COMPILED_MULTIPLIERS
SYNONYM - PA_COST_BASE_EXP_TYPES
SYNONYM - PA_IND_COMPILED_SETS
SYNONYM - PA_IND_COST_CODES
SYNONYM - PA_IND_RATE_SCH_REVISIONS
PACKAGE - PO_INTG_DOCUMENT_FUNDS_GRP

APPS.GMS_COMMITMENT_BURDEN_V is not referenced by any database object

[top of page]

View: GMS_COMMITMENT_ENCUMBERED_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
DOCUMENT_TYPE VARCHAR2 (3)
TRANSACTION_SOURCE VARCHAR2 (80)
CMT_NUMBER VARCHAR2 (50)
DESCRIPTION VARCHAR2 (240)
PROJECT_ID NUMBER

TASK_ID NUMBER

AWARD_ID NUMBER (15)
EXPENDITURE_TYPE VARCHAR2 (30)
EXPENDITURE_ITEM_DATE DATE

ORGANIZATION_ID NUMBER

VENDOR_NAME VARCHAR2 (240)
UNIT_OF_MEASURE VARCHAR2 (25)
UNIT_PRICE NUMBER

TOT_CMT_QUANTITY NUMBER

ACCT_RAW_COST NUMBER

ACCT_BURDENED_COST NUMBER

IND_COMPILED_SET_ID NUMBER (15)
BURDENABLE_RAW_COST NUMBER

PA_PERIOD VARCHAR2 (20)
GL_DATE DATE

[top of page]

APPS.GMS_COMMITMENT_ENCUMBERED_V references the following:

APPS
SYNONYM - AP_INVOICES_ALL
SYNONYM - AP_INVOICE_DISTRIBUTIONS_ALL
SYNONYM - AP_SELF_ASSESSED_TAX_DIST_ALL
SYNONYM - GL_LEDGERS
SYNONYM - GMS_AWARD_DISTRIBUTIONS
PACKAGE - GMS_BUDGET_BALANCE
SYNONYM - GMS_ENCUMBRANCES_ALL
SYNONYM - GMS_ENCUMBRANCE_ITEMS_ALL
PACKAGE - PA_CMT_UTILS
SYNONYM - PA_TRANSACTION_SOURCES
SYNONYM - PO_DISTRIBUTIONS_ALL
SYNONYM - PO_HEADERS_ALL
PACKAGE - PO_INTG_DOCUMENT_FUNDS_GRP
SYNONYM - PO_LINES_ALL
SYNONYM - PO_LINE_LOCATIONS_ALL
SYNONYM - PO_REQUISITION_HEADERS_ALL
SYNONYM - PO_REQUISITION_LINES_ALL
SYNONYM - PO_REQ_DISTRIBUTIONS_ALL
VIEW - PO_VENDORS
- PA_PERIODS
- PO_LINE_TYPES
APPS.GMS_COMMITMENT_ENCUMBERED_V is referenced by following:

APPS
VIEW - GMS_COMMITMENT_BURDEN_V

[top of page]

View: GMS_COMMITMENT_TXNS_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
PROJECT_ID NUMBER

Identifier of the project.
TASK_ID NUMBER

Identifier of the lowest task
TRANSACTION_SOURCE VARCHAR2 (17)
Source of commitment, i.e., ORACLE_PURCHASING, ORACLE_PAYABLES, OUTSIDE_SYSTEM.
LINE_TYPE VARCHAR2 (1)
Commitment line type: (R)equisition, (P)urchase Order, (I) Supplier Invoice.
CMT_NUMBER VARCHAR2 (240)
The commitment document number: requisition, purchase order or invoice number.
CMT_DISTRIBUTION_ID NUMBER

The identifier of the requisition or purchase order distribution.
CMT_HEADER_ID NUMBER

Identifier for the requisition, purchase order or invoice header.
DESCRIPTION VARCHAR2 (240)
The description of either the requisition or purchase order line or the invoice distribution.
EXPENDITURE_ITEM_DATE DATE

The expenditure item date on which you expect to incur the commitment costs.
PA_PERIOD VARCHAR2 (4000)
PA period corresponding to the commitment.
GL_PERIOD VARCHAR2 (4000)
GL period corresponding to the commitment PA period.
CMT_LINE_NUMBER NUMBER

The requisition, purchase order or invoice line number in which the distribution is included.
CMT_CREATION_DATE DATE

Date on which the requisition or purchase order was created or the invoice was incurred.
CMT_APPROVED_DATE DATE

Date on which the requisition, purchase order or invoice was approved
CMT_REQUESTOR_NAME VARCHAR2 (240)
The full name of requestor.
CMT_BUYER_NAME VARCHAR2 (240)
The full name of buyer.
CMT_APPROVED_FLAG VARCHAR2 (1)
Indicator if the commiment is approved: "Y" for approved, "N" for not approved.
CMT_PROMISED_DATE DATE

Promised delivery date for commitment.
CMT_NEED_BY_DATE DATE

Date that commitment is needed by.
ORGANIZATION_ID NUMBER

Identifier of the expenditure organization incurring the commitment.
VENDOR_ID NUMBER

Identifier of the Supplier.
VENDOR_NAME VARCHAR2 (240)
Supplier Name.
EXPENDITURE_TYPE VARCHAR2 (30)
Commitment expenditure type.
EXPENDITURE_CATEGORY VARCHAR2 (30)
The expenditure category of the commitment .
REVENUE_CATEGORY VARCHAR2 (30)
The revenue category of the commitment.
SYSTEM_LINKAGE_FUNCTION VARCHAR2 (3)
Commitment system linkage function: VENDOR_INVOICES.
UNIT_OF_MEASURE VARCHAR2 (25)
Not currently used in Oracle Projects
UNIT_PRICE NUMBER

Cost per unit of the project-related commitment distribution.
CMT_IND_COMPILED_SET_ID NUMBER

Identifier for the indirect compiled set.
ACCT_RAW_COST NUMBER

The functional currency raw cost amount of the project-related commitment distribution.
ACCT_BURDENED_COST NUMBER

The functional currency burdened cost amount of the project-related commitment distribution.
TOT_CMT_QUANTITY NUMBER

Outstanding quantity of the project-related commitment distribution.
QUANTITY_ORDERED NUMBER

Distribution quantity ordered of the purchase order commitment.
AMOUNT_ORDERED NUMBER

Distribution amount ordered of the purchase order commitment.
ORIGINAL_QUANTITY_ORDERED NUMBER

Distribution original quantity ordered of the purchase order commitment.
ORIGINAL_AMOUNT_ORDERED NUMBER

Distribution original amount ordered of the purchase order commitment.
QUANTITY_CANCELLED NUMBER

Distribution quantity cancelled of the purchase order commitment.
AMOUNT_CANCELLED NUMBER

Distribution amount cancelled of the purchase order commitment.
QUANTITY_DELIVERED NUMBER

Distribution quantity delivered of the purchase order commitment.
QUANTITY_INVOICED NUMBER

Distribution quantity invoiced of the purchase order commitment.
AMOUNT_INVOICED NUMBER

Distribution amount invoiced of the purchase order commitment.
QUANTITY_OUTSTANDING_DELIVERY NUMBER

Distribution quantity outstanding delivery of the purchase order commitment.
AMOUNT_OUTSTANDING_DELIVERY NUMBER

Distribution amount outstanding delivery of the purchase order commitment.
QUANTITY_OUTSTANDING_INVOICE NUMBER

Distribution quantity outstanding invoice of the purchase order commitment.
AMOUNT_OUTSTANDING_INVOICE NUMBER

Distribution amount outstanding invoice of the purchase order commitment.
QUANTITY_OVERBILLED NUMBER

Distribution quantity overbilled of the purchase order commitment.
AMOUNT_OVERBILLED NUMBER

Distribution amount overbilled of the purchase order commitment.
ORIGINAL_TXN_REFERENCE1 VARCHAR2 (150)
Original transaction reference-1.
ORIGINAL_TXN_REFERENCE2 VARCHAR2 (150)
Original transaction reference-2.
ORIGINAL_TXN_REFERENCE3 VARCHAR2 (0)
Original transaction reference-3.
LAST_UPDATE_DATE DATE

Standard Who Column
LAST_UPDATED_BY NUMBER

Standard Who Column
CREATION_DATE DATE

Standard Who Column
CREATED_BY NUMBER

Standard Who Column
LAST_UPDATE_LOGIN NUMBER

Standard Who Column
REQUEST_ID NUMBER

Standard Who Column
PROGRAM_APPLICATION_ID NUMBER

Standard Who Column
PROGRAM_ID NUMBER

Standard Who Column
PROGRAM_UPDATE_DATE DATE

Standard Who Column
DENOM_CURRENCY_CODE VARCHAR2 (15)
The transaction currency code.
DENOM_RAW_COST NUMBER

The transaction currency raw cost amount of the project-related commitment distribution.
DENOM_BURDENED_COST NUMBER

The transaction currency burdened cost amount of the project-related commitment distribution.
ACCT_CURRENCY_CODE VARCHAR2 (15)
The functional currency code.
ACCT_RATE_DATE DATE

The functional currency rate date.
ACCT_RATE_TYPE VARCHAR2 (30)
The functional currency rate type (such as Spot or Corporate).
ACCT_EXCHANGE_RATE NUMBER

The functional currency exchange rate.
RECEIPT_CURRENCY_CODE VARCHAR2 (15)
For expense reports, the receipt currency code (the currency in which the expenses originally occurred).
RECEIPT_CURRENCY_AMOUNT NUMBER

For expense reports, the receipt currency amount. For all the other rows, this value is null.
RECEIPT_EXCHANGE_RATE NUMBER

For expense reports, the exchange rate to convert from the receipt currency to the transaction currency.

[top of page]

APPS.GMS_COMMITMENT_TXNS_V references the following:

APPS
PACKAGE - FND_PROFILE
VIEW - GMS_COMMITMENTS_OVERRIDE_V
PACKAGE - GMS_COST_PLUS_EXTN
VIEW - GMS_ENC_PSI_V
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
PACKAGE - PA_ACCUM_UTILS
PACKAGE - PA_BURDEN_CMTS
PACKAGE - PA_CMT_UTILS
SYNONYM - PA_COMPILED_MULTIPLIERS
SYNONYM - PA_COST_BASE_EXP_TYPES
PACKAGE - PA_CURRENCY
SYNONYM - PA_EXPENDITURE_TYPES
PACKAGE - PA_FUNDS_CONTROL_UTILS
SYNONYM - PA_IND_COMPILED_SETS
SYNONYM - PA_IND_COST_CODES
SYNONYM - PA_IND_RATE_SCHEDULES_ALL_BG
SYNONYM - PA_IND_RATE_SCH_REVISIONS
PACKAGE - PA_MULTI_CURRENCY
PACKAGE - PA_PJC_CWK_UTILS
PACKAGE - PA_TASK_UTILS
PACKAGE - PA_UTILS4
- AP_INVOICES_PKG

APPS.GMS_COMMITMENT_TXNS_V is not referenced by any database object

[top of page]

View: GMS_CONTACTS_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
AWARD_ID NUMBER (15) Y
CONTACT_ID NUMBER (15) Y
TITLE_MEANING VARCHAR2 (80)
FIRST_NAME VARCHAR2 (40)
LAST_NAME VARCHAR2 (50)
STATUS VARCHAR2 (1)
JOB_TITLE VARCHAR2 (100)
MAIL_STOP VARCHAR2 (2000)
ORIG_SYSTEM_REFERENCE VARCHAR2 (240)
ADDRESS_ID NUMBER (15)
CUSTOMER_ID NUMBER (15)
USAGE_CODE VARCHAR2 (30)
PRIMARY_FLAG 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
ROW_ID ROWID (10)
ORG_ID NUMBER (15)

[top of page]

APPS.GMS_CONTACTS_V references the following:

APPS
VIEW - AR_LOOKUPS
SYNONYM - GMS_AWARDS_CONTACTS
SYNONYM - HZ_CONTACT_POINTS
SYNONYM - HZ_CUST_ACCOUNT_ROLES
SYNONYM - HZ_CUST_ACCT_SITES_ALL
SYNONYM - HZ_ORG_CONTACTS
SYNONYM - HZ_PARTIES
SYNONYM - HZ_RELATIONSHIPS
- GMS_AWARDS

APPS.GMS_CONTACTS_V is not referenced by any database object

[top of page]

View: GMS_DEFAULT_REPORTS_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
DEFAULT_REPORT_ID NUMBER (15) Y
AWARD_ID NUMBER (15) Y
REPORT_TEMPLATE_ID NUMBER (15) Y
REPORT_NAME VARCHAR2 (60) Y
TYPE_DIS VARCHAR2 (80) Y
FREQUENCY_DIS VARCHAR2 (80) Y
FREQUENCY VARCHAR2 (30) Y
DUE_WITHIN_DAYS NUMBER (15) Y
SITE_USE_ID NUMBER (15)
COPY_NUMBER 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
ROW_ID ROWID (10)

[top of page]

APPS.GMS_DEFAULT_REPORTS_V references the following:

APPS
SYNONYM - GMS_DEFAULT_REPORTS
SYNONYM - GMS_REPORT_TEMPLATES
SYNONYM - HZ_CUST_SITE_USES
- GMS_LOOKUPS

APPS.GMS_DEFAULT_REPORTS_V is not referenced by any database object

[top of page]

View: GMS_DRAFT_INVOICES_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)
AWARD_ID NUMBER (15) Y
AWARD_NUMBER VARCHAR2 (15) Y
AWARD_SHORT_NAME VARCHAR2 (30) Y
PROJECT_ID NUMBER (15) Y
PROJECT_NUMBER VARCHAR2 (25) Y
PROJECT_NAME VARCHAR2 (30) Y
DISTRIBUTION_RULE VARCHAR2 (30)
DISTRIBUTION_RULE_M VARCHAR2 (80) Y
PROJECT_TYPE VARCHAR2 (20) Y
PROJECT_STATUS_M VARCHAR2 (80) Y
PROJECT_STATUS_CODE VARCHAR2 (30) Y
PROJECT_ORGANIZATION_ID NUMBER (15) Y
PROJECT_ORGANIZATION_NAME VARCHAR2 (240) Y
CUSTOMER_ID NUMBER (15) Y
CUSTOMER_NAME VARCHAR2 (50)
CUSTOMER_NUMBER VARCHAR2 (30) Y
AGREEMENT_ID NUMBER (15) Y
AGREEMENT_NUM VARCHAR2 (50) Y
AGREEMENT_TYPE VARCHAR2 (30)
TERM_ID NUMBER (15) Y
TERM_NAME VARCHAR2 (15) Y
DRAFT_INVOICE_NUM NUMBER (15) Y
TRANSFER_STATUS_CODE VARCHAR2 (1) Y
INVOICE_STATUS_CODE VARCHAR2 (30) Y
INVOICE_STATUS_M VARCHAR2 (80) Y
CHK_STATUS VARCHAR2 (11)
BILL_THROUGH_DATE DATE

APPROVED_DATE DATE

APPROVED_BY_PERSON_ID NUMBER (9)
APPROVED_BY_PERSON_NAME VARCHAR2 (240)
APPROVED_BY_PERSON_NUMBER VARCHAR2 (30)
RELEASED_DATE DATE

RELEASED_BY_PERSON_ID NUMBER (9)
RELEASED_BY_PERSON_NAME VARCHAR2 (240)
RELEASED_BY_PERSON_NUMBER VARCHAR2 (30)
INVOICE_DATE DATE

RA_INVOICE_NUMBER VARCHAR2 (20)
PA_DATE DATE

GL_DATE DATE

CREATION_DATE DATE
Y
INVOICE_COMMENT VARCHAR2 (240)
DRAFT_INVOICE_NUM_CREDITED NUMBER (15)
CANCELED_FLAG VARCHAR2 (1)
CANCEL_CREDIT_MEMO_FLAG VARCHAR2 (1)
WRITE_OFF_FLAG VARCHAR2 (1)
CONVERTED_FLAG VARCHAR2 (1)
EXTRACTED_DATE DATE

RETENTION_PERCENTAGE NUMBER (15)
RA_INVOICE_CURRENCY_CODE VARCHAR2 (15)
INV_CURRENCY_CODE VARCHAR2 (15)
INV_RATE_TYPE VARCHAR2 (30)
INV_RATE_DATE DATE

INV_EXCHANGE_RATE NUMBER

INV_USER_RATE_TYPE VARCHAR2 (30)
PROJECT_CURRENCY_CODE VARCHAR2 (15) Y
INVOICE_CLASS VARCHAR2 (80) 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)
GENERATION_ERROR_FLAG VARCHAR2 (1) Y
TRANSFERRED_DATE DATE

TRANSFER_REJECTION_REASON VARCHAR2 (250)
EXCEPTION_FLAG VARCHAR2 (1)
UNEARNED_REVENUE_CR NUMBER

UNBILLED_RECEIVABLE_DR NUMBER

SYSTEM_REFERENCE NUMBER (15)
CUSTOMER_BILL_SPLIT NUMBER (7)
INVOICE_SET_ID NUMBER (15)
INVOICE_AMOUNT NUMBER

AMOUNT NUMBER

ORIGINAL_BALANCE NUMBER

BALANCE_DUE NUMBER

AMOUNT_APPLIED VARCHAR2 (0)
AMOUNT_CREDITED VARCHAR2 (0)
WRITE_OFF VARCHAR2 (0)
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

BILL_TO_ADDRESS_ID NUMBER

SHIP_TO_ADDRESS_ID NUMBER

UPDATE_ALLOWED VARCHAR2 (4000)
VIEW_LABOR_COSTS_ALLOWED VARCHAR2 (4000)
RECEIVABLE_CODE_COMBINATION_ID NUMBER

ROUNDING_CODE_COMBINATION_ID NUMBER

UNBILLED_CODE_COMBINATION_ID NUMBER

UNEARNED_CODE_COMBINATION_ID NUMBER

WOFF_CODE_COMBINATION_ID NUMBER

RECV_INV_AMT NUMBER

ROUND_AMT NUMBER

LANGUAGE VARCHAR2 (30)
NLS_LANGUAGE VARCHAR2 (30)
ACCTD_CURR_CODE VARCHAR2 (15)
ACCTD_RATE_TYPE VARCHAR2 (30)
ACCTD_RATE_DATE DATE

ACCTD_EXCHG_RATE NUMBER

TAX_AMOUNT NUMBER

INVOICE_CATEGORY VARCHAR2 (23)
INVOICE_BATCH_SOURCE_ID NUMBER (15)
CC_IC_AR_BATCH_SOURCE_ID NUMBER (20)
CC_PROJECT_ID NUMBER

IB_AP_TRANSFER_STATUS_CODE VARCHAR2 (1)
IB_AP_TRANSFER_ERROR_CODE VARCHAR2 (80)
UPDATE_ALLOW VARCHAR2 (1)
INVPROC_CURRENCY_CODE VARCHAR2 (15)
INVPROC_BILL_AMOUNT NUMBER

PROJFUNC_CURRENCY_CODE VARCHAR2 (15)
PROJFUNC_BILL_AMOUNT NUMBER

PROJ_BILL_AMOUNT NUMBER

FUNDING_CURRENCY_CODE VARCHAR2 (15)
FUNDING_BILL_AMOUNT NUMBER

PROJFUNC_INVTRANS_RATE_TYPE VARCHAR2 (30)
PROJFUNC_INVTRANS_RATE_TY_NAME VARCHAR2 (4000)
Exchange User rate type to use for conversion from project punctional currency to invoice transaction currency
PROJFUNC_INVTRANS_RATE_DATE DATE

PROJFUNC_INVTRANS_EX_RATE NUMBER

RETENTION_INVOICE_FLAG VARCHAR2 (1)
RETN_CODE_COMBINATION_ID NUMBER

Retention account code combination Id. This is generated based on the auto accounting rules
CREDIT_MEMO_REASON_CODE VARCHAR2 (30)
Credit Memo Reason Code is used while releasing invoices of Credit memo invoice class
BILL_TO_CUSTOMER_ID NUMBER (15)
Customer Id of the Bill to Customer i.e LOC customer
SHIP_TO_CUSTOMER_ID NUMBER (15)
Customer Id of the ship to customer i.e Funding Source
BILL_TO_CUSTOMER_NUMBER VARCHAR2 (30)
Customer Number of the Bill to Customer i.e LOC Customer Number
BILL_TO_CUSTOMER_NAME VARCHAR2 (50)
Customer Name of the Bill to Customer i.e LOC Customer Name
SHIP_TO_CUSTOMER_NUMBER VARCHAR2 (30)
Customer Number of the Ship to Customer i.e Funding Souce Customer Number
SHIP_TO_CUSTOMER_NAME VARCHAR2 (50)
Customer Name of the Ship to Customer i.e Funding Souce Customer Name
UNEARNED_REVENUE_CR_MRC VARCHAR2 (0)
Data associated with Multi Reporting Currecncy Schema Elimination
UNBILLED_RECEIVABLE_DR_MRC VARCHAR2 (0)
Data associated with Multi Reporting Currecncy Schema Elimination
PROJFUNC_CURRENCY_CODE_MRC VARCHAR2 (0)
Data associated with Multi Reporting Currecncy Schema Elimination
PROJFUNC_BILL_AMOUNT_MRC VARCHAR2 (0)
Data associated with Multi Reporting Currecncy Schema Elimination
CONCESSION_FLAG VARCHAR2 (1)
Indicates whether invoice is of type: Concession
RECORD_VERSION_NUMBER NUMBER

LAST_CREDIT_REQUEST_ID NUMBER

ENABLE_TOP_TASK_INV_MTH_FLAG VARCHAR2 (1)
REVENUE_ACCRUAL_METHOD VARCHAR2 (30)
INVOICE_METHOD VARCHAR2 (30)
ORG_ID NUMBER (15)
REVENUE_ACCRUAL_METHOD_DISP VARCHAR2 (80) Y
INVOICE_METHOD_DISP VARCHAR2 (80) Y
BILL_TO_PARTY_ID NUMBER (15)
SHIP_TO_PARTY_ID NUMBER (15)
BILL_TO_SITE_USE_ID NUMBER (15)
SHIP_TO_SITE_USE_ID NUMBER (15)
CUSTOMER_ORDER_NUMBER VARCHAR2 (240)
LINE_OF_ACCOUNT VARCHAR2 (240)
PAYMENT_SET_ID NUMBER (15)
BILL_ANOTHER_PROJECT_FLAG VARCHAR2 (1)
CC_PRVDR_FLAG VARCHAR2 (1)
PROJECT_ROLE_TYPE VARCHAR2 (20) Y
PERSON_ID NUMBER (15) Y

[top of page]

APPS.GMS_DRAFT_INVOICES_V references the following:

APPS
SYNONYM - FND_LANGUAGES
SYNONYM - GMS_AWARDS
PACKAGE - GMS_SECURITY
SYNONYM - HR_ALL_ORGANIZATION_UNITS
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_CUST_SITE_USES
SYNONYM - HZ_PARTIES
SYNONYM - PA_DISTRIBUTION_RULES
SYNONYM - PA_DRAFT_INV_ITEMS_BAS
PACKAGE - PA_MULTI_CURRENCY
PACKAGE - PA_OUTPUT_TAX
SYNONYM - PA_PROJECT_CUSTOMERS
SYNONYM - PA_PROJECT_PARTIES
SYNONYM - PA_PROJECT_ROLE_TYPES_B
SYNONYM - PA_PROJECT_STATUSES
SYNONYM - PA_ROLE_CONTROLS
PACKAGE - PA_SECURITY
SYNONYM - PER_ALL_PEOPLE_F
SYNONYM - RA_TERMS
SYS
TABLE - DUAL
- PA_PROJECT_TYPES
- PA_PROJECTS_ALL
- PA_AGREEMENTS_ALL
- PA_DRAFT_INVOICES_ALL
- PA_LOOKUPS
- PA_IMPLEMENTATIONS_ALL
- PA_CONVERSION_TYPES_V
- PA_DRAFT_INVOICES
- GL_SETS_OF_BOOKS

APPS.GMS_DRAFT_INVOICES_V is not referenced by any database object

[top of page]

View: GMS_DRAFT_INV_LINE_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)
EXPENDITURE_ITEM_ID NUMBER (15)
LINE_NUM NUMBER (15)
PROJECT_ID NUMBER (15)
DRAFT_INVOICE_NUM NUMBER (15)
DRAFT_INVOICE_ITEM_LINE_NUM NUMBER (15)
RAW_COST NUMBER

PROJECT_CURRENCY_CODE VARCHAR2 (15)
PROJECT_RATE_DATE DATE

PROJECT_RATE_TYPE VARCHAR2 (30)
USER_PROJECT_RATE_TYPE VARCHAR2 (30)
PROJECT_EXCHANGE_RATE NUMBER

RECEIPT_CURRENCY_AMOUNT NUMBER

RECEIPT_CURRENCY_CODE VARCHAR2 (15)
RECEIPT_EXCHANGE_RATE NUMBER

DENOM_RAW_COST NUMBER

DENOM_BURDENED_COST NUMBER

DENOM_CURRENCY_CODE VARCHAR2 (15)
ACCT_RAW_COST NUMBER

ACCT_BURDENED_COST NUMBER

ACCT_CURRENCY_CODE VARCHAR2 (15)
ACCT_RATE_DATE DATE

ACCT_RATE_TYPE VARCHAR2 (30)
USER_ACCT_RATE_TYPE VARCHAR2 (30)
ACCT_EXCHANGE_RATE NUMBER

ACCT_EXCHANGE_ROUNDING_LIMIT NUMBER

BILL_AMOUNT NUMBER (22)
LINE_NUM_REVERSED NUMBER

REVERSED_FLAG VARCHAR2 (0)
EXPENDITURE_ID NUMBER (15)
TASK_ID NUMBER (15)
TASK_NUMBER VARCHAR2 (25)
TASK_NAME VARCHAR2 (20)
EXPENDITURE_ITEM_DATE DATE

EXPENDITURE_TYPE VARCHAR2 (30)
INCURRED_BY_PERSON_ID NUMBER (15)
EMPLOYEE_NAME VARCHAR2 (240)
EMPLOYEE_NUMBER VARCHAR2 (30)
JOB_ID NUMBER (15)
JOB_NAME VARCHAR2 (700)
EXPENDITURE_ORGANIZATION_ID NUMBER

EXPENDITURE_ORGANIZATION_NAME VARCHAR2 (240)
VENDOR_ID NUMBER

VENDOR_NAME VARCHAR2 (240)
VENDOR_NUMBER VARCHAR2 (30)
EMPLOYEE_VENDOR_NAME VARCHAR2 (240)
EMPLOYEE_VENDOR_NUMBER VARCHAR2 (30)
NON_LABOR_RESOURCE VARCHAR2 (20)
NLR_ORGANIZATION_ID NUMBER

NLR_ORGANIZATION_NAME VARCHAR2 (240)
SYSTEM_LINKAGE_FUNCTION VARCHAR2 (3)
SYSTEM_LINKAGE_M VARCHAR2 (80)
EXPENDITURE_COMMENT VARCHAR2 (240)
TRANSACTION_SOURCE VARCHAR2 (30)
ORIG_TRANSACTION_REFERENCE VARCHAR2 (50)
EXPENDITURE_GROUP VARCHAR2 (240)
EXPENDITURE_STATUS_CODE VARCHAR2 (30)
QUANTITY NUMBER

BURDEN_COST NUMBER

UNIT_OF_MEASURE VARCHAR2 (30)
UNIT_OF_MEASURE_M VARCHAR2 (80)
COST_DISTRIBUTED_FLAG VARCHAR2 (1)
RAW_COST_RATE NUMBER

BILL_RATE NUMBER

BILL_JOB_BILLING_TITLE VARCHAR2 (80)
BILL_EMPLOYEE_BILLING_TITLE VARCHAR2 (80)
ADJUSTED_EXPENDITURE_ITEM_ID NUMBER

NET_ZERO_ADJUSTMENT_FLAG VARCHAR2 (1)
TRANSFERRED_FROM_EXP_ITEM_ID NUMBER

CONVERTED_FLAG VARCHAR2 (1)
SOURCE_EXPENDITURE_ITEM_ID NUMBER

EVENT_PROJECT_ID NUMBER (15)
EVENT_TASK_ID NUMBER (15)
EVENT_NUM NUMBER (15)
BILLABLE_FLAG VARCHAR2 (1)
BILL_HOLD_FLAG VARCHAR2 (1)
REVENUE_DISTRIBUTED_FLAG VARCHAR2 (1)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
USER_TRANSACTION_SOURCE VARCHAR2 (80)
ALLOW_ADJUSTMENTS_FLAG VARCHAR2 (1)
COSTED_FLAG VARCHAR2 (1)
COST_BURDENED_FLAG VARCHAR2 (1)
GL_ACCOUNTED_FLAG VARCHAR2 (1)
BURDEN_SUM_DEST_RUN_ID NUMBER

BURDEN_SUM_REJECTION_CODE VARCHAR2 (30)
BURDEN_SUM_REJECTION_M VARCHAR2 (80)
PROJECT_STATUS_CODE VARCHAR2 (30)
SYSTEM_REFERENCE2 VARCHAR2 (30)
MODE_IND CHAR (7)
ACTUAL_PROJECT_NUMBER VARCHAR2 (25)
ACTUAL_PROJECT_NAME VARCHAR2 (30)
ACTUAL_PROJECT_ID NUMBER (15)
CREATED_BY NUMBER (15)
CREATION_DATE DATE

BILL_TRANS_CURRENCY_CODE VARCHAR2 (15)
INVPROC_CURRENCY_CODE VARCHAR2 (15)
INVPROC_RATE_TYPE VARCHAR2 (30)
INVPROC_RATE_DATE DATE

INVPROC_EXCHANGE_RATE NUMBER

INVPROC_BILL_AMOUNT NUMBER (22)
PROJFUNC_CURRENCY_CODE VARCHAR2 (15)
PROJFUNC_RATE_TYPE VARCHAR2 (30)
PROJFUNC_RATE_DATE DATE

PROJFUNC_EXCHANGE_RATE NUMBER

PROJFUNC_BILL_AMOUNT NUMBER

PROJ_RATE_TYPE VARCHAR2 (30)
PROJ_RATE_DATE DATE

PROJ_EXCHANGE_RATE NUMBER

PROJ_BILL_AMOUNT NUMBER (22)
FUNDING_CURRENCY_CODE VARCHAR2 (15)
FUNDING_RATE_TYPE VARCHAR2 (30)
FUNDING_RATE_DATE DATE

FUNDING_EXCHANGE_RATE NUMBER

FUNDING_BILL_AMOUNT NUMBER (22)
PROJECT_RAW_COST NUMBER

PROJFUNC_COST_RATE_DATE DATE

PROJFUNC_COST_RATE_TYPE VARCHAR2 (30)
PROJFUNC_COST_EXCHANGE_RATE NUMBER

IC_BILLING_PROJ_CURR_CODE CHAR (0)
IC_BILLING_PROJFUNC_CURR_CODE CHAR (0)
DENOM_TP_CURRENCY_CODE VARCHAR2 (15)
ACCT_TP_RATE_TYPE VARCHAR2 (30)
USER_ACCT_TP_RATE_TYPE VARCHAR2 (30)
ACCT_TP_RATE_DATE DATE

ACCT_TP_EXCHANGE_RATE NUMBER

USER_PROJFUNC_COST_RATE_TYPE VARCHAR2 (30)
PRVDR_ORG_ID NUMBER (15)
RECVR_ORG_ID NUMBER

CC_CROSS_CHARGE_CODE VARCHAR2 (1)
CC_CROSS_CHARGE_TYPE VARCHAR2 (2)
CC_BL_DISTRIBUTED_CODE VARCHAR2 (1)
CC_IC_PROCESSED_CODE VARCHAR2 (1)
CC_REJECTION_CODE VARCHAR2 (30)
EXPENDITURE_ORG_ID NUMBER (15)
WORK_TYPE_ID NUMBER (15)
WORK_TYPE_NAME VARCHAR2 (4000)
TP_AMT_TYPE_CODE VARCHAR2 (30)
TRANSACTION_TYPE VARCHAR2 (80)
RATE_DISC_REASON_CODE CHAR (0)
Bill rate discount reason code
DISCOUNT_PERCENTAGE NUMBER

Discount percentage
PROJFUNC_CURRENCY_CODE_MRC VARCHAR2 (0)
Data associated with Multi Reporting Currency Schema Elimination
PROJFUNC_RATE_TYPE_MRC VARCHAR2 (0)
Data associated with Multi Reporting Currency Schema Elimination
PROJFUNC_RATE_DATE_MRC DATE

Data associated with Multi Reporting Currency Schema Elimination
PROJFUNC_EXCHANGE_RATE_MRC NUMBER

Data associated with Multi Reporting Currency Schema Elimination
PROJFUNC_BILL_AMOUNT_MRC NUMBER

Data associated with Multi Reporting Currency Schema Elimination
IC_PFC_CURRENCY_CODE_MRC VARCHAR2 (0)
Data associated with Multi Reporting Currency Schema Elimination
ACCT_TP_RATE_TYPE_MRC VARCHAR2 (0)
Data associated with Multi Reporting Currency Schema Elimination
ACCT_TP_RATE_DATE_MRC DATE

Data associated with Multi Reporting Currency Schema Elimination
ACCT_TP_EXCHANGE_RATE_MRC NUMBER

Data associated with Multi Reporting Currency Schema Elimination
RAW_COST_MRC NUMBER

Data associated with Multi Reporting Currency Schema Elimination
ACCT_RAW_COST_MRC NUMBER

Data associated with Multi Reporting Currency Schema Elimination
ACCT_BURDENED_COST_MRC NUMBER

Data associated with Multi Reporting Currency Schema Elimination
ACCT_CURRENCY_CODE_MRC VARCHAR2 (0)
Data associated with Multi Reporting Currency Schema Elimination
ACCT_RATE_DATE_MRC DATE

Data associated with Multi Reporting Currency Schema Elimination
ACCT_EXCHANGE_RATE_MRC NUMBER

Data associated with Multi Reporting Currency Schema Elimination
RETAINED_AMOUNT NUMBER

Data associated with Multi Reporting Currency Schema Elimination
ACCT_RATE_TYPE_MRC VARCHAR2 (0)
Data associated with Multi Reporting Currency Schema Elimination
PROJECT_BURDEN_COST NUMBER

Burden Cost in Project currency
ORG_ID NUMBER (15)
DOCUMENT_HEADER_ID NUMBER (15)
DOCUMENT_LINE_NUMBER NUMBER (15)
DOCUMENT_DISTRIBUTION_ID NUMBER (15)
DOCUMENT_TYPE VARCHAR2 (30)
DOCUMENT_DISTRIBUTION_TYPE VARCHAR2 (30)
DOCUMENT_PAYMENT_ID NUMBER (15)
ALLOW_BURDEN_FLAG VARCHAR2 (1)
PAYROLL_ACCRUAL_FLAG VARCHAR2 (0)
Flag to indicate if the labor costs are accrued to a project.
PAY_PERIOD_START_DATE VARCHAR2 (0)
Start date of the pay period
PAY_PERIOD_END_DATE VARCHAR2 (0)
End date of the pay period
COSTING_METHOD_M VARCHAR2 (0)
Meaning of the lookup code for the costing method.
COSTED_PAYROLL_SET_ID VARCHAR2 (0)
Unique identifier generated in Oracle Projects when you run the Interface.
PAYROLL_NAME VARCHAR2 (0)
Name of the payroll
RATE_SOURCE_M VARCHAR2 (0)
Meaning of the lookup code for the rate source.
CBS_ELEMENT_ID NUMBER (15)
The unique identifier of the cost breakdown structure element
COST_CODE VARCHAR2 (250)
This is the unique cost code generated for the cost attribute
COST_CODE_NAME VARCHAR2 (240)
This respresents the cost code name

[top of page]

APPS.GMS_DRAFT_INV_LINE_DETAILS_V references the following:

APPS
SYNONYM - FND_LOOKUP_VALUES
SYNONYM - GL_DAILY_CONVERSION_TYPES
SYNONYM - GMS_AWARD_DISTRIBUTIONS
SYNONYM - GMS_BURDEN_COMPONENTS
SYNONYM - GMS_EVENT_INTERSECT
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
SYNONYM - PA_DRAFT_INVOICE_ITEMS
SYNONYM - PA_EXPENDITURE_COMMENTS
SYNONYM - PA_EXPENDITURE_TYPES
SYNONYM - PA_RBS_ELEMENTS
PACKAGE - PA_SECURITY
SYNONYM - PA_SYSTEM_LINKAGES
SYNONYM - PA_TASKS
SYNONYM - PA_TRANSACTION_SOURCES
PACKAGE - PA_UTILS4
SYNONYM - PER_JOBS
VIEW - PO_VENDORS
- HR_ORGANIZATION_UNITS
- PA_LOOKUPS
- PA_CONVERSION_TYPES_V
- PA_DRAFT_INVOICES
- PA_EXPENDITURE_ITEMS_ALL
- PA_PROJECTS_ALL
- PA_EXPENDITURES_ALL
- PER_PEOPLE_F
- PA_COST_DISTRIBUTION_LINES_ALL

APPS.GMS_DRAFT_INV_LINE_DETAILS_V is not referenced by any database object

[top of page]

View: GMS_DRAFT_REVENUES_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)
AWARD_ID NUMBER (15) Y
AWARD_NUMBER VARCHAR2 (15) Y
AWARD_SHORT_NAME VARCHAR2 (30) Y
PROJECT_NUMBER VARCHAR2 (25) Y
PROJECT_NAME VARCHAR2 (30) Y
PROJECT_STATUS VARCHAR2 (80) Y
DRAFT_REVENUE_NUM NUMBER (15) Y
CUSTOMER_NUMBER VARCHAR2 (30) Y
CUSTOMER_NAME VARCHAR2 (50)
AGREEMENT_NUM VARCHAR2 (50) Y
REVENUE_CURRENCY_CODE VARCHAR2 (15)
REVENUE_AMOUNT NUMBER

REVENUE_STATUS VARCHAR2 (80) Y
DRAFT_REVENUE_NUM_CREDITED NUMBER (15)
ACCRUE_THROUGH_DATE DATE

GENERATION_ERROR VARCHAR2 (10)
PA_DATE DATE
Y
RELEASED_DATE DATE

TRANSFERRED_DATE DATE

GL_DATE DATE

CUSTOMER_BILL_SPLIT NUMBER (7)
RESOURCE_ACCUMULATED_FLAG VARCHAR2 (1)
UNBILLED_RECEIVABLE_DR NUMBER (22)
UNEARNED_REVENUE_CR NUMBER (22)
TRANSFER_REJECTION_REASON VARCHAR2 (250)
UNBILLED_CODE_COMBINATION_ID NUMBER (15)
UNEARNED_CODE_COMBINATION_ID NUMBER (15)
UNBILLED_BATCH_NAME VARCHAR2 (30)
UNEARNED_BATCH_NAME VARCHAR2 (30)
ACCUMULATED_FLAG VARCHAR2 (1)
PROJECT_ID NUMBER (15) Y
CUSTOMER_ID NUMBER (15) Y
GMS_REVENUE_CUSTOMER_ID NUMBER (15) Y
AGREEMENT_ID NUMBER (15) Y
TRANSFER_STATUS_CODE VARCHAR2 (1) Y
GENERATION_ERROR_FLAG VARCHAR2 (1) Y
PROJECT_TYPE VARCHAR2 (20) Y
PROJECT_STATUS_CODE VARCHAR2 (30) Y
PROJECT_ORGANIZATION_NAME VARCHAR2 (240) Y
REVENUE_STATUS_CODE VARCHAR2 (30) Y
PROJECT_ORGANIZATION_ID NUMBER (15) Y
REQUEST_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)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

TRANSFER_STATUS VARCHAR2 (80) Y
EXCEPTION_FLAG VARCHAR2 (1)
UPDATE_ALLOWED VARCHAR2 (4000)
VIEW_LABOR_COSTS_ALLOWED VARCHAR2 (4000)
UPDATE_ALLOW VARCHAR2 (4000)
CC_PRVDR_FLAG VARCHAR2 (1)
PROJFUNC_CURRENCY_CODE VARCHAR2 (15)
PROJFUNC_REVENUE_AMOUNT NUMBER

PROJECT_CURRENCY_CODE VARCHAR2 (15)
PROJECT_REVENUE_AMOUNT NUMBER

FUNDING_CURRENCY_CODE VARCHAR2 (15)
FUNDING_REVENUE_AMOUNT NUMBER

REVPROC_CURRENCY_CODE VARCHAR2 (15)
ADJUSTING_REVENUE_FLAG VARCHAR2 (1)
REALIZED_GAINS_AMOUNT NUMBER

The amount realized gains debit by the draft revenue
REALIZED_LOSSES_AMOUNT NUMBER

The amount realized losses credited by the draft revenue
REALIZED_GAINS_CCID NUMBER (15)
The identifer of the GL account to which the realized gains amount of this draft revenue is charged. This will be populated by interface revenue to GL process
REALIZED_LOSSES_CCID NUMBER (15)
The identifer of the GL account to which the realized losses amount of this draft revenue is charged. This will be populated by interface revenue to GL process
REALIZED_GAINS_BATCH_NAME VARCHAR2 (30)
The identifer of the GL JE line in which the realized gains amount is included when posted to GL. This value is a concatenation of realized gains CCID, draft revenue GL Date and transfer request id seperated by hyphens. Joins to GL_JE_LINES_REFERENCE_1
REALIZED_LOSSES_BATCH_NAME VARCHAR2 (30)
The identifer of the GL JE line in which the realized losses amount is included when posted to GL. This value is a concatenation of realized losses CCID, draft revenue GL Date and transfer request id seperated by hyphens. Joins to GL_JE_LINES_REFERENCE_1
EVENT_ID NUMBER (15)
REVTRANS_UBR_DR NUMBER

REVTRANS_UER_CR NUMBER

REVTRANS_CURRENCY_CODE VARCHAR2 (4000)
REVTRANS_AMOUNT NUMBER

ORG_ID NUMBER (15)
WARNING CHAR (1)

[top of page]

APPS.GMS_DRAFT_REVENUES_V references the following:

APPS
PACKAGE - GMS_SECURITY
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_PARTIES
PACKAGE - PA_CURRENCY
SYNONYM - PA_DISTRIBUTION_WARNINGS
SYNONYM - PA_DRAFT_REVENUE_ITEMS
SYNONYM - PA_PROJECT_STATUSES
PACKAGE - PA_SECURITY
SYS
TABLE - DUAL
- PA_LOOKUPS
- HR_ORGANIZATION_UNITS
- PA_AGREEMENTS_ALL
- PA_PROJECTS
- GMS_AWARDS
- PA_PROJECT_TYPES
- PA_DRAFT_REVENUES

APPS.GMS_DRAFT_REVENUES_V is not referenced by any database object

[top of page]

View: GMS_DTRANGE_BAL_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
PROJECT_ID NUMBER (15) Y Project Id
AWARD_ID NUMBER (15) Y Award Id
BUDGET_VERSION_ID NUMBER (15) Y Budget Version Id
START_DATE DATE
Y Start Date
END_DATE DATE
Y End Date

[top of page]

APPS.GMS_DTRANGE_BAL_V references the following:

APPS
SYNONYM - GMS_BALANCES

APPS.GMS_DTRANGE_BAL_V is not referenced by any database object

[top of page]

View: GMS_EMPLOYEES

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)
FULL_NAME VARCHAR2 (240)
EMPLOYEE_NUMBER VARCHAR2 (30)
LAST_NAME VARCHAR2 (150)
FIRST_NAME VARCHAR2 (150)
MIDDLE_NAMES VARCHAR2 (60)
EFFECTIVE_START_DATE DATE

EFFECTIVE_END_DATE DATE

EXPENSE_CHECK_SEND_TO_ADDRESS VARCHAR2 (30)
BUSINESS_GROUP_ID NUMBER (15)
VENDOR_ID NUMBER (15)
ACTIVE VARCHAR2 (30)

[top of page]

APPS.GMS_EMPLOYEES references the following:

APPS
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
- PA_EMPLOYEES

APPS.GMS_EMPLOYEES is not referenced by any database object

[top of page]

View: GMS_ENCUMBRANCES_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)
ENCUMBRANCE_ID NUMBER (15) Y
ENCUMBRANCE_STATUS_CODE VARCHAR2 (30) Y
ENCUMBRANCE_ENDING_DATE DATE
Y
ENCUMBRANCE_CLASS_CODE VARCHAR2 (2) Y
INCURRED_BY_PERSON_ID NUMBER (9)
INCURRED_BY_EMPLOYEE_NAME VARCHAR2 (240)
INCURRED_BY_EMPLOYEE_NUMBER VARCHAR2 (30)
INCURRED_BY_ORGANIZATION_ID NUMBER (15)
ORGANIZATION_NAME VARCHAR2 (240) Y
ENCUMBRANCE_GROUP VARCHAR2 (240)
CONTROL_TOTAL_AMOUNT NUMBER (22)
ENTERED_BY_PERSON_ID NUMBER (9)
DESCRIPTION VARCHAR2 (250)
INITIAL_SUBMISSION_DATE DATE

DENOM_CURRENCY_CODE VARCHAR2 (15)
ACCT_CURRENCY_CODE VARCHAR2 (15)
ACCT_RATE_DATE DATE

ACCT_RATE_TYPE VARCHAR2 (30)
ACCT_EXCHANGE_RATE NUMBER

LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY 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)
ORIG_ENC_TXN_REFERENCE1 VARCHAR2 (60)
ORIG_USER_ENC_TXN_REFERENCE VARCHAR2 (60)
VENDOR_ID NUMBER

ORIG_ENC_TXN_REFERENCE2 VARCHAR2 (60)
ORIG_ENC_TXN_REFERENCE3 VARCHAR2 (60)
OVERRIDING_APPROVER_PERSON_ID NUMBER

WF_STATUS_CODE VARCHAR2 (30)
TRANSFER_STATUS_CODE VARCHAR2 (1)
USER_BATCH_NAME VARCHAR2 (50)
ORG_ID NUMBER (15)

[top of page]

APPS.GMS_ENCUMBRANCES_V references the following:

APPS
SYNONYM - GMS_ENCUMBRANCES
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
- HR_ORGANIZATION_UNITS
- PER_PEOPLE_F

APPS.GMS_ENCUMBRANCES_V is not referenced by any database object

[top of page]

View: GMS_ENCUMBRANCE_GROUPS_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)
ENCUMBRANCE_GROUP VARCHAR2 (240) Y
ENCUMBRANCE_ENDING_DATE DATE
Y
ENCUMBRANCE_GROUP_STATUS_CODE VARCHAR2 (30) Y
ENCUMBRANCE_GROUP_STATUS_M VARCHAR2 (80) Y
SYSTEM_LINKAGE_FUNCTION VARCHAR2 (30) Y
SYSTEM_LINKAGE VARCHAR2 (80) Y
DESCRIPTION VARCHAR2 (250)
CONTROL_COUNT VARCHAR2 (20)
CONTROL_TOTAL_AMOUNT NUMBER (22)
TRANSACTION_SOURCE VARCHAR2 (30)
LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
CREATED_BY_EMPLOYEE_NAME VARCHAR2 (240)
CREATED_BY_EMPLOYEE_NUMBER VARCHAR2 (30)
USER_TRANSACTION_SOURCE VARCHAR2 (80)
ALLOW_ADJUSTMENTS_FLAG VARCHAR2 (1)
ALLOW_REVERSAL_FLAG VARCHAR2 (1)
ORG_ID NUMBER (15)

[top of page]

APPS.GMS_ENCUMBRANCE_GROUPS_V references the following:

APPS
SYNONYM - FND_USER
SYNONYM - GMS_ENCUMBRANCE_GROUPS
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
SYNONYM - PA_SYSTEM_LINKAGES
SYNONYM - PA_TRANSACTION_SOURCES
- PA_LOOKUPS
- PER_PEOPLE_F

APPS.GMS_ENCUMBRANCE_GROUPS_V is not referenced by any database object

[top of page]

View: GMS_ENCUMBRANCE_ITEMS_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)
ENCUMBRANCE_ITEM_ID NUMBER (15) Y
ENCUMBRANCE_ID NUMBER (15) Y
PROJECT_ID NUMBER (15) Y
PROJECT_NUMBER VARCHAR2 (25) Y
PROJECT_NAME VARCHAR2 (30) Y
TASK_ID NUMBER (15) Y
TASK_NUMBER VARCHAR2 (25) Y
TASK_NAME VARCHAR2 (20) Y
ENCUMBRANCE_GROUP VARCHAR2 (240)
ENCUMBRANCE_STATUS_CODE VARCHAR2 (30) Y
INCURRED_BY_PERSON_ID NUMBER (9)
UNIT_OF_MEASURE_M VARCHAR2 (80) Y
SYSTEM_LINKAGE_FUNCTION VARCHAR2 (3) Y
ENCUMBRANCE_ITEM_DATE DATE
Y
ENCUMBRANCE_TYPE VARCHAR2 (30) Y
ENC_DISTRIBUTED_FLAG VARCHAR2 (1) Y
OVERRIDE_TO_ORGANIZATION_ID NUMBER (15)
ADJUSTED_ENCUMBRANCE_ITEM_ID NUMBER (15)
NET_ZERO_ADJUSTMENT_FLAG VARCHAR2 (1)
TRANSFERRED_FROM_ENC_ITEM_ID NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY 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)
ORIG_TRANSACTION_REFERENCE VARCHAR2 (30)
TRANSACTION_SOURCE VARCHAR2 (30)
SOURCE_ENCUMBRANCE_ITEM_ID NUMBER (15)
JOB_ID NUMBER (15)
USER_TRANSACTION_SOURCE VARCHAR2 (80)
DENOM_CURRENCY_CODE VARCHAR2 (15)
DENOM_RAW_AMOUNT NUMBER

ACCT_EXCHANGE_ROUNDING_LIMIT NUMBER

ACCT_CURRENCY_CODE VARCHAR2 (15)
ACCT_RATE_DATE DATE

ACCT_RATE_TYPE VARCHAR2 (30)
ACCT_EXCHANGE_RATE NUMBER

ACCT_RAW_COST NUMBER

PROJECT_CURRENCY_CODE VARCHAR2 (15)
PROJECT_RATE_DATE DATE

PROJECT_RATE_TYPE VARCHAR2 (30)
PROJECT_EXCHANGE_RATE NUMBER

COST_RATE_FLAG VARCHAR2 (1) Y
INCURRED_BY_ORGANIZATION_ID NUMBER (15)
ALLOW_REVERSAL_FLAG VARCHAR2 (1)
AMOUNT NUMBER (22)
ENCUMBRANCE_COMMENT VARCHAR2 (240)
IND_COMPILED_SET_ID NUMBER (15)
PA_DATE DATE

GL_DATE DATE

LINE_NUM NUMBER

BURDEN_SUM_DEST_RUN_ID NUMBER (15)
BURDEN_SUM_SOURCE_RUN_ID NUMBER (4)
ORG_ID NUMBER (15)

[top of page]

APPS.GMS_ENCUMBRANCE_ITEMS_V references the following:

APPS
SYNONYM - GMS_ENCUMBRANCES
SYNONYM - GMS_ENCUMBRANCE_ITEMS_ALL
SYNONYM - PA_EXPENDITURE_TYPES
SYNONYM - PA_TASKS
SYNONYM - PA_TRANSACTION_SOURCES
- PA_PROJECTS_ALL
- PA_LOOKUPS

APPS.GMS_ENCUMBRANCE_ITEMS_V is not referenced by any database object

[top of page]

View: GMS_ENC_PSI_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
PROJECT_ID NUMBER (15)
TASK_ID NUMBER (15)
TRANSACTION_SOURCE CHAR (14)
LINE_TYPE CHAR (1)
CMT_NUMBER VARCHAR2 (240)
CMT_DISTRIBUTION_ID NUMBER

CMT_HEADER_ID NUMBER (15)
DESCRIPTION VARCHAR2 (0)
EXPENDITURE_ITEM_DATE DATE

PA_PERIOD VARCHAR2 (4000)
GL_PERIOD VARCHAR2 (4000)
CMT_LINE_NUMBER NUMBER

CMT_CREATION_DATE DATE

CMT_APPROVED_DATE DATE

CMT_REQUESTOR_NAME VARCHAR2 (0)
CMT_BUYER_NAME VARCHAR2 (0)
CMT_APPROVED_FLAG VARCHAR2 (1)
CMT_PROMISED_DATE DATE

CMT_NEED_BY_DATE DATE

ORGANIZATION_ID NUMBER

VENDOR_ID NUMBER

VENDOR_NAME VARCHAR2 (0)
EXPENDITURE_TYPE VARCHAR2 (30)
EXPENDITURE_CATEGORY VARCHAR2 (30)
REVENUE_CATEGORY VARCHAR2 (30)
SYSTEM_LINKAGE_FUNCTION VARCHAR2 (3)
UNIT_OF_MEASURE VARCHAR2 (0)
UNIT_PRICE NUMBER

CMT_IND_COMPILED_SET_ID NUMBER

ACCT_RAW_COST NUMBER

ACCT_BURDENED_COST NUMBER

TOT_CMT_QUANTITY NUMBER

QUANTITY_ORDERED NUMBER

AMOUNT_ORDERED NUMBER

ORIGINAL_QUANTITY_ORDERED NUMBER

ORIGINAL_AMOUNT_ORDERED NUMBER

QUANTITY_CANCELLED NUMBER

AMOUNT_CANCELLED NUMBER

QUANTITY_DELIVERED NUMBER

QUANTITY_INVOICED NUMBER

AMOUNT_INVOICED NUMBER

QUANTITY_OUTSTANDING_DELIVERY NUMBER

AMOUNT_OUTSTANDING_DELIVERY NUMBER

QUANTITY_OUTSTANDING_INVOICE NUMBER

AMOUNT_OUTSTANDING_INVOICE NUMBER

QUANTITY_OVERBILLED NUMBER

AMOUNT_OVERBILLED NUMBER

ORIGINAL_TXN_REFERENCE1 VARCHAR2 (150)
ORIGINAL_TXN_REFERENCE2 VARCHAR2 (150)
ORIGINAL_TXN_REFERENCE3 VARCHAR2 (0)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER

CREATION_DATE DATE

CREATED_BY NUMBER

LAST_UPDATE_LOGIN NUMBER

REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

DENOM_CURRENCY_CODE VARCHAR2 (15)
DENOM_RAW_COST NUMBER

DENOM_BURDENED_COST NUMBER

ACCT_CURRENCY_CODE VARCHAR2 (15)
ACCT_RATE_DATE DATE

ACCT_RATE_TYPE VARCHAR2 (30)
ACCT_EXCHANGE_RATE NUMBER

RECEIPT_CURRENCY_CODE VARCHAR2 (0)
RECEIPT_CURRENCY_AMOUNT NUMBER

RECEIPT_EXCHANGE_RATE NUMBER

ORG_ID NUMBER (15)
ADJUSTMENT_TYPE VARCHAR2 (150)

[top of page]

APPS.GMS_ENC_PSI_V references the following:

APPS
SYNONYM - GMS_AWARD_DISTRIBUTIONS
PACKAGE - GMS_COST_PLUS_EXTN
SYNONYM - GMS_ENCUMBRANCES
SYNONYM - GMS_ENCUMBRANCE_ITEMS
SYNONYM - GMS_ENCUMBRANCE_ITEMS_ALL
PACKAGE - PA_ACCUM_UTILS
SYNONYM - PA_COMPILED_MULTIPLIERS
SYNONYM - PA_COST_BASE_COST_CODES
SYNONYM - PA_COST_BASE_EXP_TYPES
PACKAGE - PA_CURRENCY
SYNONYM - PA_EXPENDITURE_TYPES
SYNONYM - PA_IND_COST_CODES
SYNONYM - PA_TASKS
APPS.GMS_ENC_PSI_V is referenced by following:

APPS
VIEW - GMS_COMMITMENT_TXNS_V

[top of page]

View: GMS_EVENTS_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
TASK_ID NUMBER (15)
EVENT_NUM 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
EVENT_TYPE VARCHAR2 (30) Y
DESCRIPTION VARCHAR2 (240) Y
EVENT_BILL_AMOUNT NUMBER (22) Y
EVENT_REVENUE_AMOUNT NUMBER (22) Y
REVENUE_DISTRIBUTED_FLAG VARCHAR2 (1) Y
BILL_HOLD_FLAG VARCHAR2 (1)
COMPLETION_DATE DATE

REV_DIST_REJECTION_CODE VARCHAR2 (30)
REQUEST_ID NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

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)
PROJECT_ID NUMBER (15) Y
ORGANIZATION_ID NUMBER (15) Y
BILLING_ASSIGNMENT_ID NUMBER (15)
EVENT_NUM_REVERSED NUMBER (15)
CALLING_PLACE VARCHAR2 (30)
CALLING_PROCESS VARCHAR2 (30)
AUDIT_COST_BUDGET_TYPE_CODE VARCHAR2 (30)
AUDIT_REV_BUDGET_TYPE_CODE VARCHAR2 (30)
AUDIT_AMOUNT1 NUMBER

AUDIT_AMOUNT2 NUMBER

AUDIT_AMOUNT3 NUMBER

AUDIT_AMOUNT4 NUMBER

AUDIT_AMOUNT5 NUMBER

AUDIT_AMOUNT6 NUMBER

AUDIT_AMOUNT7 NUMBER

AUDIT_AMOUNT8 NUMBER

AUDIT_AMOUNT9 NUMBER

AUDIT_AMOUNT10 NUMBER

EVENT_ID NUMBER
Y
INSTALLMENT_ID NUMBER (15) Y
ACTUAL_PROJECT_ID NUMBER (15)
ACTUAL_TASK_ID NUMBER (15)
BURDEN_COST_CODE VARCHAR2 (30)
EXPENDITURE_ORG_ID NUMBER (15)
BILL_AMOUNT NUMBER (22)
REVENUE_AMOUNT NUMBER (22)
WRITE_OFF_AMOUNT NUMBER (22)
REVENUE_ACCUMULATED VARCHAR2 (1)
RESOURCE_LIST_MEMBER_ID NUMBER (15)
EVENT_REQUEST_ID NUMBER (15)
EXPENDITURE_TYPE VARCHAR2 (30)
EVENT_CALLING_PROCESS VARCHAR2 (30)

[top of page]

APPS.GMS_EVENTS_V references the following:

APPS
SYNONYM - GMS_EVENT_ATTRIBUTE
SYNONYM - PA_EVENTS

APPS.GMS_EVENTS_V is not referenced by any database object

[top of page]

View: GMS_EXPEND_ITEMS_ADJUST_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_ITEM_ID NUMBER (15) Y
EXPENDITURE_ID NUMBER (15) Y
ADL_LINE_NUM NUMBER (15) Y
PROJECT_ID NUMBER (15) Y
PROJECT_NUMBER VARCHAR2 (25) Y
PROJECT_NAME VARCHAR2 (30) Y
PROJECT_TYPE VARCHAR2 (20) Y
PROJECT_TYPE_CLASS_CODE VARCHAR2 (30)
PROJECT_CLASS VARCHAR2 (80) Y
TASK_ID NUMBER (15) Y
TASK_NUMBER VARCHAR2 (25) Y
TASK_NAME VARCHAR2 (20) Y
EXPENDITURE_ITEM_DATE DATE
Y
EXPENDITURE_TYPE VARCHAR2 (30) Y
EXPENDITURE_CATEGORY VARCHAR2 (30) Y
REVENUE_CATEGORY_CODE VARCHAR2 (30) Y
INCURRED_BY_PERSON_ID NUMBER (15)
EMPLOYEE_NAME VARCHAR2 (240)
EMPLOYEE_NUMBER VARCHAR2 (30)
JOB_ID NUMBER (15)
JOB_NAME VARCHAR2 (700)
INCURRED_BY_ORGANIZATION_ID NUMBER (15)
OVERRIDE_TO_ORGANIZATION_ID NUMBER (15)
EXPENDITURE_ORGANIZATION_ID NUMBER

EXPENDITURE_ORGANIZATION_NAME VARCHAR2 (240) Y
VENDOR_ID NUMBER

VENDOR_NUMBER VARCHAR2 (30)
VENDOR_NAME VARCHAR2 (240)
EMPLOYEE_VENDOR_NAME VARCHAR2 (240)
EMPLOYEE_VENDOR_NUMBER VARCHAR2 (30)
NON_LABOR_RESOURCE VARCHAR2 (20)
NLR_ORGANIZATION_ID NUMBER (15)
NLR_ORGANIZATION_NAME VARCHAR2 (240)
SYSTEM_LINKAGE_FUNCTION VARCHAR2 (3) Y
SYSTEM_LINKAGE_M VARCHAR2 (80) Y
EXPENDITURE_COMMENT VARCHAR2 (240)
TRANSACTION_SOURCE VARCHAR2 (30)
ORIG_TRANSACTION_REFERENCE VARCHAR2 (50)
EXPENDITURE_GROUP VARCHAR2 (240) Y
EXPENDITURE_STATUS_CODE VARCHAR2 (30) Y
EXPENDITURE_STATUS_M VARCHAR2 (80) Y
EXPENDITURE_ENDING_DATE DATE
Y
QUANTITY NUMBER

BURDEN_COST NUMBER

UNIT_OF_MEASURE VARCHAR2 (30) Y
UNIT_OF_MEASURE_M VARCHAR2 (80) Y
RAW_COST NUMBER (22)
RAW_COST_RATE NUMBER

COST_DISTRIBUTED_FLAG VARCHAR2 (1)
COST_DIST_REJECTION_CODE VARCHAR2 (30)
LABOR_COST_MULTIPLIER_NAME VARCHAR2 (20)
BURDENED_COST NUMBER

BURDENED_COST_RATE NUMBER

COST_BURDEN_DISTRIBUTED_FLAG VARCHAR2 (1)
RECEIPT_CURRENCY_CODE VARCHAR2 (15)
RECEIPT_CURRENCY_AMOUNT NUMBER

RECEIPT_EXCHANGE_RATE NUMBER

DENOM_CURRENCY_CODE VARCHAR2 (15)
DENOM_RAW_COST NUMBER

DENOM_BURDENED_COST NUMBER

ACCT_EXCHANGE_ROUNDING_LIMIT NUMBER

ACCT_CURRENCY_CODE VARCHAR2 (15)
ACCT_RATE_TYPE VARCHAR2 (30)
ACCT_RATE_DATE DATE

ACCT_EXCHANGE_RATE NUMBER

ACCT_RAW_COST NUMBER

ACCT_BURDENED_COST NUMBER

PROJECT_CURRENCY_CODE VARCHAR2 (15)
PROJECT_RATE_TYPE VARCHAR2 (30)
PROJECT_RATE_DATE DATE

PROJECT_EXCHANGE_RATE NUMBER

IND_COST_DIST_REJECTION_CODE VARCHAR2 (30)
COST_IND_COMPILED_SET_ID NUMBER (15)
ADL_IND_COMPILED_SET_ID NUMBER (15)
CAPITALIZABLE_FLAG VARCHAR2 (1)
ACCRUED_REVENUE NUMBER (22)
ACCRUAL_RATE NUMBER (22)
RAW_REVENUE NUMBER (22)
FORECAST_REVENUE NUMBER

BILL_AMOUNT NUMBER (22)
BILL_RATE NUMBER (22)
BILL_RATE_MULTIPLIER NUMBER (22)
ADJUSTED_REVENUE NUMBER (22)
ADJUSTED_RATE NUMBER (22)
BILLABLE_FLAG VARCHAR2 (1)
REVENUE_DISTRIBUTED_FLAG VARCHAR2 (1)
BILL_HOLD_FLAG VARCHAR2 (1)
REV_DIST_REJECTION_CODE VARCHAR2 (30)
BILL_JOB_ID NUMBER (15)
BILL_JOB_BILLING_TITLE VARCHAR2 (80)
BILL_EMPLOYEE_BILLING_TITLE VARCHAR2 (80)
REV_IND_COMPILED_SET_ID NUMBER (15)
INV_IND_COMPILED_SET_ID NUMBER (15)
EVENT_PROJECT_ID NUMBER (15)
EVENT_NUM NUMBER (15)
EVENT_TASK_ID NUMBER (15)
ADJUSTED_EXPENDITURE_ITEM_ID NUMBER (15)
NET_ZERO_ADJUSTMENT_FLAG VARCHAR2 (1)
TRANSFERRED_FROM_EXP_ITEM_ID NUMBER (15)
CONVERTED_FLAG VARCHAR2 (1)
SOURCE_EXPENDITURE_ITEM_ID NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY 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)
EXPENDITURE_ORG_ID NUMBER (15)
SYSTEM_REFERENCE2 VARCHAR2 (30)
ORG_ID NUMBER (15)
USER_TRANSACTION_SOURCE VARCHAR2 (80)
ALLOW_ADJUSTMENTS_FLAG VARCHAR2 (1)
COSTED_FLAG VARCHAR2 (1)
COST_BURDENED_FLAG VARCHAR2 (1)
GL_ACCOUNTED_FLAG VARCHAR2 (1)
ALLOW_REVERSAL_FLAG VARCHAR2 (1)
ALLOW_BURDEN_FLAG VARCHAR2 (1)
BURDEN_SUM_DEST_RUN_ID NUMBER (15)
BURDEN_SUM_REJECTION_CODE VARCHAR2 (30)
BURDEN_SUM_REJECTION_M VARCHAR2 (80)
PROJECT_STATUS_CODE VARCHAR2 (30) Y
USER_ACCT_RATE_TYPE VARCHAR2 (30)
USER_PROJECT_RATE_TYPE VARCHAR2 (30)
ORIG_EXP_TXN_REFERENCE1 VARCHAR2 (60)
ORIG_USER_EXP_TXN_REFERENCE VARCHAR2 (60)
ORIG_EXP_TXN_REFERENCE2 VARCHAR2 (60)
ORIG_EXP_TXN_REFERENCE3 VARCHAR2 (60)
OVERRIDING_APPROVER_PERSON_ID NUMBER

WF_STATUS_CODE VARCHAR2 (30)
TRANSFER_STATUS_CODE VARCHAR2 (1)
USER_BATCH_NAME VARCHAR2 (50)

[top of page]

APPS.GMS_EXPEND_ITEMS_ADJUST_V references the following:

APPS
SYNONYM - FND_LOOKUP_VALUES
SYNONYM - GMS_AWARD_DISTRIBUTIONS
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
SYNONYM - PA_EXPENDITURE_COMMENTS
SYNONYM - PA_EXPENDITURE_TYPES
SYNONYM - PA_SYSTEM_LINKAGES
SYNONYM - PA_TASKS
SYNONYM - PA_TRANSACTION_SOURCES
SYNONYM - PER_JOBS
VIEW - PO_VENDORS
- PA_COST_DIST_LINES_ALL_BAS
- PER_PEOPLE_F
- PA_PROJECT_TYPES_ALL
- PA_EXPENDITURES_ALL
- PA_CONVERSION_TYPES_V
- PA_PROJECTS
- PA_EXPENDITURE_ITEMS_ALL

APPS.GMS_EXPEND_ITEMS_ADJUST_V is not referenced by any database object

[top of page]

View: GMS_FP_DISTRIBUTIONS_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
FUNDING_PATTERN_ID NUMBER (15) Y
DISTRIBUTION_NUMBER NUMBER (15)
AWARD_ID NUMBER (15) Y
DISTRIBUTION_VALUE NUMBER (7) Y
AWARD_NUMBER VARCHAR2 (15) Y
AWARD_NAME VARCHAR2 (30) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15) Y
ORG_ID NUMBER (15)

[top of page]

APPS.GMS_FP_DISTRIBUTIONS_V references the following:

APPS
SYNONYM - GMS_AWARDS
SYNONYM - GMS_FP_DISTRIBUTIONS

APPS.GMS_FP_DISTRIBUTIONS_V is not referenced by any database object

[top of page]

View: GMS_FUNDING_AWARDS_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
AWARD_ID NUMBER (15) Y Unique identifier for the award
AWARD_NAME VARCHAR2 (30) Y Name of the award
ACTUAL_PROJECT_ID NUMBER (15) Y Unique identifier for the project funded by the award
ORG_ID NUMBER (15)

[top of page]

APPS.GMS_FUNDING_AWARDS_V references the following:

APPS
SYNONYM - GMS_INSTALLMENTS
SYNONYM - GMS_SUMMARY_PROJECT_FUNDINGS
- GMS_AWARDS
- PA_PROJECTS_ALL

APPS.GMS_FUNDING_AWARDS_V is not referenced by any database object

[top of page]

View: GMS_FUNDING_PATTERNS_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
FUNDING_PATTERN_ID NUMBER (15) Y
FUNDING_SEQUENCE NUMBER (15) Y
FUNDING_NAME VARCHAR2 (30) Y
RETROACTIVE_FLAG VARCHAR2 (1) Y
PROJECT_ID NUMBER (15) Y
TASK_ID NUMBER (15)
STATUS VARCHAR2 (6) Y
FUNDS_STATUS VARCHAR2 (1)
START_DATE DATE
Y
END_DATE DATE

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

[top of page]

APPS.GMS_FUNDING_PATTERNS_V references the following:

APPS
SYNONYM - GMS_FUNDING_PATTERNS

APPS.GMS_FUNDING_PATTERNS_V is not referenced by any database object

[top of page]

View: GMS_FUNDSCTL_RES_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
PACKET_ID NUMBER (15) Y
BC_PACKET_ID NUMBER

PARENT_BC_PACKET_ID NUMBER

REQUEST_ID NUMBER (15)
PROJECT_ID NUMBER (15) Y
AWARD_ID NUMBER (15) Y
TASK_ID NUMBER (15) Y
TOP_TASK_ID NUMBER (15)
EXPENDITURE_TYPE VARCHAR2 (30) Y
EXPENDITURE_ITEM_DATE DATE
Y
ACTUAL_FLAG VARCHAR2 (1) Y
STATUS_CODE VARCHAR2 (1) Y
SET_OF_BOOKS_ID NUMBER (15) Y
JE_CATEGORY_NAME VARCHAR2 (30) Y
JE_SOURCE_NAME VARCHAR2 (30) Y
DOCUMENT_TYPE VARCHAR2 (3) Y
EXPENDITURE_ORGANIZATION_ID NUMBER (15)
PERIOD_NAME VARCHAR2 (15)
PERIOD_YEAR NUMBER (15)
PERIOD_NUM NUMBER (15)
DOCUMENT_HEADER_ID NUMBER (15)
DOCUMENT_DISTRIBUTION_ID NUMBER (15)
BUDGET_VERSION_ID NUMBER (15)
ACCOUNT_TYPE VARCHAR2 (1)
ENTERED_DR NUMBER

ENTERED_CR NUMBER

EFFECT_ON_FUNDS_CODE VARCHAR2 (1)
RESULT_CODE VARCHAR2 (3)
GL_ROW_NUMBER NUMBER

RESOURCE_LIST_MEMBER_ID NUMBER (15)
PARENT_RESOURCE_ID NUMBER (15)
BUD_RESOURCE_LIST_MEMBER_ID NUMBER (15)
BUD_TASK_ID NUMBER (15)
FUNDING_PATTERN_ID NUMBER (15)
FUNDING_SEQUENCE NUMBER (15)
FP_STATUS VARCHAR2 (1)
R_FUNDS_CONTROL_LEVEL_CODE VARCHAR2 (1)
RG_FUNDS_CONTROL_LEVEL_CODE VARCHAR2 (1)
T_FUNDS_CONTROL_LEVEL_CODE VARCHAR2 (1)
TT_FUNDS_CONTROL_LEVEL_CODE VARCHAR2 (1)
A_FUNDS_CONTROL_LEVEL_CODE VARCHAR2 (1)
AWARD_BUDGET_POSTED NUMBER

AWARD_BUDGET_APPROVED NUMBER

AWARD_BUDGET_PENDING NUMBER

TOTAL_AWARD_BUDGET NUMBER

AWARD_ENC_POSTED NUMBER

AWARD_ENC_APPROVED NUMBER

AWARD_ENC_PENDING NUMBER

TOTAL_AWARD_ENCUMBRANCE NUMBER

AWARD_ACTUAL_POSTED NUMBER

AWARD_ACTUAL_APPROVED NUMBER

AWARD_ACTUAL_PENDING NUMBER

TOTAL_AWARD_ACTUAL NUMBER

AWARD_RESULT_CODE VARCHAR2 (3)
TOP_TASK_BUDGET_POSTED NUMBER

TOP_TASK_BUDGET_APPROVED NUMBER

TOP_TASK_BUDGET_PENDING NUMBER

TOTAL_TOP_TASK_BUDGET NUMBER

TOP_TASK_ENC_POSTED NUMBER

TOP_TASK_ENC_APPROVED NUMBER

TOP_TASK_ENC_PENDING NUMBER

TOTAL_TOP_TASK_ENCUMBRANCE NUMBER

TOP_TASK_ACTUAL_POSTED NUMBER

TOP_TASK_ACTUAL_APPROVED NUMBER

TOP_TASK_ACTUAL_PENDING NUMBER

TOTAL_TOP_TASK_ACTUAL NUMBER

TOP_TASK_RESULT_CODE VARCHAR2 (3)
TASK_BUDGET_POSTED NUMBER

TASK_BUDGET_APPROVED NUMBER

TASK_BUDGET_PENDING NUMBER

TOTAL_TASK_BUDGET NUMBER

TASK_ENC_POSTED NUMBER

TASK_ENC_APPROVED NUMBER

TASK_ENC_PENDING NUMBER

TOTAL_TASK_ENCUMBRANCE NUMBER

TASK_ACTUAL_POSTED NUMBER

TASK_ACTUAL_APPROVED NUMBER

TASK_ACTUAL_PENDING NUMBER

TOTAL_TASK_ACTUAL NUMBER

TASK_RESULT_CODE VARCHAR2 (3)
RES_GRP_BUDGET_POSTED NUMBER

RES_GRP_BUDGET_APPROVED NUMBER

RES_GRP_BUDGET_PENDING NUMBER

TOTAL_RES_GRP_BUDGET NUMBER

RES_GRP_ENC_POSTED NUMBER

RES_GRP_ENC_APPROVED NUMBER

RES_GRP_ENC_PENDING NUMBER

TOTAL_RES_GRP_ENC NUMBER

RES_GRP_ACTUAL_POSTED NUMBER

RES_GRP_ACTUAL_APPROVED NUMBER

RES_GRP_ACTUAL_PENDING NUMBER

TOTAL_RES_GRP_ACTUAL NUMBER

RES_GRP_RESULT_CODE VARCHAR2 (3)
RES_BUDGET_POSTED NUMBER

RES_BUDGET_APPROVED NUMBER

RES_BUDGET_PENDING NUMBER

TOTAL_RES_BUDGET NUMBER

RES_ENC_POSTED NUMBER

RES_ENC_APPROVED NUMBER

RES_ENC_PENDING NUMBER

TOTAL_RES_ENC NUMBER

RES_ACTUAL_POSTED NUMBER

RES_ACTUAL_APPROVED NUMBER

RES_ACTUAL_PENDING NUMBER

TOTAL_RES_ACTUAL NUMBER

RES_RESULT_CODE VARCHAR2 (3)
AWARD_FA_POSTED NUMBER

AWARD_FA_PENDING NUMBER

AWARD_FA_APPROVED NUMBER

TOP_TASK_FA_POSTED NUMBER

TOP_TASK_FA_PENDING NUMBER

TOP_TASK_FA_APPROVED NUMBER

TASK_FA_POSTED NUMBER

TASK_FA_PENDING NUMBER

TASK_FA_APPROVED NUMBER

RES_FA_POSTED NUMBER

RES_FA_PENDING NUMBER

RES_FA_APPROVED NUMBER

RES_GRP_FA_POSTED NUMBER

RES_GRP_FA_PENDING NUMBER

RES_GRP_FA_APPROVED NUMBER

TOTAL_AWARD_FA NUMBER

TOTAL_TASK_FA NUMBER

TOTAL_TOP_TASK_FA NUMBER

TOTAL_RES_FA NUMBER

TOTAL_RES_GRP_FA NUMBER

PROJECT VARCHAR2 (25) Y
TASK VARCHAR2 (25) Y
AWARD_NUMBER VARCHAR2 (15)
VERSION_NAME VARCHAR2 (60)
GMS_RESULT_CODE_MEAN VARCHAR2 (80)
AWARD_RESULT_CODE_MEAN VARCHAR2 (80)
TASK_RESULT_CODE_MEAN VARCHAR2 (80)
RES_RESULT_CODE_MEAN VARCHAR2 (80)
RES_GRP_RESULT_CODE_MEAN VARCHAR2 (80)
TOP_TASK_RESULT_CODE_MEAN VARCHAR2 (80)
ORG_ID NUMBER (15)

[top of page]

APPS.GMS_FUNDSCTL_RES_V references the following:

APPS
SYNONYM - GMS_AWARDS_ALL
SYNONYM - GMS_BC_PACKETS
SYNONYM - GMS_BUDGET_VERSIONS
SYNONYM - GMS_IMPLEMENTATIONS_ALL
VIEW - GMS_LOOKUPS
SYNONYM - PA_TASKS
- PA_PROJECTS_ALL
- PA_PROJECT_TYPES_ALL

APPS.GMS_FUNDSCTL_RES_V is not referenced by any database object

[top of page]

View: GMS_FUNDSCTL_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
PACKET_ID NUMBER (15)

PROJECT_ID NUMBER (15)

AWARD_ID NUMBER (15)

TASK_ID NUMBER (15)

TOP_TASK_ID NUMBER (15)

EXPENDITURE_TYPE VARCHAR2 (30)

EXPENDITURE_ITEM_DATE DATE


ACTUAL_FLAG VARCHAR2 (1)

GMS_STATUS_CODE VARCHAR2 (1)

GMS_STATUS_CODE_MEANING VARCHAR2 (80)
JE_CATEGORY_NAME VARCHAR2 (30)

JE_SOURCE_NAME VARCHAR2 (30)

DOCUMENT_TYPE VARCHAR2 (80)

BCPKT_DOCUMENT_TYPE VARCHAR2 (3)
EXPENDITURE_ORGANIZATION_ID NUMBER (15)

PERIOD_NAME VARCHAR2 (15)

PERIOD_YEAR NUMBER (15)

PERIOD_NUM NUMBER (15)

DOCUMENT_HEADER_ID NUMBER (15)

DOCUMENT_DISTRIBUTION_ID NUMBER (15)

BUDGET_VERSION_ID NUMBER (15)

ACCOUNT_TYPE VARCHAR2 (1)

AMOUNT NUMBER


EFFECT_ON_FUNDS_CODE VARCHAR2 (1)

RESULT_CODE VARCHAR2 (3)

BALANCE_POSTED_FLAG VARCHAR2 (1)

BURDEN_POSTED_FLAG VARCHAR2 (1)

GL_ROW_ID VARCHAR2 (30)

PROJECT VARCHAR2 (25)

TASK VARCHAR2 (25)

AWARD_NUMBER VARCHAR2 (15)

VERSION_NAME VARCHAR2 (60)

BUDGET_STATUS_CODE VARCHAR2 (9)

BC_PACKET_ID NUMBER


FUNDS_CHECK_SEQ NUMBER (15)
REQUEST_ID NUMBER (15)
BURDEN_ADJUSTMENT_FLAG VARCHAR2 (1)
BURDEN_ADJ_BC_PACKET_ID NUMBER

ORG_ID NUMBER (15)
SOURCE_EVENT_ID NUMBER (15)

[top of page]

APPS.GMS_FUNDSCTL_V references the following:

APPS
SYNONYM - GMS_BC_PACKETS
SYNONYM - GMS_BUDGET_VERSIONS
SYNONYM - GMS_IMPLEMENTATIONS
SYNONYM - PA_TASKS
- PA_PROJECTS_ALL
- GMS_AWARDS
- GMS_LOOKUPS
- GMS_PROJECT_TYPES

APPS.GMS_FUNDSCTL_V is not referenced by any database object

[top of page]

View: GMS_INSTALLMENTS_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
INSTALLMENT_ID NUMBER (15) Y
INSTALLMENT_NUM VARCHAR2 (15)
AWARD_ID NUMBER (15)
START_DATE_ACTIVE DATE

END_DATE_ACTIVE DATE

CLOSE_DATE DATE

DIRECT_COST NUMBER

INDIRECT_COST NUMBER

ACTIVE_FLAG VARCHAR2 (10)
BILLABLE_FLAG VARCHAR2 (1)
TYPE VARCHAR2 (30)
ISSUE_DATE DATE

DESCRIPTION VARCHAR2 (250)
TYPE_DIS VARCHAR2 (80) 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)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
CREATION_DATE DATE

CREATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
ROW_ID ROWID (10)

[top of page]

APPS.GMS_INSTALLMENTS_V references the following:

APPS
SYNONYM - GMS_INSTALLMENTS
- GMS_LOOKUPS

APPS.GMS_INSTALLMENTS_V is not referenced by any database object

[top of page]

View: GMS_IP_AWARD_LOV_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
AWARD_ID NUMBER (15)
PROJECT_ID NUMBER

AWARD_NUMBER VARCHAR2 (15)
AWARD_SHORT_NAME VARCHAR2 (30)
START_DATE_ACTIVE DATE

END_DATE_ACTIVE DATE

ORG_ID NUMBER (15)

[top of page]

APPS.GMS_IP_AWARD_LOV_V references the following:

APPS
SYNONYM - GMS_AWARDS_ALL
SYNONYM - GMS_IMPLEMENTATIONS
SYNONYM - GMS_INSTALLMENTS
SYNONYM - GMS_SUMMARY_PROJECT_FUNDINGS
SYNONYM - PA_TASKS

APPS.GMS_IP_AWARD_LOV_V is not referenced by any database object

[top of page]

View: GMS_KEY_MEMBER_ROLE_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
AWARD_ID NUMBER (15) Y
AWARD_NUMBER VARCHAR2 (15) Y
AWARD_SHORT_NAME VARCHAR2 (30) Y
AWARD_ROLE VARCHAR2 (30) Y
PERSON_ID NUMBER (10) Y
FULL_NAME VARCHAR2 (240)

ORG_ID NUMBER (15)

[top of page]

APPS.GMS_KEY_MEMBER_ROLE_V references the following:

APPS
SYNONYM - GMS_PERSONNEL
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
- PER_PEOPLE_F
- GMS_AWARDS

APPS.GMS_KEY_MEMBER_ROLE_V is not referenced by any database object

[top of page]

View: GMS_LOC_CONTACTS_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
AWARD_ID NUMBER (15) Y
CONTACT_ID NUMBER (15) Y
TITLE_MEANING VARCHAR2 (80)
FIRST_NAME VARCHAR2 (40)
LAST_NAME VARCHAR2 (50)
STATUS VARCHAR2 (1)
JOB_TITLE VARCHAR2 (100)
MAIL_STOP VARCHAR2 (60)
ORIG_SYSTEM_REFERENCE VARCHAR2 (240)
ADDRESS_ID NUMBER (15) Y
CUSTOMER_ID NUMBER (15)
USAGE_CODE VARCHAR2 (30)
USAGE_MEANING VARCHAR2 (80)
PRIMARY_FLAG 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
ROW_ID ROWID (10)

[top of page]

APPS.GMS_LOC_CONTACTS_V references the following:

APPS
VIEW - AR_LOOKUPS
SYNONYM - GMS_AWARDS_CONTACTS
SYNONYM - HZ_CUST_ACCOUNT_ROLES
SYNONYM - HZ_CUST_ACCT_SITES_ALL
SYNONYM - HZ_ORG_CONTACTS
SYNONYM - HZ_PARTIES
SYNONYM - HZ_RELATIONSHIPS
- GMS_AWARDS

APPS.GMS_LOC_CONTACTS_V is not referenced by any database object

[top of page]

View: GMS_LOOKUPS

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
LOOKUP_TYPE VARCHAR2 (30) Y Lookup type name
LOOKUP_CODE VARCHAR2 (30) Y Lookup code name
MEANING VARCHAR2 (80) Y User-visible lookup code meaning
DESCRIPTION VARCHAR2 (240)
Description
ENABLED_FLAG VARCHAR2 (1) Y Lookup code enabled flag
START_DATE_ACTIVE DATE

Date that lookup code becomes enabled
END_DATE_ACTIVE DATE

Date that lookup code becomes disabled

[top of page]

APPS.GMS_LOOKUPS references the following:

APPS
SYNONYM - FND_LOOKUP_VALUES
APPS.GMS_LOOKUPS is referenced by following:

APPS
VIEW - GMS_FUNDSCTL_RES_V

[top of page]

View: GMS_NONE_BAL_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
PROJECT_ID NUMBER (15) Y Project Id
AWARD_ID NUMBER (15) Y Award Id
TASK_ID NUMBER (15) Y Task Id
BUDGET_VERSION_ID NUMBER (15) Y Budget Version Id
START_DATE DATE

Start Date
END_DATE DATE

End Date

[top of page]

APPS.GMS_NONE_BAL_V references the following:

APPS
SYNONYM - GMS_BALANCES

APPS.GMS_NONE_BAL_V is not referenced by any database object

[top of page]

View: GMS_NOTIFICATIONS_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)
AWARD_ID NUMBER (15) Y
AWARD_NUMBER VARCHAR2 (15) Y
AWARD_SHORT_NAME VARCHAR2 (30) Y
EVENT_TYPE VARCHAR2 (30) Y
USER_ID NUMBER (15) Y
USER_FULL_NAME VARCHAR2 (240)
USER_NAME VARCHAR2 (100) Y

[top of page]

APPS.GMS_NOTIFICATIONS_V references the following:

APPS
SYNONYM - FND_USER
SYNONYM - GMS_AWARDS_ALL
SYNONYM - GMS_NOTIFICATIONS
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
- PER_PEOPLE_X

APPS.GMS_NOTIFICATIONS_V is not referenced by any database object

[top of page]

View: GMS_OPERATING_UNITS_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
ORG_ID NUMBER (15) Y Operating unit identifier for multi-organization installations
OPERATING_UNIT VARCHAR2 (240) Y Operating Unit Name.

[top of page]

APPS.GMS_OPERATING_UNITS_V references the following:

APPS
SYNONYM - GMS_IMPLEMENTATIONS_ALL
- MO_GLOBAL
- HR_OPERATING_UNITS

APPS.GMS_OPERATING_UNITS_V is not referenced by any database object

[top of page]

View: GMS_OVERRIDE_SCHEDULES_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)
Row identifiers of records
AWARD_ID NUMBER (15) Y Award Identifier
PROJECT_ID NUMBER (15) Y Project Identifier
PROJECT_NUMBER VARCHAR2 (25) Y The Project Number that uniquely identifies the Project
PROJECT_NAME VARCHAR2 (30) Y User-defined name that uniquely identifies the Project
TASK_ID NUMBER (15)
The system-generated number that uniquely identifies the Task
TASK_NUMBER VARCHAR2 (25)
User-defined number that uniquely identifies the Task within a Project
TASK_NAME VARCHAR2 (20)
User-defined short name of the task
IDC_SCHEDULE_ID NUMBER (15) Y The system-generated number which uniquely identifies the burden schedule
IDC_SCHEDULE_NAME VARCHAR2 (30) Y The implementation-defined name of the burden schedule
IDC_SCHEDULE_FIXED_DATE DATE

Fixed date for indirect cost rate schedule
IDC_SCHEDULE_TYPE VARCHAR2 (1) Y The type of the Burden Schedule
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
ORG_ID NUMBER (15)

[top of page]

APPS.GMS_OVERRIDE_SCHEDULES_V references the following:

APPS
PACKAGE - FND_PROFILE
SYNONYM - GMS_OVERRIDE_SCHEDULES
SYNONYM - PA_TASKS
PACKAGE - PA_UTILS
- PA_PROJECTS
- PA_IND_RATE_SCHEDULES

APPS.GMS_OVERRIDE_SCHEDULES_V is not referenced by any database object

[top of page]

View: GMS_PERSONNEL_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
PERSONNEL_ID NUMBER (15) Y
AWARD_ID NUMBER (15) Y
PERSON_ID NUMBER (15) Y
AWARD_ROLE VARCHAR2 (30) Y
START_DATE_ACTIVE DATE

END_DATE_ACTIVE DATE

PERSON_NAME VARCHAR2 (240)
AWARD_ROLE_DIS VARCHAR2 (80) Y
REQUIRED_FLAG VARCHAR2 (2)
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
ROW_ID ROWID (10)

[top of page]

APPS.GMS_PERSONNEL_V references the following:

APPS
SYNONYM - GMS_PERSONNEL
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
- GMS_LOOKUPS
- PER_PEOPLE_X

APPS.GMS_PERSONNEL_V is not referenced by any database object

[top of page]

View: GMS_PHONE_CONTACTS_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
PHONE_ID NUMBER (15) Y
PHONE_NUMBER VARCHAR2 (50)
STATUS VARCHAR2 (30) Y
PHONE_TYPE VARCHAR2 (30)
PHONE_TYPE_MEANING VARCHAR2 (80) Y
CUSTOMER_ID NUMBER (15) Y
CONTACT_ID NUMBER (15) Y
AREA_CODE VARCHAR2 (10)
EXTENSION VARCHAR2 (20)
PRIMARY_FLAG 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)
ROW_ID VARCHAR2 (0)

[top of page]

APPS.GMS_PHONE_CONTACTS_V references the following:

APPS
VIEW - AR_LOOKUPS
SYNONYM - HZ_CONTACT_POINTS
SYNONYM - HZ_CUST_ACCOUNT_ROLES

APPS.GMS_PHONE_CONTACTS_V is not referenced by any database object

[top of page]

View: GMS_PQH_AWARDS_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
AWARD_NUMBER VARCHAR2 (15) Y
AWARD_ID NUMBER (15) Y
AWARD_SHORT_NAME VARCHAR2 (30) Y
PROJECT_ID NUMBER
Y
TASK_ID NUMBER (15) Y
ORG_ID NUMBER (15)

[top of page]

APPS.GMS_PQH_AWARDS_V references the following:

APPS
VIEW - GMS_AWARDS_BASIC_V

APPS.GMS_PQH_AWARDS_V is not referenced by any database object

[top of page]

View: GMS_PQH_EXP_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_TYPE VARCHAR2 (30) Y
PROJECT_ID NUMBER (15) Y
TASK_ID NUMBER (15) Y
AWARD_ID NUMBER (15) Y
EXPND_TYP_START_DATE_ACTIVE DATE
Y
EXPND_TYP_END_DATE_ACTIVE DATE

ORG_ID NUMBER (15)

[top of page]

APPS.GMS_PQH_EXP_TYPES_V references the following:

APPS
SYNONYM - GMS_ALLOWABLE_EXPENDITURES
SYNONYM - GMS_AWARDS
VIEW - GMS_PROJECT_TYPES
SYNONYM - PA_TASKS
- PA_PROJECTS_ALL
- PA_EXPENDITURE_TYPES_EXPEND_V

APPS.GMS_PQH_EXP_TYPES_V is not referenced by any database object

[top of page]

View: GMS_PQH_PROJECTS_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
PROJECT_NUMBER VARCHAR2 (25) Y
PROJECT_NAME VARCHAR2 (30) Y
PROJECT_ID NUMBER (15) Y
PROJECT_CURRENCY_CODE VARCHAR2 (15) Y

[top of page]

APPS.GMS_PQH_PROJECTS_V references the following:

APPS
PACKAGE - FND_PROFILE
VIEW - GMS_PROJECTS_V
PACKAGE - PA_CROSS_BUSINESS_GRP
- PA_PROJECT_UTILS

APPS.GMS_PQH_PROJECTS_V is not referenced by any database object

[top of page]

View: GMS_PROJECTS_BASIC_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
PROJECT_ID NUMBER (15) Y
PROJECT_NUMBER VARCHAR2 (25) Y
PROJECT_NAME VARCHAR2 (30) Y
LONG_NAME VARCHAR2 (240)
PROJECT_TYPE_CLASS_CODE VARCHAR2 (30)
PROJECT_STATUS_CODE VARCHAR2 (30) Y
TEMPLATE_FLAG VARCHAR2 (1)
PM_PROJECT_REFERENCE VARCHAR2 (25)
PROJECT_NUMBER_SORT_ORDER VARCHAR2 (25) Y
PROJECT_CURRENCY_CODE VARCHAR2 (15) Y
CC_PRVDR_FLAG VARCHAR2 (1)
ORG_ID NUMBER (15)
OPERATING_UNIT VARCHAR2 (240) Y

[top of page]

APPS.GMS_PROJECTS_BASIC_V references the following:

APPS
PACKAGE - GMS_COMMON_PKG
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
PACKAGE - PA_SECURITY
- MO_GLOBAL
- PA_PROJECTS_BASIC_V

APPS.GMS_PROJECTS_BASIC_V is not referenced by any database object

[top of page]

View: GMS_PROJECTS_BURDEN_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
SEGMENT1 VARCHAR2 (25) Y
NAME VARCHAR2 (30) Y
DESCRIPTION VARCHAR2 (250)
PROJECT_ID NUMBER (15) Y
ORG_ID NUMBER (15)

[top of page]

APPS.GMS_PROJECTS_BURDEN_V references the following:

- GMS_PROJECT_TYPES
- PA_PROJECT_STUS_UTILS
- PA_PROJECTS

APPS.GMS_PROJECTS_BURDEN_V is not referenced by any database object

[top of page]

View: GMS_PROJECTS_EXPEND_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
PROJECT_ID NUMBER (15) Y Unique identifier for the project
PROJECT_NUMBER VARCHAR2 (25) Y User-defined or system-generated unique number for the project
PROJECT_NAME VARCHAR2 (30) Y Name for the project
START_DATE DATE

Start date for the project
COMPLETION_DATE DATE

Completion date for the project
PROJECT_TYPE_CLASS_CODE VARCHAR2 (30)
Classification code for the project. Possible values are INDIRECT, CAPITAL, or CONTRACT.
PROJECT_NUMBER_SORT_ORDER VARCHAR2 (25) Y Project number for the project
PROJECT_TYPE VARCHAR2 (20) Y Project type for the project
TASKS_PER_PROJ NUMBER

Number of tasks for the project
ORG_ID NUMBER (15)

[top of page]

APPS.GMS_PROJECTS_EXPEND_V references the following:

APPS
PACKAGE - FND_PROFILE
PACKAGE - PA_CROSS_BUSINESS_GRP
SYNONYM - PA_TASKS
- PA_PROJECT_TYPES
- PA_PROJECT_UTILS
- PA_PROJECTS_EXPEND_V

APPS.GMS_PROJECTS_EXPEND_V is not referenced by any database object

[top of page]

View: GMS_PROJECTS_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
PROJECT_ID NUMBER (15) Y
PROJECT_NUMBER VARCHAR2 (25) Y
PROJECT_NAME VARCHAR2 (30) Y
START_DATE DATE

COMPLETION_DATE DATE

PROJECT_CURRENCY_CODE VARCHAR2 (15) Y
PROJECT_OU NUMBER (15)
PROJECT_TYPE_CLASS_CODE VARCHAR2 (30)
PROJECT_DESCRIPTION VARCHAR2 (250)
PROJFUNC_CURRENCY_CODE VARCHAR2 (15)

[top of page]

APPS.GMS_PROJECTS_V references the following:

APPS
PACKAGE - FND_PROFILE
PACKAGE - PA_CROSS_BUSINESS_GRP
- PA_PROJECTS_EXPEND_V
- PA_PROJECT_UTILS
APPS.GMS_PROJECTS_V is referenced by following:

APPS
VIEW - GMS_PQH_PROJECTS_V

[top of page]

View: GMS_PROJECT_FUNDINGS_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)
GMS_PROJECT_FUNDING_ID NUMBER
Y
PROJECT_FUNDING_ID NUMBER

PROJECT_ID NUMBER
Y
PROJECT_NUMBER VARCHAR2 (25)
PROJECT_NAME VARCHAR2 (30)
TASK_ID NUMBER

TASK_NUMBER VARCHAR2 (25)
TASK_NAME VARCHAR2 (20)
INSTALLMENT_ID NUMBER
Y
FUNDING_AMOUNT NUMBER
Y
DATE_ALLOCATED DATE
Y
CREATED_BY_PERSON_NAME VARCHAR2 (0)
ALLOWABLE_FUNDING_LEVEL_CODE VARCHAR2 (30)
PROJECT_TYPE_CLASS_CODE VARCHAR2 (30)
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER
Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER
Y
LAST_UPDATE_LOGIN NUMBER
Y
INSTALLMENT_NUM VARCHAR2 (15)
AWARD_ID NUMBER (15)
ORG_ID NUMBER (15)

[top of page]

APPS.GMS_PROJECT_FUNDINGS_V references the following:

APPS
SYNONYM - GMS_INSTALLMENTS
SYNONYM - GMS_PROJECT_FUNDINGS
PACKAGE - PA_SECURITY
SYNONYM - PA_TASKS
- PA_PROJECT_TYPES
- PA_LOOKUPS
- PA_PROJECTS_ALL

APPS.GMS_PROJECT_FUNDINGS_V is not referenced by any database object

[top of page]

View: GMS_PROJECT_TYPES

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
PROJECT_TYPE VARCHAR2 (20) Y
DESCRIPTION VARCHAR2 (250)
PROJECT_TYPE_CLASS_CODE VARCHAR2 (30)
SPONSORED_FLAG VARCHAR2 (1)
ORG_ID NUMBER (15)

[top of page]

APPS.GMS_PROJECT_TYPES references the following:

- PA_PROJECT_TYPES
APPS.GMS_PROJECT_TYPES is referenced by following:

APPS
VIEW - GMS_PQH_EXP_TYPES_V

[top of page]

View: GMS_REFERENCE_NUMBERS_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
AWARD_ID 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
TYPE VARCHAR2 (30) Y
VALUE VARCHAR2 (30) Y
REQUIRED_FLAG VARCHAR2 (2)
TYPE_DIS VARCHAR2 (80) Y
ROW_ID ROWID (10)

[top of page]

APPS.GMS_REFERENCE_NUMBERS_V references the following:

APPS
SYNONYM - GMS_REFERENCE_NUMBERS
- GMS_LOOKUPS

APPS.GMS_REFERENCE_NUMBERS_V is not referenced by any database object

[top of page]

View: GMS_REPORTS_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
REPORT_ID NUMBER (15)
INSTALLMENT_ID NUMBER (15) Y
REPORT_TEMPLATE_ID NUMBER (15) Y
REPORT_NAME VARCHAR2 (60) Y
TYPE_DIS VARCHAR2 (80) Y
SITE_USE_ID NUMBER (15)
COPY_NUMBER NUMBER (15) Y
DUE_DATE DATE

DATE_FILED DATE

FILED_BY NUMBER (15)
FILED_BY_DIS 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
ROW_ID ROWID (10)

[top of page]

APPS.GMS_REPORTS_V references the following:

APPS
SYNONYM - GMS_REPORTS
SYNONYM - GMS_REPORT_TEMPLATES
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
SYNONYM - HZ_CUST_SITE_USES
- GMS_LOOKUPS
- PER_PEOPLE_X

APPS.GMS_REPORTS_V is not referenced by any database object

[top of page]

View: GMS_REPORT_TEMPLATES_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
TEMPLATE_ID NUMBER (15) Y
REPORT_NAME VARCHAR2 (60) Y
TYPE VARCHAR2 (30) Y
MEANING VARCHAR2 (80) Y
TRANSACTION_NUMBER NUMBER (15)
START_DATE_ACTIVE DATE

END_DATE_ACTIVE DATE

AGENCY_SPECIFIC_FORM VARCHAR2 (60)
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
ROW_ID ROWID (10)

[top of page]

APPS.GMS_REPORT_TEMPLATES_V references the following:

APPS
SYNONYM - GMS_REPORT_TEMPLATES
- GMS_LOOKUPS

APPS.GMS_REPORT_TEMPLATES_V is not referenced by any database object

[top of page]

View: GMS_RESG_BAL_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
PROJECT_ID NUMBER (15) Y
AWARD_ID NUMBER (15) Y
TASK_ID NUMBER (15) Y
BUDGET_VERSION_ID NUMBER (15) Y
PARENT_MEMBER_ID NUMBER


START_DATE DATE


END_DATE DATE


BUDGET NUMBER


ACTUALS NUMBER


ENCUMBRANCES NUMBER


[top of page]

APPS.GMS_RESG_BAL_V references the following:

APPS
SYNONYM - GMS_BALANCES
SYNONYM - PA_RESOURCE_LIST_MEMBERS

APPS.GMS_RESG_BAL_V is not referenced by any database object

[top of page]

View: GMS_RESG_BC_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
PROJECT_ID NUMBER (15) Y
AWARD_ID NUMBER (15) Y
TASK_ID NUMBER (15) Y
RESOURCE_LIST_MEMBER_ID NUMBER (15)

BUDGET_VERSION_ID NUMBER (15)

PARENT_MEMBER_ID NUMBER


EXPENDITURE_ITEM_DATE DATE
Y
TOP_TASK_ID NUMBER (15)

STATUS_CODE VARCHAR2 (1) Y
RESULT_CODE VARCHAR2 (3)

ACTUAL_FLAG VARCHAR2 (1) Y
ENTERED_DR NUMBER


ENTERED_CR NUMBER


[top of page]

APPS.GMS_RESG_BC_V references the following:

APPS
SYNONYM - GMS_BC_PACKETS
SYNONYM - PA_RESOURCE_LIST_MEMBERS

APPS.GMS_RESG_BC_V is not referenced by any database object

[top of page]

View: GMS_RESG_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
PROJECT_ID NUMBER (15)

AWARD_ID NUMBER (15)

TASK_ID NUMBER


TASK VARCHAR2 (4000)
BUDGET_VERSION_ID NUMBER (15)

PARENT_MEMBER_ID NUMBER


RESOURCE_GROUP_NAME VARCHAR2 (240)
TOP_TASK_ID NUMBER


START_DATE DATE


END_DATE DATE


BUDGET NUMBER


ACTUALS NUMBER


ENCUMBRANCES NUMBER


[top of page]

APPS.GMS_RESG_V references the following:

APPS
PACKAGE - FND_PROFILE
PACKAGE - GMS_BUDGET_UTILS
SYNONYM - GMS_BUDGET_VERSIONS
SYNONYM - PA_BUDGET_ENTRY_METHODS
PACKAGE - PA_CROSS_BUSINESS_GRP
SYNONYM - PA_RESOURCES
SYNONYM - PA_RESOURCE_LIST_MEMBERS
- PA_RESOURCE_LISTS
- GMS_AWARD_BAL_V

APPS.GMS_RESG_V is not referenced by any database object

[top of page]

View: GMS_RES_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
PROJECT_ID NUMBER (15)

AWARD_ID NUMBER (15)

TASK_ID NUMBER


TASK VARCHAR2 (4000)
RESOURCE_LIST_MEMBER_ID NUMBER (15)

RESOURCE_NAME VARCHAR2 (240)
BUDGET_VERSION_ID NUMBER (15)

PARENT_MEMBER_ID NUMBER


TOP_TASK_ID NUMBER


START_DATE DATE


END_DATE DATE


BUDGET NUMBER


ACTUALS NUMBER


ENCUMBRANCES NUMBER


[top of page]

APPS.GMS_RES_V references the following:

APPS
PACKAGE - FND_PROFILE
VIEW - GMS_AWARD_BAL_V
PACKAGE - GMS_BUDGET_UTILS
SYNONYM - GMS_BUDGET_VERSIONS
SYNONYM - PA_BUDGET_ENTRY_METHODS
PACKAGE - PA_CROSS_BUSINESS_GRP
SYNONYM - PA_RESOURCES
SYNONYM - PA_RESOURCE_LIST_MEMBERS
- PA_RESOURCE_LISTS

APPS.GMS_RES_V is not referenced by any database object

[top of page]

View: GMS_SSA_AWARDS_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
AWARD_ID NUMBER (15) Y
AWARD_NUMBER VARCHAR2 (15) Y
AWARD_SHORT_NAME VARCHAR2 (30) Y
AWARD_ORGANIZATION_ID NUMBER (15)
AWARD_ORGANIZATION_NAME VARCHAR2 (240) Y
START_DATE DATE

END_DATE DATE

CLOSE_DATE DATE

PROJECT_ID NUMBER
Y
PROJECT_NUMBER VARCHAR2 (25) Y
TASK_ID NUMBER (15) Y
TASK_NUMBER VARCHAR2 (25) Y
ORG_ID NUMBER (15)

[top of page]

APPS.GMS_SSA_AWARDS_V references the following:

APPS
SYNONYM - GMS_AWARDS
SYNONYM - GMS_BUDGET_VERSIONS
SYNONYM - GMS_INSTALLMENTS
SYNONYM - GMS_SUMMARY_PROJECT_FUNDINGS
PACKAGE - HR_GENERAL
VIEW - HR_ORGANIZATION_UNITS
PACKAGE - HR_SECURITY
SYNONYM - PA_PROJECTS_ALL
SYNONYM - PA_TASKS
APPS.GMS_SSA_AWARDS_V is referenced by following:

APPS
VIEW - AP_WEB_PA_PROJECTS_TASKS_V
VIEW - ICX_AP_EXPENSE_LINES_V

[top of page]

View: GMS_SSA_AWARD_EXPTYPE_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
AWARD_ID NUMBER (15) Y
AWARD_NUMBER VARCHAR2 (15) Y
ALLOWABLE_SCHEDULE_ID NUMBER (15)
EXPENDITURE_TYPE VARCHAR2 (30) Y
ORG_ID NUMBER (15)

[top of page]

APPS.GMS_SSA_AWARD_EXPTYPE_V references the following:

APPS
SYNONYM - GMS_ALLOWABLE_EXPENDITURES
SYNONYM - GMS_AWARDS

APPS.GMS_SSA_AWARD_EXPTYPE_V is not referenced by any database object

[top of page]

View: GMS_STATUS_ACCUM_PROJECT_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
AWARD_ID NUMBER (15)
PROJECT_ID NUMBER (15)
PROJECT_NUMBER VARCHAR2 (25)
PROJECT_NAME VARCHAR2 (30)
TOTAL_REVENUE NUMBER

BUDGET_AMOUNT NUMBER

ACTUAL_COST NUMBER

REQUISITION_AMOUNT NUMBER

PURCHASE_ORDER_AMOUNT NUMBER

SUPPLIER_INVOICE_AMOUNT NUMBER

MANUAL_ENCUMBRANCE_AMOUNT NUMBER

[top of page]

APPS.GMS_STATUS_ACCUM_PROJECT_V references the following:

APPS
VIEW - GMS_STATUS_ACCUM_PROJ_BASE_V

APPS.GMS_STATUS_ACCUM_PROJECT_V is not referenced by any database object

[top of page]

View: GMS_STATUS_ACCUM_PROJ_BASE_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)
PROJECT_ID NUMBER (15)
PROJECT_NUMBER VARCHAR2 (25)
PROJECT_NAME VARCHAR2 (30)
TOTAL_REVENUE NUMBER

BUDGET_AMOUNT NUMBER

ACTUAL_COST NUMBER

REQUISITION_AMOUNT NUMBER

PURCHASE_ORDER_AMOUNT NUMBER

SUPPLIER_INVOICE_AMOUNT NUMBER

MANUAL_ENCUMBRANCE_AMOUNT NUMBER

[top of page]

APPS.GMS_STATUS_ACCUM_PROJ_BASE_V references the following:

APPS
SYNONYM - GMS_AWARDS_ALL
SYNONYM - GMS_BALANCES
SYNONYM - GMS_BC_PACKETS
SYNONYM - GMS_BUDGET_VERSIONS
SYNONYM - GMS_EVENT_ATTRIBUTE
SYNONYM - PA_EVENTS
- PA_PROJECTS_ALL
APPS.GMS_STATUS_ACCUM_PROJ_BASE_V is referenced by following:

APPS
VIEW - GMS_STATUS_ACCUM_PROJECT_V

[top of page]

View: GMS_STATUS_ACCUM_TASK_BASE_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)
PROJECT_ID NUMBER (15)
TASK_ID NUMBER (15)
TASK_NUMBER VARCHAR2 (25)
TASK_NAME VARCHAR2 (20)
TOTAL_REVENUE NUMBER

BUDGET_AMOUNT NUMBER

ACTUAL_COST NUMBER

REQUISITION_AMOUNT NUMBER

PURCHASE_ORDER_AMOUNT NUMBER

SUPPLIER_INVOICE_AMOUNT NUMBER

MANUAL_ENCUMBRANCE_AMOUNT NUMBER

[top of page]

APPS.GMS_STATUS_ACCUM_TASK_BASE_V references the following:

APPS
SYNONYM - GMS_BALANCES
SYNONYM - GMS_BC_PACKETS
SYNONYM - GMS_BUDGET_VERSIONS
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
PACKAGE - PA_TASK_UTILS
- PA_TASKS_V

APPS.GMS_STATUS_ACCUM_TASK_BASE_V is not referenced by any database object

[top of page]

View: GMS_STATUS_ACTUALS_BASE1_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
AWARD_ID NUMBER (15)
PROJECT_ID NUMBER (15)
TASK_ID NUMBER (15)
EXPENDITURE_ITEM_ID NUMBER (15)
REVENUE_AMOUNT NUMBER

BILLED_AMOUNT NUMBER

RAW_COST NUMBER

BURDENED_COST NUMBER

PA_DATE DATE

GL_DATE DATE

INVOICE_ID NUMBER

[top of page]

APPS.GMS_STATUS_ACTUALS_BASE1_V references the following:

APPS
SYNONYM - GMS_AWARD_DISTRIBUTIONS
SYNONYM - GMS_BURDEN_COMPONENTS
- PA_COST_DISTRIBUTION_LINES_ALL
APPS.GMS_STATUS_ACTUALS_BASE1_V is referenced by following:

APPS
VIEW - GMS_STATUS_ACTUALS_BASE2_V
VIEW - GMS_STATUS_ACTUALS_V

[top of page]

View: GMS_STATUS_ACTUALS_BASE2_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
AWARD_ID NUMBER (15)
PROJECT_ID NUMBER (15)
TASK_ID NUMBER (15)
EXPENDITURE_ITEM_ID NUMBER (15)
REVENUE_AMOUNT NUMBER

BILLED_AMOUNT NUMBER

RAW_COST NUMBER

BURDENED_COST NUMBER

INVOICE_ID VARCHAR2 (0)
PA_DATE VARCHAR2 (0)

[top of page]

APPS.GMS_STATUS_ACTUALS_BASE2_V references the following:

APPS
VIEW - GMS_STATUS_ACTUALS_BASE1_V

APPS.GMS_STATUS_ACTUALS_BASE2_V is not referenced by any database object

[top of page]

View: GMS_STATUS_ACTUALS_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
AWARD_ID NUMBER (15)
PROJECT_ID NUMBER (15)
PROJECT_NUMBER VARCHAR2 (25) Y
PROJECT_NAME VARCHAR2 (30) Y
TASK_ID NUMBER (15)
TASK_NUMBER VARCHAR2 (25) Y
TASK_NAME VARCHAR2 (20) Y
EXPENDITURE_ITEM_ID NUMBER (15)
EXPENDITURE_TYPE VARCHAR2 (30) Y
EXPENDITURE_ITEM_DATE DATE
Y
EXPENDITURE_GROUP VARCHAR2 (240) Y
QUANTITY NUMBER

UNIT_OF_MEASURE VARCHAR2 (80) Y
NON_LABOR_RESOURCE VARCHAR2 (20)
TRANSACTION_SOURCE VARCHAR2 (80)
ORIGINAL_TRANSACTION_REFERENCE VARCHAR2 (50)
RAW_COST NUMBER

BURDENED_COST NUMBER

REVENUE_AMOUNT NUMBER

BILLED_AMOUNT NUMBER

SUPPLIER_INVOICE_NUM VARCHAR2 (50)
INCURRED_BY_PERSON_ID NUMBER (15)
PA_PERIOD VARCHAR2 (20) Y --PERIOD_NAME,
PA_DATE DATE

GL_DATE DATE

EXPENDITURE_ORGANIZATION VARCHAR2 (240) Y
NON_LABOR_RESOURCE_ORG VARCHAR2 (240)
ORG_ID NUMBER (15)

[top of page]

APPS.GMS_STATUS_ACTUALS_V references the following:

APPS
SYNONYM - AP_INVOICES_ALL
VIEW - GMS_STATUS_ACTUALS_BASE1_V
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
SYNONYM - PA_EXPENDITURE_TYPES
SYNONYM - PA_TASKS
SYNONYM - PA_TRANSACTION_SOURCES
- PA_LOOKUPS
- HR_ORGANIZATION_UNITS
- PA_PERIODS
- PA_PROJECTS_ALL
- PA_EXPENDITURES_ALL
- PA_EXPENDITURE_ITEMS_ALL

APPS.GMS_STATUS_ACTUALS_V is not referenced by any database object

[top of page]

View: GMS_STATUS_AWARD_ACCUM_BASE_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
AWARD_ID NUMBER (15)
AWARD_NUMBER VARCHAR2 (15)
AWARD_SHORT_NAME VARCHAR2 (30)
STATUS VARCHAR2 (30)
TOTAL_REVENUE NUMBER

BUDGET_AMOUNT NUMBER

ACTUAL_COST NUMBER

REQUISITION_AMOUNT NUMBER

PURCHASE_ORDER_AMOUNT NUMBER

SUPPLIER_INVOICE_AMOUNT NUMBER

MANUAL_ENCUMBRANCE_AMOUNT NUMBER

TYPE VARCHAR2 (30)
FUNDING_SOURCE_ID NUMBER (15)
AWARD_ORGANIZATION_ID NUMBER (15)
ORG_ID NUMBER (15)

[top of page]

APPS.GMS_STATUS_AWARD_ACCUM_BASE_V references the following:

APPS
SYNONYM - GMS_AWARDS
SYNONYM - GMS_BALANCES
SYNONYM - GMS_BC_PACKETS
SYNONYM - GMS_BUDGET_VERSIONS
SYNONYM - PA_EVENTS
APPS.GMS_STATUS_AWARD_ACCUM_BASE_V is referenced by following:

APPS
VIEW - GMS_STATUS_AWARD_ACCUM_V

[top of page]

View: GMS_STATUS_AWARD_ACCUM_TASK_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
AWARD_ID NUMBER (15)
PROJECT_ID NUMBER (15)
TASK_ID NUMBER (15)
TASK_NUMBER VARCHAR2 (25)
TASK_NAME VARCHAR2 (20)
TOTAL_REVENUE NUMBER

BUDGET_AMOUNT NUMBER

ACTUAL_COST NUMBER

REQUISITION_AMOUNT NUMBER

PURCHASE_ORDER_AMOUNT NUMBER

SUPPLIER_INVOICE_AMOUNT NUMBER

MANUAL_ENCUMBRANCE_AMOUNT NUMBER

[top of page]

APPS.GMS_STATUS_AWARD_ACCUM_TASK_V references the following:

APPS
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
PACKAGE - PA_TASK_UTILS
- GMS_STATUS_ACCUM_TASK_BASE_V

APPS.GMS_STATUS_AWARD_ACCUM_TASK_V is not referenced by any database object

[top of page]

View: GMS_STATUS_AWARD_ACCUM_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
AWARD_ID NUMBER (15)
AWARD_NUMBER VARCHAR2 (15)
AWARD_SHORT_NAME VARCHAR2 (30)
STATUS VARCHAR2 (30)
TOTAL_REVENUE NUMBER

BUDGET_AMOUNT NUMBER

ACTUAL_COST NUMBER

COMMITMENT_AMOUNT NUMBER

REQUISITION_AMOUNT NUMBER

PURCHASE_ORDER_AMOUNT NUMBER

SUPPLIER_INVOICE_AMOUNT NUMBER

MANUAL_ENCUMBRANCE_AMOUNT NUMBER

AWARD_TYPE VARCHAR2 (30)
FUNDING_SOURCE_ID NUMBER (15)
AWARD_ORGANIZATION_ID NUMBER (15)

[top of page]

APPS.GMS_STATUS_AWARD_ACCUM_V references the following:

APPS
VIEW - GMS_STATUS_AWARD_ACCUM_BASE_V

APPS.GMS_STATUS_AWARD_ACCUM_V is not referenced by any database object

[top of page]

View: GMS_STATUS_COMMITMENTS_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
AWARD_ID NUMBER (15)
PROJECT_ID NUMBER

PROJECT_NUMBER VARCHAR2 (25) Y
PROJECT_NAME VARCHAR2 (30) Y
TASK_ID NUMBER

TASK_NUMBER VARCHAR2 (25) Y
TASK_NAME VARCHAR2 (20) Y
DOCUMENT_TYPE VARCHAR2 (3)
EXPENDITURE_TYPE VARCHAR2 (30)
EXPENDITURE_ITEM_DATE DATE

EXPENDITURE_ORGANIZATION VARCHAR2 (240) Y
COMMITMENT_NUMBER VARCHAR2 (50)
DESCRIPTION VARCHAR2 (240)
QUANTITY NUMBER

UNIT_OF_MEASURE VARCHAR2 (25)
SUPPLIER_NAME VARCHAR2 (240)
TRANSACTION_SOURCE VARCHAR2 (80)
RAW_COST NUMBER

BURDENED_COST NUMBER

PA_PERIOD VARCHAR2 (20) Y
ORG_ID NUMBER (15)
GL_DATE DATE

[top of page]

APPS.GMS_STATUS_COMMITMENTS_V references the following:

APPS
PACKAGE - GMS_BUDGET_BALANCE
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
PACKAGE - PA_CMT_UTILS
PACKAGE - PA_CURRENCY
SYNONYM - PA_TASKS
PACKAGE - PO_INTG_DOCUMENT_FUNDS_GRP
- PA_PROJECTS_ALL
- HR_ORGANIZATION_UNITS
- GMS_COMMITMENT_BURDEN_V
- PA_PERIODS

APPS.GMS_STATUS_COMMITMENTS_V is not referenced by any database object

[top of page]

View: GMS_STATUS_PROJ_GENERIC_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
PROJECT_ID NUMBER (15) Y
VIEW_LABOR_COSTS_ALLOWED VARCHAR2 (1)
COST_BUDGET_TYPE_CODE VARCHAR2 (4000)
REV_BUDGET_TYPE_CODE VARCHAR2 (4000)
COLUMN1 VARCHAR2 (25) Y
COLUMN2 VARCHAR2 (30) Y
COLUMN3 VARCHAR2 (1)
COLUMN4 NUMBER

COLUMN5 NUMBER

COLUMN6 NUMBER

COLUMN7 NUMBER

COLUMN8 NUMBER

COLUMN9 NUMBER

COLUMN10 NUMBER

COLUMN11 NUMBER

COLUMN12 NUMBER

COLUMN13 NUMBER

COLUMN14 NUMBER

COLUMN15 NUMBER

COLUMN16 NUMBER

COLUMN17 NUMBER

COLUMN18 NUMBER

COLUMN19 NUMBER

COLUMN20 NUMBER

COLUMN21 NUMBER

COLUMN22 NUMBER

COLUMN23 NUMBER

COLUMN24 NUMBER

COLUMN25 NUMBER

COLUMN26 NUMBER

COLUMN27 NUMBER

COLUMN28 NUMBER

COLUMN29 NUMBER

COLUMN30 NUMBER

COLUMN31 NUMBER

COLUMN32 NUMBER

COLUMN33 NUMBER

[top of page]

APPS.GMS_STATUS_PROJ_GENERIC_V references the following:

APPS
PACKAGE - PA_SECURITY
PACKAGE - PA_STATUS
- PA_STATUS_PROJ_GENERIC_V
- PA_PROJECTS

APPS.GMS_STATUS_PROJ_GENERIC_V is not referenced by any database object

[top of page]

View: GMS_STATUS_RESOURCES_BASE_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)
PROJECT_ID NUMBER (15)
PROJECT_NAME VARCHAR2 (30)
PROJECT_NUMBER VARCHAR2 (25)
RESOURCE_ID NUMBER (15)
RESOURCE_NAME VARCHAR2 (240)
RESOURCE_LIST_MEMBER_ID NUMBER (15)
RESOURCE_LIST_ID NUMBER (15)
TOTAL_REVENUE NUMBER

BUDGET_AMOUNT NUMBER

ACTUAL_COST NUMBER

REQUISITION_AMOUNT NUMBER

PURCHASE_ORDER_AMOUNT NUMBER

SUPPLIER_INVOICE_AMOUNT NUMBER

MANUAL_ENCUMBRANCE_AMOUNT NUMBER

START_DATE DATE

END_DATE DATE

[top of page]

APPS.GMS_STATUS_RESOURCES_BASE_V references the following:

APPS
SYNONYM - GMS_BALANCES
SYNONYM - GMS_BC_PACKETS
SYNONYM - GMS_BUDGET_VERSIONS
SYNONYM - PA_RESOURCES
SYNONYM - PA_RESOURCE_LISTS_ALL_BG
SYNONYM - PA_RESOURCE_LIST_MEMBERS
- PA_PROJECTS_ALL

APPS.GMS_STATUS_RESOURCES_BASE_V is not referenced by any database object

[top of page]

View: GMS_STATUS_RESOURCES_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
AWARD_ID NUMBER (15)
PROJECT_ID NUMBER (15)
PROJECT_NAME VARCHAR2 (30)
PROJECT_NUMBER VARCHAR2 (25)
RESOURCE_ID NUMBER (15)
RESOURCE_NAME VARCHAR2 (240)
RESOURCE_LIST_MEMBER_ID NUMBER (15)
RESOURCE_LIST_ID NUMBER (15)
TOTAL_REVENUE NUMBER

BUDGET_AMOUNT NUMBER

ACTUAL_COST NUMBER

REQUISITION_AMOUNT NUMBER

PURCHASE_ORDER_AMOUNT NUMBER

SUPPLIER_INVOICE_AMOUNT NUMBER

MANUAL_ENCUMBRANCE_AMOUNT NUMBER

START_DATE DATE

END_DATE DATE

[top of page]

APPS.GMS_STATUS_RESOURCES_V references the following:

- GMS_STATUS_RESOURCES_BASE_V

APPS.GMS_STATUS_RESOURCES_V is not referenced by any database object

[top of page]

View: GMS_SUM_PRJ_FUNDINGS_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)
PROJECT_ID NUMBER
Y
PROJECT_NUMBER VARCHAR2 (80)
PROJECT_NAME VARCHAR2 (80)
TASK_ID NUMBER

TASK_NUMBER VARCHAR2 (80)
TASK_NAME VARCHAR2 (80)
INSTALLMENT_ID NUMBER
Y
INSTALLMENT_NUM VARCHAR2 (15)
TOTAL_FUNDING_AMOUNT NUMBER
Y
TOTAL_REVENUE_AMOUNT NUMBER (22)
TOTAL_BILLED_AMOUNT NUMBER

AGREEMENT_ID NUMBER (15)
AWARD_ID NUMBER (15) Y
AWARD_NUMBER VARCHAR2 (15) Y
AWARD_SHORT_NAME VARCHAR2 (30) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER
Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER
Y
LAST_UPDATE_LOGIN NUMBER
Y
ORG_ID NUMBER (15)

[top of page]

APPS.GMS_SUM_PRJ_FUNDINGS_V references the following:

APPS
SYNONYM - GMS_INSTALLMENTS
PACKAGE - GMS_SECURITY
SYNONYM - GMS_SUMMARY_PROJECT_FUNDINGS
PACKAGE - PA_SECURITY
SYNONYM - PA_TASKS
SYS
TABLE - DUAL
- PA_LOOKUPS
- GMS_AWARDS
- PA_PROJECTS_ALL

APPS.GMS_SUM_PRJ_FUNDINGS_V is not referenced by any database object

[top of page]

View: GMS_TASK_BAL_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
PROJECT_ID NUMBER (15)

AWARD_ID NUMBER (15)

TOP_TASK_ID NUMBER


TOP_TASK_NUMBER VARCHAR2 (4000)
User-defined short name of the task
BUDGET_VERSION_ID NUMBER (15)

START_DATE DATE


END_DATE DATE


BUDGET NUMBER


ACTUALS NUMBER


ENCUMBRANCES NUMBER


[top of page]

APPS.GMS_TASK_BAL_V references the following:

APPS
PACKAGE - GMS_BUDGET_UTILS
- GMS_AWARD_BAL_V

APPS.GMS_TASK_BAL_V is not referenced by any database object

[top of page]

View: GMS_TASK_BUDGETS2_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
BUDGET_VERSION_ID NUMBER (15)
PROJECT_ID NUMBER (15)
AWARD_ID NUMBER (15)
BUDGET_TYPE_CODE VARCHAR2 (30)
VERSION_NUMBER NUMBER (15)
BUDGET_STATUS_CODE VARCHAR2 (30)
TASK_ID NUMBER

TASK_NUMBER VARCHAR2 (25)
TASK_NAME VARCHAR2 (20)
PARENT_TASK_ID NUMBER

RAW_COST_TOTAL NUMBER

BURDENED_COST_TOTAL NUMBER

REVENUE_TOTAL NUMBER

QUANTITY_TOTAL NUMBER

[top of page]

APPS.GMS_TASK_BUDGETS2_V references the following:

APPS
SYNONYM - GMS_BUDGET_LINES
PACKAGE - GMS_BUDGET_UTILS
SYNONYM - GMS_BUDGET_VERSIONS
SYNONYM - GMS_RESOURCE_ASSIGNMENTS
SYNONYM - PA_TASKS
APPS.GMS_TASK_BUDGETS2_V is referenced by following:

APPS
VIEW - GMS_TASK_BUDGETS_V

[top of page]

View: GMS_TASK_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
BUDGET_VERSION_ID NUMBER (15)

PROJECT_ID NUMBER (15)

AWARD_ID NUMBER (15)

BUDGET_TYPE_CODE VARCHAR2 (30)

VERSION_NUMBER NUMBER (15)

BUDGET_STATUS_CODE VARCHAR2 (30)

TASK_ID NUMBER


TASK_NUMBER VARCHAR2 (25)

TASK_NAME VARCHAR2 (20)

PARENT_TASK_ID NUMBER


SORT_ORDER VARCHAR2 (4000)

RAW_COST_TOTAL NUMBER


BURDENED_COST_TOTAL NUMBER


REVENUE_TOTAL NUMBER


QUANTITY_TOTAL NUMBER


[top of page]

APPS.GMS_TASK_BUDGETS_V references the following:

APPS
PACKAGE - GMS_BUDGET_UTILS
VIEW - GMS_TASK_BUDGETS2_V
PACKAGE - PA_TASK_UTILS

APPS.GMS_TASK_BUDGETS_V is not referenced by any database object

[top of page]

View: GMS_TASK_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
PROJECT_ID NUMBER (15)

AWARD_ID NUMBER (15)

TASK_ID NUMBER


TASK_NUMBER VARCHAR2 (4000)
User-defined short name of the task
BUDGET_VERSION_ID NUMBER (15)

START_DATE DATE


END_DATE DATE


BUDGET NUMBER


ACTUALS NUMBER


ENCUMBRANCES NUMBER


[top of page]

APPS.GMS_TASK_V references the following:

APPS
PACKAGE - GMS_BUDGET_UTILS
- GMS_AWARD_BAL_V

APPS.GMS_TASK_V is not referenced by any database object

[top of page]

View: GMS_TERMS_CONDITIONS_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
AWARD_ID NUMBER (15) Y
TERM_ID NUMBER (15) Y
CATEGORY_ID NUMBER (15) Y
CATEGORY_DIS VARCHAR2 (30) Y
TERM_NAME VARCHAR2 (30) Y
DESCRIPTION VARCHAR2 (240)
OPERAND VARCHAR2 (30)
VALUE 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
ROW_ID ROWID (10)

[top of page]

APPS.GMS_TERMS_CONDITIONS_V references the following:

APPS
SYNONYM - GMS_AWARDS_TERMS_CONDITIONS
SYNONYM - GMS_TC_CATEGORIES
SYNONYM - GMS_TERMS_CONDITIONS

APPS.GMS_TERMS_CONDITIONS_V is not referenced by any database object

[top of page]

View: GMS_XLA_AWARD_REF_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_SET_ID NUMBER (15) Y System generated number for a distribution set
AWARD_ID NUMBER (15) Y Unique identifier for an award. Primary key.
AWARD_NUMBER VARCHAR2 (15) Y Number input by user to identify the award
AWARD_SHORT_NAME VARCHAR2 (30) Y Award short name
AWARD_ORGANIZATION_ID NUMBER (15)
Award organization identifier
AWARD_TYPE VARCHAR2 (30)
DOCUMENT_TYPE VARCHAR2 (3) Y
EXPENDITURE_ITEM_ID NUMBER (15)
PO_DISTRIBUTION_ID NUMBER (15)
REQ_DISTRIBUTION_ID NUMBER (15)
INVOICE_DISTRIBUTION_ID NUMBER (15)
AWARD_PURPOSE_CODE VARCHAR2 (30)
AWARD_ATTRIBUTE_CATEGORY VARCHAR2 (30)
AWARD_ATTRIBUTE1 VARCHAR2 (150)
AWARD_ATTRIBUTE2 VARCHAR2 (150)
AWARD_ATTRIBUTE3 VARCHAR2 (150)
AWARD_ATTRIBUTE4 VARCHAR2 (150)
AWARD_ATTRIBUTE5 VARCHAR2 (150)
AWARD_ATTRIBUTE6 VARCHAR2 (150)
AWARD_ATTRIBUTE7 VARCHAR2 (150)
AWARD_ATTRIBUTE8 VARCHAR2 (150)
AWARD_ATTRIBUTE9 VARCHAR2 (150)
AWARD_ATTRIBUTE10 VARCHAR2 (150)
AWARD_ATTRIBUTE11 VARCHAR2 (150)
AWARD_ATTRIBUTE12 VARCHAR2 (150)
AWARD_ATTRIBUTE13 VARCHAR2 (150)
AWARD_ATTRIBUTE14 VARCHAR2 (150)
AWARD_ATTRIBUTE15 VARCHAR2 (150)

[top of page]

APPS.GMS_XLA_AWARD_REF_V references the following:

APPS
SYNONYM - GMS_AWARDS_ALL
SYNONYM - GMS_AWARD_DISTRIBUTIONS

APPS.GMS_XLA_AWARD_REF_V is not referenced by any database object

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