A

Campus

Campus code and name.

B

Social Security Number

Social Security Number of the employee.

C

Last Name

15 Character Last Name of the employee.

D

Ethnic Origin

The ethnicity origin on the Employment History Database for the employee.  If no code is printed, the data is not on the database.  The employee is assigned an error message of 05.  The employee will still be counted on the IPEDS report B40, but under column 13 or 14 for unknown.

E

Exec W/Acad

Indicates if an executive employee has retreat rights to faculty.

F

Position Number

Position Number of the Employee.

G

Primary Position

X indicates that this was determined to be the employee’s primary position.

H

Annual Salary

Base Pay times the annual factor for the class.  This is the number assigned to the employee's classification on the HR-ISA Pay Scales.  It is used to compute the employee's annual salary.  The formula is Base Pay Rate X Annual Computation Factor.

I

Range Code

Range of the position.

J

Sex

The sex of the employee.

K

Affirmative Action

This is the three character Affirmative Action Code assigned to all CSU class codes.  Only the first character of the affirmative action code is used to group the CSU classes into their primary occupational activity.  Refer to the list of CSU Affirmative Action Codes.  For employees in the Management Personnel Plan (MPP), the Affirmative Action Code assigned to the Job Code is assigned from the MPP Job Code instead of class code..

L

Duration of Appoint.

This is a two character code that indicates the duration of a temporary appointment.  Refer to the online PIMS Manual Data Element Item 415 for additional information.

M

Probation Code

The probation code for the position.

N

Time base

Indicates the time base of the position.

O

Employee Counted

Indicates if the employee was counted.  "Yes" means the employee was included in the IPEDS report.  "No" means the employee was not included.  The particular report that the employee was counted or excluded from is identified in the "Report No" column.  In the case of multiple positions, the position that was counted or the one which caused the employee to be rejected appears on the same line as the "yes" or "no" message.

P

Effective Date

The effective date of the last transaction posted for the position.

Q

Employment Date

The employment date for the employee.

R

Message Number

The reason for rejecting an employee from the IPEDS report is coded in this column.  Refer to the list of Error Messages.

S

Line Number

This is the line number on the summary report B40 which the employee will be counted in.  This identifies the report in which the employee was included or rejected from.  The report numbers are as follows:

Report Section                                                 Line Number

H        Full-time Faculty                                     1-16

I          All Other Full-time Employees                 19-65  

J         Part-time Employees                               68-76

Full time faculty reported in part H are also reported in report G, Tenure of Full Time Faculty.

All full time new hires in reports part H and I are also included in part L, New Hires.

T

Column Number

This is the column number on the summary report B40 based on which ethnic origin and sex the employee will be counted in.