What are Cross Validation Rules (CVRs)?


Overview


This article provides a comprehensive list of Cross Validation Rules (CVRS) including Health System, Financial and Gift, Capital, Sponsored Research and more. Cross Validation Rules are logic configured into the system preventing users from entering segments in a chart string that can not be combined.
 

Essential Information


Next Steps 


 CVRs that result in errors

Overall

 
Chart String Segments

CVR Description:

Financial Unit and Entity

The first 2 digits of the Financial Unit must be the same as the last 2 digits of the Entity.

Each Financial Unit can only be associated with one Entity.  If the Financial Unit entered is not in the appropriate Entity, there will be an error.

Function and Account

A value for Function (other than 000) is used when:

  1. Account on the chart string is an Expense Account or 
  2. One of the following Asset Clearing Accounts is used:
    • 163001 - Equipment In Process
    • 163003 - Equipment Clearing
    • 163151 - Software In Process less than or equal to $5M
    • 163101 - Software In Process greater than $5M

If the Account value meets the criteria above, determine the appropriate Function values.  Refer to additional guidance on Function Values in KBA: How to Determine a Chart String (CoA Reference Guide)

Example:  Function will have a value of 000 if the Account in the chart string is a Liability Account (starts with 2).  If the Account is an Expense Account a Function value of 000 will create an error due to CVR.

 
 

Health System 

 

Chart String Segments

CVR Description:

Medical Center (MC) Entity and Function 420 Teaching Hospital

When MC Entity 16242 has an Expense, the only Function that can be used is Function 420 Teaching Hospital. 

And vice versa, Function 420 Teaching Hospital can only be used by MC Entity 16242.  

Medical Center (MC) Entity, Account, and Financial Unit

When MC Entity 16242 is in the chart string and the Account is an Asset, Liability or Equity (starting with 1, 2, or 3, respectively), the only Financial Unit that can be used is 4200100 Balance Sheet Accounts Only..

Physician Group (PG), Entity, Account, and Financial Unit

When PG Entity 16143 is in the chart string and the Account is an Asset, Liability or Equity (starting with 1, 2, or 3, respectively), the only Financial Unit that can be used is 4310162 Balance Sheet.

Physician Health Svc Orgn (PHSO) Entity, Account, and Financial Unit

When PHSO Entity 16144 is in the chart string and the Account is an Asset, Liability or Equity (starting with 1, 2, or 3, respectively), the only Financial Unit that can be used is 4441035 PPH BS Reserved.

EPIC Revenue Accounts and Medical Center (MC) Entity

When posting to the following EPIC Revenue Accounts, the Entity in the chart string must be MC Entity 16242.

  • 451102-451224
  • 456102-456224
  • 457102-457224
  • 458102-458224
  • 459102-459224

If the above Revenue Accounts are used and the Entity is not 16242, there will be an error.

EPIC Revenue Accounts and Physicians Group (PG) Entity and 

When posting to the following EPIC Revenue Accounts, the Entity in the chart string must be PG Entity 16143.

  • 421201-421224
  • 426201-426224
  • 427201-427224
  • 428201-428224

If the above Revenue Accounts are used and the Entity is not 16143, there will be an error.

 
 

Foundation & Gift 

 
Chart String Segments

CVR Description: 

Fund (Foundation Agency) and Financial Unit 

Foundation Agency Fund 50001 can only be used with Financial Unit 9700001 UCSD Foundation.

Fund (Foundation Agency) and Account

Foundation Agency Fund 50001 can only use the following Accounts:

  • 100000 - Interfund Cash Account
  • 120014 - UCSD Fdn Student Pledge Receivable
  • 105001 - Foundation Agency Cash
  • 105002 - Foundation STIP Income Agency
  • 105003 - Foundation Credit Card Agency
  • 105004 - Foundation Events Credit Card Agency
  • 237313 - UCSDF Student Pledge Payable

Fund (Gift and Endowment) and Account

