CONTROLLER
DIVISIONS
Research Accounting Office
Definitions of Columns in the RIF Spreadsheets
| Column Title | Column | Definition |
|---|---|---|
| Admin Area | A | The Administrative Area Number where the account (col C) was administered |
| Mnemonic | B | The Mnemonic where the account (col C) was administered. |
| Acct Number | C | The account number established to administer the project. |
| Acct Begin Date | D | The beginning date of the period of performance for the account (col C) |
| Acct End Date | E | The ending date of the period of performance for the account (col C) |
| Acct Close Date | F | The date the account (col C) was closed. If the date is listed as any date in the future, the account is still open. |
| Budget | G | The budget and location code derived from the account number (col C) |
| Fund | H | The fund number derived from the account number (col C) |
| Award Amount | I | The total award amount associated with the account number (this could differ from the contract award amount) |
| Award Amount / PI | J | This is a derived field. The result is by taking the total award amount and multiplying by the "%% contibuted" column. |
| Account Name | K | This is the name associated with the account (col C) in IBIS |
| Agreement | L | This is the agreement number associated with the account (col C) in IBIS |
| Agency Code | M | This is the agency code of the sponosring agency of the agreement (if applicable) |
| Agency Name | N | This is the long name associated with the agency code |
| PSU ID | O | This is the PSU ID number of the individual associated with the account as listed in the RIF data |
| Prj Corres Last Name | P | This is the project correspondent associated with the agreement for this account |
| Emp Name pref | Q | This is the employees "preferred name" that is associated with social security number listed on the account |
| name sort field | R | This is a concatenation of the fields in IBIS "last name", "first name", and "middle name" used for sorting purposes |
| Res Category | S | This is the area of research as indicated on the AURA form |
| %% contributed | T | This is the percentage of "ownership" attributed to this faculty member within this area of research on this account |
| Home Budget | U | This is the "home budget" assigned to the faculty |
| FO Name | V | This is the name of the FO listed in IBIS that is associated with the "home budget" (col U) |
| FO# | W | This is the FO number listed in IBIS that is associated with the "home budget" (col U) |
| Home AA | X | This is the Administrative Area number associated with the "home budget" (col U) |
| Home Mnemonic | Y | This is the mnemonic associated with the "home budget" (col U) |
| Income | Z | This is the total income recorded in the administered account (col C) |
| Income / PI | AA | This is a derived field.The result is by taking the total income amount and multiplying by the "%% contibuted" column. |
| Expense | AB | This is the total expense recorded in the administered account (col C) |
| Expense / PI | AC | This is a derived field.The result is by taking the total expense amount and multiplying by the "%% contibuted" column. |
| Total Overhead | AD | This is the total overhead (all 900's) recorded in the administered account (col C) |
| Overhead / PI | AE | This is a derived field.The result is by taking the total overhead amount and multiplying by the "%% contibuted" column. |
| Mngm Type | AF | This is the management fee type associatted with the adminnistered account (col C) as found in IBIS |
| Management Fee | AG | This is the total management fee recorded in the administered account (col C) |
| Management Fee / PI | AH | This is a derived field. The result is by taking the total management fee amount and multiplying by the "%% contibuted" column. |
| Ovh_less_905 | AI | This is the total overhead (all 900's) less the amount found under obj 905 recorded in the administered account (col C) |
| Ovh_less_905 / PI | AJ | This is a derived field.The result is by taking the Ovh_less_905amount and multiplying by the "%% contibuted" column. |
| Admin Fee Type | AK | This is the administrative fee type associatted with the adminnistered account (col C) as found in IBIS |
| Fee_905 | AL | This is the total administrative fee recorded in the administered account (col C) |
| Fee / PI | AM | This is a derived field. The result is by taking the total administrative fee amount and multiplying by the "%% contibuted" column. |
| Adjusted Overhead / PI | AN | This field is the calculation to determine the base of overhead to use for the calculation of RIF dollars |
| 12% | AO | This is a derived field multiplying 12 % by column AN |
| 1.50% | AP | This is a derived field multiplying 1.5 % by column AN |
| 13.50% | AQ | This is a derived field multiplying 13.5 % by column AN |
| Exclude | AR | This field notes the different reasons why an account is excluded from RIF distribution |
| 5% | AS | This field is used in determining the amount of overhead that is used to calculate RIF. |
Last updated on 09/29/2005
By James A. Mattern
Email: Mattern@psu.edu
NEWS & UPDATES
Updates:
Useful PSU Links
Links for CC Areas
- MS Access Reporting
- CC DataMart
- FIS LAN Help Desk
- FIS Imaging (DocFinity)
- Outlook WebAccess
- WebEvent
Acrobat Reader
Acrobat Reader is required to view many of the links on this site. Get Acrobat Reader now.