The general ledger accounting number, stored in an accounting flexfield in the Oracle database, is comprised of twenty-four digits, and six segments as listed below. To see a report listing the values for each segment, click on the segment name.
If you encounter difficulty exporting this data to Excel, or setting the output default to Excel, click here for assistance.
Five digit numeric segment; segment values must be greater than 00000
Grant & Contract Principal Investigators have been assigned a unique department number within their base department (XXX50-XXX59). For example, all grants/contracts for PI number one in department 67900, will be assigned to department 67950. PI number 2's grants/contracts will be assigned to department 67951 etc.
The object code segment values can be expanded to give departments more flexibility. For example the base number for office supplies is 73150. The office supply object code was expanded by adding digits 1through 9 to the end of the object code. (73151-office supplies-A, 73152-office supplies-B, etc.). The other income object code 59000 has also been expanded (59001-other income-group A, 59002-other income-group B). This is not an automatic process. Please contact the RIT Service Center to request that a particular object code be expanded.
Object code types:
Certain Projects may only use certain revenue or expense object codes:
May not use Permanently Restricted Revenue Object Codes
Credit 57350, Endowment Distribution Revenue Object Code
Only the Accounting or Budget Department is allowed to process journal entries using Transfer (63000-63199) and Capital Equipment (16200-16250) object codes. If you require that a journal entry be processed using one of these object codes, please send a memo to the appropriate department requesting the entry.
The FEC for each department's operating account is defined in the system. For example, if the department's function is "Instruction", the FEC is 10. If any FEC other than 10 is entered, an error message will display on the screen.
Capital equipment accounts: project number of 84200.
There are two unique project number ranges used to represent NTID’s Operating accounts – the NTID Federally Funded Operating project range, 01999-020XX, and the NTID Non-Federally Funded Operating project range, 03009-030XX. The last two digits of these project numbers change annually at the beginning of NTID's fiscal year (October 1 – September 30). These projects are used to track NTID expenditures by fiscal year. Each year the project number changes on October 1st to coincide with the new fiscal year (i.e., FY 2009 – Project 02009 and Project 03009). For more information about accounting for Federal and Non-Federal Funds, refer to the information on the Controller's Office web page.
Cross-validation rules have been set up in the ledger to ensure that only valid/allowable combinations can be set up. This ensures the accuracy of the University’s external financial reporting. If a cross-validation rule is violated, an online error message will appear on the user's tool bar and the user will not be able to complete the transaction until the error has been corrected. If you encounter this type of error, request assistance through this RSC Catalog Item.