Skip to main content

System Status: 

Data Glossary

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 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 Purpose The Award purpose helps you understand the basic purpose of the Award
For example, Academic Support, Research, and Student Services
Award Start Date This is the Start Date of the Award
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 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 Name Name of the 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
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
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
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
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
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 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:

  • Ending Net Position - Capital Equipment (GL Project Balances)
  • Ending Net Position - Capital Assets (Financial Deficit Report - Operating Funds)
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
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.