| Column Name |
Definition |
| SSN |
Employee Identification Number (9
characters) |
| EMPL_NAME_PREFIX |
Employee Name Prefix (Mr, Ms,
etc.) |
| EMPL_LAST_NAME |
Employee Last Name |
| EMPL_FIRST_NAME |
Employee First Name |
| EMPL_MIDDLE_NAME |
Employee Middle Name |
| EMPL_NAME_SUFFIX |
Employee Name Suffix (Jr, III,
etc.) |
| NAME_LAST_FIRST |
Employee Name (Last, First
format) |
| NAME_FIRST_LAST |
Employee Name (First Last format) |
| PAY_TYPE |
Payroll Type Code (2 characters:
11=Monthly, 14=Academic, 16=Semester, 21=Salaried, 31=Hourly) |
| PAY_TYPE_DESC |
Payroll Type Description (definition
of payroll type code) |
| TRANSACTION_DATE |
Payment (or Adjustment) Date (MM/DD/YYYY
format) |
| TRANSACTION_NUMBER |
Payment (or Adjustment) Reference Number (check
or deposit advice number) |
| TRANSACTION_TYPE |
Transaction Type Code (2
characters: 30=Payment, 35=Adjustment, 45=Time & Effort
Adjustment) |
| TRAN_TYPE_DESC |
Transaction Generation Number (suffix
used to uniquely identify related transactions like checks and associated
adjustments which share the same transaction number) |
| TRAN_GEN_NUMBER |
Transaction Generation Number (suffix
used to uniquely identify related transactions like checks and associated
adjustments which share the same transaction number) |
| CHARGE_CODE |
Unique Sequence Number assigned to each funding
account's contribution to pay (2 characters: 01=1st
account, 02=2nd account, etc.) |
| ACCOUNT |
Account Number funding this contribution to pay
(12 characters) |
| ACCOUNT_OBJECT |
Expenditure Object Code associated with the
payroll (5 characters: 51110=Monthly, 51112=Academic,
etc.) |
| DEDUCTION_CODE |
Code used to identify a type of payroll
deduction |
| DEDUCTION_DESC |
Description of the payroll deduction |
| DEDUCTION_PAY_CLS |
Code used to identify the employer:
1=University, 3=Athletic Assn |
| DED_PAY_CLS_DESC |
Description of employer |
| STAFF_BEN_ACCOUNT |
Account Number paying the staff benefit |
| STAFF_BEN_OBJECT |
Expenditure Object Code associated with the
staff benefit |
| EMPLOYER_CONTRIB |
Amount of employer's contribution to staff
benefit |
| HOME_DEPARTMENT |
Home Base Department Number (3
characters) |
