This view is designed to facilitate analysis of average compensation levels for employees with similar job titles and responsibilities. Summary data is published for monthly "snapshots" of the UC Berkeley work force. Grouping-category fields are included to allow reporting disaggregated by Control Unit, Division, Department, Discipline/Group, Job Code, Salary Grade, Appointment Type, Employee Relations Code, and Bargaining Unit.
Only a subset of job rows effective on the last day of each calendar month are used to generate the summary counts in this view:
Active or On-Leave job rows (EMPL_STATUS of "A", "L", or "P")
Job rows categorized as "Principal" or "Budgetary-Hold"
Employees (PERSONNEL_STATUS_CD of "E")
"Raw" and "Weighted" averages are available. Use of weighted averages are strongly recommended for comparative purposes, and are the values displayed on reports published for general use; to generate these averages, each individual's compensation is weighted according to the percentage of time s/he works (so that a half-time job counts as 1/2-job, and a full-time job counts as one job). The formulae used to calculate raw and weighted averages are described in appropriate entries in the full definitions section of the HR-BAIRS Data Dictionary.
Average Compensation is not available (data is not populated in a particular row of the view) unless a minimum number of individuals exist in the sector of the work force the row represents. The minimum threshholds are as follows for averages at the indicated level of the campus hierarchy:
Campus: 10 employees
Control Unit: 7 employees
Division, Dept, Discipline/Group: 5 employees
Compensation professionals on the campus strongly recommend against using an average calculated from fewer than ten (10) individual salaries for comparative purposes.
This view is created in two varients, which aggregate summary counts in organizational units (Control Units, Divisions, etc.) differently:
COMP_AVG_SUMMARY_V aggregates summary counts using the reporting line effective at the time the view was last updated (generally once per month). This yields reports that show a unit's data as it would have been if the unit had always contained the departments it contains now.
COMP_AVG_SUMMARY_ED_V aggregates summary counts using the reporting line effective at the time the summary describes. This yields reports that show a unit's data actually was - without regard to subsequent addition or loss of departments, etc., due to reorganizations.
Users with reporting privileges in the Workforce Summary subject area may report on nodes in the campus Organizational Hierarchy for which they have reporting rights, as well as "parents" and "children" of those nodes.
Published in:- HRBAIRS .ws
Contains fields:
| COMP_AVG_RAW_ANNUAL_BASE_AMT |
A raw average of annual pay rates for job summarized in this row of summary view data. The raw average is based on the total number of job rows summarized, irrespective of how many FTE these rows represent. A minimum number of jobs must be summarized in a row of data in order for this field's value to contain an average (see complete definition for detailed information). |
| COMP_AVG_RAW_HOURLY_BASE_AMT |
A raw average of hourly pay rates for job summarized in this row of summary view data. The raw average is based on the total number of job rows summarized, irrespective of how many FTE these rows represent. A minimum number of jobs must be summarized in a row of data in order for this field's value to contain an average (see complete definition for detailed information). |
| COMP_AVG_RAW_MONTHLY_BASE_AMT |
A raw average of monthly pay rates for job summarized in this row of summary view data. The raw average is based on the total number of job rows summarized, irrespective of how many FTE these rows represent. A minimum number of jobs must be summarized in a row of data in order for this field's value to contain an average (see complete definition for detailed information). |
| COMP_AVG_WGTD_ANNUAL_BASE_AMT |
A weighted average of annual pay rates for job summarized in this row of summary view data. The weighted average uses the sum of FTE represented by the summarized jobs, rather than the raw number of rows. A minimum number of jobs must be summarized in a row of data in order for this field's value to contain an average (see complete definition for detailed information). |
| COMP_AVG_WGTD_HOURLY_BASE_AMT |
A weighted average of houry pay rates for job summarized in this row of summary view data. The weighted average uses the sum of FTE represented by the summarized jobs, rather than the raw number of rows. A minimum number of jobs must be summarized in a row of data in order for this field's value to contain an average (see complete definition for detailed information). |
| COMP_AVG_WGTD_MONTHLY_BASE_AMT |
A weighted average of monthly pay rates for job summarized in this row of summary view data. The weighted average uses the sum of FTE represented by the summarized jobs, rather than the raw number of rows. A minimum number of jobs must be summarized in a row of data in order for this field's value to contain an average (see complete definition for detailed information). |
| EMPL_RELATIONS_CD |
The Employee Relations code indicates whether a job is that of a manager or supervisor; and whether or not the position is considered "confidential." In summary views, indicates the Employee Relations code for which data is summarized in a row. |
| UNIT_CD |
Code representing a campus bargaining unit. Examples include: 99 (Non-represented), CX (Clerical Unit), RX (Staff Research Profession Unit), SX (Service Unit). In summary views, this field indicates the bargaining unit summarized in a row of data. |
| APPT_TYPE_CD |
A code representing the Appointment Type summarized in a row of summary-view data. |
| CAMPUS_NODE_CD |
The Level 1 (Campus-level) ORG_NODE code associated with data represented by a row, generally in data warehouse summary views. |
| CAMPUS_NODE_KEY |
A database key identifying the Level 1 (Campus-level) ORG_NODE associated with data represented by a row, generally in data warehouse summary views. A numeric value, the function of this key is use instead of ORG_NODE when joining certain views, to improve database performance. |
| CONTROL_UNIT_NODE_CD |
The Level 2 (Control Unit) ORG_NODE code associated with data represented by a row, generally in data warehouse summary views. |
| CONTROL_UNIT_NODE_KEY |
A database key identifying the Level 2 (Control-Unit-level) ORG_NODE associated with data represented by a row, generally in data warehouse summary views. A numeric value, the function of this key is use instead of ORG_NODE when joining certain views, to improve database performance. |
| DEPT_NODE_CD |
The Level 4 (Department) ORG_NODE code associated with data represented by a row, generally in data warehouse summary views. |
| DEPT_NODE_KEY |
A database key identifying the Level 4 (Department-level) ORG_NODE associated with data represented by a row, generally in data warehouse summary views. A numeric value, the function of this key is use instead of ORG_NODE when joining certain views, to improve database performance. |
| DISCIPLINE_NODE_CD |
The Level 5 (Discipline) ORG_NODE code associated with data represented by a row, generally in data warehouse summary views. |
| DISCIPLINE_NODE_KEY |
A database key identifying the Level 5 (Discipline/Group-level) ORG_NODE associated with data represented by a row, generally in data warehouse summary views. A numeric value, the function of this key is use instead of ORG_NODE when joining certain views, to improve database performance. |
| DIVISION_NODE_CD |
The Level 3 (Division) ORG_NODE code associated with data represented by a row, generally in data warehouse summary views. |
| DIVISION_NODE_KEY |
A database key identifying the Level 3 (Division-level) ORG_NODE associated with data represented by a row, generally in data warehouse summary views. A numeric value, the function of this key is use instead of ORG_NODE when joining certain views, to improve database performance. |
| EMPL_STATUS_CD |
The Employee Status (e.g., Active, Leave with Pay, Leave without Pay, Suspended, Terminated, etc.) summarized in a row of summary-view data. |
| JOB_CD |
A code representing the job (classification) summarized in a row of summary-view data. |
| JOB_CNT |
The number of job-level rows of individuals' HRMS data included in a row of summary data, irrespective of whether the individual row is a Primary Appointment or not. See PRIMARY_APPT_INDEX for more on this topic. Depending on the view in which this field appears, it may signify a number of positions, a number of personnel transactions, or some other count. The value of the field is calculated from the number of individuals' job-level rows that matches grouping-category field data in the summary row (e.g., the count of job-level rows whose APPT_TYPE = APPT_TYPE_CD; etc.). |
| JOB_FTE_CNT |
The sum of FTE from job-level rows of individuals' HRMS data included in a row of summary data, irrespective of whether the individuals' rows are Primary Appointments or not. See PRIMARY_APPT_INDEX for more on this topic. The value of the field is calculated from data in individuals' job-level rows that matches grouping-category field data in the summary row (e.g., the sum of FTE from job-level rows whose APPT_TYPE = APPT_TYPE_CD; etc.). |
| LEVEL_CD |
The level (in the campus hierarchy) of the Org_Node summarized by a row of data (e.g., Campus, Control Unit, Division, Department, Discipline/Group, etc.). |
| MONTH_KEY |
A database key identifying the month and year of data represented by a row, generally in data warehouse summary views. A numeric value, constructed of a four-digit numeric year concatenated with a two digit numeric month; for example, Oct 2003 is 200310, while Jan 2003 is 200301. |
| SAL_GRADE_CD |
A code representing the Salary Grade summarized in a row of summary-view data. |
| SUMM_NODE_CD |
The ORG_NODE on which a row of data is summarized in summary views. See ORG_NODE for more information. |
| SUMM_NODE_KEY |
A database key identifying the ORG_NODE associated with data summarized by a row in data warehouse summary views. A numeric value, the function of this key is use instead of ORG_NODE when joining certain views, to improve database performance. |