UD Financials Data Definitions |
|
Additional Help
The Office of the Vice Provost for Research Copyright © 2006,
University of Delaware Last updated
|
Data Definitions
|
Account—(six alphanumeric characters that characterize a transaction)
Transfers and allocations:
Accounting Period—Defines the month of the fiscal year as follows:
Analysis Type—(three characters) An identifier that distinguishes different types of costs in projects. Use with UOD_PROJ_RES_VW. You can view (or print) a list of important analysis types from the UDFS Training web site. A B C D E F G H I J K L M N O P Q R S T U V W X Y Z C Class—(three numeric characters) Chartfield3 (User Field)—(ten numeric characters) A B C D E F G H I J K L M N O P Q R S T U V W X Y Z Department—(five numeric characters) Field is used to identify administrative unit for each Purpose code. Five numeric characters. The use of the Department chart field allows for advanced reporting and is used in other financial processes. Department value is automatically filled in by the SpeedType selected. A B C D E F G H I J K L M N O P Q R S T U V W X Y Z F Facilities & Administrative (F&A) Costs—Facilities & Administrative (F&A) costs are indirect costs charged to external grants/contracts and carry the 195000 account value (and the SFA analysis type). These charges are designed to cover the costs of administration associated with research at the University. Charges are incurred daily through the Grants F&A process and are summarized for the general ledger monthly. UD Financial System users should recognize the following differences:
Fringes—Fringe Benefits are charged on the 129### series of account values and are processed monthly through an allocation managed by General Accounting. The charges are available for review by users only after the accounting period/month has ended. Current fringe rates. Fund—(five alpha characters) Identifies operating, non-operating, and agency funds as follows:
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z P Program—(five alphanumeric characters) Field to define type of expense such as instruction, research, scholarships, etc. Will not be used with Purpose codes for Asset, Liability, Agency, NOPLT (BLDG and RNOV85) or Purposes for basic revenue only. Examples (not complete list):
Project ID—(fifteen alphanumeric characters) This 15-character alphanumeric Chartfield identifies contract and grant activities and facilities projects. Project ID values are created by adding particular designators for fiscal year, building, or other coded details to the 10 characters in the "Purpose" (e.g., ARTC372111 Purpose=ARTC37211199000 Project ID). Combining a Contract & Grant Project ID with a non-related Purpose on a transacation, tags that transaction as a Cost Share transaction for that Grant/Contract (e.g., ARTC37211199000 used with ARTC17S000 will be assigned a CGE analysis type). Purpose—(ten or fewer alphanumeric characters) Purpose is the key chart field defining the funds used for a transaction. This field is used to assign row level security within the reporting environment. Asset and Liability Purposes begin with a letter A or L followed by numbers. These codes are six characters long, other codes are 10 characters long. For non-asset or liability codes the following is true: The first four characters will identify major unit. Next two characters will generally be as follows:
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z S Scenario—Value varies by the account or the process creating the transaction. For salary transactions, Scenario is used to identify the Effort Period for that pay. For ProCard transactions, Scenario field is used to define the last 6 digits of the Pro Card used for the purchase. Source—(eight numeric characters) Field will be used for contracts and grants agency information (e.g., 3303050000 OFFICE OF NAVAL RESEARCH). Field will be used to tag and track State Appropriations for Operations, State Special Lines, and Capital State items. It will also be used to track source of funds backing expenditures for capital projects, including State and other sources (e.g., 6100000000 UNIDEL FOUNDATION). View some examples. A B C D E F G H I J K L M N O P Q R S T U V W X Y Z U UOD_ACCOUNT_DESC—Descriptive name of the Account chartfield. UOD_BEG_FISC_BAL—Balance at the beginning of the fiscal year. UOD_BUDGREF_DESCR—The budget year. Not populated yet. UOD_CHRTFLD1_DESCR—Descriptive name of the Purpose Chartfield. UOD_CHRTFLD2_DESCR—Descriptive name of the Source Chartfield. UOD_CHRTFLD3_DESCR—Descriptive name of the User Chartfield, which tags transactions with a code that each UDFS user can unterpret as (s)he finds useful. Not populated yet. UOD_CURR_DEOBL_AMT—Total deobligations to date. UOD_CURR_FISC_BAL—Current month's transactions for the Accounting Period. UOD_DEPTID_DESCR—Descriptive name of the department. UOD_ENC_ID—Encumberance ID: Defined by user to identify an obligated item. UOD_END_FISC_BAL—Beg_Fisc_Bal plus all transactions in the fiscal year. UOD_END_FSC_BAL_PR—Equivalent to the END-FISC-BAL value of that accounting period in the prior fiscal year. UOD_FUNDCODE_DESCR—Descriptive name of the Fund Code. UOD_GLADJUST_DESCR—Descriptive name of the Adjustment Type. UOD_NET_BUDGET—Net Budget: Beginning budget plus all temporary OR permanent changes. UOD_NET_BUD_PR_YR—Net Budget for the Prior Year. UOD_NET_PERM_BUD—Net Perm Budget: Begining budget plus ONLY permanent changes. UOD_ORIG_AMOUNT—Original amount of the obligation. UOD_PERM_CHNG_BUD—Perm Change Budget: All permanent changes to the budget. UOD_PROGRAM_DESCR—Descriptive name of the Program Chartfield. Not populated yet. UOD_PROJECT_DESCR—Descriptive name of the Project Chartfield. UOD_PROJ_TO_DT_ACT—Project to Date Actuals: Transactions (Revenue Expense) from the Actuals Ledger that carry a Project ID. UOD_PROJ_TO_DT_BAL—Project to Date Balances: Project to Date Budget LESS the Project to Date Actuals. UOD_PROJ_TO_DT_BUD—Project to Date Budget: Budget Transactions which carry a Project ID. UOD_REMAINING_AMOUNT—Original amount less any deobligated amounts. UOD_SCENARIO_DESCR—Descriptive name of the Scenario Chartfield. UOD_START_BUDGET—Beginning Budget for a fiscal year. A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
|