Recording of Gift Revenue should to go through Gift Processing Services

When a Gift and Endowment Fund is on the the chart string, only Revenue Accounts fitting one of the following criteria can be used: 

  • 480xxx - Private Gift Revenue
  • 741000 - Income on Investments (STIP Distribution)
  • 870xxx - Capital Gifts and Grants Revenue

Restrictions are not placed on Asset, Liability, Equity and Expense Accounts.


 

Capital 

 

Chart String Segments

CVR Description:

Capital Funds and Financial Unit

Funds that fall under the following Fund criteria:

  • Net Investment In Capital (4xxxx)
  • Capital Construction (173xx)
  • Retirement of Debt (178xx)

The above fund can only post to one of these Financial Units:

  • 9699908 - Campus Operations NICA
  • 4200100 - Balance Sheet Accounts only for MC
  • 4310162 - Balance Sheet for PG
  • 4441035 - PPH BS Reserved for PHSO

If the Financial Unit is not one of the above for the Funds listed, there will be an error.

Capital Funds and Account

Capital Funds with any one of the following Fund criteria:

  • Net Investment In Capital (4xxxx)
  • Capital Construction (173xx)
  • Retirement of Debt (178xx)

The above funds can NOT post to the following Accounts:

  • Revenue accounts (starts with 4) 
  • Salary Expense Accounts from 500000-519999

 

Sponsored Research 

 

Chart String Segments

CVR Description:

Sponsored Research Funds and Project

All Sponsored Project Funds must have a Project Value.  

If Project value 0000000 is entered when the Fund on the chart string is a Sponsored Project Fund, there will be an error.

Sponsored Research Funds and Account (Petty Cash)

Sponsored Research Funds can not have transactions on Petty Cash Accounts.  

The following Accounts are NOT permitted with when a chart string has a Sponsored Research Fund: 

  • Petty Cash Accounts in range 101000-101999
  • Expense Account 522204 Petty Cash Reimbursements

Sponsored Research Funds and Account (Liability/Expense)

Sponsored Research Funds can NOT have transactions on Expense Account 531001 General Liability Program GAEL

Sponsored Research Funds and Accounts (Recharge)

Sponsored Research Funds can not have transactions with Recharge Accounts.  

The following Accounts can not be in the same chart string as a Sponsored Research Fund, otherwise there will be an error:

  • 734xxx
  • 775xxx
  • 777xxx
  • 773xxx

Sponsored Research Funds and Function

The following Functions are the only Functions that can be used when the chart string has a Sponsored Project Fund:

  • 400 - Instruction
  • 440 - Research
  • 620 - Public Service
  • 680 - Student Services
  • 780 - Financial Aid
  • 600 - Libraries
  • 430 - Academic Support
  • 000 - For non expense transactions.  

Refer to Function and Account rules above for when Function 000 is acceptable.

 

Other

 

Chart String Segments

CVR Description:

Activity and Account (Credit Card Clearing)

When there is a transaction on Account 101030 - Credit Card Clearing, the chart string segment Activity must be populated (not 000000), otherwise there will be an error.

Funds (SOFI) and Account

When the following SOFI Funds are in the chart string:

  • 13991 University Core Funds
  • 13992 Campus Core Funds

Account must be one of the following:

  • Expense Account starting with 5 or
  • Liability Account starting with 2 or
  • Account 100000 for inter-balancing transactions
  • One of the following Asset Clearing Accounts:
    • 163001 - Equipment In Process
    • 163003 - Equipment Clearing
    • 163101 - Software In Process greater than $5M
    • 163151 - Software In Process less than or equal to $5M
    • 310000 - System Control Net Income

Financial Control Asset Account, Financial Control Fund, and Financial Unit

Asset Accounts for Financial Control, Accounts starting with 102xxx can only use 

  • Fund 13027 Financial Control and
  • Financial Unit 9699902 Campus Operations for General Accounting.

Questions?


If you need any additional assistance, please submit a ticket here.