|
FIELD NAME |
DESCRIPTION |
FIELD VALUES/FORMAT |
DATA SOURCE |
|
Age |
Years of age based on the date of birth |
XX (numeric) |
Payroll |
|
Age Range |
Years of age in a specific range based on date of birth |
0-19
20-29
30-39
40-49
50-59
60-69
70 and above |
Payroll |
|
Alien Registration Number (EPA) |
Number assigned
with permanent residency |
Begins with
‘A’ and Numeric |
EPAWeb
|
|
Appointment End Date |
Scheduled end date for current rank |
MM/DD/YYYY |
Payroll |
|
Appointment Type |
Combination of Perm/Temp and Full/Part status |
Permanent/Full-Time
Permanent/Part-Time
Temporary/Full-Time
Temporary/Part-Time |
Payroll |
|
Base Rate |
The annual base salary for an employee
Annual
salary for permanent employee
Hourly
rate for permanent employee with less than a 20 hours per week
work schedule
Hourly
rate for a temporary employee |
$$$$$$.$$ |
EPAWeb
– EPA
Payroll
- SPA |
|
Base/Appt Department Name (EPA) |
Appointment Base Department |
|
Payroll |
|
Base/Appt Department Number (EPA) |
Appointment Base Department Number |
XXXX (numeric) |
Payroll |
|
Base/Appt Dept School/Division Name (EPA) |
School of Appointing Base Department |
|
Payroll |
|
Base/Appt Dept Subunit/Area Name (EPA) |
Subunit or Area organization of Appointing Base Department |
|
Payroll |
|
Base/Appt Dept Vice Chancellor Name (EPA) |
Vice Chancellor organization of Appointing Base Department |
|
Payroll |
|
Calendar Year |
Period in time ending on 12/31/XX |
YYYY |
|
|
Campus Address |
Includes the office mail box number, building name and address |
|
Payroll |
|
Campus Box Number |
Office mail box number |
XXXX (numeric) |
Payroll |
|
Check/Home Department Name |
Identifies the department, center, professional school or any other academic
unit that holds administrative responsibility for the employee. |
|
Payroll |
|
Check/Home Department Number |
Identifies the number code of the department, center, professional school
or any other academic unit that holds administrative responsibility
for the employee. |
XXXX (numeric) |
Payroll |
|
Check/Home Dept School/Division Name |
Identifies the school or division that holds administrative responsibility
for the employee. |
|
Payroll |
|
Check/Home Dept Subunit/Area Name |
Identifies the academic unit or area that holds administrative responsibility
for the employee. |
|
Payroll |
|
Check/Home Dept Vice Chancellor Name |
Identifies the vice chancellor unit that holds administrative responsibility
for the employee. |
|
Payroll |
|
Citizenship |
Type of nationality/residency |
U.S. Citizen
Resident
Non Resident |
EPAWeb
– EPA
Payroll - SPA |
|
Class Title (SPA) |
Office of State Personnel (OSP) classification title associated with
the position |
|
Payroll |
|
Class Title Code (SPA) |
Office of State Personnel (OSP) classification title code associated
with the position |
XXXX (numeric) |
Payroll |
|
Clinical Pay Indicator (EPA) |
Indicates an employee’s participation in the Clinical
Compensation Plan
Only available to employees that hold faculty ranks
in the Health Affairs – School
of Medicine
departments |
Yes
No
Blank |
EPAWeb |
|
Contracts & Grants Funding % Range |
Percent of employee’s salary funded by Contracts & Grants |
0%
1-25%
26-50%
51-75%
76-99%
100% |
Payroll |
|
Cost Share |
Five digit FRS account number that is used to share
the funding with a Contracts and Grants account |
XXXXX (numeric) |
|
|
Date Appointed to Current Rank (EPA) |
Date appointed to current position |
MM/DD/YYYY |
Payroll |
|
Date Entered Tenure Track (EPA) |
Date appointed to tenure track status |
MM/DD/YYYY |
EPAWeb |
|
Date First EPA Appointment (EPA) |
Date of first appointment to a permanent EPA Faculty or Non-Faculty position.
Does not include student appointments. |
MM/DD/YYYY |
EPAWeb |
|
Date Promoted to Assistant Professor (EPA) |
Date promoted to Assistant Professor rank |
MM/DD/YYYY |
EPAWeb |
|
Date Promoted to Associate Professor (EPA) |
Date promoted to Associated Professor rank |
MM/DD/YYYY |
EPAWeb |
|
Date Promoted to Professor (EPA) |
Date promoted to Professor rank |
MM/DD/YYYY |
EPAWeb |
|
Date of Birth |
Birth date |
MM/DD/YYYY |
EPAWeb
– EPA
Payroll
- SPA |
|
Date of Last Personnel Action |
Date of most current employment event |
MM/DD/YYYY |
Payroll |
|
Department of Rank (EPA) |
Department that conferred current rank status |
|
Payroll |
|
DFP Indicator (EPA) |
Indicates
Faculty with base ranks in the School
of Dentistry |
Y
N
Blank |
EPAWeb |
|
Disability Flag (SPA) |
Indication if employee has declared him/herself as a disabled person |
Yes
No
Blank |
Payroll |
|
Duration of Appointment (EPA) |
Employment time period for the current position |
1 Semester
2 Semesters
1 Year
2 Years
3 Years
4 Years
5 Years
Other
To Retirement
Until Further Notice
Blank |
Payroll |
|
Email Address |
Campus email address |
|
Payroll |
|
Emergency Duties Indicator |
Identifies if the employee’s position is deemed necessary during emergencies
impacting business operations |
Y
Blank |
HRIS |
|
Employee Type (EPA) |
Faculty – Non-faculty indicator |
Faculty
Non-Faculty |
Payroll |
|
Entry on Duty Date (SPA) |
First day of employment as an UNC-CH employee |
MM/DD/YYYY |
Payroll |
|
EPA - SPA Indicator |
Indication of employment being subject to State Personnel laws |
EPA (not subject)
SPA (subject) |
Payroll |
|
EPAWeb Employee Status |
EPA employee’s status in the EPAWeb system |
Active
On Leave
Phased
Retirement
Retired
Retired
(Contract) |
EPAWeb |
|
Federal Fiscal Year |
Point in time ending on 09/30/XX |
YYYY |
|
|
First Name |
Legal first name |
|
EPAWeb
– EPA
Payroll - SPA |
|
Fiscal Year (UNC-CH) |
Point in time ending on 06/30/XX |
YYYY |
|
|
FLSA Indicator |
Indication of an employee being covered by the Fair Labor Standards Act
(FLSA), which include law governing payment of overtime wages |
Exempt (not subject to FLSA)
Non-Exempt (subject to FLSA) |
Payroll |
|
FOC Code (SPA) |
The Federal Occupation Category (FOC) associated with the employee’s
position |
Apprentice (0)
Executive (1)
Professional (3)
Clerical (4)
Technical (5)
Skilled (6)
Service (7) |
Payroll |
|
FRS Account |
A six digit number to which revenue/expenses are
assigned |
XXXXXX (numeric) |
|
|
FRS Account/Object |
A six digit number to which revenue/expenses are
assigned & the four digit object code revenue or expense category
identifier |
XXXXXX-XXXX
(numeric) |
|
|
FTE |
Full-Time Equivalent (FTE) is the percent of time employed based on a
40 hour work week |
X.XX (numeric) Example 1.0, .75, .25 |
EPAWeb
– EPA
Payroll
- SPA |
|
Full Name |
Legal full name |
|
EPAWeb
– EPA
Payroll
- SPA |
|
Full - Part Indicator |
Indication of the employee’s contracted work hours - 40 hour week employment
(fulltime) or less than a 40 week employment (part-time) |
Full-time
Part-time |
EPAWeb
– EPA
Payroll
- SPA |
|
Fund Type |
Source
type(s) of employee’s salary
|
Auxiliary
Contracts & Grants
Other
Overhead
State
Trust |
|
|
Funding Contingency Flag (EPA) |
Indication of appointment’s permanency status |
Yes
No |
EPAWeb |
|
Gender |
Sexual category |
Male
Female |
EPAWeb
– EPA
Payroll
- SPA |
|
Grade (SPA) |
The Office of State Personnel (OSP) classification grade associated with
the position |
|
Payroll |
|
Home Address City |
City of residence |
|
Payroll |
|
Home Address County |
County of residence |
|
Payroll |
|
Home Address State |
State of residence |
|
Payroll |
|
Home Address Street |
Number and street name of residence |
|
Payroll |
|
Home Address Zip |
Zip code of residence |
|
Payroll |
|
Home Phone |
Residence telephone number |
|
Payroll |
|
Hours per Week (SPA) |
Number of contracted work hours |
XX (numeric) |
Payroll |
|
I9 Eligibility Date (EPA) |
|
MM/DD/YYYY |
EPAWeb |
|
Joint Appointment (EPA) |
Indication if more than one position is held by the employee |
Yes
No |
Payroll |
|
Joint Department (EPA) |
Identifies the department, center, professional school or any other academic
unit where employee holds a secondary position |
|
Payroll |
|
Last Date on Payroll |
Date of end of employment (last pay through date) |
MM/DD/YYYY |
Payroll |
|
Last Name |
Legal last name |
|
EPAWeb
– EPA
Payroll - SPA |
|
Last Promotion Date |
Date of most recent promotion action |
MM/DD/YYYY |
Payroll |
|
Last Salary Change Action Code |
Type of pay action for most recent employment activity affecting salary |
|
Payroll |
|
Last Salary Change Amount |
Amount of most recent change in employee’s salary |
$$$$$$.$$ |
Payroll |
|
Last Salary Change Date |
Date of most recent salary change |
MM/DD/YYYY |
Payroll |
|
Leave Pay Type (EPA) |
Type of payment of wages associated with employee’s leave status |
Full Pay
No Pay
Partial Pay |
Payroll |
|
Leave Type LOA Off Campus (EPA) |
Type of leave status |
Leave of Absence
Off-Campus Assignment
|
Payroll |
|
Leave Type Professional Personal (EPA) |
Type of leave status |
Dept
Specific
External
Competitive
Family
& Medical
Internal
Competitive
Military
Off Campus
Assignment
Other
Parental
Personal
Professional
Professional/ Educational
Research & Study |
EPAWeb |
|
Legacy - Faculty Title Modifier (EPA) |
Used in conjunction with the Faculty rank title to more accurately reflect
the true title and work performed by the employee’s specific appointment |
Distinguished (1)
Clinical (2)
Research (3)
Adjunct (4)
Other Title (5)
Designation
Distinguished Term (A) |
Payroll |
|
Legacy - Non-Faculty Modifier (EPA) |
Used in conjunction with the Non-Faculty rank title to more accurately
reflect the true title and work performed by specific appointment |
Associate (6)
Assistant (7)
Assistant to (8)
Acting/Interim (9) |
Payroll |
|
Legacy - Rank1 Title (EPA) |
Type of appointment for primary position |
Faculty
Professor (01)
Associate Professor (02)
Assistant Professor (03)
Instructor (04)
Lecturer (05)
Professor of the Practice (06)
Lecturer (07)
Non-Faculty
Chancellor (09)
Provost (10)
Vice Chancellor (11)
Dean (12)
Director (13)
Department Chairman (14)
Librarian (15)
Coach (16)
Research Associate (17)
Research Assistant (18)
Other Student (19)
Graduate Assistant (20)
Teaching Assistant (21)
Research Assistant (22)
Fellow/Trainee (23)
Teaching Fellow (24)
Resident (25)
Other Student (26)
Postdoctoral Trainee (27)
Postdoctoral Research Associate (28) |
Payroll |
|
Legacy - Rank1 Title with Modifier (EPA) |
Combination of the primary rank title and the rank title modifier |
|
Payroll |
|
Legacy - Rank2 Title (EPA) |
Type of appointment for secondary position |
Faculty
Professor (01)
Associate Professor (02)
Assistant Professor (03)
Instructor (04)
Lecturer (05)
Professor of the Practice (06)
Lecturer (07)
Non-Faculty
Chancellor (09)
Provost (10)
Vice Chancellor (11)
Dean (12)
Director (13)
Department Chairman (14)
Librarian (15)
Coach (16)
Research Associate (17)
Research Assistant (18)
Other Student (19)
Graduate Assistant (20)
Teaching Assistant (21)
Research Assistant (22)
Fellow/Trainee (23)
Teaching Fellow (24)
Resident (25)
Other Student (26)
Postdoctoral Trainee (27)
Postdoctoral Research Associate (28) |
Payroll |
|
Legacy - Rank2 Title with Modifier (EPA) |
Combination of the secondary rank title and the rank title modifier |
|
Payroll |
|
Length of Service (SPA) |
Years of employment based on Total State Service Date - TSSD (permanent
employees only) |
XX (numeric) |
Payroll |
|
Length of Service
Range (SPA) |
Years of employment in a specific range based on Total State Service
- TSSD (permanent employees only) |
0-4
5-9
10-14
15-19
20-24
25-29
30-34
35-39
40-44
45 and
above |
Payroll |
|
Middle Initial |
Legal middle name or initial |
|
EPAWeb |
|
Non-Faculty Code (EPA) |
Indicates the type of work performed in a Non-faculty appointment |
Instructional (I)
Not Determined (N)
Research (R)
SAAO - Tier 1 (A)
SAAO - Tier 2 (B) |
EPAWeb |
|
Non-Faculty TSSD (EPA) |
Date of permanent employment as a State of NC employee |
MM/DD/YYYY |
HRIS |
|
Pay Cycle Type |
Time interval for payment of wages |
B - Bi-weekly
M - Monthly
S - Summer School |
Payroll |
|
Payroll Employee Status |
Employee’s status in the Payroll system |
Active
Inactive
New (first time on payroll as active employee)
On-Leave
Term (first time on payroll as inactive) |
Payroll |
|
Performance Rating (SPA) |
Rating from employee’s annual performance appraisal
Available for Calendar and UNC-CH Fiscal years only |
Below
Good
Evaluation
Not Done
Good
Insufficient
Time
LWOP
Status
Outstanding
Very
Good
Warning |
Office of State Personnel |
|
Perm Temp
Indicator |
Indication of employment contract with UNC-CH
EPA
Is temporary if the duration of the appointment is less than twelve
months or if the appointment is coded as visiting |
Permanent
Temporary |
Payroll |
|
PID |
A Nine digit unique Personal Identification number assigned to each employee |
XXXXXXXXX (numeric) |
EPAWeb
– EPA
Payroll
- SPA |
|
Position Number (SPA) |
Unique number assigned to each position |
XXXXX (numeric) |
Payroll |
|
Primary Faculty Rank Code (EPA) |
Rank code of appointment for primary faculty position |
01
02
03
04
05
05
07 |
EPAWeb |
|
Primary Faculty Rank Dept (EPA) |
Department that conferred current primary faculty rank status |
|
EPAWeb |
|
Primary Faculty Rank Description (EPA) |
Type of rank appointment for primary faculty rank position |
Professor (01)
Associate Professor (02)
Assistant Professor (03)
Instructor (04)
Lecturer (05)
Professor of the Practice (06)
Lecturer (07) |
EPAWeb |
|
Primary Faculty Rank Modifier Code (EPA) |
Used in conjunction with the faculty rank description to more accurately
reflect the true title and work performed by the employee’s specific
appointment |
0
1
2
3
4
A |
EPAWeb |
|
Primary Faculty Rank Modifier Code Description (EPA) |
Description for primary faculty rank modifier code |
Not Applicable
(0)
Distinguished
(1)
Clinical (2)
Research (3)
Adjunct (4)
Distinguished Term (A) |
EPAWeb |
|
Primary Faculty Rank Title (EPA) |
Derived from the primary faculty rank description and the faculty rank
modifier description |
|
EPAWeb |
|
Primary Rank Code (EPA) |
Code of appointment for primary position |
Faculty
01
02
03
04
05
06
07
Non-Faculty
09
10
|