This view is designed to facilitate demographic reporting for purposes of federal regulatory compliance in the areas of Affirmative Action and Equal Employment Opportunity (AA/EEO) pertaining to campus faculty. 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, Tenure Status, and Job Code.
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"
Job Code maps to CTO code 010, 011, 114, or 124
Employees (PERSONNEL_STATUS_CD of "E")
Primary Appointment only (exactly one count per included employee)
This view is created in two varients, which aggregate summary counts in organizational units (Control Units, Divisions, etc.) differently:
AAA_EEO_JOB_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.
AAA_EEO_JOB_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 Academic Affirmative Action 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:
TENURE_FLG |
Indicates whether a row of summarized data pertains to academic (tenure-track) employees holding tenured job classifications, or not. "Tenured" jobs have been defined by Berkeley's Academic Personnel Office as those whose corresponding CTO Code is "010", and rows which include such jobs will be coded "Y" in this field. Rows with a value of "N" in this field summarize tenure-track (but not tenured) jobs whose CTO code is "011", "114", or "124". |
AMERN_INDIAN_FEMALE_CNT |
The number of American Indian female employees summarized in a row of data. |
AMERN_INDIAN_MALE_CNT |
The number of American Indian male employees summarized in a row of data. |
AMERN_INDIAN_UNKNOWN_SEX_CNT |
The number of American Indian employees whose sex is not recorded in HRMS summarized in a row of data. |
ASIAN_FEMALE_CNT |
The number of Asian female employees summarized in a row of data. |
ASIAN_MALE_CNT |
The number of Asian male employees summarized in a row of data. |
ASIAN_UNKNOWN_SEX_CNT |
The number of Asian employees whose sex is not recorded in HRMS summarized in a row of data. |
BLACK_FEMALE_CNT |
The number of black female employees summarized in a row of data. |
BLACK_MALE_CNT |
The number of black male employees summarized in a row of data. |
BLACK_UNKNOWN_SEX_CNT |
The number of black employees whose sex is not recorded in HRMS summarized in a row of 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. |
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. |
FEMALE_CNT |
The number of female employees summarized in a row of data. |
HEAD_CNT |
The number of job-level rows of individuals' HRMS data included in a row of summary data, where the individual row is an employee's Primary Appointment on the date the row of summary data represents. An employee has exactly one Primary Appointment on any given date. See PRIMARY_APPT_INDEX for more on this topic. The value of the field is calculated from the number of individuals' job-level rows that, in addition to the condition described above, match grouping-category field data in the summary row (e.g., the count of job-level rows whose APPT_TYPE = APPT_TYPE_CD; etc.). |
HISPANIC_FEMALE_CNT |
The number of Hispanic female employees summarized in a row of data. |
HISPANIC_MALE_CNT |
The number of Hispanic male employees summarized in a row of data. |
HISPANIC_UNKNOWN_SEX_CNT |
The number of Hispanic employees whose sex is not recorded in HRMS summarized in a row of 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.). |
MALE_CNT |
The number of male employees summarized in a row of data. |
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. |
PRIMARY_JOB_FTE_CNT |
The sum of FTE from job-level rows of individuals' HRMS data included in a row of summary data, where the individuals' rows are Primary Appointments. An employee has exactly one Primary Appointment on any given date. See PRIMARY_APPT_INDEX for more on this topic. The value of the field is calculated from data in individuals' job-level rows that, in addition to the condition described above, match 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.). |
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. |
UNKNOWN_ETHNIC_FEMALE_CNT |
The number of female employees whose ethnicity is not recorded in HRMS summarized in a row of data. |
UNKNOWN_ETHNIC_MALE_CNT |
The number of male employees whose ethnicity is not recorded in HRMS summarized in a row of data. |
UNKNOWN_SEX_AND_ETHNIC_CNT |
The number of employees for whom neither sex nor ethnicity are recorded in HRMS summarized in a row of data. |
UNKNOWN_SEX_CNT |
The number of employees whose sex is not recorded in HRMS summarized in a row of data. |
WHITE_FEMALE_CNT |
The number of white female employees summarized in a row of data. |
WHITE_MALE_CNT |
The number of white male employees summarized in a row of data. |
WHITE_UNKNOWN_SEX_CNT |
The number of white employees whose sex is not recorded in HRMS summarized in a row of data. |