Data Glossary

Last Updated: April 21, 2023 1:46:40 PM PDT

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.