Reporting View | Description | Key & Frequency | Recommended Search Columns |
| ACCOUNT_ATTRIBUTES
| Contains a list of all the set codes, attribute types, attribute values, and attribute values begin and end date associated with an account.One row per chart of accounts per account code per attribute type per attribute value per set code.VALUE CHART_OF_ACCOUNTS, ACCOUNT, ATTRIBUTE_TYPE, ATTRIBUTE_VALUE ATTRIBUTE_TYPE, ATTRIBUTE_VALUE, CHART_OF_ACCOUNTS | | |
ACCOUNT_HIERARCHY
| Contains a list of all general ledger and operating ledger accounts with associated hierarchy levels, account type, internal account type, account class and account pool. Used to support roll up reporting.One row per chart of accounts per account.CHART_OF_ACCOUNTS, ACCOUNT | | |
ACCOUNT_HIERARCHY_FISCAL
| Contains a list of all general ledger and operating ledger accounts with associated hierarchy levels, account type, internal account type, account class and account pool. Used to support roll up reporting by fiscal year and fiscal period.One row per chart of accounts per account per fiscal year per fiscal period.CHART_OF_ACCOUNTS, FISCAL_YEAR, FISCAL_PERIOD, ACCOUNT | | |
ACCOUNT_INDEX
| Contains a list of all account index codes with their associated chart of accounts, effective dates, next change dates, fund codes, organization codes, account codes, program codes, activity codes, location codes, and override indicators.One row per chart of accounts per account index per effective date per next change date.CHART_OF_ACCOUNTS, ACCOUNT_INDEX, EFFECTIVE_DATE CHART_OF_ACCOUNTS, ORGANIZATION_CODE CHART_OF_ACCOUNTS, PROGRAM CHART_OF_ACCOUNTS, FUND CHART_OF_ACCOUNTS, LOCATION | | |
ACCOUNT_TYPE_ATTRIBUTES
| Contains a list of all the set codes, attribute types, attribute values, and attribute values begin and end date, associated with an account type code.One row per chart of accounts per account type code per attribute type per attribute value per set code.VALUE CHART_OF_ACCOUNTS, ACCOUNT_TYPE, ATTRIBUTE_TYPE, ATTRIBUTE_VALUE ATTRIBUTE_TYPE, ATTRIBUTE_VALUE, CHART_OF_ACCOUNTS | | |
ACTIVITY_ATTRIBUTES
| Contains a list of all the set codes, attribute types, attribute values, and attribute values begin and end date associated with an activity code.One row per chart of accounts per activity code per attribute type per attribute value per set code.VALUE CHART_OF_ACCOUNTS, ACTIVITY, ATTRIBUTE_TYPE, ATTRIBUTE_VALUE ATTRIBUTE_TYPE, ATTRIBUTE_VALUE, CHART_OF_ACCOUNTS | | |
ATTRIBUTE_SETS
| Contains a list of all the set codes, attribute types, attribute values, and attribute values begin and end date associated with a chart of accounts code.One row per chart of accounts per set code per attribute type per attribute value.VALUE CHART_OF_ACCOUNTS, SET_CODE, ATTRIBUTE_TYPE, ATTRIBUTE_VALUE ATTRIBUTE_TYPE, ATTRIBUTE_VALUE, CHART_OF_ACCOUNTS | | |
BUDGET_AVAILABILITY_LEDGER
| Contains summary and current amounts for adopted budget, budget adjustments, encumbrances, budget reservations, and remaining balances by budget control keys of fund, organization code, account, and program for a fiscal year and period. Additional reporting can be by financial manager or the various hierarchy levels of the fund, organization code, account, and program.One row per chart of accounts per fiscal year and period per fund per organization code per account per program per commitment type.CHART_OF_ACCOUNTS, FISCAL_YEAR FISCAL_PERIOD CHART_OF_ACCOUNTS, ORGANIZATION_CODE CHART_OF_ACCOUNTS, PROGRAM CHART_OF_ACCOUNTS, FISCAL_YEAR, FISCAL_PERIOD, FUND, ORGANIZATION_CODE, ACCOUNT, PROGRAM CHART_OF_ACCOUNTS, FISCAL_YEAR, FUND, ORGANIZATION_CODE, ACCOUNT, PROGRAM, FISCAL_PERIOD, COMMITMENT_TYPE CHART_OF_ACCOUNTS, FUND CHART_OF_ACCOUNTS, ACCOUNT | | |
BUDGET_DETAIL
| Contains budget detail for a selected accounting distribution combination by budget id and budget phase. Additional reporting can be at the various hierarchy levels for fund, organization code, account, program and location.One row per budget ID per budget phase per budgeted line item ( chart of accounts, fund, organization code, account, program, activity, location).BUDGET_IDENTIFIER, BUDGET_PHASE, CHART_OF_ACCOUNTS, FUND, ORGANIZATION_CODE, ACCOUNT, PROGRAM, ACTIVITY, LOCATION CHART_OF_ACCOUNTS, ORGANIZATION_CODE CHART_OF_ACCOUNTS, PROGRAM CHART_OF_ACCOUNTS, FUND CHART_OF_ACCOUNTS, ACCOUNT CHART_OF_ACCOUNTS, LOCATION | | |
BUDGET_REQUEST_TEXT
| Contains text lines associated with budget line item requests.One row per budget line item per each line of text.BUDGET_LINE_ITEM_ID | | |
CHART_ATTRIBUTES
| Contains a list of all the attribute types, attribute values, and attribute values begin and end date associated with a chart of accounts code.One row per chart of accounts per attribute type per attribute value.VALUE CHART_OF_ACCOUNTS, ATTRIBUTE_TYPE, ATTRIBUTE_VALUE ATTRIBUTE_TYPE, ATTRIBUTE_VALUE, CHART_OF_ACCOUNTS | | |
ENCUMBRANCE
| Contains encumbrance document number, type of encumbrance, encumbrance status, encumbrance posted date, encumbrance last change document, completion indicator, and approval indicator for the financial commitment.One row per encumbrance document number.ENCUMBRANCE_NUMBER ENCUMBRANCE_TYPE | | |
ENCUMBRANCE_ACCOUNTING
| Contains encumbrance document number, item, sequence number, accounting distribution, and encumbrance status for the financial commitment.One row per encumbrance document number per item per sequence number.ENCUMBRANCE_NUMBER, ITEM, SEQUENCE_NUMBER CHART_OF_ACCOUNTS, FISCAL_YEAR, FUND, ORGANIZATION_CODE CHART_OF_ACCOUNTS, ORGANIZATION_CODE CHART_OF_ACCOUNTS, PROGRAM CHART_OF_ACCOUNTS, FUND CHART_OF_ACCOUNTS, ACCOUNT CHART_OF_ACCOUNTS, LOCATION | | |
ENCUMBRANCE_LEDGER
| Contains encumbrance ledger posted amounts for initial commitments, current adjustments, and current liquidations by fiscal year and period for each individual encumbrance document number and accounting distribution.One row per encumbrance document number per item per sequence number for each fiscal year and period.ENCUMBRANCE_NUMBER, ITEM, SEQUENCE_NUMBER, FISCAL_YEAR, FISCAL_PERIOD FISCAL_YEAR, FISCAL_PERIOD | | |
ENCUMBRANCE_TEXT
| Contains text lines associated with general encumbrances. .One row per encumbrance document number per each line of text.ENCUMBRANCE_NUMBER | | |
ENDOWMENT_ATTRIBUTES
| Contains endowment user defined attributes assigned to an endowment fund used to meet external and or internal reporting requirements.One row per chart of accounts per endowment fund per attribute table per attribute value.CHART_OF_ACCOUNTS, FUND | | |
ENDOWMENT_DISTRIBUTION
| Contains historical distributed spendable income for endowments. Additional reporting by income accounting distribution, unrealized gain and loss accounting distribution, and gain and loss accounting distribution with each of their distribution frequencies.One row per document number per submission number per chart of accounts per endowment fund.DOCUMENT_NUMBER, SUBMISSION_NUMBER, CHART_OF_ACCOUNTS, FUND CHART_OF_ACCOUNTS, FUND CHART_OF_ACCOUNTS, ENDOWMENT_POOL, FUND INCOME_CR_CHART, INCOME_CR_FUND | | |
ENDOWMENT_SUMMARIZED_UNITS
| Contains summarized purchased endowment units and book value for each endowment fund within a pool that had purchased units during the unitization period. An aggregation of the purchased endowment units and book value is represented from the first unitzation period to the reportable unitization period along with its current market value and market purchase unit price.One row per chart of accounts per endowment pool per endowment fund per unitization period end date.CHART_OF_ACCOUNTS, FUND CHART_OF_ACCOUNTS, ENDOWMENT_POOL CHART_OF_ACCOUNTS, ENDOWMENT_POOL, FUND | | |
ENDOWMENT_UNITS
| Contains gifts that were added to endowed funds at the document level and unitized.One row per chart of accounts per endowment pool per endowment fund per organization code per account per program per unitization period end date.VALUE CHART_OF_ACCOUNTS, FUND ENTITY_UID CHART_OF_ACCOUNTS, ENDOWMENT_POOL, FUND INCOME_CR_CHART, INCOME_CR_FUND | | |
FIXED_ASSET_ACCOUNTING_HISTORY
| Contains historical detail of the accounting impact by any adjustment or depreciation to a fixed asset including the original capitalization and or depreciation accounting as well as any adjustment amounts. .One row per fixed asset origination tag, per change sequence number, per sequence number.VALUE ORIGINATION_TAG_NUMBER, SEQUENCE_NUMBER | | |
FIXED_ASSET_ACCOUNTING_SOURCE
| Contains current detail of the accounting impact by the last adjustment or depreciation to a fixed asset listing all accounting element columns. Additional reporting can be by financial manager or the various hierarchy levels of the depreciation fund, organization code, account, program and location. .One row per fixed asset origination tag number, per sequence number.VALUE ORIGINATION_TAG_NUMBER, SEQUENCE_NUMBER CHART_OF_ACCOUNTS, PROGRAM CHART_OF_ACCOUNTS, FUND CHART_OF_ACCOUNTS, LOCATION CHART_OF_ACCOUNTS, ACCOUNT | | |
FIXED_ASSET_ADJUSTMENT
| Contains all asset adjustments information by adjustment document number. This includes the type of adjustment, depreciation adjustment date, transaction date, disposal, net book value amount, fiscal year, fiscal period, transaction amount, distribution percent, transaction amount, and transaction amount adjusted.One row per adjustment document number per item number per sequence number per accounting sequence number.DOCUMENT, ACCOUNT_ITEM, SEQUENCE_NUMBER, ACCOUNTING_SEQUENCE_NUMBER ORIGINATION_TAG_NUMBER | | |
FIXED_ASSET_ADJUSTMENT_TEXT
| Contains text lines associated with fixed asset adjustment documents.One row per document number per each line of text.DOCUMENT, SEQUENCE_NUMBER | | |
FIXED_ASSET_ATTRIBUTES
| Contains asset item user defined values used to meet external and or internal reporting requirements.One row per fixed asset item per attribute table per attribute value.VALUE ORIGINATION_TAG_NUMBER | | |
FIXED_ASSET_DEPRECIATED_ITEM
| Contains asset depreciation controls and summarized information like depreciation start date, asset type, useful life, remaining useful life, depreciation method, depreciation frequency, last depreciation date, depreciation amounts (total, net, old), and salvage amount.One row per asset origination tag number.ORIGINATION_TAG_NUMBER | | |
FIXED_ASSET_FUNDING_SOURCE
| Contains funding source accounting distribution information at the time the fixed asset item was acquired as well as an original document tag number if used. Additional reporting can be by financial manager and or the various hierarchy levels of the fund, organization code, account, program, and location.One row per fixed asset origination tag number per sequence number.ORIGINATION_TAG_NUMBER, SEQUENCE_NUMBER SUBORDINATE_TAG_NUMBER CHART_OF_ACCOUNTS, PROGRAM CHART_OF_ACCOUNTS, ORGANIZATION_CODE CHART_OF_ACCOUNTS, FUND CHART_OF_ACCOUNTS, LOCATION CHART_OF_ACCOUNTS, ACCOUNT | | |
FIXED_ASSET_ITEM
| Contains general information about the fixed asset item including acquisition details and current values such as capitalization date, capitalization amount, last adjustment date, asset type, asset description, normal useful life, various amounts, disposal method, disposal date, purchase order, invoice, vendor name, transfer date, chart of accounts, responsible organization code, responsible location, responsible person name, and grant.One row per fixed asset origination tag number.PERSON_UID ORIGINATION_TAG_NUMBER GRANT_ID | | |
FIXED_ASSET_TEXT
| Contains text lines associated with fixed asset items.One row per fixed asset item per each line of text.ORIGINATION_TAG_NUMBER | | |
FOAPAL_NO_ATTRIBUTES
| Contains a list of all accounting distribution elements that are not associated with a set code, or an attribute type, and/or an attribute value. This is used for exception reporting to assist in attaching reporting attributes to the various accounting distribution elements.One row per chart of accounts per accounting distribution element.CHART_OF_ACCOUNTS | | |
FUND_ATTRIBUTES
| Contains a list of all the set codes, attribute types, attribute values, and attribute values begin and end date associated with a fund.One row per chart of accounts per fund code per attribute type per attribute value per set code.CHART_OF_ACCOUNTS, FUND, ATTRIBUTE_TYPE, ATTRIBUTE_VALUE ATTRIBUTE_TYPE, ATTRIBUTE_VALUE, CHART_OF_ACCOUNTS | | |
FUND_HIERARCHY
| Contains a list of all funds with associated hierarchy levels, fund type, internal fund type, fund pool, financial manager, termination date, and expenditure end dates. Used to support roll up reporting.One row per chart of accounts per fund.CHART_OF_ACCOUNTS CHART_OF_ACCOUNTS, FUND | | |
FUND_HIERARCHY_FISCAL
| Contains a list of all funds with associated hierarchy levels, fund type, internal fund type, fund pool, financial manager, termination date, and expenditure end dates. Used to support roll up reporting by fiscal year and fiscal period.One row per chart of accounts per fund per fiscal year per fiscal period.CHART_OF_ACCOUNTS, FISCAL_YEAR, FISCAL_PERIOD CHART_OF_ACCOUNTS, FISCAL_YEAR, FISCAL_PERIOD, FUND | | |
FUND_TEXT
| Contains text lines associated with a fund.One row per fund per line of text. Note: This is not chart specific because of the way SCT Banner has designed this table. Thus, multi-chart environments cannot show the fund description as the description cannot be extracted without a chart of accounts.FUND | | |
FUND_TYPE_ATTRIBUTES
| Contains a list of all the set codes, attribute types, attribute values, and attribute values begin and end date associated with a fund type.One row per chart of accounts per fund type code per attribute type per attribute value per set code.VALUE CHART_OF_ACCOUNTS, FUND_TYPE, ATTRIBUTE_TYPE, ATTRIBUTE_VALUE ATTRIBUTE_TYPE, ATTRIBUTE_VALUE, CHART_OF_ACCOUNTS | | |
GENERAL_LEDGER
| Contains general ledger account/fund information for each fiscal year and period with period beginning and ending balances, and current actuals. Additional reporting can be by financial manager or the various hierarchy levels of the fund and account.One row per chart of accounts per fiscal year per fund per account per fiscal period.CHART_OF_ACCOUNTS, FISCAL_YEAR FISCAL_PERIOD CHART_OF_ACCOUNTS, FISCAL_YEAR, FISCAL_PERIOD, FUND, ACCOUNT CHART_OF_ACCOUNTS, ACCOUNT CHART_OF_ACCOUNTS, FUND | | |
GRANT_APPLIED_PAYMENTS
| Contains grant billing details for payments that have been applied against charges. Reporting can be by grant or letter or credit, various dates, payment transaction number, charge transaction number, posting document, post cashier session, and withholding information.Multiple rows per grant ID per payment transaction number.GRANT_ID, ACCOUNT_TRANSACTION_NUMBER APPLIED_GRANT_ID | | |
GRANT_ATTRIBUTES
| Contains grant user defined values used to meet external and or internal reporting requirements.One row per grant ID per attribute table per attribute value.GRANT_ID, ATTRIBUTE_TABLE | | |
GRANT_BILLING_DETAIL
| Contains details for billed and unbilled grant transactions. Reporting can be by grant, letter of credit, payment management system code, billing account distribution or document key, billing period date, and billing run and hold or release dates.One row per document per document type per sequence number per item per submission number per fund per account class per account per reversal indicator.BILL_DOCUMENT, BILL_DOCUMENT_TYPE, BILL_SEQUENCE_NUMBER, BILL_ITEM, BILL_SUBMISSION_NUMBER, BILL_REVERSAL_IND, ACCOUNT_CLASS, BILL_FUND, BILL_ACCOUNT BILL_GRANT_ID BILL_STATUS, BILL_GRANT_ID GRANT_ID CHART_OF_ACCOUNTS CHART_OF_ACCOUNTS, FUND CHART_OF_ACCOUNTS, ACCOUNT | | |
GRANT_DEFERRED_COST
| Contains details behind the postings for grant deferred costs of indirect cost, cost share and revenue. The source document information and posting document information that supports the calculations of the costs.Multiple rows per grant ID.CHART_OF_ACCOUNTS, LOCATION CHART_OF_ACCOUNTS, ORGANIZATION_CODE CHART_OF_ACCOUNTS, PROGRAM CHART_OF_ACCOUNTS, ACCOUNT_INDEX CHART_OF_ACCOUNTS, FUND GRANT_ID | | |
GRANT_EVENT
| Contains information about grant events and the data used to construct the event for a grant such as billing requirements or reminders associated with a grant. Reportable fields are event type and frequency, start and end date for generated events, number of days for a reminder notice, billing format, payment method and person responsible for the first grant event status period.One row per grant ID per grant event.GRANT_ID GRANT_ID, GRANT_EVENT | | |
GRANT_EVENT_STATUS
| Contains information about grant event periods and their statuses. Reportable fields are event type, event due date, event status and status date, person responsible for the event, and person who approved the event.One row per grant ID per grant event per grant event sequence number.GRANT_ID GRANT_ID, GRANT_EVENT GRANT_ID, GRANT_EVENT, EVENT_SEQUENCE_NUMBER RESPONSIBLE_PERSON_UID | | |
GRANT_FUND
| Contains all fund information associated to a grant as well as the general grant information. Multiple funds can be associated to one grant at any one point in time and/or over a period of time. Also lists grant indirect cost and cost share codes versus fund indirect cost and cost share codes.One row per grant ID per chart of accounts per fund.CHART_OF_ACCOUNTS, FUND GRANT_ID, CHART_OF_ACCOUNTS, FUND AGENCY_UID CHART_OF_ACCOUNTS, ORGANIZATION_CODE | | |
GRANT_FUND_SLOT
| Uses data from the GRANT_FUND reporting view. Displays up to 10 fund codes assigned to a grant listed in order of descending termination date.One row per grant ID.GRANT_ID ACTIVITY_DATE | | |
GRANT_LEDGER
| Contains grant ledger information representing inception to date amounts as well as current period amounts for adopted budgets, budget adjustments, actual activity, encumbrances, budget reservations, and remaining balance for each unique combination of accounting distribution. Additional reporting can be by financial manager or the various hierarchy levels of the fund, organization code, account, program, and location.One row per chart of accounts per grant ID per grant year per grant period per fund per organization code per account per program per activity per location.GRANT_ID CHART_OF_ACCOUNTS, ORGANIZATION_CODE CHART_OF_ACCOUNTS, PROGRAM CHART_OF_ACCOUNTS, FUND CHART_OF_ACCOUNTS, ACCOUNT CHART_OF_ACCOUNTS, LOCATION CHART_OF_ACCOUNTS, FISCAL_YEAR FISCAL_PERIOD CHART_OF_ACCOUNTS, GRANT_YEAR, GRANT_PERIOD, GRANT_ID, FUND, ORGANIZATION_CODE, ACCOUNT, PROGRAM, ACTIVITY, LOCATION CHART_OF_ACCOUNTS, FISCAL_YEAR, FISCAL_PERIOD, FUND, ORGANIZATION_CODE, ACCOUNT, PROGRAM, ACTIVITY, LOCATION CHART_OF_ACCOUNTS, GRANT_ID | | |
GRANT_PERSONNEL
| Contains information about personnel associated to the grant, each person's contact information.One row per grant ID per personnel type per personnel UID.PHONE_SEQ_NUMBER PHONE_TYPE, PHONE_SEQ_NUMBER ADDRESS_TYPE GRANT_ID CHART_OF_ACCOUNTS GRANT_ID, PERSONNEL_TYPE, PERSONNEL_UID PERSONNEL_UID, GRANT_ID | | |
GRANT_RECEIVABLE_ACCT_DETAIL
| Contains detail receivable account transaction information for all grant charges and payments. .One row per grant ID per transaction number.GRANT_ID, ACCOUNT_TRANSACTION_NUMBER CHART_OF_ACCOUNTS, FUND | | |
GRANT_TEXT
| Contains text lines associated with a grant.One row per grant ID per each line of text.GRANT_ID | | |
GRANT_VIEW
| Contains information defining the grant itself. The principal investigator, federal ID, sponsor number, agency and agency information with hierarchy data, various amounts, responsible organization with hierarchy data, various dates, letter of credit number, payment management system code, location, type of grant, indirect cost and cost share codes.One row per grant ID.CHART_OF_ACCOUNTS, RESPONSIBLE_ORGANIZATION_CODE CHART_OF_ACCOUNTS, LOCATION GRANT_ID AGENCY_UID AGENCY_UID_LEVEL_1 AGENCY_UID_LEVEL_2 AGENCY_UID_LEVEL_3 AGENCY_UID_LEVEL_4 | | |
INVOICE
| Contains general invoice and vendor information including invoice type, purchase order, vendor, vendor invoice number, third party information, one time vendor information, invoice date, payment due date, transaction date, cancel date, open paid indicator, and total approved amount.One row per invoice.INVOICE ADDRESS_TYPE | | |
INVOICE_ACCOUNTING
| Contains general invoice accounting data including, purchase order, fiscal year/period, accounting distribution, bank, and approved amount. Additional reporting can be by financial manager or the various hierarchy levels of the fund, organization code, account, program, and location.One row per invoice per item per sequence number.INVOICE, ITEM, SEQUENCE_NUMBER CHART_OF_ACCOUNTS, FISCAL_YEAR, FISCAL_PERIOD CHART_OF_ACCOUNTS, ORGANIZATION_CODE CHART_OF_ACCOUNTS, PROGRAM CHART_OF_ACCOUNTS, FUND CHART_OF_ACCOUNTS, ACCOUNT CHART_OF_ACCOUNTS, LOCATION | | |
INVOICE_ACCOUNTING_TAX_RATE
| Contains tax rates, amounts, and rebates as it relates to the invoice accounting level. This includes who the tax should be paid to.One row per invoice per item per sequence number per tax rate.INVOICE, ITEM, SEQUENCE_NUMBER | | |
INVOICE_CHECK
| Contains check payment information for each invoice including bank information, check type, check date, check net amount, cancel indicator, cancel date, and reconciliation date.One row for invoice per check number per bank.CHECK_NUMBER, BANK INVOICE, CHECK_NUMBER, BANK | | |
INVOICE_ITEM
| Contains invoice items with purchase order, and commodity information. This includes each base and converted amount for unit price, taxes, discounts and additional charges as well as approved quantity.One row per invoice per invoice item.INVOICE, ITEM | | |
INVOICE_ITEM_ACCOUNTING
| Contains general invoice commodity level accounting data including, purchase order, fiscal year/period, accounting distribution, bank, and approved amount. Additional reporting can be by financial manager or the various hierarchy levels of the fund, organization code, account, program, and location.One invoice per item per sequence numberINVOICE, ITEM, SEQUENCE_NUMBER CHART_OF_ACCOUNTS, FISCAL_YEAR, FISCAL_PERIOD CHART_OF_ACCOUNTS, LOCATION CHART_OF_ACCOUNTS, ORGANIZATION_CODE CHART_OF_ACCOUNTS, PROGRAM CHART_OF_ACCOUNTS, ACCOUNT CHART_OF_ACCOUNTS, FUND | | |
INVOICE_TAX_RATE
| Contains tax rates, amounts, and rebates as it relates to the invoice item level. This includes who the tax should be paid to.One row per invoice per item per per tax rate.INVOICE, ITEM | | |
INVOICE_TAX_RATE_SLOT
| Uses data from the INVOICE_TAX_RATE reporting view. Displays the last 8 tax rates, amounts and rebates applied to each invoice item.One row per invoice per item listing up to 8 tax rates for each item.INVOICE, ITEM ACTIVITY_DATE | | |
INVOICE_TEXT
| Contains text lines associated with invoices.One row per document number per each line of text.INVOICE | | |
JOURNAL_VOUCHER_TEXT
| Contains text lines associated with journal entries.One row per document number per each line of text.DOCUMENT | | |
LOCATION_ATTRIBUTES
| Contains a list of all the set codes, attribute types, attribute values, and attribute values begin and end date associated with a location.One row per chart of accounts per location code per attribute type per attribute value per set code.VALUE CHART_OF_ACCOUNTS, LOCATION, ATTRIBUTE_TYPE, ATTRIBUTE_VALUE ATTRIBUTE_TYPE, ATTRIBUTE_VALUE, CHART_OF_ACCOUNTS | | |
LOCATION_HIERARCHY
| Contains a list of all locations with associated hierarchy levels. Used to support roll up reporting.One row per chart of accounts per location.CHART_OF_ACCOUNTS, LOCATION | | |
LOCATION_HIERARCHY_FISCAL
| Contains a list of all locations with associated hierarchy levels. Used to support roll up reporting by fiscal year and fiscal period.One row per chart of accounts per location per fiscal year per fiscal period.CHART_OF_ACCOUNTS, FISCAL_YEAR, FISCAL_PERIOD, LOCATION | | |
OPERATING_LEDGER
| Contains summary and current amounts for adopted budget, budget adjustments, encumbrances, budget reservations, and remaining balances by accounting distribution for a fiscal year and period. Additional reporting can be by financial manager or the various hierarchy levels of the fund, organization code, account, program and location.One row per chart of accounts per fiscal year per fiscal period per fund per organization code per account per program per activity per location per commitment type. CHART_OF_ACCOUNTS, FISCAL_YEAR FISCAL_PERIOD CHART_OF_ACCOUNTS, PROGRAM CHART_OF_ACCOUNTS, ORGANIZATION_CODE CHART_OF_ACCOUNTS, FUND CHART_OF_ACCOUNTS, LOCATION CHART_OF_ACCOUNTS, FISCAL_YEAR, FISCAL_PERIOD, FUND, ORGANIZATION_CODE, ACCOUNT, PROGRAM, ACTIVITY, LOCATION CHART_OF_ACCOUNTS, ACCOUNT | | |
ORGANIZATION_ATTRIBUTES
| Contains a list of all the set codes, attribute types, attribute values, and attribute values begin and end date associated with an organization code.One row per chart of accounts per organization code per attribute type per attribute value per set code.VALUE CHART_OF_ACCOUNTS, ORGANIZATION_CODE, ATTRIBUTE_TYPE, ATTRIBUTE_VALUE ATTRIBUTE_TYPE, ATTRIBUTE_VALUE, CHART_OF_ACCOUNTS | | |
ORGANIZATION_HIERARCHY
| Contains a list of all organization codes with associated hierarchy levels, organization pool, and financial manager. Used to support roll up reporting.One row per chart of accounts per organization code.CHART_OF_ACCOUNTS, ORGANIZATION_CODE | | |
ORGANIZATION_HIERARCHY_FISCAL
| Contains a list of all organization codes with associated hierarchy levels, organization pool, and financial manager. Used to support roll up reporting by fiscal year and fiscal period.One row per chart of accounts per organization code per fiscal year per fiscal period.CHART_OF_ACCOUNTS, FISCAL_YEAR, FISCAL_PERIOD, ORGANIZATION_CODE | | |
PROGRAM_ATTRIBUTES
| Contains a list of all the set codes, attribute types, attribute values, and attribute values begin and end date associated with a program.One row per chart of accounts per program per attribute type per attribute value per set code.VALUE CHART_OF_ACCOUNTS, PROGRAM, ATTRIBUTE_TYPE, ATTRIBUTE_VALUE ATTRIBUTE_TYPE, ATTRIBUTE_VALUE, CHART_OF_ACCOUNTS | | |
PROGRAM_HIERARCHY
| Contains a list of all programs with associated hierarchy levels. Used to support roll up reporting.One row per chart of accounts per program.CHART_OF_ACCOUNTS, PROGRAM | | |
PROGRAM_HIERARCHY_FISCAL
| Contains a list of all programs with associated hierarchy levels. Used to support roll up reporting by fiscal year and fiscal period.One row per chart of accounts per program per fiscal year per fiscal period.CHART_OF_ACCOUNTS, FISCAL_YEAR, FISCAL_PERIOD, PROGRAM | | |
PROPOSAL
| Contains proposal pre-award and grant award information. The principal investigator information, agency and agency information with hierarchy data, submission date, award/decline date, and responsible organization code.One row per grant proposal.CHART_OF_ACCOUNTS, ORGANIZATION_CODE AGENCY_UID AGENCY_UID_LEVEL_1 AGENCY_UID_LEVEL_2 AGENCY_UID_LEVEL_3 AGENCY_UID_LEVEL_4 GRANT_ID PROPOSAL_CODE | | |
PROPOSAL_TEXT
| Contains text lines associated with grant proposals.One row per document number per each line of text.PROPOSAL_CODE | | |
PURCHASE_ORDER
| Contains current general purchase order and vendor information including type of purchase order, transaction date, vendor, buyer, organization hierarchy, shipping address, and blanket order information.One row per purchase order.CHART_OF_ACCOUNTS, ORGANIZATION_CODE PURCHASE_ORDER | | |
PURCHASE_ORDER_ACCOUNTING
| Contains current general purchase order accounting data including fiscal year/period, accounting distribution, and amounts. Additional reporting can be by financial manager or the various hierarchy levels of the fund, organization code, account, program, and location.One row per purchase order per item per sequence number.CHART_OF_ACCOUNTS, ACCOUNT CHART_OF_ACCOUNTS, FUND CHART_OF_ACCOUNTS, LOCATION CHART_OF_ACCOUNTS, ORGANIZATION_CODE CHART_OF_ACCOUNTS, PROGRAM PURCHASE_ORDER, ITEM, SEQUENCE_NUMBER | | |
PURCHASE_ORDER_ITEM
| Contains current purchase order items with commodity information. This includes the requisition, bid, and each base and converted amount for unit price, taxes, discounts, and additional charges as well as quantity.One row per purchase order per item.PURCHASE_ORDER, ITEM | | |
PURCHASE_ORDER_ITEM_ACCOUNTING
| Contains current general purchase order commodity level accounting data including fiscal year/period, accounting distribution, and amounts. Additional reporting can be by financial manager or the various hierarchy levels of the fund, organization code, account, program, and location.One purchase order per item per sequence numberCHART_OF_ACCOUNTS, LOCATION CHART_OF_ACCOUNTS, ORGANIZATION_CODE PURCHASE_ORDER, ITEM, SEQUENCE_NUMBER CHART_OF_ACCOUNTS, PROGRAM CHART_OF_ACCOUNTS, ACCOUNT CHART_OF_ACCOUNTS, FUND | | |
PURCHASE_ORDER_ITEM_SUMMARY
| Contains received purchase order item summary information.One row per purchase order per item received.PURCHASE_ORDER, ITEM | | |
PURCHASE_ORDER_ITEM_TEXT
| Contains text lines associated with purchase order items.One row per document number per item per each line of text.CLAUSE, CLAUSE_SEQUENCE_NUMBER | | |
PURCHASE_ORDER_TAX_RATE
| Contains current tax rates and amounts for each purchase order item. This includes who the tax should be paid to.One row per purchase order per item per priority per tax rate.PURCHASE_ORDER, ITEM, PRIORITY, TAX_RATE | | |
PURCHASE_ORDER_TEXT
| Contains text lines associated with purchase orders.One row per document number per each line of text.CLAUSE, CLAUSE_SEQUENCE_NUMBER | | |
RECEIVED_ITEM
| Contains received purchase order item information including packing slip, receiving method, carrier, received date, quantity received, and quantity rejected.One row per receiver document per packing slip per purchase order per item.RECEIVER_DOCUMENT, PURCHASE_ORDER, PACKING_SLIP_KEY, ITEM PURCHASE_ORDER, ITEM RECEIVED_DATE COMMODITY RETURN_DOCUMENT, PURCHASE_ORDER, ITEM, RETURN_SEQUENCE_NUMBER RETURN_REASON | | |
RECEIVED_ITEM_TEXT
| Contains text lines associated with purchase order received items.One row per document number per each line of text.DOCUMENT | | |
RETURNED_ITEM
| Contains returned purchase order item information.One row per returned document per returned document sequence number.RETURN_DOCUMENT, PURCHASE_ORDER, ITEM, RETURN_SEQUENCE_NUMBER PURCHASE_ORDER, ITEM VENDOR_UID, RETURN_REASON RETURN_REASON COMMODITY | | |
RETURNED_ITEM_TEXT
| Contains text lines associated with purchase order returns.One row per document number per each line of text.DOCUMENT | | |
TRANSACTION_HISTORY
| Contains source transaction accounting distirbution history and ledger posting detail information. This includes the type of document, ledger indicator, which ledger field updated, rule process, rule class, document reference number, bank, vendor, budget period, and accounting distribution. Additional reporting can be by financial manager or the various hierarchy levels of the fund, organization code, account, program, and location. Used to reconcile the various ledgers and provide detail financial activity.Multiple rows for each source financial transaction.CHART_OF_ACCOUNTS, ACCOUNT_INDEX CHART_OF_ACCOUNTS, ORGANIZATION_CODE CHART_OF_ACCOUNTS, PROGRAM CHART_OF_ACCOUNTS, FUND CHART_OF_ACCOUNTS, LOCATION DOCUMENT, DOCUMENT_TYPE, SUBMISSION_NUMBER, ITEM, SEQUENCE_NUMBER, SERIAL_NUMBER, REVERSAL_IND, LEDGER_IND CHART_OF_ACCOUNTS, FISCAL_YEAR, LEDGER_IND, POSTING_PERIOD, FUND, ORGANIZATION_CODE, ACCOUNT, PROGRAM, ACTIVITY, LOCATION, TRANSACTION_DATE ENCUMBRANCE_NUMBER, ENCUMBRANCE_ITEM_NUMBER, ENCUMBRANCE_SEQ_NUMBER, LEDGER_IND CHART_OF_ACCOUNTS, FISCAL_YEAR, LEDGER_IND, POSTING_PERIOD, ACCOUNT_INDEX, TRANSACTION_DATE CHART_OF_ACCOUNTS, FISCAL_YEAR, LEDGER_IND, POSTING_PERIOD, FIELD_CODE, FUND, ACCOUNT, ORGANIZATION_CODE, ACTUAL_FUND_TYPE_LEVEL_2 CHART_OF_ACCOUNTS, FISCAL_YEAR, LEDGER_IND, POSTING_PERIOD, DETAIL_POSTING_PROCESS, RULE_CLASS, BANK CHART_OF_ACCOUNTS, FISCAL_YEAR, ACTIVITY_DATE, LEDGER_IND, DETAIL_USER_ID CHART_OF_ACCOUNTS, FISCAL_YEAR, TRANSACTION_DATE FISCAL_YEAR_HEADER, TRANSACTION_DATE, CHART_OF_ACCOUNTS | | |
VENDOR
| Contains vendor maintenance information including ID, name, contact name, federal tax indicator, federal tax ID number, order/remittance addresses and phone numbers.One row per vendor.ADDRESS_TYPE PHONE_TYPE VENDOR_UID | | |
VENDOR_TAXABLE_REPORTING
| Contains taxable income paid to a vendor that is reportable to a federal government such as tax id, name, address, reportable amount, income type, souce of income document, check number, bank, any monies withheld for federal or state.One row per vendor uid per vendor tax id per tax year per check number per bank code per document.VENDOR_UID TAX_YEAR, VENDOR_UID TAX_YEAR, PAYER_TAX_ID VENDOR_UID, VENDOR_TAX_ID, TAX_YEAR, CHECK_NUMBER, BANK, DOCUMENT, PAYER_TAX_ID | | |
VENDOR_TEXT
| Contains text lines associated with vendors.One row per vendor per each line of text.VENDOR_UID | | |
VENDOR_TYPE
| Contains a list of all associated vendor types for the vendor.One row per vendor per vendor type.VENDOR_UID VENDOR_TYPE, VENDOR_UID | | |