david geffen school of medicine at ucla clinical ... · basic sci, physiology, & venice family...
TRANSCRIPT
DAVID GEFFEN SCHOOL OF MEDICINE AT UCLA
CLINICAL DEPARTMENTS
ALL FUNDS
BUDGET PROCESS
FOR FISCAL YEAR ENDING JUNE 30, 2017
DAVID GEFFEN SCHOOL OF MEDICINE AT UCLA
Budget Workbook Contents CLINICAL DEPARTMENTS
Fiscal Year 2016-17
PAGE BUDGET CALENDAR
Budget Calendar ( a ) – ( b )
WORKBOOK INSTRUCTIONS
General Budget Information A-1 to A-3 Compensation Plan Funds Budgeting Income/Recharges/Transfers B-1 to B-12 Expenses C-1 to C-9 Support - Dean’s Office & Health System (All Funds) D-1 to D-18 Plan Faculty (All Funds) E-1 to E-14 Projections FY16 (All Funds)/Budget (Other Funds) F-1 to F-21 Reports & Report Samples (All Funds) G-1 to G-31 Write-ups H-1 to H-12 Status I-1 to I-2
REFERENCE TABLES & LISTS
Policy Reference List J-1 Row Categories and Mapping to Budget Rows J-2 to J-4 Plan Title Codes, Scales & Tables J-5 to J-15 Fund Source Codes & Other Reference Lists J-16 to J-23
DAVID GEFFEN SCHOOL OF MEDICINE AT UCLA BUDGET& COMPUTER WORKSHOPS –ALL FUNDS BUDGETING
CALENDAR FY 2016-2017
( a )
August 2015 Dean’s Office notifies departments of proposed budget schedule for 2016-17 October 28 Budget Workshop 1 9 A.M. - 11 A.M., in 1st Floor Conference Room, Gonda Room 1357 Review revised instructions for DO and Health System support January 2016 Dean’s Office issues general budgeting instructions to departments for 2016-17. January 19 FPM Overview (Tuesday) 9 A.M. - 11 A.M., in 1st Floor Conference Room, Gonda Room 1357
Special session held for staff members who need an overview of FPM’s functionality for transferring faculty information into the All Fund Budget (AFB) program.
January 26 Basic Science Departments & ORUs- Budget Workshop 2 (Tuesday) 9 A.M. - 10 A.M., in 1st Floor Conference Room, Gonda Room 1357.
Biological Chemistry, Biomathematics, Brain Research Inst. (BRI), Clinical & Translational Science Institute (CTSI), Crump Inst. for Biological Imaging (CIBI), Harbor, Human Genetics, Inst. of Genomics & Proteomics (IGP), Jonsson Comprehensive Cancer Center (JCCC), Laboratory & Animal Medicine (DLAM), MIMG, Neurobiology, Olive View, Pharmacology-Basic Sci, Physiology, & Venice Family Clinic
Clinical Departments (& ORUs) - Budget Workshop 2
1:00 P.M. - 2:00 P.M. in 1st Floor Conference Room, Gonda Room 1357 Anesthesiology, Emergency Medicine, Family Medicine, Head & Neck Surgery, Jules Stein Eye Inst. (JSEI), Medicine, Neurology, Neurosurgery, Obstetrics & Gynecology, Ophthalmology, Orthopaedics, Pathology/UCLA Immunogenetics/ Inst. of Molecular Medicine (IMM), Pediatrics, Pharmacology-Clin, Psychiatry, Radiation Oncology, Radiological Sciences, Semel Inst. for Neuroscience & Human Behavior (SINHB), Surgery, & Urology
January 26 Budget 101 Concepts Class – New Users & Refresher for Existing Budget Staff (Tuesday) 10:00 A.M. - 12:00 Noon - Basic Sci. Depts & ORU’s – 1st Floor Conf. Room, Gonda Room 1357
2:00 P.M. - 4:00 P.M. – Clinical Departments – 1st Floor Conference Room, Gonda Room 1357
January 27 Basic Science Departments & ORUs Computer Workshop (Wednesday) 10:00 A.M. - Noon, Biomedical Library, Technology & Learning Center – Second Floor,
Room 22-001-U Biological Chemistry, Biomathematics, BRI, CTSI, CIBI, DLAM, Harbor, Human Genetics, IGP, JCCC, MIMG, Neurobiology, Olive View, Pharmacology-Basic Sci, Physiology, Venice Family Clinic
Clinical Departments & ORUs Computer Workshop 2:00 P.M. – 4:00 P.M. Biomedical Library, Technology & Learning Center – Second Floor, Room 22-001-U Head & Neck Surgery, JSEI, Neurosurgery, Ob-Gyn, Orthopaedics, Ophthalmology, Pharmacology-Clin, Psychiatry, Radiation Oncology, SINHB, Surgery, Urology
DAVID GEFFEN SCHOOL OF MEDICINE AT UCLA BUDGET& COMPUTER WORKSHOPS –ALL FUNDS BUDGETING
CALENDAR FY 2016-2017
( b )
January 28 Clinical Departments Computer Workshop (Thursday) 10:00 A.M. - Noon, Biomedical Library, Technology & Learning Center – Second Floor,
Room 22-001-U
Anesthesiology, Emergency Medicine, Family Medicine, Medicine, Neurology, Pathology, Pediatrics, Radiological Sciences Computer Workshop (as needed) 2:00 P.M. – 4:00 P.M. Biomedical Library, Technology & Learning Center – Second Floor, Room 22-001-U
January 29 Budget 101 Computer Workshop – All New Users Clinical & Basic Science Depts and ORU’s (Friday) 10:00 A.M. - Noon, Biomedical Library, Technology & Learning Center – Second Floor, Room
22-001-U Clinical Departments Computer Workshop (as needed) 2:00 P.M. – 4:00 P.M. Biomedical Library, Technology & Learning Center – Second Floor, Room 22-001-U
March 1 Basic Science Departments, Clinical Department and ORUs Budgets due into Dean’s Office
(Room 13-082 CHS). March 1- All budget revisions requested from a department are due five (5) days after a formal written April 15 request by the Dean’s Office. In the event that a funding issue delays the submission of your
budget revisions, the affected budget must be submitted within 5 days after a resolution is reached on the items in dispute.
April 29 Dean’s Office completes reviews of revised budgets. May 13 Approved budget letters to Chairs and Directors Approx. Upload approved faculty salaries budgeted from the DGSOM faculty salary application into June 24 the campus payroll system September Dean’s Office uploads budget data to campus C-BIG.
WORKBOOK INSTRUCTIONS
(A-1)
DAVID GEFFEN SCHOOL OF MEDICINE AT UCLA BUDGET WORKBOOK DEFINITIONS/INSTRUCTIONS
CLINICAL DEPARTMENTS
GENERAL BUDGET INFORMATION To meet the purposes, goals, objectives, and mission of the departments in the School, the departments annually estimate the financial resources needed or available to carry out their mission critical roles. The revenues and expenditures being projected and budgeted must be realistic, reasonable, and attainable. Descriptive narration should clearly portray how all of the department’s operations or goals are to be financed across all funding sources, indicate how revenues are estimated, delineate major expenditures by category, include major assumptions and forecasting methods, explain significant changes or variances, as well as provide contingency plans. (Source: UCLA Principles of Financial Management.) Per the policies and procedures of the UCLA David Geffen School of Medicine Implementation Procedures under the UC Health Sciences Compensation Plan, each Department annually submits a budget and salary negotiations to the Dean for approval and covers the conditions of spending priorities. The Senior Associate Dean for Finance and Administration provides the departments with detailed budget formats and instructions. The Dean may discuss other strategic matters and/or funding issues with the Departments as specified in the annual budget request letters. This workbook contains sample budget reports that cover every source of funding and special reports specific to the Compensation Plan, along with the instructions on usage of the input screens and features within the budget program. The input screen is what each user will utilize to key in the budget information into the computer program. Departments will be accessing their computerized budgets through a network drive. Each user should have an icon set-up on his/her computer desktop for the “Dean’s Office Applications Dashboard” that contains the “AFB – All Funds Budget” program, along with other fiscal applications developed and maintained by the Dean’s Office. By embedding the All Funds Budget (AFB) program into this application dashboard, the Dean’s Office is able to ensure that department users always have access to the latest version of the AFB program. If a user doesn’t have this icon on his/her computer desktop, then s/he needs to contact the department’s Computer Support Coordinator (CSC) to install the icon. See the Contact List distributed during the workshops and located on the Dean’s Office website as to whom to contact for any computer (non-budget) questions related to the program. Departments are to complete the Budget Year information for 2016-17 that will generate supporting reports and attachments. In addition, departments are to provide updated projections based on actual activity for 2015-16. For convenience actual data for FY14-15, the last completed fiscal year, are in the budget program as well as the first six months of 2015-16. The second six months of the current year has been filled in for optional changes for expense categories. Faculty salaries excluding “Z” payments for the January to June 2016 period have been imported by account owner using FPM data for that time period. Comparative data will be reflected on the report for the current year budget and prior year actual data. Further references to dates in these instructions will be as follows:
Budget Year = 2016-2017 Current Year = 2015-2016 Prior Year = 2014-2015
BUDGET SUBMISSION/DUE DATE Deliver one (1) signed copy of the faculty-salary adjustment instructions to the Dean’s Office, 13-082 CHS, no later than March 1, 2016. You do not have to submit printed copies of your budget to the Dean’s Office. Mark the completion date on the STATUS tab of the budget program. Department’s access for updating will be locked. This notifies the Dean’s Office that you have completed your budget. See section on STATUS in this workbook.
(A-2)
REVISED BUDGET SUBMISSION/DUE DATE Within five (5) working days of receiving an e-mail from your fiscal reviewer notifying you of the conclusion of the required financial and academic personnel analysis of your department’s budget, all requested changes by the Dean’s Office and desired changes by the Department are to be made. If your changes are different or in addition to those requested by the Dean’s Office, send an e-mail listing the changes to your assigned fiscal reviewer. The Department’s access for updating will be restored during this period, except for Dean’s Office and Health System support requests. The Department is to notify the Dean’s Office by marking the completion date for “Final changes completed by dept” on the STATUS tab of the budget program. Updating access will be removed at that time. The Department will be able to view input data and print budget reports in Excel. Any salary changes for individual faculty members that differ with the revised budget are to be handled through a request for salary renegotiation on a limited basis. BUDGET APPROVAL NOTIFICATION and MEMORANDA OF UNDERSTANDING The Department will receive a budget approval letter that the revised budget has been reviewed and approved by Dr. Jonathan Hiatt and Anja Paardekooper. Memoranda of Understanding with respect to support requests, the number of years being funded for each item, productivity measurements and expected returns are to be communicated separately. Specific salary rate approvals will be transmitted to the Department separately. MERIT AND COST OF LIVING SALARY INCREASES • Academic Plan Members - See Plan Faculty for detailed instructions.
Scales Use the University's Specialized Scales 0-9 as issued July 1, 2015 for budget estimates and determining Academic Programmatic Unit (APU) designations as specified in the Campus Procedures. For convenience a set of scales and tables are included in this workbook. See discussion on APUs in the Plan Faculty section of this workbook.
Merits or Promotions
Include any anticipated merits and promotions for the Budget Year as well as approved merits and promotions during the Current Year.
Scale Increase Contingency (COLA & MA) The School’s been informed by UCLA’s Office of Academic Planning and Budget that a 3% Cost of Living (COLA)/Merit increase effective July 1, 2016 is unable to be ruled out for FY16-17. If the Regents and UCOP authorize this upward adjustment to compensation, the net percentage increase for the coming budget year would be 3%. No Market Adjustment (MA) is expected. Continue to use the published scales issued July 1, 2015. The major effect of the COLA would be on those Plan faculty whose negotiations are determined by “Y” remaining firm or for those faculty negotiations determined by “X+Y” remaining firm in the event “Y” dollars are less than the scale increase. Separate detail and summary reports have been developed for the budget program enabling a review of the anticipated impact of the Scale increases (Base X + Add’l Xs or X prime). For your department’s Plan faculty, the “X” contingency is being automatically calculated and included in the Compensation Plan in which they hold their membership as a means of ensuring the most conservative budget figures for the coming budget year.
• Academic Non-Plan Use existing academic salary scales and tables in effect and include any anticipated merits or promotions for 2016-17 as well as approved merits and promotions during 2016-17. Given that the campus is not ruling out a net 3% COLA/Merit and no MA, there is a need to manually budget this expected increase in cost this year.
(A-3)
• Staff Assume a 3% COLA/Merit increase in FY2016-17 for non-represented staff based upon the present information provided to us by the University. Manually budget for this cost increase plus any staff increases associated with anticipated equity increases or bargaining agreements. If most of your staff are in bargaining units, use a composite salary adjustment percentage from the union contracts in effect.
MAINTAINING A SUFFICIENT COMPENSATION PLAN (CPL) FUND BALANCE • CPL Fund Reserve
It’s the recommendation of the Dean’s Office that every School department maintain a fund reserve representing approximately 25% of the annual costs recorded on its MCP and/or BSP fund.
Use of Fund Balance by Dean’s Office in Decision Making
The School takes into consideration the reserve balance on a CPL fund as part of the annual review process involving the department’s proposed guaranteed salary increases for Plan faculty.
(B-1)
COMPENSATION PLAN INCOME/RECHARGES/TRANSFERS
The following is a systematic approach for entering Comp Plan budget data for Clinical Departments’ Plans (MCP, ILP, and BSCP funds). INPUT SCREENS FOR DEPT/DIVISION/OUTREACH/FUND GROUPING/FUND The program is set up to budget all Comp Plan income (revenue) and expense (expenditures) under the “Income” and “Expense” tabs by Department for each fund. Optionally, a department may budget income and expense by Division or Outreach site. We have customized the program for divisions based on campus hierarchy codes. Outreach sites listed are based upon what has historically been requested. Departments are able to print reports by division or at the department level for the budget year. FUND GROUPING/FUND Select the fund grouping of Compensation Plan and then a fund (i.e., MCP, BSP, or ILA as appropriate) for entering the data from the drop-down list. If you have Divisions or have elected to input by Division, a pull-down list is available for selection. If you do not want to budget by Division select “Department Administration” or “Department Name” if you have multiple choices under Division. This choice will apply for all of your income and expenditures. If you are budgeting for a community outreach site or satellite, you are required to select the “Division” and to click on the “Outreach site.” If you have selected an Outreach site and then you would like to change to Division only, click on the “Eraser” (Closest to the Outreach box). This will delete your selection.
BUDGET PROGRAM TABS The Comp Plan budget data will be entered on the following tabs: INCOME and EXPENSE, with the exception of Dean’s Office & Health System Support, and PLAN FACULTY data. Individual PLAN FACULTY data can only be entered by using FPM. This data may be uploaded from FPM on an individual basis into the budget program at anytime. The Current Year Projections and Designation of Balance are entered on the ACTUAL + PROJECTION/DESIGNATION OF BALANCE tab. Departments will enter data or edit pre-filled in data with the exception of the surplus/ (deficit) balance. The tabs for REPORTS, WRITE-UPS, and STATUS are not input areas and have different functions explained under their respective sections of this workbook. INCOME In addition to entering income data, describe in a separate write-up attached under the “Writeups” tab the assumptions that were used to project gross charges and collections for January 2016 through June 2017 (18 months). Also, attach under the “Writeups” tab the underlying assumptions your Department uses for projecting clinical income by individual, division, program/service or department. Include any footnotes or notations discussing the estimated changes in faculty, productivity or rates and the time periods that the changes are expected.
(B-2)
For 2016-2017, budgeting will entail selecting the respective clinical, research, or educational mission applicable for an income item. INCOME TAB For Revenue, Recharges and Transfers, the following are the steps:
1. Click on “Income” tab 2. Select Revenue Category 3. Select Mission, Unless Defaulted to “Clinical” 4. Dean’s (DO) Tax Default is Automatically Assigned as “Yes” or “No.” If a Tax Exemption
Request is Granted, the DO Will Revise the Dean’s Tax From “Yes” to “No.” 5. Select Source Fund – Interfund Transfer Rows Only – Able To View Only Support From Dean
Office (Rev. Side) - See Support Tab Write-up for DO 6. Mission of Transferred Funds From Other Department Defaulted To Be Same As Recipients
Mission For Received Monies, Unless Changed 7. Input Description of Item or Individual Name (If necessary) 8. Input Amount 9. Indicate remarks or comments (Optional) 10. Click on “Add”
INPUT GRID – After you input the data, it will be reflected on the bottom section of the screen. Please refer to Net Patient Care Revenue for a full description of the grid for income.
Mission Where appropriate, a default “Clinical” mission has been assigned to each revenue type with the exception of Other Comp Plan Revenue, Support from Dean’s Office (Rev Side), Miscellaneous Recharges-Comp Plan Service, Miscellaneous Recharges, and Interfund Transfers Internal & External (Rev. Side). If no Mission is highlighted for a particular transaction, a selection must be made before a revenue item can be saved and included as part of the budget. Dean’s Tax For each revenue category, there is a default for the Dean’s Tax. The default is either shaded “Yes,” taxable, or “No,” not taxable. If both “Yes” and “No” appear in the box, a Department can request an appropriate exemption to the Dean’s tax for an income record not previously granted an exception by clicking on “Exemption Request” and selecting “Pending” in place of the default of “No Exemption.” For each created
Grid Area
Dean’s Tax
Default
Mission Default
Exemption Request Status
(B-3)
“Pending” exemption request, you must enter a “Description” as well as add any pertinent “Remarks.” A written justification thoroughly explaining each Dean’s tax exemption requested needs to be submitted through the “Write-ups” tab at the time of the initial budget submission. For those revenue items where the Dean has granted a tax exemption in the past, the School has pre-populated those records in AFB for the budget year with a zero dollar amount. A created record can either be filled-in or left blank depending on whether revenue is anticipated in FY16-17 for the revenue item.
Departments may request a Dean’s tax exemption for the following eligible categories of revenue: Eligible Revenue for Tax Exemption Category Description Faculty Salary Support (Fixed Income) - Compensation reimbursement by an outside
organization (e.g., RAND, Olive View Health System, etc.) for only the value of the time spent by a faculty member on a project initiative. Note that for any payment received under a Professional Service or other agreement to be eligible for a tax exemption, the deposited monies must be passed directly onto the affected faculty member to solely cover his/her salary and benefit compensation. None of these funds should be handled through a Department’s P&L statement process, where overhead, assessments and/or costs are applied against the funds before an amount is determined to be payable to the faculty member.
Honoraria/Payment within UC - An exemption is granted for the honoraria/payments earned by an employee from UC activities and turned over to the department.
Resident Program Support - Reimbursement covering the compensation of DGSOM residents rotating to a location of an affiliated hospital.
Chargeable Supplies (Rev Up to Amt of Exp.) - An exemption on clinical revenue generated from chargeable pharmaceutical and medical supplies is able to be claimed up to the amount of the actual expense incurred for these items. In other words, Dean’s tax is solely paid on the net profit or income generated in excess of actual cost.
Technical Fee Health System Joint Venture - The share of department’s technical fee revenue specifically attributable to a joint venture with the Health System.
Technical Fee (Admin. & Facility) in General - The net patient care revenue collected on the non-physician component of the WRVU that’s separately identified from the clinical income generated by physicians and physician extenders. Note that for any Dean’s Tax exemption requested on technical fees that’s new or results in a substantially greater amount than what was identified for the prior closed fiscal year, the Dean’s Office (DO) will be requesting more detailed information on this income during the DO Tax true-up process. The data to be provided would include such information as CPT code, CPT description, Modifier, Place of Service, etc.
(B-4)
Direct Expense Reimbursement - The receipt of monies from an organization outside of the University that solely covers the department’s actual costs incurred that benefit this external entity (e.g., rent reimbursement from an outside health care partner.
Other Exemption - Miscellaneous net patient care and Other Compensation Plan revenue evaluated on a case-by-case basis (e.g., fees for copies of patient records, fees charged for Housestaff verifications, etc.)
For every revenue item designated as either “prior approved” or “pending” in terms of a Dean’s tax exemption, one of the above categories needs to be chosen and saved with the record. Each Dean’s tax exemption request for which a written justification has been submitted will be reviewed and considered for approval during the budget review process. The following is a list of revenue items with the defaults Category Deans Tax Default Changeable
Net Patient Care Revenue Yes Yes, only with Dean’s
approval
Net Patient Care – Recharges Yes Yes, only with Dean’s
approval
Net Patient Care – Recharges – Clin. Tr. Yes Yes, only with Dean’s
approval
MAP Facility Revenue Yes Yes, only with Dean’s
approval
Other Comp Plan Revenue Yes Yes, only with Dean’s
approval
FPG Recharges No No
Health System Directorships No No
Health System Transfers No No
Support from Dean’s Office (Rev. Side) No No
Misc Recharges – Comp Plan Service No No
Misc. Recharges No No
Interfund Transfers – Internal (Rev. Side) No No
Interfund Transfers – External (Rev. Side) No No
Interest STIP Yes No
Non-Health System Transfers No No
(B-5)
INCOME: Revenue-Recharges The discussion follows the MCP/PCCP fund. The following input steps pertain to the revenue categories listed below. Revenue
1. Click on the revenue category 2. Select Mission – Clinical, Research, or Education 3. Dean’s Tax – Default is “Yes” for Net Patient Care and Other CPL Revenue Not Granted an
Exemption 4. Description Name – Required for some categories 5. Amount – Enter dollar amount 6. Remarks – Optional 7. Click on “Add”
• Net Patient Care Revenue, Net Patient Care Recharges, or Net Patient Care Recharges – Clinical
Trials
The “Net Patient Care Revenue” line captures budgeted cash collections from patient billings associated with non-managed care & managed care professional services processed and/or tracked by the Faculty Practice Group. Recharges from patient billings should be placed on the “Net Patient Care – Recharges” line, except those related to clinical trials that are reported on a separate line. The amounts from all three lines should tie into your own revenue estimates. – Attach these estimates under the “Writeups” tab. Identify revenue as PSS collections or by the description. Items that are also included in this category and should be identified by separate budget line items using “Description Name” are Technical Fee Revenues, Department of Intercollegiate Athletics, Student Health, Pharmaceutical (Rechargeables) Revenue and Patient Care Consulting.
DATA GRID When you add a data record, the entry will be immediately reflected in the grid. The most recent item that you input will be reflected as the bottom record in the grid when the “Show Details” button is clicked. Records in the grid are displayed in ascending date/time order as to when these budget entries were created, with the oldest record being on the top of the grid.
(B-6)
Show Summary – When you double click to unhighlight Dean’s Tax “Y” or “N” and then click on “Show Summary,” the total amount for the revenue category highlighted (e.g., Net Patient Care Revenue, etc.) for a division is shown. When you click on the “Eraser” ( next to the “Change” button) and then click on “Show Sum,” the total amount for every revenue category by mission for the division is displayed. If you click on the “Eraser” (top left of screen) and then on “Show Sum,” the summary data by mission is reflected for all of your divisions. The grid can be sorted by clicking on a column header. Show Detail – When you double click to unhighlight Dean’s Tax “Y” or “N” and then click on “Show Detail,” every transaction for a highlighted revenue category (e.g., Net Patient Care Revenue, etc.) is displayed. When you click on the “Eraser” (next to the “Change” button) and then on “Show Detail,” all of the revenue transactions that have been entered for this division will be reflected. If you click on the “Eraser” (top left of screen) and then on “Show Detail,” the revenue data will be displayed for all divisions. The grid can be sorted by clicking on any of the column headers. Excel - When you click on the “Excel” button ( ), the information displayed in the grid will be downloaded to Excel.
From the grid, Departments can delete or change an item. To delete, click on the item on the grid, then click on “delete.” To change, click on the item on the grid, edit such fields as the description, amount, remarks, or mission and click on the “Change” button. For those times when you want to see the full rather than partial display of what’s been saved in the “Description” or “Remark” fields for an Income record, just double-click inside the desired field and a pop-up window will display every word that’s been input.
Show Details
Click on Grid Item
Change
Eraser
Show Summary
Excel
See Entire “Description” or “Remark”
By Double Clicking In Field
Delete
(B-7)
• MAP Facility Revenue Budget the net amount for MAP Revenue.
• Other Comp Plan Revenue Budget legal consulting, support from outside units and “other revenue” that is not categorized as patient care. For example, support from Cedars-Sinai Health System, Rand Corporation, other affiliated hospitals or institutions. This category includes research and teaching income. A description name is required. ILP Assessments are included in this category.
Grid If some entries in a category are taxable and some are not taxable, all the items can be displayed in the grid by double clicking on the highlighted Dean’s Tax “Y” or “N” to remove the selection criteria and clicking on the “Show Details” button.
Grid
Show Details
Dean’s Tax Default Yes/No
Double Click on
Dean’s Tax to Remove
Highlighting
(B-8)
Recharges/Transfers • FPG Recharges
FPG Recharges (i.e., Managed Clinics & Managed Admin Services) for faculty salaries will come from the faculty salary information imported from FPM based on fund source codes. Budget FPG recharges for staff salaries and other expenditures such as departmental overhead here.
• Health System Directorships Approved and continuing items displayed as read only under the “Income” tab originate from those support transactions entered by the Dean’s Office in the “HS Support” tab assigned the “HS Type” classification of Directorship. Each transaction represents funding to be provided to a Plan faculty member for delivering contracted services to the Health System at one or more of their hospital locations (i.e., Westwood, Santa Monica, and NPH).
New or Increase or Extension Requests These three different types of Directorship support requests require a formal evaluation by the Health System leadership utilizing a submittal, review, and approval process that occurs outside of this computer application. For more information on accounting for these types of requests, refer to the directions given under the Support section of this training manual.
• Health System Transfers
Approved and continuing items displayed as read only under the “Income” tab that originate from those support transactions entered by the Dean’s Office in the “HS Support” tab assigned the “HS Type” classification of Health System Transfer. Each transaction represents support to be transferred (i.e., Unexpended Balance Account 119850) for an established funding commitment associated with one or more of the Health System’s hospital locations (i.e., Westwood, Santa Monica, and NPH).
New or Increase or Extension Requests These three different types of Health System (HS) Transfer support requests require a formal evaluation by the Health System leadership utilizing a submittal, review, and approval process that occurs outside of this application. For more information on accounting for these types of requests, refer to the directions given under the Support section of this training manual
• Support From Dean’s Office (Rev Side) Approved and continuing items anticipated from the Dean’s Office Professional fee sources are displayed as “read only” under the “Income” tab. Approved and continuing Dean’s Office funded items originate from the “Deans Support” tab.
Follow the directions given under the Support section of this training manual. For New, Increase, or Extension Requests
For more information on these three types of funding requests, refer to the Support section of this training manual.
(B-9)
• Miscellaneous Recharges – Comp Plan Service Recharges for services provided by one Comp Plan Department to another Comp Plan Department are categorized as “Compensation Plan Service” recharges. Compensation Plan Service recharges are associated with such activities as Human Resources & payroll services, IT services, research and/or administrative services. Faculty salary support provided by one Department to another Department should be categorized as an “Interfund Transfer” and not included in this line.
Example: Comp Plan Recharge – IT Services
1. Click on “Misc. Recharges – Comp Plan Service” 2. Select Mission: Clinical, Research, or Education 3. Dean’s Tax – Default set to “No” 4. Description Name – IT Services for Dept of _______ (List the Department Name) 5. Amount – Enter dollar amount 6. Remarks – Recharge for staff salaries and other costs 7. Click on “Add”
• Miscellaneous Recharges
Miscellaneous recharges represent income to be received for services provided outside of the Comp Plan. Examples of this are recharges to the Venice Family Clinic for administrative services, etc. Example - Miscellaneous Recharge – Olympic Lab Consultation Agreement
1. Click on “Misc. Recharges” 2. Dean’s Tax – Default set to “No” 3. Description Name – Olympic Lab Consultation Agreement 4. Amount – Enter dollar amount 5. Remarks – Recharge for staff salaries and other costs. 6. Select “Clinical” mission from set of 3 choices 7. Click on “Add”
• Interfund Transfers Internal (Rev. Side) – (CPL Only)
Revenue side of an internal transfer within a Department between its respective Comp Plan funds (example: MCP to BSP). Entries can only be made from the Comp Plan fund receiving the monies. No e-mail notification goes out on those transfers occurring between the Comp Plan funds of the same Department.
• Interfund Transfers Internal (Exp. Side) – (CPL Only)
Expense Side of Internal transfers entered within a Department’s Comp Plan funds. Any required editing of a particular transfer entry must be made from the fund receiving the monies.
(B-10)
Interfund Transfers External (Rev. Side) - (CPL Only) Revenue side of interfund transfers made between two different Departments. Only the Department that is receiving the transfer can enter this transaction. The Department that will be debited will receive an e-mail notification that the transaction has occurred. Please complete the transaction early in the process so the budget is still open for the debited department. The Dean’s Office will take away the access rights once a Department budget is submitted. If the receiver enters an amount after the budget is locked, the receiver will get a message stating that “The department you indicated for Other Interfund Transfers has completed and locked their budget. Please contact your fiscal reviewer for this transaction.”
Example: Medicine is getting funds from Surgery Steps Followed By Medicine in Preparing Entry:
1. Click on “Interfund Transfers External (Rev. Side)” 2. Select Mission: Clinical, Research, or Education 3. Dean’s Tax default set to “No” 4. Source Fund – Scroll down list until you find the needed Comp Plan Fund & Department
Name to debit (Example: 62110 - Surgery) 5. Description Name – Support for Dr. Michael Jones Cardiology 6. Amount – Enter dollar amount 7. Remarks – Optional 8. Click on “Add”
Source Fund
(B-11)
Change In Mission Only Action Available to Surgery After Expense Side Of Entry Appears On Their MCP Click on entry Click on the “Mission" field of the entry Pop-up box automatically appears allowing user to change mission by clicking on the
appropriate button or exit
• Interfund Transfers External (Rev. Side) - Salary Savings (formerly Excess Income) The amounts for State FTE faculty on non-19900 fund sources supporting their base salaries (Fiscal Year or Scale 0) are automatically calculated from the FPM program and displayed on the grid under Interfund Transfers-Rev. Side. Faculty selected for the calculation will have Regular faculty title codes or NPI State FTE box checked and specifically identified source codes other than State General Funds for the “Base X” field. However, the source code for Howard Hughes Investigators will not be included in the calculation. This normally represents the amount of salary savings of 19900 funds that will be exchanged through the Dean’s Office. Given that a growing number of departments need to use at least some portion of the 19900 monies freed up by their State FTE faculty, a department should input an offsetting or credit entry under “Interfund Transfers External (Rev. Side)” to be applied to Deans Office “source fund” 62135 for the amount of “salary savings” that will need to be retained in 19900 to cover any funding shortfalls related to benefit costs. These benefit cost shortfalls are attributable to increases in employer contributions to UCRP as well as other employer-obligated costs such as health premiums. The credit amount entered under “Interfund Transfers External (Rev Side)’ for the Compensation Plan needs to be manually offset by entering an equal amount under State Appropriation Revenue for 19900. You’re essentially informing Academic Personnel for the Dean’s Office that the amount of salary savings to be exchanged with your affected Compensation Plan is less than what the budget program originally calculated. A Salary Savings Report on individual amounts is available under the Reports tab. For a discussion of sources, see the Plan Faculty section of this workbook.
Mission Field
(B-12)
• Interfund Transfers External (Exp. Side) All external transfers entered from another Department’s Comp Plan fund taking monies from this Comp Plan can be viewed. Any required editing of a particular transfer entry amount must be done back in the fund receiving the monies, with the exception of the Mission.
• Interfund Transfers External (Exp. Side) - Fund Source Exchange (DEAN_03) Departments that agree to help with the Fund Source Exchange will have plan faculty funding that utilizes the temporary 19900 funds made available to the department and coded DEAN_03. Correspondingly, a transfer from the department to the Dean’s Office of professional fee funds will be calculated and displayed here.
• Interest STIP
Apply current STIP percentage (approximately 1.5%) times the Prior Year’s ending balance, current fund balance or average fund balance. For clinical funds, mission is clinical. For basic science funds, mission is research.
• Other Transfers In/Out – used for the following examples:
- Transfers between UC Campus sites - Transfers to Sales and Service Funds - Transfers to Health System related to a joint venture - Transfers to Plant Funds
Example: Transfer from UCI
1. Click on “Other Transfer In/Out” 2. Select Mission: Clinical, research, or education (Note: entries through the 119850 account
for clinical compensation plan funds are defaulted to clinical and for basic science compensation plan funds are defaulted to research.)
3. Description Name – Transfer from UCI 4. Amount – Enter dollar amount (if to another area, enter negative amount) 5. Remark – Enter remark, if pertinent 6. Click on “Add”
• Expense Transfers In/Out – used for the following example:
- Expense Transfer to the University for the UCOP Tax
Note: The Dean’s Office pre-populates this budget line with the UCOP Tax Assessment amount determined for the current fiscal year (i.e., FY15-16) An additional record for this budget line should only be created in order to back out some or all of the UCOP tax assessment from the Compensation Plan in order to cover it from another available funding source such as an Indirect Cost Recovery fund. Example: UCOP Tax Assessment
1. Click on “Expense Transfer In/Out” (Note: entries for clinical compensation plan funds are defaulted to clinical and for basic science compensation plan funds are defaulted to research.)
2. Click on “Show Details” button 3. Select the record in the grid with the Description “UCOP Tax Assessment” 4. Change Description field to “Reassignment of UCOP Tax Assessment – ICR 19940” 5. Amount – Enter a positive figure (it should be the amount to be moved to another funding
source) 6. Click on “Add”
(Note: Now that the UCOP Tax Assessment has been reduced on the Compensation Plan, be sure to add the corresponding entry to the other desired funding source)
(C-1)
COMPENSATION PLAN EXPENSES
This section covers all Comp Plan operating, research and education expenditures excluding the Plan Faculty to be budgeted for this coming year. The Plan Faculty will be covered in the Faculty Salary section. The input for this data is by expense type (natural class object code groups for Salaries and Benefits or Other Non-payroll Expenses), mission, and then by source (department professional fees, Dean’s Office, or Hospital System support). Dean’s Office support can be used for any budgeted expense item for which the Dean has already granted approval. However, Dean’s Office funding support of non-faculty Compensation Plan expenses are not input under the “Expense” tab, rather any Dean’s support request that is continuing, new, an increase, or an extension must be budgeted under the “Deans Support” tab. Four possible options are available to budget for an expense amount attributable to a request for the coming budget year awaiting formal approval or denial by the Dean.
1. DO Support Tab (Non-Plan Faculty Salary Support) With Expense - The item is not related to Plan faculty salary support and a decision has been made to go ahead and budget the expense(s) associated with this request. Enter this new request for Dean Support under the “Deans Support” tab and click the “Add” button. Click on this record displayed in the Grid. Next, click on the “Dept Expense” button in order to be taken to a submenu. From the submenu, select the “Type of Expense,” input an amount, and click on the “Add Expense” button. In the upper right hand side of screen check to see if the total “Dept Expense” equals the total “Support Amount.” If not, either modify the existing expense record or add another expense record. Exit only after “Dept Expense” equals “Support Amount.” Although the revenue from the Dean will not appear in the budget unless approved, the cost associated with this request will now be in the budget. This approach is best used when the associated expenses are to be incurred whether or not the Dean provides the requested support.
2. DO Support Tab (Non-Plan Faculty Salary Support) Embedded Expense - There is a second
option available for an item not related to Plan faculty salary support for which a decision has been made to go ahead and budget the expenses associated with this request. From the “Expense” tab, embed or combine these expenditure(s) with other expense rows under the appropriate Compensation Plan fund. Then enter a separate support request under the “DO Support” tab and select the “Yes (Embedded)” radio button for the caption “Expense budgeted?”.
3. FPM Plan Faculty Salary Support/Expense - The item is related to Plan faculty salary support
with a decision to go ahead and budget the compensation expense associated with this request. Initially, a placeholder funding line may be set-up in FPM using Source Code Dean_01 (i.e., Dean’s Office Support (Comp Plan)). If request later approved, then initial DO Source Code is valid. Otherwise, change this funding line in FPM to a non-DO Source Code. Refer to the “Support” tab of this budget process book for further instructions.
4. DO Support Tab Without Expense - To exclude initially from the budget all expenses
associated with a new Dean’s Office support request, if the costs will only be incurred in the event the Dean provides the necessary funds. Create this new DO funding request without going into “Dept Expense” submenu. Costs are expected to be separately added upon approval by the Dean or the user budgeting costs needs to click the radio button “Yes (Embedded)” to indicate that this expense is already combined with a department’s other budgeted expenses.
As has been the case in prior years, Departments with Divisions and Outreach sites may budget in greater detail than the Department level. Outreach sites may be selected at the same time the Department and Division are selected. The level 1 and 3 summary reports for the FY16-17 budget will provide budgeted items by natural class distinguishing between Clinical, Research, or Education.
(C-2)
Select the Fund Grouping/Fund Select the fund grouping of “Compensation Plan” and then a fund (i.e., MCP, BSP, or ILA as appropriate) for entering the data from a drop-down list. If you have Divisions or have elected to input by Division, a pull-down list is available for selection. If you do not want to select a specific Division, choose “Department Name” or “Department Administration” or “Chairman” if you have multiple choices under Division. This will apply for all of your income and expenditures. If you are budgeting for an Outreach site, you are required to select the “Division” and to click on the “Outreach site.” If you have selected an Outreach site and then would like to change to Division only, click on the “Eraser” closest to the Outreach box. This will delete your present selection.
SALARIES AND BENEFITS Plan Faculty costs are automatically calculated from data imported from FPM. Additionally, you may enter adjusting amounts, e.g. for increase contingencies, on the Faculty Temporary line. Staff Physicians, Staff, Academic Other, Academic Apprentice, & Interns and Residents salaries and the corresponding benefits are manually entered. The following are the steps for input:
1. Click on a Salary Line (i.e., Staff Physician Salaries, Staff Salaries, Academic Other, Academic Apprentice, or Interns and Residents)
2. Select a Mission: Clinical, Research, or Education 3. Select Funding “Source”: Prof. Fees Departmental 4. Enter a Description or Optional Employee Name 5. Enter the amount of “Salaries” and “Benefits” 6. Remarks – Optional 7. Click on “Add”
Departments are not required to give the names of individuals, except if you have selected funding to come from the Dean’s Office under the “DO Support” tab. Concerning the handling of continuing, prior approved items to be funded by Dean’s Office Compensation Plan sources refer to the “Support” tab of this manual. For a discussion of the salary categories, refer to “Types of Salary Expenditures” in this section.
DATA GRID When you add a data record, the grid will display the information that you just entered. The most recent item that you input will be reflected as the bottom record in the grid when the “Show Details” button is clicked. Records in the grid are displayed in ascending date/time order as to when these budget entries were created, with the oldest record being on the top of the grid. Show Summary – When you click on “Show Summary” for a particular salary expense type and mission, the total amount of salaries is displayed. Show Detail – When you click on “Show Detail” for a particular salary expense type and mission, every transaction under that mission will be displayed.
Mission Staff, etc. Enter Salaries
& Benefits
(C-3)
Show Salary & Benefits – When you click on “Show Sal Ben” for a particular non-faculty salary expense type and mission, every transaction under that mission will be displayed showing salaries and benefits.
From this grid, Departments can delete or change an item. To delete, click on the item on the grid, then click on “delete.” To change, click on the item, edit the description, amount or remarks and click on “change.” For those times when you want to see the full rather than partial display of what has been saved in the Description or Remark fields for an Expense record, just double-click inside the desired field and a pop-up window will display the full description.
GRID (Any data displayed in the grid can be sorted by clicking on a column) Show Summary – When you click on the “Eraser” (next to “Change” button) and then “Show Sum,” the total of each expense type by mission for the division is displayed. If you click on the “Eraser” at the top left of the screen and then “Show Sum,” the summary data by mission is reflected for all the divisions. Show Detail – When you click on the “Eraser” (next to “Change” button) and “Show Detail,” all of the expense transactions that have been entered for the division selected will be reflected. If you click on the “Eraser” at the top left of the screen and “Show Detail,” you get the data for all the divisions. Show Salary & Benefits – When you click on the “Eraser (next to “Change” button) and “Show Sal Ben,” all of the non-faculty salary lines with benefits entered for the division selected will be displayed as well as the salary and benefit amount for each faculty Plan member imported from FPM . If you click on the “Eraser” at the top left of the screen and “Show Sal Ben,” you get the data for all the divisions. TYPES OF SALARY EXPENDITURES Enter the budget for payroll expense for Faculty Temporary (Not Plan Members and any adjustments), Staff, Staff Physicians (if applicable), Academic Other, Academic Apprentice, or Interns and Residents. Plan Faculty will be automatically calculated from data in the FPM and divided between Faculty Ladder and Faculty Temporary. (For Plan Faculty title codes, see list provided in this training manual with corresponding row category or object code group.)
Erasure – Clears Fund Grouping &
Fund
Eraser – Clears Exp. Type, Mission, Source, & Grid See Entire
“Description” or “Remark” By Double Clicking
In Field “Show Sal Ben”
Displays Non-Fac. Sal & Ben
Delete
Change
Erasure – Clears
Division & Outreach
(C-4)
Faculty Temporary is the row category or object code grouping for faculty who are not in the Regular Professor series. The only items that may be entered manually are faculty who are not members of the Health Sciences Compensation Plan (i.e., faculty paid on the REG DOS code). The object code 1030 is most commonly associated with non-Plan Faculty Temporary titles. Salary and benefit information on Plan faculty who are considered Faculty Temporary will be drawn in directly from FPM. Staff Physicians with title codes 0768-0799 and 9177 are entered on the Staff Physician line. The object codes associated with Staff Physicians is 1191-1194. Staff personnel or positions with title codes 0001-0799 and 4000-9999 except Staff Physicians (see above) are entered on the Staff salaries line. The category of Staff includes those individuals with object codes of 1100-1182, 1700, 1800, 1889, 1900-1970, 3788, 8195. No distinction is made in the budget between Career and Casual or Limited Appointments. Academic Other includes non-faculty academic titles, such as those in the various research series (e.g., Project Scientist or Professional Researcher). Plan faculty title codes are excluded from this category, as they are divided between Faculty Ladder & Faculty Temporary and their salary and benefit data automatically drawn in from FPM. In addition, title codes associated with non-Plan Faculty Temporary and the Interns and Resident title codes are in other row categories. (Interns and Residents are alternatively referred to as Resident Physicians or Post M.D.s with academic title codes 2708, 2724, 2725, or 2726 along with non-physician clinical trainees under title code 2740 and are associated with 1081object code.) Academic Other is mapped to object codes 1032-1098 and 1400, excluding 1035-1039 for Faculty Temporary and 1040, 1048, 1070, and 1078 for Academic Apprentice. We have included the academic default object code 1888 to be reflected here. In addition, the Chancellor’s Office has designated the object code 1032 associated with Terminal Vacation Gross Reductions (Financial Leave Accrual) for all academic titles to be in this group. Academic Apprentice includes Graduate Student Researchers, Postdoctoral Scholar-Employees (title code 3252), Teaching Assistants and Associates, Tutors, and Readers. They are associated with object codes 1040, 1048, 1070, and 1078. Postdoctoral Scholar-Fellows (title code 3253) paid through the Graduate Division, i.e., not through Payroll, should be budgeted under "Financial Aid.” Interns and Residents are alternatively referred to as Resident Physicians or Post M.D.s with academic title codes 2708, 2724, 2725, or 2726 along with non-physician clinical trainees under title code 2740 and are associated with 1081 object code. Compensation Assignable To Clinical Mission – Salaries & benefits of those individuals directly responsible for administrative management and oversight of the operation of the Plan or practice should be budgeted to the clinical mission. Also include under the clinical mission those salaries and benefits related to billing functions, facility usage (e.g., 100 Medical Plaza, 200 Medical Plaza and all other Non-Medical Plaza locations), and community outreach activities (patient care activities that are off-campus). Select appropriate expense type. Compensation Assignable To Research Mission – Salaries and benefits of those individuals supported from compensation plan funds that are not working on or responsible for the clinical or education/administration activities of the department. An individual or unit may be split between this mission and one or both of the other 2 missions. Select appropriate expense type. Compensation Assignable To Education/Administration Mission – Salaries and benefits of those individuals supported from compensation plan funds that are not working on or responsible for the clinical or research activities of the department. An individual or unit may be split between this mission and one or both of the other 2 missions. Select appropriate expense type.
(C-5)
Prof Fees-Departmental Defaulted as the “Source” of Funding To budget for any of the above expense types, you need to accept “Prof. Fees-Departmental” as the “Source” of funding. However, you can search on any of the listed sources. If you’re requesting continuing, new, or additional funding from the Dean’s Office, create the request under the “DO Support” tab. In terms of continuing Health System funding, each budgeted support record is generated under the “HS Support” tab. Budgeting Salaries (Other Than Faculty Ladder) – Clinical, Research, or Education
MALPRACTICE INSURANCE Budget in this category the Medical Malpractice Premiums being distributed to your Department by the Faculty Practice Group. Mission is clinical and expense type is Malpractice Insurance. The following steps are for entering the data:
1. Click on “Malpractice Insurance” 2. Click on Clinical 3. Enter the “Amount” 4. Click on “Add”
If your department’s malpractice figure for the coming budget year is unavailable, input the amount being distributed to you in the current fiscal period. The Dean’s Office will further update this amount, as necessary, prior to the finalization of the FY16-17 budget process. PSS Mission is clinical and expense type is “Professional Services – Other.” Budget in this category the expense charged by the Physician Support Services (PSS) for their services. Use the figure provided to you by PSS and add-in any adjustments or true up from current year to be enacted in budget year. The following steps are for entering the data:
1. Click on “Professional Services - Other” 2. Click on Clinical 3. Enter Description PSS 4. Enter the “Amount” 5. Click on “Add”
Select An
Expense Type
Select a Mission “Prof Fee-Dept” Pre-Selected Once Choose Exp Type
(C-6)
OTHER NON-PAYROLL EXPENDITURES For these categories, budget the non-salary expenditures (e.g. supplies, information systems, equipment, and space rental for clinical operations as well as research or education expenditures. Expense Types (Row Categories or Object Code Groupings) Departments will need to budget expenditures by major expense type to allow for the ongoing creation of budget to actual comparison fiscal reports by natural expense classifications. Examples of major expense types are listed under the scrollable list reflecting the available choices. The following are the non-Salary Expense Types being utilized by the School based upon the campus object code groupings. These expense types follow closely the Object Code Categories in C-BIG. For a complete list, see separate section in the workbook reference section. Subcontracted Services Facility Computing Services Material and Supplies – Scientific Temporary Personnel Services Material and Supplies-General Consultants Equipment (Computer) Professional Services Other Equipment (Non-Computer) DLAM Telephone Patient Care Expense Mail & Messenger Printing & Copying Space Rental Services-Other Insurance Repairs & Maint. Financial Aid Entertainment Fee Remissions Travel Other Expense Start-up, Faculty Recruitment & Retention Although many of the expense traditionally budgeted by preparers can be classified in a straightforward way into one of the available “Expense Types,” some budgeted expense categories are of such a broad nature that they are unable to be broken down into more precise categories. In the event there is a category of expense such as Start-Up or Faculty Retention where a breakdown into more precise categories is not possible as of the budget submission date, then budget these costs under “Other Expense.” Also, place a comment in the “Variance Notes” area of the budget explaining any resulting large variances between budgeted “Other Expenses” and actual and projected figures for “Other Expenses.”
Variance Notes (Under “Act + Projection & Desig Of Bal”)
Click For Variance
Notes
Variance Notes Box
(C-7)
The following steps are for entering Non-salary budget data: 1. Click on “Expense Type” 2. Select a “Mission”. 3. “Source” default is “Prof. Fees-Departmental,” Only Source Available for Budgeting under
This Tab. 4. Enter Description/Name 5. Enter Amount 6. Remarks – Optional 7. Click on “Add”
Other Non-Payroll –Clinical –– Include expenditures directly related to the administration of the plan, such as incurred billing fees on patient services, on- and off-campus patient care clinic expenses charged to the MCP Plan, etc... In terms of budgeting patient care costs tied to individual off-campus sites, you can optionally budget by the “Outreach” sites set-up for your department. If your Department is adding a new site, contact the Dean’s Office – Computer Support (see contact list) for the site to be added to the program.
Budget Central Administrative Fee Recharges (CAF) and increase the figure you entered for your current year by 20% (based upon current trends). Total overall CAF costs have gone up significantly over the past fiscal year. Also, include special benefit costs for faculty, such as disability and life insurance on the additional compensation and 415(m) Restoration costs appropriate to the clinical mission. Budget transcription costs to be allocated by the Health System. Contact the Hospital’s Health Information Management Services Department (See Contact List) for the amount to be budgeted for this activity. Other Non-Payroll – Research – Non-salary costs supported from compensation plan funds that are not related to the clinical or education/administration activities of the department. Costs typically budgeted in this category have included Construction & Major Alterations, Equipment Acquisition or Rental, Space Rental, Lab or General Supplies and Travel. Also, include special benefit costs for faculty, such as disability and life insurance on the additional compensation and 415(m) Restoration costs appropriate to the Research mission. A budgeted cost item may be split between this mission and one or both of the other 2 missions. Other Non-Payroll – Education – Non-salary costs supported from compensation plan funds that are not related to clinical or research activities of the department. Costs typically budgeted in this category have included Construction & Major Alterations, Space Rental, General Supplies and Travel. Also, include special benefit costs for faculty, such as disability and life insurance on the additional compensation and 415(m) Restoration costs appropriate to the Education mission. A cost item may be split between this mission and one or both of the other 2 missions.
To Select Outreach Site
(C-8)
Dean’s Office Funding Use the “DO Support” tab for entering continuing, prior approved funding from the Dean’s Office as well as inputting support requests that are new or where an extension or increase in current funding is desired. You may only search on the “Dean’s Office-Prof. Fees” or “Dean’s Office-Student Fees” sources entered under the “DO Support” tab and visible under the “Expense” tab. You can view the expenses budgeted for any Dean’s Office support item that is pending approval or eventually receives approval or continues to be funded from one of the two displayed Dean’s Office sources whose costs have been input using the submenu activated by the “Dept Expense” button under the “DO Support” tab. Viewing a record whose expense is budgeted using the “Dept Expense” button for a newly approved or a prior approved DO support request produces the message “Trans has Expense and Revenue.” Viewing a record whose cost is budgeted utilizing the “Dept Expense” button for a DO request pending approval generates the message “Trans has Expense, but no Revenue.”
Health System Funding You may search on the “HS – Westwood Hospital,” “HS – Santa Monica Hospital,” or “HS – Neurospsychiatric Hospital” sources entered under the “HS Support” tab and visible under the “Expense” tab. You can view the expenses budgeted for any Health System support item that continues to be funded by one of the three Health System sources and whose costs have been input using the submenu activated by the “Dept Expense” button under the “HS Support” tab. Viewing a record whose expense is budgeted using the “Dept Expense” button for a newly approved or a prior approved HS support request produces the message “Trans has Expense and Revenue.”
Editing Buttons Blocked
View But Not Edit
DO Records
1 Of 2 Possible Messages
For Non-FPM Records Viewed
(C-9)
Non-Payroll (All Categories) - General and Employment Liability and Property Insurance (GL), GL Admin Cost. This expense will be reflected under the mission that the salary is charged. “Insurance” is the Expense Type for this expense. Based upon the most current available information from the campus Office of Insurance and Risk Management, the following tentative rate per $100 of payroll applies to the School: $0.08/$100 for Gen. Liability (includes amortization of prior year deficit) & Employment Practices $0.26/$100 for Employment Practices Liability $0.02/$100 for General Liability Additive Rate $0.34/$100 for Purchased and Property Insurance Programs (All-Risk Property Premium). $0.01/$100 for Administrative Fee/Loss Prevention (Liability Surcharge) $0.71/$100 for General Liability and other insurance programs (Final rate to be approved in Spring 2016.) The administrative cost of running the self–insurance programs encompasses the expenses incurred for actuarial services, AIS refinements to handle the tracking and recording of the liability insurance programs, etc. The Budget Program automatically calculates $0.71 per $100 of the salaries budgeted for faculty, staff, non-plan faculty, and interns and residents charged to the Compensation Plan only.
(D-1)
SUPPORT DEAN’S OFFICE & HEALTH SYSTEM
DO (Dean’s Office) Support The “DO Support” tab is where all DO Support requests are recorded for the Budget Year, across all fund groups. Every department is responsible for inputting via the “DO Support” tab from November 2, 2015 through December 11, 2015,” those funding requests definable as Department Support Requests. A department may solicit monies from the DO that provides reimbursement for the cost of faculty salaries of its Plan and non-plan members as well as other possible expenses. Plan faculty salaries input in FPM using a DO Source Code (i.e., DEAN_01, etc.) only uploads into the AFB as compensation expense without any of this data feeding into the DO Support tab. A new “Approved Support” button feature has been added to FPM for the FY17 budget process. By clicking on this button a user is able to compare how much approved support covering a Plan faculty member’s compensation is presently being used by the associated funding line(s) set up for this individual in FPM. What enables the Dean’s Office and a department to know that a DO support request entered into AFB involves the coverage of a Plan faculty member’s salary is the selection of the “Category” of Plan Faculty as well as the selection of a name from the newly created “Faculty” pulldown list. What links the DO support covering a Plan faculty member’s salary to his/her funding lines in FPM is the use of the DO Fiscal Program Identification record number (i.e., FP ID#) assigned to each continuing funding item by the Dean’s Office. This assignment is expected to occur no later than December 18, 2015 for continuing support items. For new, extension, or increase requests, the FP ID# will be updated by February 1, 2016. To see all instances of approved DO support along with the corresponding FP ID#’s covering Plan faculty salaries, a user should run the report in AFB under the Reports tab entitled “Dean’s Office Support Linking Plan Faculty Salary Expense to Revenue.” The FP ID#’s referenced in this report should be used in assigning FP ID#’s in FPM for those Plan faculty funding lines assigned a DO Source Code. For Plan faculty salary support that is included in a DO funding “package”, a user has the option of setting up the entire request in AFB without needing to establish a Plan faculty expense component in FPM. It can be embedded in the lump sum amount requested for the package. Example – faculty salary component in a startup support request. For DO funding classifiable as DO Program Support (e.g., Dean’s Compensation, ED&R, etc.), the Dean’s Office expects to create each approved support budget and assign a unique FP ID# no later than February 1, 2016. Every DO Support entry must include a “DO Type” selection. A discussion of the available selection options for the “DO Type” field is located in a separate section below. Every DO Support request that is created in the DO Support tab requires a “Request Status” selection. A department may select either Prior Approved or Pending from the list of available choices. Choosing Prior Approved causes the budget program to default the “Review Type” to Continue. If appropriate, a user has the option of choosing New to go along with the selection of Prior Approved. Clicking on Pending defaults the “Review Type” to New. If appropriate, a user can alternatively choose Increase or Extension simply by clicking on the desired selection. A more detailed discussion of the individual choices is addressed in a separate section below. A “Dept Expense” button under the “DO Support” tab allows for the direct budgeting of the non-faculty salary expenditures associated with an individual DO Support request. AFB will generate the corresponding expense entries in the appropriate fund group automatically. An explanation on the use of this function is provided in a separate section below. Any DO support record created and saved in the AFB starts out displaying the No radio button under the question “Expense budgeted?”. In the event a user subsequently clicks on the “Dept Expense” button and budgets the corresponding expense to go along with this DO support record, then the radio buttons change from No to Yes.
(D-2)
Where a DO support request covering a Plan faculty member’s salary has one or more corresponding funding lines in FPM linked with the same “FP ID#” and this individual’s information is sent from FPM to the AFB after January 22, 2016, then the radio button under the question “Expense Budgeted” changes from “No” to “Yes (Embedded).” A user is also able to add the budgeted expense for a DO support item to the overall costs reflected on non-faculty expense lines created outside of the “DO Support tab.” This is an alternative approach to using the “Dept Expense” button. If this approach is used, an individual needs to click on the “Yes (Embedded)” radio button. If either the “Yes” or “Yes (Embedded)” radio buttons are checked, then the assigned DO fiscal reviewer knows that the necessary expenses have been budgeted as an offset against a particular Dean’s support request. The “DO Support” tab is the repository of all DO Support requests submitted for budget review. It is the one place to view all support request records. For every support request record that has a status of “approved” or “prior approved,” the AFB program will generate a DO Support Revenue budget record in the appropriate fund/fund group and mission. A. Entering A Dean’s Support Request Under the DO Support Tab Selection of Fund Group and Fund The selection of a “Fund Grouping” (at the top of the screen) and/or “Fund” is required for entering DO support. For each support item classified as Continue, Increase, or Extension, choose the “Fund Grouping” and/or “Fund” used by the Dean’s Office in the current year for this request. For all new request items, use the department’s Compensation Plan fund for budgeting purposes. After the “Fund Grouping” and/or “Fund” has been selected, the “Dean’s Fund Grouping” will display the available Dean’s funding sources that correspond to the selection. A selection in the “Dean’s Fund Grouping” field is required to complete the entry for a DO Support record.
(D-3)
Multi-Year Plan/ DO Type/ Request Status/ Budget the Expense
Multi-Year Plan “DO Support” tab allows for the entry of a multi-year budget plan for a DO Support request. If you are requesting Dean’s support to be distributed over a number of years (i.e., up to 5 years), you should specify the amount being requested for FY2016-17 as well as the future fiscal periods. For a continuing DO support item that would span beyond the budget year, input the amount most likely needed for FY2016-17 with the remainder of the commitment projected out into future fiscal years. We strongly recommend the department submit a 3 to 5 year funding schedule for faculty recruitment and retention support requests. For multi-year as well as single year DO funding requests, there may be a time when you want to see the full rather than a partial display of what has been saved in the Description or Remark fields for a record. To see the entire Description or Remark input, double click inside the desired field and a pop-up window will display the full description. Selection of “DO Type” Making a choice within the “DO Type” field classifies the particular kind of request this item will be categorized as within the Dean’s Office database that tracks committed support to departments. The support items are split into the two main groups of “Department Support Requests” and “DO Program Support.” “Department Support Requests” are those that would fulfill a specific need within your operating unit, if approved. These requests can be entered by your department into the AFB from November 2, 2015 through December 11, 2015. “DO Program Support” represents payment to your department for a service to be provided to the Dean’s Office and/or School in an upcoming budget year. It’s the sole responsibility of the Dean’s Office to input these particular support items in the AFB no later than February 1, 2016. The selection choices under DO Types displayed from November 2, 2015 through December 11, 2015, pertain only to the DO funding tied to “Department Support Requests.” After December 11, an expanded set of choices will display that include the DO Types for “DO Program Support.”
# Yrs &
Amt/ Yr
Type Of DO Request
Being Funded
Use To Budget Expense
Tied To Request
See Entire “Description” or “Remark”
By Double Clicking In Field
(D-4)
The following are the established choices for this field: Department Support Request (11/02/15 – 12/11/15)
1. Chair’s Salary Support – Chair’s own salary support commitment tied to Chair’s appointment LOU
2. Chair’s Own Support – Start-up or other support directly benefitting the Chair’s own professional needs tied to Chair’s appointment LOU
3. Chair’s Dept Support – Department support commitment tied to Chair’s appointment LOU 4. Chair’s Other Support – Funding request tied to Chair’s appointment LOU but not covered
by the above choices 5. Faculty Recruitment – Request associated with faculty recruitment 6. Faculty Retention – Request associated with faculty retention 7. Faculty Recall – Request associated with faculty recall 8. Faculty Other – Request associated with faculty not covered by the other three available
choices 9. Teaching Support – Request associated with teaching support aimed to supplement the
department’s own teaching force. 10. Renovation – Funding associated with a renovation deemed necessary to further the research
and/or education mission of the School Dean’s Office Program Support (Requests to be Approved by 2/01/16)
1. Faculty Salary – Dean’s Compensation – Faculty salary funding associated with Dean’s Office duties, FPM funding is entered by Department and checked by DO Academic Affairs
2. Faculty Salary – Stipend (Program Director & Other) – Faculty salary funding to compensate faculty time associated with Program Director duties or Committee Service work appointed by the Dean’s Office. FPM funding is entered by Department and checked by DO Academic Affairs
3. Faculty Salary – Education Dean’s & Faculty – Faculty salary funding to compensate faculty time associated School’s Education programs and appointed by Vice Dean for Education. FPM fund is entered by Department and checked by DO Academic Affairs
4. Faculty Salary – ED&R/SAO Allocation – Faculty support allocation from the Educational Development & Research (ED & R) Office/Student Affairs Office
5. Education – Anatomy – Continuing support for the Anatomy Teaching Program 6. Education – Student Lab Expense – Reimbursement of the expense incurred on the
department account and associated with the teaching labs for the medical students 7. Education – Other – Support attributable to the education mission not covered by any of the
other available choices. 8. Research – Core Shared Resources – DO support allocated for sustaining and/or expansion of
a Core Facility benefitting those engaged in research within the David Geffen School of Medicine as well as throughout the campus
9. Research – Themes – DO support allocated to fund the six research themes. 10. Research – Other – Support attributable to the research mission not covered by any other
available choices. A couple of examples are the CTSI awards and Lab Safety Compliance 11. Other Budget – A request not covered by any of the other choices. A couple of examples are
the Global Health Program and MSTP Administration in Biochemistry Designation of Request Status Select the “Request Status” of Prior Approved for any item that has been approved by the Dean’s Office, whether it was approved at the time the FY2015-16 budget letter was issued or afterwards. AFB will generate the corresponding Dean’s support revenue in the appropriate fund group. Clicking on Prior Approved under “Request Status” defaults the “Review Type” to Continue. If appropriate, a user can alternatively choose New simply by clicking on the desired selection.
A new support request in this instance pertains to any item on which Dean’s Office approval was granted after the issuance of the FY2015-16 final budget letter with funds not being disbursed until the start of the FY2016-17 fiscal year. This is different from approved DO funding already being received and disbursed in the current FY2015-16 year.
(D-5)
Select the “Request Status” of Pending for any item requiring Dean’s approval. The AFB will only generate the corresponding Dean’s support revenue in the appropriate fund group after it has been Approved. The DO Fiscal Office will update the “Request Status” of a pending item no later than February 1, 2016, subsequent to a formal decision being made on the request by the School’s leadership. It is important to note that the written justification for every New, Increase, or Extension support item must be submitted as an addendum through the Writeups tab in AFB no later than the DO support request submittal deadline of December 11, 2015. Clicking on Pending under “Request Status” defaults the “Review Type” to New. If appropriate, a user can alternatively choose Increase or Extension simply by clicking on the desired selection. The following are the definitions for each of the 3 choices: A new support request in this instance pertains to any item on which a funding discussion has not previously taken place with the Dean’s Office. An increase pertains to the amount over the Dean’s Office commitment presently approved for a particular support item. For example, if the Dean’s Office currently has approved a $100K in salary support for a particular individual and the department is seeking to increase the total to $125K, then the $25K not currently approved should be budgeted as an increase. An extension is used for a DO Support item that requires annual review and approval, or for a commitment that Dean’s funding has expired or is expiring.
Budgeting Expenses for a DO Support Request For each DO Support request entered directly via the “DO Support” tab, a user may click on the “Dept Expense” button to budget the associated expenses. After an expense budget is created, the radio button for “Expense Budgeted?” will change to “Yes” from its default of “No” and the expense budget entries will be created in the appropriate “Fund Grouping” and/or “Fund.” A user can create a matching expense budget excluding Plan faculty salary cost for each DO support record saved. For every new, increase, or extension request item, you have the option as to whether or not to enter the expense budget prior to Dean’s Office approval. Although the revenue for a request pending Dean’s approval will not appear in the budget until it is approved, the budgeting of the cost associated with this request does not have to wait until you have Dean’s approval. This approach is best used when the budgeted expenses will be incurred whether or not the Dean provides the requested support. If you choose not to enter the costs before the approval, then the matching budgeted expense excluding Plan faculty compensation will need to be added upon the Dean’s approval using the “Dept Expense” button or as an alternative approach you may embed these costs with other expenses being budgeted by your department.
As a user, you have the ability to decide how the expense for each DO support item is to be accounted for in the AFB. In addition to the budget program tracking the budgeted expense entered through the “Dept Expense” button, a user can click on the Yes (Embedded) radio button. Selecting this button conveys that the non-faculty expense(s) for a DO support item has been included in the overall costs reflected on budgeted expense lines not created under “DO Support” tab. Where a DO support request covering a Plan faculty member’s salary has one or more corresponding funding lines in FPM linked with the same FP ID# and this individual’s information is sent from FPM to the AFB after January 22, 2016, then the radio button under the question “Expense Budgeted?” changes from “No” to “Yes (Embedded).” The “Yes” or “Yes (Embedded)” radio buttons communicates to the assigned DO fiscal reviewer that the necessary expenses have been budgeted as an offset against a particular Dean’s support request. There may be a rare case where a “prior approved” request for Dean’s support is not tied to a specific set of expenses to be incurred in the budget year, but rather applies to reimbursement for expenditures recorded in a prior fiscal year. In this particular case, budgeting expenses is not required.
(D-6)
Budget the Expense for a Request Item by Using the “Dept Expense” Button. The “Dept Expense” button allows a user to budget the associated expense attributable to a DO request. The steps for budgeting this expense is as follows:
1. Create request item by filling in “Description (Purpose),” “Amount(s),” “DO Type,” “Mission,” “Category,” “Request Status,” “Deans Fund Grouping,” and “Remark (optional)” – Click “Add” button
2. Select request item in Grid from amongst all available records 3. Click “Dept Expense” button to be taken to a submenu 4. Select “Type of Expense” a single item from list 5. Input Amount 6. Click “Add Expense” button 7. Done if “Support Amount” = “Dept Expense” displayed in upper right of screen 8. If “Support Amount” does not equal “Dept Expense,” add another “Type of Expense” 9. Exit Submenu Only After Exp = Support (Only Able To Exit When This Condition Met)
Note that Faculty Ladder Salary (and Benefit) Expense budget can’t be entered here. This is to prevent duplication since all Faculty Ladder expense budget is entered via FPM and uploaded to AFB. However, the department can budget Faculty Temporary expense here to account for faculty “non-Z incentive” salary expense that can’t be reflected in FPM.
Expense Shows
As Budgeted
Support Amt = Dept Exp Exit Submenu
(D-7)
How to Handle a DO Support Request Where Expenses Budgeted Without Using the “Dept Expense” Button (After January 22, 2016 release of AFB)
1. Select “Prior Approved” or “Approved” request item in Grid from amongst all available records 2. Click radio button Yes (Embedded) 3. Click “Update ” button located just above radio button Yes (Embedded)
B. Dean’s Support Request No Longer Originating From FPM Plan faculty salaries input in FPM using a DO Source Code (i.e., DEAN_01, etc.) only uploads into the AFB as compensation expense without any of this data feeding into the DO Support tab. A new Approved Support button feature has been added to FPM for the FY17 budget process. By clicking on this button a user is able to compare how much approved support covering a Plan faculty member’s compensation is presently being used by the associated funding line(s) set up for this individual in FPM. What enables the Dean’s Office and a department to know that a DO support request entered into AFB involves the coverage of a Plan faculty member’s salary is the selection of the “Category” Plan Faculty as well as the selection of a name from the newly created “Faculty” pulldown list. What links the DO support covering a Plan faculty member’s salary to his/her funding lines in FPM is the use of the DO Fiscal Program Identification record number (i.e., FP ID#) assigned to each continuing funding item by the Dean’s Office. This assignment is expected to occur no later than December 18, 2015 for continuing support items. For new, extension, or increase requests, the FP ID# will be updated by February 1, 2016. To see all instances of approved DO support along with the corresponding FP ID#’s covering Plan faculty salaries, a user should run the report in AFB under the Reports tabs entitled “Dean’s Office Support Linking Plan Faculty Salary Expense to Revenue.” The FP ID#’s referenced in this report should be used in assigning FP ID#’s in FPM for those Plan faculty funding lines assigned a DO Source Code. The DO Fiscal Office will assign an FP ID# to each approved DO support revenue record involving faculty salary support. Once an approved DO Support Revenue record with a corresponding FP ID# is created under the DO Support tab, it will appear under the Approved Support button in FPM. If the approved DO support includes benefits, the support budget will be calculated using an average benefit rate of 30% for FY16-17. While there may end up being a small dollar difference between the budgeted DO support in AFB from the actual Plan faculty salary expense reflected in FPM, the Dean’s Office will fully fund the actual benefit expense as part of the true up process at the fiscal year end.
For a DO Support Item Where Budgeted Costs Accounted For Elsewhere:
1. Click Radio Button Yes(Embedded)
2. Click Update Button
(D-8)
The screen shots below demonstrate the tie-in between the DO funding support for a Plan faculty member in AFB and his/her funding lines in FPM. The DO Support Revenue record created in AFB communicates to the Department the fund source which the Dean’s Office will provide for the respective support. In the event the DO fund group/fund sources assigned to a faculty Plan member’s FPM funding lines differ from the fund source assigned by the DO in AFB, then the effected pay lines in FPM need to be corrected.
AFB
FPM
Starting in FY17, a department may assign a Dean’s Office Source Code (i.e., Dean_01, etc.) to any Plan faculty salary component (X, Y, and/or Z) in FPM. The Dean’s Office Source Code of Dean_01 may now be selected under the Z/Stipend tab for a DO commitment funding a “Z” incentive. For each salary component assigned a DO Source Code in FPM, a department needs to enter and save an FP ID# corresponding to the FP ID# created in AFB for the DO support record funding the affected Plan member’s compensation.
BRUIN, JOE
BRUIN, JOE
BRUIN, JOE
(D-9)
The results of linking an approved DO support item in AFB to a Plan member’s funding/stipend lines in FPM can be viewed by using the new Approved Support button created in FPM. The window that subsequently opens by clicking on the “Approved Support” button displays all of the approved DO support records covering the affected Plan member along with a summarization of the total salary and benefit amounts being charged against each DO support item. This Approved Support window can be kept open on the desktop the entire time a user is working in FPM. The Plan faculty name displayed in the window refreshes to match the name showing in FPM. The closing of the FPM application automatically closes this window.
Information Displayed in the Approved Support Window Contains the Following Data Elements:
1. DO/HS = Funding Entity
2. Source = DO (Dean’s Office) or HS (Health System) FPM Code
3. Ref No = FP ID#/HS Rec #
4. Plus Benefits = If checked, benefits covered by DO/HS
5. Total Support = Plan faculty revenue dollars in AFB for assigned record number
6. Salary = For DO, salary net of 30% benefits. Except if DO not funding benefits, then salary based upon net of FPM “X” benefits. For HS, salary net of FPM “X” benefit rate
7. Benefits = For DO, 30% of salary. Except if DO not funding benefits, then benefits based upon FPM “X” benefit rate. For HS, benefits calculated on FPM “X” benefit rate
8. FPM Salary = Salary entered in FPM
9. FPM Benefits = Benefits derived based on X, Y, & Z entered in FPM for these funding sources
10. (Over) Under Used Support = (Over Spent) or Under Spent To see all instances of approved DO support along with the corresponding FP ID#’s covering Plan faculty salaries, a user should run the report in AFB under the “Reports” tabs entitled “Dean’s Office Support Linking Plan Faculty Salary Expense to Revenue.” The FP ID#’s referenced in this report should be used in assigning FP ID#’s in FPM for those Plan faculty with funding lines assigned a DO “Source Code.”
Bruin, Joe
(D-10)
New Dean’s Office Support Report Compares Approved DO Plan Member’s Support Against Salary Expense Budgeted in FPM
DEPARTMENT OF SURGERY / GENERAL 11/4/2015DEANS OFFICE SUPPORT - LINKING FACULTY SALARY EXPENSE TO REVENUE 12:26:03 PMFISCAL YEAR 2016-17
Fund Group: Compensation PlanFund: 62110 - Med Comp Plan
Source Fund DO Type FP Id Mis. +EBFaculty Name Description Remark AFB Revenue $ FPM Expense $ FPM Salary $ FPM Benefits $(Over)/Under Used Support
DEAN_01 62110 Recr 100 R BRUIN, SALLY BRUIN, SALLY ED&R 25,000 - - - 25,000DEAN_01 62110 Recr 101 R Y BRUIN, SALLY BRUIN, SALLY SAO 19,500 - - - 19,500DEAN_01 62110 Reten 47 R BRUIN, JOE BRUIN, JOE Faculty Retention Package 50,000 - - - 50,000Grand Total 94,500 - - - 94,500
(D-11)
HS (Health System) Support The “HS Support” tab is used for entering Health System (HS) support requests affecting the Compensation Plans. This tab is utilized by the Dean’s Fiscal Office to enter all continuing support requests that are subject to an annual review no later than December 1, 2015. Plan faculty salaries input in FPM using an HS Source Code (i.e., CPL_04, CPL_05, & CPL_07) only uploads into the AFB as compensation expense without any of this data feeding into the HS Support tab. A new “Approved Support” button feature has been added to FPM for the FY17 budget process. By clicking on this button a user is able to compare how much approved support covering a Plan faculty member’s compensation is presently being used by the associated funding line(s) set up for this individual in FPM. What enables the Dean’s Office and a department to know that an HS support request entered into AFB involves the coverage of a Plan faculty member’s salary is the selection of the “Category” of Plan Faculty as well as the selection of a name from a newly created “Faculty” pulldown list. For FY17, the assignment of the Plan faculty category to an HS support record was based upon whether there was one or more funding lines created for an individual Plan member in FPM that used an HS Source Code. A department may request for any approved HS support record that the Dean’s Fiscal Office change the “Category” from Other to Plan Faculty to indicate that the funding being provided is meant to cover a Plan member’s salary. What links the HS support covering a Plan faculty member’s salary to his/her funding lines in FPM is the use of the HS BOOK record number (i.e., HS Rec#) assigned to each continuing funding item by the Health System. This assignment is expected to occur no later than December 1, 2015 for continuing support items. For new, extension, or increase requests approved by the Health System in early February, each approved support item along with its HS Rec# will be updated by February 9, 2016. To see all instances of approved HS support along with the corresponding HS Rec#’s covering Plan faculty salaries, a user should run the report in AFB under the Reports tab entitled “Health System Support Linking Plan Faculty Salary Expense to Revenue.” The HS Rec#’s referenced in this report should be used in assigning HS Rec#’s in FPM for those Plan faculty funding lines assigned a HS Source Code. As a user, you have the ability to decide how the non-faculty expense for each HS support item is to be accounted for in the AFB. Each HS support record created and saved in AFB starts out displaying the No radio button under “Expense budgeted?.” In the event a user clicks on the “Dept Expense” button and budgets the corresponding expense to go along with this HS support record, then the radio buttons change from No to Yes. A user may however opt to add the budgeted non-faculty expense for an HS support item to the overall costs reflected on non-faculty expense lines created outside of the “HS Support tab.” This is an alternative approach to using the “Dept Expense” button. If this approach is used, an individual needs to click on the “Yes (Embedded)” radio button. Where a HS support request covering a Plan faculty member’s salary has one or more corresponding funding lines in FPM linked with the HS Rec# and this individual’s information is sent from FPM to the AFB after January 22, 2016, then the radio button under the question “Expense Budgeted?” changes from “No” to “Yes (Embedded).” The “Yes” or “Yes (Embedded)” radio buttons communicates to the assigned DO fiscal reviewer that the necessary expenses have been budgeted as an offset against a particular Health System support request. There is an active feature that enables a user to see the full rather than partial display of what has been saved in the Description or Remark fields for a record. To view the entire Description or Remark, double click inside the desired field and a pop-up window will display the full description.
(D-12)
How the Dean’s Fiscal Office Enters a Health System Support Request Under the HS Support Tab
Selection of “HS Type” Field The field entitled “HS Type” classifies a request as either of the following:
1. Directorship – Must meet the definition of a directorship as reflected in the HS’s BOOK – Directorship support for a Plan faculty member should be entered through FPM
2. Health Sys Transfer – All other support not defined as a Directorship must be treated as an HS Transfer
Selection of HS Fund Grouping The “HS Fund Grouping” field displayed provides one of 3 choices depending on the Hospital fund providing the support (i.e., CPL_04-HS-Westwood Hospital = Fund 63000, CPL_05-HS-Santa Monica Hospital = Fund 63200, and CPL_07-HS-Neuropsychiatric Hospital = 65100). Selection of Category This field entitled “Category” classifies a request as either of the following:
1. Plan Faculty – HS support meant to cover the Plan faculty salary expense created by setting up funding lines in FPM for an individual Plan member
2. Other – HS support meant to cover all expenses related to a funding commitment other than Plan faculty salaries
Selection of Faculty This field entitled “Faculty” contains a pulldown list of every plan faculty to whom an HS support request may be directly assigned.
See Entire “Description” or “Remark”
By Double Clicking In Field
Type Of HS Request
Being Funded
HS CPL Code Tied To
Hosp. Fund
Use To Budget Expense
Tied To Request
(D-13)
Designation of Request Status Each Health System support item input under the HS Support tab has a “Request Status” of Prior Approved. The selection of Prior Approved under “Request Status” defaults the “Review Type” to Continue. AFB will generate the corresponding Health System Support revenue in the appropriate Compensation Plan fund upon creating the record. The “Request Status” of Pending for Health System (HS) support requests has been disabled. If a HS support item is displaying the “No” radio button under “Expense Budgeted?,” then your department will be contacted in order to ascertain how the corresponding expenses tied to this support have been or are to be budgeted. Budgeting Expenses for a Prior Approved HS Support Request For each HS Support request entered under the “HS Support” tab, a department user may click on the “Dept Expense” button to budget the associated expenses. After an expense budget is created, the radio button for “Expense Budgeted?” will change to “Yes” from its default of “No” and the expense budget entries will be created in the appropriate Compensation Plan fund. As a user, you have the ability to choose how the expense for each non-faculty HS support item should be accounted for in the AFB. In addition to the budget program tracking the budgeted expense entered through the “Dept Expense” button, a user can click on the “Yes (Embedded)” radio button. Selecting this button conveys that the non-faculty expense(s) for a HS support item has been included in the overall costs reflected on budgeted expense lines not created under “HS Support” tab. Where a HS support request covering a Plan faculty member’s salary has one or more corresponding funding lines in FPM linked with the HS Rec# and this individual’s information is sent from FPM to the AFB after January 22, 2016, then the radio button under the question “Expense Budgeted?” changes from “No” to “Yes (Embedded).” “Yes” or “Yes (Embedded)” radio buttons communicates to the assigned DO fiscal reviewer that the necessary expenses have been budgeted as an offset against a particular HS support request.
There may be a rare case where a “prior approved” request for HS support is not tied to a specific set of expenses to be incurred in the budget year. But rather, the support applies to reimbursement for expenditures recorded in a prior fiscal year. In this particular case, a matching expense budget is not required. Budgeting the Expense for a Request Item by Using the “Dept Expense” Button. The “Dept Expense” button allows a user to budget the associated cost attributable to an HS request that’s been created under the HS Support tab. The steps for budgeting this expense is as follows:
1. Select request item in Grid from amongst all available records 2. Click “Dept Expense” button to be taken to a submenu 3. Select “Type of Expense” a single item from list 4. Input Amount 5. Click “Add Expense” button 6. Done if “Support Amount” = “Dept Expense” displayed in upper right of screen 7. If “Support Amount” does not equal “Dept Expense,” add another “Type of Expense” 8. Exit Submenu Only After Exp = Support
(D-14)
How To Handle A HS Support Request Where Expenses Budgeted Without Using the “Dept Expense” Button (After January 22, 2016 release of AFB)
1. Select “Prior Approved” request item in Grid from amongst all available records 2. Click radio button Yes (Embedded) 3. Click “Update” button located just above radio button Yes (Embedded)
Supp Amt = Dept Exp Exit Submenu
Exp Now
Shows As
Budgeted
For a DO Support Item Where Budgeted Costs Accounted For Elsewhere:
1. Click Radio Button Yes(Embedded)
2. Click Update Button
(D-15)
B. Health System Support Request No Longer Originating From FPM Plan faculty salaries input in FPM using a HS Source Code (i.e., CPL_04, CPL_05, and CPL_07) only uploads into the AFB as compensation expense without any of this data feeding into the HS Support tab. A new Approved Support button feature has been added to FPM for the FY17 budget process. By clicking on this button a user is able to compare how much approved support covering a Plan faculty member’s compensation is presently being used by the associated funding line(s) set up for this individual in FPM. What enables the Dean’s Office and a department to know that a HS support request entered into AFB involves the coverage of a Plan faculty member’s salary is the selection of the “Category” Plan Faculty as well as the selection of a name from the newly created “Faculty” pulldown list. What links the HS support covering a Plan faculty member’s salary to his/her funding lines in FPM is the use of the HS BOOK record number (i.e., HS Rec#) assigned to each funding request by the Health System. The inputting by the Dean’s Fiscal Office of all continuing HS support items is expected to occur no later than December 1, 2015. For new, extension, or increase requests, each item being funded plus the HS Rec# will be entered in AFB no later than February 9, 2016. To see all instances of approved HS support along with the corresponding HS Rec#’s covering Plan faculty salaries, a user should run the report in AFB under the Reports tabs entitled “Health System Support Linking Plan Faculty Salary Expense to Revenue.” The HS Rec#’s referenced in this report should be used in assigning HS Rec#’s in FPM for those Plan faculty funding lines assigned a HS Source Code. The DO Fiscal Office will assign an HS Rec# to each approved HS Support Revenue record involving faculty salary support. Once an approved HS Support Revenue record with a corresponding HS Rec# is created under the HS Support tab, it will appear under the Approved Support button in FPM. If the approved HS support includes benefits, the support budget will be calculated using the FPM “X” benefit rate for FY16-17. While there may end up being a small dollar difference between the budgeted HS support in AFB from the actual Plan faculty salary expense reflected in FPM, the Health System will fully fund the actual benefit expense, if a department requests a year-end true-up from the Hospital Budget Office and submits the necessary supporting documentation. The screen shots below demonstrate the tie-in between the HS funding support for a Plan faculty member in AFB and his/her funding lines in FPM.
AFB
BRUIN, JOE
(D-16)
FPM
Starting in FY17, a department may assign a Health System Source Code (i.e., CPL_04, CPL_05, & CPL_07) to any Plan faculty salary component (X, Y, and/or Z) in FPM. Any one of the Health System Source Codes may now be selected under the Z/Stipend tab for a HS commitment funding a “Z” incentive. For each salary component assigned a HS Source Code in FPM, a department needs to enter and save an HS Rec# corresponding to the HS Rec# created in AFB for the HS support record funding the affected Plan member’s compensation. The results of linking an approved HS support item in AFB to a Plan member’s funding/stipend lines in FPM can be viewed by using the new Approved Support button created in FPM. The window that subsequently opens by clicking on the “Approved Support” button displays all of the approved HS support records covering the affected Plan member along with a summarization of the total salary and benefit amounts being charged against each HS support item. This Approved Support window can be kept open on the desktop the entire time a user is working in FPM. The Plan faculty name displayed in the window refreshes to match the name showing in FPM. The closing of the FPM application automatically closes this window.
BRUIN, JOE
BRUIN, JOE
(D-17)
Information Displayed in the Approved Support Window Contains the Following Data Elements:
1. DO/HS = Funding Entity
2. Source = DO (Dean’s Office) or HS (Health System) FPM Code
3. Ref No = FP ID#/HS Rec #
4. Plus Benefits = If checked, benefits covered by DO/HS
5. Total Support = Plan faculty revenue dollars in AFB for assigned record number
6. Salary = For DO, salary net of 30% benefits. Except if DO not funding benefits, then salary based upon net of FPM “X” benefits. For HS, salary net of FPM “X” benefit rate
7. Benefits = For DO, 30% of salary. Except if DO not funding benefits, then benefits based upon FPM “X” benefit rate. For HS, benefits calculated on FPM “X” benefit rate
8. FPM Salary = Salary entered in FPM
9. FPM Benefits = Benefits derived based on X, Y, & Z entered in FPM for these funding sources
10. (Over) Under Used Support = (Over Spent) or Under Spent To see all instances of approved HS support along with the corresponding HS Rec#’s covering Plan faculty salaries, a user should run the report in AFB under the “Reports” tabs entitled “Health System Support Linking Plan Faculty Salary Expense to Revenue.” The HS Rec#’s referenced in this report should be used in assigning HS Rec#’s in FPM for those Plan faculty with funding lines assigned a HS “Source Code.”
Bruin, Joe
(D-18)
New Health System Support Report Compares Approved HS Plan Member’s Support Against Salary Expense Budgeted in FPM
DEPARTMENT OF SURGERY / GENERAL
10/23/2015
HEALTH SYSTEM SUPPORT - LINKING FACULTY SALARY EXPENSE TO REVENUE
2:29:44 PM
FISCAL YEAR 2016-17
Fund Group: Compensation PlanFund: 62110 - Med Comp Plan
Source Fund HS Type
HS Rec#
Mis.
+EB
Faculty Name Description Remark
AFB Revenue $
FPM Expense $
FPM Salary $
FPM Benefits $
(Over)/Under Used Support
CPL_04 62110 HSTrans 22 C BRUIN, JOE BRUIN, JOE SMH CMO 225,000 274,126 225,040 49,086 (49,126)Grand Total 225,000 274,126 225,040 49,086 (49,126)
(E-1)
PLAN FACULTY Entry of Plan Faculty salaries, funding, and advancement information will be done via the Dean’s Office Financial Projection Module (FPM). Refer to Plan Faculty Budget/ FPM Manual on the Dean’s Office website. The budgeted salary and benefit information will be automatically calculated to the respective fund or fund group based on department owner of the account from FPM as well as corresponding projections for January to June period of FY2015-16. As a reminder, whenever a pay line under the “Funding” tab in FPM is updated, a “Create Worksheets” button must be clicked before a Plan faculty member’s data can be uploaded to the AFB. This additional step ensures that the calculations and appropriate distributions to funding sources reflected in the budget are a more accurate representation of what is in the FPM than ever before. For your convenience, Plan Faculty sent from the FPM to the budget program may be viewed as read only. Reports on faculty salaries reflecting budgeted data are printed from the budget program. Selection of the “Compensation Plan Fund” grouping, division, and specific fund number determines the faculty member records that may be viewed. Optionally, those departments that have divisions may view faculty at the respective division or department level. Mission determinations for the projections and budget will be obtained from the account/cost center information. Faculty Ladder or Faculty Temporary totals are determined by title code. The plan title codes in the reference section have the corresponding expense row grouping. PLAN FACULTY TAB The Plan Faculty tab is activated when the “Fund Grouping” selection of “Compensation Plan” is made. It is not activated for any other fund grouping even though faculty salaries may be charged to other funding sources.
Once the specific fund number for the “plan fund” is selected, all the faculty members within that plan are available for viewing after they have been sent to the budget program from the FPM program. In order to navigate through the budget program to view Plan Faculty, use the “Find” feature to select the faculty member. If there are any corrections to be made, contact your staff to make the desired changes in FPM. You may view the following information: • Division Division acts as a filter on the number of individuals in the review set. Division is determined from data entered in FPM.
2016-17
Plan Faculty
Tab
(E-2)
• Employee ID This is the nine-digit University identifying number assigned when an individual is hired. See below for New Appointments or Open Positions. • Name The individual’s last name is followed by first name and middle initial. • New Appointments or Open Provisions New or pending appointments and open provisions may be entered or updated from previous budgets in FPM and sent to the budget program. For open provisions, include them as __Open1, ___Open2, and so forth. Further identification of departmental activity, such as Reproductive Endocrinology, is helpful as well. All open positions designated this way will appear at the end of the report. It is important that the underscore in front of the Open1 and Open2 be entered so that in the program they are alphabetized at the end. The employee ID will be blank if it has not been assigned or is an open position. Be sure to review the Open positions in FPM and delete any not needed for budgeting. SALARY INFORMATION & COMPONENT PARTS- MCP/PCCP and BSCP Imported information is based on the Dean’s Office Financial Projection Module database with budgeted data entered for July 2016 through June 2017. Annual salaries are displayed in the middle portion of the plan faculty tab screen and in a column on the left. • APU Base Salary (X & X’) The APU Base Salary is the approved salary component on one of the Health Sciences Compensation Plan Salary Scales, associated with the faculty member’s academic rank, step and Academic Programmatic Unit (APU). The APU Base Salary is considered covered compensation under the University of California Retirement Plan (UCRP) up to the amount permissible under law and in accordance with UCRP provisions and regulations. Salary scales are assigned to academic programmatic units as recommended by the Chair and approved by the Dean. The first portion of the APU Base Salary or “X” in the budget program is the individual’s Fiscal Year Scale 0 Base Salary, according to his or her approved rank and step or pending rank and step effective July 1. State funds may be used up to the Fiscal Year Scale 0 salary rate. State AIDS funds may be used only for non-Ladder Rank faculty. The second and third portions of Base Salary or “X-prime” are the two base increments above the Scale 0 rate. Addl Base <=3 represents the difference between Scale 0 and the Scales 1-3. Addl Base >3 represents the difference between Scale 3 and Scales 4-9. They may be funded from any source that permits faculty salary charges except State 199XX and AIDS funds. Visiting and Recall titles on all plans as well as ILP are not eligible for the X prime. • Negotiated Additional Compensation (Y) Plan members may receive a negotiated additional component of compensation or “Y” beyond the APU Base Salary, but it is not covered compensation under UCRP. It is annually negotiated, funded from allowable fund sources, and paid monthly. Negotiated additional compensation may be from any source that permits faculty salary charges except State 199XX and AIDS appropriations. For all X and Y portions of salary, cost amounts will automatically be calculated. The sum of the costs by source is the annual cost to be budgeted. This figure may differ in total with the annual salary if the individual does not have a full salary for the year such as in part-time or partial year appointments or sabbatical leaves at less than full salary. The calculations for part-time and partial year are automatically calculated based on the percentage in the “Time %” field. The sum of the costs cannot be greater than the annual salary.
(E-3)
• Total Negotiated Salary (TNS) The Total Negotiated Salary refers to the sum of the annual amounts for APU Base Salary (X + X’) and Negotiated Additional Compensation (Y). The annual rates are to be rounded to the nearest $100 and will be used in determining the individual’s approved salary for the year. • Title Code and Step Review the information for the appropriate values for the individual’s series and rank. Any corrections or updates to title code or step must be made in FPM. Steps are shown as 1, 2, 3, etc. rather than Roman numerals. The letter A is shown for Above Scale and Further Above Scale. It is extremely important that the title codes and steps are correct as they, along with the APU and scale, are used to link the computerized “look-up” table with the scales and corresponding automated calculations. The title code will be used to program the row category for the reports. The plan titles in the reference section of the workbook indicate which are Faculty-Ladder (FLAD) and Faculty-Temporary (FTEM) and are in line with the Chancellor’s Office budgeting groupings. • APU Code/Scale Review the APU code for the individual. Make sure the appropriate one is selected. The scale associated with the APU code is listed, e.g., 3 for Scale 3. The APU scale designation along with the title code and step determine the APU Base X values.
An Academic Programmatic Unit (APU) is defined as a group of faculty with similar clinic and/or teaching and research responsibilities. In the Faculty and Salary Information Template, include the Department's recommendation for any changes to be made for an existing APU to the Dean’s Office for review and approval. Submit a separate letter to Dr. Jonathan Hiatt and Anja Paardekooper containing an explanation or the criteria utilized along with the recommended scale. A template for each plan, MCP or BSCP, may be obtained from the WRITE-UPS tab. The Dean’s Office recommends that all Visiting and Recall appointees be in an APU set at Scale 0 as they are not eligible for retirement coverage. Include a statement regarding faculty participation in the determination of the APU and scale being considered. Refer to your department’s Health Sciences Compensation Plan Bylaws. An APU may advance to the next highest scale one year at a time assuming there is evidence of a continuing income stream sufficient to support the increase in salary and benefit costs. For example, an APU approved for Scale 3 (1.3) in 2015-16 may move to Scale 4 (1.4) for 2016-17, provided there is sound fiscal evidence to conclude that net revenues will continue to be realized at a level sufficient to sustain the increase. However, an APU may be reassigned to the next lower scale after one year in cases where there is a drop in available funding. All plan members in an APU will be on the same scale. See the Campus Procedures regarding split appointments between two different APUs. Only when the APU has been approved, may you add or modify APU codes and scale designations by entering the coding and scale designations in FPM. Contact the Dean’s Office Academic Affairs before making any APU changes. The APU code being used for FPM and the ADB has 6 digits with the first 4 associated with the department code and the last two related to the APU group and may be alpha or numeric characters. A scale is designated with the code. To change the code or scale, in FPM click in the APU or Scale box and edit. Note, however, that the APU code assigned on the campus Employee Database (EDB) may have a 6-digit code with the first 4 digits associated with the department code and the last two digits the actual scale designation. • % Time This field indicates the part-time percentage the individual is working or paid. This area indicates also partial year appointment percentages. For example, if an individual starts October 1, 2016, then 0.75 designates the 3/4ths of the year as a percentage. If an individual is part-time, e.g., 50%, and works only 6 months, the resulting percentage, e.g., 25% may be shown. The % Time field affects annual pay amounts in the distributed source grid area in the Plan Faculty Tab.
(E-4)
• AAMC Specialty The AAMC Specialty coding is for salary analysis comparisons with the Association of American Medical Colleges (AAMC) data for the specialty. The number following the abbreviation for the specialty was previously the table number for the data from the AAMC. We are using “27” to indicate the table with data for “M.D. Public and Private Schools, all pay” for MCP faculty. We are using “34” to indicate the table with data for “Ph.D. or Other Doctoral Public and Private Schools, with all pay components” for PCCP or BSCP faculty. • Location Review the information for the individual and select the appropriate location. If an individual is at more than one site, select one for a primary location, preferably based on the greatest percentage of time. • Sex This is for designation of gender M for Male and F for Female. The gender is blank for open positions.
• Firm The “Firm” designation determines the Salary Adjustment Instruction for how the individual’s salary components are to be adjusted when the Regents have approved the new scales for the Budget Year. The selection for the individual should agree with what is on the Salary Adjustment Instruction sheet (included on the template of the WRITE-UPS tab). For individuals whose negotiation is at the scale level only for the APU (also referred to as X only), a Y Firm designation should be appearing. The Y that is negotiated has a value of zero.
• Affiliated FTE This indicates the portion of Full Time Equivalent (FTE) component the individual is at the affiliated institution. For example, if an individual has 100% appointment with the V.A., 1.00 is entered. If an individual has a 5/8ths appointment, then 0.625 is entered. • Benefit Rate This is the average benefit rate for a full 12 months calculated in FPM using FY14-15. This rate has been adjusted for any anticipated increases in the UCRP contribution and health insurance premiums. The derived benefit rate will be used in estimating budgeted benefits for each plan faculty member by source. An additional 1.00% has been added to the X and Y components for health benefit costs. With the UCRP employer contribution for FY16-17 expected to be maintained at the same percentage as FY15-16, there’s no need to further adjust the benefit rates for all “X” components for this coming budget year. Given that the current UCRP employer contribution instituted by the Regents of the University of California is remaining static for FY16-17, a 0.00% increase is being budgeted for the coming budget year. Review the benefit rate assigned to each of the department’s Plan members for reasonableness. Any necessary changes may be implemented from FPM. • State FTE and NPI FTE Boxes Checking one of these boxes indicates whether the individual is a state-funded (19900) Full Time Equivalent (FTE) or NPI state-funded (19900) FTE. These areas determine the default distribution sources in the FPM. • Off-Scale Box This box will have a check if the individual is off-scale or above-scale. If the individual is to be on-scale effective 7/1/16, then make the change in FPM. If an individual has an off-scale salary, see steps (1) and (2) below and any special instructions distributed for the interim implementation of the Health Sciences Compensation Plan for BSCP members. All new or increased off-scales or above-scales are subject to the Academic Personnel approval process.
(1) Off-Scale Base X-No Merit/Promotion If the individual has an off-scale Base X salary with no pending merit or promotion, for this Budget Year use the last approved off-scale Base X rate.
(E-5)
(2) Off-scale Base X- Merit/Promotion If the individual has an off-scale Base X salary with a merit or promotion pending, use the scale provided, apply the return-to-scale schedule, and then the merit or promotion. If you have any questions, see the contact list for assistance.
• Fellow Box A check in the “Fellow” box indicates the status for those individuals regardless of the academic title code. • Chair Box A check in the “Chair” box indicates the individual who is the Chair of the Department. • Merit/Promotion Box A check in this box indicates pending or approved merits or promotions • No Export Box If individuals to be funded by the department from professional fees are plan members located at Olive View or Harbor, then this box is checked. This avoids duplication for salary analysis purposes. See the contact list for assistance for total negotiated salary and other pay sources, if needed. • PCCP Box This box is checked for individuals in the PCCP plan. They will appear on the Report for Annual Negotiated Salaries after the MCP or BSCP members as applicable. • On Z Report and Incentive/Bonus Compensation Z (or Delta Z) This box is checked for inclusion on the special Z report. If any of the faculty members are ineligible for the department’s Z incentive arrangement, then update the information in FPM. Faculty members with checked boxes will appear on the special Z report that reflects the department’s ability to meet the Schoolwide targets for Z incentives. Z is entered in FPM. Caution is advised on the amount entered and payment period since FPM treats the amount as monthly. Incentive/Bonus Compensation Z is the estimated annual cost only of the additional compensation that is an "incentive or bonus" payment by individual. The Z is paid on a “by agreement” basis at variable times during the year, e.g., annually, quarterly. If your department follows a quarterly payout pattern, then budget 4th quarter FY16, 1st, 2nd, & 3rd quarters in FY17. Only professional fee sources (Compensation Plan Funds) may fund Z. We are continuing the Schoolwide goal of having 25% of faculty salaries paid from the Compensation Plan being in the form of Z payments. The 25% target is not applied to the Compensation Plan salaries of individual faculty members, but rather to the overall level of faculty salaries funded from the Plan. There is a report “Z as a Percentage of Total Salary on Professional Fees” available in the Reports tab of the Budget program. Faculty with checked boxes for inclusion in the Z report from the Faculty Information Input Screen will be reflected on the report. The formula for distribution should conform to your department’s Health Sciences Compensation Plan bylaws or official procedure. The Department’s updated Compensation Plan Bylaws or written procedures based upon the UCLA School of Medicine Implementing Procedures effective July 1, 2015 for the Health Sciences Compensation Plan are to include at a minimum the following:
o Participation of faculty members, or a committee of faculty members, in the development and adoption of the methodology for determining an individuals’ additional compensation;
o Criteria for determining negotiated additional compensation (“Y”); o Criteria for earning or calculating optional incentive/bonus compensation (“Z”); o A statement regarding the timing of the distribution and payment of any incentive/bonus
compensation (“Z”); o A description of benefits to be received pursuant to section IV.B. & C. of the SOM Implementing
Procedures; & o A description of department taxation policies.
(E-6)
• Notes The following information is required in the “Notes” area if it is applicable to the individual named:
- part-time appointment (The “% Time” should be filled in on FPM.) - appointment effective date, if new 07/01/17 or later in the year. (The “% Time” should be
filled in on FPM.) - separation effective date (The “% Time” should be filled in on FPM.) - sabbatical leave dates, if funded at less than full salary. (The “% Time” should be filled in
on FPM.) - outside agency description for direct payments for source code DP_07 Direct Pay Other
Affiliated Hospitals and DP_09 Direct Pay Other. (Information is used by the Dean’s Office staff for annual reporting, e.g. to the AAMC.)
Summary Tab Feature:
By clicking on the Summary Tab all source codes by salary component will be displayed.
Show Summary
Summary of Sources for Salary Parts
(E-7)
SOURCE FILTER FEATURE: To view individuals with the same salary source codes, use the filter feature.
SOURCE CODE LIST In the budget program, we have a source coding to designate groups of fund numbers. The same coding has been incorporated into FPM. The source coding is essential in generating the summary of resources reports. Budgeted salary and benefit information will be automatically calculated to the respective fund or fund group based on department owner of the account from FPM as well as corresponding projections for January to June period of FY15-16. It is important to include the account and actual fund number whenever projecting or budgeting at the fund number level, e.g. Indirect Cost Recovery funds. For Contracts & Grants, Gifts, and Endowments, it is not critical for budgeting purposes to enter a specific fund number. The listing and description of the budget program source codes, their restrictions, and the corresponding University fund codes follows. These are provided as a “drop down list” in FPM and on the Plan Faculty Tab in the budget program for filtering. SOURCE CODES LIST FOR FACULTY SALARIES Grouping Code Description State Funds STATE_01 State Funds-199XX-Dept FTE
STATE_02 State Funds-199XX-Dept Temp STATE_03 State Funds-199XX-NPI FTE STATE_04 State Funds-199XX-NPI Temp STATE_05 State Funds-199XX-Letters & Sciences Tem STATE_06 State Funds-19900-Other Schools, e.g. Publ Hlth STATE_07 State Funds-19900 Chancellor STATE_08 State Funds 19910 Geriatric Research or Other
Federal C& G NIH_01 Fed C& G-NIH/SAMHSA
FCG_01 Fed C&G-Other Agencies
Private PCG_01 Private-Contracts & Grants CTR_01 Clinical Trials GFT_01 Private-Gifts END_01 Endowments
Source list filter
(E-8)
SOURCE CODES LIST FOR FACULTY SALARIES (con’t) Grouping Code Description Local Gov’t LCG_01 Local Gov’t-L.A. Co. Agmt-Harbor
LCG_02 Local Gov’t-L.A. Co. Agmt-Ol Vw LCG_03 Local Gov’t –Other SCG_01 State Agmt
Prof. Fees CPL_01 Prof Fees-Dept
CPL_02 Prof Fees-Other CPL_03 Prof Fees-Salary Savings-Fund Source Exchange CPL_04 Prof Fees-HS - Westwood Hospital CPL_05 Prof Fees-HS - Santa Monica Hospital CPL_06 Prof Fees-FPG (3906) CPL_07 Prof Fees-NPH
Dean DEAN_01 Dean’s Office Support
DEAN_02 Dean’s Office-Student Fees- (Education)-20226 DEAN_03 Dean’s Office-State Funds-199XX- (Fund Source Exchange) DEAN_04 Dean’s Office-State Funds-199XX-Salary Savings Support DEAN_05 Dean’s Office-Indirect Cost Recovery DEAN_06 Dean’s Office-Geffen Fund (Gifts) DEAN_07 Dean’s Office-Other Gifts & Endowments DEAN_08 Dean’s Office-Sales & Services DEAN_09 Dean’s Office-Contracts & Grants DEAN_10 Dean’s Office – Switzer Fund (Gifts) DEAN_11 Dean’s Office – Other UCLA
Other UCLA ICR_01 Indirect Cost Recovery-Opportunity & Overhead
SNS_01 Sales & Service-6XXXX OTH_01 Other UCLA-6XXXX (Other than Sales & Service and CPL)
Direct Pay DP_01 Direct Pay-Vet Admin-Wadsworth (West LA) DP_02 Direct Pay-Vet Admin-Sepulveda DP_03 Direct Pay-Vet Admin-Brentwood DP_04 Direct Pay-L.A. Co. Harbor DP_05 Direct Pay-L.A. Co. Ol Vw DP_06 Direct Pay-L.A. Co. MLK DP_07 Direct Pay-Other Affil Hosp (identify hospital) DP_08 Direct Pay- HHMI DP_09 Direct Pay- Other (identify source)
STATE FUNDS-199XX (See also Dean’s Office Sources) These are sources provided to the University by the State of California that the Accounting Office assigns in the fund block 19900-19999 (excluding ICR funding in this block). General Funds (19900) are the most common source in this category. They may be used to fund an individual’s base salary equal to the Fiscal Year (11-Month) Regular Salary Scale 0 only subject to Academic Personnel policy limitations regarding the title series. Geriatric Research Funds 19910 may be used only for base salaries of non-Regular Rank state-supported faculty. Funds in block 19900-19999 may not be used for Plan members’ compensation above Scale 0. For temporary 19900 funds provided by the Dean’s Office, refer to the section below under Dean’s Office Sources.
For our budgeting purposes, we have designated six Sources as follows: STATE_01 State Funds 199XX-Dept FTE.
Use this source code to designate those 19900 funds that are assigned to the department for filled positions.
(E-9)
STATE_02 State Funds 199XX-Dept Temp. Use this source code to designate those 19900 funds that are available to the department from salary savings or positions allocated to the department but currently unfilled on a permanent basis.
STATE_03 State Funds 199XX-NPI FTE
Use this source code to designate those 19900 funds that are assigned to the NPI for filled positions. For example, Psychiatry, Neurology, and Pediatrics have faculty with NPI FTE.
STATE_04 State Funds 199XX-NPI Temp.
Use this source code to designate those 19900 funds that are available to the department from salary savings or positions of NPI FTE but are currently unfilled on a permanent basis.
STATE_05 State Funds 199XX-Letters & Sciences Temp.
Use this source code to designate those 19900 funds that are to be provided from the College of Letters and Sciences. Although the individual may have a permanent FTE in Letters and Sciences, for our School’s Budget we will designate these funds as “temporary.”
STATE_06 State Funds 19900-Other Schools, e.g. Public Health, Dentistry
Use this source code to designate those 19900 funds that are to be provided from other Schools, such as Public Health or Dentistry. Although the individual may have a permanent FTE in Public Health or Dentistry or some other School, for our School’s Budget we will designate these funds as “temporary.”
STATE_07 State Funds 19900 Chancellor
Use this source code to designate those 19900 funds that are provided from the Chancellor for service to central committees, boards, etc.
STATE_08 State Funds 19910 Geriatric Research (EDR) or Other
Use this source code to designate support from the Geriatric Research Fund 19910 or other 19900-19999 sources not specifically listed above. The Geriatric Research Fund 19910 may be used only for base salaries of non-Regular Rank state-supported faculty.
• FEDERAL CONTRACTS AND GRANTS (See also Dean’s Office sources) These are sources provided to the University through contracts and grants with federal agencies that the Accounting Office assigns in the fund block 21000-33999. Only include funded renewals or continuation grants. Do not include any grant up for competitive renewal unless you have received funding notification.
For our budgeting purposes, we have designated two Sources as follows: NIH_01 Federal C& G-NIH/SAMHSA/AHRQ
Use this source code for awards made by the National Institutes of Health (NIH), the Substance Abuse and Mental Health Services Administration (SAMHSA), or the Agency for Healthcare Research and Quality (AHRQ). For awards made by these agencies from appropriation funds effective as of January 11, 2015, the salary limitation (NIHCAP) annual rate is $183,300. This is an increase in the salary cap of $1,800 from the prior cap amount. See the Dean’s Academic Personnel website for a complete history or the government website http://grants1.nih.gov/grants/policy/salcap_summary.htm. Any updates will be communicated to you.
FCG_01 Fed C& G-Other Agencies.
Use this source code for awards made by federal agencies other than NIH, SAMHSA, or AHRQ.
(E-10)
• PRIVATE CONTRACTS, GRANTS, GIFTS, AND ENDOWMENTS (See also Dean’s Office sources) These are sources provided to the University from private or non-governmental agencies. The Accounting Office assigns private contracts, grants, and gifts to fund blocking 39800-59999 and 77500-84999 (new range effective FY07). For endowments or funds functioning as endowments, the Accounting Office assigns them to fund blocking 04100-09799, while the endowment income is assigned to 34100-39799. For our budgeting purposes, we are including any Agency fund, that is, in the blocking 00001-00299 to be with this grouping.
For our budgeting purposes, we have designated four Sources as follows: PCG_01 Private-Contracts & Grants
Use this source code to designate those awards that are processed through the Office of Contract and Grant Administration (formerly Office of Sponsored Research). Also, use this coding for any plan faculty sources charged to Agency funds (fund codes 00001-00299).
CTR_01 Clinical Trials Use this source code to designate those funds for clinical trials. You may have previously coded these with Private Contracts & Grants. UCLA’s Office of Contract and Grants Administration issued the following definition for a clinical trial. “A clinical trial is a study designed to assess in humans the safety, efficacy, benefits, adverse reactions, and/or other outcomes of drugs, devices, diagnostics, treatments, procedures, medical evaluations, monitoring or preventive measures.”
GFT_01 Private-Gifts Use this source code to designate those awards that are processed through the Public Affairs and Development Office.
END_01 Endowments
Use this source code to designate sources in blocking 04100-09799 and 34100-39799 except fund numbers designated as Indirect Cost Recovery, e.g. 09549, 05399.
• LOCAL GOVERNMENT (See also Dean’s Office Sources) These are contracts and grants awarded by local government agencies and the State, including special State appropriations, and assigned by the Accounting Office in fund blockings 18000-18887, 18889-18999, 20400-20999, 77001-77499 (change in block range effective FY07). For funds provided for General funding purposes from the State, see STATE_01 to STATE_08.
For our budgeting purposes, we have designated the Sources as follows: LCG_01 Local Gov’t-L.A. Co. Agmt- Harbor
Use this source code to designate that portion of the Operating Agreement with Los Angeles County for teaching and professional services at Harbor-UCLA Health System. The fund number in current use is 20713 for 2015-16. For direct pay to the faculty member by Los Angeles County, refer to Source DP_04, Direct Pay-Los Angeles County, Harbor.
LCG_02 Local Gov’t-L.A. Co. Agmt- Olive View
Use this source code to designate that portion of the Operating Agreement with Los Angeles County for teaching and professional services at UCLA - Olive View Health System. The fund number in current use is 20713 for 2015-16. For direct pay to the faculty member by Los Angeles County, refer to Source DP_05, Direct Pay-Los Angeles County, Olive View.
LCG_03 Local Gov’t-Other
Use this source code to designate awards from local government agencies in fund blocking 20600-20999 and 77001-77499 (new block ranges effective FY07) excluding ANY fund designated for the L.A. County agreements for Harbor and Olive View within the last 5 years (20671, 20768).
(E-11)
SCG_01 State Agreements Use this source code to designate the specific contracts and grants or special appropriations in fund blockings 18000-18887, 18889-18999, and 20400-20599 (change in block range effective FY07). Funds awarded by the University-wide Task Force on Aids (funds 20520-20522) may not be used for Regular Rank state-supported faculty. Also, they may not be used for compensation above Scale 0 for any faculty.
PROFESSIONAL FEES (See also Dean’s Office Sources) These are funds pursuant to the terms of the respective Compensation Plans. These funds are assigned in the fund blocking 60000-69999. For budgeting purposes, we have identified the breakdown of categories as follows: CPL_01 Prof Fees-Dept
Use this coding to designate the department’s professional fees that are derived from current operations. See other codes for current funds provided by the Dean Offices and recharges to the UCLA Health System and the Neuropsychiatric Hospital. See CPL_02 for special circumstances, including use of compensation plan funds pending receipt of contracts and grants.
CPL_02 Prof Fees-Other
Use this coding to designate the department’s professional fees that have been designated for academic improvement for the division or individual or if the department is temporarily using compensation plan funds pending approved contracts and grants. A pop-up box will appear for selection of type of use, such as, “pending contracts and grants,” “start-up,” “retention,” or use of “individual reserves.” Use of this code will create a report detailing the identified categories.
CPL_03 Prof Fees-Salary Savings-Fund Source Exchange Optionally, use this coding to designate the department’s professional fees that will be received in exchange for other sources. For example, faculty in the Department of Psychiatry receive 19900 funds for service on committees that are exchanged with professional fees from the Dean’s Office. Use of this source code will create a value on the Interfund (Revenue side) row as well as the appropriate faculty expense. A benefit calculation will be added automatically for the revenue figure based on the individual’s benefit rate for the salary component.
CPL_04 Prof Fees-HS-Westwood Hospital Use this coding to designate professional fees generated by recharging or transfers with the UCLA Health System for faculty services provided for administrative functions and patient care services or for support of the Westwood Hospital. Expenses for faculty salaries are entered against professional fees. The funding line(s) established should coincide with an approved revenue recharge or transfer under Health System Westwood created by the Dean’s Office to offset this compensation cost. The inclusion of a reimbursement amount for benefits only becomes part of the revenue figure in the event the Health System agreed to cover these expenses.
CPL_05 Prof Fees-HS–Santa Monica Hospital
Use this coding to designate professional fees generated by recharging or transfers with the UCLA Health System for faculty services provided for administrative functions and patient care services or for support of the Santa Monica Hospital. Expenses for faculty salaries are entered against professional fees. The funding line(s) established should coincide with an approved revenue recharge or transfer under Health System Santa Monica Hospital created by the Dean’s Office to offset this compensation expense. The inclusion of a reimbursement amount for benefits only becomes part of the revenue figure in the event the Health System agreed to cover these expenses.
CPL_06 Prof Fees-FPG (Managed Clinics & Administrative Services) Use this coding to designate professional fees generated by recharging the Faculty Practice Group (FPG) Managed Clinics (i.e., CPN, SMBP, EIMG, SCN, etc.) & Managed Administrative Service units (i.e., PSS, etc.) for faculty services supporting administrative functions and patient care activities. Use of this source code will create a revenue entry (FPG Recharges) as well as expense. A benefit calculation will be added automatically for the revenue figure based on the individual’s benefit rate for the salary component.
(E-12)
CPL_07 Prof Fees-Neuropsychiatric Hospital Use this coding to designate professional fees generated by recharging or transfers with the UCLA Health System for faculty services provided for administrative functions and patient care services or for support for the Neuropsychiatric Hospital. Expenses for faculty salaries are entered against professional fees. The funding line(s) established should coincide with an approved revenue recharge or transfer under Health System Neuropsychiatric Hospital created by the Dean’s Office to offset this compensation expense. The inclusion of a reimbursement amount for benefits only becomes part of the revenue figure in the event the Health System agreed to cover these expenses.
DEAN’S OFFICE SOURCES These funds can be from any source available to the Dean’s Office. The codes were expanded to accommodate “all funds budgeting.” Use of the source codes for plan faculty salaries is for continuing, pre-approved items only. Please refer to the section of this workbook on “Dean’s Support” for what to do for new, increase, or extended funding requests. The selection of a Dean’s Office source code (Dean_01, Dean_02, and Dean_05 through Dean_11) results in the assignment of a salary and benefit expense amount to the Fund Group/Fund represented by the code chosen. For each approved support item, a corresponding revenue entry needs to be created under the DO Support tab (refer to Support section of this manual). Explanations and descriptions will be required. In FPM, enter salary amounts only. Benefits based on the individual’s rate will be calculated for you for the revenue portion of the transaction. So, if the approved, continuing amount of block support is $50,000 and the individual’s benefit rate is 29%, divide the $50,000 by 1.29, which equals $38,760. Enter $38,760 for the salary portion in FPM. The benefit portion of 29% times $38,760 is $11,240. $38,760 + $11,240 is $50,000. DEAN_01 Dean’s Office Support
This code should be selected if the source is to be one of the Dean’s Office compensation plan professional fee sources.
DEAN_02 Dean’s Office-Student Fees- (Education)-20226 Use this source code to designate support from the Dean’s Office from fund 20226, Student Fees. The fund source is used predominantly for service to the Dean’s Office Educational Development & Research (ED&R) unit. Use of this code will generate expenses to the professional fee portion of the budget.
DEAN_03 Dean’s Office -State Funds-199XX-Fund Source Exchange The Dean’s Office will select this code to designate use of temporary 19900 funds that will be made available to the department in exchange for a transfer from the department of professional fee funds. Use of this code will not affect plan faculty expenses to the department’s professional fee funds, but will generate an Interfund Transfer Expense. Corresponding revenue under State Appropriations will be calculated.
DEAN_04 Dean’s Office State Funds 199XX-Academic Salary Savings Use this source code to designate those 19900 funds that are to be provided as support from the Dean’s Office salary savings on a temporary basis. Use of this code will not affect plan faculty expenses or revenues to the department’s professional fee funds. Explanations and descriptions will be required. Revenue including a calculation for benefits will be reflected under “Support from Dean’s Office” for approved items only.
DEAN_05 Dean’s Office Indirect Cost Recovery The Dean’s Office will select this code to designate funds requested from the Dean’s Office that may be from Dean’s Indirect Cost Recovery. Use of this code will not affect plan faculty expenses or revenues to the department’s compensation plan funds.
DEAN_06 Dean’s Office-Geffen Fund This code will be selected to designate funds from the Dean’s Office that will be from the Geffen Gift fund 53287. Use of this code will not affect expenses or revenues to the department’s compensation plan funds or reports.
(E-13)
DEAN_07 Dean’s Office-Other Gifts & Endowments This code will be selected to designate funds from the Dean’s Office that will be from Gift or Endowments other than the Geffen Gift fund 53287 and Switzer Gift fund 51409. Use of this code will not affect expenses or revenues to the department’s compensation plan funds or reports.
DEAN_08 Dean’s Office-Sales & Services
This code will be selected to designate funds from the Dean’s Office that will be from Sales & Services funds, such as the Provost Fund. Use of this code will not affect expenses or revenues to the department’s compensation plan funds or reports.
DEAN_09 Dean’s Office-Contracts & Grants This code will be selected to designate funds from the Dean’s Office that will be from Contract & Grant funds, such as the Los Angeles County contract or ED&R grant funding. Use of this code will not affect expenses or revenues to the department’s compensation plan funds or reports.
DEAN_10 Dean’s Office-Switzer Fund (Gifts)
This code will be selected to designate funds from the Dean’s Office that will be from the Switzer Gift fund 51409. Use of this code will not affect expenses or revenues to the department’s compensation plan funds or reports.
DEAN_11 Dean’s Office-Other UCLA Funds This code will be selected to designate monies provided by the Dean’s Office that will be from the created category of Other, such as the CTSI and Patent funds. Use of this code will not affect expenses or revenues to the department’s compensation plan funds or reports.
• OTHER UCLA SOURCES (See also Dean’s Office Sources) For budgeting purposes, we have designated the following Sources: ICR_01 Indirect Cost Recovery-Opportunity & Overhead Funds-Department
Use this source code to designate Departmental Indirect Cost Recovery funds. If the Indirect Cost Recovery funding is from the Dean’s Office, however, use source code DEAN_05.
SNS_01 Sales & Service-6XXXX These are funds assigned in the fund blocking 60000-69999 but are not the Professional Fee (plan) or Other funds. Generally, these are other revenue-generating activities of a department. If these sources are supporting a material part of a Plan member’s salary due to her providing ongoing services to the operations, then the department should directly charge these 6XXXX source(s).
OTH_01 Other-6XXXX & 7XXXX These are a subset of the funds assigned in the fund blocking 60000-69999 but are not the Professional Fee (plan) or Sales & Service funds. As of the writing of this workbook, there are only two 7XXXX funds assigned under other (i.e., 75523 & 75544). Generally, the activities carried out under these funds are funded by a transfer of monies to a department.
• DIRECT PAY These are amounts paid directly to the individual and are included as part of the total negotiated salary. For budgeting purposes, we have designated the following nine Sources: DP_01 Direct Pay-Vet Admin-Wadsworth DP_02 Direct Pay-Vet Admin-Sepulveda DP_03 Direct Pay- Vet Admin-Brentwood
Use these source codes for direct salary payments to the individual from the Veterans’ Administration Hospital- Wadsworth, Sepulveda, and Brentwood, respectively.
DP_04 Direct Pay Los Angeles County-Harbor DP_05 Direct Pay Los Angeles County-Ol Vw DP_06 Direct Pay Los Angeles County-MLK
(E-14)
Use these source codes for direct salary payments to the individual from the Los Angeles County locations of Harbor, Olive View, and Martin Luther King, respectively. See also LCG_01 and LCG_02 for faculty salaries charged to the UCLA-L.A. County Operating Agreement fund.
DP_07 Direct Pay-Oth Affil Hosp (identify hospital)
Use this source code for direct salary payments to the individual from other affiliated hospitals, such as Cedars-Sinai Health System. Identify hospital by describing in the notes area for the individual in FPM.
DP_08 Direct Pay- HHMI
Use this source code for direct salary payments to individuals who are Howard Hughes Medical Investigators (HHMI).
DP_09 Direct Pay-Other (identify sources) Use this source code for direct payments by any other agency, such as Rand. Identify source by describing in the notes area for the individual in FPM.
Use great care in estimating the direct pay categories. These are used in determining the net gross pay provided by the University when adjusting the salaries in July.
(F-1)
ACTUAL + PROJECTION/ DESIGNATION OF BALANCES
All fund groups are provided under the “Act + Projection & Desig. Of Bal.” tab. Other than Contracts & Grants and Gifts & Endowments, you will be budgeting by the individual funds under each fund group. Only the Compensation Plan funds use the “Income“ and “Expense” tabs for budgeting 2016-2017 revenue and expenditures, respectively. For all Comp Plan funds this section is used solely to project 2015-2016 financial activity through June 30, 2016 and designate the split in the projected 2015-2016 fund balance between the Chair, Chief (or Program), and individual. The following is the color scheme used for the “Act + Projection & Desig Of Bal.” tab that defines the particular nature of the individual cells being displayed:
Peach = A read only cell with underlying detail records – Double-click cell to access records Green = A cell in summary mode – Allows entry of a single number White = A read only cell with no underlying detail records Black = A cell in detail mode – Allows multiple line entries
The current year 2015-2016 budget column under this tab serves as an aid in developing the amount being projected through June 30th for each revenue or expense row. A feature under this tab permits a user to see the detail transactions making up a particular revenue or expense row within a column containing actual information simply by double-clicking on the field containing the amount for which you wish to see the detail. This feature is active for all fund groups except “Contracts & Grants” and “Gifts & Endowments.”
A user is able to utilize a set of toggle buttons to switch a “green” input projection cell or budget cell from a single number entry to multiple line entries per cell. The “Toggle Proj Edit” button can switch one “green” projection cell at a time from summary mode (i.e., single number input) into detail mode (i.e., multiple line entries per input cell). The “Toggle Budget Edit” button can switch one “green” budget cell at a time from summary mode (i.e., single number input) into detail mode (i.e., multiple line entries per input cell).
Double Click Any Row With Actual Info & See Detail Transactions
For Comp Plans Complete Jan-Jun 16
Assign Desig. Of Bal.
With Double Click
For Subschedule
(F-2)
The “Toggle Budget Edit” button does not apply to any of the Budget 16-17 cells for any Compensation Plan Fund Grouping/Fund as the detail for these funds come from the “Income” and/or “Expense” tabs. Example of Projection Cell In “Detail Mode” or Multi-Line Entry Mode
Steps for Toggling From Summary To Detail Mode For A “Green” Colored Projection or Budget Cell 1. Click on a single “green” projection or budget cell 2. Click the “Toggle Proj Edit” or “Toggle Budget Edit” button, as appropriate 3. Answer “Yes” to the question “Are you sure you would like to toggle summary mode for ______
amount to detail mode?” which will change the cell color to black 4. Double click on the now black cell that has been created in “detail” mode to open a pop-up
window 5. Click “Add Row” in the submenu that is brought up 6. Enter Description & Amount 7. Add as many rows as is desired 8. Click the “save” button
Steps for Toggling Back To Summary Mode For A “Black” Colored Projection or Budget Cell 1. Click on a single “black” projection or budget cell 2. Black cell must be empty or showing a zero amount before it can be changed to a summary cell 3. Click the “Toggle Proj Edit” or “Toggle Budget Edit” button, as appropriate 4. Answer “Yes” to the question “Are you sure you would like to toggle detail mode for ______
amount to summary mode?” which will change the cell color to green 5. Click on the now green cell 6. Input the single value for this cell 7. Click the “Save Changes” button
Add or Delete Rows
In Detail Mode
Cell Colored Black When
In Detail Mode
(F-3)
In an effort to limit a department’s need to reconstruct the underlying detail for certain projected revenue rows and to minimize post-budget submission questions from your assigned DO Fiscal Reviewer, the following income rows under the Jan-Jun 17 projection column are starting out as a “black” projection cell (i.e., multiple line entries per input cell):
Only Appear In Comp Plan Funds Miscellaneous Recharges – Comp Plan Service Interfund Transfers Internal (Rev. Side) Interfund Transfers Internal (Exp. Side) Interfund Transfers External (Rev. Side) Interfund Transfers External (Exp. Side)
Appears Across All Fund Groups/Funds Miscellaneous Recharges Example of Revenue Projection Cells Automatically In Multi-Line Entry Mode
Input Detail
For Each Black Cell
(F-4)
To aid in accounting for all of the benefit costs associated with employee salaries, the projected and budgeted “Benefits” cells start out as “black” (i.e., multiple line entries per input cell) with a description put in for each active non-Plan faculty employee category (i.e., Staff Physicians, Staff, Academic Apprentice, Academic Other, and Interns & Residents) along with a $0 value. However, budgeted benefits for the Compensation Plan funds must be input under the “Expense” tab. The projected and budgeted benefit costs associated with Faculty Ladder & Faculty Temporary salaries originate from FPM. Note the “Average Benefit Rate” is displayed as the very last row at the bottom of the screen for each separate time-period represented by a column. Reviewing the rate displayed in each column assists a user to determine whether the benefits being projected or budgeted are in-line with present and future expectations or requires further change. Example of Benefit Projection Cell Automatically In Multi-Line Entry Mode & Average Benefit Rate Row
Input Missing Benefit Amts
As Appropriate
Increase Benefit Amts
If “Avg Benefit Rate”
Lower Than Expected
(F-5)
Another ongoing feature is the display of the total amount budgeted on each row of what has been input under the “Revenue” and “Expense” tabs for the Compensation Plan(s) for the budget year.
Also, for the Compensation Plan funds a double-click on any row in the budget column will bring up a read only detail of the budget information created under either the “Income” or “Expense” tabs.
Comp Plan To See All Budget
Transactions Of A Row Double-Click
Comp Plan Budget Rows
Brought In From Inc. & Exp. Tabs
(F-6)
An additional feature is the ability to select “All Missions” Revenue or Expense under the Mission selection criteria and see the combined impact of all revenue and expense rows totaled across all missions on the fund group/fund being budgeted. The “All Missions” selection allows a user to view but not edit any of the row amounts being displayed.
Amts Across All Missions Totaled For Each Row
(F-7)
The budget program has been designed based on the campus hierarchy coding for departments or units within the School of Medicine. You will be budgeting at the individual fund number level or at the rolled-up fund group level as well as by mission. IMPORTANT: All estimates provided will be utilized for the Chancellor’s Office C-BIG budgeting in the spring. The tabs for Income, Expense, and Plan Faculty are only applicable to the departments with Compensation Plan funds and Compensation Plan faculty. You are given data under the “Actual +Projection” tab for the prior fiscal year, the current year budget, and the first half of the current year from July through December. An automatic projection for all fund groups/funds for January through June has been provided for expense categories, but not for revenue. The projection is based on duplicating the first half of the year for all expense rows except the salary expenditure lines inclusive of Faculty Ladder, Faculty Temporary, Staff Physicians, Staff, Academic Other, Academic Apprentice, and Interns and Residents. Note that the projection values associated with the January through June period are being extracted from FPM for all salary lines. The Faculty Ladder and Faculty Temporary expense rows are based upon what is in FPM as of the beginning of January for the second six months of the year per account owner. For these two rows under the Compensation Plan(s) manually add to the amounts already there the amount of Z’s to be paid in the second half of the year, as well as, the compensation for any new appointments being made before June 30th. The “Act + Proj 15-16” column is the total for each row of the first six months and last six months. The expense figures projected for the 2nd six months of the current fiscal year can be over-written or modified in the case of the salary lines. The revenue projections for the 2nd six months are shown as zero and must be entered for every appropriate row. Use “Toggle Proj Edit” button to switch a “green” cell from single to multiple line entries. For Non-Comp Plan funds, the FY16-17 budget data other than Faculty Ladder and Faculty Temporary may be directly entered or a percentage increase may be applied to the current year projection. The Faculty Ladder and Faculty Temporary expense rows are based upon what is in FPM for the budget year per account owner. The actual + projection data can be downloaded to Excel for any Mission/Revenue or Expense combination. A method for projecting the whole year would be to choose the “Select Report - Grid” option for exporting data into Excel. With this information, you would input the amount expected for the entire year and subtract the July - December data to obtain the January - June data. Input the January - June result in AFB. Total information will only appear on the budget Summary Reports. Select the fund grouping and if applicable, a fund number. The major non-Compensation Plan fund groupings in the order of the budget program are:
Contracts & Grants Funds consolidated Gifts and Endowments Funds consolidated State Funds with specific fund numbers as applicable Indirect Cost Recovery with specific fund numbers as applicable Sales & Service Funds with specific fund numbers Student Fees Funds are only applicable to M.I.M.G. and the Dean’s Office. Other with specific fund numbers
The screen that appears will have data if there is any information for the past year or the current year.
Download Grid to Excel
6 Month Projection
Budget
Select Mission & Rev. or Exp.
(F-8)
Mission & Excel Feature To the far left is the selection for mission. Financial information for the School is captured for the missions of Clinical, Research, and Education. The “All Missions” Revenue or Expenses selections total together the financial data from the three missions being tracked in the School. The picture example given on page F-7 on the preceding page has Clinical, Research, Education or All selections for either revenue or expense. Missions other than All have been programmed from ledger data by classifications of the Full Accounting Unit (FAU) either from the School’s 2-digit cost center (e.g., 2X is Education) or from the campus designations of the 6-digit account (e.g. 44xxxx is Research). The groupings under Mission are for Revenue (Income) or Expense (Expenditures). The revenue or expense rows displayed after choosing mission under “Description” are produced if a department had prior year actual, current year actual, or budgeted amounts for that particular row. The complete list of revenue and expense row categories is listed under the Row Categories tab of the budget book. A user can choose from amongst different options for exporting into Excel the revenue or expense row information displayed across all columns in the Grid at either Level 3 or Level 1. The default for the “Actual + Projection” tab is Level 3 since this is the level of detail at which budgeting is done across all fund groups/funds. A user may alternatively choose to view only and export over to Excel revenue or expense data rolled up at Level 1. As has been the case over the last few years, the information may be downloaded to Excel at any time in order to aid in projecting or budgeting. Example of Level 3 Financial Data To Be Exported Into Excel Using Submenu
Example of Level 1 Financial Data To Be Exported Into Excel Using Submenu
Leave Level As Is
(Step 1)
Change Level
(Step 1)
Choose To
Export (Step 2)
Choose To
Export (Step 2)
Select Grid
(Step 3)
Select Grid
(Step 3)
(F-9)
Also there is an ability to export to Excel a report from the groupings under Mission for Revenue (Income) or Expense (Expenditures) related to the Level 3 information input under either the “Dept Proj Jan-Jun 16” or “Budget 16-17” columns. The report can be generated for any Fund Grouping/Fund desired. The report produced lists both the amounts for rows where a single number is entered as well as the detail records comprising any row with multiple line entries. Example of Exporting Level 3 Report For Projection or Budget Detail
Example of A Projection Detail Report
Data Each individual row that appears on the grid describes the revenue or expense categories for which data is available. The columns indicate the time-period of the data; actual for the past completed year, budget for the current year, actual for the first six months of the current year, projection for the last six months of the current year, a total of the current year’s actual and projection, and a column for the FY16-17 budget data to be entered. Editable columns are “Dept Proj Jan-Jun 16” and “Budget 16-17” that are shaded either green or black for non-Compensation Plan fund groupings. For Compensation Plan funds, the “Budget 16-17” column is shaded peach to reflect that this data comes from the Income & Expense tabs. A starting figure has been entered automatically for the current year projections for expenses only.
Select A Button
To See
What’s Been Input To
Date
(F-10)
The projection is based on duplicating the first half of the year except for the salary rows associated with Faculty Ladder, Faculty Temporary, Staff Physicians, Staff, Academic Other, Academic Apprentice, and Interns and Residents. The Faculty Ladder and Faculty Temporary expense rows and associated benefit costs are based on what is in FPM for the second six months of the year per account owner. Projection values associated with the January through June period are also extracted from FPM for all other salary lines. You may keep any amount automatically projected or make a manual adjustment to the figure. Revenues have not been automatically entered in order to avoid overstating income by duplicating permanent budget data or assuming other types of income will be generated at the same level as occurred in the first half of the fiscal year. As values are manually entered, the “Save Changes” and “Cancel Changes” options become activated.
Descriptions/Row Categories The descriptions or row categories are of the types of revenue (income) or expense (expenditures) at the lowest grouped levels, commonly referred to as Level 3, in the Dean’s Office reporting applications. Revenues may also be identified by source, for example, Sales & Services Revenue. Expenses are grouped by natural classifications such as Material and Supplies-Scientific and are primarily based on mapping object codes in the group for translation to the Chancellor’s C-BIG budgeting. Further breakdowns needed by the School or departments are also included, such as Telephone. A complete list of the available rows is included under the “Row Categories” tab in this book. Object code groupings may be found and downloaded to Excel from the Dean’s Office All Funds-Comp Plan (AFCPL) financial reporting application. Save or Cancel Changes Feature
By clicking the “Save Changes,” the entered or calculated amounts will be kept. You may also cancel the amount entered by clicking on “Cancel Changes.” It will only cancel what has not been saved. You may continue editing the figures manually or increasing the projected figures for the budget with other percentages.
Save or Cancel
Changes
Data Input Columns
Save or Cancel
Changes
(F-11)
Increase Budget by X % Use the “Increase by X %” feature for estimated revenue or cost increases for the budget year. A calculated amount will appear in the Budget year column that is the total projected figure increased by the percentage entered. For example, if you want to estimate a 5% increase in Sales & Services revenues over the projected total, click on this revenue row and then click on the “Increase by X %” button. Enter the percentage, and then click on “Increase.” The calculation is determined by increasing the projected column only by the percentage entered. An amount will be filled in the budget column. The “Save Changes” and “Cancel Changes” will be activated
You can apply the same percentage increase to more than one row at a time by either holding down the “control” key and selecting each row or highlighting multiple lines using the “shift” key before clicking on the “Increase by X%” button.
Add A Row Feature To add a row for revenues or expenses for your projections/budget, select mission revenue or expense and click on “+Add Row.” A menu will pop-up to select the appropriate revenue or expense row within the mission selected.
Select Row(s) (Step 1)
Click On
“Increase” (Step 4)
Input % Incr.
(Step 3)
Select Row
(Step 2)
Click On
“+Add Row” (Step 1)
Click on “Increase by X %” (Step 2)
(F-12)
Delete A Row With All Zero Values Delete a revenue or expense row with a zero value across all columns by clicking on the row to be deleted and pressing the “- Delete Row” button. None of the rows with data originally brought into the program can be deleted.
Creating Variance Notes The “Variance Notes” area of the budget program should be used to explain any large variances between a budgeted revenue or expense row linked to one of the missions and the corresponding actual and/or projected figures for a particular budget row. “Variance Notes” can also be used to describe the overall or more global revenue or expense variances or trends being experienced within a particular fund group and/or fund. You may type directly into the Variance Notes input area or use Word and then cut and paste to here. The program keeps track of the fund grouping/fund, mission, revenue or expense section under which a variance note was added. The following “Variance Notes” report is exportable from the budget program into Excel:
Click On “-Delete Row”
(Step 2)
Click “Yes” To Confirm
(Step 3)
Select Row
(Step 1)
(F-13)
The Health Sciences leadership wants each department to explain significant variances. The following set of guidelines will help focus attention on those areas that need discussion. Address all questions below that may pertain to your particular situation(s):
Income Identify the specific current services contributing most to the variance or describe any added or eliminated services. Identify the dollar amounts associated with the variance.
a. Explain material variances greater than 10% and $100K.
b. Explain any unexpected changes in sources of revenue support currently anticipated by your department or expected next budget year.
c. Explain any non-recurring activity or event having an impact on the department’s fiscal health
such as moves, faculty turnover, and productivity.
Expenditures Explain any significant variation in expenditure estimates from year to year. If your costs are increasing, is it due to an increase in revenue or other factors?
a. In describing the nature of a material expense variance on an individual line item that is greater than 10% and $100K, focus your explanation on what is operationally happened to increase these outlays as well as whether any expected cost savings have failed to materialize thus far. Identify any “start-up” or “recruitment” expense that is causing a variance on the “Other Expense” category.
b. In the event a particular fiscal situation is continuing to contribute towards a declining fund
balance or a deficit ending balance, explain what is being done to significantly bring down or eliminate the deficit(s) in the upcoming year.
Steps To Creating Variance Notes
Click on “Variance
Notes” (Step 1)
Click on
“Edit” (Step 2)
Click on “Send To Excel” Or “Close”
(Step 5)
Input Variance
Notes (Step 3)
(F-14)
Sending Variance Notes To Excel The computer program has been designed to separately track the Variance Notes created for each of the fund groups and/or funds being budgeted by a department. When a user clicks on the “Send To Excel” button, the “Variance Notes” created and saved for each fund group/fund, mission, and revenue/expense category is separately listed in the Excel spreadsheet produced.
PROJECTING THE CURRENT YEAR & DETERMINING BUDGET AMOUNTS FOR COMING YEAR Use the following guidelines to help with projecting the current year as well as the budget year amounts needed for the budget. INCOME/RECHARGES/TRANSFERS Project the expected cash amounts flowing in from operations or appropriations for applicable sources in either revenue accounts, recharged offsets of expenses (incoming to department), or transfers from another unit for the current year and budget year. Contracts & Grants Revenue: the Dean’s Office will automatically create a total revenue figure under “All C&G Revenue” corresponding to the amount of expenses that are being projected or budgeted. The C-BIG program only requires a total C&G revenue amount, so there is no need to break down revenue further into various other types of C&G revenue. Actual revenues for the prior year and the first six months of the current year (July-December) are equal to expenses. Gifts & Endowments Revenue: Project any additional amounts expected for the current year from January through June and estimates for the budget year including the permanent budget. Actual revenues for the prior year are equal to appropriations, excluding carry-forward balances. Separate rows are provided for Transfers and STIP. Revenue reflected under “Clinical/Revenue,” “Research/Revenue,” or “Education/Revenue” are limited to the following six lines: Gift Revenue, Endowment Revenue, STIP, Support From Dean’s Office (i.e., approved and continuing, but not new commitments, increases, or extensions of previously approved requests), Other Transfers In/ (Out), and Expense Transfers In/ (Out). Indirect Cost Recovery: Project any additional amounts expected for the current year from January through June and estimate for the budget year including the permanent budget. Actual revenues for the prior year are equal to appropriations, excluding carry-forward balances.
“Save” Or
“Cancel” (Step 4)
(F-15)
Sales & Service Funds: Revenues are determined from actual transactions in revenue accounts or recharge activity for funds owned by the department. Project any additional amounts expected for the current year from January through June and estimate for the budget year. For any funds not owned by the unit, revenues are based on appropriations excluding any carry-forward balances. Project or budget appropriations anticipated, accordingly. State (General) Funds: Project any additional amounts expected for the current year from January through June and estimate for the budget year including the permanent budget. Do not include open unfilled academic FTEs that will be drawn back. See the Contact List if you have any questions. Other UC Funds: Revenues for these funds are generally based on appropriations excluding any carry-forward balances. Project or budget appropriations anticipated, accordingly. Sample Methodologies Using amounts in the ledger or any other report documents such as the 5-year comparison reports available to be generated from the Dean’s Office AFCPL application, departments may project gross cash amounts or appropriations as applicable for the source through the end of the year or the coming budget year. Contract & Grant revenues will be automatically calculated based on projected expenses. Gift Revenues & Endowment Revenues are to be manually entered on the respective rows. See also Transfers and STIP. • Method 1 - Average Method
Develop an average of gross cash amount collected by dividing the total amount transferred by the number of months (or years) represented on the ledger or report. Multiply the average times 12 for a full year’s projection if using partial year data. Refer to clinical income model & methodologies from the Faculty Practice Group as appropriate.
• Method 2 - Actual + Projected Method
To the total amount recorded in the ledger or reflected on the reports, add amounts anticipated to be recorded for the remaining months. Refer to clinical income models & methodologies from Faculty Practice Group as appropriate.
• Method 3 - Budget
To the total amount projected for the current year, you may increase by a percentage using the feature in the budget program. Select the row first, then click on “Increase by X%”, enter a value and press “Increase” to complete the estimate. A new figure will appear in the budget column.
Net Patient Care Revenue Comp Plan Funds: This category is for collections from patient billings for non-managed care & managed care professional services handled through or outside the CareConnect system. Include capitation, package pool income and recharges from patient billings. Clinical trials, pharmaceutical revenue, student health income are included in this category. Refer to clinical income models & methodologies from Faculty Practice Group. The model used should derive total amount based on the year to date plus a 6-month projection. Under the “Writeups” tab, attach the document developed with the Faculty Practice Group on the projected gross charges and cash collection figures for the remaining 6 months of the current year. Include all footnotes or other notations explaining the assumptions going into the development of the figures. No additional documentation is required other than what you have used to arrive at your budget.
• Method 1 - Average Method
Develop separate averages for gross charges and cash collected. To obtain the averages, separately divide total gross charges and cash collected by the number of months over which the data is being reported. For example, if December year-to-date (July – December) information is being used, then separately divide total gross charges and cash collections for this period by six. The resulting averages are multiplied by 12 to obtain the annualized projection amounts. Round these figures to the nearest $1,000.
(F-16)
• Method 2 - Actual + Projected Method Year-to-date total gross charges and cash collected are added to projected services to be performed times the billing rates and cash value per service.
• Method 3 - Ratio Method Develop a separate ratio of prior year-to-date gross charges (e.g., July – January) to total prior year gross charges (i.e., July – June). You will later apply this ratio to current year-to-date gross charges. Using the same method, develop a separate ratio of prior year-to-date cash collections to total prior year cash collections. You will later apply this ratio to current year-to-date cash collections. Refer to the previous fiscal year's June 30 source documents. The next step is to separately add the 2015-16 total gross charges and cash through the same period used to develop the ratios for the prior year (e.g., July-January). Separately take the current year’s total gross charges and cash year-to-date (e.g., July-January), and divide each total by the percentages obtained from the previous fiscal year. For example, the gross cash received by January of the previous year represented 45% of total gross cash received for the year. Assume the total gross cash received during the current year through January is $700,000. Divide that by 45%. The result is $1,555,555 which is then rounded to $1,556,000.
• Method 4 - Units of Service Method
This projection takes into account changes in service units based upon the performance of a Department’s faculty and modifications in the reimbursement rates of payers. If the department is utilizing a units-of-service approach developed in conjunction with the Faculty Practice Group, then under the “Writeups” tab, attach the document developed along with all footnotes or other notations explaining the assumptions going into the development of the figures.
OTHER COMP PLAN REVENUE (INCLUDES: PROFESSIONAL WITNESS FEES/LEGAL CONSULTING, SUPPORT FROM OUTSIDE UNITS, OTHER REVENUE, ILP ASSESSMENTS)
• Method 1 - Average Method
Develop an average of gross cash amount collected by dividing the total amount transferred by the number of months (or years) represented on the ledger or report. Multiply the average times 12 for a full year's projection if using partial year data.
• Method 2 - Actual + Projected Method To the total amount recorded in the ledger, add amounts anticipated to be recorded for the remaining months.
FPG RECHARGES AND HEALTH SYSTEM DIRECTORSHIP RECHARGES & TRANSFERS
FPG recharges (i.e., Managed Clinics & Managed Admin Services) and Health System Directorship Recharges & Transfers are for administrative and patient care services. The approved funding provided covers faculty salary reimbursement and non-faculty programmatic support. • Method 1 – Actual + Projected Method
To the total amount recharged/transferred to date, add the amounts anticipated to be recharged/transferred by faculty and/ or staff members performing services for the number of months remaining as negotiated with the respective organization.
• Method 2 – Budget + Projected Method
Utilizing the original budgeted amount, add or subtract amounts as needed for changes in faculty, staff, or program/service being recharged/transferred.
(F-17)
SUPPORT FROM DEAN’S OFFICE Department users are assisted in projecting and budgeting previously approved DO Support commitments during the budget request and submission process with the availability of two specific features incorporated into the AFB. These features are represented by (1) a listing of approved DO Support request items in the appropriate Projection cell, and (2) the creation of an overall report named “Dean’s Office Support Projection Detail”. The DO Support Request items that were approved in the previous Budget process have been prepopulated in the AFB, with the projection amount defaulted to zero. Each department should update the value of the reflected requests. In addition to these prepopulated records, the department users can add DO Support items approved outside of the previous budget review and approval process for the current fiscal year. Using the listing in the Projection cell and the accompanying Overall report, the department users can reconcile DO Support transferred in July-December, as well as, account for the projection of the DO Support anticipated for the period of January – June.
MISCELLANEOUS RECHARGES/TRANSFERS – Select appropriate mission. Using amounts in the ledger or any other report documents such as the 5-year comparison reports available to be generated from the Dean’s Office AFCPL application, departments may project gross cash amounts to be received through the end of the year or the budget year.
• Method 1 - Average Method Develop an average of recharges or transfers generated by dividing the total amount transferred by the number of months (or years) represented on the ledger or report. Multiply the average times 12 for a full year's projection if using partial year data.
• Method 2 - Actual + Projected Method To the total amount recharged to date, add the amounts anticipated to be recharged for performing the services for the number of months remaining as negotiated with the affected department or unit.
INTER-FUND RECHARGES/TRANSFERS Department may use the amount budgeted unless an updated figure(s) can be confirmed as coming from another department(s). All transfer amounts must agree between departments. Estimates of transfers for Salary Savings via the Dean’s Office should be reflected here and not on the Support from Dean’s Office. INTEREST INCOME (STIP) – Mission is defaulted to Research for Private Grants or Gifts Using amounts in the ledger or any other report documents such as the 5-year comparison reports available to be generated from the Dean’s Office AFCPL application, departments may project interest income as appropriate for the fund or fund group. • Method 1 - Average Method
Develop an average of interest transferred to date by dividing the amount transferred by the number of months represented. Multiply the average times 12 months to project through the end of the year, if using partial year data.
• Method 2 - Percentage Method
Apply current STIP earnings percentage (approximately 1.5%) times the Prior Year’s ending balance, the current fund balance, or an average fund balance.
COMP PLAN DEAN’S TAX – Expense Side (negative revenue) Project the total of this expenditure by taking the original budgeted amount for 2015-2016 and adding or subtracting the true-up adjustment for the Prior Year. EXPENSES All projection or budget estimates are of expenses recorded in the University's ledger by the end of the current year or budget year by mission, e.g. Research or Education. Reports from the Dean’s Office AFCPL application may help in determining natural class categories and spending patterns by mission. Campus object codes contained in the natural class categories may be found in the “definitions” feature of the AFCPL. Object code grouping classifications may be found under the “Row Categories” tab of this workbook. Project “Z incentives” for Plan faculty as well as salary expenses for academic titles (not Plan Faculty), staff physicians (if appropriate) and other title groups as appropriate. Project or budget expenses for other non-payroll types of expenses.
(F-18)
ACADEMIC SALARIES The Chancellor’s Office divided Academic Salaries into 4 groups based on object codes: Faculty Ladder, Faculty Temporary, Academic Apprentice, and Academic Other. In addition, the School has carved out Interns and Residents. The Faculty Ladder and Faculty Temporary expense rows are based upon what is in FPM per account owner. Ledgers, Distribution of Payroll Expense Reports (PPP530), or any other meaningful reports may be used to project or budget expenditures for those academic salary components that are not automatically populated from FPM. The projection figures for Faculty Ladder, Faculty Temporary, Academic Apprentice, Academic Other, and Interns and Residents are automatically populated from FPM based upon the account owner attributable to their pay distribution lines for the second six months of FY15-16. The salary figures showing in the projection column can be checked, if desired, by taking advantage of a report in FPM. The “Title Group” field is part of the “Monthly Salary” report for Staff & Other Academics under “Overall Reports” in FPM. This helps to identify the salary costs of Academic Apprentice, Academic Other, and Interns & Residents needed for the second six-month projection. Creating a pivot table in Excel would permit this data to be sorted by Fund Group/Fund and then Title Group. • Method 1 - Average Method
Develop an average of expenses to date by dividing the total amount (on the ledger or department report) by the number of months represented. Multiply the average times 12 for a full year's projection if using partial year data. Consider any adjustments still to be made to the ledger and adjust the average accordingly.
Do not use PPP530 (Payroll Expense Distribution) report totals only, because that report does not include journal entries occurring outside of the payroll system.
With respect to the projection for any non-rate based pay (e.g., one-time payments), be sure the amount included is based upon the period when the payments are expected to be made, not earned.
• Method 2 - Actual + Projected Method
Total expenses to date are added to the result of the current month’s expenses times the number of remaining months. Consider any adjustments still to be made to the ledger and adjust the amount calculated. With respect to the projection for any non-rate based pay (e.g., one-time payments), be sure the amount included is based upon the period when the payments are expected to be made, not earned.
• Method 3 - Budget To the total amount projected for the current year, you may increase by a percentage by using the feature in the budget program. Select the row first, then click on “Increase by X%,” enter a value and press “Increase” to complete the estimate. A new figure will appear in the budget column.
STAFF SALARIES (Includes Staff & Staff Physicians – if applicable) Salaries of Staff & Staff Physicians can be projected using ledgers and Distribution of Payroll Expense Reports (PPP530). Refer to object code grouping of natural class expenses. The projection figures for Staff Physicians, Staff, Academic Apprentice, Academic Other, and Interns & Residents are automatically being populated from FPM based upon the account owner attributable to their pay distribution lines for the second six months of FY15-16. The salary figures showing in the projection column can be checked, if desired, by taking advantage of a report in FPM. The “Title Group” field is part of the “Monthly Salary” report for Staff & Other Academics under “Overall Reports” in FPM. This helps to identify the salary costs of non-Plan faculty employee categories (i.e., Staff Physicians, Staff, Academic Apprentice, Academic Other and Interns & Residents) needed for the second six-month projection. Creating a pivot table in Excel would permit this data to be sorted by Fund Group/Fund and then Title Group.
(F-19)
Discussion and methods 1-3 in the section for Academic Salaries may be used. Include retroactive pay increases determined by collective bargaining agreements. Postgraduate personnel paid through the Graduate Division (i.e., not through the payroll system) should be projected under Financial Aid.
BENEFITS All employer contribution costs regardless of salary type (e.g. academic or staff) are included here. In addition to methods 1-3 described in the section for Academic Salaries, you may want to use a percentage method. • Method 4 - Percentage Method
Divide total benefit costs by the total salary costs for a full year’s worth of data to obtain a percentage (e.g. 30%). Benefit costs are generally higher at the beginning of the calendar year (January –June) due to FICA costs. Multiply the percentage times the projected or budgeted total salary costs. Percentages may be easily obtained from actual data given using the Excel feature described above. The employer’s contribution towards UCRP is frozen at the FY14-15 rate, so there’s no need to budget for an increase in the UCRP contribution, but do budget a 0.5% rise in the annual cost of health premiums.
Note: The projected benefit costs for Faculty Ladder and Faculty Temporary are now included on the benefit row based upon the “Last Month’s Actual Benefit Rate (Excluding Vacation) for December reflected in FPM and applied to the salary and fund sources in affect for the second six months of the year per account owner. Therefore, the only calculation that remains to be done is to determine a projected benefit figure for Z’s and the benefit costs of the other academic and staff employees.
NON- PAYROLL EXPENSES Using ledgers or other reports such as the 5-year comparison report available to be generated from the Dean’s Office AFCPL application, departments may project non-payroll expenses such as supplies, equipment, and telephone for the respective category rows. A starting figure that is based on doubling the first half of the year has been automatically calculated. You may keep the amount or change the amount of the projection. Budget estimates may include a percentage increase by using the “Increase by X%” feature described in the Academic Salaries section. Object codes included in the categories may be found in the Dean’s Office AFCPL application. Rows may be added for categories that currently have no information by using the “Add a Row” feature. Postgraduate Personnel paid through the Graduate Division and charged to “78XXXX” accounts are to be included under Financial Aid. As a convenience, you may use “Other Expense” for budgeting start-up and recruitment types of expenses. A complete listing of the categories is included in the workbook.
COMP PLAN SPECIFIC EXPENSES MALPRACTICE INSURANCE Use the 2015-16 malpractice allocation figures provided. Enter projection on Malpractice Insurance line.
PSS EXPENSES Use the most recent figures available from Physician Support Services, including prior year adjustments (i.e., true-up). Enter the projection on the Professional Services Other line. Refer to contact list, if you have any questions.
TRANSFERS [Transfers In/(Out)] Departments may project incoming/outgoing amounts to/ from outside the School (e.g., from the President’s Office for Gifts or Endowments, etc.) by using any of the following methods • Method 1 - Actual Method
Departments may project amount actually transferred to date if there are no further transactions to be made.
• Method 2 - Actual + Projected Method To the total amount transferred to date add or subtract amounts anticipated to be transferred.
(F-20)
• Method 3 - Budget Departments may project using the original budget for the CY if the commitment remains unchanged. To the total amount projected for the CY, you may increase by a % by using the feature in the budget program. Select the row first, then click on “Increase by X%,” enter a value, and press “Increase” to complete the estimate. A new figure will appear in the budget column.
CARRY FORWARD PRIOR YEAR BALANCE Dean’s Office will carry forward the actual July 1 beginning balance per ledger as appropriate. There is no carry-forward for Contracts & Grants fund group since revenues are reported equal to expenses. ENDING BALANCE - END OF YEAR This is a summation of all projections for the year. This balance will be the Carry Forward Prior Year Balance for the Budget Year Column. AVERAGE BENEFIT RATE This feature provides a calculation of the “average benefit rate” for each separate time-period represented by a column under the “Actual + Projected” tab. The rate displayed in each column should be viewed as guide to determining whether the benefits being projected or budgeted are in-line with present and future expectations or requires further change.
COMP PLAN FUNDS DESIGNATION OF BALANCE 2015-16 The Revised Balance for 2015-16 is carried forward to this screen. The balance initially defaults to “Unspecified.” This balance needs to be broken down between the amounts owned or controlled by the Chair, Chief (or Program), and Individual. To do this, a user needs to bring up a “Designation of Balance Detail” pop-up subschedule.
To allocate the projected 2015-16 fund balance between the categories of Chair, Chief (or Program), and Individual click on “Add Row” under each heading and input a description and amount. Any row added under a category can be removed by clicking on the row to be deleted and subsequently clicking on “Delete Row.”
Double Click For
Designation Of Balance
(F-21)
It is important to note that as amounts are keyed in under each of the three categories that the remaining dollar value shown in the “Unspecified Balance” box is reduced by the sum total already assigned. Rows under any one of the three categories should continue to be added until the value in the “Unspecified Balance” box equals zero. Concerning the descriptions used for rows added under the “Individual” category, you may be asked to provide a breakdown of amounts using Plan member names.
Keep Adding Rows or Amounts Until Unspecified
Balance Equals
$0
(G-1)
BUDGET PROGRAM REPORTS
The budget program contains a selection of developed reports that summarize the data input by the department or unit. Each selection goes immediately to Excel for viewing and/or printing. Optionally, you may select to go immediately to the printer. In general, reports are created from the options selected at the top of the screen. If your department has multiple divisions, then click on the “Eraser” button on the upper left part of the screen before running the report to obtain information across all divisions.
OVERALL REPORTS Summary Report (Level 1 or 3) – {3-Yr Actual, Projection & Budget} Able to select one, all, or a combination of missions (e.g., Education & Research) rolled up to Level 1 or broken down into more detail revenue and expense lines by natural class reflected at Level 3. Report provides separate columns for the budget year, actual + projection for the current year, budget for the current year, and actual for the prior year. An option has been added to create a column for dollar variances in addition to percentage variances. Summary Report (Level 1 or 3) – {3-Yr With Fund Detail} Rolled up summary by Fund Group with separate sections in the schedule for the current year surplus/(deficit) and ending balance displayed for each individual fund in the group across the annual periods being reported. The report useful for all Fund Groups except Contracts & Grants and Gifts & Endowments where projecting and budgeting is not done down to the level of individual funds. At a glance, a user can see if the FY15-16 projection and FY16-17 budget amounts pertaining to the surplus/(deficit) and ending values for each fund in the group appear reasonable in relation to the prior year actual and the FY15-16 budget. Selection options related to mission, reporting level, and inclusion or exclusion of variance percentages or dollars are identical to the Summary Report (3-Yr Actual, Projection & Budget). Summary Report (Level 1 or 3) – {4-Yr} Rolled up summary of all Fund Groups or By Fund Group. The report is a useful tool to see how close the projection figures for the prior fiscal year came to last fiscal years’ actual numbers as well as comparing the current year projection against the prior year actual and the budget year figures in relation to current year projection values. Selection options related to mission, reporting level, and inclusion or exclusion of variance percentages or dollars are identical to the Summary Report (3-Yr Actual, Projection & Budget).
Click on Report
Selection, then select Mission &
Level
(G-2)
Summary by Mission Report (Level 1 or 3) – {Current Year Projection & Future Year Budget} Able to generate for each fund group/fund a report comparing current year projections attributable to the clinical, education, and research missions (separate columns) against the budgeted amounts for these same missions. Actual + Projected Report (Level 3) – {Current Year 6-Month Actual & 6-Month Projection} This report details actual data by mission and natural class through December of the current year, the unit’s projections for the 2nd half of the current year, and the resulting total. User selects the mission and report is produced at level 3. By Fund Group Summary & Other By Fund Group Reports (Level 1) The “summary” report combines together financial data. Missions may be individually selected or “all missions.” Another option is the “all missions separate” which will then create separate spreadsheet reports for each mission. Comparative data includes actual prior year with all fund groups/funds combined, current year budget and updated projections with all funds combined, and budget year data for each fund group. A variance percentage between budget year and current projected year is provided. The other “By Fund Group” reports are for each fund group (columns) for either the prior year actual, current year projection, or budget year. Each or all mission(s) may be individually selected. Another option is “all missions separate” which will then create separate spreadsheet reports for each mission. Sample report not provided in workbook.
A “Roll-Up Department” checkbox is available for a Department/Institute/ORU where the School has the practice of financially combining together its multiple operating units. This checkbox only becomes active when one of the Fund Group reports is selected. In taking advantage of this option, an affected set of operating units can determine their overall financial condition as a combined whole. The units impacted are Ophthalmology/JSEI, Pathology/Immunogenetics (TTL), Pharmacology/Crump, and Psychiatry/Semel.
By Fund Group Summary Expanded This expanded report includes a separate line at the bottom of the schedule that depicts under each column of the spreadsheet the overall Benefit Rate for all employee groups. This added report row enables a user to evaluate the reasonableness of the benefit costs reported under each major fund group being budgeted as well as the total benefit expenses being projected. The report creation options for this spreadsheet are identical to the “By Fund Group Summary” schedule.
(G-3)
Dean’s Office Support Detail Report This report enables a user to print out all Dean’s Office support items noted in the budget entered through the Dean’s Office support tab. Each item is listed along with the specific fund source identified and any explanatory remarks as well as whether the request is new, increase, extension, or continuing and the request status. If there is a desire to generate a print-out of all Dean’s support items captured in the budget rather than a particular fund group/fund, then click on the “Eraser” button in the upper right part of screen in order to clear out the “Fund Grouping” and “Fund” fields displayed and hit the “Run Report” button. If your department has multiple divisions, then click on the “Eraser” button on the upper left part of the screen before running the report to obtain information across all divisions. Only those items with “Request Status” approved or prior approved will appear as revenue on the other budget report(s) impacted by the Dean’s Office funding source(s) selected. Dean’s Office Support 5 Year Detail Report This report displays individual Dean’s s Office support items for the budget year plus 4 future years. If the timing of the release of funds from the Dean’s Office (DO) for a prior approved support item is needed earlier or in a later fiscal year than budgeted, then please inform the DO of the needed change. Any change in timing would be reflected in the AFB as part of the next annual budget cycle, if not handled prior to the finalization of the budget. Dean’s Office Support With No Budgeted Expense This report has been created to aid in determining which approved support items require the corresponding expense to be budgeted. As long as the Budget is unlocked, a Department may embed or directly budget the corresponding expenditures in AFB tied to the revenue of a specific DO support record. If the costs for a support item have been embedded within the budget, find the record under the DO Support tab and first click on the radio button “Yes (Embedded)” and then click on the “Update” button. Once the Budget is locked, a Department should notify the Dean’s Office whether the expense for the support item(s) showing on the report have been embedded in the budget or whether the expenditures need to be added and what they are. If no instructions are received, then an expense amount will be created under “Other Expense” in the amount of the support.
Criteria selections for Dean’s Office
and Health System Support
Reports
(G-4)
Dean’s Office Support Projection Detail This report has been created to permit easy identification of approved FY15-16 Dean’s Office support items across all fund groups/funds for which funding may be requested during the period of January 1 through June 30, 2016. This report reflects the description of each approved DO support item for FY15-16, along with its total funding approved for the current fiscal year. Additionally, this report shows the total DO support requested by fund group/fund from July 1 through December 31 that may be allocated, if desired, to each of the displayed support records as well as a zero dollar value displayed for the second half FY15-16. Fully utilizing all of the features of this report enables a user to see how much total DO support is needed in FY15-16 for each item being funded. Dean’s Office Support Linking Plan Faculty Salary Expense to Revenue (New for FY16-17) This report compares all approved DO revenue support records created in AFB to cover Plan faculty salaries to the corresponding Plan faculty funding lines created in FPM in order to allow a user to determine the over or under usage of the monies being made available by the Dean’s Office. The report is able to make the necessary comparison due to the assignment of an FP ID# to the related support revenue in AFB and the corresponding Plan faculty funding lines in FPM. Health System Support Detail Report – {Split between the Categories of Plan Faculty & Other} Directorships and support items to be funded by the Health System are generated from items entered under the “HS Support” tab. Only Compensation Plan Funds are affected. Each item is listed along with the specific fund source identified and any explanatory remarks as well as whether the request is new or continuing and the request status. The report is similar to the Dean’s Office Support Detail and a few columns have been added for identification. If your department has multiple divisions, then click on the “Eraser” button on the upper left part of the screen before running the report to obtain information across all divisions. The input of funding in AFB for any new, extension, or increase request approved by the Health System through a separate submittal and review process has been delegated to the Dean’s Office (DO). Only those items with “Request Status” prior approved or approved will appear as revenue on the other budget report(s). Health System Support Detail by HS Type – {Split between Directorships & HS Transfers} This report provides Health System funding requests into the two separately reported support lines on the financial reports (Directorships and Health System Transfers) for Compensation Plan. The totals on this report for Directorships and Health System Transfers tie directly to what is reflected on the level 3 financial reports. Sample report not in workbook. Health System Support with no Budgeted Expense This report has been created to aid in determining which approved support items require the corresponding expense to be budgeted. As long as the Budget is unlocked, a Department may embed or directly budget the corresponding expenditures in AFB tied to the revenue of a specific HS support record. If the costs for a support item have been embedded within the budget, find the record under the HS Support tab and first click on the radio button “Yes (Embedded)” and then click on the “Update” button. Once the Budget is locked, a Department should notify the Dean’s Office whether the expense for the HS support item(s) showing on the report have been embedded in the budget or whether the expenditures need to be added and what they are. If no instructions are received, then an expense amount will be created under “Other Expense” in the amount of the support. Health System Support Linking Plan Faculty Salary Expense to Revenue (New for FY16-17) This report compares all approved HS revenue support records created in AFB to cover Plan faculty salaries to the corresponding Plan faculty funding lines created in FPM in order to allow a user to determine the over or under use of the monies being made available by the Health System. The report is able to make the necessary comparison due to the assignment of an HS Rec# to the related support revenue in AFB and the corresponding Plan funding lines in FPM.
(G-5)
COMP PLAN REPORTS Revenue & Transfer Report – Each budget item entered by the department is listed on this report in the respective categories and applicable mission(s) listed in the report title. For your convenience, all missions may be selected to see each transaction entered. Budget Detail Expense Report - Each item entered by the department is listed on this report in the respective natural class categories and applicable mission(s) listed in the report title. For convenience, all missions may be selected to see each transaction entered. Faculty Practice Group (FPG) Recharges Report. Mission is Clinical. Faculty who will be providing services to the Faculty Practice Group are listed here from information input from selecting the appropriate source code in the FPM Program. A benefit calculation at the individual’s rate is provided. Sample report is not included in the workbook. Dean’s Tax Calculation Detail Report The sum total of income and other funds marked with a “Y” or yes for a Dean’s Tax assessment will be listed on the top part of the report. The allocation percentage is the same as it was for the fund last year. Those individual items marked as “N” or no for Dean’s Tax will be listed in the middle of the report along with explanatory remarks entered. At the bottom of the report is the combined total of the calculated Dean’s Tax for the budget year plus the Dean’s Tax true-up obligation anticipated once the current fiscal year is closed. If you have any questions about an exemption approval or the allocation percentage, contact the Dean’s Office (see contact list). Sample report not included in workbook.
Dean’s Tax Exemption Detail Report This report has been created to permit easy identification of those revenue items granted an exemption from the Dean’s tax, pending an approval, and/or where exemption requests have been denied by the School. Sample report not included in workbook. Professional Fees-Academic Enrichment Detail Report This report itemizes the faculty charged to Professional Fees-Academic Enrichment source code CPL_02 by category selected in the FPM. Categories include “Pending Contracts & Grants,” “Start-up,” “Retention,” “Individual Reserves,” and “Divisional Support.” Designation of Balances Comparison Report This report compares the individual balances in a department’s compensation plan fund between the Current Year projections (2015-16) and the Prior Year projections (2014-15) from previous budget reporting from the departments. The Current Year projections are entered on the “Actual + Projection/Designation of Balances” tab in the budget program. PLAN FACULTY REPORTS Summary of Plan Faculty Salary Expenses and Benefits by Source Report The report summarizes by funding source the estimated salaries and benefits of Plan members by the FPM “appointment department.” All information for this schedule is calculated for you, including the total number of faculty. Prior to producing this report, review the benefit rates in FPM or as copied into the budget program under the Plan Faculty tab. Plan Faculty Salary Expenses by Source & Row Category Report The report summarizes by funding source the estimated salaries and benefits of Plan members by row categories of Faculty Ladder and Faculty Temporary. The compensation information depicted on this report for the Plan members represented is dependent on which funding sources were used in setting up the budgeted faculty pay lines in FPM. Salary Savings Report (formerly NON-19900 FOR ROSTER FACULTY) This schedule is a listing of the roster-funded faculty with sources other than General State Funds (19900) supporting the base salaries (Scale 0, 11-month). The report will be generated based on the plan faculty data from FPM. Faculty with Regular faculty title codes and pre-determined source codes for the “Base X” field are included. As of the 2009-10 budget year, employee benefits are no longer being calculated. A revenue amount will be created under the Inter-fund Transfers External Revenue row in the budget for both Clinical and Basic Science Departments. For NPI roster-funded faculty without Regular faculty title codes, use of the “NPI FTE” check box will trigger the creation of the amounts.
(G-6)
Annual Negotiated Salaries Report The report details each individual Plan faculty member and summarizes the individual’s salary components and funding sources by FPM “appointment” department. Z as a Percentage of Total Salary on Professional Fees Report Any Plan faculty member for whom the check box “On Z Report” is used will be reflected in this report. Sample report not included in workbook. Faculty FAU Report (with COLA/MA Contingency, as applicable) The report lists all faculty and every account, cost center, fund and/or fund source code along with other identifying data of the salary component parts and related benefits. Also incorporated, as applicable, is the financial impact on each Plan member’s salary and benefit costs of an anticipated Scale increase (Base X + X prime) for Cost of Living (COLA) and/or Market Adjustment (MA) expected to be approved by the University. Calculations are done on the cost impact of “Y” firm faculty who will receive an increase in salary up to the full amount of the Scale increase and incur additional benefit expense; “X + Y” firm faculty who do not have sufficient “Y” to cover the increase in the “X” Scale and must come up with the additional compensation needed as well as cover the increase in benefit costs; and the incremental increase in benefit cost for all “X + Y” faculty resulting from shifting compensation from “Y” to the “X” compensation components. Pivot tables may be created from the data for use in analysis. Faculty COLA/MA Contingency Summary The report summarizes by FPM “appointment department” the financial impact on each Plan member affected by an anticipated Scale increase (Base X + X prime) for Cost of Living (COLA) and/or Market Adjustment (MA) expected to be approved by the University. Faculty Ladder & Temp Manual Entries Report The report lists each manual non-FPM generated budget entry made directly to the Faculty Ladder and/or Faculty Temporary expense rows under the Med Comp or Basic Science Compensation Plans. Academic Enrichment Election This report is used by departments with an established Academic Enrichment Account to file its annual elections of its faculty Plan members for the following fiscal year. OTHER APU Change Report The report produced contains a quick summary sheet with totals by fund group and faculty row (ladder or temporary) needed including corresponding benefits to advance one scale. The detail report is built on the Faculty FAU report with additional columns to show the calculations for the advancement in scale. The incremental amount is indicated by a component labeled “Add X 3” for report purposes only. An underlying assumption for the calculations is that funding would first come from an individual’s Y. No state funds are eligible. Selection of the funding to use should adhere to the following order: Compensation plan, Contracts & Grants, Gifts & Endowments, ICR, Sales & Services, and Student Fees. SAMPLES Selected sample reports follow.
DEPARTMENT OF _____________________SUMMARY REPORT LEVEL 1FISCAL YEAR 2016-17 11/24/20XX
12:14:30 PMFund Group: Compensation PlanFund: 62XXX - Med Comp Plan
Proj. FY16 Bud. FY17Actual Budget Projected vs. Act. FY15 Budget vs. Proj. FY16
FY 14-15 FY 15-16 FY 15-16 % Fav/(Unfav) FY 16-17 % Fav/(Unfav)
Clinical OperationsRevenue Net Patient Care & MAP Facility Revenue 0 0 0 % 0 %Other Comp. Plan Revenue 0 0 0 % 0 %Health System Recharges/Transfers 0 0 0 % 0 %Support from Dean's Office 0 0 0 % 0 %Misc. & Interfund Recharges/Transfers 0 0 0 % 0 %Interest STIP 0 0 0 % 0 %Dean's Tax 0 0 0 % 0 %Total Revenue 0 0 0 % 0 %
Expense Faculty Salaries 0 0 0 % 0 %Staff Physician Salaries 0 0 0 % 0 %Staff & Non-Faculty Salaries 0 0 0 % 0 %Benefits 0 0 0 % 0 %Professional & Purchased Services 0 0 0 % 0 %Material and Supplies - Scientific 0 0 0 % 0 %Material and Supplies - General 0 0 0 % 0 %Equipment/Depreciation 0 0 0 % 0 %Malpractice Insurance 0 0 0 % 0 %Communications 0 0 0 % 0 %Other Expense 0 0 0 % 0 %Total Expense 0 0 0 % 0 %
Other Transfers In/(Out) 0 0 0 % 0 %
Current Year Surplus / (Deficit) Clinical Oper. 0 0 0 % 0 %
Contributions (to)/from Educ & Research 0 0 0 % 0 %
Prior Year Carry Forward 0 0 0 % 0 %
Ending Balance 0 0 0 % 0 %
(G-7)
DEPARTMENT OF _____________________SUMMARY REPORT LEVEL 1FISCAL YEAR 2016-17 11/24/20XX
12:15:38 PMFund Group: Compensation PlanFund: 62XXX - Med Comp Plan
Proj. FY16 Proj. FY16 Bud. FY17 Bud. FY17Actual Budget Projected vs. Act. FY15 vs. Act. FY15 Budget vs. Proj. FY16 vs. Proj. FY16
FY 14-15 FY 15-16 FY 15-16 $ Fav/(Unfav) % Fav/(Unfav) FY 16-17 $ Fav/(Unfav) % Fav/(Unfav)
Clinical OperationsRevenue Net Patient Care & MAP Facility Revenue 0 0 0 0 % 0 0 %Other Comp. Plan Revenue 0 0 0 0 % 0 0 %Health System Recharges/Transfers 0 0 0 0 % 0 0 %Support from Dean's Office 0 0 0 0 % 0 0 %Misc. & Interfund Recharges/Transfers 0 0 0 0 % 0 0 %Interest STIP 0 0 0 0 % 0 0 %Dean's Tax 0 0 0 0 % 0 0 %Total Revenue 0 0 0 0 % 0 0 %
Expense Faculty Salaries 0 0 0 0 % 0 0 %Staff Physician Salaries 0 0 0 0 % 0 0 %Staff & Non-Faculty Salaries 0 0 0 0 % 0 0 %Benefits 0 0 0 0 % 0 0 %Professional & Purchased Services 0 0 0 0 % 0 0 %Material and Supplies - Scientific 0 0 0 0 % 0 0 %Material and Supplies - General 0 0 0 0 % 0 0 %Equipment/Depreciation 0 0 0 0 % 0 0 %Malpractice Insurance 0 0 0 0 % 0 0 %Communications 0 0 0 0 % 0 0 %Other Expense 0 0 0 0 % 0 0 %Total Expense 0 0 0 0 % 0 0 %
Other Transfers In/(Out) 0 0 0 0 % 0 0 %
Current Year Surplus / (Deficit) Clinical Oper. 0 0 0 0 % 0 0 %
Contributions (to)/from Educ & Research 0 0 0 0 % 0 0 %
Prior Year Carry Forward 0 0 0 0 % 0 0 %
Ending Balance 0 0 0 0 % 0 0 %
(G-8)
DEPARTMENT OF _____________________SUMMARY REPORT LEVEL 1 - ALL MISSIONSFISCAL YEAR 2016-17 11/24/20XX
12:20:28 PMFund Group: Compensation Plan
Proj. FY16 Bud. FY17Actual Budget Projected vs. Act. FY15 Budget vs. Proj. FY16
FY 14-15 FY 15-16 FY 15-16 % Fav/(Unfav) FY 16-17 % Fav/(Unfav)
Revenue Net Patient Care & MAP Facility Revenue 0 0 0 % 0 %Other Comp. Plan Revenue 0 0 0 % 0 %Health System Recharges/Transfers 0 0 0 % 0 %Support from Dean's Office 0 0 0 % 0 %Misc. & Interfund Recharges/Transfers 0 0 0 % 0 %Interest STIP 0 0 0 % 0 %Dean's Tax 0 0 0 % 0 %Total Revenue 0 0 0 % 0 %
Expense Faculty Salaries 0 0 0 % 0 %Staff Physician Salaries 0 0 0 % 0 %Staff & Non-Faculty Salaries 0 0 0 % 0 %Interns and Residents Salaries 0 0 0 % 0 %Benefits 0 0 0 % 0 %Professional & Purchased Services 0 0 0 % 0 %Material and Supplies - Scientific 0 0 0 % 0 %Material and Supplies - General 0 0 0 % 0 %Equipment/Depreciation 0 0 0 % 0 %Malpractice Insurance 0 0 0 % 0 %Communications 0 0 0 % 0 %Other Expense 0 0 0 % 0 %Total Expense 0 0 0 % 0 %
Other Transfers In/(Out) 0 0 0 % 0 %
Current Year Surplus / (Deficit) 0 0 0 % 0 %
Prior Year Carry Forward 0 0 0 % 0 %
Ending Balance 0 0 0 % 0 %
Current Year Surplus/(Deficit) by Fund62XX1 - Department Cash Collections 0 0 0 % 0 %62XX2 - Department-Basic Science Plan 0 0 0 % 0 %
0 0 0 % 0 %
Ending Balance by Fund62XX1 - Department Cash Collections 0 0 0 % 0 %62XX2 - Department-Basic Science Plan 0 0 0 % 0 %
0 0 0 % 0 %
(G-9)
DEPARTMENT OF _________________4 YEAR SUMMARY REPORT LEVEL 1 - ALL MISSIONSFISCAL YEAR 2016-17 11/24/20XX
1:39:51 PMFund Group: __________________
Act. FY15 Proj. FY16 Bud. FY17Actual Budget Projected Actual vs. Proj. FY15 Budget Projected vs. Act. FY15 Budget vs. Proj. FY16
FY 13-14 FY 14-15 FY 14-15 FY 14-15 % Fav/(Unfav) FY 15-16 FY 15-16 % Fav/(Unfav) FY 16-17 % Fav/(Unfav)
Revenue Net Patient Care & MAP Facility Revenue 0 0 0 0 % 0 0 % 0 %Other Comp. Plan Revenue 0 0 0 0 % 0 0 % 0 %Health System Recharges/Transfers 0 0 0 0 % 0 0 % 0 %Support from Dean's Office 0 0 0 0 % 0 0 % 0 %Misc. & Interfund Recharges/Transfers 0 0 0 0 % 0 0 % 0 %Interest STIP 0 0 0 0 % 0 0 % 0 %Dean's Tax 0 0 0 0 % 0 0 % 0 %Total Revenue 0 0 0 0 % 0 0 % 0 %
Expense Faculty Salaries 0 0 0 0 % 0 0 % 0 %Staff Physician Salaries 0 0 0 0 % 0 0 % 0 %Staff & Non-Faculty Salaries 0 0 0 0 % 0 0 % 0 %Interns and Residents Salaries 0 0 0 0 % 0 0 % 0 %Benefits 0 0 0 0 % 0 0 % 0 %Professional & Purchased Services 0 0 0 0 % 0 0 % 0 %Material and Supplies - Scientific 0 0 0 0 % 0 0 % 0 %Material and Supplies - General 0 0 0 0 % 0 0 % 0 %Equipment/Depreciation 0 0 0 0 % 0 0 % 0 %Malpractice Insurance 0 0 0 0 % 0 0 % 0 %Communications 0 0 0 0 % 0 0 % 0 %Space Rental 0 0 0 0 % 0 0 % 0 %Other Expense 0 0 0 0 % 0 0 % 0 %Total Expense 0 0 0 0 % 0 0 % 0 %
Other Transfers In/(Out) 0 0 0 0 % 0 0 % 0 %
Current Year Surplus / (Deficit) 0 0 0 0 % 0 0 % 0 %
Prior Year Carry Forward 0 0 0 0 % 0 0 % 0 %
Ending Balance 0 0 0 0 % 0 0 % 0 %
Benefit Rates 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
(G-10)
DEPARTMENT OF ________________SUMMARY BY MISSION REPORT LEVEL 3FISCAL YEAR 2016-17 11/24/20XX
1:42:42 PMFund Group: Compensation PlanFund: 62XXX - Med Comp Plan
Projected Projected Projected Projected Budget Budget Budget Budget15-16 15-16 15-16 15-16 16-17 16-17 16-17 16-17
Clinical Education Research Total Clinical Education Research TotalRevenue Net Patient Care Revenue 0 0 0 0Net Patient Care - Recharges 0 0 0 0Other Comp. Plan Revenue 0 0 0 0 0 0Directorships 0 0 0 0Health System Transfers 0 0 0 0Support from Dean's Office (Rev. Side) 0 0 0 0 0 0Misc. Recharges 0 0 0 0Interfund Transfers Internal (Exp. Side) 0 0 0 0 0 0 0 0Interfund Transfers External (Exp. Side) 0 0 0 0Interest STIP 0 0 0 0Dean's Tax (Exp. Side) 0 0 0 0Dean's Tax True-Up (Exp. Side) 0 0 0 0Total Revenue 0 0 0 0 0 0 0 0
Expense Faculty Temporary 0 0 0 0 0 0Staff Physician Salaries 0 0 0 0Staff Salaries 0 0 0 0 0 0 0 0Academic Other 0 0 0 0Academic Apprentice 0 0 0 0Interns and Residents 0 0 0 0Benefits 0 0 0 0 0 0 0 0Computing Services 0 0 0 0 0 0 0 0Consultants 0 0 0 0Professional Services - Other 0 0 0 0 0 0DLAM 0 0 0 0Printing & Copying 0 0 0 0 0 0 0 0Services - Other 0 0 0 0 0 0 0 0Repairs & Maint. - Equipment (Non Computer) 0 0 0 0Entertainment 0 0 0 0 0 0Travel 0 0 0 0 0 0Facility 0 0 0 0 0 0Material and Supplies - Scientific 0 0 0 0 0 0Material and Supplies - General 0 0 0 0 0 0 0 0Equipment (Computer) 0 0 0 0 0 0 0 0Equipment (Non Computer) 0 0 0 0Malpractice Insurance 0 0 0 0Telephone 0 0 0 0 0 0 0 0Mail & Messenger 0 0 0 0 0 0Insurance 0 0 0 0 0 0 0 0Other Expense 0 0 0 0 0 0Total Expense 0 0 0 0 0 0 0 0
Current Year Surplus / (Deficit) 0 0 0 0 0 0 0 0
Prior Year Carry Forward 0 0
Ending Balance 0 0 0 0 0 0 0 0
(G-11)
DEPARTMENT OF _______________ACTUAL + PROJECTED LEVEL 3FISCAL YEAR 2016-17 11/24/20XX
1:47:53 PMFund Group: Gifts & Endowments
Actual Dept Projected Total ProjectedJul 15- Dec 15 Jan 16 - Jun 16 Jul 15 - Jun 16
Education & Research OperationsRevenue Gift Revenue 0 0 0Endowment Revenue 0 0 0Support from Dean's Office (Rev. Side) 0 0 0Total Revenue 0 0 0
Expense Faculty Temporary 0 0 0Staff Salaries 0 0 0Academic Apprentice 0 0 0Benefits 0 0 0Computing Services 0 0 0Professional Services - Other 0 0 0DLAM 0 0 0Printing & Copying 0 0 0Services - Other 0 0 0Entertainment 0 0 0Travel 0 0 0Facility 0 0 0Material and Supplies - Scientific 0 0 0Material and Supplies - General 0 0 0Equipment (Computer) 0 0 0Telephone 0 0 0Mail & Messenger 0 0 0Insurance 0 0 0Financial Aid 0 0 0Other Expense 0 0 0Total Expense 0 0 0
Current Year Surplus / (Deficit) Ed. & Res. Oper. 0 0 0
(G-12)
11/24/20XXDEPARTMENT OF _________________________________ 1:52:38 PM
All Funds All Funds All Funds Comp PlansContracts &
GrantsGifts &
Endowments ICRSales & Services State
Suppl. Tuition & Other UC Total Variance
Actual Budget Projected Budget Budget Budget Budget Budget Budget Budget Budget Budget to
14-15 15-16 15-16 16-17 16-17 16-17 16-17 16-17 16-17 16-17 16-17 ProjectedRevenue Net Patient Care & MAP Facility Revenue 0 0 0 0 0 0 0 0 0 0 0 0%Other Comp. Plan Revenue 0 0 0 0 0 0 0 0 0 0 0 0%C&G Revenue 0 0 0 0 0 0 0 0 0 0 0 0%Sales & Service Revenue 0 0 0 0 0 0 0 0 0 0 0 0%Gifts & Endowments Revenue 0 0 0 0 0 0 0 0 0 0 0 0%Indirect Cost Recovery Revenue 0 0 0 0 0 0 0 0 0 0 0 0%State Appropriations 0 0 0 0 0 0 0 0 0 0 0 0%Supplemental Tuition (PDST) 0 0 0 0 0 0 0 0 0 0 0 0%Other UC Appropriation Revenue 0 0 0 0 0 0 0 0 0 0 0 0%CPN/SCN Recharges 0 0 0 0 0 0 0 0 0 0 0 0%Health System Recharges/Transfers 0 0 0 0 0 0 0 0 0 0 0 0%Support from Dean's Office 0 0 0 0 0 0 0 0 0 0 0 0%Misc. & Interfund Recharges/Transfers 0 0 0 0 0 0 0 0 0 0 0 0%Interest STIP 0 0 0 0 0 0 0 0 0 0 0 0%Dean's Tax 0 0 0 0 0 0 0 0 0 0 0 0%Total Revenue 0 0 0 0 0 0 0 0 0 0 0 0%
Expense Faculty Salaries 0 0 0 0 0 0 0 0 0 0 0 0%Staff Physician Salaries 0 0 0 0 0 0 0 0 0 0 0 0%Staff & Non-Faculty Salaries 0 0 0 0 0 0 0 0 0 0 0 0%Interns and Residents Salaries 0 0 0 0 0 0 0 0 0 0 0 0%Benefits 0 0 0 0 0 0 0 0 0 0 0 0%Professional & Purchased Services 0 0 0 0 0 0 0 0 0 0 0 0%Material and Supplies - Scientific 0 0 0 0 0 0 0 0 0 0 0 0%Material and Supplies - General 0 0 0 0 0 0 0 0 0 0 0 0%Equipment/Depreciation 0 0 0 0 0 0 0 0 0 0 0 0%Malpractice Insurance 0 0 0 0 0 0 0 0 0 0 0 0%Communications 0 0 0 0 0 0 0 0 0 0 0 0%Space Rental 0 0 0 0 0 0 0 0 0 0 0 0%Other Expense 0 0 0 0 0 0 0 0 0 0 0 0%Total Expense 0 0 0 0 0 0 0 0 0 0 0 0%
Other Transfers In/(Out) 0 0 0 0 0 0 0 0 0 0 0 0%
Current Year Surplus / (Deficit) 0 0 0 0 0 0 0 0 0 0 0 0%
Prior Year Carry Forward 0 0 0 0 0 0 0 0 0 0 0 0%
Ending Balance 0 0 0 0 0 0 0 0 0 0 0 0%
DAVID GEFFEN SCHOOL OF MEDICINE AT UCLABY FUND GROUP - ALL MISSIONS - LEVEL 1
Budget 2016-17
(G-13)
11/24/20XXDEPARTMENT OF _________________________ 1:55:06 PM
All Funds All Funds All Funds All Funds Comp PlansContracts &
GrantsGifts &
Endowments ICRSales & Services State
Tuition & Other UC Total Variance
Projected Actual Budget Projected Budget Budget Budget Budget Budget Budget Budget Budget Budget to
14-15 14-15 15-16 15-16 16-17 16-17 16-17 16-17 16-17 16-17 16-17 16-17 ProjectedRevenue Net Patient Care & MAP Facility Revenue 0 0 0 0 0 0 0 0 0 0 0 0 0%Other Comp. Plan Revenue 0 0 0 0 0 0 0 0 0 0 0 0 0%C&G Revenue 0 0 0 0 0 0 0 0 0 0 0 0 0%Sales & Service Revenue 0 0 0 0 0 0 0 0 0 0 0 0 0%Gifts & Endowments Revenue 0 0 0 0 0 0 0 0 0 0 0 0 0%Indirect Cost Recovery Revenue 0 0 0 0 0 0 0 0 0 0 0 0 0%State Appropriations 0 0 0 0 0 0 0 0 0 0 0 0 0%Supplemental Tuition (PDST) 0 0 0 0 0 0 0 0 0 0 0 0 0%Other UC Appropriation Revenue 0 0 0 0 0 0 0 0 0 0 0 0 0%CPN/SCN Recharges 0 0 0 0 0 0 0 0 0 0 0 0 0%Health System Recharges/Transfers 0 0 0 0 0 0 0 0 0 0 0 0 0%Support from Dean's Office 0 0 0 0 0 0 0 0 0 0 0 0 0%Misc. & Interfund Recharges/Transfers 0 0 0 0 0 0 0 0 0 0 0 0 0%Interest STIP 0 0 0 0 0 0 0 0 0 0 0 0 0%Dean's Tax 0 0 0 0 0 0 0 0 0 0 0 0 0%Total Revenue 0 0 0 0 0 0 0 0 0 0 0 0 0%
Expense Faculty Salaries 0 0 0 0 0 0 0 0 0 0 0 0 0%Staff Physician Salaries 0 0 0 0 0 0 0 0 0 0 0 0 0%Staff & Non-Faculty Salaries 0 0 0 0 0 0 0 0 0 0 0 0 0%Interns and Residents Salaries 0 0 0 0 0 0 0 0 0 0 0 0 0%Benefits 0 0 0 0 0 0 0 0 0 0 0 0 0%Professional & Purchased Services 0 0 0 0 0 0 0 0 0 0 0 0 0%Material and Supplies - Scientific 0 0 0 0 0 0 0 0 0 0 0 0 0%Material and Supplies - General 0 0 0 0 0 0 0 0 0 0 0 0 0%Equipment/Depreciation 0 0 0 0 0 0 0 0 0 0 0 0 0%Malpractice Insurance 0 0 0 0 0 0 0 0 0 0 0 0 0%Communications 0 0 0 0 0 0 0 0 0 0 0 0 0%Space Rental 0 0 0 0 0 0 0 0 0 0 0 0 0%Other Expense 0 0 0 0 0 0 0 0 0 0 0 0 0%Total Expense 0 0 0 0 0 0 0 0 0 0 0 0 0%
Other Transfers In/(Out) 0 0 0 0 0 0 0 0 0 0 0 0 0%
Current Year Surplus / (Deficit) 0 0 0 0 0 0 0 0 0 0 0 0 0%
Prior Year Carry Forward 0 0 0 0 0 0 0 0 0 0 0 0 0%
Ending Balance 0 0 0 0 0 0 0 0 0 0 0 0 0%
Benefit Rates 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
(G-14)
DAVID GEFFEN SCHOOL OF MEDICINE AT UCLABY FUND GROUP - ALL MISSIONS - LEVEL 1
Budget 2016-17
DEPARTMENT OF _____________ 11/25/20XXDEAN'S OFFICE SUPPORT DETAIL REPORT 7:27:27 AMMISSION/ALL - REVIEW TYPES/ALL - REQUEST STATUS/ALL - DO TYPE=ALLFISCAL YEAR 2016-17
Category Request Status
Review Type
Description Source Fund Group
Fund Amount Mission Remark DO Type Ref Id
Pending Ext FITZMAURICE, ARTHUR R DEAN_04 OMP 19900 - E Test 1 ED&R 1600Pr Appr Cont FITZMAURICE, ARTHUR R DEAN_02 CPL 62XXX - E Test 2 ED&R 1600Pr Appr Cont KURATA, LYNN DEAN_04 OMP 19900 - E Test 3 Other 1602Pr Appr Cont KURATA, LYNN DEAN_06 GEN - E Test 4 SAO 1603Pending New ZEE, LUCY M DEAN_04 OMP 19900 - E Test 5 ED&R
Total Plan Faculty -
OtherPending Ext Dr. Bruin - Recall DEAN_02 CPL 62XXX - E Test 6 Other
Total Other -
Grand Total -
(G-15)
DEPARTMENT OF ________________ 11/25/20XXAPPROVED DEAN'S OFFICE SUPPORT WITH NO BUDGETED EXPENSE 7:28:48 AMMISSION/ALL - REVIEW TYPES/ALL - DO TYPE=ALLFISCAL YEAR 2016-17
CategoryRequest Status
Review Type Description Source
Fund Group Fund Amount
Mission Remark
DO Type Ref Id
Budgeted Expense
Embedded Y/N? *
Other
Appr New New Medical Education Prgrm DEAN_01 CPL 62XXX - E Dr. Bruin's Training Center OtherTotal Other -
Grand Total -
* NOTE: If Budgeted Expense Associated With The Above Approved Support Is NOT Already Embedded Within AFB, Provide The Dean's Office With a List Of Expenditures To Be Added Into The Budget Program. If The Dean's Office Receives No Instructions On How To Treat Each Support Item Listed In This Report, Then An Expense Amount Equivalent To The Approved Support Will Be Created Under "Other Expense."
(G-16)
DEPARTMENT OF _______________ 11/25/2015DEANS OFFICE SUPPORT - LINKING FACULTY SALARY EXPENSE TO REVENUE 10:31:18 AMFISCAL YEAR 2016-17
Source Fund DO Type FP Id Mis. +EBFaculty Name Description Remark AFB Revenue $ FPM Expense $ FPM Salary $FPM Benefits
$(Over)/Under Used Support
DEAN_01 62110 Recr 100 R BRUIN, SALLY BRUIN, SALLY ED&R 25,000 - - - 25,000DEAN_01 62110 Recr 101 R Y BRUIN, SALLY BRUIN, SALLY SAO 19,500 - - - 19,500DEAN_01 62110 Reten 47 R BRUIN, JOE BRUIN, JOE Faculty Retention Package 50,000 69,367 49,980 19,387 (19,367)Grand Total 94,500 69,367 49,980 19,387 25,133
(G-17)
DEPARTMENT OF _______________ 11/25/20XXHEALTH SYSTEM SUPPORT DETAIL REPORT 7:31:36 AMMISSION/ALL - REVIEW TYPES/ALL - REQUEST STATUS/ALL - HS TYPES/ALLFISCAL YEAR 2016-17
Category Request Status
Review Type
Description Source Fund Group
Fund Amount Mission Remark HS Type HS Rec
Plan FacultyPr Appr Cont HELLER, PETER CPL_04 CPL 62XXX - C Test CPL04 Drctrshp 1100Pr Appr Cont HELLER, PETER CPL_05 CPL 62XXX - C Test CPL05 HSTrans 1150Pr Appr Cont HELLER, PETER CPL_07 CPL 62XXX - C Test CPL07 Drctrshp 1200
Total Plan Faculty -
OtherPr Appr Cont Yr 2 of 3 Yr Request for Operational SCPL_05 CPL 62XXX - C Test Data HSTrans 1225Pr Appr Cont Performance Metrics CPL_04 CPL 62XXX - C Test Program HSTrans 1250
Total Other -
Grand Total -(G-18)
DEPARTMENT OF _____________ 11/25/20XXREVENUE AND TRANSFER DETAIL REPORT - ALL MISSIONS 7:35:19 AMFISCAL YEAR 2016-17
Plan: MCPFund: 62XXX
Name/Description AmountDean's
Tax RemarksNet Patient Care & MAP Facility Revenue
Net Patient Care RevenueTest Data 0 Y
Total Net Patient Care Revenue 0
Total Net Patient Care & MAP Facility Revenue 0
Other Comp. Plan RevenueOther Comp. Plan Revenue
Legal Consulting 0 YTotal Other Comp. Plan Revenue 0
Total Other Comp. Plan Revenue 0
Health System Recharges/TransfersDirectorships
PF - Medical Directorships 0 N Test CPL04Total Directorships 0
Health System TransfersPF-NPH 0 N Test CPL07
Total Health System Transfers 0
Total Health System Recharges/Transfers 0
Support from Dean's OfficeSupport from Dean's Office (Rev. Side)
PF - Dean's Office Support (Prof Fees) 0 N Remarks 1New Programmatic Support 0 N
Total Support from Dean's Office (Rev. Side) 0
Total Support from Dean's Office 0
Misc. & Interfund Recharges/TransfersMisc. Recharges
Olympic Lab Green Consult Agreement 0 NTotal Misc. Recharges 0
Interfund Transfers External (Exp. Side)PF-Fund Source Exchange 0 N
Total Interfund Transfers External (Exp. Side) 0
Total Misc. & Interfund Recharges/Transfers 0
Dean's TaxDean's Tax (Exp. Side)
Automatic Calculation 0 Total Dean's Tax (Exp. Side) 0
Total Dean's Tax 0
Total Revenue 0
Other Transfers In/(Out)Other Transfers In/(Out)
Example for Report 0 N UCSFTotal Other Transfers In/(Out) 0
Total Other Transfers In/(Out) 0
(G-19)
DEPARTMENT OF_______________BUDGET DETAIL EXPENSE REPORT - ALL MISSIONSFISCAL YEAR 2016-17 11/25/20XX
7:40:58 AMPlan: MCPFund: 62XXX
Expense Name/Description Salary Benefit Total RemarksPayroll Expenses
Faculty Ladder Plan Faculty (PF) NAME - Salary Exp 0 0Faculty Ladder PF - "X + Y" Firm COLA Salary Contingency 0 0Faculty Ladder PF - "Y" Firm COLA Salary Contingency 0 0Faculty Temporary Plan Faculty (PF) NAME - Salary Exp 0 0Faculty Temporary PF - "X + Y" Firm COLA Salary Contingency 0 0Faculty Temporary PF - "Y" Firm COLA Salary Contingency 0 0Staff Physician Salaries Staff Physicians 200 Med Plaza 0 0 0Staff Salaries Consult Suites 0 0 0Benefits PF-Plan Faculty X Salary Exp 0 0Benefits PF-Plan Faculty Y Salary Exp 0 0Benefits PF - "X + Y" Firm COLA Benefits Contingency 0 0Benefits PF - "Y" Firm COLA Benefits Contingency 0 0
Total Payroll Expenses 0 0 0
Non-Payroll ExpensesProfessional Services - Other PSS 0Services - Other 0Material and Supplies - Scientific Pharmacy 0Equipment Replacement Scanner 0Insurance General liability ins. for PF-Plan Faculty Salary Exp 0 Auto. Calc.
Total Non-Payroll Expenses 0 0 0
Grand Total 0
(G-20)
DEPARTMENT OF ______________ 11/25/20XXPROFESSIONAL FEES - ACADEMIC ENRICHMENT DETAIL REPORT 7:55:29 AMFISCAL YEAR 2016-17
Plan: MCPFund: 62XXX
Purpose Faculty Name AmountINDIVIDUAL RESERVES ABERNATHY, PETER 0
DELHOMME, CHRIS 0YURATA, LYNN 0
TOTAL INDIVIDUAL RESERVES 0
PENDING CONTRACTS & GRANTS DELHOMME, CHRIS 0HELLER, PETER 0
TOTAL PENDING CONTRACTS & GRANTS 0
RETENTION BLACK, BILL 0GRAY, VERONICA 0ZEE, LUCY 0
TOTAL RETENTION 0
START UP DELBUONO, MICHAEL 0FITZMAURICE, ARTHUR 0PITRIRRI, KAREN
TOTAL START UP 0
(G-21)
DEPARTMENT OF ________________ 11/25/20XXDESIGNATION OF BALANCE COMPARISON REPORT 8:25:14 AMBUDGET YEAR 2016-17Plan: MCPFund: 62XXX
PI NameFY15-16 Projected
BalanceFY14-15 Projected
BalanceAmt Difference
Fav/(Unfav)% Difference
Fav/(Unfav)Plan Member Reserves 1,100,784 900,000 200,784 22.31%
Individuals Subtotal 1,100,784 900,000 200,784 22.31%
Chief/Program A 250,000 200,000 50,000 25.00%Chief/Program B 750,000 800,000 (50,000) -6.25%Chief/Program Subtotal 1,000,000 1,000,000 0 0.00%
Chair Reserve A 1,750,000 1,000,000 750,000 75.00%Chair Reserve B 750,000 500,000 250,000 50.00%Chair Subtotal 2,500,000 1,500,000 1,000,000 66.67%
Grand Total 4,600,784 3,400,000 1,200,784 35.32%
( G-22)
DEPARTMENT OF _______________ 12/27/20XXSUMMARY OF PLAN FACULTY SALARY EXPENSES AND BENEFITS BY SOURCE 12:47:44 PMFISCAL YEAR 2016-17
Plan: MCP
Total # of Faculty: XX
Base XAdd
X<=.3Add X>.3
Add. Comp. Y
Total Neg.
Salary X+Y Emp.Ben.
Total X+Y&E.B. Z Z Ben.
State 199XX-Dept FTE 0 0 0 0 0 0 0State 199XX-NPI FTE 0 0 0 0 0 0 0Total State Funds 0 0 0 0 0 0 0
Fed C& G-NIH/SAMHSA 0 0 0 0 0 0 0Fed C&G-Other Agenices 0 0 0 0 0 0 0Total Federal C&G 0 0 0 0 0 0 0
Private-Contracts & Grants 0 0 0 0 0 0 0Private-Gifts 0 0 0 0 0 0 0Private-Endowments 0 0 0 0 0 0 0Total Private 0 0 0 0 0 0 0
Gov't-State Agmt. 0 0 0 0 0 0 0Total Local Gov't 0 0 0 0 0 0 0
Prof Fees-Dept. 0 0 0 0 0 0 0 0 0Prof Fees-Acad. Enrich. 0 0 0 0 0 0 0 0 0Prof Fees-MC Med. Dir. 0 0 0 0 0 0 0 0 0Prof Fees-CPN/SCN 0 0 0 0 0 0 0 0 0Total Prof. Fees 0 0 0 0 0 0 0 0 0
Dean's Office-Prof. Fees 0 0 0 0 0 0 0Dean's Office-Student Fees 0 0 0 0 0 0 0Dean's Office-199XX Salary Sav. Supp. 0 0 0 0 0 0 0Dean's Office-ICR 0 0 0 0 0 0 0Total Dean 0 0 0 0 0 0 0Total UCLA 0 0 0 0 0 0 0 0 0
Direct Pay-VA 0 0 0 0 0 0 0 Total Direct Pay 0 0 0 0 0 0 0
Total-All Sources 0 0 0 0 0 0 0 0 0
(G-23)
DEPARTMENT OF _______________ 11/25/20XXPLAN FACULTY SALARY EXPENSES BY SOURCE & REPORT ROW 8:59:26 AMFISCAL YEAR 2016-17
Plan: MCPFund: 62XXXAll Missions
Total # of Faculty: XX
SourceSource Code X+Y EB X+Y EB Z EB Z EB Total
State 199XX-Dept FTE STATE_01 0 0 0State 199XX-Dept Temp STATE_02 0 0 0State 199XX-NPI FTE STATE_03 0 0 0Total State Funds 0 0 0 0 0 0 0 0 0
Fed C& G-NIH/SAMHSA NIH_01 0 0 0 0 0Fed C&G-Other Agenices FCG_01 0 0 0 0 0Total Federal C&G 0 0 0 0 0 0 0 0 0
Private-Contracts & Grants PCG_01 0 0 0 0 0Private-Gifts GFT_01 0 0 0 0 0Private-Endowments END_01 0 0 0 0 0Total Private 0 0 0 0 0 0 0 0 0
Gov't-State Agmt. SCG_01 0 0 0 0 0Total Local Gov't 0 0 0 0 0 0 0 0 0
Prof Fees-Dept. CPL_01 0 0 0 0 0 0 0 0 0Prof Fees-Acad. Enrich. CPL_02 0 0 0 0 0 0 0 0 0Total Prof. Fees 0 0 0 0 0 0 0 0 0
Dean's Office-Student Fees DEAN_02 0 0 0 0 0Dean's Office-Geffen Funds DEAN_06 0 0 0 0 0Total Dean 0 0 0 0 0 0 0 0 0Total UCLA 0 0
Direct Pay-L.A. Co. Ol Vw DP_05 0 0 Total Direct Pay 0 0 0 0 0 0 0 0 0
Total-All Sources 0 0 0 0 0 0 0 0 0
Faculty Ladder Faculty Temporary Faculty Ladder Faculty Temporary
(G-24)
DEPARTMENT OF _____________ 11/25/20XXSALARY SAVINGS 9:36:36 AMFISCAL YEAR 2016-17
Plan: MCPFund: 62XXX
NameTitle Code Step
Base Salary Annual Cost Source of Support
ALEJANDRO, DELIS 1721 3 0 Private-Contracts & GrantsGERETY, CHRISTINE 1721 1 0 Fed C& G-NIH/SAMHSAGERETY, CHRISTINE 1721 1 0 Private-Contracts & GrantsNEWLAND, IRENE 1721 6 0 Private-Contracts & GrantsTORGERSON, LLOYD 1721 A 0 Private-GiftsWAINSCOT, EMILY 1721 9 0 Fed C& G-NIH/SAMHSAYUN, DOK 1719 3 0 Fed C& G-NIH/SAMHSA
Total: 0
(G-25)
Plan: MCPFund: XXXXX ANNUAL NEGOTIATED SALARIES
NAME SALARY CURRENT PROPOSED % TOTAL TOTALAPU - LOCATION COMP. SALARY SALARY INC. ANNUAL ANNUALCODE - STEP - TITLE NAME RATE RATE DEC. COST COSTNOTES "X+Y" "X+Y+Z"TEST5CHR (M) X 0 0 0%Department-Chair Add X 0 0 0% 0 STATE_01 0 NIH_01 0 NIH_01 0 0 CPL_01 0XXXXXX - X Y 0 0 0% 0 CPL_01 0 CPL_02 0 01721 - 7- PROF MCP X+Y 0 0 0% 0 DEAN_XX 0 0X + Y Firm Merit/Promo Z 0 0 0%Test Note 5 X+Y+Z 0 0 0%
Total 0 0 0 0 0 0TEST6 (F) X 0 0 0%Department Add X 0 0 0% 0 PCG_01 0 CPL_01 0 GFT_01 0 0XXXXXX-X Y 0 0 0% 0 END_01 0 CPL_01 0 01724 - 2 - INRSDN ASST P MCP X+Y 0 0 0% 0 CPL_01 0 0X + Y Firm Z 0 0 0%
X+Y+Z 0 0 0% Total 0 0 0 0 0 0(G
-26)
ANN ADD'L BASEANN BASESCALE 0
DEPARTMENT OF _______________
FISCAL YEAR 2016-17
"Y"
ESTADD'LCOMP
ANN NEGOTADD'L COMP
"X"SCALE 1-9
"X"
11/25/20XX9:39:53 AM
"Z"
DEPARTMENT OF ________________ 11/25/20XXFACULTY FAU REPORT (WITH COLA/MA CONTINGENCY) 9:49:05 AMFISCAL YEAR 2016-17
Plan: MCPFund: 62XXX
Name Employee ID Title Plan FRow APU Scale StepOff-Scale
State FTE
NPI FTE Pay Comp. Source Fund Account CC Project
Annual Amount TNS
Benefit Rate
Benefit Cost
Total Sal. & Ben
NIH Code Miss. Sex Rank Firm
NAME 1 XXXXXXXXX 1726 MCP FTEM XXXXXX 5 8 N N N X CPL_01 62145 401042 1A 156,581 237,100 26.31% 41,196 197,777 0 C M Prof X + Y NAME 1 XXXXXXXXX 1726 MCP FTEM XXXXXX 5 8 N N N AddX1 CPL_01 62145 401042 1A 46,993 237,100 26.31% 12,364 59,357 0 C M Prof X + Y NAME 1 XXXXXXXXX 1726 MCP FTEM XXXXXX 5 8 N N N AddX2 CPL_01 62145 401042 1A 31,297 237,100 26.31% 8,234 39,531 0 C M Prof X + Y NAME 1 XXXXXXXXX 1726 MCP FTEM XXXXXX 5 8 N N N Y CPL_01 62145 401042 1A 2,229 237,100 11.96% 267 2,496 0 C M Prof X + Y NAME 1 XXXXXXXXX 1726 MCP FTEM XXXXXX 5 8 N N N X COLA Cont CPL_01 62145 4,935 237,100 26.31% 1,298 6,233 0 C M Prof X + Y NAME 1 XXXXXXXXX 1726 MCP FTEM XXXXXX 5 8 N N N X COLA Cont Ben CPL_01 62145 0 237,100 15.35% 319 319 0 C M Prof X + Y NAME 2 XXXXXXXXX 1733 MCP FTEM XXXXXX 5 2 N N N X CPL_01 62145 401042 1A 82,783 215,300 23.84% 19,735 102,518 0 C F Assoc Prof X + Y NAME 2 XXXXXXXXX 1733 MCP FTEM XXXXXX 5 2 N N N AddX1 CPL_01 62145 401042 1A 24,781 215,300 23.84% 5,908 30,689 0 C F Assoc Prof X + Y NAME 2 XXXXXXXXX 1733 MCP FTEM XXXXXX 5 2 N N N AddX2 CPL_01 62145 401042 1A 16,600 215,300 23.84% 3,957 20,557 0 C F Assoc Prof X + Y NAME 2 XXXXXXXXX 1733 MCP FTEM XXXXXX 5 2 N N N Y CPL_01 62145 401042 1A 91,137 215,300 9.49% 8,649 99,786 0 C F Assoc Prof X + Y NAME 2 XXXXXXXXX 1733 MCP FTEM XXXXXX 5 2 N N N X COLA Cont Ben CPL_01 62145 0 215,300 15.35% 540 540 0 C F Assoc Prof X + Y NAME 3 XXXXXXXXX 1712 MCP FTEM XXXXXX 5 1 N N N X CPL_01 62145 401042 1C 31,788 180,000 27.15% 8,630 40,418 0 E F Asst Prof X + Y NAME 3 XXXXXXXXX 1712 MCP FTEM XXXXXX 5 1 N N N AddX1 CPL_01 62145 401042 1C 9,540 180,000 27.15% 2,590 12,130 0 E F Asst Prof X + Y NAME 3 XXXXXXXXX 1712 MCP FTEM XXXXXX 5 1 N N N AddX2 CPL_01 62145 401042 1C 6,336 180,000 27.15% 1,720 8,056 0 E F Asst Prof X + Y NAME 3 XXXXXXXXX 1712 MCP FTEM XXXXXX 5 1 N N N Y CPL_01 62145 401042 1C 132,336 180,000 12.80% 16,939 149,275 0 E F Asst Prof X + Y NAME 3 XXXXXXXXX 1712 MCP FTEM XXXXXX 5 1 N N N X COLA Cont Ben CPL_01 62145 0 180,000 15.35% 415 415 0 C F Asst Prof X + Y
(G-27)
DEPARTMENT OF ________________ 11/25/20XXFACULTY COLA/MA CONTINGENCY SUMMARY REPORT 9:58:00 AMFISCAL YEAR 2016-17
Plan: MCPFund: 62XXX
Name Employee ID Title Plan FRow APU Scale StepOff-Scale
State FTE
NPI FTE Pay Comp. Source Fund
Annual Amount TNS
Benefit Rate
Benefit Cost
Total Sal. & Ben
NIH Code Miss. Sex Rank Firm
NAME 1 XXXXXXXXX 1726 MCP FTEM XXXXXX 5 8 N N N X COLA Cont CPL_01 62XXX 4,935 237,100 26.31% 1,298 6,233 0 C M Prof X + Y NAME 1 XXXXXXXXX 1726 MCP FTEM XXXXXX 5 8 N N N X COLA Cont Ben CPL_01 62XXX 0 237,100 15.35% 319 319 0 C M Prof X + Y NAME 2 XXXXXXXXX 1733 MCP FTEM XXXXXX 5 2 N N N X COLA Cont Ben CPL_01 62XXX 0 215,300 15.35% 540 540 0 C F Assoc Prof X + Y NAME 3 XXXXXXXXX 1712 MCP FTEM XXXXXX 5 1 N N N X COLA Cont Ben CPL_01 62XXX 0 180,000 15.35% 415 415 0 C F Asst Prof X + Y
Total Cost of COLA & MA - Ladder Faculty: 0 0 0Total Cost of COLA & MA - Temporary Faculty: 4,935 2,573 7,508
(G-28)
FISCAL YEAR 2016-17 11/25/20XXAPU Scale Change Summary Report 10:07:00 AMAPU Code(s): 15xxAA
FRow Acct Dept Fund Group Fund Miss. AmountBEN. 15XX CNG R 0FTEM 15XX CNG R 0BEN. 15XX CPL C 0FLAD 15XX CPL C 0BEN. 15XX GFT R 0FTEM 15XX GFT R 0BEN. 15XX ICR R 0FLAD 15XX ICR R 0
0
(G-29)
DEPARTMENT________________FISCAL YEAR 2016-17 11/25/20XXAPU Scale Change Detail Report For APU Code(s): 15xxAA 10:16:15 AM
Dept Code Dept Name Name
Employee ID FRow APU Scale Step Rank
Pay Comp.
Annual Amount From Y
From Y Benefits Additional
Additional Benefits
15XX Sample Department BBBBBBBBBB 111111111 FTEM 15xxAA 5 6 Prof X 15XX Sample Department BBBBBBBBBB 111111111 FTEM 15xxAA 5 6 Prof X 15XX Sample Department BBBBBBBBBB 111111111 FTEM 15xxAA 5 6 Prof X 15XX Sample Department BBBBBBBBBB 111111111 FTEM 15xxAA 5 6 Prof AddX115XX Sample Department BBBBBBBBBB 111111111 FTEM 15xxAA 5 6 Prof AddX115XX Sample Department BBBBBBBBBB 111111111 FTEM 15xxAA 5 6 Prof AddX2 0,000 015XX Sample Department BBBBBBBBBB 111111111 FTEM 15xxAA 5 6 Prof Y 00,000 015XX Sample Department BBBBBBBBBB 111111111 FTEM 15xxAA 5 6 Prof AddX3 00,00015XX Sample Department CCCCCCCCCCCCC 222222222 FTEM 15xxAA 5 3 Asst Prof X 15XX Sample Department CCCCCCCCCCCCC 222222222 FTEM 15xxAA 5 3 Asst Prof AddX115XX Sample Department CCCCCCCCCCCCC 222222222 FTEM 15xxAA 5 3 Asst Prof AddX215XX Sample Department CCCCCCCCCCCCC 222222222 FTEM 15xxAA 5 3 Asst Prof Y 00,000 0 0,000 015XX Sample Department CCCCCCCCCCCCC 222222222 FTEM 15xxAA 5 3 Asst Prof AddX3 00,00015XX Sample Department DDDDDD 333333333 FTEM 15xxAA 5 2 Assoc Prof X 15XX Sample Department DDDDDD 333333333 FTEM 15xxAA 5 2 Assoc Prof AddX115XX Sample Department DDDDDD 333333333 FTEM 15xxAA 5 2 Assoc Prof AddX215XX Sample Department DDDDDD 333333333 FTEM 15xxAA 5 2 Assoc Prof Y 00,000 0 0,000 015XX Sample Department DDDDDD 333333333 FTEM 15xxAA 5 2 Assoc Prof AddX3 00,00015XX Sample Department EEEEEEEEE 444444444 FTEM 15xxAA 5 5 Prof X 15XX Sample Department EEEEEEEEE 444444444 FTEM 15xxAA 5 5 Prof X 15XX Sample Department EEEEEEEEE 444444444 FTEM 15xxAA 5 5 Prof AddX1 00,000 015XX Sample Department EEEEEEEEE 444444444 FTEM 15xxAA 5 5 Prof AddX115XX Sample Department EEEEEEEEE 444444444 FTEM 15xxAA 5 5 Prof AddX2 00,000 015XX Sample Department EEEEEEEEE 444444444 FTEM 15xxAA 5 5 Prof AddX3 00,000 0 0
000,000 00,000
Some columns are hidden in this sample
(G-30)
DEPARTMENT OF _________________ 11/25/20XXFACULTY LADDER & TEMP MANUAL ENTRIES REPORT 10:24:24 AMFISCAL YEAR 2016-17
Plan: MCPFund: 62XXX
Fund AF Row Mission Source Amount Description Remarks Updated By Updated On
62XXX Faculty Temporary C CPL_01 0 "X+Y" COLA Moved to Alternative Funding Source User 11/25/20XX 10:23:11 AM62XXX Faculty Temporary C CPL_01 0 New Faculty - Dr. Elijah Smith User 11/25/20XX 10:23:11 AM62XXX Faculty Temporary C CPL_01 0 Call "Z" User 11/25/20XX 10:23:11 AM62XXX Faculty Temporary C CPL_01 0 Productivity "Z" User 11/25/20XX 10:23:11 AM
(G-31)
(H-1)
WRITE-UPS FOR THE BUDGET PROCESS Any necessary accompanying supporting documents may be saved with the budget program and transmitted electronically to the Dean’s Office. WRITE-UPS TAB:
The following are key features of the Writeup tab:
1. An ability to tell what document “write-up” types haven’t yet been sent to the Dean’s Office by looking at what’s listed under “Outstanding Writeup Type”
2. An ability to know the exact “write-up” document(s) already sent to the Dean’s Office. Every
document sent can be opened for viewing and resent, if an updated version needs to replace the original. Resending a “write-up” before locking the budget program (AFB) overwrites the original document. Resending a “write-up” after locking the AFB creates a document with the same file name, along with an added number at the end.
3. An ability to open and save the faculty salary adjustment instructions and information by clicking
on “Open Template File” button a. A pop-up box comes up for clinical departments with established Basic Science and Clinical
Compensation Plans that permits opening up both sets of forms or one at a time. Instructions for the overall process are as follows: CAO’s Letter – A summary level cover letter as to the major programmatic and financial factors influencing significant variations in the department’s FY15-16 projection and FY16-17 budgeted values compared to the FY14-15 actual and the final FY15-16 budget.
Write-up Type
Select Drive
Write-up File Write-up Type(s) Not Yet
Sent To Dean
2016-17
Write-up Type(s) Already
Sent To Dean
Access Faculty Info Template(s)
FacBSP 16-17.docx
FacBSP.docx
FacMCP 16-17.docx
FacMCP.docx
FacBSP 16-17.docx
(H-2)
Support Requests Health System Support A School operating unit intending to solicit support from the Health System (HS) leadership for a new initiative or expand upon an existing commitment must complete and submit by December 4 the required funding template for each such request to the Hospital Budget Office. Do not send this template through the Writeups tab in AFB. For every Health System support item that represents new funding or an increase in the amount of existing support or an extension of a BOOK record scheduled to expire, the Dean’s Office will update the AFB for those requests granted approval no later than February 9, 2016. Dean’s Office Support Concerning support requests to the School of Medicine (DGSOM), only new, increase, or extension requests pertaining to the education and research missions will be entertained. Every School operating unit is responsible for inputting as a separate record under the DO Support tab each Department Support Request that meets this criteria, along with submitting a written justification through the Writeups tab no later than December 11. For DO funding classifiable as DO Program Support (e.g., Dean’s Compensation, ED&R, etc.), a School unit does not enter this type of support item in AFB under the DO Support tab, but there may be a need to submit documentation through the Writeups tab in order to substantiate the level of dollar support being sought for FY16-17. The Dean’s Office is committed to reflecting all approvals granted for both types of DO support requests no later than February 1, 2016. In composing a business plan justifying each individual DGSOM support request, please write or copy the document and/or Excel spreadsheet(s) in Word or Excel rather than a MAC format, so that it can be transmitted to our server. The AFB application is also able to accommodate PDF files with this method. Each file can be saved either to the default directory on the budget program which is C:\All Funds Budget\File name or to another directory. Once the file is created, it can be retrieved from the program. In the middle box, the default drive is C:\All Funds Budget. The files for this drive are in the right box. If the file was saved in a different directory, the directory can be accessed by pull down menu under “Select Your Drive.” The files will appear in the right box. After highlighting the file, it can be opened from the program. To send the file to the Dean’s Office – Close the file in Word. Click on “Support Requests,” select the drive that the file was saved in and click on the file name under “Select your write-up file” and click on “Send the Selected File to DO.” A message stating that the file was sent should appear. Each file sent will appear in the “Writeups Already Sent” box. Dean’s Tax Exemption Request For any net patient care revenue and/or other Compensation Plan revenue item presently taxed by the Dean’s Office for which an exemption is desired, submit the rationale for the request. Revenue Projections and Cash Collections and/or Comparison of Productivity Measures (e.g. Clinical Income Model) • Provide a copy of the assumptions that were used to project the gross charges and cash collections for
January 2016 through June 2017 (18 months) and provide what your Department used for projecting clinical income by individual, division, program/service, or department. Include discussion of the estimated changes in faculty, productivity, or rates and the periods in which the changes are expected.
• Include all footnotes or other notations explaining the assumptions going into the development of the
clinical income figure. Other Write-ups Write-ups on revenue/expense variances and other documents meant to assist with the fiscal review of the budget should be included as material attached under the “Writeups” tab. Any write-up done outside of the budget program on income and/or expense variances, the Clinical Income Model, or other information that is deemed informational to help the Dean’s Office better understand the financial workings of the department should be attached under the “Writeups” tab for access by the assigned fiscal reviewer in the Dean’s Office.
(H-3)
The Word or Excel file can be retrieved from the budget program. If the program was saved as C:\All Funds Budget\File name, it will appear in the right box. If the file was saved in a different directory, the directory can be accessed by pull down menu under “Select Your Drive.” After highlighting the file in the right box, it can be opened from the program To send the file to the Dean’s Office - Close the file in Word or Excel. Click on “Clin. Income Model” or “Other Docs,” and “Select your Drive” that the file was saved in and click on the file name under “Select Your Writeup file.” Click on “Send the Selected File to DO.” A message stating that the file was sent should appear. Each file sent will appear in the “Writeups Already Sent” box. SALARY ADJUSTMENT INSTRUCTIONS (Faculty & Salary Information Template) In the event that the actual salary scales, tables, or an individual’s merit or promotion differ from the estimated ones used for budget projections, the Salary Adjustment Instruction forms must be used to describe what’s occurring within your department. The Salary Adjustment Instruction forms are accessed by clicking on the “Open Template File” button under this tab of the budget program. Submitting this form allows the Dean’s Office Academic Affairs staff to recalculate the salary components without further negotiations. Your CSC no longer needs to download the new budget year faculty-template at the time of installing the budget program. Instead, upon clicking the “Open Template File” button a pop-up box comes up that permits you to access the forms for both the Basic Science (labeled FacBSP) and Clinical Compensation Plans (labeled FacMCP) or one at a time. Check the box on each template for each plan for the principal preference for handling the majority of faculty salaries and new hires. Choose either Negotiated Additional Compensation (Y) firm or Total Negotiated Salary (X+Y) firm. Deviations from the chosen method are noted under the section “Individual/Exceptions.” The “Individual/Exceptions” allows a user to type in a free-form style any of the individual variations to the chosen method. Note any “Individual Exceptions” in the area provided.
Save the file in c:\All Funds Budget\your file name. Then go to the budget program and click on write-ups and see the C:\All Funds Budget\your file name. It will be reflected in the middle box. You then highlight the file and open the file from the budget program. If you have more than one department, save each with a different name, e.g., Faculty-MCP-Family, Faculty-MCP-Pediatrics. To send the file to the Dean’s Office – Click on the file name under “Select Your Writeup File,” click on “Faculty Information-Clin. (FacCL)” or “Faculty Information-Bas. Sc. (FacBS)” as applicable, click on “Send the select file to DO.” ALL BASE SALARIES (X & X PRIME) WILL BE UPDATED FOR THE SCALE RATES (SCALES 0-9) AS APPROVED FOR THE ACADEMIC PROGRAMMATIC UNITS (APUs) FOR ELIGIBLE APPOINTEES ONLY. All rates will be rounded to the nearest $100 for determining values for the Campus Employee Database (EDB).
Templates for Faculty
Information
&
Open Writeup
FacMCP 16-17.docx
FacBSP 16-17.docx
(H-4)
For MCP/PCCP faculty, the following are the choices available: X+Y firm or Y Firm. The department is to select one method for the majority of participants. Any other method may then be selected for individual or group exceptions. Method 1 for MCP/PCCP “Negotiated Additional Compensation (Y) Firm” means that the dollar amount budgeted for “Addl. Comp.” will remain firm. Base salary rates, “Base X” and “X Prime”, will be adjusted based on the Scale 0-9 rates for the APU and appointees’ eligibility. The total X+Y rate will be adjusted accordingly. Use this method for any individuals that are negotiated to have rates at the APU scale level only as well. The value of the “Negotiated Additional Compensation (Y) Dollars” would be zero. For example, Dr. Apple is a Professor 6 with an APU approved for Scale 5. For illustration purposes, assume a 3% increase for 2016-17. Budget Scale Adjustment 3% Professor Appel-Scale 0 $142,500 $146,800 Diff.Scale 5-Scale 0 71,300 73,400 Scale 5 213,800 220,200 Add’l Comp Y 80,000 80,000 Total X & Y Salary 293,800 300,200 Method 2 for MCP/PCCP “Negotiated Total Salary (X+Y) Firm” remains the same, i.e., the total X+Y rate is firm. Given the same example above, the rates would be:
Budget Scale Adjustment 3% Professor Appel-Scale 0 $142,500 $146,800 Diff.Scale 5-Scale 0 71,300 73,400 Scale 5 213,800 220,200 Add’l Comp Y 80,000 73,600 Total X & Y Salary 293,800 293,800 If the individual does not have enough Y dollars to cover the increases in “Base X” and “X Prime”, then the salaries will be adjusted to the scale rate level approved for the APU for eligible appointees. The department is to select one method for the majority of participants. The other method may then be selected for individual or group exceptions. An alternative exception for faculty at affiliated hospitals or with outside funding sources is “UCLA Pay Firm” which means that the amount of pay from UCLA sources remains firm through-out the year. This option is available only as an exception for individuals or groups. Given the same example above, with the additional information that UCLA pay is $26,500 and Non-UCLA is $240,900, the rates would be: Part A Budget Scale Adjustment 3% Scale 0 (11-month) 142,500 146,800 Diff. Scale 5-Scale 0 71,300 73,400 Total Scale 5 213,800 220,200 Add’l Comp Y-Non-UCLA 27,100 240,900 20,700 240,900 Add’l Comp Y-UCLA 26,500 26,500 Total X+Y Salary 267,400 267,400 Now assume that the Non-UCLA, i.e. Outside Source on the budget is $240,900 and increases to $243,300: Part B Budget Scale Adjustment 3% Scale 0 (11-month) 142,500 146,800 Diff. Scale 5-Scale 0 71,300 73,400 Total Scale 5 213,800 220,200 Add’l Comp Y-Non-UCLA 27,100 240,900 23,100 243,300 Add’l Comp Y-UCLA 26,500 26,500 Total X+Y Salary 267,400 269,800
(H-5)
For the Basic Science Plan the following demonstrates the choices of adjusting the salaries. Method 1 for “Negotiated Additional Compensation (Y) Dollars Firm" means that the dollar amount budgeted for “Addl. Comp.” will remain firm. Base salary rates, “Base X” and “X Prime” will be adjusted based on the Scale 0-9 rates for the APU appointees’ eligibility. The total X+Y rate will be adjusted accordingly. Use this method for any individuals that are negotiated to have rates at the APU scale level only as well. The value of the “Negotiated Y Dollars” would be zero. For example, Dr. Asample is a Professor 6 with an APU approved for Scale 3 and Additional Compensation (Y) negotiated at $35,000. For illustration purposes, assume a 3% increases for 2016-17.
Budget Scale Adjustment 3% Professor Asample-Scale 0 $142,500 $146,800 Scale 3 Add’l Ret. 42,800 44,100 Scale 3 Total 185,300 190,900 Comp Y 35,000 35,000 Total X & Y Salary 220,300 225,900
Method 2 for “Negotiated Total Salary (X+Y) Firm” remains the same, i.e., the total X+Y rate is firm. Given the same example above, the rates would be: Budget Scale Adjustment 3% Professor Asample-Scale 0 $142,500 $146,800 Scale 3 Add’l Ret. 42,800 44,100 Scale 3 Total 185,300 190,900 Rest of Add’l Comp Y 35,000 29,400 Total X & Y Salary 220,300 220,300 If the individual does not have enough Y dollars to cover the increases in “Base X” and “X Prime”, then the salaries will be adjusted to the scale rate level approved for the APU for eligible appointees. FACULTY INFORMATION WRITE-UP (Faculty & Salary Information Template):
(H-6)
FACULTY INFORMATION The second part of the template form for “FacMCP or FacBSP” saved in the department’s budget program directory is used during the salary analysis and review portion of the budget process leading to approval of the annually negotiated salaries. The form provides set areas to discuss while allowing free-form responses after each heading selection. The set areas are expandable and include:
1. General Description of Faculty a. Describe strategic new positions or services to the compensation plan. b. List strategic faculty members, that is, those on State FTEs or in major service areas,
retiring or separating as of June 30th.
2. APU a. List APUs that will change and corresponding scale. (Type NONE if not going
higher or lower.) b. For any new APU being recommended for the budget year, provide a definition of
the APU and the scale desired. Include a statement regarding faculty input on the APU recommendation and scale. Provide a separate letter to Dr. Jonathan Hiatt and Judith Rothman on the new APU and/or scale change requested. Follow the procedures above for transferring the document electronically, by selecting “APU Request” type.
3. Salary Negotiations
a. Describe the Department’s general approach to faculty salary negotiations and usage of individual or group productivity data or standards.
b. List individuals or identified groups and specify the overall target or range of increases. c. List individuals or identified groups and specify the overall target or range of decreases. d. List the individuals or groups above the target and provide an explanation for the variance. e. List the individuals or groups below the target and provide an explanation for the variance. f. Provide justifications and/or explanations in the specific separate section provided in
the form template for any differences shown in negotiation of salaries at rank and step by gender. Explanations are to be provided on how each individual faculty member is empowered to negotiate his/her salary with the Chair or the Chair’s designee. When there is a disparity, a copy is to be provided of the written or e-mail correspondence to and from the lower paid faculty member indicating that opportunities for additional income have been discussed and the proposed salary has been communicated to and accepted by the person.
Save the file in C:\All Funds Budget\your file name or another directory. If you have more than one department, then specify different names for each department. Go to the budget program. If the file was saved in C\All Funds Budget\, the file will appear in the right box. If the file was saved in a different directory, the directory can be accessed by pull down menu under “Select Your Drive.” The files will appear in the right box. After highlighting the file, it can be opened from the program. To send the file to the Dean’s Office – Close the file in Word. Click on “Faculty Information-Clin. (FacCl)” or “Faculty Information-Bas. Sc. (FacBS),” select the drive that the file was saved in and click on the file name under “Select Your Writeup File” and click on “Send the Selected File to DO.” A message stating that the file was sent should appear. Each file sent will appear in the “Writeups Already Sent” box.
(H-7)
DEPARTMENT OF Salary Adjustment Instructions – MCP
Fiscal Year 2016-17
Check the appropriate box to indicate the Department's preference in handling salaries should the actual Fiscal Year Regular Salary Scale (Scale 0) and the corresponding Scales 1-9 differ from the estimated ones used for budget projections. ALL BASE SALARIES (X & X PRIME) WILL BE UPDATED FOR THE SCALE RATES (SCALES 0-9) AS APPROVED FOR THE ACADEMIC PROGRAMMATIC UNITS (APUs) FOR ELIGIBLE APPOINTEES ONLY. (Note: All salaries will be rounded to the nearest hundred dollars.)
METHOD #1: NEGOTIATED ADDITIONAL COMPENSATION (Y) FIRM When the Fiscal Year Scale 0 Base Salaries (“X”) and the corresponding Scales 1-9 Base Increments (“X-
prime”) are known, the negotiated additional compensation ( Y) should remain as shown in this budget as the NEGOTIATED ADDITIONAL COMPENSATION RATE and the total negotiated salary (X+Y) rate be adjusted as needed.
METHOD #2: TOTAL NEGOTIATED SALARY (X+Y) FIRM
When the Fiscal Year Scale 0 Base Salaries (“X”) and the corresponding Scales 1-9 Base Increments (“X-prime”) are known, the total negotiated salary (X+Y) should remain as shown in this budget as the TOTAL NEGOTIATED SALARY RATE and the negotiated additional compensation (Y) be adjusted as needed.
Individual exceptions to above instructions are listed below. Specify Method 1, Method 2, or UCLA PAY FIRM and Names
Signed: _______________________________________________ Chair
(H-8)
DEPARTMENT OF Issue or Topics Affecting Individual or Groups of Faculty – MCP
Fiscal Year 2016-17
General Description of Faculty Describe strategic new positions or services to the compensation plan.
List strategic faculty members retiring or separating as of June 30th.
Academic Programmatic Units (APUs) List each of the Department’s APUs that will change to the next higher or next lower scale. If there are no changes, please type NONE.
For any new APU being recommended for the budget year, provide a definition of the APU and the scale desired. Include a statement regarding faculty input on the APU recommendation and scale.
Salary Negotiations Describe the Department’s general approach to faculty salary negotiations and usage of individual or group productivity data or standards.
List individuals or identified groups and specify the overall target or range of increases.
List individuals or identified groups and specify the overall target or range of decreases.
List the individuals or groups below the target and provide an explanation for the variance
(H-9)
DEPARTMENT OF Salary Adjustment Instructions – MCP
Fiscal Year 2016-17
Provide justification and/or explanation if analysis of salaries by gender at rank and step shows male/female differences. Explanations are to be provided on how each individual faculty member is empowered to negotiate his/her salary with the Chair or the Chair’s designee. When there is a disparity, a copy is to be provided of the written or e-mail correspondence to and from the lower paid faculty member indicating that opportunities for additional income have been discussed and the proposed salary has been communicated to and accepted by the person.
(H-10)
DEPARTMENT OF Salary Adjustment Instructions – BSCP
Fiscal Year 2016-17
Check the appropriate box to indicate the Department's preference in handling salaries should the actual Fiscal Year Regular Salary Scale (Scale 0) and the corresponding Scales 1-9 differ from the estimated ones used for budget projections. ALL BASE SALARIES (X & X-PRIME) WILL BE UPDATED FOR THE SCALE RATES (SCALES 0-9) AS APPROVED FOR THE ACADEMIC PROGRAMMATIC UNITS (APUs) FOR ELIGIBLE APPOINTEES ONLY. (Note: all salaries will be rounded to the nearest hundred dollars.)
METHOD #1: NEGOTIATED ADDITIONAL COMPENSATION (Y) FIRM When the Fiscal Year Scale 0 Base Salaries (“X”) and the corresponding Scales 1-9 Base Increments (“X-
prime”) are known, the negotiated additional compensation ( Y) should remain as shown in this budget as the NEGOTIATED ADDITIONAL COMPENSATION RATE and the total negotiated salary (X+Y) rate be adjusted as needed.
METHOD #2: TOTAL NEGOTIATED SALARY (X+Y) FIRM
When the Fiscal Year Scale 0 Base Salaries (“X”) and the corresponding Scales 1-9 Base Increments (“X-prime”) are known, the total negotiated salary (X+Y) should remain as shown in this budget as the TOTAL NEGOTIATED SALARY RATE and the negotiated additional compensation (Y) be adjusted as needed.
Individual exceptions to above instructions are listed below. Specify Method 1, Method 2, or UCLA PAY FIRM and Names
Signed: _______________________________________________ Chair
(H-11)
DEPARTMENT OF Issue or Topics Affecting Individual or Groups of Faculty – BSCP
Fiscal Year 2016-17
General Description of Faculty Describe strategic new positions or services to the compensation plan.
List strategic faculty members retiring or separating as of June 30th.
Academic Programmatic Units (APUs) List the Department’s APUs that will change to the next higher or next lower scale. List each APU separately with its corresponding scale. (If there are no changes, please type NONE.)
For any new APU being recommended for the budget year, provide a definition of the APU and the scale desired. Include a statement regarding faculty input on the APU recommendation and scale.
Salary Negotiations Describe the Department’s general approach to faculty salary negotiations and usage of individual or group productivity data or standards.
List individuals or identified groups and specify the overall target or range of increases.
List individuals or identified groups and specify the overall target or range of decreases.
List the individuals or groups below the target and provide an explanation for the variance
(H-12)
DEPARTMENT OF Issue or Topics Affecting Individual or Groups of Faculty – BSCP
Fiscal Year 2016-17
Provide justification and/or explanation if analysis of salaries by gender at rank and step shows male/female differences. Explanations are to be provided on how each individual faculty member is empowered to negotiate his/her salary with the Chair or the Chair’s designee. When there is a disparity, a copy is to be provided of the written or e-mail correspondence to and from the lower paid faculty member indicating that opportunities for additional income have been discussed and the proposed salary has been communicated to and accepted by the person.
(I-1)
STATUS TAB This tab reflects important dates associated with the submission and finalization of a department’s budget package and will be updated if there are changes. It also has a mechanism for each department to inform the Dean’s Office that they have completed their budgets.
The rows that are highlighted in red require an eventual action by a department. Those rows highlighted in blue contain information on other steps in the budget process important to every department. When you have finished the work on inputting your Plan faculty information, click on “Dept PF TNS budget completed (FPM)”. A message will pop-up stating that “This operation will lock Plan Faculty and it cannot be reversed. Would you like to continue?” You’re given the choices of “yes,” or “no.” Click “yes” and it will notify the Dean’s Office that you are done with this step in the budget process. When you have finished your budget, click on “Dept budget & projection completed (AFB)”. A message will pop-up stating that “This operation will lock the Budget and it cannot be reversed. Would you like to continue?” You’re given the choices of “yes” or “no.” Click “yes” and it will notify the Dean’s Office that you’re now done with this this step in the budget process. The four locks under the fiscal year date above and to the right of the Status tab indicates whether the budget is unlocked (green) and you can update, or locked (red) and you are unable to update. If you have locked the budget inadvertently, contact the Dean’s Office Fiscal Reviewer to get the budget unlocked. Even when the budget is locked (the first lock on the left) you may view data, export to excel, print reports, and send attachments through the Writeups tab. The second lock is the “Plan Faculty lock” which is for Plan Faculty. As of the close of business on February 26, 2016, the Dean’s Office will lock the Plan Faculty. However, we have allowed flexibility in that the Plan Faculty may be unlocked for further updating transmissions from FPM while the rest of the budget is locked from departmental input. Contact the Dean’s Office Academic Reviewer for unlocking the Plan Faculty. The third lock is the “DO Support lock” which affects data entry under the DO (Dean’s Office) Support Tab. The Dean’s Office opens this lock for a set period of time (11-2-15 through 12-11-15) to allow each department to input Department Support requests. By the close of business on December 11, the Dean’s Office will lock the DO Support Tab allowing for no further department input.
2016-17
Locked/ Unlocked to Dept
(I-2)
The fourth lock is the “HS Support lock” which affects the data entry under the HS (Health System) Support Tab. With the Dean’s Office inputting all continuing HS support by December 1and any approved new/increase/extension requests by February 9, the HS Support tab now remains locked to School’s departments throughout the entire budget cycle. Upon the issuance by the Dean’s Office of a formal request for budgetary changes, the budget will be unlocked for update by the department. When those changes are completed, click on the row indicated with “Final changes completed by dept”. A message will pop-up stating “This operation will lock the Budget and Plan Faculty and it cannot be reversed. Would you like to continue?” You’re given the choices of “yes” or “no.” Click “yes” and it will notify the Dean’s Office that you are done. After the final changes have been completed by your department and the status bar marked, forward a list of those changes to the Dean’s Office Fiscal Reviewer.
POLICY REFERENCE LIST
(J-1)
POLICY REFERENCES UCLA Financial Policy
Web address: http://www.policies.ucla.edu/businessfinance.htm Principles of Financial Management-Policy, Principles, Responsibilities
Campus Budget Information Gateway (C-BIG) - UCLA Office of Academic Planning & Budget
Web address: http://www.apb.ucla.edu/cbig.aspx NIH Salary Cap Limits Summary
Web address: http://grants1.nih.gov/grants/policy/policy.htm Under Policy Resources, select Salary Cap Summary
UC Academic Personnel Manual & Scales
Web address: http://www.ucop.edu/academic-personnel/academic-personnel-policy/index.html Select section of Academic Personnel Manual Desired
Web address: http://www.ucop.edu/academic-personnel/compensation/index.html
Select Academic Salary Scales. Latest period is July 1, 2015 Historic scales are also available.
Regents' Compensation Plan
Web address: http://www.ucop.edu/academic-personnel/_files/apm/apm-670.pdf APM 670-Health Sciences Compensation, July 2012; Appendix A-Philosophy Appendix B Guidelines on Occasional Outside Professional Activities by Health Sciences
Compensation Plan Participants, July 2012. Appendix C- Campus Accounting & Budgeting Methods
Web address: http://www.ucop.edu/academic-personnel-programs/_files/apm/apm-671.pdf APM 671-Health Sciences Compensation, July 2015, Appendixes A, B, C, & D
UCLA School of Medicine Implementation Procedures under the UC Health Sciences
Web address: http://www.deans.medsch.ucla.edu/academic/SOM%20implementing%20procedures%203-5-14.pdf
Compensation Plan, effective July 1, 2012. New draft implementation procedures for APM 671 are currently under review.
Department's Compensation Plan Bylaws/Procedures/Rules or Regulations
Contact your department administration on compensation plans.
UCLA Campus Human Resources Web address: https://www.chr.ucla.edu/hr-administration
1) "Policies & Labor Contracts" 2) "HR Administration" -Compensation & Classification 3) Go to Title & Pay Plan for salary ranges
UC Accounting Manual Chapters
Web address: http://policy.ucop.edu/manuals/accounting-manual.html D-371-12.1, Disbursements: Accounting for and Tax Reporting of Payments
Made Through the Vendor System (look under TAXES) H-214-7, Heatlh Care Services: Professional Fees H-214-75, Health Sciences Compensation Plans P-196-11, Payroll: Accounting For and Tax Reporting of Mandatory
Deductions and Insurance Benefit Contributions P-196-37, Payroll: Health Sciences Compensation
ROW CATEGORIES & MAPPING
(J-2)
Davi
d Ge
ffen
Scho
ol o
f Med
icin
e at
UCL
ARe
port
Row
Des
crip
tions
/Cat
egor
ies
SORT
O
RDER
AFCP
L CO
DELe
vel 3
Leve
l 2Le
vel 1
Reve
nue
1A1
10N
et P
atie
nt C
are
Rev
enue
Net
Pat
ient
Car
e R
even
ue
Net
Pat
ient
Car
e &
MAP
Fac
ility
Rev
.
2A1
20N
et P
atie
nt C
are
- Rec
harg
esN
et P
atie
nt C
are
Rev
enue
N
et P
atie
nt C
are
& M
AP F
acili
ty R
ev.
3A1
30N
et P
atie
nt C
are
- Rec
harg
es -
Clin
. Tr.
Net
Pat
ient
Car
e R
even
ue
Net
Pat
ient
Car
e &
MAP
Fac
ility
Rev
.
4A1
40M
ap F
acili
ty R
even
ueM
AP F
acili
ty R
even
ueN
et P
atie
nt C
are
& M
AP F
acili
ty R
ev.
5A1
50O
ther
Com
p. P
lan
Rev
enue
O
ther
Com
p. P
lan
Rev
enue
O
ther
Com
p. P
lan
Rev
enue
6A1
55Al
l C &
G R
even
ueAl
l C &
G R
even
ueAl
l C &
G R
even
ue7
A160
NIH
C&
G R
even
ueN
IH C
&G
Rev
enue
N
IH C
&G
Rev
enue
8
A170
Oth
er F
eder
al C
&G
Rev
enue
Oth
er F
eder
al C
&G
Rev
enue
Oth
er C
&G
Rev
enue
9A1
80C
linic
al T
rials
C&
G R
even
ueO
ther
C&
G R
even
ueO
ther
C&
G R
even
ue10
A190
Priv
ate
C&
G R
even
ueO
ther
C&
G R
even
ueO
ther
C&
G R
even
ue11
A200
Loca
l C&
G R
even
ueO
ther
C&
G R
even
ueO
ther
C&
G R
even
ue12
A210
Sta
te C
&G
Rev
enue
Oth
er C
&G
Rev
enue
Oth
er C
&G
Rev
enue
13A2
20C
NG
Rev
enue
Adj
ustm
ent (
Inc/
Dec
r)O
ther
C&
G R
even
ueO
ther
C&
G R
even
ue
14A2
30S
ales
& S
ervi
ce R
even
ueS
ales
& S
ervi
ce R
even
ue
Sal
es &
Ser
vice
Rev
enue
15A2
40G
ift R
even
ueG
ifts
& E
ndow
men
ts R
even
ueG
ifts
& E
ndow
men
ts R
even
ue16
A250
GFT
Rev
enue
(Inc
/Dec
r) b
y G
FT T
rans
fers
Gift
s &
End
owm
ents
Rev
enue
Gift
s &
End
owm
ents
Rev
enue
17A2
60G
FT R
even
ue (I
nc/D
ecr)
by
STI
PG
ifts
& E
ndow
men
ts R
even
ueG
ifts
& E
ndow
men
ts R
even
ue18
A270
End
owm
ent R
even
ueG
ifts
& E
ndow
men
ts R
even
ueG
ifts
& E
ndow
men
ts R
even
ue19
A280
EN
D R
even
ue (I
nc/D
ecr)
by
EN
D T
rans
fers
Gift
s &
End
owm
ents
Rev
enue
Gift
s &
End
owm
ents
Rev
enue
20A2
90E
ND
Rev
enue
(Inc
/Dec
r) b
y S
TIP
Gift
s &
End
owm
ents
Rev
enue
Gift
s &
End
owm
ents
Rev
enue
21A3
00In
dire
ct C
ost R
ecov
ery
Rev
enue
Indi
rect
Cos
t Rec
over
y R
even
ueIn
dire
ct C
ost R
ecov
ery
Rev
enue
22A3
20S
tate
App
ropr
iatio
n R
even
ueS
tate
App
ropr
iatio
nsS
tate
App
ropr
iatio
ns23
A310
Sup
plem
enta
l Tui
tion
(PD
ST)
Sup
plem
enta
l Tui
tion
(PD
ST)
Sup
plem
enta
l Tui
tion
(PD
ST)
24A3
15O
ther
UC
App
ropr
iatio
n R
even
ueO
ther
UC
App
ropr
iatio
n R
even
ueO
ther
UC
App
ropr
iatio
n R
even
ue
(J-3)
Dav
id G
effe
n S
choo
l of M
edic
ine
at U
CLA
Rep
ort R
ow D
escr
iptio
ns/C
ateg
orie
s
SO
RT
OR
DER
AFC
PL
CO
DE
Leve
l 3Le
vel 2
Leve
l 12
5A
33
0F
PG
Re
cha
rge
sF
PG
Re
cha
rge
s
FP
G R
ech
arg
es
26
A3
40
Dir
ect
ors
hip
sM
ed
ica
l Ce
nte
r R
ech
arg
es
/Tra
ns
feM
ed
ica
l Ce
nte
r R
ech
arg
es
/Tra
ns
fers
27
A3
50
Me
dic
al C
en
ter
Tra
ns
fers
Me
dic
al C
en
ter
Re
cha
rge
s/T
ran
sfe
Me
dic
al C
en
ter
Re
cha
rge
s/T
ran
sfe
rs
28
A4
40
Su
pp
ort
fro
m D
ea
n's
Offi
ce (
Re
v. S
ide
)S
up
po
rt fr
om
De
an
's O
ffice
S
up
po
rt fr
om
De
an
's O
ffice
2
9A
43
0S
up
po
rt fr
om
De
an
's O
ffice
(E
xp. S
ide
)S
up
po
rt fr
om
De
an
's O
ffice
S
up
po
rt fr
om
De
an
's O
ffice
30
A3
60
Mis
c. R
ech
arg
es
- C
om
p. P
lan
Se
rvic
eM
isc.
& C
om
p. P
lan
Re
cha
rge
sM
isc.
& In
terf
un
d R
ech
arg
es
/ Trs
fs
31
A3
70
Mis
c. R
ech
arg
es
Mis
c. &
Co
mp
. Pla
n R
ech
arg
es
Mis
c. &
Inte
rfu
nd
Re
cha
rge
s/ T
rsfs
32
A3
90
Inte
rfu
nd
Tra
ns
fers
Inte
rna
l (R
ev.
Sid
e)
Inte
rfu
nd
Tra
ns
fers
Mis
c. &
Inte
rfu
nd
Re
cha
rge
s/ T
rsfs
33
A3
80
Inte
rfu
nd
Tra
ns
fers
Inte
rna
l (E
xp. S
ide
)In
terf
un
d T
ran
sfe
rsM
isc.
& In
terf
un
d R
ech
arg
es
/ Trs
fs3
4A
41
0In
terf
un
d T
ran
sfe
rs E
xte
rna
l (R
ev.
Sid
e)
Inte
rfu
nd
Tra
ns
fers
Mis
c. &
Inte
rfu
nd
Re
cha
rge
s/ T
rsfs
35
A4
00
Inte
rfu
nd
Tra
ns
fers
Ext
ern
al (
Exp
. Sid
e)
Inte
rfu
nd
Tra
ns
fers
Mis
c. &
Inte
rfu
nd
Re
cha
rge
s/ T
rsfs
36
A4
20
Inte
res
t ST
IP
In
tere
st S
TIP
Inte
res
t ST
IP
37
A4
50
De
an
's T
ax
(Exp
. Sid
e)
De
an
's T
ax
De
an
's T
ax
38
A4
60
De
an
's T
ax
(Re
v. S
ide
)D
ea
n's
Ta
xD
ea
n's
Ta
x3
9A
47
0D
ea
n's
Ta
x T
rue
-Up
(E
xp S
ide
)D
ea
n's
Ta
x T
rue
-Up
De
an
's T
ax
40
A4
80
De
an
's T
ax
Tru
e-U
p (
Re
v S
ide
)D
ea
n's
Ta
x T
rue
-Up
De
an
's T
ax
Expe
nses
41
A5
10
Fa
culty
La
dd
er
Fa
culty
Sa
lari
es
Fa
culty
Sa
lari
es
42
A5
20
Fa
culty
Te
mp
ora
ry
Fa
culty
Sa
lari
es
Fa
culty
Sa
lari
es
43
A5
30
Sta
ff P
hys
icia
n S
ala
rie
s
Sta
ff P
hys
icia
n S
ala
rie
s
Sta
ff P
hys
icia
n S
ala
rie
s
44
A5
40
Sta
ff S
ala
rie
sS
taff
Sa
lari
es
Sta
ff &
No
n-F
acu
lty S
ala
rie
s4
5A
55
0A
cad
em
ic O
the
r S
ala
rie
sA
cad
em
ic O
the
r S
ala
rie
sS
taff
& N
on
-Fa
culty
Sa
lari
es
46
A5
60
Aca
de
mic
Ap
pre
ntic
e S
ala
rie
sA
cad
em
ic O
the
r S
ala
rie
sS
taff
& N
on
-Fa
culty
Sa
lari
es
47
A5
70
Inte
rns
an
d R
es
ide
nts
Sa
lari
es
Inte
rns
an
d R
es
ide
nts
Sa
lari
es
Inte
rns
an
d R
es
ide
nts
Sa
lari
es
48
A5
80
Be
ne
fits
Be
ne
fits
Be
ne
fits
(J-4)
Davi
d Ge
ffen
Scho
ol o
f Med
icin
e at
UCL
ARe
port
Row
Des
crip
tions
/Cat
egor
ies
SORT
O
RDER
AFCP
L CO
DELe
vel 3
Leve
l 2Le
vel 1
49A5
90S
ubco
ntra
cted
Ser
vice
s
Sub
cont
ract
ed S
ervi
ces
Pro
fess
iona
l & P
urch
ased
Ser
vice
s
50A6
00C
ompu
ting
Ser
vice
sC
ompu
ting
Ser
vice
sP
rofe
ssio
nal &
Pur
chas
ed S
ervi
ces
51A6
20Te
mpo
rary
Per
sonn
el S
ervi
ces
Pro
fess
iona
l/Res
earc
h S
ervi
ces
Pro
fess
iona
l & P
urch
ased
Ser
vice
s
52A6
30C
onsu
ltant
sP
rofe
ssio
nal/R
esea
rch
Ser
vice
sP
rofe
ssio
nal &
Pur
chas
ed S
ervi
ces
53A6
40P
rofe
ssio
nal S
ervi
ces
- Oth
erP
rofe
ssio
nal/R
esea
rch
Ser
vice
sP
rofe
ssio
nal &
Pur
chas
ed S
ervi
ces
54A6
50D
LAM
Gen
eral
Ser
vice
sP
rofe
ssio
nal &
Pur
chas
ed S
ervi
ces
55A6
60P
atie
nt C
are
Exp
ense
Gen
eral
Ser
vice
sP
rofe
ssio
nal &
Pur
chas
ed S
ervi
ces
56A6
70P
rintin
g &
Cop
ying
Gen
eral
Ser
vice
sP
rofe
ssio
nal &
Pur
chas
ed S
ervi
ces
57A6
80S
ervi
ces
- Oth
erG
ener
al S
ervi
ces
Pro
fess
iona
l & P
urch
ased
Ser
vice
s
58A6
90R
epai
rs &
Mai
nt. -
Equ
ipm
ent (
Non
Com
pute
r)R
epai
rs &
Mai
nt. -
Equ
ipm
ent (
Non
Com
pute
r)P
rofe
ssio
nal &
Pur
chas
ed S
ervi
ces
59A7
00E
nter
tain
men
t
E
nter
tain
men
t
P
rofe
ssio
nal &
Pur
chas
ed S
ervi
ces
60A7
10Tr
avel
Trav
elP
rofe
ssio
nal &
Pur
chas
ed S
ervi
ces
61A7
20Fa
cilit
yFa
cilit
yP
rofe
ssio
nal &
Pur
chas
ed S
ervi
ces
62A7
40M
ater
ial a
nd S
uppl
ies
- Sci
entif
ic
M
ater
ial a
nd S
uppl
ies
- Sci
entif
ic
M
ater
ial a
nd S
uppl
ies
- Sci
entif
ic
63
A730
Mat
eria
l and
Sup
plie
s - G
ener
al
Mat
eria
l and
Sup
plie
s - G
ener
al
Mat
eria
l and
Sup
plie
s - G
ener
al
64A7
50E
quip
men
t (C
ompu
ter)
E
quip
men
t/Dep
reci
atio
nE
quip
men
t/Dep
reci
atio
n65
A760
Equ
ipm
ent (
Non
Com
pute
r)
Equ
ipm
ent/D
epre
ciat
ion
Equ
ipm
ent/D
epre
ciat
ion
66A7
80M
alpr
actic
e In
sura
nce
Mal
prac
tice
Insu
ranc
e
M
alpr
actic
e In
sura
nce
67A7
90Te
leph
one
Com
mun
icat
ions
Com
mun
icat
ions
68A8
00M
ail &
Mes
seng
erC
omm
unic
atio
nsC
omm
unic
atio
ns69
A830
Spa
ce R
enta
lS
pace
Ren
tal
Spa
ce R
enta
l
70A7
70In
sura
nce
Insu
ranc
e
O
ther
Exp
ense
71A8
10Fi
nanc
ial A
idFi
nanc
ial A
idO
ther
Exp
ense
72A8
20Fe
e R
emis
sion
s
Fi
nanc
ial A
idO
ther
Exp
ense
73A8
40O
ther
Exp
ense
Oth
er E
xpen
seO
ther
Exp
ense
74A9
00O
ther
Tra
nsfe
rs In
/(Out
)
O
ther
Tra
nsfe
rs In
/(Out
)
O
ther
Tra
nsfe
rs In
/(Out
)
75
A905
Exp
ense
Tra
nsfe
rs In
/(Out
)O
ther
Tra
nsfe
rs In
/(Out
)
O
ther
Tra
nsfe
rs In
/(Out
)
76
A910
Prio
r Yea
r Car
ry F
orw
ard
P
rior Y
ear C
arry
For
war
d
Prio
r Yea
r Car
ry F
orw
ard
A999
UN
CLA
SS
IFIE
D O
BJE
CT
CO
DE
UN
CLA
SS
IFIE
D O
BJE
CT
CO
DE
AA9H
F &
AF
& A
PLAN TITLE CODES, SCALES, & TABLES
(J-5)
TITLE CODES FOR SCHOOL OF MEDICINE COMPENSATION PLAN FACULTY FOR 2016-2017
TITLE/SERIES
HS COMP EFFECTIVE 7/1/2012
BUDGET ROW CATEGORY
REGULAR ASST PROFESSOR REGULAR ASSOC PROFESSOR REGULAR PROFESSOR
1717 1719 1721
FLAD FLAD FLAD
RECALL HCOMP
1701
FTEM
ASST PROF IN RSDN ASSOC PROF IN RSDN PROF IN RSDN
1724 1725 1726
FTEM FTEM FTEM
ADJ INSTRUCTOR ADJ ASST PROFESSOR ADJ ASSOC PROFESSOR ADJ PROFESSOR
1727 1728 1729 1730
FTEM FTEM FTEM FTEM
HS CLIN INSTRUCTOR HS ASST CLIN PROFESSOR HS ASSOC CLIN PROFESSOR HS CLIN PROFESSOR
1731 1732 1733 1734
FTEM FTEM FTEM FTEM
ASST PROF OF CLIN X ASSOC PROF OF CLIN X PROF OF CLIN X
1455 1454 1453
FTEM FTEM FTEM
VST ASST PROFESSOR VST ASSOC PROFESSOR VST PROFESSOR
1712 1713 1714
FTEM FTEM FTEM
FLAD = Faculty Ladder FTEM = Faculty Temporary
SCHOOL OF MEDICINE MEDCOMP SCALE 0AS OF JULY 2015 & CONTINUING
FactorBase/FY 11 Month Total Scale "0" To FY
Rank/Step Annual Monthly Annual Monthly Annual Monthly 11 Month
Instructor 58,500 4,875.00 00 0.00 58,500 4,875.00 0.0000
Assistant Professor I 67,800 5,650.00 00 0.00 67,800 5,650.00 0.0000Assistant Professor II 71,900 5,991.67 00 0.00 71,900 5,991.67 0.0000Assistant Professor III 75,800 6,316.67 00 0.00 75,800 6,316.67 0.0000Assistant Professor IV 80,200 6,683.33 00 0.00 80,200 6,683.33 0.0000
Associate Professor I 84,200 7,016.67 00 0.00 84,200 7,016.67 0.0000Associate Professor II 88,300 7,358.33 00 0.00 88,300 7,358.33 0.0000Associate Professor III 93,200 7,766.67 00 0.00 93,200 7,766.67 0.0000Associate Professor IV 99,000 8,250.00 00 0.00 99,000 8,250.00 0.0000Associate Professor V 106,700 8,891.67 00 0.00 106,700 8,891.67 0.0000
Professor I 99,100 8,258.33 00 0.00 99,100 8,258.33 0.0000Professor II 106,800 8,900.00 00 0.00 106,800 8,900.00 0.0000Professor III 114,500 9,541.67 00 0.00 114,500 9,541.67 0.0000Professor IV 122,800 10,233.33 00 0.00 122,800 10,233.33 0.0000Professor V 131,600 10,966.67 00 0.00 131,600 10,966.67 0.0000Professor VI 142,500 11,875.00 00 0.00 142,500 11,875.00 0.0000Professor VII 154,200 12,850.00 00 0.00 154,200 12,850.00 0.0000Professor VIII 167,000 13,916.67 00 0.00 167,000 13,916.67 0.0000Professor IX 180,900 15,075.00 00 0.00 180,900 15,075.00 0.0000
Professor A/S 0.0000
dsn:scale0
(J-6)
Add'l Retirement Incr.
SCHOOL OF MEDICINE MEDCOMP SCALE 1AS OF JULY 2015 & CONTINUING
FactorBase/FY 11 Month Total Scale "1" To FY
Rank/Step Annual Monthly Annual Monthly Annual Monthly 11 Month
Instructor 58,500 4,875.00 5,900 491.67 64,400 5,366.67 0.1000
Assistant Professor I 67,800 5,650.00 6,800 566.67 74,600 6,216.67 0.1000Assistant Professor II 71,900 5,991.67 7,200 600.00 79,100 6,591.67 0.1000Assistant Professor III 75,800 6,316.67 7,600 633.33 83,400 6,950.00 0.1000Assistant Professor IV 80,200 6,683.33 8,000 666.67 88,200 7,350.00 0.1000
Associate Professor I 84,200 7,016.67 8,400 700.00 92,600 7,716.67 0.1000Associate Professor II 88,300 7,358.33 8,800 733.34 97,100 8,091.67 0.1000Associate Professor III 93,200 7,766.67 9,300 775.00 102,500 8,541.67 0.1000Associate Professor IV 99,000 8,250.00 9,900 825.00 108,900 9,075.00 0.1000Associate Professor V 106,700 8,891.67 10,700 891.66 117,400 9,783.33 0.1000
Professor I 99,100 8,258.33 9,900 825.00 109,000 9,083.33 0.1000Professor II 106,800 8,900.00 10,700 891.67 117,500 9,791.67 0.1000Professor III 114,500 9,541.67 11,500 958.33 126,000 10,500.00 0.1000Professor IV 122,800 10,233.33 12,300 1,025.00 135,100 11,258.33 0.1000Professor V 131,600 10,966.67 13,200 1,100.00 144,800 12,066.67 0.1000Professor VI 142,500 11,875.00 14,300 1,191.67 156,800 13,066.67 0.1000Professor VII 154,200 12,850.00 15,400 1,283.33 169,600 14,133.33 0.1000Professor VIII 167,000 13,916.67 16,700 1,391.66 183,700 15,308.33 0.1000Professor IX 180,900 15,075.00 18,100 1,508.33 199,000 16,583.33 0.1000
Professor A/S 0.1000dsn:scale1
(J-7)
Add'l Retirement Incr.
SCHOOL OF MEDICINE MEDCOMP SCALE 2AS OF JULY 2015 & CONTINUING
FactorBase/FY 11 Month Total Scale "2" To FY
Rank/Step Annual Monthly Annual Monthly Annual Monthly 11 Month
Instructor 58,500 4,875.00 11,700 975.00 70,200 5,850.00 0.2000
Assistant Professor I 67,800 5,650.00 13,600 1,133.33 81,400 6,783.33 0.2000Assistant Professor II 71,900 5,991.67 14,400 1,200.00 86,300 7,191.67 0.2000Assistant Professor III 75,800 6,316.67 15,200 1,266.66 91,000 7,583.33 0.2000Assistant Professor IV 80,200 6,683.33 16,000 1,333.34 96,200 8,016.67 0.2000
Associate Professor I 84,200 7,016.67 16,800 1,400.00 101,000 8,416.67 0.2000Associate Professor II 88,300 7,358.33 17,700 1,475.00 106,000 8,833.33 0.2000Associate Professor III 93,200 7,766.67 18,600 1,550.00 111,800 9,316.67 0.2000Associate Professor IV 99,000 8,250.00 19,800 1,650.00 118,800 9,900.00 0.2000Associate Professor V 106,700 8,891.67 21,300 1,775.00 128,000 10,666.67 0.2000
Professor I 99,100 8,258.33 19,800 1,650.00 118,900 9,908.33 0.2000Professor II 106,800 8,900.00 21,400 1,783.33 128,200 10,683.33 0.2000Professor III 114,500 9,541.67 22,900 1,908.33 137,400 11,450.00 0.2000Professor IV 122,800 10,233.33 24,600 2,050.00 147,400 12,283.33 0.2000Professor V 131,600 10,966.67 26,300 2,191.66 157,900 13,158.33 0.2000Professor VI 142,500 11,875.00 28,500 2,375.00 171,000 14,250.00 0.2000Professor VII 154,200 12,850.00 30,800 2,566.67 185,000 15,416.67 0.2000Professor VIII 167,000 13,916.67 33,400 2,783.33 200,400 16,700.00 0.2000Professor IX 180,900 15,075.00 36,200 3,016.67 217,100 18,091.67 0.2000
Professor A/S 0.2000
dsn:scale2
(J-8)
Add'l Retirement Incr.
SCHOOL OF MEDICINE MEDCOMP SCALE 3AS OF JULY 2015 & CONTINUING
FactorBase/FY 11 Month Total Scale "3" To FY
Rank/Step Annual Monthly Annual Monthly Annual Monthly 11 Month
Instructor 58,500 4,875.00 17,600 1,466.67 76,100 6,341.67 0.3000
Assistant Professor I 67,800 5,650.00 20,300 1,691.67 88,100 7,341.67 0.3000Assistant Professor II 71,900 5,991.67 21,600 1,800.00 93,500 7,791.67 0.3000Assistant Professor III 75,800 6,316.67 22,700 1,891.66 98,500 8,208.33 0.3000Assistant Professor IV 80,200 6,683.33 24,100 2,008.34 104,300 8,691.67 0.3000
Associate Professor I 84,200 7,016.67 25,300 2,108.33 109,500 9,125.00 0.3000Associate Professor II 88,300 7,358.33 26,500 2,208.34 114,800 9,566.67 0.3000Associate Professor III 93,200 7,766.67 28,000 2,333.33 121,200 10,100.00 0.3000Associate Professor IV 99,000 8,250.00 29,700 2,475.00 128,700 10,725.00 0.3000Associate Professor V 106,700 8,891.67 32,000 2,666.66 138,700 11,558.33 0.3000
Professor I 99,100 8,258.33 29,700 2,475.00 128,800 10,733.33 0.3000Professor II 106,800 8,900.00 32,000 2,666.67 138,800 11,566.67 0.3000Professor III 114,500 9,541.67 34,400 2,866.66 148,900 12,408.33 0.3000Professor IV 122,800 10,233.33 36,800 3,066.67 159,600 13,300.00 0.3000Professor V 131,600 10,966.67 39,500 3,291.66 171,100 14,258.33 0.3000Professor VI 142,500 11,875.00 42,800 3,566.67 185,300 15,441.67 0.3000Professor VII 154,200 12,850.00 46,300 3,858.33 200,500 16,708.33 0.3000Professor VIII 167,000 13,916.67 50,100 4,175.00 217,100 18,091.67 0.3000Professor IX 180,900 15,075.00 54,300 4,525.00 235,200 19,600.00 0.3000
Professor A/S 0.3000
dsn:scale3
Add'l Retirement Incr.
(J-9)
SCHOOL OF MEDICINE MEDCOMP SCALE 4AS OF JULY 2015 & CONTINUING
Factor Add'l Retirement Increment
Base/FY 11 Month to Scale 3 Diff. in Scales 4 & 3 Total Scale "4" To FYRank/Step Annual Monthly Annual Monthly Annual Monthly Annual Monthly 11 Month
Instructor 58,500 4,875.00 17,600 1,366.66 5,800 583.34 81,900 6,825.00 0.4000
Assistant Prof I 67,800 5,650.00 20,300 1,591.67 6,800 666.66 94,900 7,908.33 0.4000Assistant Prof II 71,900 5,991.67 21,600 1,683.33 7,200 716.67 100,700 8,391.67 0.4000Assistant Prof III 75,800 6,316.67 22,700 1,775.00 7,600 750.00 106,100 8,841.67 0.4000Assistant Prof IV 80,200 6,683.33 24,100 1,883.33 8,000 791.67 112,300 9,358.33 0.4000
Associate Prof I 84,200 7,016.67 25,300 1,975.00 8,400 833.33 117,900 9,825.00 0.4000Associate Prof II 88,300 7,358.33 26,500 2,066.67 8,800 875.00 123,600 10,300.00 0.4000Associate Prof III 93,200 7,766.67 28,000 2,183.34 9,300 924.99 130,500 10,875.00 0.4000Associate Prof IV 99,000 8,250.00 29,700 2,316.67 9,900 983.33 138,600 11,550.00 0.4000Associate Prof V 106,700 8,891.67 32,000 2,500.00 10,700 1,058.33 149,400 12,450.00 0.4000
Professor I 99,100 8,258.33 29,700 2,325.00 9,900 975.00 138,700 11,558.33 0.4000Professor II 106,800 8,900.00 32,000 2,500.00 10,700 1,058.33 149,500 12,458.33 0.4000Professor III 114,500 9,541.67 34,400 2,683.33 11,400 1,133.33 160,300 13,358.33 0.4000Professor IV 122,800 10,233.33 36,800 2,883.33 12,300 1,208.34 171,900 14,325.00 0.4000Professor V 131,600 10,966.67 39,500 3,083.34 13,100 1,299.99 184,200 15,350.00 0.4000Professor VI 142,500 11,875.00 42,800 3,341.67 14,200 1,408.33 199,500 16,625.00 0.4000Professor VII 154,200 12,850.00 46,300 3,616.67 15,400 1,525.00 215,900 17,991.67 0.4000Professor VIII 167,000 13,916.67 50,100 3,916.67 16,700 1,649.99 233,800 19,483.33 0.4000Professor IX 180,900 15,075.00 54,300 4,241.67 18,100 1,791.66 253,300 21,108.33 0.4000
Professor A/S 0.4000
(J-10)
SCHOOL OF MEDICINE MEDCOMP SCALE "5"AS OF JULY 2015 & CONTINUING
Factor Add'l Retirement Increment
Base/FY 11 Month to Scale 3 Diff. in Scales 5 & 3 Total Scale "5" To FYRank/Step Annual Monthly Annual Monthly Annual Monthly Annual Monthly 11 Month
Instructor 58,500 4,875.00 17,600 1,366.66 11,700 1,075.01 87,800 7,316.67 0.5000
Assistant Prof I 67,800 5,650.00 20,300 1,591.67 13,600 1,233.33 101,700 8,475.00 0.5000Assistant Prof II 71,900 5,991.67 21,600 1,683.33 14,400 1,316.67 107,900 8,991.67 0.5000Assistant Prof III 75,800 6,316.67 22,700 1,775.00 15,200 1,383.33 113,700 9,475.00 0.5000Assistant Prof IV 80,200 6,683.33 24,100 1,883.33 16,000 1,458.34 120,300 10,025.00 0.5000
Associate Prof I 84,200 7,016.67 25,300 1,975.00 16,800 1,533.33 126,300 10,525.00 0.5000Associate Prof II 88,300 7,358.33 26,500 2,066.67 17,700 1,616.67 132,500 11,041.67 0.5000Associate Prof III 93,200 7,766.67 28,000 2,183.34 18,600 1,699.99 139,800 11,650.00 0.5000Associate Prof IV 99,000 8,250.00 29,700 2,316.67 19,800 1,808.33 148,500 12,375.00 0.5000Associate Prof V 106,700 8,891.67 32,000 2,500.00 21,400 1,950.00 160,100 13,341.67 0.5000
Professor I 99,100 8,258.33 29,700 2,325.00 19,900 1,808.34 148,700 12,391.67 0.5000Professor II 106,800 8,900.00 32,000 2,500.00 21,400 1,950.00 160,200 13,350.00 0.5000Professor III 114,500 9,541.67 34,400 2,683.33 22,900 2,091.67 171,800 14,316.67 0.5000Professor IV 122,800 10,233.33 36,800 2,883.33 24,600 2,233.34 184,200 15,350.00 0.5000Professor V 131,600 10,966.67 39,500 3,083.34 26,300 2,399.99 197,400 16,450.00 0.5000Professor VI 142,500 11,875.00 42,800 3,341.67 28,500 2,600.00 213,800 17,816.67 0.5000Professor VII 154,200 12,850.00 46,300 3,616.67 30,800 2,808.33 231,300 19,275.00 0.5000Professor VIII 167,000 13,916.67 50,100 3,916.67 33,400 3,041.66 250,500 20,875.00 0.5000Professor IX 180,900 15,075.00 54,300 4,241.67 36,200 3,300.00 271,400 22,616.67 0.5000
Professor A/S 0.5000
(J-11)
SCHOOL OF MEDICINE MEDCOMP SCALE "6"AS OF JULY 2015 & CONTINUING
FactorBase/FY 11 Month to Scale 3 Diff. in Scales 6 & 3 Total Scale "6" To FY
Rank/Step Annual Monthly Annual Monthly Annual Monthly Annual Monthly 11 Month
Instructor 58,500 4,875.00 17,600 1,366.66 20,400 1,800.01 96,500 8,041.67 0.6500
Assistant Prof I 67,800 5,650.00 20,300 1,591.67 23,800 2,083.33 111,900 9,325.00 0.6500Assistant Prof II 71,900 5,991.67 21,600 1,683.33 25,100 2,208.33 118,600 9,883.33 0.6500Assistant Prof III 75,800 6,316.67 22,700 1,775.00 26,600 2,333.33 125,100 10,425.00 0.6500Assistant Prof IV 80,200 6,683.33 24,100 1,883.33 28,000 2,458.34 132,300 11,025.00 0.6500
Associate Prof I 84,200 7,016.67 25,300 1,975.00 29,400 2,583.33 138,900 11,575.00 0.6500Associate Prof II 88,300 7,358.33 26,500 2,066.67 30,900 2,716.67 145,700 12,141.67 0.6500Associate Prof III 93,200 7,766.67 28,000 2,183.34 32,600 2,866.66 153,800 12,816.67 0.6500Associate Prof IV 99,000 8,250.00 29,700 2,316.67 34,700 3,050.00 163,400 13,616.67 0.6500Associate Prof V 106,700 8,891.67 32,000 2,500.00 37,400 3,283.33 176,100 14,675.00 0.6500
Professor I 99,100 8,258.33 29,700 2,325.00 34,700 3,041.67 163,500 13,625.00 0.6500Professor II 106,800 8,900.00 32,000 2,500.00 37,400 3,283.33 176,200 14,683.33 0.6500Professor III 114,500 9,541.67 34,400 2,683.33 40,000 3,516.67 188,900 15,741.67 0.6500Professor IV 122,800 10,233.33 36,800 2,883.33 43,000 3,766.67 202,600 16,883.33 0.6500Professor V 131,600 10,966.67 39,500 3,083.34 46,000 4,041.66 217,100 18,091.67 0.6500Professor VI 142,500 11,875.00 42,800 3,341.67 49,800 4,375.00 235,100 19,591.67 0.6500Professor VII 154,200 12,850.00 46,300 3,616.67 53,900 4,733.33 254,400 21,200.00 0.6500Professor VIII 167,000 13,916.67 50,100 3,916.67 58,500 5,133.33 275,600 22,966.67 0.6500Professor IX 180,900 15,075.00 54,300 4,241.67 63,300 5,558.33 298,500 24,875.00 0.6500
Professor A/S 0.6500
(J-12)
Add'l Retirement Increment
SCHOOL OF MEDICINE MEDCOMP SCALE "7"AS OF JULY 2015 & CONTINUING
Add'l Retirement Increment FactorBase/FY 11 Month to Scale 3 Diff. in Scales 7 & 3 Total Scale "7" To FY
Rank/Step Annual Monthly Annual Monthly Annual Monthly Annual Monthly 11 Month
Instructor 58,500 4,875.00 17,600 1,366.66 29,200 2,533.34 105,300 8,775.00 0.8000
Assistant Prof I 67,800 5,650.00 20,300 1,591.67 33,900 2,925.00 122,000 10,166.67 0.8000Assistant Prof II 71,900 5,991.67 21,600 1,683.33 35,900 3,108.33 129,400 10,783.33 0.8000Assistant Prof III 75,800 6,316.67 22,700 1,775.00 37,900 3,275.00 136,400 11,366.67 0.8000Assistant Prof IV 80,200 6,683.33 24,100 1,883.33 40,100 3,466.67 144,400 12,033.33 0.8000
Associate Prof I 84,200 7,016.67 25,300 1,975.00 42,100 3,641.66 151,600 12,633.33 0.8000Associate Prof II 88,300 7,358.33 26,500 2,066.67 44,100 3,816.67 158,900 13,241.67 0.8000Associate Prof III 93,200 7,766.67 28,000 2,183.34 46,600 4,033.32 167,800 13,983.33 0.8000Associate Prof IV 99,000 8,250.00 29,700 216.67 49,500 6,383.33 178,200 14,850.00 0.8000Associate Prof V 106,700 8,891.67 32,000 2,500.00 53,400 4,616.66 192,100 16,008.33 0.8000
Professor I 99,100 8,258.33 29,700 2,325.00 49,600 4,283.34 178,400 14,866.67 0.8000Professor II 106,800 8,900.00 32,000 2,500.00 53,400 4,616.67 192,200 16,016.67 0.8000Professor III 114,500 9,541.67 34,400 2,683.33 57,200 4,950.00 206,100 17,175.00 0.8000Professor IV 122,800 10,233.33 36,800 2,883.33 61,400 5,300.01 221,000 18,416.67 0.8000Professor V 131,600 10,966.67 39,500 3,083.34 65,800 5,691.66 236,900 19,741.67 0.8000Professor VI 142,500 11,875.00 42,800 3,341.67 71,200 6,158.33 256,500 21,375.00 0.8000Professor VII 154,200 12,850.00 46,300 3,616.67 77,100 6,666.66 277,600 23,133.33 0.8000Professor VIII 167,000 13,916.67 50,100 3,916.67 83,500 7,216.66 300,600 25,050.00 0.8000Professor IX 180,900 15,075.00 54,300 4,241.67 90,400 7,816.66 325,600 27,133.33 0.8000
Professor A/S 0.8000
(J-13)
SCHOOL OF MEDICINE MEDCOMP SCALE "8"AS OF JULY 2015 & CONTINUING
Add'l Retirement Increment FactorBase/FY 11 Month to Scale 3 Diff. in Scales 8 & 3 Total Scale "8" To FY
Rank/Step Annual Monthly Annual Monthly Annual Monthly Annual Monthly 11 Month
Instructor 58,500 4,875.00 17,600 1,366.66 40,900 3,508.34 117,000 9,750.00 1.0000
Assistant Prof I 67,800 5,650.00 20,300 1,591.67 47,500 4,058.33 135,600 11,300.00 1.0000Assistant Prof II 71,900 5,991.67 21,600 1,683.33 50,300 4,308.33 143,800 11,983.33 1.0000Assistant Prof III 75,800 6,316.67 22,700 1,775.00 53,100 4,541.66 151,600 12,633.33 1.0000Assistant Prof IV 80,200 6,683.33 24,100 1,883.33 56,100 4,800.01 160,400 13,366.67 1.0000
Associate Prof I 84,200 7,016.67 25,300 1,975.00 58,900 5,041.66 168,400 14,033.33 1.0000Associate Prof II 88,300 7,358.33 26,500 2,066.67 61,800 5,291.67 176,600 14,716.67 1.0000Associate Prof III 93,200 7,766.67 28,000 2,183.34 65,200 5,583.32 186,400 15,533.33 1.0000Associate Prof IV 99,000 8,250.00 29,700 2,316.67 69,300 5,933.33 198,000 16,500.00 1.0000Associate Prof V 106,700 8,891.67 32,000 2,500.00 74,700 6,391.66 213,400 17,783.33 1.0000
Professor I 99,100 8,258.33 29,700 2,325.00 69,400 5,933.34 198,200 16,516.67 1.0000Professor II 106,800 8,900.00 32,000 2,500.00 74,800 6,400.00 213,600 17,800.00 1.0000Professor III 114,500 9,541.67 34,400 2,683.33 80,100 6,858.33 229,000 19,083.33 1.0000Professor IV 122,800 10,233.33 36,800 2,883.33 86,000 7,350.01 245,600 20,466.67 1.0000Professor V 131,600 10,966.67 39,500 3,083.34 92,100 7,883.32 263,200 21,933.33 1.0000Professor VI 142,500 11,875.00 42,800 3,341.67 99,700 8,533.33 285,000 23,750.00 1.0000Professor VII 154,200 12,850.00 46,300 3,616.67 107,900 9,233.33 308,400 25,700.00 1.0000Professor VIII 167,000 13,916.67 50,100 3,916.67 116,900 9,999.99 334,000 27,833.33 1.0000Professor IX 180,900 15,075.00 54,300 4,241.67 126,600 10,833.33 361,800 30,150.00 1.0000
Professor A/S 1.0000
(J-14)
SCHOOL OF MEDICINE MEDCOMP SCALE "9"AS OF JULY 2015 & CONTINUING
Add'l Retirement Increment FactorBase/FY 11 Month to Scale 3 Diff. in Scales 9 & 3 Total Scale "9" To FY
Rank/Step Annual Monthly Annual Monthly Annual Monthly Annual Monthly 11 Month
Instructor 58,500 4,875.00 17,600 1,366.66 55,500 4,725.01 131,600 10,966.67 1.2500
Assistant Prof I 67,800 5,650.00 20,300 1,591.67 64,500 5,475.00 152,600 12,716.67 1.2500Assistant Prof II 71,900 5,991.67 21,600 1,683.33 68,300 5,808.33 161,800 13,483.33 1.2500Assistant Prof III 75,800 6,316.67 22,700 1,775.00 72,100 6,125.00 170,600 14,216.67 1.2500Assistant Prof IV 80,200 6,683.33 24,100 1,883.33 76,200 6,475.01 180,500 15,041.67 1.2500
Associate Prof I 84,200 7,016.67 25,300 1,975.00 80,000 6,800.00 189,500 15,791.67 1.2500Associate Prof II 88,300 7,358.33 26,500 2,066.67 83,900 7,133.33 198,700 16,558.33 1.2500Associate Prof III 93,200 7,766.67 28,000 2,183.34 88,500 7,524.99 209,700 17,475.00 1.2500Associate Prof IV 99,000 8,250.00 29,700 2,316.67 94,100 8,000.00 222,800 18,566.67 1.2500Associate Prof V 106,700 8,891.67 32,000 2,500.00 101,400 8,616.66 240,100 20,008.33 1.2500
Professor I 99,100 8,258.33 29,700 2,325.00 94,200 8,000.00 223,000 18,583.33 1.2500Professor II 106,800 8,900.00 32,000 2,500.00 101,500 8,625.00 240,300 20,025.00 1.2500Professor III 114,500 9,541.67 34,400 2,683.33 108,700 9,241.67 257,600 21,466.67 1.2500Professor IV 122,800 10,233.33 36,800 2,883.33 116,700 9,908.34 276,300 23,025.00 1.2500Professor V 131,600 10,966.67 39,500 3,083.34 125,000 10,624.99 296,100 24,675.00 1.2500Professor VI 142,500 11,875.00 42,800 3,341.67 135,300 11,500.00 320,600 26,716.67 1.2500Professor VII 154,200 12,850.00 46,300 3,616.67 146,500 12,450.00 347,000 28,916.67 1.2500Professor VIII 167,000 13,916.67 50,100 3,916.67 158,700 13,483.33 375,800 31,316.67 1.2500Professor IX 180,900 15,075.00 54,300 4,241.67 171,800 14,600.00 407,000 33,916.67 1.2500
Professor A/S 1.2500
(J-15)
FUND SOURCE CODES
& OTHER REFERENCE LISTS
SOURCE CODES LIST FOR FACULTY SALARIES
Code Description CPL BudgetGrouping State FundsSTATE_01 State Funds-199XX-Dept FTE STATE_02 State Funds-199XX-Dept Temp STATE_03 State Funds-199XX-NPI FTE STATE_04 State Funds-199XX-NPI Temp STATE_05 State Funds-199XX-Letters & Sciences TemSTATE_06 State Funds-19900-Other Schools, e.g. Publ HlthSTATE_07 State Funds-19900 ChancellorSTATE_08 State Funds 19910 Geriatric Research
Grouping Federal Contracts & GrantsNIH_01 # Fed C& G-NIH/SAMHSA Sal Savings calcFCG_01 # Fed C&G-Other Agenices Sal Savings calcGrouping Private SourcesPCG_01 # Private-Contracts & Grants Sal Savings calcCTR_01 # Clinical Trials Sal Savings calcGFT_01 # Private-Gifts Sal Savings calcEND_01 # Endowments Sal Savings calcGrouping Local GovernmentLCG_01 # Local Gov’t-L.A. Co. Agmt-Harbor Sal Savings calcLCG_02 # Local Gov’t-L.A. Co. Agmt-Ol Vw Sal Savings calcLCG_03 # Local Gov’t –Other Sal Savings calcSCG_01 # State Agmt Sal Savings calcGrouping Professional FeesCPL_01 Prof Fees-Dept ExpenseCPL_02 Prof Fees-Other ExpenseCPL_03 Prof Fees-Salary Savings-Fund Source Exchange Revenue, ExpenseCPL_04 * Prof Fees-Hlth System-Westwood Hospital Revenue, ExpenseCPL_05 * Prof Fees-Hlth System-Santa Monica Hospital Revenue, ExpenseCPL_06 Prof Fees-FPG (3906) Revenue, ExpenseCPL_07 * Prof Fees-Hlth System-Neuropsychiatric Hospital Revenue, Expense
Grouping Dean Support & SourcesDEAN_01 * Dean's Office Support (Comp Plan) Revenue, ExpenseDEAN_02 * Dean's Office--Student Fees-20226 (Education) Revenue, ExpenseDEAN_03 Dean's Office-State Funds-199XX-Fund Source Exchange Interfund ExpenseDEAN_04 * Dean's Office-State Funds-199XX-Use of Salary Savings SupportDEAN_05 * Dean's Office-Indirect Cost Recovery Funds-ICRDEAN_06 * Dean's Office-Geffen Funds (Gifts)DEAN_07 * Dean's Office-Other Gifts & EndowmentsDEAN_08 * Dean's Office-Sales & ServiceDEAN_09 * Dean's Office-Contracts & GrantsDEAN_10 * Dean's Office-Switzer Fund (Gifts)DEAN_11 * Dean's Office-Other UCLA
Grouping Other UCLAICR_01 Indirect Cost Recovery-Opportunity & OverheadSNS_01 Sales & Service FundsOTH_01 Other UCLA Funds
Grouping Direct PayDP_01 Direct Pay-Vet Admin-Wadsworth (West LA)DP_02 Direct Pay-Vet Admin-SepulvedaDP_03 Direct Pay-Vet Admin-Brentwood DP_04 Direct Pay-L.A. Co. Harbor DP_05 Direct Pay-L.A. Co. Ol Vw DP_06 Direct Pay-L.A. Co. MLKDP_07 Direct Pay-Other Affil Hosp DP_08 Direct Pay- HHMIDP_09 Direct Pay- Other
# Use of these funds in Base X for a State FTE person calculates Salary Savings revenue in Comp Plan Funds.* Health System and Dean's Support Revenues are created in AFB for approved items only for any fund source.
(J-16)
LOCATION AND OUTREACH
SHORT LONG UCLADESCRIPTION * DESCRIPTION ACCOUNT COST CENTER
ALHAMBRA ONC ALHAMBRA ONCOLOGY 7Q
BAKER * BAKERSFIELDBH1 * BEVERLY HILLS 1BH2 * BEVERLY HILLS 2BH-SUBSPEC BEVERLY HILLS/SUBSPECIALTY 7B NewBH II-PCP BEVERLY HILLS II/PCP Two Different 7Y NewBH II-ONC BEVERLY HILLS II/ONCOLOGY Accts w/in Dept 7Y New
BRENTWD * BRENTWOODBURBANK ONC BURBANK ONCOLOGY Two Different 9SBURBANK PCP BURBANK PCP Accts w/in Dept 9S New
CALABASAS PRIM CALABASAS PRIMARY CARE Two Different 7OCALABASAS ONC CALABASAS ONCOLOGY Accts w/in Dept 7OCALABASAS SUB CALABASAS SUBSPECIALTY 9GCALABASAS II CALABASAS IICAMPUS SPEC CAMPUS SPECIALTIES 7RCARE CARE CENTER 7CCEDAR CEDARSCENTC * CENTURY CITYCHS CHS 6C,6DCHS-100M CHS-100 MED PLAZA 6ECHS-IMS * CHS-INTERNAL MED SUITECHS-WHC * CHS-WOMEN HEALTH CENTERCHS-WHC GI CHS- WOMEN HLTH CTR GICOMOUT COMMUNITY OUTREACH 6VCULVC * CULVER CITY
DREW DREWEAST/WEST MED EAST/WEST MEDICINE 8PEDELMAN * EDELMANEICHCTR * EICHENBAUM CTRFAIRF * FAIRFAX
HGH HARBOR-UCLA MCHHMI H HUGHES MED INHOSPITALISTS HOSPITALISTS 7KINTENSIVISTS/NEPH PULM INTENSIVISTS/SM NEPH 7BINTERNAL MED INTERNAL MED-#455/490 6C see 100MPIRVINE ONC IRVINE ONCOLOGY 8RLAGUNA ONC LAGUNA HILLS ONCOLOGY 9OLANPA1 * LANCAST/PALM1LANPA2 * LANCAST/PALM2LATIJ * LA TIJERAMALIB * MALIBUMAN-BE * MANHATTAN BEACH 7UMDR * MARINA DEL REYMARVI * MAR VISTAMED HOSP PRG * MEDICAL HOSPITALITY PROGRAM 8SMLK ML KING HOSPITAL
NORTH NORTHRIDGE 8FOV OLIVE VIEW MC
* Site may be closed or renamed. (J-17)
LOCATION AND OUTREACH
SHORT LONG UCLADESCRIPTION DESCRIPTION ACCOUNT COST CENTER
PAC PAL * PACIFIC PALISADESPASADENA PASADENA ONCOLOGY 8K name changePASADENA PASADENAPLAN ADMIN PLAN ADMINISTRATION (MED)PORTER RANCH ONC PORTER RANCH ONCOLOGY 7IPORTER RANCH SUB PORTER RANCH SUBSPECIALTIES 9HPORTER RANCH PRIM PORTER RANCH PRIMARY CARE/NORTHRIDGE 8FRAND RANDRFO RISK FACTOR OBESITY 6A
SBARB * SANTA BARBARA 8HSBCMC SBERNADINO CMCSBERN SAN BERNADINO 7L
SANTA CLARITA SUB SANTA CLARITA CARDIOLOGY Two Different 7MSANTA CLARITA ENDO SANTA CLARITA ENDOSCOPY Accts w/in Dept 7MSANTA CLARITA SANTA CLARITA SANTA CLARITA PRIM SANTA CLARITA PRIMARY CARE Two Different 7N
SANTA CLARITA SUBSPECIALTIES Accts w/in Dept 7NSANTA CLARITA ONC SANTA CLARITA ONCOLOGY 8M
SHERM * SHERMAN OAKSSIMI VALLEY SIMI VALLEY ONCOLOGY 8V name changeSIMI VALLEY SIMI VALLEY SIMI VALLEY PRIM SIMI VALLEY PRIMARY CARE 8OSIMI VALLEY SUB SIMI VALLEY SUBSPECIALTY 9ISNF SKILLED NURSING FACILITY 6F
SM12TH-1 SAMO 12TH ST-1 (2ND FLOOR) 8C see SM Derm
SM1 SANTA MONICA 1 8TSM2 SANTA MONICA 2 8XSM DERM COSM SM DERMATOLOGY-COSMETICS 7X see Derm FundSM PEDS/ETC SM PEDIATRICS/ETC 8Q
SM15TH SAMO 15TH 7Q
SM16TH SAMO 16TH ST 7ZSM16TH ID SM 16TH INFECTIOUS DISEASES 8NSM16TH-3 SAMO 16TH ST 3 8QSM16TH CIA SM 16TH CLINICAL IMMUNOLOGY & ALLERGY 7U
SMBLVD-1 SAMO SM BLVD-1 7XSMBLVD-2 SAMO BLVD-2 8DSMBLVD-3 SAMO BLVD-3 8P
SM DERMPATH SM DERMPATH 8VSMGERI SM GERIATRICS (16th Street) 7WSMIMRES SM INTERNAL MED/RESIDENCY 7DSMMC SANTA MONICA MEDICAL CENTER 7VSM RHEU SM RHEUMATOLOGY 7JSMWIL SAMO WILSHIRE 8G
* Site may be closed or renamed. (J-18)
LOCATION AND OUTREACH
SHORT LONG UCLADESCRIPTION DESCRIPTION ACCOUNT COST CENTER
SO.BAY ENDO SOUTH BAY ENDOCRINOLOGY 9NSO.BAY PULM SOUTH BAY PULMONARY 9QSO.BAY PALO V SO. BAY - PALOS VERDES Two Different 8IBEACH CITIES/PRIM BEACH CITIES PRIMARY CARE Accts w/in Dept 8IBEACH CITIES/SUB BEACH CITIES SUBSPECIALTIES 9PTH-OAK THOUSAND OAKSTH-AGOURA TO - AGOURA 7STH-OAK-Los Robl THOUSAND OAKS-Los Robles MC 8RTH-OAKS PRIM CARE THOUSAND OAKS-Primary Care 9JTH-OAKS SUB THOUSAND OAKS-Subspecialty 9KTH-OAKS NUCL MED THOUSAND OAKS-Nuclear Med 9LTORR - ONC TORRANCE ONCOLOGY Two Different 8ATORR - PRIM TORRANCE PRIMARY CARE Accts w/in Dept 8ATORR-E/W TORRANCE EAST-WEST 9V New
VA SE VA SEPULVEDAVA WA VA WADSWORTHVAB VA BRENTWOOD
VENICE SATELLITEVENTU VENTURA 7TWHC #290 WOMEN'S HEALTH CTR #290 7EWH ENDOSCOPY WEST HILLS ENDOSCOPY PROC ROOM 9UWESTLAKE ONC WESTLAKE ONCOLOGY 8BWESTLAKE PRIM WESTLAKE PRIMARY CARE 9FWESTLAKE SUB WESTLAKE SUBSPECIALTIES Two Different 9EWESTLAKE SUB WESTLAKE - EAST/WEST Accts w/in Dept 9EWLA WEST LOS ANGELEWWD WESTWOOD 8JWWD 2 WESTWOOD II 8S
100MP CARD 100MP CARDIAC DIAGNOSIS 7H100MP CELIAC 100MP CELIAC/IBS 9M100MP DERM COSM 100MP DERM COSMETICS 6D100MP EP/NEPH 100MP CARDIOLOGY-EP/NEPHROLOGY 7P100MP GASTRO 100MP GASTRO 6E100MP INT MED 100MP INTERNAL MEDICINE 6C100MP NUCL IM 100MP NUCLEAR IMAGING 7G100MP ONCOL 100MP ONCOLOGY 6D & 8J
2020 SM CARD 2020 SM CARDIOLOGY 7A2020 SM DERM 2020 SM DERMATOLOGY 8C2020 SM DERM COSM 2020 SM DERMATOLOGY COSMETIC Two Different 7X2020 SM NUCL IM 2020 SM NUCLEAR IMAGING Accts w/in Dept 7X2020 SM ENDO 2020 SM ENDOCRINOLOGY 8T2020 SM GASTRO-MOB 2020 SM GASTROENTEROLOGY-MOB 6G2020 SM ONCOL 2020 SM ONCOLOGY 8D & 8E2020 SM PRIM CARE 2020 SM PRIMARY CARE 6K
* Site may be closed or renamed. (J-19)
AAMC SPECIALTY TABLEFOR FACULTY INFORMATION
DEPARTMENT AAMC SPECIALTY & TABLE # ABBREVIATION PLAN
Anesthesiology B/Sci_Other34 Basoth34 BSCPAnesth_General27 AnesG27 MCPAnesth_General34 AnesG34 BSCP or PCCPAnesth_PainManagement27 AnesPM27 MCPAnesth_PainManagement34 AnesPM34 BSCP or PCCPAnesth_Pediatric27 AnesPe27 MCPAnesth_Pediatric34 AnesPe34 BSCP or PCCPAnesthesiology27 Anesth27 MCPAnesthesiology34 Anesth34 BSCP or PCCPMed_Phys&Rehab27 MRehab27 MCPMed_Phys&Rehab34 MRehab34 BSCP or PCCP
Emergency Medicine Other_Basic34 Basoth34 BSCPEmergency_Medicine27 Memer27 MCPEmergency_Medicine34 Memer34 BSCP or PCCP
Family Medicine B/Sci_Other34 Basoth34 BSCP(new 7-15) Fam_General27 FamGen27 MCP(new 7-15) Fam_General34 FamGen34 BSCP or PCCP(new 7-15) Fam_Other27 FamOth27 MCP(new 7-15) Fam_Other34 FamOth34 BSCP or PCCP(new 7-15) Fam_SM27 FamSM27 MCP(new 7-15) Fam_SM34 FamSM34 BSCP or PCCP
Med_Preventive 27 Mprev27 MCPMed_Preventive 34 Mprev34 BSCP or PCCP
Human Genetics Human_Genetics27 HGenet27 MCPHuman_Genetics34 HGenet34 BSCP or PCCP
Medicine B/Sci_Other34 Basoth34 BSCPFamily_Practice27 Fammed27 MCPFamily_Practice34 Fammed34 BSCP or PCCPHuman_Genetics27 HGenet27 MCPHuman_Genetics34 HGenet34 BSCP or PCCPMed_AllerImm27 MCIA27 MCPMed_AllerImm34 MCIA34 BSCP or PCCPMed_Cardiology27 Mcard27 MCPMed_Cardiology34 Mcard34 BSCP or PCCPMed_Card_Inv_Inter27 MCII27 MCPMed_Card_Inv_Inter34 MCII34 BSCP or PCCPMed_Card_Inv_NInter27 MCIN27 MCPMed_Card_Inv_NInter34 MCIN34 BSCP or PCCPMed_Card_NonInvasive27 MCNInv27 MCPMed_Card_NonInvasive34 MCNInv34 BSCP or PCCPMed_CritCare27 MCrit27 MCPMed_CritCare34 MCrit34 BSCP or PCCPMed_CommHealth27 MCommH27 MCPMed_CommHealth34 MCommH34 BSCP or PCCPMed_Derm27 Mderm27 MCPMed_Derm34 Mderm34 BSCP or PCCPMed_Derm_Mohs27 MDMohs27 MCPMed_Derm_Mohs34 MDMohs34 BSCP or PCCPMed_Endo27 MEndo27 MCPMed_Endo34 MEndo34 BSCP or PCCP
(J-20)
AAMC SPECIALTY TABLEFOR FACULTY INFORMATION
DEPARTMENT AAMC SPECIALTY & TABLE # ABBREVIATION PLAN
Medicine (con't) Med_Gastro27 Mgast27 MCPMed_Gastro34 Mgast34 BSCP or PCCPMed_General27 MGen27 MCPMed_General34 MGen34 BSCP or PCCPMed_Geriatric27 MGeri27 MCPMed_Geriatric34 MGeri34 BSCP or PCCPMed_HemOnc27 MHemo27 MCPMed_HemOnc34 MHemo34 BSCP or PCCPMed_Hospitalist27 MHosp27 MCPMed_Hospitalist34 MHosp34 BSCP or PCCPMed_InfDisease27 MInfD27 MCPMed_InfDisease34 MInfD34 BSCP or PCCPMed_Nephrol27 MNeph27 MCPMed_Nephrol34 MNeph34 BSCP or PCCPMed_Other27 Medoth27 MCPMed_Other34 Medoth34 BSCP or PCCPMed_Phys&Rehab27 MRehab27 MCPMed_Phys&Rehab34 MRehab34 BSCP or PCCPMed_Preventive 27 Mprev27 MCPMed_Preventive 34 Mprev34 BSCP or PCCPMed_Pulmon27 MPulm27 MCPMed_Pulmon34 MPulm34 BSCP or PCCPMed_Rheum27 MRheu27 MCPMed_Rheum34 MRheu34 BSCP or PCCP
Neurology B/Sci_Other34 Basoth34 BSCP or PCCPNeurology27 Neurol27 MCPNeurology34 Neurol34 BSCP or PCCPNeurosciences_34 NeuroS34 BSCP or PCCPPsychiatry34 Psych34 BSCP or PCCP
Neurosurgery B/Sci_Other34 Basoth34 BSCPS/Neurosurgery27 Sneuro27 MCPS/Neurosurgery34 Sneuro34 BSCP or PCCPNeurosciences_34 NeuroS34 BSCP or PCCPSurg_Trauma27 STrau27 MCPSurg_Trauma34 STrau34 BSCP or PCCP
Obstetrics & Gynecology B/Sci_Other34 Basoth34 BSCP or PCCPOB_Gen27 ObGen27 MCPOB_Gen34 ObGen34 BSCP or PCCPOB_Mat&Fetal27 OBMF27 MCPOB_Mat&Fetal34 OBMF34 BSCP or PCCPOB_Gyn_Onc27 OBGO27 MCPOB_Gyn_Onc34 OBGO34 BSCP or PCCPOB_Other27 OB_oth27 MCPOB_Other34 OB_oth34 BSCP or PCCPOB_Repro_Endo27 OBRE27 MCPOB_Repro_Endo34 OBRE34 BSCP or PCCP
Ophthalmology B/Sci_Other34 Basoth34 BSCPOphthalmology27 Ophth27 MCPOphthalmology34 Ophth34 BSCP or PCCP
Orthopaedic Surgery B/Sci_Other34 Basoth34 BSCPMed_Phys&Rehab27 MRehab27 MCPMed_Phys&Rehab34 MRehab34 BSCP or PCCP
(new 7-15) Orthopaedic_SurgGen27 OrthoG27 MCP(new 7-15) Orthopaedic_SurgGen34 OrthoG34 BSCP or PCCP(new 7-15) Orthopaedic_SurgOther27 OrthOt27 MCP(new 7-15) Orthopaedic_SurgOther34 OrthOt34 BSCP or PCCP(new 7-15) Orthopaedic_SurgSM27 OrthSM27 MCP(new 7-15) Orthopaedic_SurgSM34 OrthSM34 BSCP or PCCP
Surg_Trauma27 STrau27 MCPSurg_Trauma34 STrau34 BSCP or PCCP
(J-21)
AAMC SPECIALTY TABLEFOR FACULTY INFORMATION
DEPARTMENT AAMC SPECIALTY & TABLE # ABBREVIATION PLAN
Pathology B/Sci_Other34 Basoth34 BSCPPathology_Anat27 PaAnat27 MCPPathology_Anat34 PaAnat34 BSCP or PCCPPathology_Clin27 PaClin27 MCPPathology_Clin34 PaClin34 BSCP or PCCPPathology_Other27 PaOth27 MCPPathology_Other34 PaOth34 BSCP or PCCP
Pediatrics B/Sci_Other34 Basoth34 BSCPHuman_Genetics27 HGenet27 MCPHuman_Genetics34 HGenet34 BSCP or PCCPPeds_AdolMed27 PAdolM27 MCPPeds_AdolMed34 PAdolM34 BSCP or PCCPPeds_Allerg27 PAller27 MCPPeds_Allerg34 PAller34 BSCP or PCCPPeds_Cardiology27 PCard27 MCPPeds_Cardiology34 PCard34 BSCP or PCCPPeds_Child/Adol27 PChAd27 MCPPeds_Child/Adol34 PChAd34 BSCP or PCCPPeds_CritCare27 PCrit27 MCPPeds_CritCare34 PCrit34 BSCP or PCCPPeds_Emerg27 PEMR27 MCPPeds_Emerg34 PEMR34 BSCP or PCCPPeds_Endo27 PEndo27 MCPPeds_Endo34 PEndo34 BSCP or PCCPPeds_Gastro27 PGast27 MCPPeds_General27 PGen27 MCPPeds_General34 PGen34 BSCP or PCCPPeds_Genetics27 PGene27 MCPPeds_HemOnc27 PHemo27 MCPPeds_HemOnc34 PHemo34 BSCP or PCCP
(new 7-15) Peds_Hosp27 PHosp27 MCPPeds_InfDis27 PIndfD27 MCPPeds_InfDis34 PInfD34 BSCP or PCCPPeds_Neonatol27 Pneon27 MCPPeds_Neonatol34 Pneon34 BSCP or PCCPPeds_Other27 Pedoth27 MCPPeds_Other34 Pedoth34 BSCP or PCCPPeds_Nephrol34 PNephr34 BSCP or PCCPPeds_Neurology27 PNeur27 MCPPeds_Neurology34 PNeur34 BSCP or PCCPPeds_Pulmon 27 PPulm27 MCPPeds_Pulmon34 PPulm34 BSCP or PCCPPeds_Rheum27 PRheu27 MCPPeds_Rheum34 PRheu34 BSCP or PCCP
Pharmacology B/Sci_Other34 Basoth34 BSCPNuclear_Medicine27 NucM27 MCPNuclear_Medicine34 NucM34 BSCP or PCCPPharmacology27 Pharma27 MCPPharmacology34 Pharma34 BSCP or PCCP
(J-22)
AAMC SPECIALTY TABLEFOR FACULTY INFORMATION
DEPARTMENT AAMC SPECIALTY & TABLE # ABBREVIATION PLAN
Psychiatry B/Sci_Other34 Basoth34 BSCP(new 01-13) Psychiatry_General27 PsyGen27 MCP(new 01-13) Psychiatry_General34 PsyGen34 BSCP or PCCP(new 01-13) Psychiatry_Other27 PsyOth27 MCP(new 01-13) Psychiatry_Other34 PsyOth34 BSCP or PCCP
Psy_ChildAdol27 PSCA27 MCPPsy_ChildAdol34 PSCA34 BSCP or PCCPNeurosciences_34 NeuroS34 BSCP or PCCP
Radiation Oncology B/Sci_Other34 Basoth34 BSCPRad_Therapeutic27 Radonc27 MCPRad_Therapeutic34 Radonc34 BSCP or PCCP
Radiological Sciences B/Sci_Other34 Basoth34 BSCPRad_Diagnostic_Inter27 RadInt27 MCPRad_Diagnostic_Inter34 RadInt34 BSCP or PCCPRad_Diagnostic_Non27 RadioN27 MCPRad_Diagnostic_Non34 RadioN34 BSCP or PCCPRadiology_Other27 RadO27 MCPRadiology_Other34 RadO34 BSCP or PCCP
Surgery B/Sci_Other34 Basoth34 BSCPMed_Phys&Rehab27 MRehab27 MCPMed_Phys&Rehab34 MRehab34 BSCP or PCCP
Surg_General27 Sgen27 MCPSurg_General34 Sgen34 BSCP or PCCP
S/Neurosurgery27 Sneuro27 MCPS/Neurosurgery34 Sneuro34 BSCP or PCCP
Surg_Other27 SOther27 MCPSurg_Other34 SOther 34 BSCP or PCCPSurg_Otolaryng27 S_otol27 MCPSurg_Otolaryng34 S_otol34 BSCP or PCCPSurg_Pediatrics27 SPeds27 MCPSurg_Pediatrics34 SPeds34 BSCP or PCCPSurg_Plastic27 Splast27 MCPSurg_Plastic34 Splast34 BSCP or PCCPSurg_Thor_Card27 Sthorc27 MCPSurg_Thor_Card34 Sthorc34 BSCP or PCCPSurg_Transplant27 STrans27 MCPSurg_Transplant34 STrans34 BSCP or PCCPSurg_Trauma27 STrau27 MCPSurg_Trauma34 STrau34 BSCP or PCCPSurg_Vascular27 SVSC27 MCPSurg_Vascular34 SVSC34 BSCP or PCCP
Urology B/Sci_Other34 Basoth34 BSCPMed_Preventive 27 Mprev27 MCPUrology27 Urolog27 MCPUrology34 Urolog34 BSCP or PCCP
(J-23)