GMS Tables (51)
GMS - Grants Accounting — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.
| Table | Columns | Description |
|---|---|---|
GMS_269_HISTORY |
43 | Financial status report for an award |
GMS_270_HISTORY |
23 | Financial status report for an award |
GMS_272_HISTORY |
30 | Federal cash transaction report |
GMS_ALLOWABILITY_SCHEDULES |
10 | Cost allowability schedules |
GMS_ALLOWABLE_EXPENDITURES |
10 | Allowable expenditures of cost allowability schedule |
GMS_AWARDS_ALL |
85 | Information about awards |
GMS_AWARDS_CONTACTS |
10 | Contacts of award |
GMS_AWARDS_TERMS_CONDITIONS |
10 | Terms and conditions of award |
GMS_AWARD_DISTRIBUTIONS |
48 | Distribution lines for requisitions, purchase orders, invoices, encumbrances, and Project expenditures charged to awards |
GMS_AWARD_EXP_TYPE_ACT_COST |
16 | Actual expense incurred for an award by expenditure type |
GMS_BALANCES |
21 | Balance of budgets, actual costs, and encumbrance costs |
GMS_BC_PACKETS |
138 | Budgetary control packets for funds checking |
GMS_BC_PACKETS_BVID |
3 | This is a temporary summary table used in the funds check process to store distinct budget versions present in current packets. After the |
GMS_BC_PACKETS_SUMMARY |
14 | This is a temporary summary table used in the funds check process to store actual and encumbrance amounts for current and previous packets. |
GMS_BC_PACKET_ARRIVAL_ORDER |
4 | This table stores the execution order for the packets. This table is populated during the funds check process, and the records are deleted o |
GMS_BILLING_CANCELLATIONS |
14 | Journal of deleted billing event distributions for deleted, cancelled revenue, or invoices |
GMS_BILLING_FORMS |
26 | Implementation-defined billing forms |
GMS_BUDGETARY_CONTROLS |
13 | Budgetary control level for awards, tasks, resource groups, and resources |
GMS_BUDGET_LINES |
37 | Detail lines of project and task budgets |
GMS_BUDGET_VERSIONS |
51 | Versions of award budgets |
GMS_BURDEN_ADJUSTMENTS_LOG |
20 | Journal of burdenable raw cost adjustments |
GMS_BURDEN_COMPONENTS |
19 | Burden components of billing events |
GMS_CONCURRENCY_CONTROL |
8 | Control table for concurrency control of transactions in Grants Accounting concurrent processes |
GMS_DEFAULT_REPORTS |
32 | Default reports of award |
GMS_DISTRIBUTIONS |
20 | Header information |
GMS_DISTRIBUTION_DETAILS |
24 | Details of distribution lines |
GMS_ENCUMBRANCES_ALL |
47 | Groups of encumbrance items incurred by employees or organizations in an encumbrance batch |
GMS_ENCUMBRANCE_GROUPS_ALL |
18 | Groups of pre-approved encumbrances |
GMS_ENCUMBRANCE_ITEMS_ALL |
60 | Manual encumbrance charged to sponsored projects |
GMS_EVENT_ATTRIBUTE |
20 | Additional information on billing events for mapping billing event information maintained in PA_EVENTS table |
GMS_EVENT_INTERSECT |
13 | Relationship between expenditure items and events |
GMS_FP_DISTRIBUTIONS |
9 | Stores the funding pattern distribution details for a defined funding pattern |
GMS_FUNDING_PATTERNS_ALL |
16 | Rule definition for charging transactions of a sponsored project to funding awards |
GMS_IMPLEMENTATIONS_ALL |
13 | Implementation options for award numbering method setup |
GMS_IND_COST_CODES |
2 | Additional information related to indirect cost codes maintained in PA_IND_COST_CODES |
GMS_INSTALLMENTS |
35 | Information about installments |
GMS_NOTIFICATIONS |
3 | Record of notifications sent to users about award events |
GMS_OVERRIDE_SCHEDULES |
10 | Information about Indirect Cost Rate Override Schedules defined on an award |
GMS_PERSONNEL |
12 | Personnel of award |
GMS_PROJECT_FUNDINGS |
12 | Incremental amounts of allocated funds from installments to project and tasks |
GMS_PROJECT_TYPES_ALL |
2 | Additional information on project types maintained in PA_PROJECT_TYPES |
GMS_REFERENCE_NUMBERS |
9 | Reference numbers of award |
GMS_REPORTS |
29 | Reports of installment |
GMS_REPORT_TEMPLATES |
29 | Implementation-defined report templates |
GMS_RESOURCE_ASSIGNMENTS |
12 | Resource assignments for a budget version at a branch of project's work breakdown |
GMS_SUMMARY_PROJECT_FUNDINGS |
12 | Summary funding amounts allocated from installment to project and tasks |
GMS_TC_CATEGORIES |
7 | Implementation-defined terms and conditions categories |
GMS_TERMS_CONDITIONS |
11 | Implementation-defined terms and conditions |
GMS_TRANSACTION_INTERFACE_ALL |
23 | Extension to PA_TRANSACTION_INTERFACE_ALL to maintain additional information |
GMS_UNIQUE_IDENTIFIER_CONTROL |
7 | Next award number for automatic award numbering |
GMS_WF_PROCESSES |
11 | Versions of award and budget workflows. There can be many workflows for an award or budget. |