Banner HR Employee Data Elements Definitions
Field Type notes:
- Free form text field type typically has no limitations of what can be entered in the field, other than a character limit.
- Drop Down/Validated field type allows for selection of only one value from an available list predetermined values, unless otherwise noted in the Field Definitions column.
- Date field type allows entry of date only.
Note regarding employees with multiple positions: each active employee has a primary position and must have a primary position at any given time. If an employee holds positions in addition to their primary role, these positions are entered in Banner and are labeled as overload. For example, a full time faculty who also has an adjunct position will have the faculty job flagged as primary in Banner and the adjunct job flagged as overload. Overload jobs are similar to secondary assignments.
Faculty who are receiving supplemental/temporary pay for additional duties such as serving in an interim role may have an additional "job" entered in Banner. This practice of separating supplement pay for additional duties is not consistent across all units. The Banner term for this type of record is flagged as "Secondary". This is only a Banner term and should not be confused with the definition of a secondary assignment.
Banner Field | Field Definition | Data Category | Optional/Required | Field Type | Available Values | Can the list of available values be modified by VCU? | How is the data maintained? |
---|---|---|---|---|---|---|---|
Prefix (name) | Prefix associated with the person's name (for example, Mr. or Mrs.). | Personal/Demographics | Optional | Free form text | N/A | N/A | From new hire paperwork at time of hire. Note: information in this field is not well maintained and should not be used to address employees. |
First Name (legal) | The person's legal first name as it appears on their social security card. | Personal/Demographics | Required | Free form text | N/A | N/A | From new hire paperwork at time of hire. If legally changed during employment, information is updated by VCU HR via documentation from employee. |
Middle Name (legal) | The person's legal middle name as it appears on their social security card. | Personal/Demographics | Required | Free form text | N/A | N/A | From new hire paperwork at time of hire. If legally changed during employment, information is updated by VCU HR via documentation from employee. |
Last Name (legal) | The person's legal last name as it appears on their social security card. | Personal/Demographics | Required | Free form text | N/A | N/A | From new hire paperwork at time of hire. If legally changed during employment, information is updated by VCU HR via documentation from employee. |
Suffix (name) | Suffix associated with the person's name (for example, Jr. or Sr.). | Personal/Demographics | Optional | Free form text | N/A | N/A | From new hire paperwork at time of hire. If legally changed during employment, information is updated by VCU HR via documentation from employee. |
Preferred First Name | Person's name of use. This name may or may not match the person's legal first name. | Personal/Demographics | Optional | Free form text | N/A | N/A | From new hire paperwork at time of hire. Employee has the ability to update via eServices at any time. |
Legal Sex | Indicates the legal sex of the person | Personal/Demographics | Required | Drop Down/Validated | No | From new hire paperwork at time of hire. If legally changed during employment, information is updated by VCU HR via documentation from employee. | |
Gender Designation | Gender by which the person identifies. | Personal/Demographics | Optional | Drop Down/Validated | Yes | From new hire paperwork at time of hire. Employee has the ability to update via eServices at any time. | |
Personal Pronoun | Pronoun by which the person identifies. | Personal/Demographics | Optional | Drop Down/Validated | Yes | From new hire paperwork at time of hire. Employee has the ability to update via eServices at any time. | |
Birth Date | Person's date of birth. | Personal/Demographics | Required | Date | N/A | N/A | From new hire paperwork at time of hire. If a correction is needed, information is updated by VCU HR via documentation from employee. |
Citizenship | Indicates whether the person is a U.S. citizen. | Personal/Demographics | Required | Drop Down/Validated | Yes | From new hire paperwork at time of hire. If a correction is needed or a non-citizen becomes a citizen, information is updated by VCU HR via documentation from employee. | |
Ethnicity | Division of Inclusive Excellence Terminology | Personal/Demographics | Optional | Drop Down/Validated | No | From new hire paperwork at time of hire. Employee has the ability to update via eServices at any time. | |
Race | Division of Inclusive Excellence Terminology NOTE: Employees may select one or more race categories. | Personal/Demographics | Optional | Drop Down/Validated | Yes | From new hire paperwork at time of hire. Employee has the ability to update via eServices at any time. | |
Veteran Status | Indicates whether the person served in the armed forces and, if so, specifies the category in which to count them for the U.S. | Personal/Demographics | Optional | Drop Down/Validated | No | From new hire paperwork at time of hire. Employee has the ability to update via eServices at any time. | |
Disabled Veteran | Indicates whether the person is a disabled veteran. | Personal/Demographics | Optional | Check box | N/A | N/A | From new hire paperwork at time of hire. Employee has the ability to update via eServices at any time. |
Disability Status | Indicates whether the person has/had disability. This is only a disability status of yes or no. There are no specifics to the nature of the disability. | Personal/Demographics | Optional | Drop Down/Validated | No | From new hire paperwork at time of hire. Employee has the ability to update via eServices at any time. | |
Employee Class | Employee class categorizes the employee into a specific employee type that helps determine the employee's benefit eligibility and which policies govern their employment at VCU. While employees can hold multiple positions simultaneously, at this level, an employee can have only one employee class that is associated with their currently active primary position. Based on the available values:
| Employee | Required | Drop Down/Validated | Yes | Information maintained by VCU HR based on personnel action forms submitted by HR Associated and HR Professionals. | |
Employee Group | VCU Defined grouping of employee classifications into broader categories. The groups include the following employee types based on the person's current primary position: Classified Staff - staff in the state's classified employee type. Executive and Sr Leadership - University and Academic Professionals whose position requires contracts. Typically senior level leaders. Faculty - Non-Qatar teaching and research faculty and clinical faculty who are not considered Academic Administrator Post Doctoral - Postdoctoral scholars governed by Postdoctoral Services. VCU President - only the current president of VCU. Qatar Faculty - Teaching and research faculty located at the Qatar campus. Salaried Non Benefit Eligible - Graduate Assistants, adjuncts, and temporary exempt other employee types. Univ and Academic Professional - University and Academic Professional staff not considered Academic Professional or Executive and Senior Leadership. Hourly and Student Worker - employees in an hourly or student employment positions. *Updates to the definition contained in this document is currently in progress. | Employee | Required | Drop Down/Validated | Yes | Information maintained by VCU HR based on personnel action forms submitted by HR Associated and HR Professionals. Occasionally directly updated by HRAs and HRPs with VCU HR involvement. | |
Leave Category | Indicates the type of leave plan in which the employee is participating. Leave categories with the term VSDP follow the Virginia Sickness and Disability leave plan. Leave categories with the term Traditional follow the traditional sick leave plan. Leave categories labeled as Academic Professionals and Univ & Acad are associated with University and Academic Professional staff. | Employee | Required | Drop Down/Validated | Yes | Information maintained by VCU HR based on employee type, eligibility, and, in some cases, specific leave type selection by the employee. | |
Part or Full Time | Indicates whether the employee's primary position is full time or part time. | Employee | Required | Drop Down/Validated | No | Defaulted based on the employee type classification. | |
Home Department Organization | The department in which the employee's primary position is housed. For employees who hold multiple positions, only one home department is assigned based on their primary position. The department name is defined on the Finance side as part of VCU's organizational hierarchy. Departments have the flexibility to have as many department codes/names as they wish, falling under their MBU. | Employee | Required | Drop Down/Validated | VCU's organization chart maintained by Finance. | Yes | The information is entered and maintained by either VCU HR based on personnel action forms or directly entered by HR Associated and Professionals via electronic personnel action forms in Banner. |
State Hire Date | Most recent state hire date. Reflects continuous state service only. Does not include state service prior to a break. May include periods outside of VCU. | Employee | Required | Date | N/A | N/A | From new hire paperwork at time of hire. If a correction is needed, VCU HR makes the necessary correction based on documentation from the employee or other state agencies. |
Leave Anniversary Date | All periods of virginia state service that is used in calculating leave accrual, collapsed into one continuous length. | Employee | Required | Date | N/A | N/A | From new hire paperwork at time of hire. If a correction is needed, VCU HR makes the necessary correction based on documentation from the employee or other state agencies. |
Base Service Award Date | All periods of VCU and VCUHS employment that is used in calculating service recognition, collapsed into one continuous length. | Employee | Required | Date | N/A | N/A | From new hire paperwork at time of hire. If a correction is needed, VCU HR makes the necessary correction based on documentation from the employee or employment records within HR systems. |
VCU Hire Date | Most recent VCU hire date. Does not include periods prior to a break in VCU employment. Inclusive of continuous service in any employment type. | Employee | Required | Date | N/A | N/A | From new hire paperwork at time of hire. If a correction is needed, VCU HR makes the necessary correction based on documentation from the employee or employment records within HR systems. |
Termination Reason | Reason for employment separation from VCU. | Employee | Optional (unless separated status) | Drop Down/Validated | Yes | Provided by department at time of processing employment separation. The accuracy of this information is dependent on information provided to the HR Associate/Professional from either the employee or manager of the employee. | |
Termination Date | Date the employee separated from VCU. | Employee | Optional (unless separated status) | Date | N/A | N/A | Provided by department at time of processing employment separation. |
Position Number | Either a unique or pooled position number tied to the position(s) the employee holds or has held at VCU. An employee holding multiple positions at any given time will have a position number tied to each position. | Job | Required | Drop Down/Validated | Selected from a list of pre-established position records. | Yes | Entered at time of hire into each position. |
Position Suffix | A two character code associated with each position an employee holds. The suffix provides an additional identifier to the position number, especially in cases where an employee holds multiple jobs in a pooled position (e.g. adjunct positions). | Job | Required | Free form text | N/A | N/A | Entered at time of hire into each position. |
Job Employee Class | See Employee Class definition. At this level, employee class is assigned to each position the employee holds. As a result, each position an employee holds can uniquely be identified in its own employee class. | Job | Required | Drop Down/Validated | See available values associated with Employee Class field. | Yes | Entered at time of hire into each position or updated if information such as FTE or employment type changes. |
Job Begin Date | The first start date in a position. This does does not change if the employee leaves the position and return into the same position without a change in their position number and position suffix combination. | Job | Required | Date | N/A | N/A | Entered at time of hire into each position. |
Job End Date | The most recent end date of the position. This date can be either in the past (for positions that have already ended) or in the future (for positions with a future known end date). The end date will be automatically removed or changed by the system if the employee returns into the same position and position suffix combination. | Job | Optional (unless the job has an end date) | Date | N/A | N/A | Future end date entered for temporary contracted positions such as adjuncts and graduate assistants or for employees with a visa expiration date. Otherwise, job end date is entered at time of employment end. |
Effective Date (Job transaction effective date) | Effective date of each action that resulted in a change on an employee's position. Each change to a job must have an effective date. Therefore, an employee's job could have many effective dates tied. | Job | Required | Date | N/A | N/A | Entered at time of processing a change to an employee's job based on personnel action forms received from HR Associates/Professionals. |
Job Status | Status of an employee's job at any given time. | Job | Required | Drop Down/Validated | No | Entered at time of processing a change to an employee's job based on personnel action forms received from HR Associates/Professionals. | |
Working Title | Non-standardized working title assigned to an employee's job. Working title can change multiple times over the employment period. For Faculty, the working title on their job record typically matches the Academic Title listed on their faculty tracking form in Banner. | Job | Required | Free form text | N/A | N/A | Entered at time of processing a change to an employee's job based on personnel action forms received from HR Associates/Professionals. |
Job FTE | Full-time equivalency. In most cases, this is 1 or less and typically indicates the number of full time hours worked by the employee. Adjuncts teaching in the summer may have an FTE that is greater than 1 due to the condensed nature of summer teaching schedule. | Job | Required | Numeric | N/A | N/A | Entered at time of processing a change to an employee's job based on personnel action forms received from HR Associates/Professionals. |
Job Change Reason | A specific reason that resulted in a change on an employee's position. The change reason may include a reason for ending an employee's job. Each change to a job must have a change reason. Therefore, an employee's job could have many change reasons associated with each change effective dates over the employment period. | Job | Required | Drop Down/Validated | Yes | Entered at time of processing a change to an employee's job based on personnel action forms received from HR Associates/Professionals. | |
Hourly Rate | Employee's per hour pay rate. This amount may change throughout the employment period. | Job | Required | Numeric | N/A | N/A | Entered at time of hire and processing as pay changes take place based on personnel action forms received from HR Associates/Professionals. |
Semi Monthly Rate | The semi-monthly pay amount the employee is expected to receive. | Job | Required | Numeric | N/A | N/A | Entered at time of hire and processing as pay changes take place based on personnel action forms received from HR Associates/Professionals. |
Annual Salary | For faculty, staff, and post docs, this is their annual salary. For other salaried employees such as adjuncts and graduate assistants, this is the total amount they are expected to receive for the contracted period. For hourly, student worker, and work study employees, this is a calculated amount projected based on their hourly rate and FTE. | Job | Required | Numeric | N/A | N/A | Entered at time of hire and processing as pay changes take place based on personnel action forms received from HR Associates/Professionals. |
Timesheet Organization | Department associated with each job the employee holds at any given time. Because this field is tied to each job, an employee may have multiple job department codes if they hold multiple jobs in different departments. | Job | Required | Drop Down/Validated | VCU's organization chart maintained by Finance. | Yes | Entered at time of hire into the position and updated as needed, based on personnel action changes received from HR Associate/Professional. |
Supervisor ID/Name | The direct supervisor of each position the employee holds. An employee who holds multiple jobs could have more than one supervisor. | Job | Optional | Drop Down/Validated | Selected from the list of active employees and affiliates in Banner HR. | Yes | Entered at time of hire into the position and updated as needed, based on personnel action changes received from HR Associate/Professional. |
Job Labor Distribution | A string of funding information that indicates where the employee's salary is charged. An employee's salary could be charged to one funding source or multiple funding sources based on percentage assigned to each funding source. | Job | Required | Drop Down/Validated | Selected from available funding sources created and maintained by finance as part of the universities chart of accounts. | Yes | Entered at time of hire into the position and updated as needed, based on personnel action changes received from HR Associate/Professional. |
SOC Code | The federal Standard Occupational Classification (SOC) code used to classify all employees into occupational categories for the purpose of collecting and reporting data. NOTE: this information is currently available only for staff positions. | Position | Optional | Drop Down/Validated | Values | Yes | Entered at time of position establishment and updated based on changes to the position. |
Visa Type | The type of visa or work authorization presented for legal employment. This information is only for non-U.S. citizens. | Employee | Optional | Drop Down/Validated | Yes | Entered at time of hire and updated as visa/work authorization is renewed. | |
Visa Start Date | The start date of the employee's visa or work authorization. | Employee | Optional | Date | N/A | N/A | Entered at time of hire and updated as visa/work authorization is renewed. |
Visa End Date | Expiration date of the employee visa or work authorization. | Employee | Optional | Date | N/A | N/A | Entered at time of hire and updated as visa/work authorization is renewed. |
Primary Activity | Primary work assignment of the faculty member | Faculty Tracking | Required | Drop Down/Validated | No | While there is information in this field for all faculty, it's currently not well maintained. | |
Faculty Type | The Faculty Type field allows the institution to potentially group like faculty. VCU has historically used this field for various purposes, as indicated by the list of available values. | Faculty Tracking | Optional | Drop Down/Validated | Yes | Currently not well maintained. | |
Academic Title | Working title that is tied to the faculty's primary position. | Faculty Tracking | Optional | Free form text | N/A | N/A | Manually entered by HR Professionals and updated as the faculty's primary role changes. |
Terminal Degree | A check in this field indicates the faculty has the highest degree they may be expected to obtain. The check mark existing in this field is dependent on whether a terminal degree is entered on another form in Banner. | Faculty Tracking | Optional | Checkbox | N/A | N/A | Currently not well maintained as credentials history in Banner is not fully accurate and up-to-date. |
Rank Effective Date | Date on which the specific rank became effective. | Faculty Tracking | Optional | Date | N/A | N/A | Manually entered by HR Professionals as part of rank record maintenance. |
Rank | Institutional rank the faculty holds. Some history of rank movement exists per recent update made to this data. | Faculty Tracking | Optional | Drop Down/Validated | Yes | Manually entered by HR Professionals at time of faculty hire and after a promotion to a higher rank. | |
Tenure Effective Date | Date on which the specific tenure status became effective. | Faculty Tracking | Optional | Date | N/A | N/A | Manually entered by HR Professionals at time of hire and updated when tenure status changes. |
Tenure Status | Status of the faculty member's tenure. | Faculty Tracking | Optional | Drop Down/Validated | Yes | Manually entered by HR Professionals at time of hire and updated when tenure status changes. |
Additional Faculty Tracking Fields
The following are Faculty tracking fields readily available in Banner but currently not utilized, along with the standard definition of the field as presented by Ellucian. While the standard definitions are in place to guide institutions, VCU can define the use of the field differently.
Field Name | Standard Field Definition |
---|---|
Primary Discipline | This field identifies the main academic discipline associated with the faculty member. |
Institution Credit | Credit toward the number of years of service the employee may have from prior institutions which may have some bearing on current faculty action eligibility. |
Emeritus Status | Indicates if the faculty member has achieved an emeritus status |
AAUP Member | Indicates whether the faculty member has a membership to the American Association of University Professors. |
Birth State or Province | Identifies the birthplace of the faculty member. |
Appt or Reappt Begin Date | Official start date for the appointment or reappointment. |
End Date | Date the faculty member's appointment ends. |
Decision | Decision made about the reappointment or tenure.
|
Decision Date | Date the decision was made with regard to the reappointment or tenure |
Decision Deferred to Date | Date that the decision will be deferred to with regard to the reappointment or tenure |
Terminal Appointment | A check in this box indicates that this is the last appointment and tenure was denied. |
Previous Tenure Grant | Generally, use this field to track tenure from another institution. This field can record tenure when the candidate has a lapse in service or it can be used to record credit given in a negotiated appointment. |
Tenure Credit this Appt | Number that reflects the amount of credit given to the tenure candidate for this appointment. This field is used for reporting purposes. |
Tenure FTE | Full-Time Equivalence (FTE) factor associated within the department. The value entered in this field represents the individual FTE component that has contributed towards the total FTE of tenure for a faculty member. |
Review Type | Faculty review associated with this appointment. |
Next Review Date | Date when the faculty member has their next review for appointment or reappointment. |
Discipline | This field identifies the primary field of academic concentration of the faculty member. A list displays the possible values. |
IPEDS Contract Type | For faculty members who have a tenure code of Non-tenured or Ineligible, the IPEDS contract type indicates the length of the contract with the institution. The contract type is only collected for employees with these tenure types. Values include the following:
|
Tenure Tracking Begin Date | Date from which the tenure process began for this faculty member. This date determines the length of time a faculty member is on track. |
Tenure Review Date | Date the faculty member should have their next review. |
Next Review | Date after the Rank Effective Date on which the faculty member will be eligible for a promotional review. |
Decision for Rank | Decision made about the promotion.
|
Decision Date | Date on which the rank decision was determined. |
Decision Deferred To Date | Date to when the rank decision is postponed. |