Data Glossary
Last Updated: November 22, 2023 2:07:47 PM PST
Give feedback
Review a glossary of terms for financial reports and analytics.
You will notice that some field names appear multiple times, we are currently working on consolidating and updating the field names and descriptions in the glossary.
A - D
| Field Name | Description |
|---|---|
| Account | This indicates the nature of the transaction being recorded For example: Asset, Liability, Equity, Revenue, Expense or Transfer Account |
| Account | Code for the Account (ex. 440000) |
| Account | Numerical representation for the account in the primary/standard Common Chart of Accounts (CCOA This indicates the nature of the transaction being recorded, for example, Asset, Liability, Equity, Revenue, Expense or Transfer Account |
| Account Class | Class associated with the Customer Account (ex. Federal, Foreign, Local, Private, Public, State, etc.) |
| Account Code | Numerical representation for the Account in the primary/standard Common Chart of Accounts (CCOA) This indicates the nature of the transaction being recorded For example, Asset, Liability, Equity, Revenue, Expense or Transfer Account |
| Account Code | Description of the Account |
| Account Code | An Account Code is a segment within the Chart of Accounts The Account Code represents the Account that the charge is associated to |
| Account Code | Unique ID for each account indicates the nature of the transaction being recorded For example, Asset, Liability, Equity, Revenue, Expense or Transfer Account |
| Account Description | The description of the Account |
| Account Description | Detailed description of the Project |
| Account Description | The description for specific Customer Account, such as Radiology Sponsored Project or Pediatrics Service Agreement Billing |
| Account Level 29 | Alphanumeric code and description representing Level 29 of the Account posting level |
| Account Level 30 | Alphanumeric code and description representing Level 30 of the Account posting level |
| Account Number | The Customer Number associated with the Customer Account (unique identifier) |
| Account Profile Generate Bill Indicator | Indicated if the Invoices will be generated for this Customer Account Customer Account can have multiple sites (geographic locations) |
| Account Profile Payment Terms | Default payment terms for the Customer Account, such as Immediate, Net 30, Net 45, etc. |
| Account Type | Number and Description that indicates the nature of the transaction being recorded. For example: Asset, Liability, Equity, Revenue, Expense or Transfer Account |
| Account Type | Identify the Account type for the Account code |
| Account Value | Numerical representation for the account in the primary/standard Common Chart of Accounts (CCOA) This indicates the nature of the transaction being recorded For example, Asset, Liability, Equity, Revenue, Expense or Transfer Account |
| Accounted Credit Amount | The Accounting date of the transaction |
| Accounting Date | Specific Date within the Accounting Period |
| Accounting Date | Date that Purchase Order line was posted to the General Ledger |
| Accounting Date | Calendar date within the Accounting period |
| Accounting Period | The Accounting Period is the combined month and fiscal year (Jul-20) for which a business prepares and reports financial performance and position For example, the UCSD fiscal year 2021 is Jul-20 through Jun-21 |
| Accounting Period End Date | Last date of the Accounting Period |
| Accounting Period Name | The Accounting period is the combined month and fiscal year (Jul-20) for which a business prepares and reports financial performance and position For example, the UCSD fiscal year 2021 is Jul-20 through Jun-21 |
| Accounting Period Name | The Accounting month that the transaction has been incurred on the General Ledger |
| Accounting Period Name | The Accounting Period is the combined month and fiscal year (Jul-20) for which a business prepares and reports financial performance and position, for example, the UCSD fiscal year 2021 is Jul-20 through Jun-21 |
| Accounting Period Start Date | First date of the Accounting Period |
| Active Award Count by Sponsor | Count of Active Awards by Sponsor, viewable by Award |
| Active Awards by Award Type | Count of Awards by Type - Viewable as a chart or table |
| Active Awards by PI | Count of Awards by Principal Investigator - Viewable as a chart or table |
| Active Grants | Total Count of Active Grants based on parameters |
| Activity Code | Tracks credit card merchant Accounts and internal Loans |
| Activity Date |
A reference value that provides more information about the transaction
This value is dependent on the Journal Source Receivables = Receipt Date Cash Management = Transaction Date Project - Cost: Expenditure Date, External Revenue: Payables = Invoice Date: , Payments: Check Date General Ledger = Accounting Date |
| Activity Description | What is the description of the Activity? |
| Activity Description | Name of Activity value |
| Activity Hierarchy L1 Code | Alphanumeric code representing Level 1 of the Activity hierarchy |
| Activity Hierarchy L1 Description | Text description for Level 1 of Activity hierarchy |
| Activity Hierarchy L2 Code | Alphanumeric code representing Level 2 of the Activity hierarchy, the posting level of the hierarchy |
| Activity Hierarchy L2 Description | Text description for Level 2 of Activity hierarchy, the posting level for Activity |
| Activity Value | Unique 6 digit alphanumeric # that classifies a transaction by Activity where PPM is not appropriate, such as credit card merchant account |
| Additional Notes | Any additional classifications that designate user activity in the system |
| Aging Bucket | A categorization method based on number of days from Invoice Date to Today as a numeric value |
| Alternate Name | Any other Name that the vendor has utilized This is includes "Doing Business As" (DBA's) Is utilized in the case of acquisition and mergers |
| Amount | Total amount of money |
| Amount Applied | Amount applied against an Invoice when Payment is made (can be partial of full) |
| Amount Still Due | Amount that is still due on the Invoice |
| Application Date | Date when Credit Memo was applied |
| Applied Amount | Amount that was applied against an open Invoice |
| Applied Transaction Class | ex. Invoice |
| Applied Transaction Number | Transaction number to which the Credit Memo was applied |
| Approval Group Name | Name of Approval Group |
| Approval Status | Indicates whether Invoice has been approved or not |
| Approved Requisition Amount | Total sum amount of the Requisition that was approved |
| Approved Requisition Count | Number of Requisitions within Oracle Financials Cloud that have been approved and converted to a Purchase Order |
| Asset Category | Added for future use, once Asset Categories are tracked |
| Assigned Date | Date when the Journal was assigned for approval |
| Assigned To | Who the Journal is assigned for approval |
| Assistant Coaching Salaries, Benefits, Bonuses | Compensation, bonuses and benefits paid to all coaches reportable on the university or related entities W-2 and 1099 forms, as well as non-taxable benefits, inclusive of: -Gross wages and bonuses. -Benefits including allowances, speaking fees, retirement, stipends, memberships, media income, tuition reimbursement/ exemptions and earned deferred compensation, including those funded by the state |
| Award Burden Schedule | This is also referred to as an Indirect Cost Rate schedule associated with the Award It represents a set of multipliers that act against Raw Cost to determine your Indirect Cost (IDC) |
| Award End Date | This is the End Date of the Award |
| Award Flow Through Sponsor | |
| Award Number | Award # from Kuali Research (KR), this is not the Sponsor Award # |
| Award Owning Organization | Award Owning Organization (Department) as recognized in the PPM module |
| Award Principal Investigator | The faculty member responsible of the award |
| Award Purpose | The Award purpose helps you understand the basic purpose of the Award For example, Academic Support, Research, and Student Services |
| Award Sponsor | Sponsor/funder of the award, who specifies certain requirements that the award is subject to |
| Award Start Date | This is the Start Date of the Award |
| Award Status | ex. Active, Inactive, Hold, etc. |
| Award Type | Type of Award Defines if it is a Federal Grant, Private Contract, State Contract |
| Award Type | Indicates the Award structure based on type of award -e.g., Award with 2 different organizations, Award with 2 different burden rates, etc. |
| Awards Expiring in Next 90 Days | Total Count of Grants expiring in the next 90 days based |
| Bank Account Name | Name of the Bank associated with the Account |
| Base Price | MSRP (Manufacturer's Suggested Retail Price) before any options or taxes are added |
| Beginning Balance | The balance of the Account as of the start of the given fiscal period |
| Beginning Balance | Is the starting total Debits and starting total Credits for the fiscal year listed out separately |
| Beginning Balance | Total Beginning Balance for each report line item |
| Beginning Net Position | The July 1 carryforward balance in account 300000. Please note the Beginning Net Position for FY22 is an estimate during the period July - October until account 300000 is updated with FY21 Net Activity at the financial unit and project level. |
| Bill-to Customer Name | Name of the Customer that is receiving the Credit Memo |
| Bill-to Customer Number | Unique identifier number within OFC for a particular Customer |
| Budget | The total Cost for the original baseline budget for the approved financial plan type Values reflected here have been entered into the Project Portfolio Management (PPM) module for the appropriate Project |
| Budget Amount | The total Cost for the original baseline budget for the approved financial plan type Values reflected here have been entered into the PPM module for the appropriate Project |
| Budget Amount | Total Budget Amount based on parameters provided |
| Budget Balance | This is the calculated amount of the Budget Amount - Cost |
| Budget Balance with Committed Cost | This is the calculated amount of the Budget Amount - Cost - Total Committed Cost |
| Budget Resource Category | The name of the Resource category that classifies the Resource type into a Cost group Examples include Operating Expenses, Benefit Expenses, UCSD equipment, etc. |
| Budget vs Expenses | Comparison chart of Budget vs Expenses by Expenditure |
| Business Classification | Special Business Classifications given to a Vendor at the time of Supplier set up These can include Electronic Invoicing vendor, or Small Business Classifications |
| Business Classification Status |
Current: the Business Classification has not expired yet Expired: the Business Classification no longer applies and the payee must renew or update their information with us via PaymentWorks |
| Business Classification Start Date |
The official date the Business Classification began |
| Business Classification End Date | The official date the Business Classification expired |
| Business Relationship | Shows the type of business relationship they are categorized within OFC |
| Business Unit Ledger | The security context attached to the employee's assigned role Designates the Business Unit and/or Ledger that further provisions access to underlying data in the OFC system |
| Business Unit | ex. Campus, Health, etc. |
| Buyer | Person that actually bought the product, usually designated by the Department |
| Calendar Month End Date | Last day of the Calendar Month |
| Calendar Month Start Date | First day of the Calendar Month |
| Capital Assets | Inception to date (since Oracle go-live, 7/1/20) Capital Assets purchases, sourced from Level 3 of the Standard Account hierarchy, 16000B Capital Assets |
| Capital Equipment | Inception to date (since Oracle go-live, 7/1/20) Capital Equipment purchases, sourced from Level 2 of the Standard Account hierarchy, 15000A Non-Current Assets |
| Category Name | Category for the Requisition, such as Facility Tools over 5K (Inventorial), Lab Supplies, etc. |
| Change in Net Position | The YTD net activity of resource, revenue and expense accounts |
| Check Status | Indicates the status of a payment, e.g. Cleared, Voided, Issued |
| COA String | Full chartstring value for the Journal line number |
| Collection Method | Method for collecting the Receipt |
| Conference Distributions | All revenues received by conference distribution, excluding portions of distribution relating to media rights |
| Contract Number | Any Contract associated with the Requisition |
| Contract Number | Contract # in OFC that is equal to the Award Number The Contract houses the revenue and bill plans |
| Contract Owning Organization | Contract Owning Organization (Department) as recognized in the PPM module |
| Contributions | Contributions provided and used by athletics in the reporting year including: -Amounts received from individuals, corporations, associations, foundations, clubs or other organizations designated for the operations of the athletics program -Funds contributed by outside contributors for the payment of debt service, lease payments or rental fee expenses for athletic facilities in the reporting year -Amounts received above face value for tickets |
| Core Adjusted Base Budget | Base Budget specific to Core Funds, including incremental adjustments for approved commitments, includes Recurring and One-Time |
| Core Base Budget | Base Budget specific to Core Funds |
| Core Funds |
Category of Funds that is used to support direct costs associated with instruction, research and public service efforts. Core funds include State and UC General Funds, Student Fee Funds (Tuition, Student Services Fees, Professional Degree Supplemental Tuition, Non-Resident Supplemental Tuition), Indirect Cost Recovery Funds, Investment Income, Patent Income, ASSA, Gift Fees/Endowment Cost Recovery
|
| Core New Requests | Requests to central campus for new Core Funding submitted through the annual budget process |
| Cost | Drives values of report |
| Cost Center | Numeric code and description of the Financial Unit |
| Cost Center Code | Indicates sport or department associated with the activity |
| Cost Center Code | Financial Unit Code |
| Cost Center Code | Financial Unit tied to the transaction |
| Cost Center Description | Financial Unit description tied to the transaction |
| Cost Trend | Award Cost by fiscal quarter - by line graph or list view |
| Costs | This is the total Cost associated with the Project and Task |
| Count | Count of Requisitions |
| Created By | System user that has created the Receipt |
| Created by |
A reference value that provides more information about the Transaction
This value is dependent on the Journal Source Receivables = Receipt Date Cash Management = Transaction Date Project - Cost: Expenditure Date, External Revenue: Payables = Invoice Date: , Payments: Check Date General Ledger = Accounting Date |
| Creation Date | Code for the Fund |
| Creation Date | Date when the Receipt was created |
| Creation Date | Did this Transaction come from a subledger? If so, which one? |
| Creation Method | How was the transaction created? (ex. Manual vs. Imported, etc.) |
| Credit Amount | Dollar amount for Credit transactions |
| Credit Memo ID | Unique identified of the Credit Memo |
| Current | Current outstanding charges |
| Current Period | The time period you want the report to run for (e.g. YTD, YearTotal, Dec 2020, etc) |
| Current Period | The time period the report the report is run for, e.g. YTD, YearTotal, Dec 2020, etc. The default for this report is Year Total |
| Customer Class | Class associated with the Customer Entity (ex. Federal, Foreign, Local, Private, Public, State, etc.) Customer Entity can have multiple Customer Accounts (ex. Qualcomm as entity may have Sorrento Valley account and Torrey Pines Account) |
| Customer Name | The name of the Customer, as it will appear on the Invoice |
| Customer Name | Name of the Customer with the outstanding balance |
| Customer Name | Name of the Sponsored Project Customer for which the Invoice look up is performed |
| Date | Date of the transaction |
| Debit Amount | Dollar amount for Debit transactions |
| Default Payment Method | The payment method for the Supplier This method is unique to each Supplier site |
| Department Reporting Category | Is set at the project level. It can be faculty portfolio or department portfolio, depending on who manages the resources. |
| Derived Fund Code | A fund is a code used in IFIS to identify the source of funding for a transaction. When the university receives funding, it is credited to a specific fund that represents the funding source. |
| Description | Description of the Expenditure type |
| Description |
A reference value that provides more information about the transaction
This value is dependent on the Journal Source Receivables = No Value Cash Management = Transaction Description Project - Cost: Transaction Source, External Revenue: Payables = Invoices: , Payments: General Ledger = Journal Line Description |
| Difference - Invoice Distribution Amount | A calculation that takes the difference between the General Ledger - Invoice Distribution Amount and the PPM Costing - Invoice Distribution Amount to highlight where a discrepancy is present |
| Difference - PO Distribution Amount | A calculation that takes the difference between the General Ledger - PO Distribution Amount and the PPM Costing - PO Distribution Amount to highlight where a discrepancy is present |
| Direct Institutional Support | Direct Funds provided by the institution to athletics for the operations of intercollegiate athletics |
| Direct Overhead and Adm Expenses | Overhead and administrative expenses paid by or charged directly to athletics including: -Administrative/Overhead fees charged by the institution to athletics. -Facilities maintenance. -Security. -Risk Management. -Utilities. -Equipment Repair. -Telephone. -Other Administrative Expense |
| Distribution Cost Center Code | Financial Unit Code |
| Distribution Cost Center Description | Financial Unit Description |
| Document | Provides identifiable detail for audit purposes |
| Document Reference |
A reference value that provides more information about the transaction
This value is dependent on the Journal Source Receivables = Receipt Reference Cash Management = Reference Text Project - Cost: Original Transaction Reference Number, External Revenue: Payables = Invoices: <>, Payments: Payment Batch Name General Ledger = No Value |
| Document Status | Current approval status of the transaction |
E - H
| Field Name | Description | |
|---|---|---|
| Earnings Period End Date | Labor Ledger field indicating the end of date of when payroll was earned. This is typically the same as the pay period end date for regular payroll, but may be different for salary cost transfers. Equivalent to the Expenditure Item Date in Oracle PPM. | |
| Effective Burden Schedule | The burden schedule stores the rates and indicates which transactions are burdened, based on cost bases defined in the burden structure. You specify which expenditure types are included in each cost base. | |
| Effective Burden Schedule Multiplier |
|
|
| Effective Burden Schedule Multiplier Level | What level the rate is coming from. It can be project or task level. | |
| Email Address | The email address of the employee | |
| Employee ID | The internal identification number for the employee This uniquely identifies the employee throughout the OFC system |
|
| End Date | The End Date of the Expenditure Type | |
| Ending Balance | The results of Beginning Balance +/- Period Net Activity results in the ending balance If the fiscal period is still open, ending balance represents balance year to date |
|
| Ending Balance | Is the total Debits and Credits, listed separately, of Year Beginning Balances + Prior Periods + Period Activity The Debits and Credits would be added and listed separately It will not include any Periods past the last Period entered in the parameters |
|
| Ending Balance | Total Ending Balance for each report line item | |
| Ending Net Position | Total Resources - Total Expenses + Beginning Net Position July 1 | |
| Ending Net Position | Beginning Net Position +Total Resources - Total Expenses | |
| Endowments, Investments | Spending policy distributions from athletics restricted endowments and investment income used for athletics operations in the reporting year |
|
| Entered Amount CR | Dollar amount for credit transactions | |
| Entered Amount DR | Dollar amount for Debit transactions | |
| Entered Credit Amount | Amount that is accounted for the Receipt | |
| Entity | Think VC area; the official numeric code that represents the VC area or major operational unit in the first segment of the new COA | |
| Entity | Represents the VC area or major operational unit in the first segment of the new COA | |
| Entity | The VC area or major operational unit in the first segment of the new COA | |
| Entity | The official numeric code that represents the VC area or major operational unit in the first segment of the new COA | |
| Entity | The official numeric code that represents the VC area or major operational unit in the first segment of the new COA | |
| Entity Code | Think VC area; the official numeric code that represents the VC area or major operational unit in the first segment of the new COA | |
| Entity Name | Think VC area; the description that corresponds to the official numeric code that represents the VC area or major operational unit | |
| Entity Name | Name of the entity that owns the Receivable | |
| Equipment, Uniforms and Supplies | Items that are provided to the teams only. Equipment amounts are those expended from current or operating funds | |
| Event Type | Event associated with the transaction | |
| Expendable | The Balance that is available for Expenditure at a point in time For current use Gift Funds the Balance comes from New Gifts or Transfers, for Endowments and Funds functioning as Endowment the Balance comes from payout, which is also referred to as Spending |
|
| Expenditure by Sponsor and Sponsor Category | Graph of Expenditure Values: By Sponsor (Graph and List | |
| Expenditure Category | The name of the Expenditure category that classifies the Expenditure type into a Cost group Examples include Operating Expenses, Benefit Expenses, UCSD equipment, etc. |
|
| Expenditure Category | Expenditure Categories are used for grouping Expenditure Types for Costing | |
| Expenditure Comments | Provides explanation and identifiable detail for audit purposes | |
| Expenditure Item Date | Provides identifiable detail for audit purposes | |
| Expenditure Organization Name | Describes source of expense, Provides identifiable detail for audit purposes | |
| Expenditure Type | Classifies expenses into reporting categories | |
| Expenditure Type | Expenditure Type is a POETAF value which interacts with the Project Portfolio Management (PPM) module in Oracle An Expenditure Type is only necessary if the Expense is being charged to a Project When an Expense is associated with a Project, the Expense will post to the ledger according to the Project Expenditure Type rather than the default COA (Chart of Accounts) Account value |
|
| Expenditure Type | What kind of Expense is this? Examples include private gift revenue, lab test and diagnostic services, maintenance and cleaning supplies; these Expenditure Types map to your Chart of Accounts account values For additional information, click here for the current list of Expenditure Types and associated information in Oracle. |
|
| Expenditure Type Description | What is the Expenditure for (ex. Office Supplies) | |
| Expenditure Type Name | Name of the Expenditure (ex. 522403 - Marine Supplies) | |
| Expiration Date | This is the date the certification will expire | |
| Expired Awards | Total Count of Expired Awards | |
| External Transaction Description | Description of the Transaction (ex. AMERICAN EXPRESS DES:AXP DISCNT ID:1040822611 INDN:MED GRP OTOL1040822611 CO ID:1134992250 CCD) | |
| External Transaction Reference | Reference for the Transaction, such as UCSD Parking or UCSD MOORS PHARMACY, etc. | |
| External Transaction Type | Type of External Transaction, such as fee | |
| Financial Unit | Financial Unit is any UCSD unit with an ongoing business objective and budget, a group of employees and generally a physical space This value is an official segment of the Chart of Accounts and should correlate to the owning organization of the Project |
|
| Financial Unit | Numeric Financial Unit Code The Financial Unit is any UCSD unit with an ongoing business objective and budget, a group of employees and generally a physical space This value is an official segment of the Chart of Accounts and should correlate to the owning organization of the Project |
|
| FinU | Financial Unit is any UCSD unit with an ongoing business objective and budget, a group of employees and generally a physical space This value is an official segment of the Chart of Accounts and should correlate to the owning organization of the Project |
|
| FinU Code | Financial Unit (FinUnit) represents a unit with an ongoing business objective, with a responsible individual with fiscal authority over budget and costs, an identifiable group of employees, and generally physical space Every FinUnit must submit its own budget FinUnit will also be used for approvals, routing, and authorizations The first two digits of the FinUnit correlate to the last two digits of the Entity code |
|
| FinU Code | Sport or department associated with the activity | |
| FinU Description | Description of FinUnit | |
| FinU Description | Financial Unit Name, the Financial Unit is any UCSD unit with an ongoing business objective and budget, a group of employees and generally a physical space This value is an official segment of the Chart of Accounts and should correlate to the owning organization of the Project |
|
| FinU Level 2 Code | Official numeric code that represents a Vice Chancellor area or major operational unit | |
| FinU Level 2 Description | Description for FinU Level 2 Code | |
| FinU Level 3 Code | Official numeric code that represents a Division | |
| FinU Level 3 Description | Description for FinU Level 3 Code | |
| FinU Level 4 Code | Official numeric code that represents a Department | |
| FinU Level 4 Description | Description for FinU Level 4 Code | |
| FinU Name | Name of Financial Unit | |
| FinU Value | Financial Unit is any UCSD unit with an ongoing business objective and budget, a group of employees and generally a physical space This value is an official segment of the Chart of Accounts and should correlate to the owning organization of the Project |
|
| FinUnit Description | Financial Unit Name is the Financial Unit is any UCSD unit with an ongoing business objective and budget, a group of employees and generally a physical space This value is an official segment of the Chart of Accounts and should correlate to the owning organization of the Project |
|
| First Creation Date | Date Invoice is created in the system | |
| First Name | The first name of the employee | |
| Fiscal Quarter | The Fiscal Quarter is a known combination of three Accounting Periods according to your fiscal year For example, Qtr1-21 is Jul-20, Aug-20, Sep-20 This allows you to report rolled-up financial transactions for summarized reporting |
|
| Flow Through Entity | Entity where the funds go through from a subaward. | |
| Flow Through Sponsor | For subawards, the agency providing funding to the flow-through entity. | |
| From User | Who created the Journal | |
| Full Chart String from Receivables | Chart of Account (COA) string for the transaction | |
| Full Name | Last name, First name of user | |
| Funct Code | Is an Expense classification that must accompany transactions against Expense Accounts If the transaction is not an Expense, the Function should be 00 |
|
| Funct Description | Name of Fund | |
| Funct Hierarchy L1 Code | Alphanumeric code representing Level 1 of the Function hierarchy | |
| Funct Hierarchy L1 Description | Text description for Level 1 of Function hierarchy | |
| Funct Hierarchy L2 Code | Alphanumeric code representing Level 2 of the function hierarchy, the posting level of the hierarchy | |
| Funct Hierarchy L2 Description | Text description for Level 2 of function hierarchy, the posting level for function | |
| Funct or Cash Flow Description | Function Description | |
| Funct or Cash Flow Value | Function Value | |
| Funct Value | Is an Expense classification that must accompany transactions against Expense accounts If the transaction is not an Expense, the Function should be 000 |
|
| Function | Element of the new Chart of Accounts string that represents the Function or purpose of the activity based on the NACUBO Higher Ed purpose of an expense. Function was called program in the IFIS system Prompt entry format: FN_XXX |
|
| Function | Is an Expense classification that must accompany transactions against Expense Accounts If the transaction is not an Expense, the Function should be 000 |
|
| Function | This is the UCSD Function DFF code value that determines the accounting for Non-Sponsored Projects | |
| Function Description | This is the UCSD Function DFF description that determines the accounting for Non-Sponsored Projects | |
| Functional Unit | Functional Unit under which the outstanding charges fall under | |
| Fund | Fund is the high-level classification of the source of Funds for a transaction and tracks restrictions and designations Prompt entry format: FD_XXXXX |
|
| Fund | Fund is the classification of the source of Funds for a transaction and tracks restrictions and designations | |
| Fund | Focuses on the External Fund restriction for audited financial statement presentation Five Fund categories include Unrestricted, Restricted Expendable, Restricted Nonexpendable, Net Investment, and Agency Funds |
|
| Fund | This is the UCSD Fund DFF code value that determines the accounting for Non-Sponsored Projects | |
| Fund Code | Official numeric code that represents a Fund | |
| Fund Code | Focuses on the external Fund restriction for audited financial statement presentation Five Fund categories include Unrestricted, Restricted Expendable, Restricted Nonexpendable, Net Investment, and Agency Funds |
|
| Fund Code | Description of the Fund | |
| Fund Description | Description of Fund Code | |
| Fund Description | Amount that was entered for the Receipt | |
| Fund Description | This is the UCSD Fund DFF description that determines the accounting for Non-Sponsored Projects | |
| Fund Name | Name of Fund | |
| Fund Value | Focuses on the external Fund restriction for audited financial statement presentation Five Fund categories include Unrestricted, Restricted Expendable, Restricted Nonexpendable, Net Investment, and Agency Funds |
|
| Funding Source | Identifies source of expense | |
| Fundraising, Marketing & Promotions | Costs associated with fund raising, marketing and promotion for media guides, brochures, recruiting publications and such | |
| Future 1 | Currently not in use, reserved for future | |
| Future 2 | Currently not in use, reserved for future | |
| Game Expenses | Game-day expenses other than travel which are necessary for intercollegiate athletics competition, including officials, security, event staff, ambulance, etc. Input any payments back to the NCAA for hosting a tournament | |
| General Ledger - Invoice Distribution Amount | The Invoice Distribution Amount that is reflected on the General Ledger | |
| General Ledger - PO Distribution Amount | The PO Distribution Amount that is reflected on the General Ledger | |
| Gifts | Grouping of Funds that includes endowments and private gifts Foundation Gift Funds begin with the letters A – L Regents Gift Funds begin with M – Z Gift revenue may be budgeted on Account 480000: Pvt Gifts Also includes Endowment payout |
|
| Grand Total | Is a mathematic calculation that sums up the values in the associated row or column | |
| Greater than 180 | Over 180 days late | |
| Guarantees | Amounts paid to visiting participating institutions, including per diems and/or travel and meal expenses. This includes payments made due to game cancellations. | |
| Guarantees | Revenue received from participation in away games This includes payments received due to game cancellations |
|
| Head Coaching Salaries | Compensation, bonuses and benefits paid to all coaches reportable on the university or related entities W-2 and 1099 forms, as well as non-taxable benefits, inclusive of: -Gross wages and bonuses. -Benefits including allowances, speaking fees, retirement, stipends, memberships, media income, tuition reimbursement/ exemptions and earned deferred compensation, including those funded by the state |
|
| Hold Count | The total number of holds on an Invoice This number is derived from OFC at the Invoice Header level |
|
| Hold Name | The name of the hold from Oracle This is the reason why an Invoice would be pending payment |
I - L
| Field Name | Description |
|---|---|
| Inactive Date | The date the vendor has been Inactive Will only populate if Supplier Profile Status is Inactive |
| Inception to Date Expenditures | Inception to Date Expenditures based on parameters provided Click on the performance tile to see the rows that make up the overall count |
| Indirect Cost Recovery | Indirect Cost recovery for the fiscal year - by graph or list |
| InterEntity Code | When functionality within OFC uses this element, values will be the same as Entity |
| Interentity Hierarchy L1 Code | Alphanumeric code representing Level 1 of the Interentity hierarchy |
| Interentity Hierarchy L1 Description | Text description for Level 1 of Interentity hierarchy |
| Interentity Hierarchy L2 Code | Alphanumeric code representing Level 2 of the Interentity hierarchy, the posting level of the hierarchy |
| Interentity Hierarchy L2 Description | Text description for Level 2 of Interentity hierarchy, the posting level for Interentity |
| Invoice Amount | Total amount of Invoice line including tax |
| Invoice Count | Count of Invoices |
| Invoice Creation Date | Date of when Invoice was created |
| Invoice ID | Unique identifier created by Oracle Financials Cloud |
| Invoice Line Number | Line item on the Invoice that identifies a specific product purchased, usually one line per item if there are more than one items as part of the single Invoice |
| Invoice Number | Provides identifiable detail for audit purposes. |
| Invoice Number | Invoice number given to UC San Diego by the vendor. |
| Invoice Number | Unique ID associated with each Invoice |
| Invoice Number | Unique number generated by vendor issuing an Invoice to UC San Diego |
| Invoice Number | Accounts Payable Invoice number associated with the purchase transaction |
| Invoice Number | In the detailed view, individual Invoices are displayed for each Customer |
| Invoice Payment Status | Indicates whether an invoice has been paid |
| Invoice Source | Name of original system from where the Invoice was created |
| Invoice Source Name | Name of original system from where the Invoice was created |
| Invoice Status | Provides identifiable detail for audit purposes |
| Invoice Total Amount | Total Amount outstanding for specific Invoice |
| Invoice Type | Defines if an Invoice is payable or a Credit Memo |
| Invoiced Amount | Total amount of Invoice including Tax |
| Invoiced Amount | Total amount of invoice including tax |
| Item | Item Name (ex. Rug and Towel[300000017439308]) |
| Item Description | More detailed Item description (ex. 2020/2021 Xerox Maintenance/Cost per Copy for Black & White Fleet, Office Machines (includes parts and supplies with the exception of paper)) |
| Journal Batch Name | Worklist item description for the Journal Batch |
| Journal Category | Subledger category for the transaction (Misc. Receipt) |
| Journal Category Name | Name of the Journal Category which define the purpose of Journal entries |
| Journal Created by | User that submitted the Journal |
| Journal Entry Description | Detailed description related to the Journal entry |
| Journal Line Accounted Amount CR | Credit amount of the transaction |
| Journal Line Accounted Amount DR | Debit amount of the transaction |
| Journal Line Description | Description or comments for the Journal line number. |
| Journal Line Entered Credit | Dollar amount for Credit transactions |
| Journal Line Entered Debit | Dollar amount for Debit transactions |
| Journal Line Number | Number of the Journal Line |
| Journal Line Number | Line number of the Journal entry |
| Journal Name | The specific General Ledger Journal that this transaction was posted in |
| Journal Source | Did this transaction come from a subledger? If so, which one? |
| Journal Source Name | Source of the transaction from the subledger (Receivables, Payables, etc) |
| Journal Total Entered Credit | Dollar amount for Credit transactions |
| Journal Total Entered Debit | Dollar amount for Debit transactions |
| Justification | Reason given |
| Last Creation Date | Updated date Invoice is created in the system |
| Last Name | The last name of the employee |
| Ledger | The Ledger is a collection of Financial Accounts that record financial transactions against a Chart of Accounts UCSD has two ledgers, UCSD which represents campus activity and FOUNDATION which tracks Gift Funds |
| Ledger Last Updated By | Who is the person that updated the transaction last? |
| Line Description | A reference value that provides more information about the transaction This value is dependent on the Journal Source Receivables = No Value Cash Management = Transaction Description Project - Cost: Transaction Source, External Revenue: Payables = Invoices: , Payments: General Ledger = Journal Line Description |
| Location | This is the UCSD Location DFF code value that determines the accounting for Non-Sponsored Projects |
| Location | Classifies a transaction by physical location or capitalized Assets |
| Location Code | Classifies a transaction by physical location or capitalized Assets |
| Location Description | This is the UCSD Location DFF description that determines the accounting for Non-Sponsored Projects |
| Location Description | Name of Location |
| Location Hierarchy L1 Code | Alphanumeric code representing Level 1 of the Location hierarchy |
| Location Hierarchy L1 Description | Text description for Level 1 of Location hierarchy |
| Location Hierarchy L2 Code | Alphanumeric code representing Level 2 of the Location hierarchy, the posting level of the hierarchy |
| Location Hierarchy L2 Description | Text description for Level 2 of Location hierarchy, the posting level for Location |
| Location Value | Classifies a transaction by physical location or capitalized Assets |
M - P
| Field Name | Description |
|---|---|
| Managerial Reporting Account Hierarchy L1 Code | Alphanumeric code representing Level 1 of the Managerial Reporting account hierarchy where all Revenue, Expense, and Carryforward Balance accounts roll up into. |
| Managerial Reporting Account Hierarchy L1 Description | Text description for Level 1 of Managerial Reporting Account Hierarchy |
| Managerial Reporting Account Hierarchy L2 Code | Alphanumeric code representing Level 2 of the Managerial Reporting account hierarchy, which categorizes accounts into 3 categories: Total Resources, Total Expenses, and Total Balances. |
| Managerial Reporting Account Hierarchy L2 Description | Text description for Level 2 of Managerial Reporting account hierarchy |
| Managerial Reporting Account Hierarchy L3 Code | Alphanumeric code representing Level 3 of the Managerial Reporting account hierarchy which further categorizes accounts. Total Resources has 2 L3 subcategories: External Revenues and Internal Resources. Total Expenses has 3 L3 subcategories: Compensation Expenses, Non-Compensation Expenses, and Non Operating Expenses/Transfers. Total Balances has 1 L3 subcategory: Carryforward Balance. |
| Managerial Reporting Account Hierarchy L3 Description | Text description for Level 3 of Managerial Reporting account hierarchy |
| Managerial Reporting Account Hierarchy L4 Code | Alphanumeric code representing Level 4 of the Managerial Reporting account hierarchy that further categorizes accounts into more detailed categories. The L4 subcategories represent the report rows on most internal managerial reports. External Revenues has 7 L4 subcategories: Appropriations, Contracts and Grants, Investment Income, Other Revenue., Private Gifts, Sales and Services Educ Activities, Student Tuition and Fees. Internal Resources has 6 L4 subcategories: Care/Guaranteed Payments, Department Clinical Benefits, Core Resource Allocations, Health System Professional Services, Internal Resources Other, and Recharge Income. Compensation Expenses has 5 L4 subcategories: Academic Salaries and Wages, Medical Salaries and Wages, Non Academic Salaries and Wages, Accruals and Other, and Benefits. Non Compensation Expenses has 10 L4 subcategories: Facilities/Equip/Rentals/Repairs, Network and Communications, Other Operating Expense, Professional Svcs Consulting and TES, Software Maintenance and Licenses, Space Rental and Leasing, Student Support, Supplies and Other Services, Travel and Transit, and Utilities. L3 Non-Operating Expenses/Transfer has 2 L4 subcategories: Assessments/Tax/Overhead and Non Operating Expenses. Carryforward Balance has 1 L4 subcategory: Fund Balance, which represents the July 1 Carryforward Balance. |
| Managerial Reporting Account Hierarchy L4 Description | Text description for Level 4 of Managerial Reporting Account Hierarchy |
| Managerial Reporting Account Hierarchy L5 Code | Alphanumeric code representing Level 5 of the Managerial Reporting account hierarchy, the posting level, which is the account number. |
| Managerial Reporting Account Hierarchy L5 Description | Text description for Level 5 of Managerial Reporting account hierarchy, the posting level, which is the account name |
| Managerial Reporting Fund Hierarchy L1 Code | Alphanumeric code representing Level 1 of the Managerial Reporting Fund hierarchy which is All Funds |
| Managerial Reporting Fund Hierarchy L1 Description | Text description for Level 1 of Managerial Reporting Fund hierarchy |
| Managerial Reporting Fund Hierarchy L2 Code | Alphanumeric code representing Level 2 of the Managerial Reporting Fund hierarchy which categorizes Funds into 2 subcategories: Core and Non-Core |
| Managerial Reporting Fund Hierarchy L2 Description | Text description for Level 2 of Managerial Reporting Fund hierarchy |
| Managerial Reporting Fund Hierarchy L3 Code | Alphanumeric code representing Level 3 of the Managerial Reporting Fund hierarchy, which categorizes Funds into 4 subcategories: Core Funds, Contracts and Grants, Other Unrestricted Funds, Restricted Funds |
| Managerial Reporting Fund Hierarchy L3 Description | Text description for Level 3 of Managerial Reporting Fund hierarchy |
| Managerial Reporting Fund Hierarchy L4 Code | Alphanumeric code representing Level 4 of the Managerial Reporting Fund hierarchy, which further categorizes L3 into subcategories. Core Funds has 1 subcategory, Contracts and Grants has 4 subcategories, Other Unrestricted Funds has 3 subcategories, and Restricted Funds has 2 subcategories |
| Managerial Reporting Fund Hierarchy L4 Description | Text description for Level 4 of Managerial Reporting Fund hierarchy |
| Managerial Reporting Fund Hierarchy L5 Code | Alphanumeric code representing Level 5 of the Managerial Reporting Fund hierarchy, which further categorizes more detailed subcategories, for example Level 4 Tuition and Fees at Level 5 is further categorized into Non-Resident Tuition, Professional Supplemental Tuition, Student Services Fee, Self-Supporting Masters Programs, and Summer Tuition |
| Managerial Reporting Fund Hierarchy L5 Description | Text description for Level 5 of Managerial Reporting Fund hierarchy |
| Managerial Reporting Fund Hierarchy L6 Code | Alphanumeric code representing Level 6 of the Managerial Reporting Fund hierarchy, the posting level, which is the Fund number. |
| Managerial Reporting Fund Hierarchy L6 Code | Alphanumeric code representing Level 6 of the Managerial Reporting Fund hierarchy, the posting level, which is the Fund number |
| Managerial Reporting Fund Hierarchy L6 Description | Text description for Level 6 of Managerial Reporting Fund hierarchy, the posting level, which is the Fund name |
| Managerial Reporting Hierarchy L2 Code | Text description for Level 2 of Managerial Reporting fund hierarchy |
| Media Rights | All revenue received for radio, television, internet, digital and e-commerce rights, including the portion of conference distributions related to media rights - if applicable |
| Medical Expenses and Medical Insurance | Medical expenses and medical insurance premiums for student-athletes |
| Memberships and Dues | Memberships, conference and association dues |
| NCAA distributions including tournament rev | Revenues received from all NCAA distributions including NCAA championships reimbursements and payments received from the NCAA for hosting a championship |
| Net Activity | Calculated value of Debit Amount + Credit Amount for the transaction |
| Net Amount | Calculated value of Debit Amount + Credit Amount for the transaction |
| New Award Trend By Sponsor | Award Funding by Sponsor, viewable by Fiscal Year |
| New Grants Within Last 90 Days | Total Count of New Grants established within the last 90 days based on parameters provided Click on the performance tile to see the rows that make up the overall count |
| Non-Sponsored Revenue Amount | All Revenue that has been recorded to the PPM module May not reflect Revenue that was only recognized directly in the General Ledger |
| OFC Account Code | OFC Account code that is associated with the Expenditure Type |
| OFC Account Number | Oracle Account Number of the Customer with the open Invoice |
| OFC Award Number | Award Number in Oracle against which the invoicing is taking place for the Sponsored Project |
| OFC Invoice Number | Invoice Number in Oracle system for which there is a corresponding SPARCM Invoice |
| OFC Username | The SSO username attached to the employee's OFC login details |
| One-Time | Anticipated Resources/Expenditures that will not part of the ongoing Budget on a recurring basis e.g., planned expenses against carryforward balance or other resources expected to be received from other FinUnits |
| One-Time Multi-Year | Anticipated Resources/Expenditures that will not part of the ongoing budget on a recurring basis, but will span a finite number of fiscal years |
| Order | Purchase Order number associated with the P2P transaction within Oracle Financials Cloud |
| Order | Purchase Order number |
| Ordered Amount | Amount of goods and services ordered in Invoice |
| Ordered Amount | Total amount of the Purchase Order including Tax |
| Other | Any operating revenues received by athletics in the report year which cannot be classified into one of the stated categories. |
| Other Operating Expenses | Remaining items included in "Total" but not classified into one of the above categories |
| Other Unrestricted | Non-core, non-SOFI funds that often generate their own revenue and are considered self-supporting, e.g Recharge Funds, Auxiliary Funds, Surplus Sales, Conference Revenue Funds, etc. |
| Outcome | Outcome of the Worklist item |
| Outstanding Amount | Difference Ordered amount and Invoiced amount This is the amount left to be Invoiced on a PO |
| Paid Invoices | Number of paid Invoices |
| Pay Period End Date | Labor Ledger field indicating the end of the period in which the payroll was processed. Equivalent to the Accounting Date in Oracle. |
| Payment Method | Shows method used by payee to complete payment |
| Payment Method Name | Shows method used by payee to complete payment |
| Payment Status | Indicates whether the Invoice has been paid or not |
| Payment Terms Name | When is Invoice supposed to be paid, immediately, in 30, 45, 60 days, etc. (ex. NET 30) |
| Pending Requisition Count | Total number of pending Requisitions within Oracle Financials Cloud |
| Period Activity | Net Period Activity for each report line item |
| Period Beginning Balance | The Balance of the Account as of the start of the given fiscal period |
| Period Ending Balance | The results of Beginning Balance +/- Period Net Activity results in the Ending Balance If the fiscal period is still open, Ending Balance represents balance year to date |
| Period Net Activity | The calculated total of Credits - Debits to show total activity during the given fiscal period |
| Period Net Activity | Net Activity for each report line item |
| Period Net Activity | Are the total Debits and Credits, listed separately, during the Period entered in the parameters of the query |
| Period YTD | Year-To-Date totals for the report line items |
| PO Amount | Amount that the Purchase Order was created for |
| PO Count | Count of individual Purchase Order created within Oracle Financials Cloud |
| PO Create Date | Date PO is created in Oracle system |
| PO Distribution ID | Unique Id to allocate Costs for goods or services to different Charge Accounts There could be multiple Charge Accounts for each shipment line |
| PO Header ID | Unique identifier created by Oracle Financials Cloud |
| PO Number | Unique number associated with each Purchase Order |
| PO Spend Over Time | PO spend amount over time |
| PO Status | Current status of Purchase Order Shows whether PO is open or closed |
| PO Volume Over Time | Number of POs over time |
| Posting Date | Date the Journal Entry is posted |
| Posting Status Description | Posting status of Journal entry |
| PPM Costing - Invoice Distribution Amount | The Invoice Distribution Amount that is reflected on the PPM Costing Module |
| PPM Costing - PO Distribution Amount | The PO Distribution Amount that is reflected on the PPM Costing Module |
| Preparer Email Address | Email address of preparer |
| Preparer Name | The name of the individual who prepared and submitted the Requisition for approvals There is only ever one preparer per Requisition |
| Principal | This is for Endowments and Fund functioning as Endowments only The Balance is comprised of the original Gift, Transfers and Reinvestments of Payout It is not available to be spent This is also sometimes referred to as the corpus or the Book Value |
| Principal Investigator | Controls and monitors the technical direction and academic quality of Research Projects such as laboratory studies or clinical trials Ensures that Projects comply with the terms, conditions, and policies defined by the Sponsor and the Institution Owns ultimate responsibility for the management of the Sponsored Research Award, especially in cases where funding is obtained from federal agencies such as the NIH |
| Program | This is the UCSD Program DFF code value that determines the accounting for Non-Sponsored Projects |
| Program | This is part of Chart of Accounts Associates transactions with a formalized set of system-wide or cross campus activities |
| Program Code | This is part of Chart of Accounts Associates transactions with a formalized set of system-wide or cross campus activities |
| Program Description | This is the UCSD Program DFF description that determines the accounting for Non-Sponsored Projects |
| Program Hierarchy L1 Code | Alphanumeric code representing Level 1 of the Program hierarchy |
| Program Hierarchy L1 Description | Text description for Level 1 of Program hierarchy |
| Program Hierarchy L2 Code | Alphanumeric code representing Level 2 of the Program hierarchy, the posting level of the hierarchy |
| Program Hierarchy L2 Description | Text description for Level 2 of Program hierarchy, the posting level for Program |
| Program Value | This is part of Chart of Accounts Associates transactions with a formalized set of system-wide or cross campus activities |
| Program, Concessions, Novelty sales, Parking | Revenues from: -Game Programs -Novelties -Food and Concessions -Parking |
| Project | Element of the new Chart of Accounts string used by the Oracle Project Portfolio Management (PPM) module to track Projects that are designated as Sponsored, Capital, or General Each project is auto-assigned a unique Project Number Some indexes used in the IFIS system were mapped to projects in PPM Prompt entry format: PJ_XXXXXXX |
| Project | Unique 7 digit # that identifies the Project in system |
| Project | Unique 7 digit # and description that identifies the Project in the system |
| Project | Unique identifier for the Project within the system |
| Project | Concatenated project 7 digit Project Number and Project Name that identifies the Project in the system |
| Project | Identifies the Project in the system |
| Project | Concatenation of Unique 7 digit # that identifies the Project in system and Name assigned to the Project by the department |
| Project & Task | A combination of the Project Number, Project Name, Task Number, and Task Name so that you can group them all together |
| Project Code | Unique 7 digit # that identifies the Project in system |
| Project Class Category | Grouping of Project Class Codes |
| Project Class Code | A way to identify the type of activity the the project is for and is useful for grouping and reporting |
| Project Classification | Project Classification represents Project Class Category + Project Class Code and is a way to identify the type of activity the project is for and is useful for grouping and reporting |
| Project Description | Task associated with the Project where the transaction posted |
| Project Description | Name of Project |
| Project End Date | The End Date associated with the Project Active Projects can have an End Date |
| Project Finish Date | Hidden Field The End Date associated with the Project Please note that Active Projects can have an End Date |
| Project Hierarchy L1 Code | Alphanumeric code representing Level 1 of the Project hierarchy |
| Project Hierarchy L1 Description | Text description for Level 1 of Project hierarchy |
| Project Hierarchy L2 Code | Alphanumeric code representing Level 2 of the Project hierarchy, the posting level of the hierarchy |
| Project Hierarchy L2 Description | Text description for Level 2 of Project hierarchy, the posting level for Project |
| Project Manager | Manages the execution and completion of a single Project Creates budgets, plans, and schedules Sources and allocates resources such as labor, subcontractors, materials, and equipment Tracks physical and financial project performance, changes, and issues Ensures proper Billing and Cost Transfers Communicates status and Project performance to Program Managers and Project executives Project Managers are identified in the system as last name, first name Please be sure your parameter values reflect the proper name structure - Ex. Smith, Joe |
| Project Name | Project Name that identifies the project in the system |
| Project Name | Description of the Project |
| Project Name | Unique alphanumeric name for the Project within the OFC system |
| Project Name | Name assigned to the Project by the department |
| Project Number | Used to group and isolate Expenses when Expenditure Types will not accomplish that goes (Ex: Head vs. Asst coach salaries, Recruiting, Expense, etc) |
| Project Number | 7 digit Project Number that identifies the Project in the system |
| Project Number | Unique 7 digit # that identifies the Project in system |
| Project Organization | Indicates sport or department associated with the expense |
| Project Organization | Sport or department associated with the activity |
| Project Organization | Project Owning Organization (Department) as recognized in the PPM |
| Project Start Date | The Start Date associated with the Project |
| Project Status | The current status of the Project, possible options are: Active - the Project is open to accept incoming charges and transactions Closed - the Project is no longer accepting incoming charges and transactions UCSD Closed - the Project is Pending Close in the system It technically is open for transactions but should not be actively used |
| Project Status | Represents the status of the Project The Project status type controls which processes are allowed during each stage of a Project Oracle Fusion Projects provides the following predefined project statuses Values include: Active, Closed, UCSD Closed and Rejected |
| Project Task | Unique identifier for the Receipt within the system |
| Project Type | Designates the Project use within the OFC system, possible options are: UCSD General Project, UCSD General Project with Burdening, UCSD Capital Project, UCSD Default Project, UCSD Sponsor Project |
| Project Type | Refers to General, Sponsored or Capital |
| Project Value | Unique 7 digit # that identifies the Project in system |
| Purchase Order | Unique ID associated with each Purchase Order |
| Purchase Order Amount | Total amount of the Purchase Order including Tax |
| Purchase Order Amount | Total amount of the Purchase Order not including Tax |
| Purchase Order Distribution Amount | Amount values that are associated to the Purchase Order at the distribution level These values take into account any split Funded Purchase Orders |
| Purchase Order Number | Unique ID that is given to each Purchase Order |
| Purchase Requestor Name | Name of Purchase Order requester |
Q - T
| Field Name | Description |
|---|---|
| Receipt Accounted Amount | Dollar amount accounted for the Receipt |
| Receipt Comments | Comments entered during the Receipt creation These could be customer specific comments, or bank comments related to the electronic transaction or cashier's comments provided with the payment, etc. |
| Receipt Comments | Comments made when the Receipt was entered |
| Receipt Customer Reference | Customer reference for the Receipt |
| Receipt Date | Date of the Receipt (date when Receipt was entered in the system) |
| Receipt Entered Amount | Dollar amount entered for the Receipt |
| Receipt ID | Internal unique identifier of the Transaction within the system |
| Receipt Method | ACH/Wires, Check-Campus, etc. |
| Receipt Number | Unique identifier for the Receipt within the system |
| Receipt Number | Date when the Receipt was created |
| Receipt Number | A unique identifier for the Receipt |
| Receipt State | State of the Receipt (ex. Applied, Reversal user error, etc.) |
| Receipt State Code | What is the state of the Receipt, applied, unapplied, unidentified, reversed, etc. |
| Receipt Type | Standard of Miscellaneous |
| Receipt Type Code | CASH or other values |
| Recruiting | Transportation, lodging and meals for prospective student athletes and institutional personnel on official and unofficial visits, telephone call charges, postage and such. Include value of use of institution's own vehicles or airplanes as well as in-kind value of loaned or contributed transportation |
| Recurring Core Budget | The recurring approved annualized plan of operations for the university. It is adjusted during the annual budget process to reflect changes with continuing impact Typically, only Core Funds have core recurring budgets The Core Recurring budget was previously called the permanent budget Permanent budget balances were stored in the Permanent Budget System in the Budget Master File but are now referred to as Core Recurring budget in the Oracle EPBCS Planning and Budgeting System |
| Remaining Budget including Commitments and Revenue | Calculated value that is Budget + Revenue - Total Cost - Total Committed |
| Remaining budget Including Committed Costs | Remaining Budget for Awards based on parameters |
| Remaining Budget with Revenue | This is a calculated column of the Budget + Revenue Amount - Total Cost Revenue amounts reflected here must be recorded to the PPM module If your Revenue only hit the General Ledger, it will not be available in this calculated column |
| Remaining Budget without Revenue | This is the calculated amount of the Budget - Total Cost |
| Req to PO Time in Days | The total number of days that it took from Requisition Submission Date to PO Create Date This time is considered how long it took for a Requisition to be converted to a Purchase Order |
| Requester Full Name | The name of the individual who requested the item within the requisition There can be multiple requesters per Requisition |
| Requisition | Unique identifier for a Requisition (ex. REQ00076396) |
| Requisition Approval Amount | Total sum amount of the Requisition that was approved |
| Requisition Approved Date | The date that the Requisition within Oracle Financials Cloud was approved Only approved Requisitions will contain this date |
| Requisition Approved Date | The date that the Requisition within Oracle Financials Cloud was approved Only approved Requisitions will contain this date |
| Requisition Description | Detailed description of the Requisition |
| Requisition Header Amount | Total sum amount of the Requisition that was approved |
| Requisition Header ID | OFC value that is unique to each Requisition This value is used to direct users to the OFC UI |
| Requisition Line Amount | Total amount of line amounts on a Requisition |
| Requisition Number | The unique identifier within Oracle Financials Cloud that denotes a Requisition |
| Requisition Tax Amount | Total tax amount of the Requisition that was approved |
| Resources Available |
The Current Resources available based on the Accounting Period provided in parameter; depending on the report, calculated as:
|
| Revenue Balance | This is the calculated amount of the Revenue Amount - Cost |
| Revenue Balance with Committed Cost | This is the calculated amount of the Revenue Amount - Cost - Total Committed Cost |
| Revenue Category | The Revenue Category classifies the Expenditure Type into a Revenue Group Examples include Capital Expense, Direct Costs, Program Income, Indirect Costs, and other sources |
| Reversal Reason | Reason for the Reversal of the Receipt |
| Reversal Reason Code | System code for the Reversal |
| Revision Number | Unique ID given to each revision |
| Role | The employee's assigned role within the OFC system |
| Royalties, Licensing, advertisements, Sponsorships | Revenues from: -Sponsorships -Licensing Agreements -Advertisement -Royalties |
| Site | OFC Supplier profile used to make the Invoice payment |
| Site | The Vendor profile that can be used for PO, Invoices and Payments |
| Site | Bill (Bill-to), Ship (Ship-to), Correspond (Statements), send reminders to pay (Dunning) |
| Site Account Address Set | Address set associated with the Account Profile: ENTERPRISE (across business units, since it could be separate for Campus, Health, PG, PH, etc) |
| Site Address Line 1 | Line 1 of the Address (ex. 123 Main St.) |
| Site Address Line 2 | Line 2 of the Address (ex. Suite 200) |
| Site City | City of the Address |
| Site Primary Purpose Indicator | Primary indicator for the site, usually defaulted to Bill-to, since specific site can have multiple site purposes |
| Site Profile Class | Class associated with the Customer Site (ex. Federal, Foreign, Local, Private, Public, State, etc.) |
| Site Profile Class Description | Class description associated with the Customer Site (ex. Federal, Foreign, Local, Private, Public, State, etc.) |
| Site Profile Delivery Method | Preferred method for the Customer for Invoice Delivery (auto-generated and emailed or printed and delivered by the department) |
| Site Profile Generate Bill Indicator | Indicated if the Invoices will be generated for this Customer site |
| Site Purpose | Purpose of the specific site, such as to Bill (Bill-to), Ship (Ship-to), Correspond (Statements), send reminders to pay (Dunning) |
| Site State | Postal Code State abbreviation (ex. 'CA' for California) |
| Source | Did this transaction come from a subledger? If so, which one? |
| Source AP Source Name | Where did the transaction originate from (ex. Manual invoice entry vs. UCSD Transcepta) |
| SPARCM Invoice Number | SPARCM Invoice Number for which the look up is being made |
| Spirit Groups | Include support for spirit groups including bands, cheerleaders, mascots, dancers, etc |
| Sponsored Flag | Y/N - Designates if the Project is Sponsored or not The report shows only Projects with Sponsored Flag = N |
| Sports Camp Expenses | All expenses paid by the athletics department, including non athletics personnel salaries and benefits, from hosting sports camps and clinics |
| Sports camp revenues | Revenues received by the athletics department for sports camps and clinics |
| Start Date | If a business certification has a issued This is the date the certification was given |
| State | Current status of the Worklist item |
| Status | Status of the Receipt (ex. Active) |
| Student -Athlete Meals (non travel) | Meal allowance and food/snacks provided to student athletes |
| Student Fees | Student fees assessed and restricted for support of intercollegiate athletics |
| Summary | Links to the Full Transfer details |
| Supplier | Provides identifiable detail for audit purposes |
| Supplier | Supplier Name |
| Supplier | Supplier is composed of Supplier Number and Supplier Name This value is the company that was utilized to fulfil an product or service |
| Supplier Name | Supplier Name |
| Supplier Number | Unique ID that is given to each Supplier |
| Supplier Profile Status | This is the status that allows you to see if a Vendor is active within in the system |
| Supplier Site Status | It can be active, if the site is active and available for use of payment. If conditions are the opposite, it is inactive. |
| Sys18 ID of User | Sys18 ID of User |
| Task | Allows the Project to be divided into smaller subsets for Project Cost management within the Project Portfolio Management (PPM) |
| Task | This is the Task Number that allows the Project to be divided into smaller subsets for Project Cost Management within the Project Portfolio Management (PPM) The Task breakdown is only available within the PPM module and will not be visible in the General Ledger (GL) |
| Task Manager | Individual that has been identified in the system as responsible for a Task within a Project Task Managers are identified in the system as last name, first name Please be sure your parameter values reflect the proper name structure - Ex. Smith, Joe |
| Task Name | Description of the Task |
| Task Name | This is the Task Name that allows the Project to be divided into smaller subsets for Project Cost Management within the Project Portfolio Management (PPM) The Task breakdown is only available within the PPM module and will not be visible in the General Ledger (GL) Task-level transactions are rolled up and reported to the GL as sum values against the project; this is due to the UCSD design configuration |
| Task Number | Used to group and isolate Expenses when Expenditure Types will not accomplish that goes (Ex: Head vs. Asst coach salaries, Recruiting, Expense, etc) |
| Task Number | This is the Task Number that allows the Project to be divided into smaller subsets for Project Cost Management within the Project Portfolio Management (PPM) The Task breakdown is only available within the PPM module and will not be visible in the General Ledger (GL). Task-level transactions are rolled up and reported to the GL as sum values against the Project; this is due to the UCSD design configuration |
| Task Organization | Task Owning Organization (Department) as recognized in the PPM module |
| Team | The department to which the employee is assigned |
| Team Travel | Air and ground travel, lodging, meals and incidentals (including housing costs incurred during school break period) for competition related to preseason, regular season and non-bowl postseason. Amounts incurred for food and lodging for housing the team before a home game also should be included. Use of the institution's own vehicles or airplanes as well as in-kind value of donor-provided transportation |
| Ticket Sales | Revenue received for sales of admissions to athletic events This may include: · Public and faculty sales · Student sales · Shipping and Handling fees |
| Top 10 Active Awards by Budget | Current Budget Amount by Award for the to 10 active |
| Top 10 Overspent Awards | Burn rate for the top 10 Overspent awards - by graph or list |
| Total | Total of ALL activity in PPM for all project owning orgs |
| Total | Total general ledger revenue activity for Intercollegiate Athletics |
| Total Amount | Total amount of the Purchase Order including Tax |
| Total Applied Amount | Dollar amount for applied portion of the Receipt |
| Total Beginning Balance | Total of Beginning Balance for selected Periods |
| Total Committed Cost | This is the Sum of Commitments from Purchase Requisitions, Purchase Orders, Supplier Invoices, and External Commitments, including Raw and Burdened Costs |
| Total Committed Raw Cost | This is the Sum of Commitments from Purchase Requisitions, Purchase Orders, Supplier Invoices, and External Commitments, NOT including Burdened Costs |
| Total Cost | This is the total Cost associated with the Project and Task |
| Total Cost | This is the total cost associated with the Project and Task |
| Total Ending Balance | Total of Ending Balance for selected Periods |
| Total Expenses | Total of Expense Accounts according to the Managerial Reporting Account hierarchy, calculated YTD from fiscal year start through the Accounting Period provided in the parameter |
| Total of all Categories | Total of all of the above categories |
| Total of all categories | Total of all transactions into previous categories |
| Total Period Net Activity | Total of Period Net Activity for selected Periods |
| Total Resources |
Combination of External Revenue and Internal Resources according to the Managerial Reporting Account hierarchy, calculated YTD from fiscal year start through the Accounting Period provided in the parameter |
| Total Tax Amount | Total amount of the tax on the Purchase Order |
| Total Unapplied Amount | Dollar amount for unapplied portion of the Receipt |
| Total Unbudgeted Awards | Unbudgeted Amount by Sponsor, Viewable by Award |
| Transaction Class Code | ex. INV |
| Transaction Date | Date when the Transaction occurred |
| Transaction Number | Provides identifiable detail for audit purposes |
| Transaction Number |
A reference value that provides more information about the transaction
This value is dependent on the Journal Source Receivables = Receipt Number Cash Management = Transaction Number Project - Cost: Expenditure Item, External Revenue-Revenue distribution number: Payables = Invoices: Invoice Number, Payments: Check Number General Ledger = Journal Batch ID |
| Transaction Number | System number that will equate to the Receipt Number |
| Transaction Number | Unique identifier within the system |
| Transaction Number | Unique identifier for the transaction |
| Transaction Source | Provides identifiable detail for audit purposes |
| Transaction Status | Status of the transaction (ex. Incomplete, Complete) |
| Transaction Status (Description) | Description of the transaction status |
| Transaction Type | What type of transaction is this? |
| Transfer Status Code | Indicator if a transaction moved to the corresponding subledger, PPM or AP, etc. Values are ‘Y’ or null |
| Transfer To | Type of Adjustment and the Direction |
| Transferred By | Name of user who performed the Transfer or adjustment |
| Type | Type of transaction, usually states SHOPPING |
U - Z
| Field Name | Description |
|---|---|
| Unallocated Amount | Total Dollar Amount Unallocated based on parameters provided Click on the performance tile to see the rows that make up the overall count |
| Unbudgeted Amount | Total Dollar Amount Unbudgeted based on parameters |
| Unpaid Amount | Dollar amount of unpaid Invoices |
| Unpaid Invoices | Number of unpaid Invoices |
| Validation Status | Indicates whether the Invoice has been validated or not |
| WF Status | Workflow Status - this is the status of the approval workflow for this Cost adjustment |
| Workflow Participant | Approver Group Name for the Worklist item |
| Year Beginning Balance | Is the starting total Debits and starting total Credits for the fiscal year listed out separately |
| Year End Balance | Total for report line item for the whole fiscal year |
| YTD Net Position | Total for report line item from Period 1 to End Period selected |
Numerical
| Field Name | Description |
|---|---|
| # Awards Underspent | Count of Underspending Awards based on parameters |
| # of Awards > 80% Budget Spent | Count of Awards Spending at over 80% the Budget based |
| # of Awards Overspent | Count of Overspent Awards based on parameters |
| 0 to 30 | Charges past due within 30 days late. |
| 120 to 180 | Charges past due within 180 days late |
| 31 to 60 | Charges past due within 60 days late |
| 61 to 90 | Charges past due within 90 days late |
| 91 to 120 | Charges past due within 120 days late |
Acronyms
| Field Name | Description |
|---|---|
| BAH | Business Analytics Hub |
Find answers, request services, or get help from our team at the UC San Diego Services & Support portal.